--linx 新增职员和修改职员权限分离
IF NOT EXISTS (SELECT * FROM T_POPEDOM WHERE F_ID = 6601)
  INSERT T_POPEDOM (F_ID,F_NAME,F_VALUE) VALUES(6601,'职员新增',297) ;
GO

IF NOT EXISTS (SELECT * FROM T_POPEDOM WHERE F_ID = 6602)
  INSERT T_POPEDOM (F_ID,F_NAME,F_VALUE) VALUES(6602,'职员编辑',298) ;
GO

IF NOT EXISTS (SELECT * FROM T_POPEDOM WHERE F_ID = 6603)
  INSERT T_POPEDOM (F_ID,F_NAME,F_VALUE) VALUES(6603,'修改职员卡号',299) ;
GO


IF (NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DEPURATE') and Name='F_RECEIVEIDS')) 
AND (NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DEPURATE') and Name='F_RECEIVEAMOUNT'))
AND (NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DEPURATE') and Name='F_NAMEDAMOUNT'))
AND (NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DEPURATE') and Name='F_NORMALAMOUNT'))
AND (NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_DEPURATE') and Name='F_ADDAMOUNT'))
BEGIN 

ALTER TABLE dbo.T_DEPURATE ADD
	F_RECEIVEIDS varchar(200) NULL,
	F_RECEIVEAMOUNT int NULL,
	F_NAMEDAMOUNT int NULL,
	F_NORMALAMOUNT int NULL,
	F_ADDAMOUNT int NULL


END

GO



if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'EnableDeleteFreeLeastGoods') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('EnableDeleteFreeLeastGoods', '0', NULL, '是否启用删除免费最低消费', 0, '浴场');
END
GO

if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'UpdateTotalAmountMethod') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) VALUES ('UpdateTotalAmountMethod', '0', NULL, '自动计算人数方式 0:按项目人数 1:过滤加钟方式', 0, '基础设置');
END
GO

IF EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_PROMOTION') and Name='F_CARDTYPEID')
BEGIN   
   ALTER TABLE T_PROMOTION alter COLUMN F_CARDTYPEID varchar(6000)
END
GO



if not exists(select * from T_WORKERQUEUEPARAMETER where F_ID = 'CheckWorkerHeadShipTraitByAptoticQueue') 
BEGIN
  INSERT INTO T_WORKERQUEUEPARAMETER (F_ID, F_VALUE, F_SHOPID, F_REMARK, F_ISHIDE, F_TYPE) 
  VALUES ('CheckWorkerHeadShipTraitByAptoticQueue', '1', NULL, '特性技师上钟时停牌技师是否自动罚轮', 0, '排钟方式');
END

GO


IF NOT  EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_WORKER') and Name='F_SOEUSERID')
BEGIN   
   ALTER TABLE T_WORKER ADD  F_SOEUSERID varchar(50) NULL
END
GO


IF NOT EXISTS(
   SELECT * 
    FROM syscolumns 
    WHERE id=object_id('T_CLIENT') and Name='F_SOEUSERID')
BEGIN   
   ALTER TABLE T_CLIENT ADD  F_SOEUSERID varchar(50) NULL
END
GO