SET foreign_key_checks = 0;

INSERT INTO `evp_discounts` (`id`, `discount_type_id`, `token`, `value`, `name`, `status`) VALUES
  (1, 1, 'KCHMB3', 30.0000, 'Discount for Earlybirds', 'available'),
  (2, 1, '54Z48F', 30.0000, 'Discount for Earlybirds', 'available'),
  (3, 1, '3DY4ZP', 30.0000, 'Discount for Earlybirds', 'available'),
  (4, 1, '85WF5S', 30.0000, 'Discount for Earlybirds', 'available'),
  (5, 1, 'ZXPFBL', 30.0000, 'Discount for Earlybirds', 'available'),
  (6, 1, 'ULWMRB', 30.0000, 'Discount for Earlybirds', 'available'),
  (7, 1, '9AWV9M', 30.0000, 'Discount for Earlybirds', 'available'),
  (8, 1, 'VGK7FK', 30.0000, 'Discount for Earlybirds', 'available'),
  (9, 1, 'XQY7VS', 30.0000, 'Discount for Earlybirds', 'available'),
  (10, 1, '2LAEUU', 30.0000, 'Discount for Earlybirds', 'available'),
  (11, 1, 'N4ZQ2H', 30.0000, 'Discount for Earlybirds', 'available'),
  (12, 1, 'QP3DS2', 30.0000, 'Discount for Earlybirds', 'available'),
  (13, 1, 'UYZWMF', 30.0000, 'Discount for Earlybirds', 'available'),
  (14, 1, 'YPVL8Q', 30.0000, 'Discount for Earlybirds', 'available'),
  (15, 1, 'QP5AVW', 30.0000, 'Discount for Earlybirds', 'available'),
  (16, 1, '7YFK52', 30.0000, 'Discount for Earlybirds', 'available'),
  (17, 1, 'MXQCC4', 30.0000, 'Discount for Earlybirds', 'available'),
  (18, 1, 'EBEGEU', 30.0000, 'Discount for Earlybirds', 'available'),
  (19, 1, '32VNM4', 30.0000, 'Discount for Earlybirds', 'available'),
  (20, 1, 'P6CZ6F', 30.0000, 'Discount for Earlybirds', 'available'),
  (21, 1, 'Z5X233', 30.0000, 'Discount for Earlybirds', 'available'),
  (22, 1, 'AQP3TW', 30.0000, 'Discount for Earlybirds', 'available'),
  (23, 1, 'MGWUTR', 30.0000, 'Discount for Earlybirds', 'available'),
  (24, 1, '6B6L36', 30.0000, 'Discount for Earlybirds', 'available'),
  (25, 1, 'S4DXQ7', 30.0000, 'Discount for Earlybirds', 'available'),
  (26, 1, 'WZYGSU', 30.0000, 'Discount for Earlybirds', 'available'),
  (27, 1, 'WP7QFH', 30.0000, 'Discount for Earlybirds', 'available'),
  (28, 1, 'N7XHHY', 30.0000, 'Discount for Earlybirds', 'available'),
  (29, 1, 'D2M6VR', 30.0000, 'Discount for Earlybirds', 'available'),
  (30, 1, 'EBHY2U', 30.0000, 'Discount for Earlybirds', 'available'),
  (31, 2, 'REUSABLE', 50.0000, 'Reusable Code', 'available'),
  (32, 3, '3TLU8C', 5.0000, 'Marketing Compaign Discount', 'available'),
  (33, 3, 'XAFUXB', 5.0000, 'Marketing Compaign Discount', 'available'),
  (34, 3, 'UP86TX', 5.0000, 'Marketing Compaign Discount', 'available'),
  (35, 3, '3C5ZMQ', 5.0000, 'Marketing Compaign Discount', 'available'),
  (36, 3, 'CJAS8R', 5.0000, 'Marketing Compaign Discount', 'available'),
  (37, 3, 'SKQUR7', 5.0000, 'Marketing Compaign Discount', 'available'),
  (38, 3, 'G3Z4XH', 5.0000, 'Marketing Compaign Discount', 'available'),
  (39, 3, 'CKMPVM', 5.0000, 'Marketing Compaign Discount', 'available'),
  (40, 3, 'XS7RBQ', 5.0000, 'Marketing Compaign Discount', 'available'),
  (41, 3, 'KJZGRB', 5.0000, 'Marketing Compaign Discount', 'available'),
  (42, 3, '8RJ7TX', 5.0000, 'Marketing Compaign Discount', 'available'),
  (43, 3, 'MNUPCX', 5.0000, 'Marketing Compaign Discount', 'available'),
  (44, 3, 'TUZGWB', 5.0000, 'Marketing Compaign Discount', 'available'),
  (45, 3, 'NMP3BU', 5.0000, 'Marketing Compaign Discount', 'available'),
  (46, 3, '5ATGAD', 5.0000, 'Marketing Compaign Discount', 'available'),
  (47, 3, 'JNLNP4', 5.0000, 'Marketing Compaign Discount', 'available'),
  (48, 3, 'HJCDG6', 5.0000, 'Marketing Compaign Discount', 'available'),
  (49, 3, 'RX46VY', 5.0000, 'Marketing Compaign Discount', 'available'),
  (50, 3, 'TTU29E', 5.0000, 'Marketing Compaign Discount', 'available'),
  (51, 3, '56G2ZP', 5.0000, 'Marketing Compaign Discount', 'available'),
  (52, 4, 'PBXHTM', 20.0000, 'Special Fixed Price Discount', 'available'),
  (53, 4, 'TN5E8R', 20.0000, 'Special Fixed Price Discount', 'available'),
  (54, 4, '2FZLHV', 20.0000, 'Special Fixed Price Discount', 'available'),
  (55, 4, 'AGWEDY', 20.0000, 'Special Fixed Price Discount', 'available'),
  (56, 4, 'GBEA3P', 20.0000, 'Special Fixed Price Discount', 'available'),
  (57, 4, 'X5ABBZ', 20.0000, 'Special Fixed Price Discount', 'available'),
  (58, 4, 'LX7ALH', 20.0000, 'Special Fixed Price Discount', 'available'),
  (59, 4, 'SN2JB3', 20.0000, 'Special Fixed Price Discount', 'available'),
  (60, 4, 'CCNHQB', 20.0000, 'Special Fixed Price Discount', 'available'),
  (61, 4, '5YMY37', 20.0000, 'Special Fixed Price Discount', 'available');

INSERT INTO `evp_discount_types` (`id`, `tickets_count`, `name`, `description`, `date_created`, `date_starts`, `date_ends`, `status`, `strategy`, `type`, `scope`, `multiple`) VALUES
  (1, 30, 'Discount for Earlybirds', 'First 30 Tickets are 30% cheaper', '2014-10-28 13:12:37', '2013-10-28 00:00:00', '2014-12-28 00:00:00', 1, 'discount.strategy.custom_discount', 'discount.type.percentage', 'discount.scope.event', 0),
  (2, 500, 'Reusable Code', 'This Discount code can be used more than once. It gives 50% Discount', '2014-10-28 13:19:16', '2013-10-28 00:00:00', '2015-10-28 00:00:00', 1, 'discount.strategy.custom_discount', 'discount.type.percentage', 'discount.scope.event', 1),
  (3, 20, 'Marketing Compaign Discount', 'This discount is for all clients that use a voucher from our marketing campaign. It gives fixed 5 EUR Discount', '2014-10-28 13:23:34', '2013-10-28 00:00:00', '2015-10-28 00:00:00', 1, 'discount.strategy.custom_discount', 'discount.type.fixed_amount', 'discount.scope.event', 0),
  (4, 10, 'Special Fixed Price Discount', 'This code gives a fixed price discount. Fixed Price is set to 20EUR.', '2014-10-28 13:26:47', '2013-10-28 00:00:00', '2015-10-28 00:00:00', 1, 'discount.strategy.custom_discount', 'discount.type.percentage', 'discount.scope.event', 0);

INSERT INTO `evp_discount_type_ticket_type` (`discounttype_id`, `tickettype_id`) VALUES
  (1, 1),
  (1, 2),
  (1, 3),
  (2, 1),
  (2, 2),
  (2, 3),
  (3, 1),
  (3, 2),
  (3, 3),
  (4, 1),
  (4, 2),
  (4, 3);

INSERT INTO `evp_events` (`id`, `event_type_id`, `area_id`, `name`, `description`, `currency`, `date_created`, `date_starts`, `date_ends`, `enabled`, `default_locale`, `date_on_sale`, `country_code`, `token`, `global_entity_template`, `breadcrumbs_enabled`) VALUES
  (1, 1, NULL, 'Vilnius Innovation Conference 2015', '<p>The Conference Board of Vilnius has established the Centre for Business Innovation (CBI) as a five-year initiative to help bring about major improvements in firm-level business innovation in Vilnius, Lithuania.</p>\r\n\r\n<p>The 2015 Business Innovation Summit explored the real-life challenges and opportunities for innovation within firms and tangible solutions. Industry professionals and expert speakers took part in delegate-expert sharing sessions, giving participants the insights and tools to increase the speed at which their organizations can generate new ideas, products, services, and processes.</p>', 'LTL', '2014-10-28 12:39:38', '2014-11-28 10:00:00', '2014-11-28 22:00:00', 1, 'lt', '2014-10-28 12:38:00', 'lt', '1283f86fd43d1a0204c242c986786a46544f8e8a0e33b5!53050725', 0, 1);

INSERT INTO `evp_event_types` (`id`, `name`, `max_tickets_per_user`, `status`, `invoicing_enabled`, `pay_by_invoice_enabled`) VALUES
  (1, 'My Events', 10, '1', 0, 0);

