set global innodb_file_per_table =ON;



CREATE TABLE IF NOT EXISTS `order_store_log_table` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID  说明:主键',
 `ItemID` int(11) COMMENT 'ItemID  说明:ItemID',
  `MenuID` int(11) NOT NULL COMMENT '项目ID  说明:项目ID',
  `Action` int(11) NOT NULL COMMENT '动作  说明:Action 0:入库 1:出库',
  `ActionNum` int(11) NOT NULL COMMENT '数量  说明:数量',
  `OrderID` int(11) DEFAULT NULL COMMENT '订单号  说明:订单号',
  `OpUserID` int(11) DEFAULT NULL COMMENT '操作员  说明:操作员',
  `CreateTime` datetime NOT NULL COMMENT '创建时间  说明:创建时间',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COMMENT='库存记录表';

 alter table menu_table modify column StoreNum int default -1 COMMENT '库存  说明:库存'; 

update menu_table set storeNum=-1 where storeNum=0;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND column_name='MenuID';
if(@count<=0) THEN 
 alter table order_detail_table add column MenuID int COMMENT '项目ID  说明:项目ID'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_cardno_length';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '卡号位数', 'main_cardno_length', '0', '8888', now(),'Length Of CardNo','卡号位数');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_auto_activestore';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '自动激活库存', 'main_auto_activestore', '1', '2', now(),'Auto Active Store','自动激活库存');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_type_table' AND column_name='DeliveryChargeMin';
if(@count<=0) THEN 
 alter table cust_type_table add column DeliveryChargeMin int default 1000000000 COMMENT '外卖费免收额  说明:外卖费免收额'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_l1_bold';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '第一语言粗体', 'print_l1_bold', '1', '2', now(),'Print L1 Bold','第一语言粗体');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_l2_bold';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '第二语言粗体', 'print_l2_bold', '1', '2', now(),'Print L2 Bold','第二语言粗体');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='op_user_table' AND column_name='MustSignIn';
if(@count<=0) THEN 
 alter table op_user_table add column MustSignIn int default 1  COMMENT '点单前必签到  说明:点单前必签到'; 
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_quickpage_seq';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '快捷界面顺序', 'main_quickpage_seq', '0', '10', now(),'Quick Page Seq','快捷界面顺序');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='PayStatus';
if(@count<=0) THEN 
 alter table order_table add column PayStatus int default 0  COMMENT '付款状态  说明:付款状态 0:未付款 1:已付款';
Update order_table set payStatus =1 where orderAmount<=PaymentAmount; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_orderid';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_orderid (orderID);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_split_group_table' AND  index_name = 'index_order_split_group_table_orderid ';
if(@count<=0) THEN 
ALTER TABLE order_split_group_table ADD INDEX index_order_split_group_table_orderid (orderID);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_needinput_custno';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '需要输入客户数量', 'main_needinput_custno', '0', '2', now(),'Need Input Guest No.','需要输入客户数量');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_table_bold';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '桌号打印粗体', 'print_table_bold', '1', '1', now(),'Tab Print Bold.','桌号打印粗体');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_payment_nodelivery';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '付款后不配送', 'main_payment_nodelivery', '1', '2', now(),'After Paid No Delivery','付款后不配送');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_label_orderno_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '标签单号字体大小', 'print_label_orderno_fontsize', '10px', '3', now(),'Label Font Size','标签单号字体大小');
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_value_type_table
WHERE valueType=4 and settingValue=4;
if(@count<=0) THEN 
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (4,'Super',4,'Super','Super',now());
end if;
end;
call proc_tempPro;


Update setting_value_type_table set valueTypeDesc='Cashier',l1='Cashier',l2='Cashier' where valuetype=4 and settingValue=1;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_creditsign_tipsuggestion';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '信用卡签字单是否打印建议小费', 'print_creditsign_tipsuggestion', '1', '2', now(),'Credit Print Suggestion Tip','信用卡签字单是否打印建议小费');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_report_online';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '开启在线报表', 'main_report_online', '1', '2', now(),'Open Online Report','开启在线报表');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_close_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '退出权限', 'main_close_right', '0', '4', now(),'Exit Right','退出权限');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_vip_modify_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', 'VIP卡修改权限', 'main_vip_modify_right', '4', '4', now(),'VIP Modify Right','VIP卡修改权限');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_autoflash_menu';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '自动刷新菜单', 'main_autoflash_menu', '1', '2', now(),'Auto Flash Menu','自动刷新菜单');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_superposition_tax';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '是否叠加税', 'main_superposition_tax', '1', '2', now(),'Superposition Tax','是否叠加税');
end if;
end;
call proc_tempPro;





DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_lock_mode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '密码锁定模式', 'main_lock_mode', '0', '14', now(),'Lock Mode','密码锁定模式');
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (14,'Can Lock',0,'Can Lock','可锁定',now());
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (14,'No Lock',1,'No Lock','不可锁定',now());
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (14,'Always Lock',2,'Always Lock','一直锁定',now());
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND  index_name = 'index_order_payment_vipid';
if(@count<=0) THEN 
ALTER TABLE order_payment_table ADD INDEX index_order_payment_vipid (vipid);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND  index_name = 'index_order_payment_orderid';
if(@count<=0) THEN 
ALTER TABLE order_payment_table ADD INDEX index_order_payment_orderid (orderID);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='clock_table' AND column_name='TipAmount';
if(@count<=0) THEN 
 alter table clock_table add column TipAmount float(10,2) default 0 COMMENT '小费  说明:小费'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_menu_sameadd';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '相同是否叠加', 'main_menu_sameadd', '1', '2', now(),'Same Item Add','相同是否叠加');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_second_picwidth';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '5', '第二屏图片宽度', 'main_second_picwidth', '500', '8888', now(),'Second Pic Width','第二屏图片宽度');
end if;
end;
call proc_tempPro;


alter table spec_table modify Price float(10,2) default 0  COMMENT '价格  说明:价格';
alter table menu_table modify ItemNo varchar(100) COMMENT '快捷键  说明:快捷键';
alter table follow_table modify ItemNo varchar(100) COMMENT '快捷键  说明:快捷键';
alter table order_detail_table modify ItemNo varchar(100) COMMENT '快捷键  说明:快捷键';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_sign_double';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '签字单打印两张', 'main_sign_double', '0', '2', now(),'Sign Print Double','签字单打印两张');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_countgroupid';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_countgroupid (CountGroupID);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_split_detail_table' AND  index_name = 'index_order_split_detail_table_itemid';
if(@count<=0) THEN 
ALTER TABLE order_split_detail_table ADD INDEX index_order_split_detail_table_itemid (itemid);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_itemid';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_itemid (itemid);
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_follow_mark';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '跟随标记', 'print_follow_mark', '**', '0', now(),'Follow Mark.','跟随标记');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_servicecharge_mark';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '服务费打印文字', 'print_servicecharge_mark', 'Service Charge', '0', now(),'Service Print Word','服务费打印文字');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_credit_sign_tipstyle';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '签字单小费底部打印', 'print_credit_sign_tipstyle', '0', '2', now(),'Credit Tip Bottom','签字单小费底部打印');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_setting_newwin';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '报表设置新窗口打开', 'main_setting_newwin', '1', '2', now(),'Setting New Win','报表设置新窗口打开');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='printer_conf_table' AND column_name='PrintBarCode';
if(@count<=0) THEN 
 alter table printer_conf_table add column PrintBarCode int default 1 COMMENT '打印条形码  说明:打印条形码'; 
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_cooktime_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '预约字体大小', 'print_cooktime_fontsize', '14px', '3', now(),'Appointment Font Size','预约字体大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND column_name='HostName';
if(@count<=0) THEN 
 alter table order_payment_table add column HostName varchar(100) COMMENT '主机名'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_cancelword_l1';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '第一语言取消', 'print_cancelword_l1', 'Cancel', '0', now(),'L1 Cancel Word','第一语言取消');
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '第二语言取消', 'print_cancelword_l2', '取消', '0', now(),'L2 Cancel Word','第二语言取消');
end if;
end;
call proc_tempPro;





DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_less_store_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '减少库存权限', 'main_less_store_right', '3', '4', now(),'Store Less Right','减少库存权限');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_close_store_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '关闭库存权限', 'main_close_store_right', '3', '4', now(),'Store Less Right','关闭库存权限');
end if;
end;
call proc_tempPro;


update  setting_menu_table set L1='Cost Report',L2='成本报表' where targetUrl='commissionReport.html';
Delete from setting_menu_table where targetUrl='vipreporttmp.html';

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='storeLogReport.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (1002, 'Store Log Report', '库存变动报表', 'storeLogReport.html', now(),1);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='storeReport.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (1002, 'Store Report', '库存报表', 'storeReport.html', now(),1);
end if;
end;
call proc_tempPro;


