UPDATE `%%XC%%_products` SET `pinCodesEnabled` = 1 WHERE `product_id` = '42';
UPDATE `%%XC%%_products` SET `autoPinCodes` = 1 WHERE `product_id` = '42';
Insert into `%%XC%%_pin_codes` (`code`,`createDate`,`isSold`,`isBlocked`,`productId`,`orderItemId`) values ('123432','1563400000','1','1','42','9');

Insert into `%%XC%%_product_attachments` (`product_id`,`private`,`orderby`,`access`) values (42,1,9,'A');
INSERT INTO `%%XC%%_product_attachment_storages` (`attachment_id`,`path`,`fileName`,`mime`,`storageType`,`size`,`date`)VALUES (1,'42/autotests-master.zip.c71fd792451ed5ae164b389633c5ce89','autotests-master.zip','application/zip','r',15822,1563419916);
INSERT INTO `%%XC%%_product_attachment_translations` (`id`,`title`,`description`,`code`) VALUES (1,'autotests-master.zip','tead decription','en');
INSERT INTO `%%XC%%_order_item_private_attachments` (`item_id`,`attachment_id`,`title`,`downloadKey`,`expire`,`attempt`,`attemptLimit`,`blocked`) VALUES (9,1,'autotests-master.zip','d94cbffd3467923c68e80c16ec5a41a0ecf387814c9b8f299ef378ff78465aeeccf6e0dc403912e6334b6bbd7273eee5b2bbfe752982a3bb2d45df140fe8460c',1910846340,0,3,0);

INSERT INTO `%%XC%%_product_attachment_history_points` (`attachment_id`,`order_id`,`profile_id`,`login`,`ip`,`date`,`path`,`additionalDetails`) values (1,6,NULL,'test@email.com','192.168.0.1',1563400000,'sadasdasd','asdasdasd');

INSERT INTO `%%XC%%_attributes` ( `position`, `decimals`, `type`, `AddToNew`, `displayMode`) VALUES ( 0, 0, 'H', '', 'S');
INSERT INTO `%%XC%%_attribute_translations` (`id`, `name`, `unit`, `code`) VALUES (100, 'HiddenAttr100 ', '', 'en');
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (300, 100, 0, 0);
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (301, 100, 0, 0);
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (302, 100, 0, 0);
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (300, 'Red', 'en');
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (301, 'Green', 'en');
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (302, 'Blue', 'en');

INSERT INTO `%%XC%%_attributes` ( `position`, `decimals`, `type`, `AddToNew`, `displayMode`) VALUES ( 0, 0, 'H', '', 'S');
INSERT INTO `%%XC%%_attribute_translations` (`id`, `name`, `unit`, `code`) VALUES (101, 'HiddenAttr100', '', 'en');
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (303, 101, 0, 0);
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (304, 101, 0, 0);
INSERT INTO `%%XC%%_attribute_options` (`id`, `attribute_id`, `AddToNew`, `position`) VALUES (305, 101, 0, 0);
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (303, 'Red', 'en');
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (304, 'Green', 'en');
INSERT INTO `%%XC%%_attribute_option_translations` (`id`, `name`, `code`) VALUES (305, 'Blue', 'en');

INSERT INTO `%%XC%%_attribute_values_hidden` (`attribute_option_id`,`product_id`,`attribute_id`) VALUES (305, 42, 101);

INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (1,42,NULL,'price',11.0000,100,0);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (2,42,NULL,'price',12.1000,10,99);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (3,42,NULL,'price',8.0000,5,9);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (4,42,NULL,'price',7.8000,15,0);

INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (5,31,NULL,'price',100.0000,100,0);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (6,31,NULL,'price',150.0000,50,99);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (7,31,NULL,'price',200.0000,15,49);
INSERT INTO `%%XC%%_wholesale_prices` (`id`, `product_id`, `membership_id`, `type`, `price`, `quantityRangeBegin`, `quantityRangeEnd`) VALUES (8,31,NULL,'price',250.0000,2,14);

INSERT INTO `%%XC%%_conversations` (`order_id`) VALUES (6);

INSERT INTO `%%XC%%_conversation_members` (`conversation_id`,`profile_id`) VALUES (1,8);

INSERT INTO `%%XC%%_vendor_convo_messages` (`conversation_id`, `profile_id`, `date`, `body`, `type`) VALUES (1,8,1563518255,'what price','regular');
INSERT INTO `%%XC%%_vendor_convo_messages` (`conversation_id`, `profile_id`, `date`, `body`, `type`) VALUES (1,8,1563518200,'test message','regular');

