('58','КОНФЕТЫ БАТОНЧИК СЛИВОЧНЫЙ','[BLOB]','30','10189',NULL);
REPLACE INTO `picklist1` (`code`, `name`, `image`, `parent`, `tmccode`, `itemorder`) VALUES ('59','КОНФЕТЫ МИШКИ В ЛЕСУ','[BLOB]','30','10190',NULL),('6','ТОРТ ДЮЖИНА МАННА НЕБЕСНАЯ 800Г','[BLOB]\[BLOB]','1','11242',6),('60','СОСИСКА В ТЕСТЕ','[BLOB]','29','10191',NULL),('61','КОЛЬЦО В ПОМАДКЕ','[BLOB]','29','10192',NULL),('62','ЧИАБАТТА','[BLOB]','29','10193',NULL),('63','СПЕЦ. ТОВАРЫ','[BLOB]',NULL,NULL,6),('64','СИГАРЕТЫ ВИНСТОН БЛЮ (WINSTON BLUE)','[BLOB]','63','2012',NULL),('65','ВОДКА ABSOLUT 40% 0.7L','[BLOB]','63','2010',NULL),('66','МОЛОЧНЫЙ ДЕСЕРТ','[BLOB]','63','105',NULL),('67','ВОДА МИНЕРАЛЬНАЯ BORJOMI','[BLOB]','63','106',NULL),('69','ТОВАР ЗАПРЕЩЁН К ПРОДАЖЕ','[BLOB]','63','1062',NULL),('7','ТОРТ ДЮЖИНА ЧЕРЕМУХОВЫЙ 800Г','[BLOB]\[BLOB]\[BLOB]\[BLOB]\[BLOB]\[BLOB]\nK9OCZxqW51VPKheS8FYUgSkKiJATX62SZrtvijA9Yued6N/9nXoL2JG9c5xDufEMVY73atLU+ynS3ykpxMajmyl5/oPMB+ESpiVjsFHDxprqu844Qvlcx4tJ+W4LpdLJQXzRNQ935oQFMp1PAr4JSykXQzFffKIr8St8xsOajKArAg/97V7+5KjrLso5+qhavOf980+l0YSw3h8+CIGA2my3e27xZ4ZPdz8XP/xjQg69k7D2FXsqS/9JPNY/GLyUv732tJz7/0sngFv9eTFTkxae5vc954vP3KvovrqY8xd+Y/23xJL+f00DbJ6xc810GWKx4WuvFomSMWbCv5pjzpa956XV7H/eEJs2T0QvnfIO6ri96D3f3o67rBRdhPkmekMNesuj8P8s1JvwmRBpxAAAAAElFTkSuQmCC','1','11228',7),('70','ОБЯЗАТЕЛЬНЫЙ ВВОД КОЛИЧЕСТВА ВРУЧНУЮ','[BLOB]','63','10157',NULL),('71','ОБЯЗАТЕЛЬНЫЙ ВВОД ЦЕНЫ','[BLOB]','63','10158',NULL),('72','ОБЯЗАТЕЛЬНЫЙ ВЫБОР ЦЕНЫ ИЗ СПИСКА','[BLOB]','63','1072',NULL),('73','ПУСТОЙ КАТАЛОГ','','63',NULL,NULL),('8','ТОРТ ПЕРФЕКТ ПОЗДРАВЛЯЮ 800Г','[BLOB]\[BLOB]','1','10202',8);

--
-- Dumping data for table `picklist2`
--


--
-- Dumping data for table `prices1`
--


--
-- Dumping data for table `prices2`
--


--
-- Dumping data for table `provider1`
--


--
-- Dumping data for table `provider2`
--


--
-- Dumping data for table `region1`
--


--
-- Dumping data for table `region2`
--


--
-- Dumping data for table `remain1`
--


--
-- Dumping data for table `remain2`
--


--
-- Dumping data for table `remainbarcode1`
--


--
-- Dumping data for table `remainbarcode2`
--


--
-- Dumping data for table `remaindraftbeer1`
--


--
-- Dumping data for table `remaindraftbeer2`
--


--
-- Dumping data for table `role1`
--

REPLACE INTO `role1` (`rolecode`, `rolename`, `cashmanagement`) VALUES (1,'Оператор-кассир',NULL),(2,'Администратор торгового зала',NULL),(3,'Кассир',NULL),(4,'Полный доступ',NULL);

--
-- Dumping data for table `role2`
--


--
-- Dumping data for table `rolecmaction1`
--


--
-- Dumping data for table `rolecmaction2`
--


--
-- Dumping data for table `rolecommand1`
--