create table IF not EXISTS  cashdraw_log_table
(
ID INTEGER not null AUTO_INCREMENT COMMENT 'ID  说明:主键',
HostName VARCHAR(100) not null COMMENT '主机名  说明:主机名',
SignInTime DATETIME not null COMMENT '签到时间  说明:签到时间',
SignInAmount INTEGER not null COMMENT '初始金额  说明:初始金额',
SignOutTime DATETIME COMMENT '签出时间  说明:签出时间',
SignInUserID INTEGER COMMENT '签到操作员  说明:签到操作员',
SignOutUserID INTEGER COMMENT '签出操作员  说明:签出操作员',
SignOutAmount INTEGER COMMENT '签出金额  说明:签出金额',
CreateTime DATE not null COMMENT '时间  说明:时间',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=27039 DEFAULT CHARSET=utf8mb4 COMMENT='钱箱记录表';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_cashneed_cashinout';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '钱箱是否签到', 'main_cashneed_cashinout', '1', '2', now(),'Cash In Out','钱箱是否签到');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='cashinoutReport.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (1002, 'Cash In/Out Report', 'Cash In/Out报表', 'cashinoutReport.html', now(),1);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM botton_main_table
WHERE type=1 and method='cashinout';
if(@count<=0) THEN 
INSERT INTO `botton_main_table` (L1,L2,logoUrl,type,method,rightType,createTime,isshow,doublecheck,weight)  VALUES ('Cash In/Out','Cash In/Out','images/icon/icon_cashdraw.png',1,'cashinout',1,now(),1,0,0);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='FollowGroupID2';
if(@count<=0) THEN 
 alter table menu_table add column FollowGroupID2 varchar(100)  COMMENT '跟随组ID2  说明:跟随组ID2'; 
alter table menu_table add column MutliSelect2  integer  COMMENT '套餐上限2  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID3 varchar(100)  COMMENT '跟随组ID3  说明:跟随组ID3'; 
alter table menu_table add column MutliSelect3  integer  COMMENT '套餐上限3 说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID4 varchar(100)  COMMENT '跟随组ID4  说明:跟随组ID4'; 
alter table menu_table add column MutliSelect4  integer  COMMENT '套餐上限4  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID5 varchar(100)  COMMENT '跟随组ID5  说明:跟随组ID5'; 
alter table menu_table add column MutliSelect5  integer  COMMENT '套餐上限5  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID6 varchar(100)  COMMENT '跟随组ID6  说明:跟随组ID6'; 
alter table menu_table add column MutliSelect6  integer  COMMENT '套餐上限6  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID7 varchar(100)  COMMENT '跟随组ID7  说明:跟随组ID7'; 
alter table menu_table add column MutliSelect7  integer  COMMENT '套餐上限7  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
 alter table menu_table add column FollowGroupID8 varchar(100)  COMMENT '跟随组ID8  说明:跟随组ID8'; 
alter table menu_table add column MutliSelect8  integer  COMMENT '套餐上限8  说明:套餐上限;0：多选，不限制;1：单选;2：多选，限制上限'; 
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_tableno_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '桌号打印字体大小', 'print_tableno_fontsize', '14px', '3', now(),'Table No. FontSize','桌号打印字体大小');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_amount_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '小计字体大小', 'print_amount_fontsize', '12px', '3', now(),'Amount FontSize','小计字体大小');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_tax_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '税率字体大小', 'print_tax_fontsize', '12px', '3', now(),'Tax FontSize','税率字体大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='NoTaxAmount';
if(@count<=0) THEN 
 alter table order_table add column NoTaxAmount int default 0 COMMENT '免税额  说明:免税额'; 
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_split_group_table' AND column_name='NoTaxAmount';
if(@count<=0) THEN 
 alter table order_split_group_table add column NoTaxAmount int default 0 COMMENT '免税额  说明:免税额'; 
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_auto_splitqty';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '分单自动按数量拆分', 'main_auto_splitqty', '1', '2', now(),'Auto Split Qty','分单自动按数量拆分');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_split_detail_table' AND  index_name = 'index_order_split_detail_table_orderid ';
if(@count<=0) THEN 
ALTER TABLE order_split_detail_table ADD INDEX index_order_split_detail_table_orderid (orderID);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='UserOrderNo';
if(@count<=0) THEN 
 alter table order_table add column UserOrderNo varchar(30) COMMENT '用户单号  说明:用户单号'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_printapp_path';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '打印插件路径', 'main_printapp_path', 'C:\\\\Program Files (x86)\\\\MountTaiSoftware\\\\CLodop32\\\\CLodopPrint32.exe', '0', now(),'Path of print app','打印插件路径');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='setting_menu_table' AND column_name='Status';
if(@count<=0) THEN 
 alter table setting_menu_table add column Status integer default 0 COMMENT '状态  说明:0：正常, 1:关闭'; 
alter table setting_menu_table add column RightType integer default 0 COMMENT '权限级别'; 
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_report_otherdate_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '报表日期切换权限', 'main_report_otherdate_right', '0', '4', now(),'Report Date Right','报表日期切换权限');
end if;
end;
call proc_tempPro;


CREATE TABLE IF NOT EXISTS `org_table` (
  `OrgID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID  说明:主键',
  `UUID` varchar(100) NOT NULL COMMENT 'UUID  说明:UUID',
  `ChannelID` int(11) NOT NULL COMMENT '渠道ID  说明:渠道ID',
  `OrgName` varchar(100) NOT NULL COMMENT '机构名称  说明:机构名称',
  `OrgPhoneNo` varchar(50) NOT NULL COMMENT '机构号码  说明:机构号码',
  `CreateTime` datetime NOT NULL COMMENT '开通时间  说明:开通时间',
  `OpUserID` varchar(50) DEFAULT NULL COMMENT '操作员  说明:操作员',
  `MidRestTime` varchar(10) NOT NULL COMMENT '营业中休息时间  说明:营业中休息时间（区分午餐、晚餐）',
  `ValidTime` date NOT NULL COMMENT '有效时间  说明:有效时间，超过有效期，自动关闭接单状态。',
  `OrderMode` int(11) NOT NULL COMMENT '接单模式  说明:接单模式 0：根据客户端状态 1：手动模式',
  `StartOrderTime` varchar(10) DEFAULT NULL COMMENT '接单开始时间  说明:接单开始时间',
  `EndOrderTime` varchar(10) DEFAULT NULL COMMENT '接单结束时间  说明:接单结束时间',
  `OrderStatus` int(11) NOT NULL COMMENT '接单状态  说明:接单状态 0：关闭接单 1：正在接单',
  `Status` int(11) NOT NULL COMMENT '状态  说明:状态 0：关闭 1：正常',
  `ClientStatus` int(11) NOT NULL COMMENT '客户端状态  说明:客户端状态 0：断开 1：已连接',
  `Remark` varchar(500) DEFAULT NULL COMMENT '备注  说明:备注',
  `Street` varchar(500) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `State` varchar(100) DEFAULT NULL,
  `ZipCode` varchar(100) DEFAULT NULL,
  `FixType` int(11) NOT NULL DEFAULT '0',
  `DeliveryCharge` int(11) NOT NULL DEFAULT '0',
  `DeliveryMinAmount` int(11) NOT NULL DEFAULT '99999999',
  `PaymentType` varchar(10) NOT NULL DEFAULT '0,1',
  `TaxRate` float(10,4) NOT NULL DEFAULT '0.0000',
  `TaxRate2` float(10,4) NOT NULL DEFAULT '0.0000',
  `OrgGroupID` int(11) DEFAULT NULL COMMENT '机构组ID',
  `DeliveryType` int(11) DEFAULT NULL COMMENT 'Delivery类型',
  `PickUpType` int(11) DEFAULT NULL COMMENT 'PickUp类型',
  PRIMARY KEY (`OrgID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='机构表';


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='category_group_table' AND column_name='OnlineShowFlag';
if(@count<=0) THEN 
 alter table category_group_table add column OnlineShowFlag integer default 0 COMMENT '在线显示  说明:0：都显示, 1:仅本地显示,2:仅在线显示'; 
 alter table category_group_table add column OnlineLang varchar(500) COMMENT '在线名称'; 
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='category_table' AND column_name='OnlineShowFlag';
if(@count<=0) THEN 
 alter table category_table add column OnlineShowFlag integer default 0 COMMENT '在线显示  说明:0：都显示, 1:仅本地显示,2:仅在线显示'; 
 alter table category_table add column OnlineLang varchar(500) COMMENT '在线名称'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='OnlineShowFlag';
if(@count<=0) THEN 
 alter table menu_table add column OnlineShowFlag integer default 0 COMMENT '在线显示  说明:0：都显示, 1:仅本地显示,2:仅在线显示'; 
 alter table menu_table add column OnlineLang varchar(500) COMMENT '在线名称'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='follow_table' AND column_name='OnlineShowFlag';
if(@count<=0) THEN 
 alter table follow_table add column OnlineShowFlag integer default 0 COMMENT '在线显示  说明:0：都显示, 1:仅本地显示,2:仅在线显示'; 
 alter table follow_table add column OnlineLang varchar(500) COMMENT '在线名称'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='NewFlag';
if(@count<=0) THEN 
 alter table menu_table add column NewFlag integer default 0 COMMENT '是否新品  说明:0：否, 1:是'; 
 alter table menu_table add column HotFlag integer default 0 COMMENT '是否热门  说明:0：否, 1:是'; 
 alter table menu_table add column HotLevel integer default 0 COMMENT '辣度'; 
 alter table menu_table add column LabelInfo varchar(1000) COMMENT '标签'; 
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND column_name='PaymentChange';
if(@count<=0) THEN 
 alter table order_payment_table add column PaymentChange integer default 0 COMMENT '找零金额';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='OnlinePaymentID';
if(@count<=0) THEN 
 alter table order_table add column OnlinePaymentID integer COMMENT '在线付款ID';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='OnlineOrderID';
if(@count<=0) THEN 
 alter table order_table add column OnlineOrderID integer COMMENT '在线订单ID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='commonConf.html?groupID=5';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (39, 'Pay Amount Setting', '付款金额配置', 'commonConf.html?groupID=5', now(),0);
Delete from common_conf_table where groupID=5;
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$5',500,0,now(),8,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$10',1000,0,now(),7,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$15',1500,0,now(),6,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$20',2000,0,now(),5,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$25',2500,0,now(),4,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$30',3000,0,now(),3,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$40',4000,0,now(),2,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (5,'$50',5000,0,now(),1,0);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='commonConf.html?groupID=6';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (39, 'Special Amount Setting', '调味金额配置', 'commonConf.html?groupID=6', now(),0);
Delete from common_conf_table where groupID=6;
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$0.50',50,0,now(),8,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$1.00',100,0,now(),7,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$1.50',150,0,now(),6,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$2.00',200,0,now(),5,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$2.50',250,0,now(),4,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$3.00',300,0,now(),3,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$4.00',400,0,now(),2,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (6,'$5.00',500,0,now(),1,0);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_print_time';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '显示打印时间', 'print_print_time', '1', '2', now(),'Show Print Time','显示打印时间');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_use_timeno';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '使用时间单号', 'main_use_timeno', '1', '2', now(),'Use Time No.','使用时间单号');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_signout_checkunpaid';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '签出检查未付款', 'main_signout_checkunpaid', '1', '2', now(),'Sign Check Unpaid','签出检查未付款');
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='onlineOrder.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (39, 'Online Order Setting', '在线点餐配置', 'onlineOrder.html', now(),0);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='EmailAddress';
if(@count<=0) THEN 
 alter table org_table add column EmailAddress varchar(200) COMMENT 'email地址';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_online_creditpayfun';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '在线信用卡支付', 'main_online_creditpayfun', '1', '2', now(),'Online credit pay','在线信用卡支付');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_gift_reporttype';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '扣减礼品卡预售额', 'main_gift_reporttype', '0', '2', now(),'PreSale Gift Deduction','扣减礼品卡预售额');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_ticket_split';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '每个ITEM打印分隔符', 'print_ticket_split', '1', '2', now(),'Item Print Split','每个ITEM打印分隔符');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='onlineOrder.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup)  VALUES (39, 'Online Order Setting', '在线点餐配置', 'onlineOrder.html', now(),0);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='EmailAddress';