INSERT INTO `evp_event_type_field_schemas` (`id`, `field_schema_id`, `event_type_id`, `is_required`, `is_required_for_all`, `is_made_by_admin`) VALUES
  (1, 1, 1, 1, 0, 0),
  (2, 2, 1, 1, 0, 1),
  (3, 3, 1, 0, 0, 1);

INSERT INTO `evp_event_type_steps` (`id`, `event_type_id`, `form_step_id`, `step_order`) VALUES
  (1, 1, 1, 1),
  (2, 1, 2, 2),
  (4, 1, 3, 4),
  (3, 1, 4, 3);

INSERT INTO `evp_field_records` (`id`, `event_id`, `field_schema_id`, `ticket_id`, `user_id`, `value`) VALUES
  (1, 1, 1, NULL, 24, 'p.simkus@paysera.lt'),
  (2, 1, 2, NULL, 24, 'Paulius Simkus'),
  (3, 1, 3, NULL, 24, '22'),
  (4, 1, 1, NULL, 25, 'p.simkus@paysera.lt'),
  (5, 1, 2, NULL, 25, 'Paulius Simkus'),
  (6, 1, 3, NULL, 25, '23'),
  (7, 1, 1, NULL, 26, 'p.simkus@paysera.lt'),
  (8, 1, 2, NULL, 26, 'Paulius Simkus'),
  (9, 1, 3, NULL, 26, '23'),
  (10, 1, 1, NULL, 27, 'p.simkus@paysera.lt'),
  (11, 1, 2, NULL, 27, 'Paulius Simkus'),
  (12, 1, 3, NULL, 27, '23'),
  (13, 1, 1, NULL, 28, 'p.simkus@paysera.lt'),
  (14, 1, 2, NULL, 28, 'Paulius Simkus'),
  (15, 1, 3, NULL, 28, '23'),
  (16, 1, 1, NULL, 29, 'simkus9@gmail.com'),
  (17, 1, 2, NULL, 29, 'Paulius Simkus'),
  (18, 1, 3, NULL, 29, '23'),
  (19, 1, 1, NULL, 30, 'simkus9@gmail.com'),
  (20, 1, 2, NULL, 30, 'Paulius Simkus'),
  (21, 1, 3, NULL, 30, '23'),
  (22, 1, 1, NULL, 31, 'simkus9@gmail.com'),
  (23, 1, 2, NULL, 31, 'Paulius Simkus'),
  (24, 1, 3, NULL, 31, '23'),
  (25, 1, 1, NULL, 33, 'simkus9@gmail.com'),
  (26, 1, 2, NULL, 33, 'Paulius Simkus'),
  (27, 1, 3, NULL, 33, '23'),
  (28, 1, 1, NULL, 34, 'simkus9@gmail.com'),
  (29, 1, 2, NULL, 34, 'Paulius Simkus'),
  (30, 1, 3, NULL, 34, '23'),
  (31, 1, 1, NULL, 37, 'simkus9@gmail.com'),
  (32, 1, 2, NULL, 37, 'Paulius Simkus'),
  (33, 1, 3, NULL, 37, '23'),
  (34, 1, 1, NULL, 38, 'simkus9@gmail.com'),
  (35, 1, 2, NULL, 38, 'Paulius Simkus'),
  (36, 1, 3, NULL, 38, '23'),
  (37, 1, 1, NULL, 39, 'simkus9@gmail.com'),
  (38, 1, 2, NULL, 39, 'Paulius Simkus'),
  (39, 1, 3, NULL, 39, '23'),
  (40, 1, 1, NULL, 40, 'simkus9@gmail.com'),
  (41, 1, 2, NULL, 40, 'Paulius Simkus'),
  (42, 1, 3, NULL, 40, '23'),
  (43, 1, 1, NULL, 41, 'simkus9@gmail.com'),
  (44, 1, 2, NULL, 41, 'Paulius Simkus'),
  (45, 1, 3, NULL, 41, '23'),
  (46, 1, 1, NULL, 42, 'simkus9@gmail.com'),
  (47, 1, 2, NULL, 42, 'Paulius Simkus'),
  (48, 1, 3, NULL, 42, '23'),
  (49, 1, 1, NULL, 43, 'simkus9@gmail.com'),
  (50, 1, 2, NULL, 43, 'Paulius Simkus'),
  (51, 1, 3, NULL, 43, '23'),
  (52, 1, 1, NULL, 44, 'simkus9@gmail.com'),
  (53, 1, 2, NULL, 44, 'Paulius Simkus'),
  (54, 1, 3, NULL, 44, '23'),
  (55, 1, 1, NULL, 45, 'simkus9@gmail.com'),
  (56, 1, 2, NULL, 45, 'Paulius Simkus'),
  (57, 1, 3, NULL, 45, '23'),
  (58, 1, 1, NULL, 46, 'simkus9@gmail.com'),
  (59, 1, 2, NULL, 46, 'Paulius Simkus'),
  (60, 1, 3, NULL, 46, '23'),
  (61, 1, 1, NULL, 47, 'simkus9@gmail.com'),
  (62, 1, 2, NULL, 47, 'Paulius Simkus'),
  (63, 1, 3, NULL, 47, '23'),
  (64, 1, 1, NULL, 48, 'simkus9@gmail.com'),
  (65, 1, 2, NULL, 48, 'Paulius Simkus'),
  (66, 1, 3, NULL, 48, '23'),
  (67, 1, 1, NULL, 49, 'simkus9@gmail.com'),
  (68, 1, 2, NULL, 49, 'Paulius Simkus'),
  (69, 1, 3, NULL, 49, '23'),
  (70, 1, 1, NULL, 50, 'simkus9@gmail.com'),
  (71, 1, 2, NULL, 50, 'Paulius Simkus'),
  (72, 1, 3, NULL, 50, '23'),
  (73, 1, 1, NULL, 51, 'simkus9@gmail.com'),
  (74, 1, 2, NULL, 51, 'Paulius Simkus'),
  (75, 1, 3, NULL, 51, '23'),
  (76, 1, 1, NULL, 52, 'simkus9@gmail.com'),
  (77, 1, 2, NULL, 52, 'Paulius Simkus'),
  (78, 1, 3, NULL, 52, '23'),
  (79, 1, 1, NULL, 53, 'simkus9@gmail.com'),
  (80, 1, 2, NULL, 53, 'Paulius Simkus'),
  (81, 1, 3, NULL, 53, '23'),
  (82, 1, 1, NULL, 56, 'simkus9@gmail.com'),
  (83, 1, 2, NULL, 56, 'Paulius Simkus'),
  (84, 1, 3, NULL, 56, '23');

INSERT INTO `evp_field_schemas` (`id`, `name`, `type`, `validator`, `field_order`, `label`) VALUES
  (1, 'email', 'email', 'Symfony\\Component\\Validator\\Constraints\\Email', 1, 'label.email'),
  (2, 'FirstandLastname', 'text', 'Symfony\\Component\\Validator\\Constraints\\NotBlank', 2, 'Firstname and Lastname'),
  (3, 'EnterAge', 'text', 'Symfony\\Component\\Validator\\Constraints\\NotBlank', 3, 'Enter your age');