REPLACE INTO `rolecommand1` (`id`, `rolecode`, `commandcode`, `rule`, `documenttype`) VALUES (2,4,2,1,255),(3,4,3,1,255),(4,4,4,1,255),(5,4,5,1,255),(6,4,6,1,255),(7,4,7,1,255),(8,4,8,1,255),(9,4,9,1,255),(10,4,10,1,255),(11,4,11,1,255),(12,4,12,1,255),(13,4,13,1,255),(15,4,15,1,255),(16,4,16,1,255),(18,4,18,1,255),(19,4,19,1,255),(20,4,20,1,255),(21,4,21,1,255),(22,4,22,1,255),(23,4,23,1,255),(24,4,24,1,255),(25,4,27,1,255),(26,4,28,1,255),(27,4,29,1,255),(28,4,30,1,255),(29,4,42,1,255),(33,4,46,1,255),(35,4,48,1,255),(36,4,49,1,255),(37,4,50,1,255),(39,4,52,1,255),(40,4,53,1,255),(41,4,54,1,255),(42,4,55,1,255),(43,4,56,1,255),(45,4,58,1,255),(46,4,59,1,255),(48,4,61,1,255),(50,4,63,1,255),(52,4,65,1,255),(57,4,70,1,255),(59,4,72,1,255),(61,4,74,1,255),(64,4,77,1,255),(69,4,82,1,255),(70,4,83,1,255),(71,4,84,1,255),(73,4,86,1,255),(74,4,87,1,255),(75,4,88,1,255),(77,4,90,1,255),(79,4,1,1,255),(80,2,12,1,255),(81,2,13,1,255),(83,3,1,1,255),(84,3,2,1,255),(85,3,3,1,255),(86,3,4,1,255),(87,3,5,1,255),(89,3,7,1,255),(91,3,9,1,255),(92,3,10,1,255),(93,3,11,1,255),(97,3,15,1,255),(98,3,16,1,255),(100,3,18,1,255),(101,3,19,1,255),(102,3,20,1,255),(103,3,21,1,255),(104,3,22,1,255),(105,3,23,1,255),(106,3,24,1,255),(107,3,27,1,255),(108,3,28,1,255),(109,3,29,1,255),(110,3,30,1,255),(111,3,42,1,255),(115,3,46,1,255),(117,3,48,1,255),(118,3,49,1,255),(127,3,58,1,255),(128,3,59,1,255),(132,3,63,1,255),(134,3,65,1,255),(139,3,70,1,255),(141,3,72,1,255),(143,3,74,1,255),(151,3,82,1,255),(152,3,83,1,255),(153,3,84,1,255),(156,3,87,1,255),(157,3,88,1,255),(159,3,90,1,255),(161,4,92,1,255),(162,4,93,1,255),(163,3,92,1,255),(184,1,8,1,2),(185,1,50,1,255),(186,1,55,1,255),(187,1,54,1,255),(188,1,53,1,255),(189,1,52,1,255),(190,1,56,1,255),(192,1,61,1,255),(194,1,77,1,255),(195,1,6,1,255),(196,1,86,1,255),(198,2,2,1,255),(199,1,93,1,255),(360,4,94,1,255),(361,1,94,1,255),(362,4,95,1,255),(363,4,96,1,255),(364,4,97,1,255),(365,4,100,1,255),(366,4,98,1,255),(367,4,99,1,255),(368,3,6,1,255),(369,3,8,1,255),(370,3,12,1,255),(371,3,13,1,255),(373,3,50,1,255),(374,3,52,1,255),(375,3,53,1,255),(376,3,54,1,255),(377,3,55,1,255),(378,3,56,1,255),(380,3,61,1,255),(382,3,100,1,255),(383,3,77,1,255),(385,3,86,1,255),(387,3,93,1,255),(388,3,94,1,255),(389,3,95,1,255),(390,3,96,1,255),(391,3,97,1,255),(392,3,98,1,255),(393,3,99,1,255),(394,3,101,1,255),(395,3,102,1,255),(396,3,103,1,255),(397,4,101,1,255),(398,4,102,1,255),(399,4,103,1,255),(400,4,105,1,255),(401,4,106,1,255),(402,4,104,1,255),(403,3,105,1,255),(404,3,106,1,255),(405,3,104,1,255),(406,4,107,1,255),(407,4,108,1,255),(408,3,107,1,255),(409,3,108,1,255),(410,3,109,1,255),(411,4,109,1,255),(412,4,136,1,255),(413,3,136,1,255),(414,4,138,1,255),(415,4,138,1,255),(416,3,138,1,255),(417,4,139,1,255),(418,3,139,1,255),(421,3,140,1,255),(422,4,140,1,255),(425,4,141,1,255),(426,4,142,1,255),(428,4,143,1,255),(429,4,144,1,255),(431,3,145,1,255),(432,4,145,1,255),(433,4,146,1,255),(434,4,147,1,255),(435,4,148,1,255),(436,4,149,1,255),(437,4,150,1,255),(438,4,153,1,255),(439,4,154,1,255),(440,4,155,1,255),(441,4,156,1,255),(444,4,157,1,255),(445,4,158,1,255),(446,4,159,1,255),(448,4,160,1,255),(449,4,161,1,255),(450,4,162,1,255),(451,3,162,1,255),(452,4,163,1,255),(453,3,163,1,255),(454,4,164,1,255),(455,3,164,1,255),(456,4,165,1,255),(457,3,165,1,255),(458,3,166,1,255),(459,4,166,1,255),(460,3,168,1,255),(461,4,168,1,255),(462,3,169,1,255),(463,4,169,1,255),(467,4,170,1,255),(468,4,171,1,255),(469,4,137,1,255),(470,4,152,1,255),(477,4,176,1,255),(478,3,176,1,255),(480,4,178,1,255),(481,4,179,1,255),(482,4,180,1,255),(483,4,181,1,255),(484,3,181,1,255),(485,3,151,1,255),(486,4,151,1,255),(487,4,182,1,255),(488,3,182,1,255),(489,4,183,1,255),(490,3,183,1,255),(491,4,184,1,255),(492,4,185,1,255),(493,4,186,1,255),(494,3,184,1,255),(495,3,185,1,255),(496,3,186,1,255),(497,4,187,1,255),(498,4,188,1,255),(499,4,189,1,255),(500,4,190,1,255),(501,4,193,1,255),(502,4,194,1,255),(503,4,195,1,255),(504,3,170,1,255),(505,4,191,1,255),(506,3,190,1,255),(507,3,171,1,255),(508,3,193,1,255),(509,3,160,1,255),(510,3,156,1,255),(511,3,189,1,255),(512,4,196,1,255),(513,4,197,1,255),(514,3,198,1,255),(515,3,199,1,255),(516,4,198,1,255),(517,4,199,1,255),(518,3,200,1,255),(519,4,200,1,255),(520,3,201,1,255),(521,4,201,1,255),(522,3,202,1,255),(523,4,202,1,255),(524,3,204,1,255),(525,4,204,1,255),(526,3,205,1,255),(527,4,205,1,255),(528,3,206,1,255),(529,4,206,1,255),(530,4,207,1,255),(531,4,208,1,255),(532,4,209,1,255),(533,4,210,1,255),(534,4,211,1,255);