if(@count<=0) THEN 
 alter table org_table add column EmailAddress varchar(200) COMMENT 'email地址';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_online_creditpayfun';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '在线信用卡支付', 'main_online_creditpayfun', '1', '2', now(),'Online credit pay','在线信用卡支付');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_gift_reporttype';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '扣减礼品卡预售额', 'main_gift_reporttype', '0', '2', now(),'PreSale Gift Deduction','扣减礼品卡预售额');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='setting_menu_table' AND column_name='LogoUrl';
if(@count<=0) THEN 
 alter table setting_menu_table add column LogoUrl varchar(100) COMMENT 'LogoUrl'; 

end if;
end;
call proc_tempPro;


update setting_menu_table set logoUrl='/images/blackIcon/icon_maininfo.png' where targetUrl='utop.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_custtype.png' where targetUrl='custType.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_paytype.png' where targetUrl='payType.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_tableset.png' where targetUrl='table.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_printset.png' where targetUrl='printer.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_menugroupset.png' where targetUrl='categoryGroup.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_menuset.png' where targetUrl='category.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_followset.png' where targetUrl='follow.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_indexset.png' where targetUrl='indexpage.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_menurightset.png' where targetUrl='configCmd.html?funGroup=menurightfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_menumainset.png' where targetUrl='configCmd.html?funGroup=menumainfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_menunumset.png' where targetUrl='configCmd.html?funGroup=menunumfun&needlogo=0';
update setting_menu_table set logoUrl='/images/blackIcon/icon_paymentset.png' where targetUrl='configCmd.html?funGroup=paymentfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_ordermainset.png' where targetUrl='configCmd.html?funGroup=orderlistmainfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_orderqueryset.png' where targetUrl='configCmd.html?funGroup=orderlistqueryfun&needlogo=0';
update setting_menu_table set logoUrl='/images/blackIcon/icon_usermainset.png' where targetUrl='configCmd.html?funGroup=userinfomainfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_tablemainset.png' where targetUrl='configCmd.html?funGroup=tableinfomainfun';
update setting_menu_table set logoUrl='/images/blackIcon/icon_tableotherset.png' where targetUrl='configCmd.html?funGroup=tableinfotablefun&needlogo=0';
update setting_menu_table set logoUrl='/images/blackIcon/icon_printoptions.png' where targetUrl='options.html?settingGroup=1';
update setting_menu_table set logoUrl='/images/blackIcon/icon_rightoptions.png' where targetUrl='options.html?settingGroup=2';
update setting_menu_table set logoUrl='/images/blackIcon/icon_specgroupset.png' where targetUrl='specGroup.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_specset.png' where targetUrl='spec.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_specopset.png' where targetUrl='specOperation.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_userset.png' where targetUrl='user.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_deliveryset.png' where targetUrl='driver.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_displayoptions.png' where targetUrl='options.html?settingGroup=4&menudisplayflag=1';
update setting_menu_table set logoUrl='/images/blackIcon/icon_busoptions.png' where targetUrl='options.html?settingGroup=3';
update setting_menu_table set logoUrl='/images/blackIcon/icon_doubledisplayoptions.png' where targetUrl='options.html?settingGroup=5';
update setting_menu_table set logoUrl='/images/blackIcon/icon_countgroupset.png' where targetUrl='countgourp.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_hardwareoptions.png' where targetUrl='options.html?settingGroup=6';
update setting_menu_table set logoUrl='/images/blackIcon/icon_paxset.png' where targetUrl='reader.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_rateset.png' where targetUrl='commonConf.html?groupID=1';
update setting_menu_table set logoUrl='/images/blackIcon/icon_amountset.png' where targetUrl='commonConf.html?groupID=2';
update setting_menu_table set logoUrl='/images/blackIcon/icon_rateset.png' where targetUrl='commonConf.html?groupID=3';
update setting_menu_table set logoUrl='/images/blackIcon/icon_amountset.png' where targetUrl='commonConf.html?groupID=4';
update setting_menu_table set logoUrl='/images/blackIcon/icon_tipsuggestionset.png' where targetUrl='tipSuggestion.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_sysset.png' where targetUrl='systemConf.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_report1.png' where targetUrl='dailyreport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_report2.png' where targetUrl='detailreport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_report3.png' where targetUrl='monthreport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_userreport.png' where targetUrl='employeereport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_storelogreport.png' where targetUrl='storeLogReport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_report4.png' where targetUrl='yearreport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_report5.png' where targetUrl='weeklyreport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_costreport.png' where targetUrl='commissionReport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_store.png' where targetUrl='storeReport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_cashinoutreport.png' where targetUrl='cashinoutReport.html';
update setting_menu_table set logoUrl='/images/blackIcon/icon_paymentamountset.png' where targetUrl='commonConf.html?groupID=5';
update setting_menu_table set logoUrl='/images/blackIcon/icon_specamountset.png' where targetUrl='commonConf.html?groupID=6';
update setting_menu_table set logoUrl='/images/blackIcon/icon_onlineorderset.png' where targetUrl='onlineOrder.html';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_ticket_split';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '每个ITEM打印分隔符', 'print_ticket_split', '1', '2', now(),'Item Print Split','每个ITEM打印分隔符');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_ordertime';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_ordertime (OrderTime);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='table_order_table' AND  index_name = 'index_table_order_table_tableid';
if(@count<=0) THEN 
ALTER TABLE table_order_table ADD INDEX index_table_order_table_tableid (tableid);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_autoprint_hostname';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '自动打印机器名', 'print_autoprint_hostname', '', '0', now(),'Auto Print Hostname','自动打印机器名');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='AppointmentPrint';
if(@count<=0) THEN 
 alter table order_table add column AppointmentPrint int default 0  COMMENT '预约是否打印  说明:0:未打印 1:已打印';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_tax_discount';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '税打折', 'main_tax_discount', '1', '2', now(),'Discount Tax','税打折');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_tax_delivery';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '外卖费收税', 'main_tax_delivery', '1', '2', now(),'Delivery Tax','外卖费收税');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MinAmount';
if(@count<=0) THEN 
 alter table org_table add column MinAmount integer default 0 COMMENT '最低金额';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='pax_batch_detail_table' AND  index_name = 'index_pax_batch_detail_table_batchid';
if(@count<=0) THEN 
ALTER TABLE pax_batch_detail_table ADD INDEX index_pax_batch_detail_table_batchid (batchID);
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='op_log_table' AND column_name='UserOrderNo';
if(@count<=0) THEN 
 alter table op_log_table add column UserOrderNo varchar(20) COMMENT '时间单号';
end if;
end;
call proc_tempPro;

 alter table op_log_table modify column UpdateTime datetime COMMENT '创建时间';


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='op_log_table' AND  index_name = 'index_op_log_table_userorderno';
if(@count<=0) THEN 
ALTER TABLE op_log_table ADD INDEX index_op_log_table_userorderno (UserOrderNo);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_report_utop';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '报表打印UTOP', 'print_report_utop', '0', '2', now(),'Report print utop','报表打印UTOP');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='printer_conf_table' AND column_name='SimilarMerger';
if(@count<=0) THEN 
 alter table printer_conf_table add column SimilarMerger integer default 0 COMMENT '同类合并';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_paid_changeserver';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '付款修改Server', 'main_paid_changeserver', '1', '2', now(),'Pay Change Server','付款修改Server');
end if;
end;
call proc_tempPro;