INSERT INTO `evp_orders` (`id`, `user_id`, `event_id`, `invoice_id`, `date_created`, `date_finished`, `status`, `date_expires`, `tickets_count`, `price`, `payment_type`, `invoice_required`, `token`, `test_mode`) VALUES
  (1, 1, 1, NULL, '2014-10-28 13:34:31', NULL, 'in_progress', '2014-10-28 13:39:31', NULL, NULL, NULL, 0, 'b47461007819afb5f2ba4b3bf9a4efce544f9b67645a29!98575362', 0),
  (2, 2, 1, NULL, '2014-10-28 13:34:48', NULL, 'in_progress', '2014-10-28 13:39:48', NULL, NULL, NULL, 0, 'db2d0bd6967bab521a6d606d2904a7f1544f9b784a8204!42058716', 0),
  (3, 3, 1, NULL, '2014-10-28 13:36:29', NULL, 'in_progress', '2014-10-28 13:41:29', NULL, NULL, NULL, 0, 'd986f660f90ebd16a9ad212c78fa1710544f9bdd2ce491!78859390', 0),
  (4, 4, 1, NULL, '2014-10-28 13:36:38', NULL, 'in_progress', '2014-10-28 13:41:38', NULL, NULL, NULL, 0, '90c58052e35376586e63cf37cd8e9fd4544f9be69cfdc4!51495012', 0),
  (5, 5, 1, NULL, '2014-10-28 13:37:42', NULL, 'in_progress', '2014-10-28 13:42:42', NULL, NULL, NULL, 0, 'b3b9f9529cb4cabb2783f2cd1b85130e544f9c2630c835!36552620', 0),
  (6, 6, 1, NULL, '2014-10-28 13:37:59', NULL, 'in_progress', '2014-10-28 13:42:59', NULL, NULL, NULL, 0, 'b54e60c1878e1aa8c52d1f6178d39a60544f9c373568b3!79484675', 0),
  (7, 7, 1, NULL, '2014-10-28 13:38:21', NULL, 'in_progress', '2014-10-28 13:43:21', NULL, NULL, NULL, 0, '3ed251f787e5e4f1ad7c36515236301e544f9c4d0d84a4!21893785', 0),
  (8, 8, 1, NULL, '2014-10-28 13:38:37', NULL, 'in_progress', '2014-10-28 13:43:37', NULL, NULL, NULL, 0, '98186567df6b8403fc56cf172b379790544f9c5deb78e4!27324616', 0),
  (9, 9, 1, NULL, '2014-10-28 13:40:45', NULL, 'in_progress', '2014-10-28 13:45:45', NULL, NULL, NULL, 0, 'c1341b618018a054161dcb7b7f5cef69544f9cdd6a79d2!69657307', 0),
  (10, 10, 1, NULL, '2014-10-28 13:41:02', NULL, 'in_progress', '2014-10-28 13:46:02', NULL, NULL, NULL, 0, 'a1e30eea9b3fe7c849affefec19e6a49544f9cee35df62!48850371', 0),
  (11, 11, 1, NULL, '2014-10-28 13:45:34', NULL, 'in_progress', '2014-10-28 13:50:34', NULL, NULL, NULL, 0, '4f0214a8ff58a13b3e6d27425ec984f0544f9dfe92c1f3!20179178', 0),
  (12, 12, 1, NULL, '2014-10-28 14:36:43', NULL, 'in_progress', '2014-10-28 14:41:43', NULL, NULL, NULL, 0, '586588dfdf9fab52cca8880059636fb4544fa9fb2dd085!47216591', 0),
  (13, 13, 1, NULL, '2014-10-28 14:37:15', NULL, 'in_progress', '2014-10-28 14:42:15', NULL, NULL, NULL, 0, 'bde72b2125e56a6c900e458e1b3ec35e544faa1b2f7426!28872518', 0),
  (14, 14, 1, NULL, '2014-10-28 14:37:56', NULL, 'in_progress', '2014-10-28 14:42:56', NULL, NULL, NULL, 0, 'd8402f91e4295a01639b980918011950544faa44c5a619!72404318', 0),
  (15, 15, 1, NULL, '2014-10-28 14:40:33', NULL, 'in_progress', '2014-10-28 14:45:33', NULL, NULL, NULL, 0, '1bff8d68b29b04c336e41954bb5d2105544faae1885864!26966602', 0),
  (16, 16, 1, NULL, '2014-10-28 14:41:01', NULL, 'in_progress', '2014-10-28 14:46:01', NULL, NULL, NULL, 0, '3f46b22263e7f775c51480d1fa9c9320544faafdeed672!29819462', 0),
  (17, 17, 1, NULL, '2014-10-29 05:58:04', NULL, 'in_progress', '2014-10-29 06:03:04', NULL, NULL, NULL, 0, '102bef8fef9f1e78954ed1b9d6a2de85545081ecc1a024!47693079', 0),
  (18, 18, 1, NULL, '2014-10-29 07:02:18', NULL, 'in_progress', '2014-10-29 07:07:18', NULL, NULL, NULL, 0, '7abb0d5011caef680085f5409221f93d545090fa5042b2!90642711', 0),
  (19, 19, 1, NULL, '2014-10-29 07:24:38', NULL, 'in_progress', '2014-10-29 07:29:38', NULL, NULL, NULL, 0, '45ae2a09345fa06132959746b5dbf19554509636d21087!91995193', 0),
  (20, 20, 1, NULL, '2014-10-29 07:25:20', NULL, 'in_progress', '2014-10-29 07:30:20', NULL, NULL, NULL, 0, '6a362d127160ec8f20ed7a8e56fbb12754509660eaf532!94974818', 0),
  (21, 21, 1, NULL, '2014-10-29 07:30:30', NULL, 'in_progress', '2014-10-29 07:35:30', NULL, NULL, NULL, 0, 'd4b72f6ac48d882b2932cd61d496a83d54509796405c68!17513415', 0),
  (22, 22, 1, NULL, '2014-10-29 08:50:34', NULL, 'in_progress', '2014-10-29 08:55:34', NULL, NULL, NULL, 0, '6ec3c733c7ad971022265c5be5cc81a05450aa5a196c30!10816943', 0),
  (23, 23, 1, NULL, '2014-10-29 09:11:25', NULL, 'in_progress', '2014-10-29 09:16:25', NULL, NULL, NULL, 0, 'be7e5ff9a9918834064a047fd5ba3ddf5450af3d0e0466!58830795', 0),
  (24, 24, 1, NULL, '2014-10-29 11:00:11', NULL, 'in_progress', '2014-10-29 11:05:59', 1, 0.0000, 'wallet', 0, 'eff0bca9d03fa13d925b966f8cbcf46a5450c8bbd9c6e6!68346168', 0),
  (25, 25, 1, NULL, '2014-10-29 11:07:39', NULL, 'in_progress', '2014-10-29 11:12:59', 1, 0.0000, 'wallet', 0, '3920d2f2b60d9efc7b03b2c0bd5131815450ca7b92e1d0!08261709', 0),
  (26, 26, 1, NULL, '2014-10-29 11:08:48', NULL, 'in_progress', '2014-10-29 11:14:15', 1, 0.0000, 'wallet', 0, 'ecc96b6da23ccd84c0e32501a476ddc55450cac06999b0!28221816', 0),
  (27, 27, 1, NULL, '2014-10-29 11:09:54', NULL, 'in_progress', '2014-10-29 11:15:17', 1, 29.9950, 'wallet', 0, 'cee21793394c547722ebad7f8a12bffd5450cb02de48d5!00364951', 0),
  (28, 28, 1, NULL, '2014-10-31 07:20:13', '2014-10-31 07:20:39', 'done', '2014-10-31 07:25:25', 1, 59.9900, 'wallet', 0, '63c274ca299c55c22fedbb71044a43af5453382d614163!83343908', 1),
  (29, 29, 1, NULL, '2014-10-31 07:22:48', NULL, 'in_progress', '2014-10-31 07:28:13', 1, 29.9950, 'wallet', 0, 'fe13bd50b8cc0a70ab1138211ed5ec78545338c8670939!14588355', 0),
  (30, 30, 1, NULL, '2014-10-31 07:23:46', NULL, 'in_progress', '2014-10-31 07:29:02', 1, 29.9950, 'wallet', 0, '1b20b86d7938fcc4d9aa92d991a6cace54533902ef6433!74997797', 0),
  (31, 31, 1, NULL, '2014-10-31 07:25:06', '2014-10-31 07:25:29', 'done', '2014-10-31 07:30:17', 1, 59.9900, 'wallet', 0, '26f63519270ee99df4b65739fae45c88545339522c5896!85508609', 1),
  (32, 32, 1, NULL, '2014-10-31 07:26:27', NULL, 'in_progress', '2014-10-31 07:31:29', NULL, NULL, NULL, 0, '53f8d9a930591ef509e1ed774e94a81c545339a3444da2!86491657', 0),
  (33, 33, 1, NULL, '2014-10-31 07:26:49', NULL, 'in_progress', '2014-10-31 07:32:10', 1, 29.9950, 'wallet', 0, '656ce44eb870d28baa4b0cdbf615ea86545339b97fecb7!86223545', 0),
  (34, 34, 1, NULL, '2014-10-31 07:29:12', NULL, 'in_progress', '2014-10-31 07:41:31', 1, 29.9950, 'wallet', 0, 'd642d530c9ddffa2ede0abdd3cb8c31554533a487cd4f7!08910942', 0),
  (35, 35, 1, NULL, '2014-10-31 07:37:02', NULL, 'in_progress', '2014-10-31 07:42:05', NULL, NULL, NULL, 0, 'bc595cfe582bad5cc063f952c425dfca54533c1e72cd78!71966048', 0),
  (36, 36, 1, NULL, '2014-10-31 07:38:41', '2014-10-31 07:38:41', 'done', '2014-10-31 07:43:41', 1, 59.9900, 'generated_manually', 0, '7754f62834c3aea2c12c5f0f92abe85454533c811374a1!09514288', 0),
  (37, 37, 1, NULL, '2014-10-31 07:49:42', NULL, 'in_progress', '2014-10-31 07:54:56', 1, 29.9950, 'wallet', 0, '8f9b0b058c331a3f1312a9184006342854533f1698ff70!15450853', 0),
  (38, 38, 1, NULL, '2014-11-11 07:40:56', '2014-11-11 07:41:30', 'done', '2014-11-11 07:46:15', 1, 59.9900, 'wallet', 0, '8a9b6b8fdb594d48155e3890e0e7c0035461bd88794a48!55805645', 1),
  (39, 39, 1, NULL, '2014-11-11 07:46:05', '2014-11-11 07:46:35', 'done', '2014-11-11 07:51:19', 1, 30.0000, 'wallet', 0, '929b5d32a9687d7401799c4d91f2c7f75461bebd4b75a4!79782733', 1),
  (40, 40, 1, NULL, '2014-11-11 07:47:23', NULL, 'in_progress', '2014-11-11 07:52:34', 1, 0.0000, NULL, 0, '9f328375caaf04a67620c634a045540a5461bf0b06c3f9!84387345', 0),
  (41, 41, 1, NULL, '2014-11-11 07:53:29', '2014-11-11 07:53:57', 'done', '2014-11-11 07:58:41', 1, 30.0000, 'wallet', 0, '66cef628f9b3bdd39db71d2afb932bbc5461c079aa73a6!74080767', 1),
  (42, 42, 1, NULL, '2014-11-11 08:06:29', '2014-11-11 08:06:53', 'done', '2014-11-11 08:11:39', 1, 95.0000, 'wallet', 0, 'b0fef68410f7d316239da72200eb7f785461c3853a29b2!37510325', 1),
  (43, 43, 1, NULL, '2014-11-11 08:08:52', '2014-11-11 08:09:14', 'done', '2014-11-11 08:14:01', 1, 59.9900, 'wallet', 0, '221cfdab8e092bf90ecaf16a5ad022a75461c41479f547!17822064', 1),
  (44, 44, 1, NULL, '2014-11-11 08:10:02', '2014-11-11 08:10:23', 'done', '2014-11-11 08:15:10', 1, 59.9900, 'wallet', 0, 'e8025ea83ccc1ab21cda54ef2cd7a2315461c45a2773e4!71557234', 1),
  (45, 45, 1, NULL, '2014-11-11 08:25:37', '2014-11-11 08:26:03', 'done', '2014-11-11 08:30:48', 1, 59.9900, 'wallet', 0, '4d0a7c9cb62f82cc89b6a6a8acc1abbe5461c801a9a770!31530311', 1),
  (46, 46, 1, NULL, '2014-11-11 08:36:45', '2014-11-11 08:37:10', 'done', '2014-11-11 08:41:56', 1, 59.9900, 'wallet', 0, 'f5dcdf4ebb59490ca1b9089be3627a355461ca9d8d3f25!97125571', 1),
  (47, 47, 1, NULL, '2014-11-11 08:50:01', NULL, 'in_progress', '2014-11-11 08:55:11', 1, 59.9900, NULL, 0, 'eb4a22b63b944f89dc478eb3b5a1e4875461cdb97ce222!17540610', 0),
  (48, 48, 1, NULL, '2014-11-11 08:50:38', '2014-11-11 08:51:03', 'done', '2014-11-11 08:55:49', 1, 59.9900, 'wallet', 0, 'fd2299371d40e57c30655e51ede5e5d25461cdde641206!03851799', 1),
  (49, 49, 1, NULL, '2014-11-11 09:16:56', '2014-11-11 09:17:18', 'done', '2014-11-11 09:22:04', 1, 59.9900, 'wallet', 0, 'fd56a5718a34f089f3eec4af552041185461d408d6c9e8!72676408', 1),
  (50, 50, 1, NULL, '2014-11-11 09:19:12', '2014-11-11 09:20:03', 'done', '2014-11-11 09:24:23', 1, 59.9900, 'wallet', 0, '2b9c7a2d9cc7052f9fc5555df0167a5a5461d490ad2058!49576112', 1),
  (51, 51, 1, NULL, '2014-11-11 12:11:21', NULL, 'in_progress', '2014-11-11 12:16:29', 1, 59.9900, NULL, 0, 'f73c425970c943d4586fd645053953845461fce916d821!28675955', 0),
  (52, 52, 1, NULL, '2014-11-12 07:20:26', '2014-11-12 07:20:52', 'done', '2014-11-12 07:25:37', 1, 59.9900, 'wallet', 0, '6876be2dda3a776b23e92fcb7a23561154630a3a9f1c72!33455409', 1),
  (53, 53, 1, NULL, '2014-11-12 07:27:19', '2014-11-12 07:27:47', 'done', '2014-11-12 07:32:32', 1, 59.9900, 'wallet', 0, 'f43954fc1beed414a58b478c3065acb654630bd710ee78!79821587', 1),
  (54, 54, 1, NULL, '2014-11-12 08:43:11', NULL, 'in_progress', '2014-11-12 08:48:18', NULL, NULL, NULL, 0, '6d1d83355aa7ffc8829ede17abf7a92454631d9f3354a9!03407941', 0),
  (55, 55, 1, NULL, '2014-11-12 08:57:25', NULL, 'in_progress', '2014-11-12 09:02:25', NULL, NULL, NULL, 0, '9904a28370e6992bde09e0ccf3420381546320f55cd777!88257884', 0),
  (56, 56, 1, NULL, '2014-11-12 09:05:15', '2014-11-12 09:05:37', 'done', '2014-11-12 09:10:23', 1, 59.9900, 'wallet', 0, 'e6a3c6dc29a1b026d797bf7a7721d8ac546322cb12e227!88759733', 1);

