102 lines
6.7 KiB
Transact-SQL
102 lines
6.7 KiB
Transact-SQL
--delete Sys_ButtonToMenu where MenuId in (select MenuId from Sys_Menu where MenuType='Menu_ProjectSet')
|
||
--go
|
||
--delete from Sys_Menu where MenuType='Menu_ProjectSet'
|
||
--go
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('6B988160-2F4D-4428-92D9-20392593B9D2','淃커매워','ProjectData/ProjectSetSave.aspx',10,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('F9F1FBE9-295E-4D46-8E37-8A8929A37B4D','6B988160-2F4D-4428-92D9-20392593B9D2','괏닸',1)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('A4308F9A-0280-49C5-BEE4-FA858FE1CE24','陋零/데禱','ProjectData/Installation.aspx',15,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('112C49FF-2794-4F5A-89C2-1ECF55122190','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('B31D06AA-DC90-45A6-864E-5B686AFE4EFD','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('C6404132-E1AB-43C5-845C-C39688DED2F3','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('81A46A75-5B64-412B-B337-7388D90663E1','A4308F9A-0280-49C5-BEE4-FA858FE1CE24','괏닸',4)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('336FE0BB-AE1D-4F15-A35B-1FC582E01A14','淃커寮淃','ProjectData/MainItem.aspx',20,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('54B26566-3749-4213-BEEF-B7E6E3BB7671','336FE0BB-AE1D-4F15-A35B-1FC582E01A14','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('91B5411C-5C66-478F-8B8E-A1308DD18FC9','336FE0BB-AE1D-4F15-A35B-1FC582E01A14','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('57EB7491-B503-47B5-8C3B-9BF29E5D572D','336FE0BB-AE1D-4F15-A35B-1FC582E01A14','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('F8E86DBF-7601-49F8-B539-573AB95A630A','336FE0BB-AE1D-4F15-A35B-1FC582E01A14','괏닸',4)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('CBA3833A-C705-4B4E-A4A7-ACC27D0ECDCE','데貫묏넋','ProjectData/UnitWork.aspx',30,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('BD560DF3-A1A4-44F9-ABC1-B203C627979C','CBA3833A-C705-4B4E-A4A7-ACC27D0ECDCE','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('27034B5A-4669-4A21-B57E-3A0C2FA705A8','CBA3833A-C705-4B4E-A4A7-ACC27D0ECDCE','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('428EBF49-0E46-46F4-A596-734D27B8619D','CBA3833A-C705-4B4E-A4A7-ACC27D0ECDCE','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('05B51CC2-9F00-4ABD-81DF-C20A640FBAE9','CBA3833A-C705-4B4E-A4A7-ACC27D0ECDCE','괏닸',4)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('64690369-3049-4009-82EE-437DF2E606BA','淃커데貫','ProjectData/ProjectUnit.aspx',40,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('E1BDCD88-EC6F-4C7F-AB75-E229B14121BA','64690369-3049-4009-82EE-437DF2E606BA','朞嶝',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('4971D446-279F-4F53-ADF3-9B8CBD63360C','64690369-3049-4009-82EE-437DF2E606BA','<EFBFBD>뇜',2)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('CDB80E91-61A8-4E4D-BA97-3ADDC3208B66','淃커痰빵','ProjectData/ProjectUser.aspx',50,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('A8CA1528-CF6A-4332-98B2-D428803D2D52','CDB80E91-61A8-4E4D-BA97-3ADDC3208B66','朞嶝',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('97223C15-81D1-4174-A755-9DE9E7653C31','CDB80E91-61A8-4E4D-BA97-3ADDC3208B66','<EFBFBD>뇜',2)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('2C970C89-8C69-4A6C-B832-8A64B8A701CA','嘉묏겯莉','ProjectData/TeamGroup.aspx',60,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('FE98C62E-B876-4277-BB4B-25A532819DAD','2C970C89-8C69-4A6C-B832-8A64B8A701CA','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('373EBAC3-E347-4C9A-86B1-1E2EFFF1AB12','2C970C89-8C69-4A6C-B832-8A64B8A701CA','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('06A19ADA-F5B4-4170-B486-8756C72C8A94','2C970C89-8C69-4A6C-B832-8A64B8A701CA','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('65820054-A597-4705-BA29-20FA0CD2CF30','2C970C89-8C69-4A6C-B832-8A64B8A701CA','괏닸',4)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('D24ACD3C-086C-4AC8-9AFA-16D48893215E','淃커榴檄','ProjectData/ProjectShutdown.aspx',80,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('0E77225D-70A1-4463-9062-2F901A670B59','D24ACD3C-086C-4AC8-9AFA-16D48893215E','藤속',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('CC3D7F7E-326E-42E1-AC8A-B2E646172683','D24ACD3C-086C-4AC8-9AFA-16D48893215E','錦맣',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('F5EA25D1-F61B-4C36-BBF4-C50D3DE553C1','D24ACD3C-086C-4AC8-9AFA-16D48893215E','<EFBFBD>뇜',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('B0D84243-E170-4D2E-952E-7C3FEB70C73B','D24ACD3C-086C-4AC8-9AFA-16D48893215E','괏닸',4)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('76FEA4F3-FD2A-4A89-A36A-75FCF114C7A5','D24ACD3C-086C-4AC8-9AFA-16D48893215E','瓊슥',5)
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('9c62332c-d31f-4575-a323-49537bf335e8','淃커뻔쓱<EFBFBD>零','ProjectData/ProjectSysSet.aspx',90,'0','Menu_ProjectSet',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('1741D717-8339-404D-BBC7-FBDF1517B460','9c62332c-d31f-4575-a323-49537bf335e8','괏닸',1)
|
||
GO |