create table if not EXISTS time_group_table
(
TimeGroupID INTEGER not null AUTO_INCREMENT COMMENT '组ID  说明:主键',
GroupName VARCHAR(100) not null COMMENT '组名  说明:组名',
W1 INTEGER not null COMMENT '周1  说明:周1',
W2 INTEGER not null COMMENT '周2  说明:周2',
W3 INTEGER not null COMMENT '周3  说明:周3',
W4 INTEGER not null COMMENT '周4  说明:周4',
W5 INTEGER not null COMMENT '周5  说明:周5',
W6 INTEGER not null COMMENT '周6  说明:周6',
W7 INTEGER not null COMMENT '周7  说明:周7',
StartTime VARCHAR(10) not null COMMENT '开始时间  说明:开始时间',
EndTime VARCHAR(10) not null COMMENT '结束时间  说明:结束时间',
OnlineStartTime VARCHAR(10) not null COMMENT '在线开始时间  说明:在线开始时间',
OnlineEndTime VARCHAR(10) not null COMMENT '在线结束时间  说明:在线结束时间',
Remark VARCHAR(500) COMMENT '备注  说明:备注',
CreateTime DATE not null COMMENT '创建时间  说明:创建时间',
  PRIMARY KEY (`TimeGroupID`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='时间组表';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='category_table' AND column_name='TimeGroupID';
if(@count<=0) THEN 
 alter table category_table add column TimeGroupID integer default 0 COMMENT '时间组';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='timeGroup.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup,logoUrl)  VALUES (2, 'Time Group Setting', '时间组配置', 'timeGroup.html', now(),0,'/images/blackIcon/icon_time.png');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='Picurl';
if(@count<=0) THEN 
 alter table menu_table add column Picurl varchar(500) COMMENT '图片地址';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DineInType';
if(@count<=0) THEN 
 alter table org_table add column DineInType integer COMMENT 'Dine In类型';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='PickUpMinAmount';
if(@count<=0) THEN 
 alter table org_table add column PickUpMinAmount integer default 0 COMMENT '来取起送金额';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND column_name='AppointmentTime';
if(@count<=0) THEN 
 alter table order_detail_table add column AppointmentTime datetime COMMENT '预约打印时间';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='commonConf.html?groupID=7';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup,logoUrl)  VALUES (39, 'Time Select Setting', '时间选择配置', 'commonConf.html?groupID=7', now(),0,'/images/blackIcon/icon_time.png');
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (7,'3 Min',3,0,now(),8,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (7,'6 Min',6,0,now(),7,0);
Insert into common_conf_table (GroupID,ShowDesc,Value,Status,CreateTime,Weight,RightType) values (7,'9 Min',9,0,now(),6,0);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='ModifyFlag';
if(@count<=0) THEN 
 alter table org_table add column ModifyFlag integer default 0 COMMENT '是否可改单，0：可改；1：不可改';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OrgPhone2';
if(@count<=0) THEN 
 alter table org_table add column OrgPhone2 varchar(30)  COMMENT '号码2';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='NeedTip';
if(@count<=0) THEN 
 alter table org_table add column NeedTip integer default 0 COMMENT '是否收小费，0：不可；1：可收小费';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MapKey';
if(@count<=0) THEN 
 alter table org_table add column MapKey varchar(100) COMMENT '地图KEY';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryCharge2';
if(@count<=0) THEN 
 alter table org_table add column DeliveryCharge2 integer default 0 COMMENT '外送费2';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryDistince';
if(@count<=0) THEN 
 alter table org_table add column DeliveryDistince float(10,2) default 0 COMMENT '距离';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryDistince2';
if(@count<=0) THEN 
 alter table org_table add column DeliveryDistince2 float(10,2) default 0 COMMENT '距离2';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_delivery_key';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '地图KEY', 'main_delivery_key', '', 0, now(),'Delivery Tax','地图KEY');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_table' AND column_name='Distince';
if(@count<=0) THEN 
 alter table cust_table add column Distince integer default 0 COMMENT '距离(米)';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_table' AND column_name='Distince2';
if(@count<=0) THEN 
 alter table cust_table add column Distince2 varchar(50)  COMMENT '距离(MI)';
end if;
end;
call proc_tempPro;





DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_split_detail_table' AND column_name='ListIndex';
if(@count<=0) THEN 
 alter table order_split_detail_table add column ListIndex integer default 0 COMMENT '序列';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_value_type_table
WHERE valueType=15;
if(@count<=0) THEN 
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (15,'Always Print',0,'Always Print','总是打印',now());
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (15,'Print',1,'Print','打印',now());
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (15,'No Print',2,'No Print','不打印',now());
Update default_setting_table set valueType=15 where settingKey='print_sign_tip';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='hardware_scale';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '6', '电子秤', 'hardware_scale', '0', '7', now(),'Scale','电子秤');
end if;
end;
call proc_tempPro;


alter table cust_type_table modify column ServiceCharge float(10,2);


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_type_table' AND column_name='AutoPrint';
if(@count<=0) THEN 
 alter table cust_type_table add column AutoPrint integer default 0 COMMENT '自动打印; 0:是;1:否';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryTax';
if(@count<=0) THEN 
 alter table org_table add column DeliveryTax integer default 1 COMMENT '外卖费收税';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_appointmentprint';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_appointmentprint (appointmentPrint);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_appointmenttime';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_appointmenttime (appointmentTime);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_custtype';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_custtype (custType);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_orderid';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_orderid (orderID);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_isPrint';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_isPrint (isPrint);
end if;
end;
call proc_tempPro;

update order_table set AppointmentPrint=1 where TO_DAYS(orderTime) < TO_DAYS(now())-3;
update default_setting_table set SettingValue='Server' where  SettingKey='print_autoprint_hostname' and (settingValue = '' or settingValue is null);

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_batch_detail';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印BATCH明细', 'print_batch_detail', '0', '2', now(),'Print Batch Detail','打印BATCH明细');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_credit_receipt';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '是否打印签字单', 'print_credit_receipt', '0', '2', now(),'Print Credit Receipt','是否打印签字单');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DiscountRate';
if(@count<=0) THEN 
 alter table org_table add column DiscountRate integer default 0 COMMENT '折扣率';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DiscountTax';
if(@count<=0) THEN 
 alter table org_table add column DiscountTax integer default 1 COMMENT '税打折';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_online_appid';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '连锁ID', 'main_online_appid', '', 0, now(),'App ID','连锁ID');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_online_appkey';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '连锁Key', 'main_online_appkey', '', 0, now(),'App Key','连锁Key');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='pax_batch_detail_table' AND  index_name = 'index_pax_batch_detail_table_batchid';
if(@count<=0) THEN 
ALTER TABLE pax_batch_detail_table ADD INDEX index_pax_batch_detail_table_batchid (BatchID);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='vip_card_table' AND  index_name = 'index_vip_card_table_cardno';
if(@count<=0) THEN 
ALTER TABLE vip_card_table ADD unique INDEX index_vip_card_table_cardno(CardNo);
end if;
end;
call proc_tempPro;



CREATE TABLE IF NOT EXISTS `payout_log_table` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID  说明:主键',
  `HostName` varchar(100) NOT NULL COMMENT '主机名  说明:主机名',
  `OrderTime` date NOT NULL COMMENT '记录日期  说明:记录时间',
  `CreateTime` datetime NOT NULL COMMENT '创建时间  说明:创建时间',
  `Reason` varchar(1000) NOT NULL COMMENT '理由  说明:理由',
  `Amount` int(11) NOT NULL COMMENT '金额  说明:金额',
  `OpUserID` int(11) NOT NULL COMMENT '操作员ID  说明:操作员ID',
  `OpUserName` varchar(200) NOT NULL COMMENT '操作员  说明:操作员',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='支出记录表';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='payout.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L1,L2,targetUrl,createTime,menuGroup,LogoUrl)  VALUES (1002, 'Payout Report', '支出报表', 'payout.html', now(),1,'/images/blackIcon/icon_costreport.png');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='ModifyFlag';
if(@count<=0) THEN 
 alter table order_table add column ModifyFlag integer default 0 COMMENT '修改标志';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_remark_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '备注打印大小', 'print_remark_fontsize', '16px', '3', now(),'Remark Font Size','备注打印大小');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_type_table' AND column_name='SelfFlag';
if(@count<=0) THEN 
 alter table cust_type_table add column SelfFlag integer default 0 COMMENT '支持自助';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='pay_type_table' AND column_name='SelfFlag';
if(@count<=0) THEN 
 alter table pay_type_table add column SelfFlag integer default 0 COMMENT '支持自助';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='cust_table' AND  index_name = 'index_cust_table_phoneno';
if(@count<=0) THEN 
ALTER TABLE cust_table ADD INDEX index_cust_table_phoneno (PhoneNo);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_self_tsinfo';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '自助完成提示', 'main_self_tsinfo', '', 0, now(),'Self Mode Info','自助完成提示');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_index_bgimg';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '首页背景图地址', 'main_index_bgimg', '', 0, now(),'Index Page Imgurl','首页背景图地址');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_index_pagemode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '首页样式模式', 'main_index_pagemode', '0', '16', now(),'Index Display Mode','首页样式模式');
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (16,'Default Mode',0,'Default Mode','默认模式',now());
INSERT INTO `setting_value_type_table` (valueType,valueTypeDesc,settingValue,l1,l2,createTime)  VALUES (16,'Tint Mode',1,'Tint Mode','浅色模式',now());
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_index_bgimg';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '首页背景图地址', 'main_index_bgimg', '', 0, now(),'Index Page Imgurl','首页背景图地址');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_index_custtype_bgcolor';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '首页客户类型背景颜色', 'main_index_custtype_bgcolor', '#333', 0, now(),'Index Page CustType BgColor','首页客户类型背景颜色');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_index_custtype_bgcolor';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '首页客户类型背景颜色', 'main_index_custtype_bgcolor', '#333', 0, now(),'Index Page CustType BgColor','首页客户类型背景颜色');
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_menu_rightbotton_invert';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '点单页面浅色模式', 'main_menu_rightbotton_invert',1, 2, now(),'Menu Page Tint Mode','点单页面浅色模式');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_orderlist_invert';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '历史页面黑色按钮', 'main_orderlist_invert',1, 2, now(),'Order Page Black Botton','历史页面黑色按钮');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_table_pagemode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '4', '桌子页面模式', 'main_table_pagemode', '0', '16', now(),'Table Display Mode','桌子页面模式');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OnlineFeeRate';
if(@count<=0) THEN 
 alter table org_table add column OnlineFeeRate integer default 0  COMMENT '在线手续费率';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='category_table' AND column_name='Picurl';
if(@count<=0) THEN 
 alter table category_table add column Picurl varchar(500) COMMENT '图片地址';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='follow_table' AND column_name='Picurl';
if(@count<=0) THEN 
 alter table follow_table add column Picurl varchar(500) COMMENT '图片地址';
