<![CDATA[
delete from botton_main_table;
INSERT INTO `botton_main_table` (`BottonID`, `L1`, `L2`, `LogoUrl`, `Type`, `Method`, `Weight`, `RightType`, `CreateTime`, `IsShow`, `DoubleCheck`) VALUES (10,'Open Drawer','钱箱','images/icon/icon_cashdraw.png',1,'openCashDraw',9,1,'2018-04-02',0,0),(11,'Order List','订单列表','images/icon/icon_orderlist.png',2,'orderList.html',13,0,'2018-04-10',0,0),(12,'中文','English','images/menuIcon/icon_lang.png',1,'changeLang',3,0,'2018-04-12',0,0),(13,'Map','地图','images/icon/icon_map.png',1,'openMap',6,0,'2018-04-12',1,0),(14,'Send / Print','打印','images/icon/icon_print1.png',2,'sendprint.html',11,0,'2018-04-12',1,0),(15,'Report','报表','images/icon/icon_summary.png',2,'report/index.html',8,3,'2018-04-12',0,0),(16,'Payment','付款','images/icon/icon_pay.png',2,'payment.html',12,1,'2018-04-12',0,0),(17,'Batch','信用卡','images/icon/icon_batch.png',2,'batch.html',7,2,'2018-04-12',0,0),(18,'Manage','设置','images/icon/icon_manager.png',2,'setting/index.html',2,3,'2018-04-12',0,0),(19,'Time Clock','签到','images/icon/icon_timeclock.png',1,'doSignIn',5,0,'2018-04-12',1,0),(20,'Shut Down','关机','images/icon/icon_shutdown.png',1,'shutdown',1,0,'2018-04-12',1,0),(21,'VIP','VIP','images/icon/icon_vip.png',1,'querygiftcard',4,0,'2018-07-20',1,0),(22,'Modify','修改','images/icon/icon_orderlist.png',2,'modify.html',10,0,'2018-08-10',1,0),(23,'Remote','远程协助','images/icon/icon_remote.png',3,'AnyDesk.exe',0,2,'2018-09-29',0,0),(24,'Cash In/Out','Cash In/Out','images/icon/icon_cashdraw.png',1,'cashinout',0,1,'2019-02-02',1,0);
delete from common_conf_table;
INSERT INTO `common_conf_table` (`ID`, `GroupID`, `ShowDesc`, `Value`, `Status`, `CreateTime`, `Weight`, `RightType`) VALUES (1,1,'5%','5',0,'2018-07-12 14:49:24',2,0),(12,1,'10%','10',0,'2018-07-12 15:48:37',1,0),(13,3,'5%','5',0,'2018-07-12 15:54:20',0,0),(14,3,'10%','10',0,'2018-07-12 15:54:26',0,0),(15,3,'15%','15',0,'2018-07-12 15:54:33',0,0),(16,3,'20%','20',0,'2018-07-12 15:54:41',0,0),(17,4,'$5','5',0,'2018-07-12 15:55:02',0,0),(18,4,'$10','10',0,'2018-07-12 15:55:08',0,0),(19,4,'$15','15',0,'2018-07-12 15:55:15',0,0),(20,4,'$20','20',0,'2018-07-12 15:55:22',0,0),(21,4,'$25','25',0,'2018-07-12 15:55:29',0,0),(22,4,'$30','30',0,'2018-07-12 15:55:36',0,0),(23,4,'$35','35',0,'2018-07-12 15:55:46',0,0),(24,4,'$40','40',0,'2018-07-12 15:55:54',0,0),(25,4,'$45','45',0,'2018-07-12 15:56:00',0,0),(26,4,'$50','50',0,'2018-07-12 15:56:09',0,0),(27,1,'15%','15',0,'2018-07-12 15:56:34',0,0),(28,1,'20%','20',0,'2018-07-12 15:56:41',0,0),(29,2,'$5','5',0,'2018-07-12 16:37:11',0,0),(30,2,'$10','10',0,'2018-07-12 16:37:17',0,0),(31,2,'$15','15',0,'2018-07-12 16:37:23',0,0),(32,2,'$20','20',0,'2018-07-12 16:37:28',0,0),(33,2,'$25','25',0,'2018-07-12 16:37:37',0,0),(34,2,'$30','30',0,'2018-07-12 16:37:45',0,0),(35,2,'$35','35',0,'2018-07-12 16:37:52',0,0),(36,2,'$40','40',0,'2018-07-12 16:37:59',0,0),(37,2,'$45','45',0,'2018-07-12 16:38:06',0,0),(38,2,'$50','50',0,'2018-07-12 16:38:12',0,0),(55,5,'$5','500',0,'2019-04-23 14:55:05',8,0),(56,5,'$10','1000',0,'2019-04-23 14:55:05',7,0),(57,5,'$15','1500',0,'2019-04-23 14:55:05',6,0),(58,5,'$20','2000',0,'2019-04-23 14:55:05',5,0),(59,5,'$25','2500',0,'2019-04-23 14:55:05',4,0),(60,5,'$30','3000',0,'2019-04-23 14:55:05',3,0),(61,5,'$40','4000',0,'2019-04-23 14:55:05',2,0),(62,5,'$50','5000',0,'2019-04-23 14:55:05',1,0),(63,6,'$0.50','50',0,'2019-04-23 14:55:06',8,0),(64,6,'$1.00','100',0,'2019-04-23 14:55:06',7,0),(65,6,'$1.50','150',0,'2019-04-23 14:55:06',6,0),(66,6,'$2.00','200',0,'2019-04-23 14:55:06',5,0),(67,6,'$2.50','250',0,'2019-04-23 14:55:06',4,0),(68,6,'$3.00','300',0,'2019-04-23 14:55:06',3,0),(69,6,'$4.00','400',0,'2019-04-23 14:55:06',2,0),(70,6,'$5.00','500',0,'2019-04-23 14:55:06',1,0);
delete from config_cmd_table;
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,0,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,'Special Request','调味','images/menuIcon/icon_tw.png','menurightfun','specrequest',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);
delete from count_group_table;
INSERT INTO `count_group_table` (`CountGroupID`, `L1`, `L2`, `Status`, `CreateTime`) VALUES (1,'Drink','酒水',0,'2018-06-25 16:28:36'),(13,'Appetizers','头抬',0,'2018-06-26 08:30:00');
delete from cust_type_table;
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`) VALUES (1,'Dine In','堂吃','images/icon/icon_dinein.png',2,0,NULL,'2018-04-10',14,0,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,1000000000),(2,'Pick Up','来取','images/icon/icon_pickup.png',1,0,NULL,'2018-04-10',11,0,2,0,0,1,1,2,0,NULL,NULL,1,0,0,0,0,1000000000),(3,'Delivery','外卖','images/icon/icon_delivery.png',1,0,NULL,'2018-04-10',10,0,2,0,0,1,0,2,1,NULL,NULL,1,1,0,0,0,1000000000),(4,'Walk In','外等','images/icon/icon_walkin.png',0,0,NULL,'2018-04-10',12,0,2,0,0,1,0,2,0,NULL,NULL,1,0,0,0,0,1000000000),(5,'Buffet','自助餐','images/icon/icon_buffet.png',4,0,NULL,'2018-04-10',13,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,1000000000),(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,0,0,1000000000),(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,0,0,99999999),(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,0,0,99999),(10,'Seafood','海鲜','images/icon/icon_seafood.png',2,0,NULL,'2019-04-23',9,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,999999),(11,'Milk Tea','奶茶','images/icon/icon_drink.png',0,0,NULL,'2019-04-23',8,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,999999),(12,'Market','超市','images/icon/icon_market.png',1,0,NULL,'2019-04-23',5,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,9999999),(13,'Poke','Poke','images/icon/icon_poke.png',2,0,NULL,'2019-04-23',7,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,999999),(14,'Barbecue','烤肉','images/icon/icon_barbecue.png',2,0,NULL,'2019-04-23',6,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,999999),(15,'Nail','美甲','images/icon/icon_nail.png',0,0,NULL,'2019-04-23',4,1,1,0,0,0,0,0,0,NULL,NULL,1,0,0,0,0,999999);
delete from default_setting_group_table;
INSERT INTO `default_setting_group_table` (`GroupID`, `GroupName`, `CreateTime`) VALUES (1,'Printer','2018-05-22'),(2,'main','2018-06-15');
delete from default_setting_table;
INSERT INTO `default_setting_table` (`ID`, `HostName`, `SettingGroup`, `SettingDesc`, `SettingKey`, `SettingValue`, `ValueType`, `CreateTime`, `L1`, `L2`) VALUES (1,NULL,1,'第一语言字体','print_lang1_font','\"fzzyjt\"',0,'2018-10-16','First Lang. Font','第一语言字体'),(2,NULL,1,'第一语言字体大小','print_lang1_fontsize','16px',3,'2018-10-16','First Lang. Size','第一语言字体大小'),(3,NULL,1,'第二语言字体','print_lang2_font','\"fzzyjt\"',0,'2018-10-16','Second Lang. Font','第二语言字体'),(4,NULL,1,'第二语言字体大小','print_lang2_fontsize','18px',3,'2018-10-16','Second Lang. Size','第二语言字体大小'),(5,NULL,1,'特殊项粗体','print_spec_fontweight','1',1,'2018-10-16','Special Bold','特殊项粗体'),(6,NULL,1,'外卖地址字体大小','print_address_fontsize','16px',3,'2018-10-16','Address Font Size','外卖地址字体大小'),(7,NULL,1,'餐馆名称字体大小','print_restname_fontsize','18px',3,'2018-10-16','Name Font Size','餐馆名称字体大小'),(8,NULL,1,'菜品间距','print_item_margin','2px',8,'2018-10-16','Item Space','菜品间距'),(9,NULL,1,'单号字体大小','print_checkno_fontsize','18px',3,'2018-10-16','Order No. Font Size','单号字体大小'),(10,NULL,1,'总额字体大小','print_total_fontsize','20px',3,'2018-10-16','Total Font Size','总额字体大小'),(11,NULL,1,'总额是否粗体','print_total_fontweight','0',1,'2018-10-16','Total Bold','总额是否粗体'),(12,NULL,1,'预约时间粗体','print_cooktime_fontweight','0',1,'2018-10-16','AppointMent Bold','预约时间粗体'),(13,NULL,1,'打印特殊项的数量','print_spec_num','1',2,'2018-10-16','Print Special Qty','打印特殊项的数量'),(14,NULL,1,'是否打印数量','print_item_num','1',2,'2018-10-16','Print Qty','是否打印数量'),(15,NULL,1,'预约提示文字','print_cooktime_ts','出菜时间',0,'2018-10-16','AppointMent Word','预约提示文字'),(16,NULL,1,'预约自动打印','print_cooktime_autoprint','1',2,'2018-10-16','Auto Print','预约自动打印'),(17,NULL,1,'厨房预留空白','print_kitchen_space','0',2,'2018-10-16','Kitchen Head Space','厨房预留空白'),(18,NULL,1,'是否打印税率','print_taxrate','0',2,'2018-10-16','Print Tax Rate','是否打印税率'),(19,NULL,1,'是否打印更多信息','print_more_info','0',2,'2018-10-16','Print More Info','是否打印更多信息'),(20,NULL,1,'订单时间字体大小','print_ordertime_fontsize','14px',3,'2018-10-16','Order Time Font Size','订单时间字体大小'),(21,NULL,1,'是否打印客户类型','print_custtype','0',2,'2018-10-16','Print Cust Type','是否打印客户类型'),(22,NULL,1,'餐馆名称是否粗体','print_restname_fontweight','1',1,'2018-10-16','UTOP Bold','餐馆名称是否粗体'),(23,NULL,1,'餐馆信息字体大小','print_utop_fontsize','12px',3,'2018-10-16','UTOP FONT SIZE','餐馆信息字体大小'),(24,NULL,1,'客户类型字体大小','print_custtype_fontsize','16px',3,'2018-10-16','Cust Type Font Size','客户类型字体大小'),(25,NULL,1,'菜品打印顺序','print_item_seq',' ',0,'2018-10-16','Item Print Seq.','菜品打印顺序'),(26,NULL,1,'打印模式','print_test','1',11,'2018-10-16','Print Mode','打印模式'),(27,NULL,1,'打印收据前厨房必打','print_receipt_mustkitchen','0',2,'2018-10-16','Kitchen Must Print','打印收据前厨房必打'),(28,NULL,3,'税率','main_taxrate','8.75',0,'2018-10-16','Tax','税率'),(29,NULL,3,'税率2','main_taxrate2','10',0,'2018-10-16','Tax 2','税率2'),(30,NULL,2,'桌子修改权限','main_table_modify','1',4,'2018-10-16','Modify Table Right','桌子修改权限'),(31,NULL,3,'总计Adjust','main_total_adjust','0',5,'2018-10-16','Adjust','总计Adjust'),(32,NULL,2,'总计查看权限','main_orderlist_total_right','3',4,'2018-10-16','Total Right','总计查看权限'),(33,NULL,2,'查看所有订单权限','main_orderlist_allorder_right','1',4,'2018-10-16','All Order Right','查看所有订单权限'),(34,NULL,2,'菜单修改权限','main_menu_modify','3',4,'2018-10-16','Modify Menu Right','菜单修改权限'),(35,NULL,2,'右键修改权限','main_rightclick_right','4',4,'2018-10-16','Right Click Right','右键修改权限'),(36,NULL,5,'双屏显示','main_double_display','1',2,'2018-10-16','Double Display','双屏显示'),(37,NULL,5,'第二屏语言','main_second_lang','1',6,'2018-10-16','Second Screen Lang,','第二屏语言'),(38,NULL,5,'第二屏图片路径','main_second_imgpath','d://bgimg',0,'2018-10-16','Image Path','第二屏图片路径'),(39,NULL,5,'轮播间隔(毫秒)','main_second_time','5000',0,'2018-10-16','Pic. Swicth Time','轮播间隔(毫秒)'),(40,NULL,3,'休息时间','rest_middle_time','15:00',0,'2018-10-16','Rest Time','休息时间'),(41,NULL,3,'营业时间','rest_end_time','07:30',0,'2018-10-16','Bus. Time','营业时间'),(42,NULL,4,'分类背景颜色','main_category_bgcolor','rgba(0,0,0,0.5)',9999,'2018-10-16','Category BG','分类背景颜色'),(43,NULL,4,'分类边框颜色','main_category_bordercolor','#FFF',0,'2018-10-16','Category Border','分类边框颜色'),(44,NULL,4,'分类空白背景颜色','main_category_fitbgcolor','rgba(0,0,0,0.5)',0,'2018-10-16','Category Blank BG','分类空白背景颜色'),(45,NULL,4,'分类空白边框颜色','main_category_fitbordercolor','#FFF',0,'2018-10-16','Category Blank Border','分类空白边框颜色'),(46,NULL,4,'分类激活背景颜色','main_category_activebgcolor','#FFAE5D',0,'2018-10-16','Category Active BG','分类激活背景颜色'),(47,NULL,4,'分类字体颜色','main_category_color','#fff',0,'2018-10-16','Category Font','分类字体颜色'),(48,NULL,4,'分类激活字体颜色','main_category_activecolor','#000',0,'2018-10-16','Category Active Font','分类激活字体颜色'),(49,NULL,4,'分类功能背景颜色','main_category_cmdbgcolor','#FFAE5D',0,'2018-10-16','Category Fun. BG','分类功能背景颜色'),(50,NULL,4,'分类功能字体颜色','main_category_cmdcolor','#000',0,'2018-10-16','Category Fun. Font','分类功能字体颜色'),(51,NULL,4,'菜品背景颜色','main_menu_bgcolor','rgba(255,255,255,0.7)',0,'2018-10-16','Menu BG','菜品背景颜色'),(52,NULL,4,'菜品边框颜色','main_menu_bordercolor','#fff',0,'2018-10-16','Menu Border','菜品边框颜色'),(53,NULL,4,'菜品空白背景颜色','main_menu_fitbgcolor','rgba(255,255,255,0.7)',0,'2018-10-16','Menu Blank BG','菜品空白背景颜色'),(54,NULL,4,'菜品空白边框颜色','main_menu_fitbordercolor','#fff',0,'2018-10-16','Menu Blank Border','菜品空白边框颜色'),(55,NULL,4,'菜品字体颜色','main_menu_color','#000',0,'2018-10-16','Menu Font','菜品字体颜色'),(56,NULL,4,'菜品功能背景颜色','main_menu_cmdbgcolor','rgba(0,0,0,0.5)',0,'2018-10-16','Menu Fun. BG','菜品功能背景颜色'),(57,NULL,4,'菜品功能字体颜色','main_menu_cmdcolor','#fff',0,'2018-10-16','Menu Fun. Font','菜品功能字体颜色'),(58,NULL,4,'跟随背景颜色','main_follow_bgcolor','rgba(0,0,0,0.5)',0,'2018-10-16','Follow BG','跟随背景颜色'),(59,NULL,4,'跟随边框颜色','main_follow_bordercolor','#fff',0,'2018-10-16','Follow Border','跟随边框颜色'),(60,NULL,4,'跟随空白背景颜色','main_follow_fitbgcolor','rgba(0,0,0,0.5)',0,'2018-10-16','Follow Blank BG','跟随空白背景颜色'),(61,NULL,4,'跟随空白边框颜色','main_follow_fitbordercolor','#fff',0,'2018-10-16','Follow Blank Border','跟随空白边框颜色'),(62,NULL,4,'跟随字体颜色','main_follow_color','#fff',0,'2018-10-16','Follow Font','跟随字体颜色'),(63,NULL,6,'CALLID','hardware_callid_1','1',7,'2018-10-16','CALLID','CALLID'),(64,NULL,6,'CALLID2','hardware_callid_2','0',7,'2018-10-16','CALLID2','CALLID2'),(65,NULL,6,'钱箱','hardware_cashdraw','receipt',9990,'2018-10-16','Cash Draw','钱箱'),(66,NULL,4,'菜单字体大小','main_fontsize','18px',3,'2018-10-16','Menu Font Size','菜单字体大小'),(67,NULL,6,'显示牌','hardware_display','0',7,'2018-10-16','VFD Price Display','显示牌'),(68,'1111',4,'分类背景颜色','main_category_bgcolor','#323232',9999,'2018-10-16','Category BG','分类背景颜色'),(69,'1111',4,'分类边框颜色','main_category_bordercolor','#ccc',0,'2018-10-16','Category Border','分类边框颜色'),(70,'1111',4,'分类空白背景颜色','main_category_fitbgcolor','#323232',0,'2018-10-16','Category Blank BG','分类空白背景颜色'),(71,'1111',4,'分类空白边框颜色','main_category_fitbordercolor','#ccc',0,'2018-10-16','Category Blank Border','分类空白边框颜色'),(72,'1111',4,'分类激活背景颜色','main_category_activebgcolor','#FFAE5D',0,'2018-10-16','Category Active BG','分类激活背景颜色'),(73,'1111',4,'分类字体颜色','main_category_color','#FFF',0,'2018-10-16','Category Font','分类字体颜色'),(74,'1111',4,'分类激活字体颜色','main_category_activecolor','#fff',0,'2018-10-16','Category Active Font','分类激活字体颜色'),(75,'1111',4,'分类功能背景颜色','main_category_cmdbgcolor','#ECE7D1',0,'2018-10-16','Category Fun. BG','分类功能背景颜色'),(76,'1111',4,'分类功能字体颜色','main_category_cmdcolor','#000',0,'2018-10-16','Category Fun. Font','分类功能字体颜色'),(77,'1111',4,'菜品背景颜色','main_menu_bgcolor','#FAFAFA',0,'2018-10-16','Menu BG','菜品背景颜色'),(78,'1111',4,'菜品边框颜色','main_menu_bordercolor','#ccc',0,'2018-10-16','Menu Border','菜品边框颜色'),(79,'1111',4,'菜品空白背景颜色','main_menu_fitbgcolor','#FAFAFA',0,'2018-10-16','Menu Blank BG','菜品空白背景颜色'),(80,'1111',4,'菜品空白边框颜色','main_menu_fitbordercolor','#ccc',0,'2018-10-16','Menu Blank Border','菜品空白边框颜色'),(81,'1111',4,'菜品字体颜色','main_menu_color','#222222',0,'2018-10-16','Menu Font','菜品字体颜色'),(82,'1111',4,'菜品功能背景颜色','main_menu_cmdbgcolor','#DBDCE1',0,'2018-10-16','Menu Fun. BG','菜品功能背景颜色'),(83,'1111',4,'菜品功能字体颜色','main_menu_cmdcolor','#000',0,'2018-10-16','Menu Fun. Font','菜品功能字体颜色'),(84,'1111',4,'跟随背景颜色','main_follow_bgcolor','#ccc',0,'2018-10-16','Follow BG','跟随背景颜色'),(85,'1111',4,'跟随边框颜色','main_follow_bordercolor','#fff',0,'2018-10-16','Follow Border','跟随边框颜色'),(86,'1111',4,'跟随空白背景颜色','main_follow_fitbgcolor','#EEF1F8',0,'2018-10-16','Follow Blank BG','跟随空白背景颜色'),(87,'1111',4,'跟随空白边框颜色','main_follow_fitbordercolor','#ccc',0,'2018-10-16','Follow Blank Border','跟随空白边框颜色'),(88,'1111',4,'跟随字体颜色','main_follow_color','#222222',0,'2018-10-16','Follow Font','跟随字体颜色'),(89,'1111',4,'菜单字体大小','main_fontsize','14px',3,'2018-10-16','Menu Font Size','菜单字体大小'),(90,NULL,2,'打印后价格下调权限','main_print_num_modify','2',4,'2018-10-16','Down Price Right','打印后价格下调权限'),(109,NULL,3,'号码前三位','main_phone3','',8888,'2018-10-16','Area Code','号码前三位'),(110,NULL,3,'起始单号','main_startorderno','0',8888,'2018-10-16','Start Order No.','起始单号'),(111,NULL,1,'已打印文字','print_isprintword','',0,'2018-10-16','Printed Word','已打印文字'),(112,NULL,1,'签字单打印小费','print_sign_tip','0',2,'2018-10-16','Credit Print Tip','签字单打印小费'),(114,NULL,1,'打印小费建议','print_tip_suggestion','1',2,'2018-10-16','Tip Suggestion','打印小费建议'),(115,NULL,1,'底部文字','print_bottom_word',' Thank you very much!<br/>All transactions are final. No refund.',0,'2018-10-16','Bottom Word','底部文字'),(116,NULL,2,'取消菜权限','main_item_cancel_right','2',4,'2018-10-16','Cancel Item Right','取消菜权限'),(117,NULL,4,'主界面左右顺序','main_indexpage_seq','0',10,'2018-10-16','Main Page Seq.','主界面左右顺序'),(118,NULL,4,'点单界面左右顺序','main_menupage_seq','0',10,'2018-10-16','Menu Page Seq.','点单界面左右顺序'),(119,NULL,4,'订单界面左右顺序','main_orderlist_seq','0',10,'2018-10-16','Order List Page Seq.','订单界面左右顺序'),(120,NULL,3,'跟随项是否分单','main_split_follow','0',2,'2018-10-16','Follow Can Split','跟随项是否分单'),(121,NULL,6,'来电显示数量','hardware_callid_num','6',8888,'2018-10-16','Callerid Num','来电显示数量'),(122,NULL,3,'模式','rest_mode','0',12,'2018-10-16','Mode','模式'),(123,NULL,6,'LED显示牌','hardware_led_port','0',7,'2018-10-16','LED Price Display','LED显示牌'),(125,NULL,1,'显示打印去向','print_printername','1',2,'2018-10-16','Print Code','显示打印去向'),(140,NULL,4,'ITEM列表宽度','main_item_width','350',8888,'2018-10-16','ITEM Width','ITEM列表宽度'),(141,NULL,4,'菜单行数','main_menu_rownum','10',8888,'2018-10-16','Menu Row Num','菜单行数'),(142,NULL,1,'打印ITEM宽度','print_item_width','90',8888,'2018-10-16','Print Item Width','打印ITEM宽度'),(143,NULL,4,'明细行数','main_item_rownum','15',8888,'2018-10-16','Detail Row Num','明细行数'),(144,NULL,3,'付款后打印模式','main_payment_printmode','0',13,'2018-10-16','After Payment Mode','付款后打印模式'),(145,NULL,1,'打印客户姓名','print_cust_name','0',2,'2018-10-16','Print Cust Name','打印客户姓名'),(146,NULL,1,'打印客户地址','print_cust_address','0',2,'2018-10-16','Print Cust Address','打印客户地址'),(147,NULL,1,'打印客户号码','print_cust_phone','0',2,'2018-10-16','Print Cust Phone No','打印客户号码'),(148,NULL,1,'打印客户CITY','print_cust_city','0',2,'2018-10-16','Print Cust City','打印客户CITY'),(149,NULL,1,'打印客户State','print_cust_state','1',2,'2018-10-16','Print Cust State','打印客户State'),(150,NULL,1,'打印客户ZIPCODE','print_cust_zipcode','1',2,'2018-10-16','Print Cust ZIPCODE','打印客户ZIPCODE'),(151,NULL,1,'打印REMARK','print_cust_remark','0',2,'2018-10-16','Print REMARK','打印REMARK'),(152,NULL,4,'客户类型底部显示','main_custtype_bottomshow','0',2,'2018-10-16','Cust Type Bottom Show','客户类型底部显示'),(153,NULL,2,'服务费输入权限','main_service_input_right','0',4,'2018-10-18','Service Input Right','服务费输入权限'),(154,NULL,2,'折扣输入权限','main_discount_input_right','0',4,'2018-10-18','Discount Input Right','折扣输入权限'),(155,NULL,3,'区号是否显示','main_areacode_show','1',2,'2018-10-25','Area Code Show','区号是否显示'),(156,NULL,1,'全部打印粗体','print_all_bold','1',2,'2018-10-25','Print All Bold','全部打印粗体'),(157,NULL,3,'快捷付款开钱箱','main_quickpay_opendrawer','1',2,'2018-10-25','Quick Pay Open Drawer','快捷付款开钱箱'),(158,NULL,1,'跟随同一行打印','print_follow_sameline','1',2,'2018-10-25','Print WithItem Sameline','跟随同一行打印'),(159,NULL,3,'快捷键精确匹配','main_itemno_exact','0',2,'2018-10-25','Itemno Exact','快捷键精确匹配'),(160,NULL,2,'BATCH权限','main_batch_right','2',4,'2018-10-25','Batch Right','BATCH权限'),(161,NULL,3,'卡号位数','main_cardno_length','0',8888,'2018-12-17','Length Of CardNo','卡号位数'),(162,NULL,3,'自动激活库存','main_auto_activestore','1',2,'2018-12-17','Auto Active Store','自动激活库存'),(163,NULL,1,'第一语言粗体','print_l1_bold','1',2,'2018-12-17','Print L1 Bold','第一语言粗体'),(164,NULL,1,'第二语言粗体','print_l2_bold','0',2,'2018-12-17','Print L2 Bold','第二语言粗体'),(165,NULL,4,'快捷界面顺序','main_quickpage_seq','0',10,'2018-12-17','Quick Page Seq','快捷界面顺序'),(166,NULL,3,'需要输入客户数量','main_needinput_custno','0',2,'2018-12-17','Need Input Guest No.','需要输入客户数量'),(167,NULL,1,'桌号打印粗体','print_table_bold','1',1,'2018-12-17','Tab Print Bold.','桌号打印粗体'),(168,NULL,3,'付款后不配送','main_payment_nodelivery','1',2,'2018-12-17','After Paid No Delivery','付款后不配送'),(169,NULL,1,'标签单号字体大小','print_label_orderno_fontsize','10px',3,'2018-12-17','Label Font Size','标签单号字体大小'),(170,NULL,1,'信用卡签字单是否打印建议小费','print_creditsign_tipsuggestion','1',2,'2018-12-17','Credit Print Suggestion Tip','信用卡签字单是否打印建议小费'),(171,NULL,3,'开启在线报表','main_report_online','1',2,'2018-12-17','Open Online Report','开启在线报表'),(172,NULL,2,'退出权限','main_close_right','0',4,'2018-12-17','Exit Right','退出权限'),(173,NULL,2,'VIP卡修改权限','main_vip_modify_right','2',4,'2018-12-17','VIP Modify Right','VIP卡修改权限'),(174,NULL,3,'自动刷新菜单','main_autoflash_menu','0',2,'2018-12-17','Auto Flash Menu','自动刷新菜单'),(175,NULL,3,'是否叠加税','main_superposition_tax','1',2,'2018-12-17','Superposition Tax','是否叠加税'),(176,NULL,3,'密码锁定模式','main_lock_mode','0',14,'2018-12-17','Lock Mode','密码锁定模式'),(181,NULL,3,'相同是否叠加','main_menu_sameadd','1',2,'2018-12-15','Same Item Add','相同是否叠加'),(182,NULL,5,'第二屏图片宽度','main_second_picwidth','500',8888,'2018-12-15','Second Pic Width','第二屏图片宽度'),(183,NULL,1,'签字单打印两张','main_sign_double','0',2,'2018-12-15','Sign Print Double','签字单打印两张'),(184,NULL,1,'跟随标记','print_follow_mark','**',0,'2018-12-15','Follow Mark.','跟随标记'),(185,NULL,1,'服务费打印文字','print_servicecharge_mark','Service Charge',0,'2019-02-02','Service Print Word','服务费打印文字'),(186,NULL,1,'签字单小费底部打印','print_credit_sign_tipstyle','0',2,'2019-02-02','Credit Tip Bottom','签字单小费底部打印'),(187,NULL,3,'报表设置新窗口打开','main_setting_newwin','1',2,'2019-02-02','Setting New Win','报表设置新窗口打开'),(188,NULL,1,'预约字体大小','print_cooktime_fontsize','14px',3,'2019-02-02','Appointment Font Size','预约字体大小'),(189,NULL,1,'第一语言取消','print_cancelword_l1','Cancel',0,'2019-02-02','L1 Cancel Word','第一语言取消'),(190,NULL,1,'第二语言取消','print_cancelword_l2','取消',0,'2019-02-02','L2 Cancel Word','第二语言取消'),(191,NULL,2,'减少库存权限','main_less_store_right','3',4,'2019-02-02','Store Less Right','减少库存权限'),(192,NULL,2,'关闭库存权限','main_close_store_right','3',4,'2019-02-02','Store Less Right','关闭库存权限'),(193,NULL,3,'钱箱是否签到','main_cashneed_cashinout','1',2,'2019-02-02','Cash In Out','钱箱是否签到'),(194,NULL,1,'桌号打印字体大小','print_tableno_fontsize','12px',3,'2019-02-02','Table No. FontSize','桌号打印字体大小'),(195,NULL,1,'小计字体大小','print_amount_fontsize','12px',3,'2019-02-02','Amount FontSize','小计字体大小'),(196,NULL,1,'税率字体大小','print_tax_fontsize','12px',3,'2019-02-02','Tax FontSize','税率字体大小'),(197,NULL,3,'分单自动按数量拆分','main_auto_splitqty','1',2,'2019-02-02','Auto Split Qty','分单自动按数量拆分'),(198,NULL,3,'打印插件路径','main_printapp_path','C:\\\\Program Files (x86)\\\\MountTaiSoftware\\\\CLodop32\\\\CLodopPrint32.exe',0,'2019-02-02','Path of print app','打印插件路径'),(230,NULL,2,'报表日期切换权限','main_report_otherdate_right','0',4,'2019-04-23','Report Date Right','报表日期切换权限'),(231,NULL,1,'显示打印时间','print_print_time','1',2,'2019-04-23','Show Print Time','显示打印时间'),(232,NULL,3,'使用时间单号','main_use_timeno','1',2,'2019-04-23','Use Time No.','使用时间单号'),(233,NULL,3,'签出检查未付款','main_signout_checkunpaid','1',2,'2019-04-23','Sign Check Unpaid','签出检查未付款'),(234,NULL,3,'在线信用卡支付','main_online_creditpayfun','1',2,'2019-04-23','Online credit pay','在线信用卡支付'),(235,NULL,3,'扣减礼品卡预售额','main_gift_reporttype','0',2,'2019-04-23','PreSale Gift Deduction','扣减礼品卡预售额'),(236,NULL,1,'每个ITEM打印分隔符','print_ticket_split','1',2,'2019-04-23','Item Print Split','每个ITEM打印分隔符'),(237,NULL,1,'自动打印机器名','print_autoprint_hostname','',0,'2019-04-23','Auto Print Hostname','自动打印机器名'),(238,NULL,3,'税打折','main_tax_discount','1',2,'2019-04-23','Discount Tax','税打折'),(239,NULL,3,'外卖费收税','main_tax_delivery','1',2,'2019-04-23','Delivery Tax','外卖费收税');
delete from driver_table;
INSERT INTO `driver_table` (`DriverID`, `DriverName`, `CreateTime`, `Remark`) VALUES (1,'Driver1','2018-05-07 13:35:07',NULL),(2,'Driver2','2018-05-07 13:35:18',NULL),(3,'Driver3','2018-05-07 13:36:09',NULL),(4,'Driver4','2018-07-25 14:57:04',NULL);
delete from op_user_table;
INSERT INTO `op_user_table` (`OpUserID`, `OpUserName`, `OpUserPwd`, `RightType`, `MLevel`, `CreateTime`, `Remark`, `UpdateTime`, `Token`, `flag1`, `flag2`, `flag3`, `flag4`, `flag5`, `MustSignIn`) VALUES (1,'Boss','1208',3,0.00,'2018-03-28 09:23:46',NULL,'2018-09-12','fjkekdije17dj',0,0,0,0,0,1),(2,'Manager','0208',2,0.00,'2018-05-07 11:13:50',NULL,'2018-09-12','fjkekdije17dd',0,0,0,0,0,1),(10,'Casher','888',1,0.00,'2018-06-15 16:42:33',NULL,'2018-09-12','bif6mipxxfg',0,0,0,0,0,1),(13,'Waiter1','1',0,0.00,'2018-06-22 12:00:26',NULL,'2018-09-12','kc6o83svhtj',0,0,0,0,0,1),(14,'Waiter2','2',0,0.00,'2018-08-03 13:26:20',NULL,'2018-09-12','f3qn8c1gbid',0,0,0,0,0,1),(15,'Honor pos','777888999',4,0.00,'2018-10-16 15:51:35',NULL,'2018-12-18','fup10kwe4u5',0,0,0,0,0,1);
delete from pay_type_table;
INSERT INTO `pay_type_table` (`PayType`, `L1`, `L2`, `LogoUrl`, `PayFun`, `Weight`, `IsShow`, `CreateTime`, `RightType`, `IsDefault`, `OpenDraw`) VALUES (1,'Cash','现金','','',2,0,'2018-04-11',1,1,1),(2,'Credit Card','信用卡','','',1,0,'2018-04-11',0,0,0),(3,'Check','支票','','',0,1,'2018-04-11',0,0,0),(4,'Gift Certificate','礼品卡','','gift',0,0,'2018-04-11',0,0,0),(5,'Master','Master','','',0,1,'2018-04-11',0,0,0),(6,'American Express','American Express','','',0,1,'2018-04-11',0,0,0),(7,'Discover','Discover','','',0,1,'2018-04-11',0,0,0),(8,'Room Charge','Room Charge','','',0,1,'2018-04-11',0,0,0),(9,'Online Payment','在线支付','','online',0,1,'2018-04-11',0,0,0);
delete from picture_table;
INSERT INTO `picture_table` (`ID`, `ImgUrl`, `CreateTime`) VALUES (138,'images/blackIcon/icon_discount.png','2018-06-11'),(139,'images/blackIcon/icon_split.png','2018-06-11'),(140,'images/blackIcon/icon_tip.png','2018-06-11'),(141,'images/blackIcon/icon_vip.png','2018-06-11'),(142,'images/icon/icon_cancelorder.png','2018-06-11'),(143,'images/icon/icon_cancelpayment.png','2018-06-11'),(144,'images/icon/icon_driver.png','2018-06-11'),(145,'images/icon/icon_map.png','2018-06-11'),(146,'images/icon/icon_orderlist.png','2018-06-11'),(147,'images/icon/icon_payment.png','2018-06-11'),(148,'images/icon/icon_print1.png','2018-06-11'),(149,'images/icon/icon_send.png','2018-06-11'),(150,'images/icon/icon_summary.png','2018-06-11'),(151,'images/icon/icon_tip.png','2018-06-11'),(152,'images/icon/icon_update.png','2018-06-11'),(153,'images/menuIcon/icon_changeprice.png','2018-06-11'),(154,'images/menuIcon/icon_custtype.png','2018-06-11'),(155,'images/menuIcon/icon_date.png','2018-06-11'),(156,'images/menuIcon/icon_discount.png','2018-06-11'),(157,'images/menuIcon/icon_exit.png','2018-06-11'),(158,'images/menuIcon/icon_lang.png','2018-06-11'),(159,'images/menuIcon/icon_resume.png','2018-06-11'),(160,'images/menuIcon/icon_split2.png','2018-06-11'),(161,'images/menuIcon/icon_tw.png','2018-06-11'),(168,'images/icon/icon_batch.png','2018-06-11'),(169,'images/icon/icon_cashdraw.png','2018-06-11'),(170,'images/icon/icon_manager.png','2018-06-11'),(171,'images/icon/icon_map.png','2018-06-11'),(172,'images/icon/icon_orderlist.png','2018-06-11'),(173,'images/icon/icon_pay.png','2018-06-11'),(174,'images/icon/icon_print1.png','2018-06-11'),(175,'images/icon/icon_shutdown.png','2018-06-11'),(176,'images/icon/icon_summary.png','2018-06-11'),(177,'images/icon/icon_timeclock.png','2018-06-11'),(178,'images/menuIcon/icon_lang.png','2018-06-11'),(183,'images/icon/icon_buffet.png','2018-06-11'),(184,'images/icon/icon_delivery.png','2018-06-11'),(185,'images/icon/icon_dinein.png','2018-06-11'),(186,'images/icon/icon_pickup.png','2018-06-11'),(187,'images/icon/icon_walkin.png','2018-06-11'),(188,'images/icon/icon_giftcard.png','2018-06-19'),(189,'images/icon/icon_vip.png','2018-07-20'),(190,'images/icon/icon_remote.png','2018-09-29'),(191,'images/icon/icon_drink.png','2019-04-23'),(192,'images/icon/icon_poke.png','2019-04-23'),(193,'images/icon/icon_market.png','2019-04-23'),(194,'images/icon/icon_seafood.png','2019-04-23'),(195,'images/icon/icon_barbecue.png','2019-04-23'),(196,'images/icon/icon_nail.png','2019-04-23');
delete from printer_conf_table;
INSERT INTO `printer_conf_table` (`ID`, `PrinterName`, `PrintType`, `PrintCode`, `CustType`, `PrintLang`, `Status`, `PrintHead`, `PrintAmount`, `PrintPrice`, `IsSplitItemno`, `LabelFlag`, `BottomPrint`, `LangPrintSeq`, `HeadSpace`, `PrintNum`, `CreateTime`, `PrintAddr`, `PrintAlready`, `PrintCancel`, `PrintPayment`, `MarginLeft`, `LabelWidth`, `LabelHeight`, `ShieldCustType`, `L1FontSize`, `L2FontSize`, `IsPrintMark`, `ModifyPrint`, `PrintBarCode`) VALUES (1,'receipt',1,'',0,1,0,0,0,0,0,0,0,1,0,1,'2018-05-22',0,0,1,0,0,80,0,'','','',0,0,1),(2,'packer',2,'',2,0,0,0,0,0,0,0,0,1,0,1,'2018-05-22',0,0,1,0,0,80,0,'','','',1,1,1),(3,'runner',3,'',1,0,1,0,0,0,0,0,0,0,0,1,'2018-05-22',0,0,0,1,0,0,0,'','','',1,1,1),(4,'chef',0,'0',0,0,0,1,1,1,0,0,1,1,50,1,'2018-05-22',1,1,0,1,0,80,0,'','','',1,1,1),(5,'sushi',0,'1',0,1,1,1,1,1,0,0,1,1,0,1,'2018-05-29',1,1,0,1,0,0,0,'','','',0,1,1),(6,'fryer',0,'2',0,0,1,1,1,1,0,0,1,1,0,1,'2018-09-12',1,1,0,1,10,80,0,'','','',0,1,1),(7,'bar',0,'3',0,1,1,1,1,1,0,0,1,1,0,1,'2018-09-12',1,1,0,1,10,80,0,'','','',0,1,1);
delete from setting_menu_table;
INSERT INTO `setting_menu_table` (`ID`, `FID`, `L1`, `L2`, `TargetUrl`, `CreateTime`, `Weight`, `MenuGroup`, `Status`, `RightType`, `LogoUrl`) VALUES (1,0,'Base Setting','基础设置',NULL,'2018-06-07',0,0,0,0,NULL),(2,0,'Menu Setting','菜单设置',NULL,'2018-06-07',0,0,0,0,NULL),(3,0,'Module Setting','功能设置',NULL,'2018-06-07',0,0,0,0,NULL),(4,0,'Options Setting','选项设置',NULL,'2018-06-07',0,0,0,0,NULL),(5,1,'UTOP Setting','主要信息设置','utop.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_maininfo.png'),(6,1,'Cust Type Setting','客户类型设置','custType.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_custtype.png'),(7,1,'Pay Type Setting','付款类型设置','payType.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_paytype.png'),(8,1,'Table Setting','桌子设置','table.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_tableset.png'),(9,1,'Printer Setting','打印机设置','printer.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_printset.png'),(10,2,'Group Setting','菜单组设置','categoryGroup.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menugroupset.png'),(12,2,'Menu Setting','菜单设置','category.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menuset.png'),(13,2,'Follow Setting','跟随项设置','follow.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_followset.png'),(14,3,'Index Setting','首页功能设置','indexpage.html','2018-06-07',0,0,0,0,'/images/blackIcon/icon_indexset.png'),(15,3,'Menu Right Setting','点单页右侧栏设置','configCmd.html?funGroup=menurightfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menurightset.png'),(16,3,'Menu Main Setting','点单页主功能设置','configCmd.html?funGroup=menumainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menumainset.png'),(17,3,'Menu Num Setting','点单页数量功能设置','configCmd.html?funGroup=menunumfun&needlogo=0','2018-06-07',0,0,0,0,'/images/blackIcon/icon_menunumset.png'),(18,3,'Payment Setting',' 付款页功能设置\r\n','configCmd.html?funGroup=paymentfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_paymentset.png'),(19,3,'Order Main Setting','订单页面主功能设置','configCmd.html?funGroup=orderlistmainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_ordermainset.png'),(20,3,'Order Query Setting','订单页面查询功能设置','configCmd.html?funGroup=orderlistqueryfun&needlogo=0','2018-06-07',0,0,0,0,'/images/blackIcon/icon_orderqueryset.png'),(21,3,'User Main Setting','用户信息页面主功能设置','configCmd.html?funGroup=userinfomainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_usermainset.png'),(22,3,'Table Main Setting','桌子页主功能设置','configCmd.html?funGroup=tableinfomainfun','2018-06-07',0,0,0,0,'/images/blackIcon/icon_tablemainset.png'),(23,3,'Table Other Setting','桌子页其他设置','configCmd.html?funGroup=tableinfotablefun&needlogo=0','2018-06-11',0,0,0,0,'/images/blackIcon/icon_tableotherset.png'),(24,4,'Print Options Setting',' 打印选项设置','options.html?settingGroup=1','2018-06-07',0,0,0,0,'/images/blackIcon/icon_printoptions.png'),(25,4,'Right Setting','权限设置','options.html?settingGroup=2','2018-06-07',0,0,0,0,'/images/blackIcon/icon_rightoptions.png'),(26,2,'Spec Group Setting','调味组设置','specGroup.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specgroupset.png'),(27,2,'Spec Setting','调味设置','spec.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specset.png'),(28,2,'Spec Operation Setting','调味操作设置','specOperation.html','2018-06-14',0,0,0,0,'/images/blackIcon/icon_specopset.png'),(29,1,'User Setting','用户设置','user.html','2018-06-15',0,0,0,0,'/images/blackIcon/icon_userset.png'),(30,1,'Driver Setting','送餐员设置','driver.html','2018-06-15',0,0,0,0,'/images/blackIcon/icon_deliveryset.png'),(31,4,'Display Options Setting','显示选项设置','options.html?settingGroup=4&menudisplayflag=1','2018-06-22',0,0,0,0,'/images/blackIcon/icon_displayoptions.png'),(32,4,'Business Setting','营业设置','options.html?settingGroup=3','2018-06-22',0,0,0,0,'/images/blackIcon/icon_busoptions.png'),(33,4,'Double Display Setting','双屏设置','options.html?settingGroup=5','2018-06-22',0,0,0,0,'/images/blackIcon/icon_doubledisplayoptions.png'),(34,0,'Report Setting','报表设置',NULL,'2018-06-25',0,0,0,0,NULL),(35,34,'Group Setting','统计组设置','countgourp.html','2018-06-25',0,0,0,0,'/images/blackIcon/icon_countgroupset.png'),(36,4,'Hardware Setting','外设设置','options.html?settingGroup=6','2018-06-26',0,0,0,0,'/images/blackIcon/icon_hardwareoptions.png'),(37,0,'PAX Setting','PAX刷卡设置',NULL,'2018-06-29',0,0,0,0,NULL),(38,37,'Machine Setting','刷卡机设置','reader.html','2018-06-29',0,0,0,0,'/images/blackIcon/icon_paxset.png'),(39,0,'Other Setting','其他设置',NULL,'2018-07-12',0,0,0,0,NULL),(40,39,'Tip Rate Setting','小费比例设置','commonConf.html?groupID=1','2018-07-12',0,0,0,0,'/images/blackIcon/icon_rateset.png'),(41,39,'Tip Amount Setting','小费金额设置','commonConf.html?groupID=2','2018-07-12',0,0,0,0,'/images/blackIcon/icon_amountset.png'),(42,39,'Discount Rate Setting','打折比例设置','commonConf.html?groupID=3','2018-07-12',0,0,0,0,'/images/blackIcon/icon_rateset.png'),(43,39,'Discount Amount Setting','打折金额设置','commonConf.html?groupID=4','2018-07-12',0,0,0,0,'/images/blackIcon/icon_amountset.png'),(44,39,'Tip Suggestion','建议小费','tipSuggestion.html','2018-08-10',0,0,0,0,'/images/blackIcon/icon_tipsuggestionset.png'),(45,1,'System Setting','系统设置','systemConf.html','2018-09-06',0,0,0,0,'/images/blackIcon/icon_sysset.png'),(1001,0,'Total Report','统计报表','','2018-06-20',0,1,0,0,NULL),(1002,0,'Other Report','其他报表','','2018-06-20',0,1,0,0,NULL),(1003,1001,'Daily Report','日报表','dailyreport.html','2018-06-20',0,1,0,0,'/images/blackIcon/icon_report1.png'),(1004,1001,'Detail Report','细目报表','detailreport.html','2018-06-20',4,1,0,0,'/images/blackIcon/icon_report2.png'),(1005,1001,'Monthly Report','月报表','monthreport.html','2018-06-20',2,1,0,0,'/images/blackIcon/icon_report3.png'),(1006,1002,'Employee Report','员工报表','employeereport.html','2018-06-20',0,1,0,0,'/images/blackIcon/icon_userreport.png'),(1008,1001,'Yearly Report','年报表','yearreport.html','2018-06-21',3,1,0,0,'/images/blackIcon/icon_report4.png'),(1009,1001,'Weekly Report','周报表','weeklyreport.html','2018-06-21',1,1,0,0,'/images/blackIcon/icon_report5.png'),(1010,1002,'Cost Report','成本报表','commissionReport.html','2018-09-19',0,1,0,0,'/images/blackIcon/icon_costreport.png'),(1011,1002,'Store Log Report','库存变动报表','storeLogReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_storelogreport.png'),(1012,1002,'Store Report','库存报表','storeReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_store.png'),(1013,1002,'Cash In/Out Report','Cash In/Out报表','cashinoutReport.html','2019-02-02',0,1,0,0,'/images/blackIcon/icon_cashinoutreport.png'),(1017,39,'Pay Amount Setting','付款金额配置','commonConf.html?groupID=5','2019-04-23',0,0,0,0,'/images/blackIcon/icon_paymentamountset.png'),(1018,39,'Special Amount Setting','调味金额配置','commonConf.html?groupID=6','2019-04-23',0,0,0,0,'/images/blackIcon/icon_specamountset.png'),(1019,39,'Online Order Setting','在线点餐配置','onlineOrder.html','2019-04-23',0,0,0,0,'/images/blackIcon/icon_onlineorderset.png');
delete from setting_value_type_table;
INSERT INTO `setting_value_type_table` (`TypeID`, `ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (1,1,'粗体','0','2018-05-22','Bold','粗体'),(2,1,'普通','1','2018-05-22','Normal','普通'),(3,2,'是','0','2018-05-22','Yes','是'),(4,2,'否','1','2018-05-22','No','否'),(5,3,'30','30px','2018-06-11','30','30'),(6,3,'28','28px','2018-06-11','28','28'),(7,3,'26','26px','2018-06-11','26','26'),(8,3,'24','24px','2018-06-11','24','24'),(9,3,'22','22px','2018-06-11','22','22'),(10,3,'20','20px','2018-06-11','20','20'),(11,3,'18','18px','2018-06-11','18','18'),(12,3,'16','16px','2018-06-11','16','16'),(13,3,'14','14px','2018-06-11','14','14'),(14,3,'12','12px','2018-06-11','12','12'),(15,3,'10','10px','2018-06-11','10','10'),(16,3,'8','8px','2018-06-11','8','8'),(17,4,'Order','0','2018-06-15','Order','Order'),(18,4,'Cashier','1','2018-06-15','Cashier','Cashier'),(19,4,'Report','2','2018-06-15','Report','Report'),(20,4,'BOSS','3','2018-06-15','BOSS','BOSS'),(21,5,'实际金额','0','2018-06-15','Actual Amount','实际金额'),(22,5,'三进五，八进十','1','2018-06-15','3to5,8to10','三进五，八进十'),(23,5,'向上取整，进五或十','2','2018-06-15','Up, to 5,10','向上取整，进五或十'),(24,5,'向上取整，进十','3','2018-06-15','Up, to 10','向上取整，进十'),(25,5,'四舍五入','4','2018-06-15','Rounding','四舍五入'),(26,6,'跟随第一屏','0','2018-06-19','Follow Main','跟随第一屏'),(27,6,'第一语言','1','2018-06-19','First Lang.','第一语言'),(28,6,'第二语言','2','2018-06-19','Second Lang.','第二语言'),(29,7,'COM1','1','2018-06-26','COM1','COM1'),(30,7,'COM2','2','2018-06-26','COM2','COM2'),(31,7,'COM3','3','2018-06-26','COM3','COM3'),(32,7,'COM4','4','2018-06-26','COM4','COM4'),(33,7,'COM5','5','2018-06-26','COM5','COM5'),(34,7,'COM6','6','2018-06-26','COM6','COM6'),(35,7,'COM7','7','2018-06-26','COM7','COM7'),(36,7,'COM8','8','2018-06-26','COM8','COM8'),(37,7,'COM9','9','2018-06-26','COM9','COM9'),(38,7,'COM10','10','2018-06-26','COM10','COM10'),(39,7,'无','0','2018-06-26','None','无'),(40,8,'2','2px','2018-07-18','2','2'),(41,8,'3','3px','2018-07-18','3','3'),(42,8,'4','4px','2018-07-18','4','4'),(43,8,'5','5px','2018-07-18','5','5'),(44,8,'6','6px','2018-07-18','6','6'),(45,8,'7','7px','2018-07-18','7','7'),(46,8,'8','8px','2018-07-18','8','8'),(47,8,'10','10px','2018-07-20','10','10'),(48,9,'只可改高','1','2018-07-20','Only More','只可改高'),(49,9,'不可修改','2','2018-07-20','Can Not','不可修改'),(50,10,'正常','0','2018-09-06','Normal','正常'),(51,10,'颠倒','1','2018-09-06','Upside Down ','颠倒'),(52,11,'测试模式','0','2018-09-20','Test Mode','测试模式'),(53,11,'性能模式','1','2018-09-20','Performance Mode','性能模式'),(54,11,'兼容模式','2','2018-09-20','Compatible Mode','兼容模式'),(55,12,'普通模式','0','2018-09-25','Normal Mode','普通模式'),(56,12,'快速外卖店模式','1','2018-09-25','Quick Order Mode','快速点单模式'),(57,13,'用户选择','0','2018-10-16','User Select','用户选择'),(58,13,'不打印','1','2018-10-16','No Print','不打印'),(59,13,'打印','2','2018-10-16','Print','打印'),(60,4,'Super','4','2018-11-19','Super','Super'),(61,14,'Can Lock','0','2018-12-07','Can Lock','可锁定'),(62,14,'No Lock','1','2018-12-07','No Lock','不可锁定'),(63,14,'Always Lock','2','2018-12-07','Always Lock','一直锁定'),(64,15,'Always Print','0','2019-10-02','Always Print','总是打印'),(65,15,'Print','1','2019-10-02','Print','打印'),(66,15,'No Print','2','2019-10-02','No Print','不打印'),(67,16,'Default Mode','0','2019-10-02','Default Mode','默认模式'),(68,16,'Tint Mode','1','2019-10-02','Tint Mode','浅色模式'),(69,8,'15','15px','2020-12-18','15','15'),(70,8,'20','20px','2020-12-18','20','20'),(71,8,'25','25px','2020-12-18','25','25'),(72,8,'30','30px','2020-12-18','30','30'),(73,8,'40','40px','2020-12-18','40','40'),(74,8,'50','50px','2020-12-18','50','50'),(75,8,'75','75px','2020-12-18','75','75');
delete from tip_suggestion_table;
INSERT INTO `tip_suggestion_table` (`ID`, `TipRate`, `FontWeight`, `FontSize`, `Weight`, `Status`, `CreateTime`) VALUES (15,15,0,'12',0,0,'2018-08-06 13:34:36'),(16,20,0,'12',0,0,'2018-08-06 13:34:41'),(17,25,0,'12',0,0,'2018-08-06 13:34:45');
delete from utop_info_table;
INSERT INTO `utop_info_table` (`ID`, `MainName`, `Street`, `City`, `State`, `ZipCode`, `MoreInfo`, `Tel`, `SecondTel`, `OtherTel`, `Images`, `WebSite`) VALUES (164,'Honor POS','7 Division St','New York','NY','10002 ','','212-863-9266','','','','');
delete from org_table;
delete from table_area_table;
delete from table_table;
]]>