INSERT INTO `evp_order_details` (`id`, `ticket_type_id`, `order_id`, `event_id`, `user_id`, `tickets_count`) VALUES
  (1, 3, 24, 1, 24, 1),
  (2, 1, 25, 1, 25, 0),
  (3, 3, 25, 1, 25, 1),
  (4, 3, 26, 1, 26, 1),
  (5, 1, 27, 1, 27, 1),
  (6, 1, 28, 1, 28, 1),
  (7, 1, 29, 1, 29, 1),
  (8, 1, 30, 1, 30, 1),
  (9, 1, 31, 1, 31, 1),
  (10, 1, 32, 1, 32, 1),
  (11, 1, 33, 1, 33, 1),
  (12, 1, 34, 1, 34, 1),
  (13, 1, 35, 1, 35, 1),
  (14, 1, 36, 1, 36, 1),
  (15, 1, 37, 1, 37, 1),
  (16, 1, 38, 1, 38, 1),
  (17, 1, 39, 1, 39, 1),
  (18, 3, 40, 1, 40, 1),
  (19, 1, 41, 1, 41, 1),
  (20, 2, 42, 1, 42, 1),
  (21, 1, 43, 1, 43, 1),
  (22, 1, 44, 1, 44, 1),
  (23, 1, 45, 1, 45, 1),
  (24, 1, 46, 1, 46, 1),
  (25, 1, 47, 1, 47, 1),
  (26, 1, 48, 1, 48, 1),
  (27, 1, 49, 1, 49, 1),
  (28, 1, 50, 1, 50, 1),
  (29, 1, 51, 1, 51, 1),
  (30, 1, 52, 1, 52, 1),
  (31, 1, 53, 1, 53, 1),
  (32, 1, 54, 1, 54, 1),
  (33, 1, 56, 1, 56, 1);