end if;
end;
call proc_tempPro;






DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='PickUpFlag';
if(@count<=0) THEN 
 alter table order_table add column PickUpFlag int default 0 COMMENT '取货状态  说明:取货状态 0：未取货；1：已取货'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='PickUpTime';
if(@count<=0) THEN 
 alter table order_table add column PickUpTime datetime COMMENT '取货时间  说明:取货时间'; 
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='cust_table' AND column_name='PayRemark';
if(@count<=0) THEN 
 alter table cust_table add column PayRemark varchar(100) COMMENT '付款备注  说明:付款备注'; 
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='GroupMode';
if(@count<=0) THEN 
 alter table menu_table add column GroupMode integer default 0 COMMENT '组模式  说明:组模式 0：非组模式 1：组模式'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='menu_table' AND column_name='FGroupMenuID';
if(@count<=0) THEN 
 alter table menu_table add column FGroupMenuID integer COMMENT '父组菜单ID  说明:父组菜单ID'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='follow_table' AND column_name='PrintMode';
if(@count<=0) THEN 
 alter table follow_table add column PrintMode integer default 0 COMMENT '打印模式  说明:0：主菜 1：主菜+跟随'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND column_name='SignatureData';
if(@count<=0) THEN 
 alter table order_payment_table add column SignatureData text COMMENT '签名数据'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_superposition_uptax';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '是否叠加税上税', 'main_superposition_uptax', '1', '2', now(),'Superposition Double Tax','是否叠加税上税');
end if;
end;
call proc_tempPro;



CREATE TABLE IF not EXISTS print_mission_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID 主键' ,
    MissionType INT(10) NOT NULL   COMMENT '任务类型 任务类型
0：订单打印任务
1：分单打印任务
2：签字单打印任务' ,
    CreateTime DATETIME NOT NULL   COMMENT '创建时间' ,
    MissionHostName VARCHAR(100) NOT NULL   COMMENT '执行主机名' ,
    SendHostName VARCHAR(100) NOT NULL   COMMENT '登记主机名' ,
    Value1 TEXT    COMMENT '字段1' ,
    Value2 TEXT    COMMENT '字段2' ,
    Value3 TEXT    COMMENT '字段3' ,
    Value4 TEXT    COMMENT '字段4' ,
    Value5 TEXT    COMMENT '字段5' ,
    Value6 TEXT    COMMENT '字段6' ,
    Value7 TEXT    COMMENT '字段7' ,
    Value8 TEXT    COMMENT '字段8' ,
    Value9 TEXT    COMMENT '字段9' ,
    Value10 TEXT    COMMENT '字段10' ,
    PRIMARY KEY (ID)
) COMMENT = '打印任务表 ';


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_discount_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '折扣打印大小', 'print_discount_fontsize', '12px', '3', now(),'Discount Font Size','折扣打印大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_deliverycharge_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '外卖费打印大小', 'print_deliverycharge_fontsize', '12px', '3', now(),'DeliveryCharge Font Size','外卖费打印大小');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_tip_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '小费打印大小', 'print_tip_fontsize', '12px', '3', now(),'Tip Font Size','小费打印大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_cashdraw_lodop';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '钱箱插件模式', 'main_cashdraw_lodop', '1', '2', now(),'Cashdrawer Lodop','钱箱插件模式');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_sms_apikey';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '短信APIKEY', 'main_sms_apikey', '', '0', now(),'SMS API Key','短信APIKEY');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_sms_apisecret';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '短信APISecRet', 'main_sms_apisecret', '', '0', now(),'SMS API Secret','短信APISecret');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_sms_apifrom';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '短信主叫', 'main_sms_apifrom', '', '0', now(),'SMS From','短信主叫');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_sms_orderready_info';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '短信内容(Ready)', 'main_sms_orderready_info', '', '0', now(),'SMS Info(Ready)','短信内容(Ready)');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_auto_cust_point';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '会员自动积分', 'main_auto_cust_point', '1', '2', now(),'Cust Auto Point','会员自动积分');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliveryTime';
if(@count<=0) THEN 
 alter table order_table add column DeliveryTime DateTime  COMMENT '配送时间'; 
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SmsApiID';
if(@count<=0) THEN 
 alter table org_table add column SmsApiID varchar(100) COMMENT '短信APIID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SmsApiKey';
if(@count<=0) THEN 
 alter table org_table add column SmsApiKey varchar(100) COMMENT '短信APIKEY';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SmsFrom';
if(@count<=0) THEN 
 alter table org_table add column SmsFrom varchar(100) COMMENT '短信主叫';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SmsValidInfo';
if(@count<=0) THEN 
 alter table org_table add column SmsValidInfo varchar(100) COMMENT '短信验证码内容';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OpenApiID';
if(@count<=0) THEN 
 alter table org_table add column OpenApiID varchar(100) COMMENT '连锁ID';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OpenApiKey';
if(@count<=0) THEN 
 alter table org_table add column OpenApiKey varchar(100) COMMENT '连锁KEY';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_auto_giftpay';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '会员余额自动提示', 'main_auto_giftpay', '1', '2', now(),'Gift Auto Pay','会员余额自动提示');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='PaymentTsInfo';
if(@count<=0) THEN 
 alter table org_table add column PaymentTsInfo text COMMENT '付款提示信息';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='PayByDoorInfo';
if(@count<=0) THEN 
 alter table org_table add column PayByDoorInfo varchar(100) COMMENT '到店付款提示内容';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_second_signature';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '5', '双屏签字', 'main_second_signature', '1', '2', now(),'Second Signature','双屏签字');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_discounttip_inputmode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '折扣小费小数点输入', 'main_discounttip_inputmode', '0', '2', now(),'Discount Tip Point Input','折扣小费小数点输入');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_printtime_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印时间大小', 'print_printtime_fontsize', '12px', '3', now(),'Print Time Font Size','打印时间大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='QROrderMustLogin';
if(@count<=0) THEN 
 alter table org_table add column QROrderMustLogin int default 0 COMMENT '扫码点单是否登陆';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='follow_table' AND column_name='CountGroupID';
if(@count<=0) THEN 
 alter table follow_table add column CountGroupID integer default 0 COMMENT '统计组';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_server_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '服务员打印大小', 'print_server_fontsize', '14px', '3', now(),'Server Font Size','服务员打印大小');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_guestNo_fontsize';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '人数打印大小', 'print_guestNo_fontsize', '12px', '3', now(),'Guest No. Font Size','人数打印大小');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='AutoCode';
if(@count<=0) THEN 
 alter table org_table add column AutoCode int default 0 COMMENT 'PickUp自动编号';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='tip_suggestion_table' AND column_name='OnlineShowFlag';
if(@count<=0) THEN 
 alter table tip_suggestion_table add column OnlineShowFlag int default 0 COMMENT '0：都显示, 1:仅本地显示,2:仅在线显示';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MailSender';
if(@count<=0) THEN 
 alter table org_table add column MailSender varchar(100) COMMENT 'MailSender';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MailPassword';
if(@count<=0) THEN 
 alter table org_table add column MailPassword varchar(100) COMMENT 'MailPassword';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MailSmtp';
if(@count<=0) THEN 
 alter table org_table add column MailSmtp varchar(100) COMMENT 'MailSmtp';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MailPort';
if(@count<=0) THEN 
 alter table org_table add column MailPort varchar(100) COMMENT 'MailPort';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OnlineSignature';
if(@count<=0) THEN 
 alter table org_table add column OnlineSignature int default 0 COMMENT '0：不签名;1：需要签名';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='StartOrderTime2';
if(@count<=0) THEN 
 alter table org_table add column StartOrderTime2 varchar(10);
 alter table org_table add column EndOrderTime2 varchar(10);
 alter table org_table add column StartOrderTime3 varchar(10);
 alter table org_table add column EndOrderTime3 varchar(10);
 alter table org_table add column StartOrderTime4 varchar(10);
 alter table org_table add column EndOrderTime4 varchar(10);
 alter table org_table add column StartOrderTime5 varchar(10);
 alter table org_table add column EndOrderTime5 varchar(10);
 alter table org_table add column StartOrderTime6 varchar(10);
 alter table org_table add column EndOrderTime6 varchar(10);
 alter table org_table add column StartOrderTime7 varchar(10);
 alter table org_table add column EndOrderTime7 varchar(10);
 update org_table set StartOrderTime2=StartOrderTime,StartOrderTime3=StartOrderTime,StartOrderTime4=StartOrderTime,StartOrderTime5=StartOrderTime,StartOrderTime6=StartOrderTime,StartOrderTime7=StartOrderTime;
 update org_table set EndOrderTime2=EndOrderTime,EndOrderTime3=EndOrderTime,EndOrderTime4=EndOrderTime,EndOrderTime5=EndOrderTime,EndOrderTime6=EndOrderTime,EndOrderTime7=EndOrderTime;

end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DiscountMode';
if(@count<=0) THEN 
 alter table org_table add column DiscountMode int default 0 COMMENT '0：总数;1：小计';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OnlineFeeMode';
if(@count<=0) THEN 
 alter table org_table add column OnlineFeeMode int default 0 COMMENT '0：比例;1：固定金额';
end if;
end;
call proc_tempPro;



CREATE TABLE if not EXISTS kds_mission_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    OrderID INT(10)    COMMENT '订单号' ,
    PrinterID INT(10)    COMMENT '打印机ID' ,
    CreateTime DATETIME    COMMENT '创建时间' ,
    PRIMARY KEY (ID)
) COMMENT = 'KDS任务表 ';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND column_name='KDSStatus';
if(@count<=0) THEN 
 alter table order_detail_table add column KDSStatus int default 0 COMMENT 'KDS状态 0:未处理;1:已处理';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_kdsstatus';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_kdsstatus (kdsStatus);
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_gratuity_tax';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印服务费税', 'print_gratuity_tax', '1', '2', now(),'Print Gratuity Tax','打印服务费税');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SplitItem';
if(@count<=0) THEN 
 alter table org_table add column SplitItem int default 0 COMMENT '0：不拆分;1：拆分';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND column_name='OpUserID';