--
-- Dumping data for table `rolecommand2`
--


--
-- Dumping data for table `rolerelation1`
--

REPLACE INTO `rolerelation1` (`id`, `primaryrole`, `secondaryrole`, `rule`) VALUES (2,1,3,1);

--
-- Dumping data for table `rolerelation2`
--


--
-- Dumping data for table `roleuser1`
--

REPLACE INTO `roleuser1` (`id`, `usercode`, `rolecode`, `rule`) VALUES (3,'3',3,1),(61,'4',4,1),(62,'1',1,1),(63,'2',2,1);

--
-- Dumping data for table `roleuser2`
--


--
-- Dumping data for table `rostat1`
--


--
-- Dumping data for table `rostat2`
--


--
-- Dumping data for table `sdabs1`
--


--
-- Dumping data for table `sdabs2`
--


--
-- Dumping data for table `sdperc1`
--


--
-- Dumping data for table `sdperc2`
--


--
-- Dumping data for table `securityweight1`
--


--
-- Dumping data for table `securityweight2`
--


--
-- Dumping data for table `settings1`
--


--
-- Dumping data for table `settings2`
--


--
-- Dumping data for table `shop1`
--


--
-- Dumping data for table `shop2`
--


--
-- Dumping data for table `shopgrouplabels1`
--


--
-- Dumping data for table `shopgrouplabels2`
--


--
-- Dumping data for table `shoplabels1`
--


--
-- Dumping data for table `shoplabels2`
--


--
-- Dumping data for table `shoptoshoplabels1`
--


--
-- Dumping data for table `shoptoshoplabels2`
--


--
-- Dumping data for table `spindex1`
--


--
-- Dumping data for table `spindex2`
--


--
-- Dumping data for table `sprices1`
--


--
-- Dumping data for table `sprices2`
--


--
-- Dumping data for table `supplier1`
--


--
-- Dumping data for table `supplier2`
--


--
-- Dumping data for table `terminal1`
--


--
-- Dumping data for table `terminal2`
--


--
-- Dumping data for table `tgrlink1`
--


--
-- Dumping data for table `tgrlink2`
--


--
-- Dumping data for table `timeperiod1`
--


--
-- Dumping data for table `timeperiod2`
--


--
-- Dumping data for table `timerestrict1`
--


--
-- Dumping data for table `timerestrict2`
--


--
-- Dumping data for table `tmc1`
--