INSERT INTO `evp_payment_callback` (`id`, `order_id`, `handlerName`, `parsedRequestData`, `rawRequestData`, `error_message`) VALUES
  (1, 28, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"p.simkus@paysera.lt","orderid":"28","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"Order No: 28 at http:\\/\\/54.84.122.238 project. (Seller: Paulius \\u0160imkus)","_client_language":"eng","status":"1","requestid":"66385395","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1wLnNpbWt1cyU0MHBheXNlcmEubHQmb3JkZXJpZD0yOCZhbW91bnQ9NTk5OSZjdXJyZW5jeT1MVEwmY291bnRyeT1MVCZwYXltZW50PXdhbGxldCZ0ZXN0PTEmdmVyc2lvbj0xLjYmcHJvamVjdGlkPTU1MTgyJnR5cGU9RU1BJmxhbmc9JnBheXRleHQ9T3JkZXIrTm8lM0ErMjgrYXQraHR0cCUzQSUyRiUyRjU0Ljg0LjEyMi4yMzgrcHJvamVjdC4rJTI4U2VsbGVyJTNBK1BhdWxpdXMrJUM1JUEwaW1rdXMlMjkmX2NsaWVudF9sYW5ndWFnZT1lbmcmc3RhdHVzPTEmcmVxdWVzdGlkPTY2Mzg1Mzk1Jm5hbWU9VUFCJnN1cmVuYW1lPU1vayVDNCU5N2ppbWFpLmx0JnBheWFtb3VudD01OTk5JnBheWN1cnJlbmN5PUxUTA==","ss1":"ccda23f6ff41b2398383b33c057a6550","ss2":"a_n_
sAewoftxkGRLADoLov_eMi0zFOW2oGpDNh49yoN3dECe-AqhOlGuKxzQFkCo76V6seg0F4fvNGLj97MgIr98df5rSfwIHAJSHWdAXAU-662onVe-FCnV-_rZZ4l1MgVUEqaW4X2aLllfGCjsVuasP6TgLaW0DS1uc7-7ZDU="}', NULL),
  (2, 31, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"31","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"Order No: 31 at http:\\/\\/54.84.122.238 project. (Seller: Paulius \\u0160imkus)","_client_language":"eng","status":"1","requestid":"66385554","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9MzEmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PU9yZGVyK05vJTNBKzMxK2F0K2h0dHAlM0ElMkYlMkY1NC44NC4xMjIuMjM4K3Byb2plY3QuKyUyOFNlbGxlciUzQStQYXVsaXVzKyVDNSVBMGlta3VzJTI5Jl9jbGllbnRfbGFuZ3VhZ2U9ZW5nJnN0YXR1cz0xJnJlcXVlc3RpZD02NjM4NTU1NCZuYW1lPVVBQiZzdXJlbmFtZT1Nb2slQzQlOTdqaW1haS5sdCZwYXlhbW91bnQ9NTk5OSZwYXljdXJyZW5jeT1MVEw=","ss1":"7034ff2e76775672865ec0d412a0d81a","ss2":"
LVy8BP3OHjPzgstivNsw4IEmpMNOQVbJaSG-4XN1O2RGve3Oh3minGJ2OTfPfLlkbi98z1cEEU1C4ZyaNwNbrQuoq63JhJzIncRf4tpeuyVOaUOUvUiPsmmFiHTD_5TkzThjRr8cKQWXmkQCXM1c-V8LH5heEexuoUWlUIvy6PM="}', NULL),
  (3, 38, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"38","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"31530","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 38 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Dmitrijus Glezeris)","_client_language":"lit","status":"1","requestid":"66980445","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9MzgmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD0zMTUzMCZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzM4K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErRG1pdHJpanVzK0dsZXplcmlzJTI5Jl9jbGllbnRfbGFuZ3VhZ2U9bGl0JnN0YXR1cz0xJnJlcXVlc3RpZD02Njk4MDQ0NSZuYW1lPVVBQiZzdXJlbmFtZT1Nb2slQzQlOTdqaW1haS5sdCZwYXlhbW91bnQ9NTk5OSZwYXljdXJyZW5jeT1MVEw=","ss1":"
93e41aa0e814be6731cd61f0a69512ca","ss2":"UqMK_pQDIQJoMK1Q4XsSKS3zTfRX1ssmTsKewdr4V7MZ0H-JCEZBC9Q16t82htBYkOTohD90wTc3sj-BIE7xquI4gUytSumO22MoZDiTG5zv07SzgSKJVtEtMX5GyxkH507bmjU1A0g9UPjGtJrW20mL4Ggh0bdQo6pd2NQh2xs="}', NULL),
  (4, 39, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"39","amount":"3000","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 39 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66980742","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"3000","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9MzkmYW1vdW50PTMwMDAmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzM5K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODA3NDImbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTMwMDAmcGF5Y3VycmVuY3k9TFRM","ss1":"
4cd7b78844a4d1267983efeebc70d4ba","ss2":"RNXg2N3LptZ74soOn09un2TbExZIPkvP2X-1XJHALIYIvhyliCqPTQQIBMXoqFD-z2OnSV_H0v0CSZr-Fe6ZEGkEQ1o1LKyLOVeu2mSZ8SPR0yz7RqCXrIxOYHHl8574r6wO5FQUS9PFZLn21DpQWtRgQ-fXr0dJAZfK99lfC1o="}', NULL),
  (5, 41, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"41","amount":"3000","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 41 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66981198","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"3000","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDEmYW1vdW50PTMwMDAmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQxK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODExOTgmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTMwMDAmcGF5Y3VycmVuY3k9TFRM","ss1":"
8db74431e7f122ad951fddff99bab7bc","ss2":"Xs7JhzT9cYt_xOaX7XARHLp7C2eMWPF47qyD3iY4h-de3TbfNNBh7PJCjf7Jy0mmvYdEUhv27Rh3NV6ExhgFYHU_XDMkfzyrPVnP71NTe9Q2JkLcS8S_ByHzE9V2hx62b9iw6Ee-7xmrf4tCvoqHj4qTvHWMDpwdxtL8IjQKg4k="}', NULL),
  (6, 42, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"42","amount":"9500","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 42 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66982080","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"9500","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDImYW1vdW50PTk1MDAmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQyK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODIwODAmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTk1MDAmcGF5Y3VycmVuY3k9TFRM","ss1":"
b8b0b76da1cdd000d773a2b6f93fd322","ss2":"ozrJ2A_4RiQVEUw6VgCKyKQbd5TePM_GR2RmXJ7sgCvO07SUBa42x7DeSKQ0-_x6Pe6vipJEdDklFP9isTLcYE5PHY13pqIj6eMzj5rtCzDqG2RnNKdgAvR2ViXKbX-hJkzw_bRMaYvWCNsmcmPKfZHlftajnoc0wEkRffA3ZSE="}', NULL),
  (7, 43, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"43","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 43 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66982233","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDMmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQzK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODIyMzMmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
a0cf147901d0b2a3be706fd58c132076","ss2":"Rx2VeW0h96JB_iLaL5EByKQcIeKF-7AqJnNjxk25LQ2aCKqPm5dql1Zthva0Hvg92eNC7dV25_AcWx4QsCBpavbm7WCZ6VbYOG8LqcmqiszV1b8zmGdoFRR60IX0Ioj_or2oMt92OlUQiRJ8jFzRAbHGYDODMrE8xUyvqM69toY="}', NULL),
  (8, 44, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"44","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 44 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66982305","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDQmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQ0K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODIzMDUmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
9ca4158d7d29db7aed206cb5da135f9b","ss2":"o76x_egFYHeyzAABgJHcHwc5dZhJHDUyVAgOFvNyIRccPSQ0EMVLTnng724tDyYElLYKjLoBizMdtrxJdbTYlxTK0jfSEerHRVUV6IEnSxfkpYNz6xYVX8JjQTW10VPJgMF4NUP3OaiMYawKbhmCtaSC1EzvB2vln3tNrelL7v0="}', NULL),
  (9, 45, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"45","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 45 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66983211","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDUmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQ1K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODMyMTEmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
df052cbeaecf12449350708265d3b709","ss2":"vvPXGFivGeM9NHMia7H0GxmCv7NGDvLooL1JKoMUlWM-C3ibrAIqhfOCiT9nfU9V17x-ysppvwPnvsoVQCXxxbPsGpGkgtBUfiyZntkJOG82JqMpDZAEBo4HbASGEu9l2-zqBpoEc8fR5jLhrH-g-1-828QWdqWyxVoRz47RIgg="}', NULL),
  (10, 46, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"46","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"31530","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 46 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Dmitrijus Glezeris)","_client_language":"lit","status":"1","requestid":"66984012","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDYmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD0zMTUzMCZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQ2K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErRG1pdHJpanVzK0dsZXplcmlzJTI5Jl9jbGllbnRfbGFuZ3VhZ2U9bGl0JnN0YXR1cz0xJnJlcXVlc3RpZD02Njk4NDAxMiZuYW1lPVVBQiZzdXJlbmFtZT1Nb2slQzQlOTdqaW1haS5sdCZwYXlhbW91bnQ9NTk5OSZwYXljdXJyZW5jeT1MVEw=","ss1":"
8b2127cda8d8614428f09fdba91d263d","ss2":"BlZiTQ_LsAztbhMytIGvbQndxZySvX5XWI8dUDHGkn50oItOAxaEw-UicHoM--Qhdl2vsKygWOH07gdX4pgsUzf2-3B3JrC2RnrvhhBqBFf-wDiElyiHVPhi3Zmr5aeH0l7SETXSfqZGY-0olOlORpHr1w_dyrl4ljo89zykdjw="}', NULL),
  (12, 48, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"48","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"31530","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 48 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Dmitrijus Glezeris)","_client_language":"lit","status":"1","requestid":"66984906","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDgmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD0zMTUzMCZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQ4K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErRG1pdHJpanVzK0dsZXplcmlzJTI5Jl9jbGllbnRfbGFuZ3VhZ2U9bGl0JnN0YXR1cz0xJnJlcXVlc3RpZD02Njk4NDkwNiZuYW1lPVVBQiZzdXJlbmFtZT1Nb2slQzQlOTdqaW1haS5sdCZwYXlhbW91bnQ9NTk5OSZwYXljdXJyZW5jeT1MVEw=","ss1":"
28b851430182210d2063d9f499e48ada","ss2":"ZjK6WVRMQwPWta1LiNzNs0r1_7jR26u-tDRqAyaHMVu1JhFlNJqZSEMSb0gBL0OPH0VM2v4_ge80QAM6Zxvyk-EnDOOWI_SQGbn9ZuzgVR2ZcpRraWazYDcLLZNSeBEkBksEwfr8qYByTcc_SqwaSameBRFIs1IPKTimuQDItWk="}', NULL),
  (13, 49, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"49","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 49 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66986724","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NDkmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzQ5K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODY3MjQmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
59fa22305ba91a0783448ab38c88a7ab","ss2":"oK1AT9LKyvC4j8ipAIjv9ZenGDsrrnusXYAHe3wwWAqHBP2IjW_ogRbXqqQsZHO26H3FqQH8h-NX7U1Q3qmS4X-_1g3_KsUIb3VYm-aXzlIbJfkgIQMXNoFog9n2lGJqUsGbGxUQYntVDMiVBljceRz1nyh-29dqBCbmnLfUHe4="}', NULL),
  (14, 50, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"50","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 50 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"66986853","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NTAmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzUwK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjY5ODY4NTMmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
17bee283bad42ea5032567dd5b180f78","ss2":"mB_kmEXu5JB0HS6FXMKQQeNLp1shMSw72bjbJt38CWysw_CM37vpaI1GParjh3QS1y0AkOFbt30RRA4mUPsjTldPePSnQr7ZiYhruKkQ7XB9z59HxOjlsrG1NUAYgwd2qNluSQLYITYQFsfnGzmVk-zLHMsmdkrMBVssnprRzPs="}', NULL),
  (26, 52, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"52","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 52 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"67045761","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NTImYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzUyK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjcwNDU3NjEmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
c4ec60c63201269cb9237bcfc47fe951","ss2":"xgpO0RSkTCyFW7XaCfE6DGsfNOU_FerKl3nG4RAacIpYTzDMq9bNWYcr6VIVBw_nmJgEvmToXTgEiRgJF50R0iyjfHOmGU6nOFtxnnnFWKR-5UwIK1VZdMrcD67a5km_IixpHxxE42i5Ag9DO4-U2v2ZfDr1JuO6XqhzNlFJ-fc="}', NULL),
  (27, 53, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"53","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 53 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"67046133","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NTMmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzUzK2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjcwNDYxMzMmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
1c5171d27cc74ca2b1811d3bc6d9f3d4","ss2":"yY_fKXxQNotuq1vDMfDMqdddAv3gDXkEspq536rMPnn6QM0nuegQdvWTe_dpxHIeCJG2h8rpD5514m0zV5p8veRRH3OnvN2nbEMja_CScryyN7keSO7V5zaSMNmq55gQuTydnvO-dJkhY9omH9QKci-cn2GfzpQYTgmWN3RkgzU="}', NULL),
  (35, 56, 'evp_payment.payment_handler.web_to_pay', '{"p_email":"simkus9@gmail.com","orderid":"56","amount":"5999","currency":"LTL","country":"LT","payment":"wallet","test":"1","version":"1.6","projectid":"55182","type":"macro","lang":"","paytext":"U\\u017esakymas nr: 56 http:\\/\\/54.88.149.158 projekte. (Pardav\\u0117jas: Paulius \\u0160imkus)","_client_language":"lit","status":"1","requestid":"67051290","name":"UAB","surename":"Mok\\u0117jimai.lt","payamount":"5999","paycurrency":"LTL"}', '{"data":"cF9lbWFpbD1zaW1rdXM5JTQwZ21haWwuY29tJm9yZGVyaWQ9NTYmYW1vdW50PTU5OTkmY3VycmVuY3k9TFRMJmNvdW50cnk9TFQmcGF5bWVudD13YWxsZXQmdGVzdD0xJnZlcnNpb249MS42JnByb2plY3RpZD01NTE4MiZ0eXBlPUVNQSZsYW5nPSZwYXl0ZXh0PVUlQzUlQkVzYWt5bWFzK25yJTNBKzU2K2h0dHAlM0ElMkYlMkY1NC44OC4xNDkuMTU4K3Byb2pla3RlLislMjhQYXJkYXYlQzQlOTdqYXMlM0ErUGF1bGl1cyslQzUlQTBpbWt1cyUyOSZfY2xpZW50X2xhbmd1YWdlPWxpdCZzdGF0dXM9MSZyZXF1ZXN0aWQ9NjcwNTEyOTAmbmFtZT1VQUImc3VyZW5hbWU9TW9rJUM0JTk3amltYWkubHQmcGF5YW1vdW50PTU5OTkmcGF5Y3VycmVuY3k9TFRM","ss1":"
8a11073c70f487ccd3afa32e07661fb2","ss2":"RqFkzhhrVnAfJ_jOLo1ULBz7-wmU_901bIwnWnd0kc1OYNoqzzIY7hzulmdeLLQXwfq7VKk9_21pT6TnHam1b2ec1PglVeAyBE05Ql98Y6Q6-S8LtGcgPSpn2Yjf0rCG_i2OEFJTobz43VapJ1CmRkt00_6Dlh43nvn4TvK7LfM="}', NULL);

INSERT INTO `evp_steps` (`id`, `parameter`) VALUES
  (1, 'ticket_type_discount'),
  (2, 'user_details_fill'),
  (3, 'payment_window'),
  (4, 'payment_type_selection'),
  (7, 'seat_selection');

INSERT INTO `evp_templates` (`id`, `parent_class`, `foreign_key`, `name`, `type`, `source`, `from_email`, `subject`, `attachment_name`) VALUES
  (1, 'Evp\\Bundle\\TicketBundle\\Entity\\Event', '1', 'ticket.html.twig', 'ticket', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/default-ticket.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (2, 'Evp\\Bundle\\TicketBundle\\Entity\\Event', '1', 'ticket.html.twig', 'ticket_email', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing tickets to our event.&nbsp;</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>', 'company@email.com', 'Event Tickets', 'Ticket PDF'),
  (3, 'Evp\\Bundle\\TicketBundle\\Entity\\Event', '1', 'ticket_used.html.twig', 'ticket_used', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Cannot Enter Event.</p>\r\n\r\n<p>You Ticket is Invalid, because it was used before</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (4, 'Evp\\Bundle\\TicketBundle\\Entity\\Event', '1', 'ticket_unused.html.twig', 'ticket_unused', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Can Enter Event.</p>\r\n\r\n<p>Your Ticket is Valid.</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (18, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '1', 'ticket.html.twig', 'ticket', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/standartinis.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (19, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '1', 'ticket.html.twig', 'ticket_email', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>', 'company@email.com', 'Event Tickets', 'Ticket PDF'),
  (20, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '3', 'ticket.html.twig', 'ticket', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/savanoriu.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (21, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '3', 'ticket_used.html.twig', 'ticket_used', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (22, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '3', 'ticket_unused.html.twig', 'ticket_unused', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (23, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '3', 'ticket.html.twig', 'ticket_email', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>', 'company@email.com', 'Event Tickets', 'Ticket PDF'),
  (24, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '2', 'ticket.html.twig', 'ticket', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/verslo-klases.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (25, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '2', 'ticket_used.html.twig', 'ticket_used', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (26, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '2', 'ticket_unused.html.twig', 'ticket_unused', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET.</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (27, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '2', 'ticket.html.twig', 'ticket_email', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>', 'company@email.com', 'Event Tickets', 'Ticket PDF'),
  (28, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '1', 'ticket_used.html.twig', 'ticket_used', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>', NULL, NULL, NULL),
  (29, 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', '1', 'ticket_unused.html.twig', 'ticket_unused', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET</p>\r\n</body>\r\n</html>', NULL, NULL, NULL);

INSERT INTO `evp_tickets` (`id`, `event_id`, `ticket_type_id`, `user_id`, `order_details_id`, `discount_id`, `ticket_examiner_id`, `seat_id`, `price`, `date_created`, `status`, `date_modified`, `token`, `date_used`) VALUES
  (1, 1, 3, 24, 1, NULL, NULL, NULL, 0.0000, '2014-10-29 11:00:20', 'idle', '2014-11-11 08:06:33', 'e14259fc1a953ece2bf7682ec84cbdce5450c8c46fa884!36228832', NULL),
  (4, 1, 3, 25, 3, NULL, NULL, NULL, 0.0000, '2014-10-29 11:07:45', 'idle', '2014-11-11 08:06:33', 'a84591e5d94e594119c883511ef4b7be5450ca8194ee04!19185735', NULL),
  (5, 1, 3, 26, 4, NULL, NULL, NULL, 0.0000, '2014-10-29 11:08:55', 'idle', '2014-11-11 08:06:33', '9fc851f75229b1ea243ad3c223f8c3825450cac7e99dd8!73618337', NULL),
  (6, 1, 1, 27, 5, 31, NULL, NULL, 29.9950, '2014-10-29 11:09:58', 'idle', '2014-11-11 08:06:33', '1ce69736ec5e5fa239f494add4661bdd5450cb06af8f07!79391415', NULL),
  (7, 1, 1, 28, 6, NULL, NULL, NULL, 59.9900, '2014-10-31 07:20:16', 'unused', '2014-11-11 08:06:33', 'df4c01290d1fd98c90fbfe17a9755e37545338303fbb55!53000590', NULL),
  (8, 1, 1, 29, 7, 31, NULL, NULL, 29.9950, '2014-10-31 07:22:52', 'idle', '2014-11-11 08:06:33', 'a3d5de41cdf0b2708e07ec0344ee5cc2545338cccb59b6!51258413', NULL),
  (9, 1, 1, 30, 8, 31, NULL, NULL, 29.9950, '2014-10-31 07:23:50', 'idle', '2014-11-11 08:06:33', '9f8376c971617df8d7c2c3bb03d3ebf2545339061a54a8!31947080', NULL),
  (10, 1, 1, 31, 9, NULL, NULL, NULL, 59.9900, '2014-10-31 07:25:09', 'unused', '2014-11-11 08:06:33', '7f3aa12e0d9d6b36bf0d0075c949594454533955414681!96078601', NULL),
  (11, 1, 1, 32, 10, NULL, NULL, NULL, 59.9900, '2014-10-31 07:26:29', 'idle', '2014-11-11 08:06:33', '12f3cb64dc233c96a237aabbfa1d4473545339a5f17078!54368058', NULL),
  (12, 1, 1, 33, 11, 31, NULL, NULL, 29.9950, '2014-10-31 07:26:52', 'idle', '2014-11-11 08:06:33', '495f36305aa7a94113a8b15d5c837d51545339bc6a1c75!25709784', NULL),
  (14, 1, 1, 34, 12, 31, NULL, NULL, 29.9950, '2014-10-31 07:36:17', 'idle', '2014-11-11 08:06:33', '340a2a45a6b74b7a545131865e21d4cb54533bf1e95d48!94050720', NULL),
  (15, 1, 1, 35, 13, NULL, NULL, NULL, 59.9900, '2014-10-31 07:37:05', 'idle', '2014-11-11 08:06:33', '6ec2b99c73e885928ec27adc953d32d554533c2184ec86!74792719', NULL),
  (16, 1, 1, 36, 14, NULL, NULL, NULL, 59.9900, '2014-10-31 07:38:41', 'unused', '2014-11-11 08:06:33', 'fcf53d0566ce88af84f014de5de7fa7a54533c811721d1!07104445', NULL),
  (17, 1, 1, 37, 15, 31, NULL, NULL, 29.9950, '2014-10-31 07:49:45', 'idle', '2014-11-11 08:06:33', 'c592ea7581b74dd977a982fa0f02876f54533f198baf52!39533906', NULL),
  (18, 1, 1, 38, 16, NULL, NULL, NULL, 59.9900, '2014-11-11 07:41:03', 'unused', '2014-11-11 08:06:33', '6fc2ac1c8906d0532506302a76db3a9c5461bd8fef4343!81487321', NULL),
  (19, 1, 1, 39, 17, 31, NULL, NULL, 30.0000, '2014-11-11 07:46:08', 'unused', '2014-11-11 08:06:33', 'c2bd6228e5167c52520c3ccc121de3325461bec0117e59!67496251', NULL),
  (20, 1, 3, 40, 18, NULL, NULL, NULL, 0.0000, '2014-11-11 07:47:27', 'idle', '2014-11-11 08:06:33', '6e06610807c5a8927e0eee5563f10e2f5461bf0f275408!01041041', NULL),
  (21, 1, 1, 41, 19, 31, NULL, NULL, 30.0000, '2014-11-11 07:53:32', 'unused', '2014-11-11 08:06:33', '6d43fd1eff9e2c6a95f57b76a82933ff5461c07c586f64!09607910', NULL),
  (22, 1, 2, 42, 20, 31, NULL, NULL, 95.0000, '2014-11-11 08:06:32', 'unused', '2014-11-11 08:06:53', '95042c4770da0b3de9044c3197b7b8575461c388073341!16266765', NULL),
  (23, 1, 1, 43, 21, NULL, NULL, NULL, 59.9900, '2014-11-11 08:08:54', 'unused', '2014-11-11 08:09:14', 'cc6aff3a6ad8fd47e564d4503910c94e5461c416e9d7a1!35404886', NULL),
  (24, 1, 1, 44, 22, NULL, NULL, NULL, 59.9900, '2014-11-11 08:10:05', 'unused', '2014-11-11 08:10:23', '9a7602fb1cdc60d9fb59dacb0bc04db65461c45d81a7c9!05053991', NULL),
  (25, 1, 1, 45, 23, NULL, NULL, NULL, 59.9900, '2014-11-11 08:25:40', 'unused', '2014-11-11 08:26:03', '1fe17db8740f58ea69b59a1b2313df7a5461c804101718!34381177', NULL),
  (26, 1, 1, 46, 24, NULL, NULL, NULL, 59.9900, '2014-11-11 08:36:48', 'unused', '2014-11-11 08:37:10', 'c89ff9a2883162096c26e49a524726cf5461caa0839c79!46071586', NULL),
  (27, 1, 1, 47, 25, NULL, NULL, NULL, 59.9900, '2014-11-11 08:50:05', 'idle', '2014-11-11 08:50:11', '78f9fa40b11a7bfabcdb4845f88b08955461cdbd1b8ab5!52648823', NULL),
  (28, 1, 1, 48, 26, NULL, NULL, NULL, 59.9900, '2014-11-11 08:50:41', 'unused', '2014-11-11 08:51:03', '6b596a8a07763748fb4ca2fc8a9b29a65461cde1de1ff4!50477767', NULL),
  (29, 1, 1, 49, 27, NULL, NULL, NULL, 59.9900, '2014-11-11 09:16:59', 'unused', '2014-11-11 09:17:18', '96e276680bf61f00d76d19ebe284c6795461d40b5ac070!14367114', NULL),
  (30, 1, 1, 50, 28, NULL, NULL, NULL, 59.9900, '2014-11-11 09:19:18', 'unused', '2014-11-11 09:20:03', '923769c37d73eccaf769e58d356c75ba5461d4962e2261!05814674', NULL),
  (31, 1, 1, 51, 29, NULL, NULL, NULL, 59.9900, '2014-11-11 12:11:23', 'idle', '2014-11-11 12:11:29', '6be0208cbdf5a53098f8773e46bbd7045461fceba78232!30451321', NULL),
  (32, 1, 1, 52, 30, NULL, NULL, NULL, 59.9900, '2014-11-12 07:20:29', 'unused', '2014-11-12 07:20:52', '045ccb889c1a2959a2caf7d50bd2207e54630a3d1c4f64!99211143', NULL),
  (33, 1, 1, 53, 31, NULL, NULL, NULL, 59.9900, '2014-11-12 07:27:25', 'unused', '2014-11-12 07:27:47', '15cd4701a59dbe5ad687a9912e15ccd754630bdd169d09!24721321', NULL),
  (34, 1, 1, 54, 32, NULL, NULL, NULL, 59.9900, '2014-11-12 08:43:18', 'idle', '2014-11-12 08:43:18', '37c2a97acf6b5466cac9c95bdb8f1dbf54631da679bae7!46550941', NULL),
  (35, 1, 1, 56, 33, NULL, NULL, NULL, 59.9900, '2014-11-12 09:05:17', 'unused', '2014-11-12 09:05:37', '5ceb1c4eaf936b5fa612db8038acb115546322cd951ac5!27643462', NULL);

INSERT INTO `evp_ticket_types` (`id`, `event_id`, `area_id`, `tickets_count`, `name`, `description`, `date_created`, `price`, `status`) VALUES
  (1, 1, NULL, 500, 'Standard Ticket', 'A ticket to participate in event', '2014-10-28 12:54:23', 59.9900, 1),
  (2, 1, NULL, 300, 'Business Sector Ticket', 'A special ticket for business general managers', '2014-10-28 12:56:37', 189.9900, 1),
  (3, 1, NULL, 50, 'Volunteer Ticket', 'A free ticket for volunteers', '2014-10-28 13:00:56', 0.0000, 1);

INSERT INTO `evp_translations` (`id`, `locale`, `object_class`, `field`, `foreign_key`, `content`) VALUES
  (1, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\EventType', 'name', '1', 'My Events'),
  (2, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\EventType', 'name', '1', 'Mano Renginiai'),
  (3, 'ru', 'Evp\\Bundle\\TicketBundle\\Entity\\EventType', 'name', '1', 'мои события'),
  (4, 'lv', 'Evp\\Bundle\\TicketBundle\\Entity\\EventType', 'name', '1', 'Mani notikumi'),
  (5, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Event', 'name', '1', 'Vilnius Innovation Conference 2015'),
  (6, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Event', 'description', '1', '<p>The Conference Board of Vilnius has established the Centre for Business Innovation (CBI) as a five-year initiative to help bring about major improvements in firm-level business innovation in Vilnius, Lithuania.</p>\r\n\r\n<p>The 2015 Business Innovation Summit explored the real-life challenges and opportunities for innovation within firms and tangible solutions. Industry professionals and expert speakers took part in delegate-expert sharing sessions, giving participants the insights and tools to increase the speed at which their organizations can generate new ideas, products, services, and processes.</p>'),
  (7, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Event', 'name', '1', 'Inovacijų Konferencija Vilnius 2015'),
  (8, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Event', 'description', '1', '<p>Verslumą skatinančių inovacijų konferencija 2015 Vilniuje.Renginyje apžvelgsime, kaip pasikeitė inovatyviausių kompanijų sąrašas Lietuvoje per pastaruosius metus. Kurios inovacijos greičiauisiai keičia Lietuvos rinką? Kokių pokyčių tikėtis verslo sektoriuje per ateinančius 5-ius metus.</p>'),
  (9, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '1', 'Standard Ticket'),
  (10, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '1', 'A ticket to participate in event'),
  (11, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '1', 'Standartinis Bilietas'),
  (12, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '1', 'Bilietas su kuriuo galėsite patekti į pagrindinį renginį'),
  (13, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '2', 'Business Sector Ticket'),
  (14, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '2', 'A special ticket for business general managers'),
  (15, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '2', 'Verslo klasės bilietas'),
  (16, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '2', 'Šis bilietas suteikia privilegijuotą teisę patekti į salę, kurioje rinksis įstaigų vadovai'),
  (17, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '3', 'Volunteer Ticket'),
  (18, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '3', 'A free ticket for volunteers'),
  (19, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'name', '3', 'Savanorių bilietas'),
  (20, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\TicketType', 'description', '3', 'Savanoriai gali dalyvauti renginyje nemokamai. Į renginį reikia atvykti 30 minučių prieš renginio pradžią'),
  (21, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'name', '1', 'Discount for Earlybirds'),
  (22, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'description', '1', 'First 30 Tickets are 30% cheaper'),
  (23, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'name', '2', 'Reusable Code'),
  (24, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'description', '2', 'This Discount code can be used more than once. It gives 50% Discount'),
  (25, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'name', '3', 'Marketing Compaign Discount'),
  (26, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'description', '3', 'This discount is for all clients that use a voucher from our marketing campaign. It gives fixed 5 EUR Discount'),
  (27, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'name', '4', 'Special Fixed Price Discount'),
  (28, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\DiscountType', 'description', '4', 'This code gives a fixed price discount. Fixed Price is set to 20EUR.'),
  (29, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Form\\FieldSchema', 'label', '2', 'Firstname and Lastname'),
  (30, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Form\\FieldSchema', 'label', '2', 'Vardas ir Pavardė'),
  (31, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Form\\FieldSchema', 'label', '3', 'Enter your age'),
  (32, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Form\\FieldSchema', 'label', '3', 'amžius'),
  (33, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '1', '<html><head><meta content="text/html; charset=utf-8" http-equiv="Content-Type" /><title>Bilietas</title><style type="text/css">#main {margin:0;} #qr {display: block;left: 150px;overflow: hidden;padding: 2px;position: absolute;top: 160px;}</style></head><body><div id="main"><img src="http://tickets.paysera.lt/wp-content/uploads/2014/10/default-ticket.png" width="100%" /><div id="qr"><img src="{{ url(''evp_ticket_generate_qr'', { ''ticketToken'' : ticket.token }) }}" width="158" /></div></div></body></html>'),
  (34, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '2', '<html><head></head><body><p>Thank you for purchasing tickets to Innovataion Conference Vilnius 2015.</p></body></html>'),
  (35, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '2', 'company@email.com'),
  (36, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '2', 'Innovation Conference 2015 Ticket'),
  (37, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '2', 'Innovation Conference Ticket PDF'),
  (38, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '3', '<html><head>	<title></title></head><body><p>Invalid&nbsp;Ticket. This ticket was used before</p></body></html>'),
  (39, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '4', '<html><head>	<title></title></head><body><p>Valid Ticket. You can enter Event</p></body></html>'),
  (40, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '2', '<html><head>	<title></title></head><body><p>Ačiū, kad pirkote bilietą į Verslo Inovacijų konferenciją.&nbsp;</p></body></html>'),
  (41, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '2', 'kompanija@email.lt'),
  (42, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '2', 'Verslo Inovacijų konferencijos bilietas'),
  (43, 'lt', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '2', 'Bilietas PDF'),
  (44, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '5', '<!DOCTYPE><html><head>	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />	<title>Bilietas</title>	<style type=\\"text/css\\">#main {margin:0;}           #qr {           display: block;           left: 150px;           overflow: hidden;           padding: 2px;           position: absolute;           top: 160px;           }	</style></head><body><div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/savanoriu.png\\" width=\\"100%\\" /><div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div></div></body></html>'),
  (45, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '6', '<!DOCTYPE><html><head>	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />	<title>Bilietas</title>	<style type=\\"text/css\\">#main {margin:0;}           #qr {           display: block;           left: 150px;           overflow: hidden;           padding: 2px;           position: absolute;           top: 160px;           }	</style></head><body><div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/verslo-klases.png\\" width=\\"100%\\" /><div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div></div></body></html>'),
  (46, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '7', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Volunteer Ticket.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (47, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '8', '<html><head>	<title></title></head><body><p>Valid Ticket.</p><p>Type: Volunteer</p></body></html>'),
  (48, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '9', '<html><head>	<title></title></head><body><p>Invalid Ticket.</p><p>Type: Volunteer</p></body></html>'),
  (49, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '10', '<html><head>	<title></title></head><body><p>Invalid Ticket</p><p>Type: Business Sector Ticket</p></body></html>'),
  (50, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '11', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Business Class Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (51, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '1', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/default-ticket.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (52, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '2', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing tickets to our event.&nbsp;</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (53, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '2', 'company@email.com'),
  (54, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '2', 'Event Tickets'),
  (55, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '2', 'Ticket PDF'),
  (56, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '3', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Cannot Enter Event.</p>\r\n\r\n<p>You Ticket is Invalid, because it was used before</p>\r\n</body>\r\n</html>'),
  (57, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '4', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Can Enter Event.</p>\r\n\r\n<p>Your Ticket is Valid.</p>\r\n</body>\r\n</html>'),
  (58, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '5', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Cannot Enter Event.&nbsp;</p>\r\n\r\n<p>This Volunteer Ticket was used before.</p>\r\n</body>\r\n</html>'),
  (59, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '6', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Caan&nbsp;Enter Event.&nbsp;</p>\r\n\r\n<p>This Volunteer Ticket is Valid.</p>\r\n</body>\r\n</html>'),
  (60, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '7', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Volunteer Ticket.</p>\r\n\r\n<p>Ticket PDF File is Attached to this email.</p>\r\n</body>\r\n</html>'),
  (61, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '7', 'company@email.com'),
  (62, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '7', 'Event Tickets'),
  (63, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '7', 'Ticket PDF'),
  (64, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '8', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/verslo-klases.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (65, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '9', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Cannot Enter Event.</p>\r\n\r\n<p>This Business Class Ticket was used before.</p>\r\n</body>\r\n</html>'),
  (66, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '10', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Can Enter Event.</p>\r\n\r\n<p>This Business Class Ticket is Valid.</p>\r\n</body>\r\n</html>'),
  (67, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '11', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Business Class Ticket to our event.</p>\r\n\r\n<p>Ticket PDF files are attached to this email</p>\r\n</body>\r\n</html>'),
  (68, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '11', 'company@email.com'),
  (69, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '11', 'Event Tickets'),
  (70, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '11', 'Ticket PDF'),
  (72, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '13', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/verslo-klases.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (73, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '14', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/standartinis.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (74, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '15', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Standard ticket to our event,</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (75, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '15', 'company@email.com'),
  (76, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '15', 'Event Tickets'),
  (77, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '15', 'Ticket PDF'),
  (78, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '16', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You Cannot Enter Event.&nbsp;</p>\r\n\r\n<p>This Standard&nbsp;Ticket was used before.</p>\r\n</body>\r\n</html>'),
  (79, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '17', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>You can Enter Event.</p>\r\n\r\n<p>This Standard Ticket is valid.</p>\r\n</body>\r\n</html>'),
  (80, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '18', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/standartinis.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (81, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '18', NULL),
  (82, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '18', NULL),
  (83, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '18', NULL),
  (84, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '19', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (85, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '19', 'company@email.com'),
  (86, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '19', 'Event Tickets'),
  (87, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '19', 'Ticket PDF'),
  (88, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '20', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/savanoriu.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (89, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '21', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>'),
  (90, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '22', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET</p>\r\n</body>\r\n</html>'),
  (91, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '23', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (92, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '23', 'company@email.com'),
  (93, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '23', 'Event Tickets'),
  (94, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '23', 'Ticket PDF'),
  (95, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '24', '<!DOCTYPE>\r\n<html>\r\n<head>\r\n	<meta content=\\"text/html; charset=utf-8\\" http-equiv=\\"Content-Type\\" />\r\n	<title>Bilietas</title>\r\n	<style type=\\"text/css\\">#main {margin:0;}\r\n           #qr {\r\n           display: block;\r\n           left: 100px;\r\n           overflow: hidden;\r\n           padding: 2px;\r\n           position: absolute;\r\n           top: 110px;\r\n           }\r\n	</style>\r\n</head>\r\n<body>\r\n<div id=\\"main\\"><img src=\\"http://tickets.paysera.lt/wp-content/uploads/2014/10/verslo-klases.png\\" width=\\"100%\\" />\r\n<div id=\\"qr\\"><img src=\\"{{ url(\\''evp_ticket_generate_qr\\'', { \\''ticketToken\\'' : ticket.token }) }}\\" width=\\"158\\" /></div>\r\n</div>\r\n</body>\r\n</html>'),
  (96, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '25', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>'),
  (97, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '26', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET.</p>\r\n</body>\r\n</html>'),
  (98, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '27', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Thank you for purchasing Ticket to our event.</p>\r\n\r\n<p>Tickets are attached to this email.</p>\r\n</body>\r\n</html>'),
  (99, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'fromEmail', '27', 'company@email.com'),
  (100, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'subject', '27', 'Event Tickets'),
  (101, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'attachmentName', '27', 'Ticket PDF'),
  (102, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '28', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>INVALID TICKET.</p>\r\n</body>\r\n</html>'),
  (103, 'en', 'Evp\\Bundle\\TicketBundle\\Entity\\Template', 'source', '29', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>VALID TICKET</p>\r\n</body>\r\n</html>');

INSERT INTO `evp_users` (`id`, `order_id`, `date_created`, `email`) VALUES
  (1, 1, '2014-10-28 13:34:31', NULL),
  (2, 2, '2014-10-28 13:34:48', NULL),
  (3, 3, '2014-10-28 13:36:29', NULL),
  (4, 4, '2014-10-28 13:36:38', NULL),
  (5, 5, '2014-10-28 13:37:42', NULL),
  (6, 6, '2014-10-28 13:37:59', NULL),
  (7, 7, '2014-10-28 13:38:21', NULL),
  (8, 8, '2014-10-28 13:38:37', NULL),
  (9, 9, '2014-10-28 13:40:45', NULL),
  (10, 10, '2014-10-28 13:41:02', NULL),
  (11, 11, '2014-10-28 13:45:34', NULL),
  (12, 12, '2014-10-28 14:36:43', NULL),
  (13, 13, '2014-10-28 14:37:15', NULL),
  (14, 14, '2014-10-28 14:37:56', NULL),
  (15, 15, '2014-10-28 14:40:33', NULL),
  (16, 16, '2014-10-28 14:41:01', NULL),
  (17, 17, '2014-10-29 05:58:04', NULL),
  (18, 18, '2014-10-29 07:02:18', NULL),
  (19, 19, '2014-10-29 07:24:38', NULL),
  (20, 20, '2014-10-29 07:25:20', NULL),
  (21, 21, '2014-10-29 07:30:30', NULL),
  (22, 22, '2014-10-29 08:50:34', NULL),
  (23, 23, '2014-10-29 09:11:25', NULL),
  (24, 24, '2014-10-29 11:00:11', 'p.simkus@paysera.lt'),
  (25, 25, '2014-10-29 11:07:39', 'p.simkus@paysera.lt'),
  (26, 26, '2014-10-29 11:08:48', 'p.simkus@paysera.lt'),
  (27, 27, '2014-10-29 11:09:54', 'p.simkus@paysera.lt'),
  (28, 28, '2014-10-31 07:20:13', 'p.simkus@paysera.lt'),
  (29, 29, '2014-10-31 07:22:48', 'simkus9@gmail.com'),
  (30, 30, '2014-10-31 07:23:46', 'simkus9@gmail.com'),
  (31, 31, '2014-10-31 07:25:06', 'simkus9@gmail.com'),
  (32, 32, '2014-10-31 07:26:27', NULL),
  (33, 33, '2014-10-31 07:26:49', 'simkus9@gmail.com'),
  (34, 34, '2014-10-31 07:29:12', 'simkus9@gmail.com'),
  (35, 35, '2014-10-31 07:37:02', NULL),
  (36, 36, '2014-10-31 07:38:41', 'simkus9@gmail.com'),
  (37, 37, '2014-10-31 07:49:42', 'simkus9@gmail.com'),
  (38, 38, '2014-11-11 07:40:56', 'simkus9@gmail.com'),
  (39, 39, '2014-11-11 07:46:05', 'simkus9@gmail.com'),
  (40, 40, '2014-11-11 07:47:23', 'simkus9@gmail.com'),
  (41, 41, '2014-11-11 07:53:29', 'simkus9@gmail.com'),
  (42, 42, '2014-11-11 08:06:29', 'simkus9@gmail.com'),
  (43, 43, '2014-11-11 08:08:52', 'simkus9@gmail.com'),
  (44, 44, '2014-11-11 08:10:02', 'simkus9@gmail.com'),
  (45, 45, '2014-11-11 08:25:37', 'simkus9@gmail.com'),
  (46, 46, '2014-11-11 08:36:45', 'simkus9@gmail.com'),
  (47, 47, '2014-11-11 08:50:01', 'simkus9@gmail.com'),
  (48, 48, '2014-11-11 08:50:38', 'simkus9@gmail.com'),
  (49, 49, '2014-11-11 09:16:56', 'simkus9@gmail.com'),
  (50, 50, '2014-11-11 09:19:12', 'simkus9@gmail.com'),
  (51, 51, '2014-11-11 12:11:21', 'simkus9@gmail.com'),
  (52, 52, '2014-11-12 07:20:26', 'simkus9@gmail.com'),
  (53, 53, '2014-11-12 07:27:19', 'simkus9@gmail.com'),
  (54, 54, '2014-11-12 08:43:11', NULL),
  (55, 55, '2014-11-12 08:57:25', NULL),
  (56, 56, '2014-11-12 09:05:15', 'simkus9@gmail.com');


SET foreign_key_checks = 1;