if(@count<=0) THEN 
 alter table order_detail_table add column OpUserID int COMMENT '操作员ID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND column_name='OpUserName';
if(@count<=0) THEN 
 alter table order_detail_table add column OpUserName varchar(500) COMMENT '操作员';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_detail_table' AND  index_name = 'index_order_detail_table_opuserid';
if(@count<=0) THEN 
ALTER TABLE order_detail_table ADD INDEX index_order_detail_table_opuserid (OpUserID);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_auto_save_opinfo';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '明细自动保存操作员', 'main_auto_save_opinfo', '1', '2', now(),'Auto Save OpInfo','明细自动保存操作员');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND column_name='CardType';
if(@count<=0) THEN 
 alter table order_payment_table add column CardType varchar(30) COMMENT '卡类型'; 
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_payment_table' AND  index_name = 'index_order_payment_table_cardtype';
if(@count<=0) THEN 
ALTER TABLE order_payment_table ADD INDEX index_order_payment_table_cardtype (CardType);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_dailyreport_showcardtype';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '报表显示卡类型统计', 'main_dailyreport_showcardtype', '1', '2', now(),'Report Show Card Type','报表显示卡类型统计');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='Remark2';
if(@count<=0) THEN 
 alter table org_table add column Remark2 varchar(4000) COMMENT '备注2'; 
end if;
end;
call proc_tempPro;


delete from setting_value_type_table where ValueType=8;
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '2', '2px', '2018-7-18', '2', '2');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '3', '3px', '2018-7-18', '3', '3');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '4', '4px', '2018-7-18', '4', '4');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '5', '5px', '2018-7-18', '5', '5');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '6', '6px', '2018-7-18', '6', '6');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '7', '7px', '2018-7-18', '7', '7');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '8', '8px', '2018-7-18', '8', '8');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '10', '10px', '2018-7-20', '10', '10');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '15', '15px', '2020-12-18', '15', '15');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '20', '20px', '2020-12-18', '20', '20');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '25', '25px', '2020-12-18', '25', '25');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '30', '30px', '2020-12-18', '30', '30');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '40', '40px', '2020-12-18', '40', '40');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '50', '50px', '2020-12-18', '50', '50');
INSERT INTO `setting_value_type_table` (`ValueType`, `ValueTypeDesc`, `SettingValue`, `CreateTime`, `L1`, `L2`) VALUES (8, '75', '75px', '2020-12-18', '75', '75');


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_doubletax';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印第二税', 'print_doubletax', '1', '2', now(),'Report Show Card Type','打印第二税');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_credit_bottom_word';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '签字单底部文字', 'print_credit_bottom_word', 'Thank you very much!', '0', now(),'Credit Bottom Word','签字单底部文字');
select SettingValue into @datavalue  from default_setting_table where SettingKey='print_bottom_word';
update default_setting_table set SettingValue =@datavalue where SettingKey='print_credit_bottom_word';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryZipCode';
if(@count<=0) THEN 
 alter table org_table add column DeliveryZipCode varchar(1000) COMMENT '外送区域限制，多个逗号隔开';
end if;
end;
call proc_tempPro;






DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='PickUpTime';
if(@count<=0) THEN 
 alter table org_table add column PickUpTime int default 0  COMMENT '来取时间';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryTime';
if(@count<=0) THEN 
 alter table org_table add column DeliveryTime int default 0  COMMENT '外送时间';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='BusyPickUpTime';
if(@count<=0) THEN 
 alter table org_table add column BusyPickUpTime int default 0  COMMENT '忙时来取时间';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='BusyDeliveryTime';
if(@count<=0) THEN 
 alter table org_table add column BusyDeliveryTime int default 0  COMMENT '忙时外送时间';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='BusyFlag';
if(@count<=0) THEN 
 alter table org_table add column BusyFlag int default 0  COMMENT '忙时标志';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='AppointmentFlag';
if(@count<=0) THEN 
 alter table org_table add column AppointmentFlag int default 0  COMMENT '是否预约时间，0：不预约；1：预约1天；2：预约2天';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DiscountMInAmount';
if(@count<=0) THEN 
 alter table org_table add column DiscountMinAmount int default 0  COMMENT '折扣最低金额';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_label_custtype';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '标签打印客户类型', 'print_label_custtype', '1', '2', now(),'Label Print CustType','标签打印客户类型');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_label_splitmode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '标签数量拆分', 'print_label_splitmode', '1', '2', now(),'Label Split Mode','标签数量拆分');
end if;
end;
call proc_tempPro;




CREATE TABLE IF NOT EXISTS callerid_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    HostName VARCHAR(100)    COMMENT '主机名' ,
    Sign VARCHAR(100)    COMMENT '标记' ,
    PhoneNo VARCHAR(100)    COMMENT '号码' ,
    CreateTime DATETIME    COMMENT '创建时间' ,
    PRIMARY KEY (ID)
) COMMENT = '来电显示记录表 ';


CREATE TABLE IF NOT EXISTS  callerid_his_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    HostName VARCHAR(100)    COMMENT '主机名' ,
    Sign VARCHAR(100)    COMMENT '标记' ,
    PhoneNo VARCHAR(100)    COMMENT '号码' ,
    CreateTime DATETIME    COMMENT '创建时间' ,
    UseHostName VARCHAR(100)    COMMENT '使用主机' ,
    UseTime DATETIME    COMMENT '使用时间' ,
    OpUserID INT(10)    COMMENT '使用人ID' ,
    OpUserName VARCHAR(100)    COMMENT '使用人名称' ,
    PRIMARY KEY (ID)
) COMMENT = '来电显示历史表 ';


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryCharge3';
if(@count<=0) THEN 
 alter table org_table add column DeliveryCharge3 int default 0  COMMENT '外卖费3';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryCharge4';
if(@count<=0) THEN 
 alter table org_table add column DeliveryCharge4 int default 0  COMMENT '外卖费4';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryCharge5';
if(@count<=0) THEN 
 alter table org_table add column DeliveryCharge5 int default 0  COMMENT '外卖费5';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryDistince3';
if(@count<=0) THEN 
 alter table org_table add column DeliveryDistince3 float(10,2) default 0  COMMENT '外送距离3';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryDistince4';
if(@count<=0) THEN 
 alter table org_table add column DeliveryDistince4 float(10,2) default 0  COMMENT '外送距离4';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DeliveryDistince5';
if(@count<=0) THEN 
 alter table org_table add column DeliveryDistince5 float(10,2) default 0  COMMENT '外送距离5';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_report_tip_feerate';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '报表打印小费费率', 'print_report_tip_feerate', '0', '0', now(),'Report Print Tip FeeRate','报表打印小费费率');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='RestStartTime';
if(@count<=0) THEN 
 alter table org_table add column RestStartTime varchar(10) default '0';
 alter table org_table add column RestEndTime varchar(10) default '0';
 alter table org_table add column RestStartTime2 varchar(10) default '0';
 alter table org_table add column RestEndTime2 varchar(10) default '0';
 alter table org_table add column RestStartTime3 varchar(10) default '0';
 alter table org_table add column RestEndTime3 varchar(10) default '0';
 alter table org_table add column RestStartTime4 varchar(10) default '0';
 alter table org_table add column RestEndTime4 varchar(10) default '0';
 alter table org_table add column RestStartTime5 varchar(10) default '0';
 alter table org_table add column RestEndTime5 varchar(10) default '0';
 alter table org_table add column RestStartTime6 varchar(10) default '0';
 alter table org_table add column RestEndTime6 varchar(10) default '0';
 alter table org_table add column RestStartTime7 varchar(10) default '0';
 alter table org_table add column RestEndTime7 varchar(10) default '0';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_creditcard_chip';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '签字单打印加密标志', 'print_creditcard_chip', '0', '2', now(),'Print Credit Card Chip','签字单打印加密标志');
end if;
end;
call proc_tempPro;


alter table order_table modify CustNo float(11,2);


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_second_addtip';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '5', '双屏小费', 'main_second_addtip', '1', '2', now(),'Second Add Tip','双屏小费');
end if;
end;
call proc_tempPro;





DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_custid';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_custid (custid);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_phoneno';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_phoneno (phoneno);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='cust_table' AND  index_name = 'index_cust_table_custid';
if(@count<=0) THEN 
ALTER TABLE cust_table ADD INDEX index_cust_table_custid (custid);
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='GuestOrder';
if(@count<=0) THEN 
 alter table org_table add column GuestOrder int default 0  COMMENT '游客下单';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_payment_inputmode';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '付款金额小数点输入', 'main_payment_inputmode', '1', '2', now(),'Payment Point Input','付款金额小数点输入');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MaxOrderAmount';
if(@count<=0) THEN 
 alter table org_table add column MaxOrderAmount int default 100000 COMMENT '最大订单金额';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='count_group_table' AND column_name='CountRate';
if(@count<=0) THEN 
 alter table count_group_table add column CountRate float(10,2) default 0  COMMENT '统计比例';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_order_payment_kitchenprint';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '点单界面付款必送', 'print_order_payment_kitchenprint', '1', '2', now(),'Order Payment Must Print','点单界面付款必送');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_itemamount_click_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '总计点击权限', 'main_itemamount_click_right', '0', '4', now(),'Amount Click Amount','总计点击权限');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliverectID';
if(@count<=0) THEN 
 alter table order_table add column DeliverectID int default 0  COMMENT 'DeliverectID';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliverectOrderID';
if(@count<=0) THEN 
 alter table order_table add column DeliverectOrderID varchar(100)  COMMENT 'DeliverectOrderID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliverectStatus';
