delete from category_group_table;
delete from category_table;
delete from follow_table;
delete from menu_table;
delete from config_cmd_table;
delete from spec_group_table;
delete from spec_op_table;
delete from spec_table; 
delete from cust_type_table;


INSERT INTO `category_group_table` (`CategoryGroupID`, `L1`, `L2`, `IsShow`, `Weight`, `Remark`, `CreateTime`, `Type`, `OnlineShowFlag`, `OnlineLang`) VALUES (1,'Menu','Menu',0,999999,NULL,'2018-11-08',0,0,'');
INSERT INTO `category_table` (`CategoryID`, `L1`, `L2`, `CategoryGroupID`, `IsShow`, `FollowItemGroupID`, `Weight`, `Remark`, `CreateTime`, `Type`, `BottonColor`, `OnlineShowFlag`, `OnlineLang`, `TimeGroupID`, `Picurl`) VALUES (89,'Ingredients','辅料',1,0,'',1,NULL,'2018-11-14',0,'',0,NULL,0,NULL);
INSERT INTO `config_cmd_table` (`ID`, `L1`, `L2`, `LogoUrl`, `FunGroup`, `Cmd`, `Weight`, `RightType`, `IsShow`, `CreateTime`, `IsMain`, `DoubleCheck`) VALUES (1,'Discount','打折','images/blackIcon/icon_discount.png','paymentfun','discount',0,0,0,'2018-05-10',0,0),(2,'Service Charge','服务费','images/blackIcon/icon_tip.png','paymentfun','tip',0,0,0,'2018-05-10',0,0),(3,'VIP','VIP','images/blackIcon/icon_vip.png','paymentfun','vip',0,0,1,'2018-05-10',0,0),(4,'Pay Split','分单','images/blackIcon/icon_split.png','paymentfun','paysplit',0,1,0,'2018-05-10',1,0),(5,'Change Type','类型','images/menuIcon/icon_custtype.png','menurightfun','changetype',12,0,0,'2018-05-10',0,0),(6,'Cook Time','时间','images/menuIcon/icon_date.png','menurightfun','setcooktime',10,0,0,'2018-05-10',0,0),(7,'Discount','折扣','images/menuIcon/icon_discount.png','menurightfun','discount',9,0,0,'2018-05-10',0,0),(8,'Split','分隔符','images/menuIcon/icon_split2.png','menurightfun','split',7,0,0,'2018-05-10',0,0),(9,'Change Price','改价','images/menuIcon/icon_changeprice.png','menurightfun','changeprice',8,0,0,'2018-05-10',0,0),(10,'Self Input','其他','images/menuIcon/icon_changeprice.png','menurightfun','selfinput',4,0,0,'2018-05-10',0,0),(11,'中文','English','images/menuIcon/icon_lang.png','menurightfun','changelang',2,0,0,'2018-05-10',0,0),(12,'Resume','恢复','images/menuIcon/icon_resume.png','menurightfun','resume',3,0,0,'2018-05-10',0,0),(13,'Exit','退出','images/menuIcon/icon_exit.png','menurightfun','exit',1,0,0,'2018-05-10',0,0),(14,'Remove/-','减少/-','','menunumfun','less',0,0,0,'2018-05-10',0,0),(15,'Add/+','增加/+','','menunumfun','add',0,0,0,'2018-05-10',0,0),(16,'Quantity','数量','','menunumfun','num',0,0,0,'2018-05-10',0,0),(17,'Save','存单','images/icon/icon_orderlist.png','menumainfun','save',0,0,0,'2018-05-10',0,0),(18,'Payment','付款','images/icon/icon_payment.png','menumainfun','payment',0,0,0,'2018-05-10',0,0),(19,'Send/Print','送厨','images/icon/icon_send.png','menumainfun','send',0,0,0,'2018-05-10',0,0),(20,'Modify','修改','images/icon/icon_update.png','orderlistmainfun','modify',13,0,0,'2018-05-10',0,0),(21,'Send&Print','打印','images/icon/icon_print1.png','orderlistmainfun','print',12,0,0,'2018-05-10',0,0),(22,'Payment','付款','images/icon/icon_payment.png','orderlistmainfun','payment',11,0,0,'2018-05-10',0,1),(23,'Tip','小费','images/icon/icon_tip.png','orderlistmainfun','tip',10,0,0,'2018-05-10',0,0),(24,'Void Order','取消订单','images/icon/icon_cancelorder.png','orderlistmainfun','voidorder',9,2,0,'2018-05-10',0,1),(25,'Void Pay.','取消付款','images/icon/icon_cancelpayment.png','orderlistmainfun','voidpayment',8,1,0,'2018-05-10',0,1),(26,'Set Driver','设定司机','images/icon/icon_driver.png','orderlistmainfun','setdriver',7,0,0,'2018-05-10',0,0),(27,'Print Sum.','打印日报','images/icon/icon_summary.png','orderlistmainfun','printsummary',6,2,0,'2018-05-10',0,0),(28,'Print List','打印列表','images/icon/icon_print1.png','orderlistmainfun','printlist',5,2,0,'2018-05-10',0,0),(29,'Map','地图','images/icon/icon_map.png','orderlistmainfun','map',4,0,1,'2018-05-10',0,0),(30,'中文','English','images/menuIcon/icon_lang.png','orderlistmainfun','changelang',3,0,0,'2018-05-10',0,0),(31,'Exit','退出','images/menuIcon/icon_exit.png','orderlistmainfun','exit',1,0,0,'2018-05-10',0,0),(32,'List All','全部','','orderlistqueryfun','listall',10,0,0,'2018-05-10',0,0),(33,'List By Date','按日期列出','','orderlistqueryfun','listbydate',9,0,0,'2018-05-10',0,0),(34,'List By Server','按服务员列出','','orderlistqueryfun','listbyserver',8,0,0,'2018-05-10',0,0),(35,'List Unpaid Only','列出未支付','','orderlistqueryfun','listunpaidonly',6,0,0,'2018-05-10',0,0),(36,'List By Driver','按司机列出','','orderlistqueryfun','listbydriver',7,0,0,'2018-05-10',0,0),(40,'More','更多','images/icon/icon_update.png','userinfomainfun','more',0,0,0,'2018-05-11',0,0),(41,'Type','类型','images/menuIcon/icon_custtype.png','userinfomainfun','changetype',0,0,0,'2018-05-11',0,0),(42,'Map','地图','images/icon/icon_map.png','userinfomainfun','map',0,0,0,'2018-05-11',0,0),(43,'Resume','恢复','images/menuIcon/icon_resume.png','userinfomainfun','clear',0,0,0,'2018-05-11',0,0),(44,'Cancel','取消','images/menuIcon/icon_exit.png','userinfomainfun','cancel',0,0,0,'2018-05-11',0,0),(45,'OK','确定','images/icon/icon_orderlist.png','userinfomainfun','ok',0,0,0,'2018-05-11',1,0),(46,'Modify','修改','images/icon/icon_update.png','tableinfomainfun','modify',0,0,0,'2018-06-06',0,0),(47,'Print','打印','images/icon/icon_print1.png','tableinfomainfun','print',0,0,0,'2018-06-06',0,0),(48,'Payment','付款','images/icon/icon_payment.png','tableinfomainfun','payment',0,0,0,'2018-06-06',0,0),(49,'Close','关闭','images/menuIcon/icon_exit.png','tableinfomainfun','close',0,0,0,'2018-06-06',0,0),(50,'Change Table','更改餐桌','','tableinfotablefun','changetable',0,0,0,'2018-06-06',0,0),(51,'Clear Table','清除餐桌','','tableinfotablefun','cleartable',0,0,0,'2018-06-06',0,0),(52,'Add New Guest','加新客人','','tableinfotablefun','addnewguest',0,0,0,'2018-06-06',0,0),(53,'Add More Tables','加新桌子','','tableinfotablefun','addnewtable',0,0,0,'2018-06-06',0,0),(54,'Change Server','更改侍者','','tableinfotablefun','changeserver',0,0,0,'2018-06-06',0,0),(55,'Split Table','分桌','','tableinfotablefun','splittable',0,0,0,'2018-06-06',0,0),(56,'Gift Card','礼品卡','images/icon/icon_giftcard.png','menurightfun','giftcard',6,1,1,'2018-06-19',0,0),(57,'Delivery','外卖费','images/icon/icon_delivery.png','menurightfun','deliverycharge',5,0,0,'2018-06-24',0,0),(58,'List Paid','列出已付款','','orderlistqueryfun','listpaid',5,0,0,'2018-07-23',0,0),(59,'List Printed','列出已打印','','orderlistqueryfun','listprinted',4,0,0,'2018-07-23',0,0),(60,'LIst void','列出已取消','','orderlistqueryfun','listvoided',1,0,0,'2018-07-23',0,0),(61,'List By PayType','按付款方式','','orderlistqueryfun','listbypaytype',2,0,0,'2018-07-23',0,0),(62,'LIst Un Print','列出未打印','','orderlistqueryfun','listunprinted',3,0,0,'2018-07-23',0,0),(63,'Cust Info','资料','images/icon/icon_summary.png','menurightfun','custinfo',11,0,1,'2018-08-03',0,0),(64,'Change Server','服务员','images/menuIcon/icon_custtype.png','menurightfun','changeserver',13,0,1,'2018-09-21',0,0),(65,'Order List','订单','images/icon/icon_orderlist.png','menurightfun','orderlist',14,0,1,'2018-09-26',0,0),(66,'Quick Pay','快捷付款','images/icon/icon_pay.png','orderlistmainfun','allcashpay',2,2,0,'2018-10-18',0,0);
INSERT INTO `cust_type_table` (`CustType`, `L1`, `L2`, `LogoUrl`, `PreFun`, `IsNoTax`, `MenuID`, `CreateTime`, `Weight`, `IsShow`, `Type`, `DeliveryCharge`, `PrintAddr`, `PrintServer`, `OnlyPrintPhone`, `PrintSelect`, `ShowMode`, `DefaultGroupID`, `DefaultCategoryID`, `FunPrintCopy`, `NeedDelivery`, `ServiceCharge`, `ServiceCustNo`, `QuickPayShow`, `DeliveryChargeMin`, `AutoPrint`, `SelfFlag`) VALUES (2,'Pick Up','来取','images/icon/icon_pickup.png',1,0,NULL,'2018-04-10',11,0,2,0,0,1,0,1,0,NULL,NULL,1,0,0.00,0,0,1000000000,0,0),(3,'Delivery','外卖','images/icon/icon_delivery.png',1,0,NULL,'2018-04-10',10,0,2,0,0,1,0,1,1,NULL,NULL,1,1,0.00,0,0,1000000000,0,0),(4,'Walk In','外等','images/icon/icon_drink.png',0,0,NULL,'2018-04-10',12,0,2,0,0,1,0,1,0,NULL,NULL,1,0,0.00,0,0,1000000000,0,0),(7,'Gift Card','礼品卡','images/icon/icon_giftcard.png',3,0,NULL,'2018-06-25',3,1,1,0,1,1,0,1,0,NULL,NULL,1,0,0.00,0,0,1000000000,0,0),(8,'Online Delivery','在线送餐','images/icon/icon_send.png',1,0,NULL,'2019-04-22',2,1,2,0,0,0,0,0,1,NULL,NULL,1,1,0.00,0,0,99999999,0,0),(9,'Online Pick Up','在线来取','images/icon/icon_cancelorder.png',1,0,NULL,'2019-04-22',1,1,2,0,0,0,0,0,1,NULL,NULL,1,0,0.00,0,0,99999,0,0);
INSERT INTO `follow_table` (`FollowID`, `FollowGroupID`, `ItemNo`, `L1`, `L2`, `Price`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`, `FollowItemType`, `BottonColor`, `Commission`, `OnlineShowFlag`, `OnlineLang`, `Picurl`, `PrintMode`, `CountGroupID`) VALUES (1,'10','101','M','M',0,1,0,'9',0,0,0,NULL,'2018-11-08',1,'',0,0,NULL,NULL,0,0),(2,'10','103','L','L',0,1,0,'9',0,0,0,NULL,'2018-11-08',1,'',0,0,NULL,NULL,0,0),(192,'101','1011','Hot','Hot',0,1,0,'9',0,0,0,NULL,'2018-11-08',0,'',0,0,NULL,NULL,0,0),(193,'101','1031','Cold','Cold',0,1,0,'9',0,0,0,NULL,'2018-11-08',0,'',0,0,NULL,NULL,0,0),(414,'101','1011','Regular Sugar','',0,1,0,'9',0,0,0,NULL,'2019-02-22',0,'',0,0,NULL,NULL,0,0),(415,'101','1011','30% Sugar','',0,1,0,'9',0,0,0,NULL,'2019-02-22',0,'',0,0,NULL,NULL,0,0),(416,'101','1011','50% Sugar','',0,1,0,'9',0,0,0,NULL,'2019-02-22',0,'',0,0,NULL,NULL,0,0),(417,'101','1011','70% Sugar','',0,1,0,'9',0,0,0,NULL,'2019-02-22',0,'',0,0,NULL,NULL,0,0);
INSERT INTO `menu_table` (`MenuID`, `CategoryID`, `ItemNo`, `L1`, `L2`, `Price1`, `Price2`, `Price3`, `Price4`, `Price5`, `Price6`, `Price7`, `Price8`, `Price9`, `Price10`, `FollowGroupID`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`, `MutliSelect`, `CountGroupID`, `LunchDinnerShow`, `BottonColor`, `WithItem`, `StoreNum`, `Commission`, `FollowGroupID2`, `MutliSelect2`, `FollowGroupID3`, `MutliSelect3`, `FollowGroupID4`, `MutliSelect4`, `FollowGroupID5`, `MutliSelect5`, `FollowGroupID6`, `MutliSelect6`, `FollowGroupID7`, `MutliSelect7`, `FollowGroupID8`, `MutliSelect8`, `OnlineShowFlag`, `OnlineLang`, `NewFlag`, `HotFlag`, `HotLevel`, `LabelInfo`, `Picurl`, `GroupMode`, `FGroupMenuID`) VALUES (11504,89,'I01','Bubble ','珍珠',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11505,89,'I02','Red Bean','红豆',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11506,89,'I03','Jelly','果冻',75,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2018-11-14',999,0,0,'','',-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,0,0,NULL,NULL,0,NULL),(11507,89,'null04','Oreo Cookies','奥利奥饼干',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11508,89,'I05','Milk','牛奶',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11509,89,'I06','White Sugar','白糖',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11510,89,'I07','Cream Cheese','芝士奶油',50,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11511,89,'I08','-------','',0,0,0,0,0,0,0,0,0,0,'',0,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11512,89,'I09','Watermelon','西瓜',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11513,89,'I10','Pineapple','菠萝',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11514,89,'I11','Blueberries','蓝莓',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11515,89,'I12','Mango','芒果',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11516,89,'I13','Papaya','木瓜',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11517,89,'I14','Banana','香蕉',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11518,89,'I15','Avocado','奶油果',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11519,89,'I16','Lime','青柠檬',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11520,89,'I17','Yellow Lomon','黄柠檬',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11521,89,'I18','Orange','橙',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11522,89,'I19','Red Pomelo','红柚子',100,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-18',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11523,89,'I19','more ice','多冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11524,89,'I19','less ice','少冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11525,89,'I19','more Sugar','多糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11526,89,'I19','less Sugar','少糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-22',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11527,89,'I19','no ice','去冰',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11528,89,'I19','No sugar','不要糖',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11529,89,'I19','no bubble','不要珍珠',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11530,89,'I19','add cream','加奶盖',75,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11531,89,'I19','No jelly','不要果冻',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11532,89,'I19','no red bean','不要红豆',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-24',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11535,89,'I19','Fruit tea bag','鲜果森林乌龙',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11536,89,'I19','Osmanthus Oolong tea','金票乌龙',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11537,89,'I19','four season tea','高山青茶',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11538,89,'I19','Dark Oolong tea','太极红岩',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11539,89,'I19','jasmine tea','红颜茉莉',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL),(11540,89,'I19','Oolong tea','金贵乌龙 ',0,0,0,0,0,0,0,0,0,0,'',1,0,'0',0,0,0,NULL,'2019-02-26',999,0,0,'','',-1,0,'',999,'',999,'',999,'',999,'',999,'',999,'',999,0,NULL,0,0,0,NULL,NULL,0,NULL);
INSERT INTO `spec_group_table` (`SpecGroupID`, `L1`, `L2`, `Weight`, `Remark`, `CreateTime`) VALUES (8,'TASTE','味 道',999999,NULL,'2018-11-08'),(9,'VEGETABLE','菜 类',999999,NULL,'2018-11-08'),(10,'MEAT','肉 类',999999,NULL,'2018-11-08'),(11,'Other /Appetizers','其它/ 头台',999999,NULL,'2018-11-08');
INSERT INTO `spec_op_table` (`ID`, `L1`, `L2`, `Weight`, `Remark`, `CreateTime`) VALUES (1,'No','不要',0,NULL,'2018-11-08'),(2,'Little','少',0,NULL,'2018-11-08'),(3,'With','要',0,NULL,'2018-11-08'),(4,'Only','只要',0,NULL,'2018-11-08'),(5,'Extra',' 多',0,NULL,'2018-11-08'),(6,'On the Side','分装',0,NULL,'2018-11-08'),(7,'Free','免费',0,NULL,'2018-11-08'),(12,'Well Done','多煮',0,NULL,'2018-11-08'),(13,'Rare','少煮',0,NULL,'2018-11-08');
INSERT INTO `spec_table` (`FollowID`, `SpecGroupID`, `ItemNo`, `L1`, `L2`, `Price`, `isMain`, `PriceMode`, `Printer`, `IsNoTax`, `IsDiscount`, `Weight`, `Remark`, `CreateTime`) VALUES (1,'10','M4','Chicken','鸡肉',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(2,'10','M03','Pork','叉烧',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(3,'10','M8','Shrimp','虾',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(4,'10','M5','Beef','牛肉',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(5,'10','M9','Baby Shrimp','虾仁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(6,'10','M6','Scallop','干贝',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(7,'10','M10','Crab Meat','蟹肉',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(8,'10','M11','Lobster','龙虾',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(9,'10','M3','Shredded Pork','肉丝',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(10,'8','T10','Black Bean Sauce','豆豉汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(11,'8','T11','Brown Sauce','黑汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(12,'8','T28','BBQ Sauce','BBQ汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(13,'8','T15','Curry Sauce','咖哩汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(14,'8','T18','Duck Sauce','酸梅酱',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(15,'8','T25','Egg Foo Gravy','蓉蛋汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(16,'8','T13','Garlic Sauce','鱼香汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(17,'8','T16','General Tso\'s Sauce','左宗汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(18,'8','T20','Ginger Sauce','姜汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(19,'8','T17','Hoisin Sauce','海鲜酱',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(20,'8','T7','Honey','蜜汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(21,'8','T21','Hot Oil','辣椒油',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(22,'8','T23','Hunan Sauce','湖南汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(23,'8','T29','Kung Pao Sauce','宫保汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(24,'8','T3','MSG','味精',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(25,'8','T19','Mustard','芥末',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(26,'8','T4','Oil','油',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(27,'8','T04','Orange Sauce','陈皮汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(28,'8','T1','Spicy','辣',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(29,'8','T5','Salt','盐',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(30,'8','T6','Sugar','糖',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(31,'8','T9','Steamed','水煮',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(32,'8','T14','Sesame Sauce','芝麻汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(33,'8','T22','Soy Sauce','酱油',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(34,'9','V06','Broccoli','芥兰',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(35,'9','V14','Cabbage','白菜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(36,'9','V20','Carrot','胡萝卜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(37,'9','V17','Snow Peas','雪豆',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(38,'9','V23','Bamboo Shoot','笋片',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(39,'9','V191','Baby Corn','玉米',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(40,'9','V08','Mushroom','蘑枯',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(41,'9','V09','Straw Mushroom','草菰',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(42,'9','V02','Onion','洋葱',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(43,'9','V03','Scallion','青葱',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(44,'9','V24','Bean Sprout','芽菜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(45,'9','V10','Green Pepper','青椒',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(46,'9','V04','Garlic','蒜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(47,'9','V18','String Bean','四季豆',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(48,'9','T42','Eggplant','茄子',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(49,'9','V21','Celery','芹菜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(50,'9','V22','Water Chestnut','马蹄',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(51,'9','V15','Peas','青豆',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(52,'9','V05','Ginger','姜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(53,'9','V28','Tofu','豆腐',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(54,'9','V01','Vegetable','菜',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(57,'11','O03','Fork','叉子',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(58,'11','O04','Spoon','汤匙',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(59,'11','O02','Chopstick','筷子',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(60,'11','O01','Plate','盘子',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(61,'11','O05','Napkin','纸巾',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(62,'11','T49','Fortune Cookies','签语饼',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(63,'11','T46','Small Dry Noodle','小面干',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(64,'11','T50','Well Done','要煮熟',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(65,'11','T63','Middle Well','要半生',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(66,'11','T61','Steamed','水煮',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(67,'11','T59','Slice','要片',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(68,'11','T60','Shredded','要丝',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(69,'10','M13','Duck','鸭',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(70,'10','M1','White Meat','白肉',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(71,'11','T62','Cut half','切半',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(72,'10','M2','Dark Meat','黑肉',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(73,'11','T58','206','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(74,'11','O11','Pancakes','木须皮',100.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(75,'11','T64','Wonton','云吞',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(76,'11','T48','Extra Duck Sauce','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(77,'11','T51','Extra Soy Sauce','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(78,'11','T52','Extra Mustard','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(79,'8','T24','Sweet Sour Sauce','甜酸汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(80,'8','T26','Szechuan Sauce','四川汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(81,'9','V19','Peanut','花生',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(82,'11','T53','Extra Hot Sauce','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(83,'11','T54','H.M Duck Sauce','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(84,'11','T55','H.M Mustard','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(85,'9','V25','Cashew Nut','腰果',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(86,'9','V34','Almond','杏仁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(87,'9','V35','Walnut','核桃',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(88,'9','V16','Orange Peel','陈皮',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(89,'9','V12','Chili Pepper','辣椒',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(90,'9','V26','Tomato','蕃茄',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(91,'11','T56','Dumpling Sauce','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(92,'8','T27','Teriyaki Sauce','烧烤汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(93,'11','T57','Hot Oil','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(94,'8','T12','White Sauce','白汁',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(95,'8','T30','Dark','加黑',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(96,'8','T31','Thicker Sauce','要杰胡',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(97,'11','T65','Hoisin Sauce','海鲜酱',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(98,'11','T66','Extra Ketchup','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(99,'10','M02','Egg','蛋',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(100,'9','V27','','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08'),(101,'11','T67','PEANUT SAUCE','',0.00,0,0,'9',0,0,999999,NULL,'2018-11-08');