45 lines
3.0 KiB
Transact-SQL
45 lines
3.0 KiB
Transact-SQL
--delete from Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_TeamWork')
|
|
--go
|
|
--delete from Sys_Menu where MenuType='Menu_TeamWork'
|
|
--go
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('40F4BEB7-743C-4BE8-8C4C-5DB40EDF7CA0','电子签章管理','',10,'0','Menu_TeamWork',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('825E7F50-EAB3-4442-8315-0F4AE5A0DE99','签章审批','',10,'40F4BEB7-743C-4BE8-8C4C-5DB40EDF7CA0','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('DFEEC7AC-CA64-4844-8B98-04DE7137F37D','签章台账','',20,'40F4BEB7-743C-4BE8-8C4C-5DB40EDF7CA0','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('45D5C10D-79DF-46C8-83C5-3A23F00747CF','签章回收','',30,'40F4BEB7-743C-4BE8-8C4C-5DB40EDF7CA0','Menu_TeamWork',1,1,1)
|
|
GO
|
|
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('0537893A-F2E4-4D35-98C7-64BFE14FBDE2','会议管理','',20,'0','Menu_TeamWork',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('EAFCC89E-BB00-40A7-A2D4-53DCBA923A67','会议看板','',10,'0537893A-F2E4-4D35-98C7-64BFE14FBDE2','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('A3F231B5-4013-4FE2-87F7-DADC7DEA3866','会议预定','',20,'0537893A-F2E4-4D35-98C7-64BFE14FBDE2','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('1733F871-5ED4-45A9-A7A3-DB94F6C14B5A','会议签到','',30,'0537893A-F2E4-4D35-98C7-64BFE14FBDE2','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('8B3EF56E-C05A-4D80-AFF0-FADE46860567','会议纪要','',40,'0537893A-F2E4-4D35-98C7-64BFE14FBDE2','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('AE674D8D-6526-4E3C-BC1D-16614A97A842','文档模板库','',30,'0','Menu_TeamWork',1,0,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('D12B0D1C-E9DA-4784-A5E6-67615B8C34F7','内控制度用表','',10,'AE674D8D-6526-4E3C-BC1D-16614A97A842','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('85F1FDE3-16FB-47BD-9D22-7C53120FD9AC','管理用表','',20,'AE674D8D-6526-4E3C-BC1D-16614A97A842','Menu_TeamWork',1,1,1)
|
|
GO
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
VALUES('578BF124-5587-4D0F-8AC8-4441D61303A3','办公文档模板','',30,'AE674D8D-6526-4E3C-BC1D-16614A97A842','Menu_TeamWork',1,1,1)
|
|
GO |