REPLACE INTO `tmc1` (`bcode`, `vatcode1`, `vatcode2`, `vatcode3`, `vatcode4`, `vatcode5`, `dcode`, `name`, `articul`, `cquant`, `measure`, `pricetype`, `price`, `minprice`, `valcode`, `quantdefault`, `quantlimit`, `ostat`, `links`, `quant_mode`, `bcode_mode`, `op_mode`, `dept_mode`, `price_mode`, `tara_flag`, `tara_mode`, `tara_default`, `unit_weight`, `code`, `aspectschemecode`, `aspectvaluesetcode`, `aspectusecase`, `aspectselectionrule`, `extendetoptions`, `groupcode`, `remain`, `remaindate`, `documentquantlimit`, `age`, `alcoholpercent`, `inn`, `kpp`, `alctypecode`, `manufacturercountrycode`, `paymentobject`, `loyaltymode`, `minretailprice`, `ntin`, `packagecode`, `ownertype`) VALUES ('1',1,0,0,0,0,1,'МОЛОКО БМК 1.5% 1Л П/П','',1.000,1,8,15.20,13.68,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10',2,0,0,0,0,2,'БМК БИФИЛЮКС 2.5% 0.5Л','',1.000,1,8,15.30,13.77,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('100',4,0,0,0,0,2,'ТВОРОГ ДАНОН ДАНИССИМО БРАВО ШОКОЛАД 135Г','',1.000,1,8,26.50,23.85,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'100',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10068',2,0,0,0,0,1,'ТОРТ АЛБИС МАЭСТРО 800Г','',1.000,1,8,261.50,235.35,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10068',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10069',2,0,0,0,0,1,'ТОРТ АЛБИС ЭКСТЕЗИ 600Г','',1.000,1,8,182.50,164.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10069',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1007',2,0,0,0,0,1,'ЙОГУРТНЫЙ ПРОДУКТ КАМПИНА НЕЖНЫЙ АНАНАС 1.2% 100Г','',1.000,1,8,5.90,5.31,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1007',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10071',2,0,0,0,0,1,'Х/Т ОСВЕЖИТЕЛЬ ВОЗДУХА ФРОСТ МОРСКОЙ 300МЛ','',1.000,1,8,47.90,43.11,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10071',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10074',2,0,0,0,0,1,'Х/Т ПЕРЧАТКИ РУСАЛОЧКА ЛАТЕКС БОЛЬШИЕ','',1.000,1,8,29.10,26.19,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10074',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10119',2,0,0,0,0,1,'КОСМ.БАЛЬЗАМ ДЛЯ ВОЛОС ГЛИС КУР ЖИДКИЙ ШЕЛК ДЛЯ ЛОМКИХ ВОЛОС 200МЛ','',1.000,1,8,115.50,103.95,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10119',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10130',2,0,0,0,0,1,'КЕТЧУП БАЛТИМОР АДМИРАЛ 530Г С/Б','',1.000,1,8,55.70,50.13,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10130',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10133',2,0,0,0,0,1,'КЕТЧУП БАЛТИМОР ТАТАРСКИЙ 530Г С/Б','',1.000,1,8,55.70,50.13,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10133',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10157',2,0,0,0,0,1,'ПРЯНИК 6 ВОРОНЕЖСКИЙ 400Г','',1.000,1,0,24.00,21.60,NULL,0.000,NULL,0,0,47,3,0,1,1,NULL,NULL,NULL,NULL,'10157',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10158',2,0,0,0,0,1,'ПРЯНИК 6 ИРЭК 400Г','',1.000,1,8,29.60,26.64,NULL,1.000,NULL,0,0,15,3,0,1,3,NULL,NULL,NULL,NULL,'10158',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10159',2,0,0,0,0,1,'ГРЕЙПФРУТ','',1.000,3,NULL,75.90,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10159',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10160',2,0,0,0,0,1,'ПЕРСИК','',1.000,3,NULL,200.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10160',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10161',2,0,0,0,0,1,'ПРЯНИК 6 НЕГРИТЕНОК 350Г','',1.000,1,8,22.00,19.80,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10161',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10162',2,0,0,0,0,1,'ЯБЛОКИ КРАСНЫЕ','',1.000,3,NULL,99.99,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10162',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10163',2,0,0,0,0,1,'КЛУБНИКА','',1.000,3,NULL,186.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10163',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10164',2,0,0,0,0,1,'ГРАНАТ','',1.000,3,NULL,77.50,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10164',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10165',2,0,0,0,0,1,'ПОМЕЛО','',1.000,3,NULL,133.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10165',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10166',2,0,0,0,0,1,'БАНАНЫ МИНИ','',1.000,3,NULL,99.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10166',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10167',2,0,0,0,0,1,'ЛИМОНЫ','',1.000,3,NULL,55.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10167',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10168',2,0,0,0,0,1,'ШАМПИНЬОНЫ','',1.000,3,NULL,77.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10168',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10169',2,0,0,0,0,1,'ЦВЕТНАЯ КАПУСТА','',1.000,3,NULL,55.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10169',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10170',2,0,0,0,0,1,'БАКЛАЖАНЫ','',1.000,3,NULL,120.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10170',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10171',2,0,0,0,0,1,'ЛУК КРАСНЫЙ','',1.000,3,NULL,37.70,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10171',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10172',2,0,0,0,0,1,'КАРТОФЕЛЬ НОВЫЙ УРОЖАЙ','',1.000,3,NULL,80.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10172',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10173',2,0,0,0,0,1,'ПОМИДОРЫ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10173',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10174',2,0,0,0,0,1,'КОНФЕТЫ 35 ШОКОЛАДНЫЕ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10174',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10175',2,0,0,0,0,1,'КОНФЕТЫ КРАСНЫЙ МАК','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10175',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10176',2,0,0,0,0,1,'КОНФЕТЫ КРОКАНТ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10176',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10177',2,0,0,0,0,1,'КОНФЕТЫ МАСКА','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10177',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10178',2,0,0,0,0,1,'КОНФЕТЫ СНИКЕРС','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10178',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10179',2,0,0,0,0,1,'КОНФЕТЫ ТВИКС МИНИ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10179',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10180',2,0,0,0,0,1,'ПОНЧИК РОЗОВЫЙ','',1.000,3,NULL,45.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10180',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10181',2,0,0,0,0,1,'СЛОЙКА С ДЖЕМОМ КИВИ','',1.000,3,NULL,45.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10181',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10182',2,0,0,0,0,1,'БУЛОЧКА С КОРИЦЕЙ','',1.000,3,NULL,45.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10182',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10183',2,0,0,0,0,1,'КЕФИР БМК 1% 400МЛ П/П','',1.000,1,8,15.80,14.22,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10183',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10184',2,0,0,0,0,1,'БАГЕТ','',1.000,3,NULL,45.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10184',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10185',2,0,0,0,0,1,'КРУАСАН','',1.000,3,NULL,45.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10185',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10186',2,0,0,0,0,1,'КЕФИР БМК 2.5% 400Г П/П','',1.000,1,8,17.60,15.84,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10186',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10187',2,0,0,0,0,1,'ПЕРЕЦ БОЛГАРСКИЙ','',1.000,3,NULL,100.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10187',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10188',2,0,0,0,0,1,'ОГУРЦЫ','',1.000,3,NULL,57.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10188',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10189',2,0,0,0,0,1,'КОНФЕТЫ БАТОНЧИК СЛИВОЧНЫЙ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10189',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10190',2,0,0,0,0,1,'КОНФЕТЫ МИШКИ В ЛЕСУ','',1.000,3,NULL,129.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10190',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10191',2,0,0,0,0,1,'СОСИСКА В ТЕСТЕ','',1.000,3,NULL,35.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10191',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10192',2,0,0,0,0,1,'КОЛЬЦО В ПОМАДКЕ','',1.000,3,NULL,27.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10192',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10193',2,0,0,0,0,1,'ЧИАБАТТА','',1.000,3,NULL,48.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10193',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('102',2,0,0,0,0,1,'МОЛОЧНЫЙ ДЕСЕРТ ДАНОН ДАНИССИМО С ТВОРОЖНЫМ КРЕМОМ ВИШНЯ 130Г','',1.000,1,8,24.90,22.41,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'102',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10202',2,0,0,0,0,1,'ТОРТ ПЕРФЕКТ ПОЗДРАВЛЯЮ 800Г','',1.000,1,8,209.90,188.91,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10202',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10206',2,0,0,0,0,1,'МАСЛО СЛИВОЧНОЕ ЛАКТ КРЕСТЬЯНСКОЕ 72.5% 400Г','',1.000,1,8,110.30,99.27,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10206',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10219',2,0,0,0,0,1,'КЕФИР БМК 2.5% 900Г П/П','',1.000,1,8,30.70,27.63,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10219',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10241',2,0,0,0,0,1,'ПРИПРАВА МАГГИ МАКАРОНОМАНИЯ БОЛОНЕЗ 30Г','',1.000,1,8,21.90,19.71,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10241',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10255',2,0,0,0,0,1,'ПРЯНИК 6 ДНЕПРОВСКИЙ 400Г','',1.000,1,8,23.10,20.79,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10255',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1029',2,0,0,0,0,1,'СОК РИЧ АНАНАС 1Л','',1.000,1,8,70.90,63.81,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1029',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1031',2,0,0,0,0,1,'СОК РИЧ ГРЕЙПФРУТ 1Л','',1.000,1,8,80.60,72.54,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1031',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1034',2,0,0,0,0,1,'СОК РИЧ ЯБЛОКО 1Л','',1.000,1,8,70.90,63.81,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1034',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10341',2,0,0,0,0,1,'СЫР ПЛАВЛЕНЫЙ АЛДЕС СЛИВОЧНЫЙ 200Г','',1.000,1,8,42.50,38.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10341',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10342',2,0,0,0,0,1,'СЫР ПЛАВЛЕНЫЙ АЛДЕС ВЕТЧИНА 200Г','',1.000,1,8,42.50,38.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10342',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10343',2,0,0,0,0,1,'СЫР ПЛАВЛЕНЫЙ АЛДЕС ГРИБЫ 200Г','',1.000,1,8,42.50,38.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10343',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10344',2,0,0,0,0,1,'ПАКЕТ СРЕДНИЙ','',1.000,1,NULL,5.50,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10344',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10345',2,0,0,0,0,1,'ПАКЕТ БОЛЬШОЙ','',1.000,1,NULL,7.50,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10345',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1037',2,0,0,0,0,1,'НЕКТАР РИЧ МАНГО 1Л','',1.000,1,8,70.90,63.81,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1037',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10396',2,0,0,0,0,1,'КОНС.РЫБ.САРДИНЕЛЛА НДМ 230Г','',1.000,1,8,23.90,21.51,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10396',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('105',2,0,0,0,0,1,'МОЛОЧНЫЙ ДЕСЕРТ ДАНОН ДАНИССИМО С ТВОРОЖНЫМ КРЕМОМ ЧЕРНИКА 130Г','',1.000,1,8,24.90,22.41,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'105',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10517',2,0,0,0,0,1,'МЫЛО/Т АБСОЛЮТ ОСВЕЖАЮЩЕЕ 90Г','',1.000,1,8,14.20,12.78,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10517',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10590',2,0,0,0,0,1,'СЫР ПЛАВЛЕНЫЙ АЛДЕС БЕКОН 200Г','',1.000,1,8,42.50,38.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10590',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('106',2,0,0,0,0,1,'ВОДА МИНЕРАЛЬНАЯ BORJOMI','',1.000,1,NULL,80.00,0.00,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'106',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1062',2,0,0,0,0,1,'ЗАМОРОЗКА РГ КЛУБНИКА 400Г','',1.000,1,8,76.90,69.21,NULL,1.000,NULL,0,0,15,3,1,1,1,NULL,NULL,NULL,NULL,'1062',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1067',2,0,0,0,0,1,'ПРИПРАВА ПРИПРАВЫЧ ДЛЯ ПЕРВЫХ БЛЮД 15Г','',1.000,1,8,6.50,5.85,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1067',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1070',2,0,0,0,0,1,'ЧАЙ ПРИНЦЕССА КАНДИ ЦЕЙЛОНСКИЙ 25ПАК.','',1.000,1,8,20.80,18.72,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'1070',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1072',2,0,0,0,0,1,'ЧАЙ ПРИНЦЕССА ГИТА 25ПАК. С/Я','',1.000,1,8,17.70,15.93,NULL,1.000,NULL,0,0,15,3,0,1,5,NULL,NULL,NULL,NULL,'1072',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10770',2,0,0,0,0,1,'ТВОРОЖНЫЙ ПРОДУКТ ДАНОН АКТИВИЯ МЮСЛИ 130Г','',1.000,1,8,26.90,24.21,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10770',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('1094',2,NULL,NULL,NULL,NULL,1,'МУКА МАРИЯ В/С ГОСТ 1КГ','',1.000,1,NULL,15.90,14.31,NULL,1.000,NULL,0,0,15,3,0,1,5,NULL,NULL,NULL,NULL,'1094',NULL,NULL,NULL,NULL,NULL,NULL,0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10941',2,0,0,0,0,1,'ПРЯНИК 6 МУ-МУ СО СГУЩЕНКОЙ 410Г','',1.000,1,8,30.70,27.63,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10941',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('10984',2,0,0,0,0,1,'ПРИПРАВА МАГГИ БУЛЬОН ЗОЛОТОЙ КУРИНЫЙ 10Г','',1.000,1,8,2.50,2.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'10984',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11',3,0,0,0,0,1,'ВАРЕНЕЦ БМК 2.5% 450Г ПЮР/ПАК','',1.000,1,8,20.90,18.81,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11200',2,0,0,0,0,1,'КРУПА МАРИЯ ФАСОЛЬ 700Г','',1.000,1,8,47.90,43.11,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11200',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11228',2,0,0,0,0,1,'ТОРТ ДЮЖИНА ЧЕРЕМУХОВЫЙ 800Г','',1.000,1,8,273.50,246.15,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11228',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11240',2,0,0,0,0,1,'ТОРТ ДЮЖИНА ЗЛАТА ПРАГА 800Г','',1.000,1,8,226.50,203.85,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11240',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11242',2,0,0,0,0,1,'ТОРТ ДЮЖИНА МАННА НЕБЕСНАЯ 800Г','',1.000,1,8,216.80,195.12,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11242',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11247',2,0,0,0,0,1,'ТОРТ ДЮЖИНА ЛЮБИМЫЙ 800Г','',1.000,1,8,241.00,216.90,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11247',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11336',2,0,0,0,0,1,'ДИАБЕТИКА ШОКОЛАД НА ФРУКТОЗЕ КЛАССИЧ. ГОРЬКИЙ 100Г','',1.000,1,8,60.40,54.36,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11336',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('11338',2,0,0,0,0,1,'ДИАБЕТИКА ШОКОЛАД НА ФРУКТОЗЕ С ОРЕХОМ 100Г','',1.000,1,8,60.40,54.36,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'11338',NULL,NULL,NULL,NULL,NULL,'0',0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('123456',NULL,NULL,NULL,NULL,NULL,NULL,'Сертификат',NULL,0.000,NULL,NULL,5000.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,0,0,NULL,NULL,NULL,NULL,NULL,'123456',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2010',2,0,0,0,0,1,'Водка \"Absolut\" 40%,0.7 л',NULL,1.000,1,8,969.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,224,0,NULL,NULL,NULL,NULL,NULL,'2010',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,18,40.00,NULL,NULL,NULL,NULL,NULL,NULL,300.00,NULL,NULL,NULL),('2011',2,0,0,0,0,1,'Коньяк Camus VS Elegance 0.7 л с 2 бокалами 0.7 л',NULL,1.000,1,8,3500.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,1024,0,NULL,NULL,NULL,NULL,NULL,'2011',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,21,40.00,NULL,NULL,NULL,NULL,NULL,NULL,300.00,NULL,NULL,NULL),('2012',2,0,0,0,0,1,'СИГАРЕТЫ ВИНСТОН БЛЮ (WINSTON BLUE)',NULL,1.000,1,0,168.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,32864,0,16,NULL,NULL,NULL,NULL,'2012',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,110.00,NULL,NULL,NULL),('2013',2,NULL,NULL,NULL,NULL,1,'Кроссовки STRUTTER CBLACK/CBLACK/GRESIX',NULL,1.000,1,NULL,3229.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'2013',1,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2014',2,0,0,0,0,1,'Цитрамон П табл. №10',NULL,1.000,1,8,20.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'2014',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2015',2,0,0,0,0,1,'Маска трехслойная на резинке 50 шт, черная',NULL,1.000,1,8,350.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'2015',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2016',2,0,0,0,0,1,'Автошина зимняя, 205/55 R16 Bridgestone Blizzak VRX 91S',NULL,1.000,1,8,5120.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,NULL,NULL,NULL,'2016',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2017',2,0,0,0,0,1,'Сигареты \"Marlboro\", красные',NULL,1.000,1,8,178.57,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,4,NULL,NULL,NULL,NULL,'2017',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2018',2,0,0,0,0,1,'Пиво барнаульское',NULL,1.000,12,8,110.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,2,NULL,NULL,'2018',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2019',2,0,0,0,0,1,'Бутылка 1 л',NULL,1.000,1,8,10.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,1,NULL,1.000,'2019',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('2020',2,0,0,0,0,1,'Бутылка 1.5 л',NULL,1.000,1,8,11.00,0.00,NULL,1.000,0.000,NULL,NULL,0,3,NULL,0,NULL,NULL,1,NULL,1.500,'2020',NULL,NULL,NULL,NULL,NULL,NULL,0.000,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('46047014',2,0,0,0,0,1,'ПРИПРАВА МАГГИ БУЛЬОН ЗОЛОТОЙ КУРИНЫЙ 10Г','',1.000,1,8,2.50,2.25,NULL,1.000,NULL,0,0,15,3,0,1,1,NULL,NULL,NULL,NULL,'46047014',NULL,NULL,NULL,NULL,NULL,NULL,0.000,'2011-11-21 10:22:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Dumping data for table `tmc2`
--


--
-- Dumping data for table `tmcalcocode1`
--


--
-- Dumping data for table `tmcalcocode2`
--


--
-- Dumping data for table `tmccatalog1`
--


--
-- Dumping data for table `tmccatalog2`
--


--
-- Dumping data for table `tmcext1`
--


--
-- Dumping data for table `tmcext2`
--


--
-- Dumping data for table `tmcgroups1`
--


--
-- Dumping data for table `tmcgroups2`
--


--
-- Dumping data for table `tmckit1`
--


--
-- Dumping data for table `tmckit2`
--


--
-- Dumping data for table `tmckititem1`
--


--
-- Dumping data for table `tmckititem2`
--


--
-- Dumping data for table `tmclink1`
--


--
-- Dumping data for table `tmclink2`
--


--
-- Dumping data for table `tmcrequiredquantity1`
--


--
-- Dumping data for table `tmcrequiredquantity2`
--


--
-- Dumping data for table `tmcsalerestrict1`
--


--
-- Dumping data for table `tmcsalerestrict2`
--


--
-- Dumping data for table `tmcsupplier1`
--


--
-- Dumping data for table `tmcsupplier2`
--


--
-- Dumping data for table `tmcvisualverify1`
--


--
-- Dumping data for table `tmcvisualverify2`
--


--
-- Dumping data for table `tmpshortgoodslist`
--


--
-- Dumping data for table `tostat1`
--


--
-- Dumping data for table `tostat2`
--


--
-- Dumping data for table `tprices1`
--

REPLACE INTO `tprices1` (`tindex`, `bcode`, `price`, `name`, `documentid`, `effectivedate`, `packingprice`) VALUES (1,'1072',10.00,'Доп цена 1',NULL,'2020-10-11 15:19:16',NULL),(1,'1094',50.00,'Доп. цена 1',NULL,'2024-05-22 09:59:04',NULL),(1,'2017',170.00,'цена1','1','0000-00-00 00:00:00',NULL),(2,'1072',15.00,'Доп цена 2',NULL,'2020-10-11 15:19:37',NULL),(2,'1094',60.00,'Доп. цена 2',NULL,'2024-05-22 09:59:28',NULL),(2,'2017',180.00,'цена2','1','0000-00-00 00:00:00',NULL),(3,'1072',20.00,'Доп цена 3',NULL,'2020-10-11 15:19:48',NULL),(3,'1094',80.00,'Доп. цена 3',NULL,'2024-05-22 09:59:37',NULL),(4,'1072',25.00,'Доп цена 4',NULL,'2020-10-11 15:20:02',NULL);

--
-- Dumping data for table `tprices2`
--


--
-- Dumping data for table `tquick1`
--


--
-- Dumping data for table `tquick2`
--


--
-- Dumping data for table `units1`
--

REPLACE INTO `units1` (`code`, `name`, `flag`, `frunit`) VALUES (1,'шт.',0,0),(2,'г',0,10),(3,'кг',1,11),(4,'т',1,12),(5,'см',0,20),(6,'дм',0,21),(7,'м',1,22),(8,'кв. см',0,30),(9,'кв. дм',0,31),(10,'кв. м',1,32),(11,'мл',0,40),(12,'л',1,41),(13,'куб. м',0,42),(14,'кВт · ч',0,50),(15,'Гкал',0,51),(16,'сутки',0,70),(17,'час',0,71),(18,'мин',0,72),(19,'с',0,73),(20,'Кбайт',0,80),(21,'Мбайт',0,81),(22,'Гбайт',0,82),(23,'Тбайт',0,83),(24,'-',0,255);

--
-- Dumping data for table `units2`
--


--
-- Dumping data for table `valut1`
--

REPLACE INTO `valut1` (`code`, `stat`, `chr`, `name`, `type`, `rate`, `ratecb`, `decpoint`, `round`, `mode`, `drawer`, `discascheme`, `ishidden`, `operation`, `payprocmodule`, `merchantid`, `payprocdir`) VALUES (1,2,'Руб','Российский рубль','1',1.0000,1.0000,-2,2,0,1,0,0,0,NULL,NULL,NULL),(2,0,'СБ','СберБанк','2',1.0000,1.0000,-2,2,6,0,0,0,10,'libProcessingSb',NULL,NULL),(3,0,'АТ','Автономный терминал','2',1.0000,1.0000,-2,2,6,0,NULL,0,10,'libProcessingDummy',NULL,NULL),(4,0,'Райф','СБП Райффайзен','2',1.0000,1.0000,-2,1,6,0,0,0,10,'libProcessingRaiffeisenSbp',NULL,NULL);

--
-- Dumping data for table `valut2`
--


--
-- Dumping data for table `vat1`
--

REPLACE INTO `vat1` (`code`, `name`, `rate`, `mode`) VALUES (1,'НДС 0%',0.00,NULL),(2,'НДС 10%',10.00,NULL),(3,'НДС 20%',20.00,NULL),(4,'НДС 10/110',10.00,NULL),(5,'НДС 20/120',20.00,NULL),(6,'БЕЗ НДС',NULL,NULL);

--
-- Dumping data for table `vat2`
--


--
-- Dumping data for table `verification1`
--


--
-- Dumping data for table `verification2`
--



