--ÊÇ·ñ
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