if(@count<=0) THEN 
 alter table order_table add column DeliverectStatus int default 0  COMMENT 'DeliverectStatus';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliverectChannel';
if(@count<=0) THEN 
 alter table order_table add column DeliverectChannel varchar(50)  COMMENT 'DeliverectChannel';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='DeliverectStatus';
if(@count<=0) THEN 
 alter table order_table add column DeliverectStatus int default 0  COMMENT 'DeliverectStatus';
end if;
end;
call proc_tempPro;






DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_receipt_cardtype';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '收据打印卡类型', 'print_receipt_cardtype', '1', '2', now(),'Receipt Print CardType','收据打印卡类型');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM setting_menu_table
WHERE TargetUrl='onlineOrderConf.html';
if(@count<=0) THEN 
INSERT INTO `setting_menu_table` (fid,L2,L1,targetUrl,createTime,menuGroup,status,logoUrl)  VALUES (39, '外卖平台配置', 'Deliverect Conf', 'onlineOrderConf.html', now(),0,0,'/images/blackIcon/icon_countgroupset.png');
end if;
end;
call proc_tempPro;


CREATE TABLE if not exists online_order_conf_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    Name VARCHAR(1000)    COMMENT '名称' ,
    AccountID VARCHAR(1000)    COMMENT 'AccountID' ,
    LocationID VARCHAR(1000)    COMMENT 'LocationID' ,
    ChannelID VARCHAR(1000)    COMMENT 'ChannelID' ,
    PickupType INT(10)    COMMENT 'PickupType' ,
    DeliveryType INT(10)    COMMENT 'DeliveryType' ,
    DineinType INT(10)    COMMENT 'DineinType' ,
    CurbsideType INT(10)    COMMENT 'CurbsideType' ,
    CategoryGroupID VARCHAR(100)    COMMENT '菜单组' ,
    DeliveryTax INT(10)   DEFAULT 0 COMMENT 'DeliveryTax' ,
    TakeawayTax INT(10)   DEFAULT 0 COMMENT 'TakeawayTax' ,
    EatInTax INT(10)   DEFAULT 0 COMMENT 'EatInTax' ,
    PaymentType INT(10)    COMMENT 'PaymentType' ,
    DeliveryPreparedTime INT(10) NOT NULL  DEFAULT 0 COMMENT 'Delivery备餐时间' ,
    PickupPreparedTime INT(10) NOT NULL  DEFAULT 0 COMMENT 'Pickup备餐时间' ,
    EatinPreparedTime INT(10) NOT NULL  DEFAULT 0 COMMENT 'Eatin备餐时间' ,
    PRIMARY KEY (ID)
) COMMENT = '第三方点单平台配置表 ';

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='ConfirmPhoneNo';
if(@count<=0) THEN 
 alter table org_table add column ConfirmPhoneNo  int not null default 0  COMMENT '是否需要确认号码';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_discountcard_expireddays';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '折扣卡过期天数', 'main_discountcard_expireddays', '0', '0', now(),'Discount Card Expired Days','折扣卡过期天数');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_empreport_onlytimeclock';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '员工报表只显示签到信息', 'main_empreport_onlytimeclock', '1', '2', now(),'Emp Report Only TimeClock','员工报表只显示签到信息');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_tax_servicecharge';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '3', '税后服务费', 'main_tax_servicecharge', '1', '2', now(),'Serivce Charge Tax','税后服务费');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='TipAfterTax';
if(@count<=0) THEN 
 alter table org_table add column TipAfterTax  int not null default 0  COMMENT '税后小费';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_unpaid_amount';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '是否打印未付款金额', 'print_unpaid_amount', '1', '2', now(),'Print Unpaid Amount','是否打印未付款金额');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DoorDashDID';
if(@count<=0) THEN 
 alter table org_table add column DoorDashDID  varchar(100)  COMMENT 'DoorDashDID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DoorDashKeyID';
if(@count<=0) THEN 
 alter table org_table add column DoorDashKeyID  varchar(100)  COMMENT 'DoorDashKeyID';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DoorDashSecret';
if(@count<=0) THEN 
 alter table org_table add column DoorDashSecret  varchar(100)  COMMENT 'DoorDashSecret';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='TrackingUrl';
if(@count<=0) THEN 
 alter table order_table add column TrackingUrl varchar(1000)  COMMENT 'TrackingUrl';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='TrackNo';
if(@count<=0) THEN 
 alter table order_table add column TrackNo varchar(100)  COMMENT 'TrackNo';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_tax_word1';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印税名称1', 'print_tax_word1', '', '0', now(),'Pring Tax Word1','打印税名称1');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_tax_word2';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印税名称2', 'print_tax_word2', '', '0', now(),'Pring Tax Word2','打印税名称2');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='pay_type_table' AND column_name='PayRate';
if(@count<=0) THEN 
 alter table pay_type_table add column PayRate int default 0  COMMENT '手续费费率';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='pax_cardreader_conf_table' AND column_name='PType';
if(@count<=0) THEN 
 alter table pax_cardreader_conf_table add column PType int default 0  COMMENT '协议类型 0:TCP;1:HTTP';
end if;
end;
call proc_tempPro;

alter table pay_type_table modify column PayRate float(10,2) default 0  COMMENT '手续费费率';

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_convenience_word';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印手续费名称', 'print_convenience_word', 'Convenience Fee', '0', now(),'Pring Convenience Word','打印手续费名称');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_remark_oneline';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '备注换行打印', 'print_remark_oneline', '1', '2', now(),'Print Remark Oneline','备注换行打印');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='DoorDashPickupTime';
if(@count<=0) THEN 
 alter table org_table add column DoorDashPickupTime int not null default 0  COMMENT 'DoorDashPickupTime';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='NeedDriverTip';
if(@count<=0) THEN 
 alter table org_table add column NeedDriverTip int not null default 0  COMMENT 'NeedDriverTip';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_tablestatus_click_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '桌子状态点击权限', 'main_tablestatus_click_right', '0', '4', now(),'Table Status Click Amount','桌子状态点击权限');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_unitprice';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印单价', 'print_unitprice', '1', '2', now(),'Pring Unit Price','打印单价');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='follow_table' AND column_name='MaxSelect';
if(@count<=0) THEN 
 alter table follow_table add column MaxSelect int default 0  COMMENT '最大选择数量';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='Session';
if(@count<=0) THEN 
 alter table order_table add column Session varchar(100)  COMMENT 'Session';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.statistics  
WHERE table_schema= DATABASE() AND table_name='order_table' AND  index_name = 'index_order_table_session';
if(@count<=0) THEN 
ALTER TABLE order_table ADD INDEX index_order_table_session (session);
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_closesession_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '关闭Session权限', 'main_closesession_right', '0', '4', now(),'Close Session Right','关闭Session权限');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='MinutesTimeLock';
if(@count<=0) THEN 
 alter table org_table add column MinutesTimeLock int not null default 20  COMMENT '每分钟订单限流';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='table_table' AND column_name='LockFlag';
if(@count<=0) THEN 
 alter table table_table add column LockFlag int not null default 0  COMMENT '锁定状态';
 alter table table_table add column LockTime datetime  COMMENT '锁定时间';
alter table table_table add column LockOpUserID int COMMENT '锁定员工ID';
alter table table_table add column LockOpUserName varchar(100) COMMENT '锁定员工名称';

end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='order_table' AND column_name='CallStatus';
if(@count<=0) THEN 
 alter table order_table add column CallStatus int default 0  COMMENT '0:准备中；1:叫号中；999:完成';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='RequestMoreInfo';
if(@count<=0) THEN 
 alter table org_table add column RequestMoreInfo varchar(100)  ;
end if;
end;
call proc_tempPro;




