32 lines
1.5 KiB
Transact-SQL
32 lines
1.5 KiB
Transact-SQL
--ÊÇ·ñ
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('B5E5044B-8A65-4D0E-A609-ABF6046AB012','Y','Y',1,'YesOrNo')
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('73B762F1-C58D-4C6E-99C6-18C89D42D135','N','N',2,'YesOrNo')
|
|
GO
|
|
|
|
--ÄÚÖýÇÉ«
|
|
INSERT INTO dbo.Sys_Role( RoleId ,RoleName,IsBuilt)
|
|
VALUES ( '483fa2a4-f9c6-448a-ab6c-ad7424131514','Contract Administrator','True')
|
|
INSERT INTO dbo.Sys_Role( RoleId ,RoleName,IsBuilt)
|
|
VALUES ( '39e35a17-8fa2-447c-b1da-bf92bff36ad4','CTS/S','True')
|
|
INSERT INTO dbo.Sys_Role( RoleId ,RoleName,IsBuilt)
|
|
VALUES ( 'b76dec7a-ba1c-46f1-8859-ece4b18252b1','CTS/C','True')
|
|
INSERT INTO dbo.Sys_Role( RoleId ,RoleName,IsBuilt)
|
|
VALUES ( '0fc14ea7-69f4-4923-879d-a46812f2c8ef','CT GM','True')
|
|
INSERT INTO dbo.Sys_Role( RoleId ,RoleName,IsBuilt)
|
|
VALUES ( '49b47f26-d5ea-4650-97ec-0d29686e1819','CT Director','True')
|
|
GO
|
|
--One-time ContractsµÄStatus
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('53E6440F-91E4-4EA5-842E-95FB0C15C228','Preparing','Preparing',1,'Status')
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('1138D45D-6F42-475F-9F73-B5C9549B5173','On going','On going',2,'Status')
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('4EAA387B-9C50-405D-9BA6-8C00D90C7B1A','Completed','Completed',3,'Status')
|
|
INSERT dbo.Sys_Const(ID,ConstValue,ConstText,SortIndex,GroupId)
|
|
VALUES ('5317DC68-4569-4AAB-8C70-59C5FC65A388','Cancelled','Cancelled',4,'Status')
|
|
GO
|
|
|
|
|