GoldHoo/doc/调整记录/2021-07-26 14.50.sql

INSERT INTO basedata.ShopShowFunction
        ( ShowFunctionId ,
          ShowFunctionName
        )
VALUES  ( 100 , -- ShowFunctionId - int
          N'只有【产品展示】功能' -- ShowFunctionName - nvarchar(50)
        ),
		( 110 , -- ShowFunctionId - int
          N'只看补件' -- ShowFunctionName - nvarchar(50)
        ),
		( 120 , -- ShowFunctionId - int
          N'只看产品' -- ShowFunctionName - nvarchar(50)
        );


-- 初始化业务员展示权限 --
INSERT INTO basedata.ShopMemberShowPrivilege
        ( ShopMemberId, ShowFunctionId )
SELECT ShopMemberId, 100 FROM basedata.ShopMemberPrivilege  WHERE FunctionId = 20000;