SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON
GO
SET DATEFORMAT YMD
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL Serializable
GO
BEGIN TRANSACTION


PRINT(N'Update rows in [Master].[Menus]')
UPDATE [Master].[Menus] SET [MenuParentId]=33, [MenuIcon]=NULL, [MenuSort]=1 WHERE [MenuId] = 2
UPDATE [Master].[Menus] SET [MenuParentId]=35, [MenuIcon]=NULL, [MenuSort]=1 WHERE [MenuId] = 3
UPDATE [Master].[Menus] SET [MenuParentId]=33, [MenuIcon]=NULL WHERE [MenuId] = 4
UPDATE [Master].[Menus] SET [MenuParentId]=33, [MenuIcon]=NULL WHERE [MenuId] = 5
UPDATE [Master].[Menus] SET [MenuParentId]=35, [MenuName]='Penyelarasan', [MenuIcon]=NULL, [MenuSort]=2 WHERE [MenuId] = 6
UPDATE [Master].[Menus] SET [MenuName]='Penetapan', [MenuSort]=5 WHERE [MenuId] = 7
UPDATE [Master].[Menus] SET [MenuParentId]=38, [MenuSort]=1 WHERE [MenuId] = 20
UPDATE [Master].[Menus] SET [MenuParentId]=38, [MenuSort]=2 WHERE [MenuId] = 21
UPDATE [Master].[Menus] SET [MenuParentId]=30, [MenuUrl]='#', [MenuIcon]=NULL, [MenuSort]=1 WHERE [MenuId] = 28
PRINT(N'Operation applied to 9 rows out of 9')

PRINT(N'Add rows to [Master].[Menus]')
SET IDENTITY_INSERT [Master].[Menus] ON
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (30, 0, '#', 'Perencanaan', 'icon-certificate', 2, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (31, 28, 'apps/penyampaianproleg', 'Penyampaian Proleg', NULL, 1, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (32, 28, 'apps/proleg', 'Daftar Peraturan Proleg', NULL, 2, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (33, 0, '#', 'Penyusunan', 'icon-library', 3, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (34, 35, '#', 'Board Seminar', NULL, 1, 1, '2017-07-24 15:05:06.000', NULL, NULL, 0, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (35, 0, '#', 'Pembahasan', 'icon-bubble-user', 4, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (36, 35, 'harmonisasi/pengharmonisasian', 'Pengharmonisasian', NULL, 3, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (38, 0, '#', 'Penyebarluasan', 'icon-bubble-user', 6, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (39, 38, 'penyebarluasan/pengundangan', 'Pengundangan', NULL, 3, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (40, 38, 'penyebarluasan/penyebarluasan', 'Penyebarluasan', NULL, 4, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
INSERT INTO [Master].[Menus] ([MenuId], [MenuParentId], [MenuUrl], [MenuName], [MenuIcon], [MenuSort], [MenuCreateBy], [MenuCreateDate], [MenuUpdateBy], [MenuUpdateDate], [MenuStatus], [MenuLogCode]) VALUES (41, 33, 'apps/boardseminarPOJK', 'Board Seminar POJK', NULL, 2, 1, '2017-07-24 15:05:06.000', NULL, NULL, 1, NULL)
SET IDENTITY_INSERT [Master].[Menus] OFF
PRINT(N'Operation applied to 11 rows out of 11')

COMMIT TRANSACTION
GO
