if not exists(select * from T_SYSTEM where F_ID = 'OnlineUpdateLogServiceURI')
BEGIN
  INSERT INTO T_SYSTEM (F_ID, F_VALUE, F_REMARK, F_TYPE) 
  VALUES ('OnlineUpdateLogServiceURI', 'https://www.soesoft.org/hdwmslog-rest/api/', '线上日志服务请求地址', '系统');  
END;

GO


if not exists(select * from T_SYSTEM where F_ID = 'CrmCode')
BEGIN
  INSERT INTO T_SYSTEM (F_ID, F_VALUE, F_REMARK, F_TYPE) 
  VALUES ('CrmCode', '', '店铺识别编号', '系统');  
END;

GO



update T_AUTOID  set F_FORMAT = '%.8d' where F_ID in (
'T_ATTENDANCE',    
'T_CHECKOUT',
'T_CHECKOUTPAYMENT',
'T_CONSUME',
'T_CONSUMEWORKER',
'T_DEPURATE',
'T_GRATISTCONSUME',
'T_RECEIVE',
'T_ROOMCALL',
'T_TEABILL');

GO

update T_AUTOID  set F_FORMAT = '%.10d' where F_ID in (
'T_ATTLOG',
'T_SMARTLOG',
'T_WORKERQUEUECHANGEFILE',
'T_WORKERQUEUESTATISTICS');

GO

update T_AUTOID set F_REMARK = '同步' where F_TYPE = 2;
GO