CREATE TABLE IF NOT EXISTS  `chowly_conf_table` (
  `ID` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID 说明:主键',
  `ApiKey` varchar(100) NOT NULL COMMENT 'APIKEY 说明:UUID',
  `StartOrderTime` varchar(10) DEFAULT NULL COMMENT '接单开始时间 说明:接单开始时间',
  `EndOrderTime` varchar(10) DEFAULT NULL COMMENT '接单结束时间 说明:接单结束时间',
  `StartOrderTime2` varchar(10) DEFAULT NULL COMMENT '接单开始时间2',
  `EndOrderTime2` varchar(10) DEFAULT NULL COMMENT '接单结束时间2',
  `StartOrderTime3` varchar(10) DEFAULT NULL COMMENT '接单开始时间3',
  `EndOrderTime3` varchar(10) DEFAULT NULL COMMENT '接单结束时间3',
  `StartOrderTime4` varchar(10) DEFAULT NULL COMMENT '接单开始时间4',
  `EndOrderTime4` varchar(10) DEFAULT NULL COMMENT '接单结束时间4',
  `StartOrderTime5` varchar(10) DEFAULT NULL COMMENT '接单开始时间5',
  `EndOrderTime5` varchar(10) DEFAULT NULL COMMENT '接单结束时间5',
  `StartOrderTime6` varchar(10) DEFAULT NULL COMMENT '接单开始时间6',
  `EndOrderTime6` varchar(10) DEFAULT NULL COMMENT '接单结束时间6',
  `StartOrderTime7` varchar(10) DEFAULT NULL COMMENT '接单开始时间7',
  `EndOrderTime7` varchar(10) DEFAULT NULL COMMENT '接单结束时间7',
  `TaxRate` float(10,4) NOT NULL COMMENT 'TaxRate',
  `TaxRate2` float(10,4) NOT NULL COMMENT 'TaxRate2',
  `DeliveryType` int(10) DEFAULT NULL COMMENT 'Delivery类型',
  `PickUpType` int(10) DEFAULT NULL COMMENT 'PickUp类型',
  `DineInType` int(10) DEFAULT NULL COMMENT 'Dine In类型',
  `RestStartTime` varchar(10) DEFAULT NULL COMMENT '休息开始时间1',
  `RestEndTime` varchar(10) DEFAULT NULL COMMENT '休息结束时间1',
  `RestStartTime2` varchar(10) DEFAULT NULL COMMENT '休息开始时间2',
  `RestEndTime2` varchar(10) DEFAULT NULL COMMENT '休息结束时间2',
  `RestStartTime3` varchar(10) DEFAULT NULL COMMENT '休息开始时间3',
  `RestEndTime3` varchar(10) DEFAULT NULL COMMENT '休息结束时间3',
  `RestStartTime4` varchar(10) DEFAULT NULL COMMENT '休息开始时间4',
  `RestEndTime4` varchar(10) DEFAULT NULL COMMENT '休息结束时间4',
  `RestStartTime5` varchar(10) DEFAULT NULL COMMENT '休息开始时间5',
  `RestEndTime5` varchar(10) DEFAULT NULL COMMENT '休息结束时间5',
  `RestStartTime6` varchar(10) DEFAULT NULL COMMENT '休息开始时间6',
  `RestEndTime6` varchar(10) DEFAULT NULL COMMENT '休息结束时间6',
  `RestStartTime7` varchar(10) DEFAULT NULL COMMENT '休息开始时间7',
  `RestEndTime7` varchar(10) DEFAULT NULL COMMENT '休息结束时间7',
  `CategoryGroupID` int(10) DEFAULT NULL,
  `PaymentType` int(10) DEFAULT NULL,
  `PickupPreparedTime` int(10) DEFAULT NULL,
  `DeliveryPreparedTime` int(10) DEFAULT NULL,
  `DineinPreparedTime` int(10) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='chowly配置表 ';



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='table_table' AND column_name='AlarmFlag';
if(@count<=0) THEN 
 alter table table_table add column AlarmFlag int default 0  COMMENT '呼叫标志；0：正常；1：呼叫中';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SendOrderConfirmFlag';
if(@count<=0) THEN 
 alter table org_table add column SendOrderConfirmFlag int default 0  COMMENT '是否发送确认短信';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='SendOrderNotifyFlag';
if(@count<=0) THEN 
 alter table org_table add column SendOrderNotifyFlag int default 0  COMMENT '是否短信通知机构';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='OrderNotifyIsdn';
if(@count<=0) THEN 
 alter table org_table add column OrderNotifyIsdn varchar(100)  COMMENT '短信通知号码';
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='pax_cardreader_record_table' AND column_name='TenderType';
if(@count<=0) THEN 
 alter table pax_cardreader_record_table add column TenderType varchar(20) default 'CREDIT'  COMMENT '刷卡通道';
end if;
end;
call proc_tempPro;

CREATE TABLE IF NOT EXISTS pax_cardpointgateway_log_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    CreateTime DATETIME    COMMENT '创建时间' ,
    OrderID INT(10)    COMMENT '订单号' ,
    PaymentID INT(10)    COMMENT '付款ID' ,
    PaymentAmount INT(10)   DEFAULT 0 COMMENT '付款金额' ,
    Tip INT(10)   DEFAULT 0 COMMENT '小费' ,
    amount VARCHAR(100)    COMMENT 'amount' ,
    resptext VARCHAR(100)    COMMENT 'resptext' ,
    setlstat VARCHAR(100)    COMMENT 'setlstat' ,
    capturedate VARCHAR(100)    COMMENT 'capturedate' ,
    respcode VARCHAR(100)    COMMENT 'respcode' ,
    batchid VARCHAR(100)    COMMENT 'batchid' ,
    entrymode VARCHAR(100)    COMMENT 'entrymode' ,
    merchid VARCHAR(100)    COMMENT 'merchid' ,
    token VARCHAR(100)    COMMENT 'token' ,
    authcode VARCHAR(100)    COMMENT 'authcode' ,
    respproc VARCHAR(100)    COMMENT 'respproc' ,
    authdate VARCHAR(100)    COMMENT 'authdate' ,
    bintype VARCHAR(100)    COMMENT 'bintype' ,
    lastfour VARCHAR(100)    COMMENT 'lastfour' ,
    voidable VARCHAR(100)    COMMENT 'voidable' ,
    name VARCHAR(100)    COMMENT 'name' ,
    currency VARCHAR(100)    COMMENT 'currency' ,
    refundable VARCHAR(100)    COMMENT 'refundable' ,
    expiry VARCHAR(100)    COMMENT 'expiry' ,
    retref VARCHAR(100)    COMMENT 'retref' ,
    respstat VARCHAR(100)    COMMENT 'respstat' ,
    account VARCHAR(100)    COMMENT 'account' ,
    PRIMARY KEY (ID)
) COMMENT = 'cardpoint网关日志 ';

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_total';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印总数', 'print_total', '0', '2', now(),'Pring Total','打印总数');
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='print_sortbyitemno';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '1', '打印按照ITEMNO排序', 'print_sortbyitemno', '1', '2', now(),'Pring Sort by ItemNo','打印按照ITEMNO排序');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='op_user_table' AND column_name='CommissionRate';
if(@count<=0) THEN 
 alter table op_user_table add column CommissionRate float(10,2) default 0  COMMENT '佣金比例';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='AppointmentPickup';
if(@count<=0) THEN 
 alter table org_table add column AppointmentPickup int default 0  COMMENT 'AppointmentPickup ';
alter table org_table add column AppointmentDelivery int default 0  COMMENT 'AppointmentDelivery';
alter table org_table add column AppointmentDinein int default 0  COMMENT 'AppointmentDinein';
alter table org_table add column AppointmentAll int default 0  COMMENT 'AppointmentAll';
end if;
end;
call proc_tempPro;


CREATE TABLE IF NOT EXISTS bp_cardreader_detail_table(
    ID INT(10) NOT NULL AUTO_INCREMENT  COMMENT 'ID' ,
    CreateTime DATETIME    COMMENT '时间' ,
    PaymentID INT(10)    COMMENT 'PaymentID' ,
    OrderID INT(10)    COMMENT 'OrderID' ,
    RequestAmount INT(10)    COMMENT 'RequestAmount' ,
    ApprovalAmount INT(10)    COMMENT 'ApprovalAmount' ,
    AmExPOSData VARCHAR(100)    COMMENT 'AmExPOSData' ,
    AmExTranID VARCHAR(100)    COMMENT 'AmExTranID' ,
    AcctNum VARCHAR(100)    COMMENT 'AcctNum' ,
    LocalDateTime VARCHAR(100)    COMMENT 'LocalDateTime' ,
    MerchID VARCHAR(100)    COMMENT 'MerchID' ,
    OrderNum VARCHAR(100)    COMMENT 'OrderNum' ,
    PymtType VARCHAR(100)    COMMENT 'PymtType' ,
    RefNum VARCHAR(100)    COMMENT 'RefNum' ,
    STAN VARCHAR(100)    COMMENT 'STAN' ,
    TermID VARCHAR(100)    COMMENT 'TermID' ,
    TrnmsnDateTime VARCHAR(100)    COMMENT 'TrnmsnDateTime' ,
    TxnAmt VARCHAR(100)    COMMENT 'TxnAmt' ,
    TxnCrncy VARCHAR(100)    COMMENT 'TxnCrncy' ,
    TxnType VARCHAR(100)    COMMENT 'TxnType' ,
    AddtlRespData VARCHAR(100)    COMMENT 'AddtlRespData' ,
    AthNtwkID VARCHAR(100)    COMMENT 'AthNtwkID' ,
    AthNtwkNm VARCHAR(100)    COMMENT 'AthNtwkNm' ,
    AuthID VARCHAR(100)    COMMENT 'AuthID' ,
    RespCode VARCHAR(100)    COMMENT 'RespCode' ,
    Tip INT(10)   DEFAULT 0 COMMENT 'Tip' ,
    Token VARCHAR(4000)    COMMENT 'Token' ,
    BatchStatus INT(10)   DEFAULT 0 COMMENT 'BatchStatus' ,
    PRIMARY KEY (ID)
) COMMENT = '蓝牙刷卡器刷卡记录表 ';

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_report_print_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '报表打印权限', 'main_report_print_right', '0', '4', now(),'Print Report Right','报表打印权限');
end if;
end;
call proc_tempPro;

DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM default_setting_table
WHERE settingKey='main_order_report_print_right';
if(@count<=0) THEN 
INSERT INTO `default_setting_table` (hostName,settingGroup,settingDesc,settingKey,settingValue,valueType,createTime,l1,l2)  VALUES (null, '2', '订单报表打印权限', 'main_order_report_print_right', '0', '4', now(),'Print Order Report Right','订单报表打印权限');
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='kds_mission_table' AND column_name='KDSStatus';
if(@count<=0) THEN 
 alter table kds_mission_table add column  KDSStatus int default 0  COMMENT '状态';
 alter table kds_mission_table add column  Recall int default 0  COMMENT '重叫状态';
end if;
end;
call proc_tempPro;




DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='LogoUrl';
if(@count<=0) THEN 
 alter table org_table add column LogoUrl varchar(300)  COMMENT 'LogoUrl';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='LoginBGUrl';
if(@count<=0) THEN 
 alter table org_table add column LoginBGUrl varchar(300)  COMMENT 'LoginBGUrl';
end if;
end;
call proc_tempPro;



DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='Atimemode';
if(@count<=0) THEN 
 alter table org_table add column  Atimemode int default 0  COMMENT 'Atimemode';
end if;
end;
call proc_tempPro;


DROP PROCEDURE IF EXISTS proc_tempPro;
CREATE PROCEDURE proc_tempPro()
BEGIN
SELECT count(*) into @count FROM INFORMATION_SCHEMA.Columns  
WHERE table_schema= DATABASE() AND table_name='org_table' AND column_name='LangMode';
if(@count<=0) THEN 
 alter table org_table add column  LangMode int default 0  COMMENT 'LangMode';
end if;
end;
call proc_tempPro;