-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: changelog.groovy
-- Ran at: 10/5/12 4:28 PM

-- Liquibase version: 2.0.1
-- *********************************************************************

-- Lock Database
-- Changeset changelog_3.7.0.groovy::3.7.0-2::owf::(Checksum: 3:cbe5e34a9d02b85dd00159ffb3783040)
/****** Object:  Table [dbo].[owf_group]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[owf_group] ON
        INSERT [dbo].[owf_group] ([id], [version], [status], [email], [description], [name], [automatic]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'active', N'testgroup1@group1.com', N'TestGroup1', N'TestGroup1', 0)
        INSERT [dbo].[owf_group] ([id], [version], [status], [email], [description], [name], [automatic]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'active', N'testgroup2@group2.com', N'TestGroup2', N'TestGroup2', 0)
        SET IDENTITY_INSERT [dbo].[owf_group] OFF
        /****** Object:  Table [dbo].[domain_mapping]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[domain_mapping] ON
        INSERT [dbo].[domain_mapping] ([id], [version], [src_id], [src_type], [relationship_type], [dest_id], [dest_type]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'group', N'owns', CAST(1 AS Numeric(19, 0)), N'widget_definition')
        INSERT [dbo].[domain_mapping] ([id], [version], [src_id], [src_type], [relationship_type], [dest_id], [dest_type]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'group', N'owns', CAST(2 AS Numeric(19, 0)), N'widget_definition')
        INSERT [dbo].[domain_mapping] ([id], [version], [src_id], [src_type], [relationship_type], [dest_id], [dest_type]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'group', N'owns', CAST(1 AS Numeric(19, 0)), N'widget_definition')
        INSERT [dbo].[domain_mapping] ([id], [version], [src_id], [src_type], [relationship_type], [dest_id], [dest_type]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'group', N'owns', CAST(2 AS Numeric(19, 0)), N'widget_definition')
        SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
        /****** Object:  Table [dbo].[person]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[person] ON
        INSERT [dbo].[person] ([id], [version], [enabled], [user_real_name], [username], [last_login], [email_show], [email], [prev_login], [description]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'Test Admin 1', N'testAdmin1', CAST(0x00009F5801238C74 AS DateTime), 0, N'testAdmin1@ozone3.test', NULL, N'Test Administrator 1')
        INSERT [dbo].[person] ([id], [version], [enabled], [user_real_name], [username], [last_login], [email_show], [email], [prev_login], [description]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'Test User 1', N'testUser1', CAST(0x00009F5301238D91 AS DateTime), 0, N'testUser1@ozone3.test', NULL, N'Test User 1')
        INSERT [dbo].[person] ([id], [version], [enabled], [user_real_name], [username], [last_login], [email_show], [email], [prev_login], [description]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'Test User 2', N'testUser2', CAST(0x00009F5301238DA4 AS DateTime), 0, N'testUser2@ozone3.test', NULL, N'Test User 2')
        INSERT [dbo].[person] ([id], [version], [enabled], [user_real_name], [username], [last_login], [email_show], [email], [prev_login], [description]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'DEFAULT_USER', N'DEFAULT_USER', CAST(0x00009F5801238E35 AS DateTime), 0, NULL, NULL, NULL)
        SET IDENTITY_INSERT [dbo].[person] OFF
        /****** Object:  Table [dbo].[role]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[role] ON
        INSERT [dbo].[role] ([id], [version], [authority], [description]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), N'ROLE_USER', N'User Role')
        INSERT [dbo].[role] ([id], [version], [authority], [description]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), N'ROLE_ADMIN', N'Admin Role')
        SET IDENTITY_INSERT [dbo].[role] OFF
        /****** Object:  Table [dbo].[requestmap]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[requestmap] ON
        INSERT [dbo].[requestmap] ([id], [version], [url], [config_attribute]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'/login/**', N'IS_AUTHENTICATED_ANONYMOUSLY')
        INSERT [dbo].[requestmap] ([id], [version], [url], [config_attribute]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'/denied.jsp', N'IS_AUTHENTICATED_ANONYMOUSLY')
        INSERT [dbo].[requestmap] ([id], [version], [url], [config_attribute]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'/**', N'IS_AUTHENTICATED_FULLY')
        SET IDENTITY_INSERT [dbo].[requestmap] OFF
        /****** Object:  Table [dbo].[widget_definition]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[widget_definition] ON
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widgetA.gif', N'images/blue/icons/widgetContainer/widgetAsm.gif', 0, 615, N'1.0', 565, N'examples/fake-widgets/widget-a.html', N'ea5435cf-4021-4f2a-ba69-dde451d12551', N'Widget A')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widgetB.gif', N'images/blue/icons/widgetContainer/widgetBsm.gif', 0, 565, N'1.0', 635, N'examples/fake-widgets/widget-b.html', N'fb5435cf-4021-4f2a-ba69-dde451d12551', N'Widget B')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widgetC.gif', N'images/blue/icons/widgetContainer/widgetCsm.gif', 0, 980, N'1.0', 740, N'examples/fake-widgets/widget-c.html', N'0c5435cf-4021-4f2a-ba69-dde451d12551', N'Widget C')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widgetD.gif', N'images/blue/icons/widgetContainer/widgetDsm.gif', 0, 630, N'1.0', 525, N'examples/fake-widgets/widget-d.html', N'1d5435cf-4021-4f2a-ba69-dde451d12551', N'Widget D')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(5 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widget1.gif', N'images/blue/icons/widgetContainer/widget1sm.gif', 0, 625, N'1.0', 405, N'examples/fake-widgets/widget-one.html', N'd6543ccf-4021-4f2a-ba69-dde451d12551', N'Widget One')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(6 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widget2.gif', N'images/blue/icons/widgetContainer/widget2sm.gif', 0, 610, N'1.0', 635, N'examples/fake-widgets/widget-two.html', N'e65431cf-4021-4f2a-ba69-dde451d12551', N'Widget Two')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(7 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widget3.gif', N'images/blue/icons/widgetContainer/widget3sm.gif', 0, 630, N'1.0', 540, N'examples/fake-widgets/widget-three.html', N'a65432cf-4021-4f2a-ba69-dde451d12551', N'Widget Three')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(8 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widget4.gif', N'images/blue/icons/widgetContainer/widget4sm.gif', 0, 675, N'1.0', 350, N'examples/fake-widgets/widget-four.html', N'b65434cf-4021-4f2a-ba69-dde451d12551', N'Widget Four')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(9 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/widget5.gif', N'images/blue/icons/widgetContainer/widget5sm.gif', 0, 615, N'1.0', 630, N'examples/fake-widgets/widget-five.html', N'c65435cf-4021-4f2a-ba69-dde451d12551', N'Widget Five')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(10 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/nearlyEmpty.gif', N'images/blue/icons/widgetContainer/nearlyEmptysm.gif', 0, 540, N'1.0', 440, N'examples/walkthrough/widgets/NearlyEmptyWidget.html', N'bc5435cf-4021-4f2a-ba69-dde451d12551', N'Nearly Empty')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(11 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/channelShouter.gif', N'images/blue/icons/widgetContainer/channelShoutersm.gif', 0, 295, N'1.0', 250, N'examples/walkthrough/widgets/ChannelShouter.html', N'eb5435cf-4021-4f2a-ba69-dde451d12551', N'Channel Shouter')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(12 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'images/blue/icons/widgetIcons/channelListener.gif', N'images/blue/icons/widgetContainer/channelListenersm.gif', 0, 540, N'1.0', 440, N'examples/walkthrough/widgets/ChannelListener.html', N'ec5435cf-4021-4f2a-ba69-dde451d12551', N'Channel Listener')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(13 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'examples/walkthrough/images/chromeWiget_black_icon.png ', N'examples/walkthrough/images/chromeWiget_blue_icon.png ', 0, 540, N'1.0', 440, N'examples/walkthrough/widgets/WidgetChrome.html', N'e8687289-f595-4b6d-9911-c714b483509d', N'Widget Chrome')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(14 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'examples/walkthrough/images/event_monitor_black_icon.png', N'examples/walkthrough/images/event_monitor_blue_icon.png', 0, 500, N'1.0', 600, N'examples/walkthrough/widgets/EventMonitor.html', N'9d2e5f85-e199-4c6a-be31-4c6954206687', N'Event Monitor Widget')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(15 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'examples/walkthrough/images/log_icon.png', N'examples/walkthrough/images/log_icon_blue.png', 0, 540, N'1.0', 440, N'examples/walkthrough/widgets/WidgetLog.html', N'4854fbd4-395c-442b-95c6-8b60702fd2b4', N'Widget Log')
        INSERT [dbo].[widget_definition] ([id], [version], [visible], [image_url_large], [image_url_small], [singleton], [width], [widget_version], [height], [widget_url], [widget_guid], [display_name]) VALUES (CAST(16 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, N'examples/walkthrough/images/testpref_black_icon.png', N'examples/walkthrough/images/testpref_blue_icon.png', 0, 450, N'1.0', 300, N'examples/walkthrough/widgets/Preferences.html', N'920b7cc1-dd37-46ac-8457-afda62613e56', N'Preferences Widget')
        SET IDENTITY_INSERT [dbo].[widget_definition] OFF
        /****** Object:  Table [dbo].[tags]    Script Date: 09/08/2011 17:46:09 ******/
        /****** Object:  Table [dbo].[tag_links]    Script Date: 09/08/2011 17:46:09 ******/
        /****** Object:  Table [dbo].[role_people]    Script Date: 09/08/2011 17:46:09 ******/
        INSERT [dbo].[role_people] ([person_id], [role_id]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[role_people] ([person_id], [role_id]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[role_people] ([person_id], [role_id]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[role_people] ([person_id], [role_id]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
        /****** Object:  Table [dbo].[preference]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[preference] ON
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 0', CAST(2 AS Numeric(19, 0)), N'foo.bar.0')
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 1', CAST(2 AS Numeric(19, 0)), N'foo.bar.1')
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 0', CAST(3 AS Numeric(19, 0)), N'foo.bar.0')
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 1', CAST(3 AS Numeric(19, 0)), N'foo.bar.1')
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(5 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 0', CAST(1 AS Numeric(19, 0)), N'foo.bar.0')
        INSERT [dbo].[preference] ([id], [version], [value], [path], [user_id], [namespace]) VALUES (CAST(6 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'foovalue', N'test path entry 1', CAST(1 AS Numeric(19, 0)), N'foo.bar.1')
        SET IDENTITY_INSERT [dbo].[preference] OFF
        /****** Object:  Table [dbo].[person_widget_definition]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[person_widget_definition] ON
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 0, CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 1, CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 2, CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 3, CAST(4 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(5 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 4, CAST(5 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(6 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 5, CAST(6 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(7 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 6, CAST(7 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(8 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 7, CAST(8 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(9 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 8, CAST(9 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(10 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 9, CAST(10 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(11 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 10, CAST(11 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(12 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 11, CAST(12 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(13 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 12, CAST(13 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(14 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 13, CAST(14 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(15 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 14, CAST(15 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(16 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)), 1, 15, CAST(16 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(17 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 0, CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(18 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 1, CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(19 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 2, CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(20 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 3, CAST(4 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(21 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 4, CAST(5 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(22 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 5, CAST(6 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(23 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 6, CAST(7 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(24 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 7, CAST(8 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(25 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 8, CAST(9 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(26 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 9, CAST(10 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(27 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 10, CAST(11 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(28 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 11, CAST(12 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(29 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 12, CAST(13 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(30 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 13, CAST(14 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(31 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 14, CAST(15 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(32 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)), 1, 15, CAST(16 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(33 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 0, CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(34 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 1, CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(35 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 2, CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(36 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 3, CAST(4 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(37 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 4, CAST(5 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(38 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 5, CAST(6 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(39 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 6, CAST(7 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(40 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 7, CAST(8 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(41 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 8, CAST(9 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(42 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 9, CAST(10 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(43 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 10, CAST(11 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(44 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 11, CAST(12 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(45 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 12, CAST(13 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(46 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 13, CAST(14 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(47 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 14, CAST(15 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(48 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(3 AS Numeric(19, 0)), 1, 15, CAST(16 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(49 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 0, CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(50 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 1, CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(51 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 2, CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(52 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 3, CAST(4 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(53 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 4, CAST(5 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(54 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 5, CAST(6 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(55 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 6, CAST(7 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(56 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 7, CAST(8 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(57 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 8, CAST(9 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(58 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 9, CAST(10 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(59 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 10, CAST(11 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(60 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 11, CAST(12 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(61 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 12, CAST(13 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(62 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 13, CAST(14 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(63 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 14, CAST(15 AS Numeric(19, 0)))
        INSERT [dbo].[person_widget_definition] ([id], [version], [person_id], [visible], [pwd_position], [widget_definition_id]) VALUES (CAST(64 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), CAST(4 AS Numeric(19, 0)), 1, 15, CAST(16 AS Numeric(19, 0)))
        SET IDENTITY_INSERT [dbo].[person_widget_definition] OFF
        /****** Object:  Table [dbo].[owf_group_people]    Script Date: 09/08/2011 17:46:09 ******/
        INSERT [dbo].[owf_group_people] ([person_id], [group_id]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[owf_group_people] ([person_id], [group_id]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[owf_group_people] ([person_id], [group_id]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[owf_group_people] ([person_id], [group_id]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(2 AS Numeric(19, 0)))
        /****** Object:  Table [dbo].[dashboard]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[dashboard] ON
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 0, 0, N'6d08b7cd-29a4-444c-9d13-c084aeed3674', 0, N'tabbed', N'Tabbed Window Manager (testAdmin1)', CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 1, 0, N'456771d1-7bab-4572-9a42-c2adc1afa38d', 0, N'accordion', N'Accordion Window Manager (testAdmin1)', CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, 2, 0, N'f136de4b-ee63-4116-b968-5c9abe1fe779', 0, N'desktop', N'Desktop Window Manager (testAdmin1)', CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 3, 0, N'1306979e-9500-4120-ac11-5144c3c939d6', 3, N'portal', N'Portal Window Manager (testAdmin1)', CAST(1 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(5 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 0, 0, N'3b9c580a-ad91-4f94-8efe-a3b087e4806a', 0, N'tabbed', N'Tabbed Window Manager (testUser1)', CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(6 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 1, 0, N'5dae69ef-3735-4886-8b98-beae03578c7d', 0, N'accordion', N'Accordion Window Manager (testUser1)', CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(7 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, 2, 0, N'84e964df-2539-4282-a14e-890bc2056b72', 0, N'desktop', N'Desktop Window Manager (testUser1)', CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(8 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 3, 0, N'07261d44-e318-4540-84ac-276963df8245', 3, N'portal', N'Portal Window Manager (testUser1)', CAST(2 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(9 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 0, 0, N'674a47ae-a0f3-4b00-b658-3f812b53461d', 0, N'tabbed', N'Tabbed Window Manager (testUser2)', CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(10 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 1, 0, N'03fcd947-5365-4d81-a70a-448827b9f3d8', 0, N'accordion', N'Accordion Window Manager (testUser2)', CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(11 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 1, 2, 0, N'7c0f5661-1b28-4a87-99ae-f5079c449aeb', 0, N'desktop', N'Desktop Window Manager (testUser2)', CAST(3 AS Numeric(19, 0)))
        INSERT [dbo].[dashboard] ([id], [version], [isdefault], [dashboard_position], [altered_by_admin], [guid], [column_count], [layout], [name], [user_id]) VALUES (CAST(12 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), 0, 3, 0, N'309bed0f-328a-4b2a-95d8-53657929326b', 3, N'portal', N'Portal Window Manager (testUser2)', CAST(3 AS Numeric(19, 0)))
        SET IDENTITY_INSERT [dbo].[dashboard] OFF
        /****** Object:  Table [dbo].[dashboard_widget_state]    Script Date: 09/08/2011 17:46:09 ******/
        SET IDENTITY_INSERT [dbo].[dashboard_widget_state] ON
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(1 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(5 AS Numeric(19, 0)), 0, N'ff492cb9-3169-405b-b949-5d3c7d00f8ed', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(1 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(2 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(6 AS Numeric(19, 0)), 0, N'08596415-50b0-49b7-bfcf-89798acc2670', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(1 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(3 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(7 AS Numeric(19, 0)), 0, N'f451e775-d52b-437c-b728-0ccdfb0ff487', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(1 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(4 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'accordion', 0, 200, CAST(5 AS Numeric(19, 0)), 0, N'ad47205b-c6e2-431c-a432-ef7037f4cc65', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(2 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(5 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideNorth', 0, 200, CAST(6 AS Numeric(19, 0)), 0, N'893e73e3-1844-4b34-b1d5-a1818e4fedb7', 435, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(2 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(6 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideCenter', 0, 200, CAST(7 AS Numeric(19, 0)), 0, N'8333e544-263d-4a8d-9b97-b3096edb6328', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(2 AS Numeric(19, 0)), 200, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(7 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 100, CAST(5 AS Numeric(19, 0)), 0, N'cf545b57-c50b-4eb6-b615-d18b2d568cec', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(3 AS Numeric(19, 0)), 200, 200)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(8 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(6 AS Numeric(19, 0)), 0, N'4b8ea586-487b-4d28-acf7-c55ece19dcbc', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(3 AS Numeric(19, 0)), 250, 250)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(9 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 222, CAST(7 AS Numeric(19, 0)), 0, N'e45f9d15-5f6a-4916-9146-96607f44ed33', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(3 AS Numeric(19, 0)), 300, 300)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(10 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(9 AS Numeric(19, 0)), 0, N'4bbef9d0-93f8-4d88-906b-dead2c660a25', 300, 0, N'Widget Five', NULL, 0, 464, NULL, 0, 0, 0, 0, CAST(4 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(11 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(8 AS Numeric(19, 0)), 0, N'5a6ba6e1-5c49-4df2-a88f-643244e83abc', 400, 0, N'Widget Four', NULL, 1, 464, NULL, 0, 0, 1, 0, CAST(4 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(12 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(7 AS Numeric(19, 0)), 0, N'72643bd6-bdbf-4d05-bc5a-d2ce954304ef', 540, 0, N'Widget Three', NULL, 2, 630, NULL, 0, 0, 2, 0, CAST(4 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(13 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(21 AS Numeric(19, 0)), 0, N'614e5fd2-3156-4d38-8ab5-1e08ebea9324', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(5 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(14 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(22 AS Numeric(19, 0)), 0, N'facde559-31f0-4695-86ce-0ad551ef49b9', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(5 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(15 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(23 AS Numeric(19, 0)), 0, N'2c478cc2-8a37-4c6c-a57a-84db7b7bb4d6', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(5 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(16 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'accordion', 0, 200, CAST(21 AS Numeric(19, 0)), 0, N'4dfef93c-ed15-4b8c-bd83-d8e6bb9a83f0', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(6 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(17 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideNorth', 0, 200, CAST(22 AS Numeric(19, 0)), 0, N'd51e3d67-e178-498e-995f-7c2cfe0c307f', 435, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(6 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(18 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideCenter', 0, 200, CAST(23 AS Numeric(19, 0)), 0, N'5f99c4c4-a9b8-481d-bd61-ea306d6d28a9', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(6 AS Numeric(19, 0)), 200, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(19 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 100, CAST(21 AS Numeric(19, 0)), 0, N'93e50b1b-28f9-4979-98b1-b75e681bc426', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(7 AS Numeric(19, 0)), 200, 200)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(20 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(22 AS Numeric(19, 0)), 0, N'05aa4cd7-32e8-4eb3-8c8b-9fbb3c78e94a', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(7 AS Numeric(19, 0)), 250, 250)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(21 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 222, CAST(23 AS Numeric(19, 0)), 0, N'067600fb-8b98-4ed4-8294-9a7d5b07e522', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(7 AS Numeric(19, 0)), 300, 300)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(22 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(25 AS Numeric(19, 0)), 0, N'ff03479f-eefc-4b40-9761-f2c07ba15db3', 300, 0, N'Widget Five', NULL, 0, 464, NULL, 0, 0, 0, 0, CAST(8 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(23 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(24 AS Numeric(19, 0)), 0, N'b4058bb7-7df9-4f68-9506-84b75c96d5eb', 400, 0, N'Widget Four', NULL, 1, 464, NULL, 0, 0, 1, 0, CAST(8 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(24 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(23 AS Numeric(19, 0)), 0, N'0b0f3940-150f-4e04-a8b8-ae06b83361d4', 540, 0, N'Widget Three', NULL, 2, 630, NULL, 0, 0, 2, 0, CAST(8 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(25 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(37 AS Numeric(19, 0)), 0, N'6c6b2f05-32da-4ad6-8c71-21ba6df22900', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(9 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(26 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(38 AS Numeric(19, 0)), 0, N'4c100b4f-5210-4207-9d78-2090f0203c59', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(9 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(27 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(39 AS Numeric(19, 0)), 0, N'40744ef7-5a27-4cd1-9634-b51ab8a4c1df', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(9 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(28 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'accordion', 0, 200, CAST(37 AS Numeric(19, 0)), 0, N'98a4e8ec-d11a-445b-9dc6-9430ec318511', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(10 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(29 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideNorth', 0, 200, CAST(38 AS Numeric(19, 0)), 0, N'4b088544-9cbb-484f-8f37-9ccf417179e8', 435, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(10 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(30 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'rightSideCenter', 0, 200, CAST(39 AS Numeric(19, 0)), 0, N'fb5f7ae8-cae4-40b0-a4a9-2b57775c00fd', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(10 AS Numeric(19, 0)), 200, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(31 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 100, CAST(37 AS Numeric(19, 0)), 0, N'2f96059b-0112-4685-a62e-dffb7b764c00', 405, 0, N'Widget One', NULL, 0, 625, NULL, 0, 0, 0, 0, CAST(11 AS Numeric(19, 0)), 200, 200)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(32 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 200, CAST(38 AS Numeric(19, 0)), 0, N'3d30664c-5c7e-46a2-ac0d-4e2cb8c52c09', 635, 0, N'Widget Two', NULL, 0, 610, NULL, 0, 0, 1, 1, CAST(11 AS Numeric(19, 0)), 250, 250)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(33 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 222, CAST(39 AS Numeric(19, 0)), 0, N'ea583e7a-ebf0-4a99-a291-ed3b0a634047', 540, 0, N'Widget Three', NULL, 0, 630, NULL, 0, 0, 2, 0, CAST(11 AS Numeric(19, 0)), 300, 300)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(34 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(41 AS Numeric(19, 0)), 0, N'02a4273b-7f3c-4bd0-99d7-55e66568b07a', 300, 0, N'Widget Five', NULL, 0, 464, NULL, 0, 0, 0, 0, CAST(12 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(35 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(40 AS Numeric(19, 0)), 0, N'78f0b88f-3aca-4cce-a870-083af47de226', 400, 0, N'Widget Four', NULL, 1, 464, NULL, 0, 0, 1, 0, CAST(12 AS Numeric(19, 0)), 0, 0)
        INSERT [dbo].[dashboard_widget_state] ([id], [version], [region], [button_opened], [z_index], [person_widget_definition_id], [minimized], [unique_id], [height], [pinned], [name], [widget_guid], [column_pos], [width], [button_id], [collapsed], [maximized], [state_position], [active], [dashboard_id], [y], [x]) VALUES (CAST(36 AS Numeric(19, 0)), CAST(0 AS Numeric(19, 0)), N'none', 0, 0, CAST(39 AS Numeric(19, 0)), 0, N'70340447-beb1-448a-bffc-6320a32e9015', 540, 0, N'Widget Three', NULL, 2, 630, NULL, 0, 0, 2, 0, CAST(12 AS Numeric(19, 0)), 0, 0)
        SET IDENTITY_INSERT [dbo].[dashboard_widget_state] OFF
        /****** Object:  Table [dbo].[eventing_connections]    Script Date: 09/08/2011 17:46:09 ******/
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', '', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_3.7.0.groovy', '3.7.0-2', '2.0.1', '3:cbe5e34a9d02b85dd00159ffb3783040', 1)
GO

-- Changeset changelog_3.8.0.groovy::3.8.0-7::owf::(Checksum: 3:4163f7334862d1ae47e0a16041fcc73b)
-- Updating Admin Widget Icons and Names
UPDATE [dbo].[widget_definition] SET [display_name] = 'User Manager', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_user.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_user.png' WHERE widget_url='admin/UserManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'User Editor', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_user.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_user.png', [visible] = 0 WHERE widget_url='admin/UserEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Widget Manager', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_widget.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_widget.png' WHERE widget_url='admin/WidgetManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Widget Editor', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_widget.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_widget.png', [visible] = 0 WHERE widget_url='admin/WidgetEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Group Manager', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_group.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_group.png' WHERE widget_url='admin/GroupManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Group Editor', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_group.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_group.png', [visible] = 0 WHERE widget_url='admin/GroupEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Group Dashboard Manager', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_dashboard.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_dashboard.png' WHERE widget_url='admin/GroupDashboardManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Dashboard Editor', [image_url_large] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_dashboard.png', [image_url_small] = 'themes/owf-ext-theme/resources/themes/images/owf-ext/admin/64x64_blue_dashboard.png', [visible] = 0 WHERE widget_url='admin/DashboardEdit.gsp'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Updating Admin Widget Icons and Names', GETDATE(), 'Update Data (x8)', 'EXECUTED', 'changelog_3.8.0.groovy', '3.8.0-7', '2.0.1', '3:4163f7334862d1ae47e0a16041fcc73b', 2)
GO

-- Changeset changelog_3.8.0.groovy::3.8.0-8::owf::(Checksum: 3:b238501e1bba591174a058bae014f1ae)
-- Renaming sample dashboard names
UPDATE [dbo].[dashboard] SET [name] = 'Tabbed Window Manager' WHERE name like 'Tabbed Window Manager (%)'
GO

UPDATE [dbo].[dashboard] SET [name] = 'Accordion Window Manager' WHERE name like 'Accordion Window Manager (%)'
GO

UPDATE [dbo].[dashboard] SET [name] = 'Desktop Window Manager' WHERE name like 'Desktop Window Manager (%)'
GO

UPDATE [dbo].[dashboard] SET [name] = 'Portal Window Manager' WHERE name like 'Portal Window Manager (%)'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Renaming sample dashboard names', GETDATE(), 'Update Data (x4)', 'EXECUTED', 'changelog_3.8.0.groovy', '3.8.0-8', '2.0.1', '3:b238501e1bba591174a058bae014f1ae', 3)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-5::owf::(Checksum: 3:b48f7e8d8c8590b065e4f76f0613cc2d)
-- deleting old sample data
DELETE FROM [dbo].[role_people]
GO

DELETE FROM [dbo].[role]
GO

DELETE FROM [dbo].[requestmap]
GO

DELETE FROM [dbo].[preference]
GO

DELETE FROM [dbo].[owf_group_people]
GO

DELETE FROM [dbo].[dashboard_widget_state]
GO

DELETE FROM [dbo].[person_widget_definition]
GO

DELETE FROM [dbo].[domain_mapping]
GO

DELETE FROM [dbo].[dashboard]
GO

DELETE FROM [dbo].[owf_group]
GO

DELETE FROM [dbo].[widget_definition]
GO

DELETE FROM [dbo].[person]
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'deleting old sample data', GETDATE(), 'Delete Data (x12)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-5', '2.0.1', '3:b48f7e8d8c8590b065e4f76f0613cc2d', 4)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-6::owf::(Checksum: 3:6aea85e20f7bef869f4c22e7be83f1f5)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-6', '2.0.1', '3:6aea85e20f7bef869f4c22e7be83f1f5', 5)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-7::owf::(Checksum: 3:56bfda152e35ce325993eb717dc97ddd)
-- insert new sample data
INSERT INTO [dbo].[person] ([description], [email], [email_show], [enabled], [id], [user_real_name], [username], [version]) VALUES ('Test Administrator 1', 'testAdmin1@ozone3.test', 0, 1, 1, 'Test Admin 1', 'testAdmin1', 0)
GO

INSERT INTO [dbo].[person] ([description], [email], [email_show], [enabled], [id], [user_real_name], [username], [version]) VALUES ('Test User 1', 'testUser1@ozone3.test', 0, 1, 2, 'Test User 1', 'testUser1', 0)
GO

INSERT INTO [dbo].[person] ([description], [email], [email_show], [enabled], [id], [user_real_name], [username], [version]) VALUES ('Test User 2', 'testUser1@ozone3.test', 0, 1, 3, 'Test User 2', 'testUser2', 0)
GO

INSERT INTO [dbo].[person] ([email_show], [enabled], [id], [user_real_name], [username], [version]) VALUES (0, 1, 28, 'DEFAULT_USER', 'DEFAULT_USER', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-7', '2.0.1', '3:56bfda152e35ce325993eb717dc97ddd', 6)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-8::owf::(Checksum: 3:9b8ce7935597e00627e62f138a642084)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-8', '2.0.1', '3:9b8ce7935597e00627e62f138a642084', 7)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-9::owf::(Checksum: 3:4dc34561b4f3b10f09de573ae2566925)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-9', '2.0.1', '3:4dc34561b4f3b10f09de573ae2566925', 8)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-10::owf::(Checksum: 3:dce1159e015f1d6314c981dfe85f5dca)
-- insert new sample data
INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget A', 565, 6, 'themes/common/images/blue/icons/widgetIcons/widgetA.gif', 'themes/common/images/blue/icons/widgetContainer/widgetAsm.gif', 0, 0, 1, 'ea5435cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-a.html', '1.0', 615)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget B', 635, 7, 'themes/common/images/blue/icons/widgetIcons/widgetB.gif', 'themes/common/images/blue/icons/widgetContainer/widgetBsm.gif', 0, 0, 1, 'fb5435cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-b.html', '1.0', 565)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget C', 740, 8, 'themes/common/images/blue/icons/widgetIcons/widgetC.gif', 'themes/common/images/blue/icons/widgetContainer/widgetCsm.gif', 0, 0, 1, '0c5435cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-c.html', '1.0', 980)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget D', 525, 9, 'themes/common/images/blue/icons/widgetIcons/widgetD.gif', 'themes/common/images/blue/icons/widgetContainer/widgetDsm.gif', 0, 0, 1, '1d5435cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-d.html', '1.0', 630)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget One', 405, 10, 'themes/common/images/blue/icons/widgetIcons/widget1.gif', 'themes/common/images/blue/icons/widgetContainer/widget1sm.gif', 0, 0, 1, 'd6543ccf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-one.html', '1.0', 625)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Two', 635, 11, 'themes/common/images/blue/icons/widgetIcons/widget2.gif', 'themes/common/images/blue/icons/widgetContainer/widget2sm.gif', 0, 0, 1, 'e65431cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-two.html', '1.0', 610)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Three', 540, 12, 'themes/common/images/blue/icons/widgetIcons/widget3.gif', 'themes/common/images/blue/icons/widgetContainer/widget3sm.gif', 0, 0, 1, 'a65432cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-three.html', '1.0', 630)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Four', 350, 13, 'themes/common/images/blue/icons/widgetIcons/widget4.gif', 'themes/common/images/blue/icons/widgetContainer/widget4sm.gif', 0, 0, 1, 'b65434cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-four.html', '1.0', 675)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Five', 630, 14, 'themes/common/images/blue/icons/widgetIcons/widget5.gif', 'themes/common/images/blue/icons/widgetContainer/widget5sm.gif', 0, 0, 1, 'c65435cf-4021-4f2a-ba69-dde451d12551', 'examples/fake-widgets/widget-five.html', '1.0', 615)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Nearly Empty', 440, 15, 'themes/common/images/blue/icons/widgetIcons/nearlyEmpty.gif', 'themes/common/images/blue/icons/widgetContainer/nearlyEmptysm.gif', 0, 0, 1, 'bc5435cf-4021-4f2a-ba69-dde451d12551', 'examples/walkthrough/widgets/NearlyEmptyWidget.html', '1.0', 540)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Channel Shouter', 250, 16, 'themes/common/images/blue/icons/widgetIcons/channelShouter.gif', 'themes/common/images/blue/icons/widgetContainer/channelShoutersm.gif', 0, 0, 1, 'eb5435cf-4021-4f2a-ba69-dde451d12551', 'examples/walkthrough/widgets/ChannelShouter.html', '1.0', 295)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Channel Listener', 440, 17, 'themes/common/images/blue/icons/widgetIcons/channelListener.gif', 'themes/common/images/blue/icons/widgetContainer/channelListenersm.gif', 0, 0, 1, 'ec5435cf-4021-4f2a-ba69-dde451d12551', 'examples/walkthrough/widgets/ChannelListener.html', '1.0', 540)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Chrome', 440, 18, 'examples/walkthrough/images/chromeWiget_black_icon.png', 'examples/walkthrough/images/chromeWiget_blue_icon.png', 0, 0, 1, 'e8687289-f595-4b6d-9911-c714b483509d', 'examples/walkthrough/widgets/WidgetChrome.html', '1.0', 540)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Event Monitor Widget', 600, 19, 'examples/walkthrough/images/event_monitor_black_icon.png', 'examples/walkthrough/images/event_monitor_blue_icon.png', 0, 0, 1, '9d2e5f85-e199-4c6a-be31-4c6954206687', 'examples/walkthrough/widgets/EventMonitor.html', '1.0', 500)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Log', 440, 20, 'examples/walkthrough/images/log_icon.png', 'examples/walkthrough/images/log_icon_blue.png', 0, 0, 1, '4854fbd4-395c-442b-95c6-8b60702fd2b4', 'examples/walkthrough/widgets/WidgetLog.html', '1.0', 540)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Preferences Widget', 300, 21, 'examples/walkthrough/images/testpref_black_icon.png', 'examples/walkthrough/images/testpref_blue_icon.png', 0, 0, 1, '920b7cc1-dd37-46ac-8457-afda62613e56', 'examples/walkthrough/widgets/Preferences.html', '1.0', 450)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Users', 440, 151, 'themes/common/images/admin/64x64_blue_user.png', 'themes/common/images/admin/64x64_blue_user.png', 0, 0, 1, 'b3b1d04f-97c2-4726-9575-82bb1cf1af6a', 'admin/UserManagement.gsp', '1.0', 818)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'User Editor', 440, 154, 'themes/common/images/admin/64x64_blue_user.png', 'themes/common/images/admin/64x64_blue_user.png', 0, 0, 0, '101f119e-b56a-4e16-8219-11048c020038', 'admin/UserEdit.gsp', '1.0', 581)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widgets', 440, 156, 'themes/common/images/admin/64x64_blue_widget.png', 'themes/common/images/admin/64x64_blue_widget.png', 0, 0, 1, '412ec70d-a178-41ae-a8d9-6713a430c87c', 'admin/WidgetManagement.gsp', '1.0', 818)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Widget Editor', 493, 158, 'themes/common/images/admin/64x64_blue_widget.png', 'themes/common/images/admin/64x64_blue_widget.png', 0, 0, 0, '6cf4f84a-cc89-45ba-9577-15c34f66ee9c', 'admin/WidgetEdit.gsp', '1.0', 581)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Groups', 440, 160, 'themes/common/images/admin/64x64_blue_group.png', 'themes/common/images/admin/64x64_blue_group.png', 0, 0, 1, 'b87c4a3e-aa1e-499e-ba10-510f35388bb6', 'admin/GroupManagement.gsp', '1.0', 818)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Group Editor', 440, 163, 'themes/common/images/admin/64x64_blue_group.png', 'themes/common/images/admin/64x64_blue_group.png', 0, 0, 0, 'd6ce3375-6e89-45ab-a7be-b6cf3abb0e8c', 'admin/GroupEdit.gsp', '1.0', 581)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Group Dashboards', 440, 166, 'themes/common/images/admin/64x64_blue_dashboard.png', 'themes/common/images/admin/64x64_blue_dashboard.png', 0, 0, 1, '9d804b74-b2a6-448a-bd04-fe286905ab8f', 'admin/GroupDashboardManagement.gsp', '1.0', 818)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Dashboard Editor', 440, 170, 'themes/common/images/admin/64x64_blue_dashboard.png', 'themes/common/images/admin/64x64_blue_dashboard.png', 0, 0, 0, 'a540f672-a34c-4989-962c-dcbd559c3792', 'admin/DashboardEdit.gsp', '1.0', 581)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x24)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-10', '2.0.1', '3:dce1159e015f1d6314c981dfe85f5dca', 9)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-11::owf::(Checksum: 3:97a08e1ab2c49977ac3c526fbc115478)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-11', '2.0.1', '3:97a08e1ab2c49977ac3c526fbc115478', 10)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-12::owf::(Checksum: 3:4a1b6cf6fee545d03e644c1ad3194051)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person_widget_definition] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-12', '2.0.1', '3:4a1b6cf6fee545d03e644c1ad3194051', 11)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-13::owf::(Checksum: 3:8e3e82dc223694d1658209e2d2f7ce9e)
-- insert new sample data
INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (29, 1, 0, 0, 1, 6)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (30, 1, 1, 0, 1, 7)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (31, 1, 2, 0, 1, 8)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (32, 1, 3, 0, 1, 9)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (33, 1, 4, 0, 1, 10)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (34, 1, 5, 0, 1, 11)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (35, 1, 6, 0, 1, 12)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (36, 1, 7, 0, 1, 13)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (37, 1, 8, 0, 1, 14)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (38, 1, 9, 0, 1, 15)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (39, 1, 10, 0, 1, 16)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (40, 1, 11, 0, 1, 17)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (41, 1, 12, 0, 1, 18)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (42, 1, 13, 0, 1, 19)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (43, 1, 14, 0, 1, 20)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (44, 1, 15, 0, 1, 21)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (45, 2, 0, 0, 1, 6)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (46, 2, 1, 0, 1, 7)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (47, 2, 2, 0, 1, 8)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (48, 2, 3, 0, 1, 9)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (49, 2, 4, 0, 1, 10)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (50, 2, 5, 0, 1, 11)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (51, 2, 6, 0, 1, 12)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (52, 2, 7, 0, 1, 13)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (53, 2, 8, 0, 1, 14)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (54, 2, 9, 0, 1, 15)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (55, 2, 10, 0, 1, 16)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (56, 2, 11, 0, 1, 17)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (57, 2, 12, 0, 1, 18)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (58, 2, 13, 0, 1, 19)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (59, 2, 14, 0, 1, 20)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (60, 2, 15, 0, 1, 21)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (61, 3, 0, 0, 1, 6)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (62, 3, 1, 0, 1, 7)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (63, 3, 2, 0, 1, 8)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (64, 3, 3, 0, 1, 9)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (65, 3, 4, 0, 1, 10)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (66, 3, 5, 0, 1, 11)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (67, 3, 6, 0, 1, 12)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (68, 3, 7, 0, 1, 13)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (69, 3, 8, 0, 1, 14)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (70, 3, 9, 0, 1, 15)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (71, 3, 10, 0, 1, 16)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (72, 3, 11, 0, 1, 17)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (73, 3, 12, 0, 1, 18)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (74, 3, 13, 0, 1, 19)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (75, 3, 14, 0, 1, 20)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (76, 3, 15, 0, 1, 21)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (77, 28, 0, 0, 1, 6)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (78, 28, 1, 0, 1, 7)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (79, 28, 2, 0, 1, 8)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (80, 28, 3, 0, 1, 9)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (81, 28, 4, 0, 1, 10)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (82, 28, 5, 0, 1, 11)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (83, 28, 6, 0, 1, 12)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (84, 28, 7, 0, 1, 13)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (85, 28, 8, 0, 1, 14)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (86, 28, 9, 0, 1, 15)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (87, 28, 10, 0, 1, 16)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (88, 28, 11, 0, 1, 17)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (89, 28, 12, 0, 1, 18)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (90, 28, 13, 0, 1, 19)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (91, 28, 14, 0, 1, 20)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (92, 28, 15, 0, 1, 21)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (174, 1, 1, 0, 1, 151)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (177, 1, 1, 0, 1, 154)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (179, 1, 1, 0, 1, 156)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (181, 1, 1, 0, 1, 158)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (183, 1, 1, 0, 1, 160)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (185, 1, 1, 0, 1, 163)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (187, 1, 1, 0, 1, 166)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (189, 1, 1, 0, 1, 170)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x72)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-13', '2.0.1', '3:8e3e82dc223694d1658209e2d2f7ce9e', 12)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-14::owf::(Checksum: 3:843fbeecd7beaabb7b66766e01257b97)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person_widget_definition] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-14', '2.0.1', '3:843fbeecd7beaabb7b66766e01257b97', 13)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-15::owf::(Checksum: 3:6afc0de689e25f431dbc9e13b5f1c37f)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-15', '2.0.1', '3:6afc0de689e25f431dbc9e13b5f1c37f', 14)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-16::owf::(Checksum: 3:1e537730add70b5d19a30e0139a6927f)
-- insert new sample data
INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [created_by_id], [created_date], [dashboard_position], [default_settings], [description], [edited_by_id], [edited_date], [guid], [id], [isdefault], [layout], [name], [user_id], [version]) VALUES (0, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '917b4cd0-ecbd-410b-afd9-42d150c26426', 101, 1, 'desktop', 'Sample', 1, 0)
GO

INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [created_by_id], [created_date], [dashboard_position], [default_settings], [description], [edited_by_id], [edited_date], [guid], [id], [isdefault], [layout], [name], [user_id], [version]) VALUES (1, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '6f1d0c3e-821a-41ca-ac1b-ed72186bbb53', 117, 1, 'desktop', 'Sample', 2, 0)
GO

INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [created_by_id], [created_date], [dashboard_position], [default_settings], [description], [edited_by_id], [edited_date], [guid], [id], [isdefault], [layout], [name], [user_id], [version]) VALUES (0, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '985dee86-acf5-4f35-abc1-362ca60b39b8', 133, 1, 'desktop', 'Sample', 3, 0)
GO

INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [created_by_id], [created_date], [dashboard_position], [default_settings], [description], [edited_by_id], [edited_date], [guid], [id], [isdefault], [layout], [name], [user_id], [version]) VALUES (0, 0, NULL, NULL, 2, '
        {
           "widgetStates" :
              {
                 "b3b1d04f-97c2-4726-9575-82bb1cf1af6a" :
                    {
                       "x" : 20,
                       "y" : 20,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "412ec70d-a178-41ae-a8d9-6713a430c87c" :
                    {
                       "x" : 619,
                       "y" : 20,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "b87c4a3e-aa1e-499e-ba10-510f35388bb6" :
                    {
                       "x" : 20,
                       "y" : 442,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "9d804b74-b2a6-448a-bd04-fe286905ab8f" :
                    {
                       "x" : 619,
                       "y" : 442,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "101f119e-b56a-4e16-8219-11048c020038" :
                    {
                       "x" : 40,
                       "y" : 40,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "6cf4f84a-cc89-45ba-9577-15c34f66ee9c" :
                    {
                       "x" : 639,
                       "y" : 40,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "d6ce3375-6e89-45ab-a7be-b6cf3abb0e8c" :
                    {
                       "x" : 40,
                       "y" : 462,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    },
                 "a540f672-a34c-4989-962c-dcbd559c3792" :
                    {
                       "x" : 639,
                       "y" : 462,
                       "height" : 382,
                       "width" : 559,
                       "columnPos" : 0
                    }
              }
        }
      ', NULL, NULL, NULL, '05202a4a-ced5-b014-ec8c-5f942b0e8030', 150, 0, 'desktop', 'Administration', 1, 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-16', '2.0.1', '3:1e537730add70b5d19a30e0139a6927f', 15)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-17::owf::(Checksum: 3:9da58019b4389a434526b120cb82f0b3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-17', '2.0.1', '3:9da58019b4389a434526b120cb82f0b3', 16)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-18::owf::(Checksum: 3:3a3d5340a5a5ace302436ef6cb37288b)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard_widget_state] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-18', '2.0.1', '3:3a3d5340a5a5ace302436ef6cb37288b', 17)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-19::owf::(Checksum: 3:ae622822d6d601221be17fbc04cbacf9)
-- insert new sample data
INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 101, 405, 102, 0, 0, 'Widget One', 33, 0, 'none', 0, '83958046-e409-4d56-a03b-09b5a3ec8399', 0, NULL, 625, 200, 200, 100)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (1, NULL, 0, 0, 0, 101, 635, 103, 0, 0, 'Widget Two', 34, 0, 'none', 1, '7ea1fdd4-8b0d-47c6-a62a-326a6df9cc0c', 0, NULL, 610, 250, 250, 200)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 101, 540, 104, 0, 0, 'Widget Three', 35, 0, 'none', 2, 'ce8ee71f-ce79-4845-afbf-18a0a875a56e', 0, NULL, 630, 300, 300, 222)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 117, 405, 118, 0, 0, 'Widget One', 49, 0, 'none', 0, '5ea660a2-936b-4210-83db-f9d6381dc818', 0, NULL, 625, 200, 200, 100)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (1, NULL, 0, 0, 0, 117, 635, 119, 0, 0, 'Widget Two', 50, 0, 'none', 1, '20b21563-e731-4688-8146-758852361d00', 0, NULL, 610, 250, 250, 200)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 117, 540, 120, 0, 0, 'Widget Three', 51, 0, 'none', 2, '919d671a-33e1-4a34-830b-ee3f1c8cc4fb', 0, NULL, 630, 300, 300, 222)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 133, 405, 134, 0, 0, 'Widget One', 65, 0, 'none', 0, '23643536-c7db-4560-ad76-fff7b9f3c48c', 0, NULL, 625, 200, 200, 100)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (1, NULL, 0, 0, 0, 133, 635, 135, 0, 0, 'Widget Two', 66, 0, 'none', 1, '249beede-47b1-4c95-bf6c-97de96efab7b', 0, NULL, 610, 250, 250, 200)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 133, 540, 136, 0, 0, 'Widget Three', 67, 0, 'none', 2, 'ba3e8b1e-684d-4044-acdc-2c4d5e649e5c', 0, NULL, 630, 300, 300, 222)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 150, 382, 221, 0, 0, 'Users', 174, 0, 'none', 0, 'f9c72845-447b-06d1-6b80-59dbd7918adc', 0, 'b3b1d04f-97c2-4726-9575-82bb1cf1af6a', 559, 20, 20, 19000)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 150, 382, 222, 0, 0, 'Groups', 183, 0, 'none', 1, 'cd2e8e03-fae1-839f-e85e-8e3a8aa8cc70', 0, 'b87c4a3e-aa1e-499e-ba10-510f35388bb6', 559, 20, 442, 19010)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (0, NULL, 0, 0, 0, 150, 382, 223, 0, 0, 'Group Dashboards', 187, 0, 'none', 2, '8956159f-d450-c315-cbaa-09d12307dc4a', 0, '9d804b74-b2a6-448a-bd04-fe286905ab8f', 559, 619, 442, 19020)
GO

INSERT INTO [dbo].[dashboard_widget_state] ([active], [button_id], [button_opened], [collapsed], [column_pos], [dashboard_id], [height], [id], [maximized], [minimized], [name], [person_widget_definition_id], [pinned], [region], [state_position], [unique_id], [version], [widget_guid], [width], [x], [y], [z_index]) VALUES (1, NULL, 0, 0, 0, 150, 382, 224, 0, 0, 'Widgets', 179, 0, 'none', 3, 'c35df5a7-978f-210e-7dab-6df28f09469f', 0, '412ec70d-a178-41ae-a8d9-6713a430c87c', 559, 619, 20, 19030)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x13)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-19', '2.0.1', '3:ae622822d6d601221be17fbc04cbacf9', 18)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-20::owf::(Checksum: 3:77324f286836f3c2083cf4d97ba89712)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard_widget_state] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-20', '2.0.1', '3:77324f286836f3c2083cf4d97ba89712', 19)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-21::owf::(Checksum: 3:e1bbc2a49c95fa461e87c6e9ca935a1c)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-21', '2.0.1', '3:e1bbc2a49c95fa461e87c6e9ca935a1c', 20)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-22::owf::(Checksum: 3:ac040168255d915bc4c4440087bb9ae1)
-- insert new sample data
INSERT INTO [dbo].[owf_group] ([automatic], [description], [email], [id], [name], [status], [version]) VALUES (0, 'TestGroup1', 'testgroup1@group1.com', 4, 'TestGroup1', 'active', 0)
GO

INSERT INTO [dbo].[owf_group] ([automatic], [description], [email], [id], [name], [status], [version]) VALUES (0, 'TestGroup2', 'testgroup2@group2.com', 5, 'TestGroup2', 'active', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-22', '2.0.1', '3:ac040168255d915bc4c4440087bb9ae1', 21)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-23::owf::(Checksum: 3:a92ef7058e95dc7fc22b74f927d694ab)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-23', '2.0.1', '3:a92ef7058e95dc7fc22b74f927d694ab', 22)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-25::owf::(Checksum: 3:ade3ef8907b4a13a374f05723b4712b4)
-- insert new sample data
INSERT INTO [dbo].[owf_group_people] ([group_id], [person_id]) VALUES (4, 2)
GO

INSERT INTO [dbo].[owf_group_people] ([group_id], [person_id]) VALUES (4, 1)
GO

INSERT INTO [dbo].[owf_group_people] ([group_id], [person_id]) VALUES (5, 2)
GO

INSERT INTO [dbo].[owf_group_people] ([group_id], [person_id]) VALUES (5, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-25', '2.0.1', '3:ade3ef8907b4a13a374f05723b4712b4', 23)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-27::owf::(Checksum: 3:88bdfb2fcd44bd865e76fcda61e7d4fa)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[role] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-27', '2.0.1', '3:88bdfb2fcd44bd865e76fcda61e7d4fa', 24)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-28::owf::(Checksum: 3:56cf365e11bb693bc75b4131efbc4556)
-- insert new sample data
INSERT INTO [dbo].[role] ([authority], [description], [id], [version]) VALUES ('ROLE_USER', 'User Role', 26, 2)
GO

INSERT INTO [dbo].[role] ([authority], [description], [id], [version]) VALUES ('ROLE_ADMIN', 'Admin Role', 27, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-28', '2.0.1', '3:56cf365e11bb693bc75b4131efbc4556', 25)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-29::owf::(Checksum: 3:652cc97efe70c114fd64bb95ff6758bd)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[role] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-29', '2.0.1', '3:652cc97efe70c114fd64bb95ff6758bd', 26)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-31::owf::(Checksum: 3:4318d8906f61a4c4429c3af056f06c87)
-- insert new sample data
INSERT INTO [dbo].[role_people] ([person_id], [role_id]) VALUES (2, 26)
GO

INSERT INTO [dbo].[role_people] ([person_id], [role_id]) VALUES (3, 26)
GO

INSERT INTO [dbo].[role_people] ([person_id], [role_id]) VALUES (28, 26)
GO

INSERT INTO [dbo].[role_people] ([person_id], [role_id]) VALUES (1, 27)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-31', '2.0.1', '3:4318d8906f61a4c4429c3af056f06c87', 27)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-33::owf::(Checksum: 3:33bc03c179a7fea33070389090310cde)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[preference] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-33', '2.0.1', '3:33bc03c179a7fea33070389090310cde', 28)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-34::owf::(Checksum: 3:62011f2458c9d6a9f4884f2c3349dab8)
-- insert new sample data
INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (144, 'foo.bar.0', 'test path entry 0', 2, 'foovalue', 0)
GO

INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (145, 'foo.bar.1', 'test path entry 1', 2, 'foovalue', 0)
GO

INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (146, 'foo.bar.0', 'test path entry 0', 3, 'foovalue', 0)
GO

INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (147, 'foo.bar.1', 'test path entry 1', 3, 'foovalue', 0)
GO

INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (148, 'foo.bar.0', 'test path entry 0', 1, 'foovalue', 0)
GO

INSERT INTO [dbo].[preference] ([id], [namespace], [path], [user_id], [value], [version]) VALUES (149, 'foo.bar.1', 'test path entry 1', 1, 'foovalue', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x6)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-34', '2.0.1', '3:62011f2458c9d6a9f4884f2c3349dab8', 29)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-35::owf::(Checksum: 3:f47f30b273184c5e832951ff12a46f2a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[preference] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-35', '2.0.1', '3:f47f30b273184c5e832951ff12a46f2a', 30)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-36::owf::(Checksum: 3:9b8027f3578751f37ca975af3ea8dd9a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-36', '2.0.1', '3:9b8027f3578751f37ca975af3ea8dd9a', 31)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-37::owf::(Checksum: 3:f277332664f1f36f3f13bf4977c1bd84)
-- insert new sample data
INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (6, 'widget_definition', 22, 'owns', 4, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (7, 'widget_definition', 23, 'owns', 4, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (6, 'widget_definition', 24, 'owns', 5, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (7, 'widget_definition', 25, 'owns', 5, 'group', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-37', '2.0.1', '3:f277332664f1f36f3f13bf4977c1bd84', 32)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-38::owf::(Checksum: 3:ecc99350f7b63eee250d398d0da42de3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-38', '2.0.1', '3:ecc99350f7b63eee250d398d0da42de3', 33)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-39::owf::(Checksum: 3:59c7a92c0f57221743c838ea0c1e7b6f)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tags] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-39', '2.0.1', '3:59c7a92c0f57221743c838ea0c1e7b6f', 34)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-40::owf::(Checksum: 3:7c595f960a0d9cbaec670333fdbaea32)
-- insert new sample data
INSERT INTO [dbo].[tags] ([id], [name], [version]) VALUES (152, 'admin', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-40', '2.0.1', '3:7c595f960a0d9cbaec670333fdbaea32', 35)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-41::owf::(Checksum: 3:5328f3c92a37153b983de54b717ed9a5)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tags] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-41', '2.0.1', '3:5328f3c92a37153b983de54b717ed9a5', 36)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-42::owf::(Checksum: 3:75ec49b903334d42d8584a310e0d17de)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tag_links] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-42', '2.0.1', '3:75ec49b903334d42d8584a310e0d17de', 37)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-43::owf::(Checksum: 3:2241715a9f8abce9ffed932735763bcc)
-- insert new sample data
INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 153, -1, 152, 151, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 155, -1, 152, 154, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 157, -1, 152, 156, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 159, -1, 152, 158, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 162, -1, 152, 160, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 164, -1, 152, 163, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 165, -1, 152, 161, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 169, -1, 152, 166, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 168, -1, 152, 167, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 172, -1, 152, 170, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 173, -1, 152, 171, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 176, -1, 152, 174, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 178, -1, 152, 177, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 180, -1, 152, 179, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 182, -1, 152, 181, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 184, -1, 152, 183, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 186, -1, 152, 185, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 188, -1, 152, 187, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 190, -1, 152, 189, 'personWidgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x19)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-43', '2.0.1', '3:2241715a9f8abce9ffed932735763bcc', 38)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-44::owf::(Checksum: 3:1ad4cd99dc411058555bdb225d526771)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tag_links] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-44', '2.0.1', '3:1ad4cd99dc411058555bdb225d526771', 39)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-46::owf::(Checksum: 3:5c1705f46d07fab68b80494982589ffe)
UPDATE [dbo].[widget_definition] SET [widget_url] = 'examples/walkthrough/widgets/ChannelListener.gsp' WHERE widget_url='examples/walkthrough/widgets/ChannelListener.html'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', '', GETDATE(), 'Update Data', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-46', '2.0.1', '3:5c1705f46d07fab68b80494982589ffe', 40)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-53::owf::(Checksum: 3:7fed1a797ab9d36fdb18255281541337)
-- Insert widget type mapping links
insert into widget_definition_widget_types (widget_definition_id, widget_type_id)
      select id, 1 from widget_definition
      where widget_url not in (
        'admin/DashboardEdit.gsp',
        'admin/GroupDashboardManagement.gsp',
        'admin/GroupEdit.gsp',
        'admin/GroupManagement.gsp',
        'admin/MarketplaceApprovals.gsp',
        'admin/UserManagement.gsp',
        'admin/UserEdit.gsp',
        'admin/WidgetEdit.gsp',
        'admin/WidgetManagement.gsp'
        )
GO

insert into widget_definition_widget_types (widget_definition_id, widget_type_id)
      select id, 2 from widget_definition
      where widget_url in (
        'admin/DashboardEdit.gsp',
        'admin/GroupDashboardManagement.gsp',
        'admin/GroupEdit.gsp',
        'admin/GroupManagement.gsp',
        'admin/MarketplaceApprovals.gsp',
        'admin/UserManagement.gsp',
        'admin/UserEdit.gsp',
        'admin/WidgetEdit.gsp',
        'admin/WidgetManagement.gsp'
        )
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Insert widget type mapping links', GETDATE(), 'Custom SQL (x2)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-53', '2.0.1', '3:7fed1a797ab9d36fdb18255281541337', 41)
GO

-- Changeset changelog_4.0.0.groovy::4.0.0-55::owf::(Checksum: 3:43c93ef1d7f35a92c470fdcfde7b2d6f)
-- Updating Admin Widget Icons and Names
UPDATE [dbo].[widget_definition] SET [display_name] = 'Users', [image_url_large] = 'themes/common/images/adm-tools/Users64.png', [image_url_small] = 'themes/common/images/adm-tools/Users24.png' WHERE widget_url='admin/UserManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/adm-tools/Users64.png', [image_url_small] = 'themes/common/images/adm-tools/Users24.png' WHERE widget_url='admin/UserEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Widgets', [image_url_large] = 'themes/common/images/adm-tools/Widgets64.png', [image_url_small] = 'themes/common/images/adm-tools/Widgets24.png' WHERE widget_url='admin/WidgetManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/adm-tools/Widgets64.png', [image_url_small] = 'themes/common/images/adm-tools/Widgets24.png' WHERE widget_url='admin/WidgetEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Groups', [image_url_large] = 'themes/common/images/adm-tools/Groups64.png', [image_url_small] = 'themes/common/images/adm-tools/Groups24.png' WHERE widget_url='admin/GroupManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/adm-tools/Groups64.png', [image_url_small] = 'themes/common/images/adm-tools/Groups24.png' WHERE widget_url='admin/GroupEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Group Dashboards', [image_url_large] = 'themes/common/images/adm-tools/Dashboards64.png', [image_url_small] = 'themes/common/images/adm-tools/Dashboards24.png' WHERE widget_url='admin/GroupDashboardManagement.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/adm-tools/Dashboards64.png', [image_url_small] = 'themes/common/images/adm-tools/Dashboards24.png' WHERE widget_url='admin/DashboardEdit.gsp'
GO

UPDATE [dbo].[widget_definition] SET [display_name] = 'Approvals', [image_url_large] = 'themes/common/images/adm-tools/Approvals64.png', [image_url_small] = 'themes/common/images/adm-tools/Approvals24.png', [visible] = 1 WHERE widget_url='admin/MarketplaceApprovals.gsp'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Updating Admin Widget Icons and Names', GETDATE(), 'Update Data (x9)', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-55', '2.0.1', '3:43c93ef1d7f35a92c470fdcfde7b2d6f', 42)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-5::owf::(Checksum: 3:a3a4f6fe76ad042b42e27bdf7b09d277)
-- Rename All Users and OWF Admins groups to OWF Users and OWF Administrators, then set them to automatic.
UPDATE [dbo].[owf_group] SET [automatic] = 1, [name] = 'OWF Users' WHERE name='All Users' AND automatic=0
GO

UPDATE [dbo].[owf_group] SET [automatic] = 1, [name] = 'OWF Administrators' WHERE name='OWF Admins' AND automatic=0
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Rename All Users and OWF Admins groups to OWF Users and OWF Administrators, then set them to automatic.', GETDATE(), 'Update Data (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-5', '2.0.1', '3:a3a4f6fe76ad042b42e27bdf7b09d277', 43)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-6::owf::(Checksum: 3:96aa216a330817681aca38dc66d1129b)
-- Set default value for display_name
UPDATE owf_group
			SET display_name = name
			WHERE display_name IS NULL
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Set default value for display_name', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-6', '2.0.1', '3:96aa216a330817681aca38dc66d1129b', 44)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-7::owf::(Checksum: 3:55a215b64becd106729fc560fca74a21)
-- Updating Sample Widget URLs
UPDATE [dbo].[widget_definition] SET [widget_url] = 'examples/walkthrough/widgets/ChannelShouter.gsp' WHERE widget_url='examples/walkthrough/widgets/ChannelShouter.html'
GO

UPDATE [dbo].[widget_definition] SET [widget_url] = 'examples/walkthrough/widgets/Preferences.gsp' WHERE widget_url='examples/walkthrough/widgets/Preferences.html'
GO

UPDATE [dbo].[widget_definition] SET [widget_url] = 'examples/walkthrough/widgets/WidgetChrome.gsp' WHERE widget_url='examples/walkthrough/widgets/WidgetChrome.html'
GO

UPDATE [dbo].[widget_definition] SET [widget_url] = 'examples/walkthrough/widgets/WidgetLog.gsp' WHERE widget_url='examples/walkthrough/widgets/WidgetLog.html'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Updating Sample Widget URLs', GETDATE(), 'Update Data (x4)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-7', '2.0.1', '3:55a215b64becd106729fc560fca74a21', 45)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-8::owf::(Checksum: 3:e1bbc2a49c95fa461e87c6e9ca935a1c)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-8', '2.0.1', '3:e1bbc2a49c95fa461e87c6e9ca935a1c', 46)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-9::owf::(Checksum: 3:4a029c2334ee8d0f12dd11f10e53a1fd)
-- Add admin group
INSERT INTO [dbo].[owf_group] ([automatic], [description], [display_name], [id], [name], [status], [version]) VALUES (1, 'OWF Administrators', 'OWF Administrators', 191, 'OWF Administrators', 'active', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Add admin group', GETDATE(), 'Insert Row', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-9', '2.0.1', '3:4a029c2334ee8d0f12dd11f10e53a1fd', 47)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-10::owf::(Checksum: 3:a92ef7058e95dc7fc22b74f927d694ab)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-10', '2.0.1', '3:a92ef7058e95dc7fc22b74f927d694ab', 48)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-11::owf::(Checksum: 3:9b8027f3578751f37ca975af3ea8dd9a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-11', '2.0.1', '3:9b8027f3578751f37ca975af3ea8dd9a', 49)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-12::owf::(Checksum: 3:8259b91ae15d229983ec7c7899ce52cd)
-- Updating Sample Admin Dashboard to be in the admin group
UPDATE [dbo].[dashboard] SET [user_id] = NULL WHERE id=150
GO

UPDATE [dbo].[dashboard_widget_state] SET [person_widget_definition_id] = NULL WHERE dashboard_id=150
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (150, 'dashboard', 192, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Updating Sample Admin Dashboard to be in the admin group', GETDATE(), 'Update Data (x2), Insert Row', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-12', '2.0.1', '3:8259b91ae15d229983ec7c7899ce52cd', 50)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-13::owf::(Checksum: 3:ecc99350f7b63eee250d398d0da42de3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-13', '2.0.1', '3:ecc99350f7b63eee250d398d0da42de3', 51)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-14::owf::(Checksum: 3:4dc34561b4f3b10f09de573ae2566925)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-14', '2.0.1', '3:4dc34561b4f3b10f09de573ae2566925', 52)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-15::owf::(Checksum: 3:c2d3b3571a76497a6de5db75f34c46d4)
-- insert new sample data
INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Color Server', 300, 172, 'themes/common/images/blue/icons/widgetIcons/channelShouter.gif', 'themes/common/images/blue/icons/widgetContainer/channelShoutersm.gif', 0, 0, 1, '2410a41d-0bc9-cee6-2645-a89087da374f', 'examples/walkthrough/widgets/ColorServer.gsp', '1.0', 300)
GO

INSERT INTO [dbo].[widget_definition] ([background], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'Color Client', 300, 173, 'themes/common/images/blue/icons/widgetIcons/channelListener.gif', 'themes/common/images/blue/icons/widgetContainer/channelListenersm.gif', 0, 0, 1, '4bc8e886-b576-3dac-015d-589b4813ceda', 'examples/walkthrough/widgets/ColorClient.gsp', '1.0', 300)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-15', '2.0.1', '3:c2d3b3571a76497a6de5db75f34c46d4', 53)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-16::owf::(Checksum: 3:97a08e1ab2c49977ac3c526fbc115478)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-16', '2.0.1', '3:97a08e1ab2c49977ac3c526fbc115478', 54)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-17::owf::(Checksum: 3:4a1b6cf6fee545d03e644c1ad3194051)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person_widget_definition] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-17', '2.0.1', '3:4a1b6cf6fee545d03e644c1ad3194051', 55)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-18::owf::(Checksum: 3:2101485c508626863f8c60d6dcb83305)
-- insert new sample data
INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (190, 28, 16, 0, 1, 173)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (191, 1, 16, 0, 1, 173)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (192, 2, 16, 0, 1, 173)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (193, 3, 16, 0, 1, 173)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (194, 28, 17, 0, 1, 172)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (195, 1, 17, 0, 1, 172)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (196, 2, 17, 0, 1, 172)
GO

INSERT INTO [dbo].[person_widget_definition] ([id], [person_id], [pwd_position], [version], [visible], [widget_definition_id]) VALUES (197, 3, 17, 0, 1, 172)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x8)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-18', '2.0.1', '3:2101485c508626863f8c60d6dcb83305', 56)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-19::owf::(Checksum: 3:843fbeecd7beaabb7b66766e01257b97)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[person_widget_definition] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-19', '2.0.1', '3:843fbeecd7beaabb7b66766e01257b97', 57)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-20::owf::(Checksum: 3:9b8027f3578751f37ca975af3ea8dd9a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-20', '2.0.1', '3:9b8027f3578751f37ca975af3ea8dd9a', 58)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-21::owf::(Checksum: 3:794c1478fed2f3277efed5300225daed)
-- insert new sample data
INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (170, 'widget_definition', 200, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (171, 'widget_definition', 201, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-21', '2.0.1', '3:794c1478fed2f3277efed5300225daed', 59)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-22::owf::(Checksum: 3:ecc99350f7b63eee250d398d0da42de3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-22', '2.0.1', '3:ecc99350f7b63eee250d398d0da42de3', 60)
GO

-- Changeset changelog_5.0.0.groovy::5.0.0-23::owf::(Checksum: 3:77d50cef2581b1cd4a89ea3c9040b73a)
-- insert new sample data
INSERT INTO [dbo].[widget_definition_widget_types] ([widget_definition_id], [widget_type_id]) VALUES (172, 1)
GO

INSERT INTO [dbo].[widget_definition_widget_types] ([widget_definition_id], [widget_type_id]) VALUES (173, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-23', '2.0.1', '3:77d50cef2581b1cd4a89ea3c9040b73a', 61)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-18::owf::(Checksum: 3:4dc34561b4f3b10f09de573ae2566925)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-18', '2.0.1', '3:4dc34561b4f3b10f09de573ae2566925', 62)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-19::owf::(Checksum: 3:060ed35d30b4c3f5fc656d920dd53aac)
-- insert new sample data
INSERT INTO [dbo].[widget_definition] ([background], [description], [descriptor_url], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [universal_name], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'This widget displays the end of day report for the New York Stock Exchange.', '../examples/walkthrough/descriptors/NYSE_descriptor.html', 'NYSE Widget', 437, 178, 'themes/common/images/blue/icons/widgetIcons/widgetC.gif', 'themes/common/images/blue/icons/widgetContainer/widgetCsm.gif', 0, 'org.owfgoss.owf.examples.NYSE', 0, 1, 'fe137961-039d-e7a5-7050-d6eed7ac4782', 'examples/walkthrough/widgets/NYSE.gsp', '1.0', 825)
GO

INSERT INTO [dbo].[widget_definition] ([background], [description], [descriptor_url], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [universal_name], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'This widget displays HTML.', '../examples/walkthrough/descriptors/HTMLViewer_descriptor.html', 'HTML Viewer', 600, 179, 'themes/common/images/blue/icons/widgetIcons/widgetC.gif', 'themes/common/images/blue/icons/widgetContainer/widgetCsm.gif', 0, 'org.owfgoss.owf.examples.HTMLViewer', 0, 1, 'cd5e77f8-cb28-8574-0a8a-a535bd2c7de4', 'examples/walkthrough/widgets/HTMLViewer.gsp', '1.0', 400)
GO

INSERT INTO [dbo].[widget_definition] ([background], [description], [descriptor_url], [display_name], [height], [id], [image_url_large], [image_url_small], [singleton], [universal_name], [version], [visible], [widget_guid], [widget_url], [widget_version], [width]) VALUES (0, 'This widget charts stock prices.', '../examples/walkthrough/descriptors/StockChart_descriptor.html', 'Stock Chart', 600, 180, 'themes/common/images/blue/icons/widgetIcons/widgetC.gif', 'themes/common/images/blue/icons/widgetContainer/widgetCsm.gif', 0, 'org.owfgoss.owf.examples.StockChart', 0, 1, '92078ac9-6f21-2f5f-6afc-bdc8c915c66d', 'examples/walkthrough/widgets/StockChart.gsp', '1.0', 800)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x3)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-19', '2.0.1', '3:060ed35d30b4c3f5fc656d920dd53aac', 63)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-20::owf::(Checksum: 3:4b2eabcf9c66a32485f65255d22f142f)
-- insert new sample data
INSERT INTO [dbo].[widget_definition_widget_types] ([widget_definition_id], [widget_type_id]) VALUES (178, 1)
GO

INSERT INTO [dbo].[widget_definition_widget_types] ([widget_definition_id], [widget_type_id]) VALUES (179, 1)
GO

INSERT INTO [dbo].[widget_definition_widget_types] ([widget_definition_id], [widget_type_id]) VALUES (180, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x3)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-20', '2.0.1', '3:4b2eabcf9c66a32485f65255d22f142f', 64)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-21::owf::(Checksum: 3:97a08e1ab2c49977ac3c526fbc115478)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_definition] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-21', '2.0.1', '3:97a08e1ab2c49977ac3c526fbc115478', 65)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-22::owf::(Checksum: 3:e1bbc2a49c95fa461e87c6e9ca935a1c)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-22', '2.0.1', '3:e1bbc2a49c95fa461e87c6e9ca935a1c', 66)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-23::owf::(Checksum: 3:2ef3a5917ef4c44ca618a48bc22f35a2)
-- Add OWF Users group
INSERT INTO [dbo].[owf_group] ([automatic], [description], [display_name], [id], [name], [status], [version]) VALUES (1, 'OWF Users', 'OWF Users', 192, 'OWF Users', 'active', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Add OWF Users group', GETDATE(), 'Insert Row', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-23', '2.0.1', '3:2ef3a5917ef4c44ca618a48bc22f35a2', 67)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-24::owf::(Checksum: 3:a92ef7058e95dc7fc22b74f927d694ab)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[owf_group] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-24', '2.0.1', '3:a92ef7058e95dc7fc22b74f927d694ab', 68)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-26::owf::(Checksum: 3:0a3449c1768dc73dd1c4cb402027935f)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[intent] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-26', '2.0.1', '3:0a3449c1768dc73dd1c4cb402027935f', 69)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-27::owf::(Checksum: 3:3fa5da9f6c183c928b5023132ad3f5e5)
-- insert new sample data
INSERT INTO [dbo].[intent] ([action], [id], [version]) VALUES ('Graph', 301, 0)
GO

INSERT INTO [dbo].[intent] ([action], [id], [version]) VALUES ('View', 302, 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x2)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-27', '2.0.1', '3:3fa5da9f6c183c928b5023132ad3f5e5', 70)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-28::owf::(Checksum: 3:5a386a89e949ff5c9f3f8dcbda560067)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[intent] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-28', '2.0.1', '3:5a386a89e949ff5c9f3f8dcbda560067', 71)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-29::owf::(Checksum: 3:4280425483e0828f1044f4c60dc62cea)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[intent_data_type] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-29', '2.0.1', '3:4280425483e0828f1044f4c60dc62cea', 72)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-30::owf::(Checksum: 3:4390a2bef918c69968b16fbd4ee8fcbb)
-- insert new sample data
INSERT INTO [dbo].[intent_data_type] ([data_type], [id], [version]) VALUES ('Prices', 303, 0)
GO

INSERT INTO [dbo].[intent_data_type] ([data_type], [id], [version]) VALUES ('HTML', 304, 0)
GO

INSERT INTO [dbo].[intent_data_types] ([intent_data_type_id], [intent_id]) VALUES (303, 301)
GO

INSERT INTO [dbo].[intent_data_types] ([intent_data_type_id], [intent_id]) VALUES (304, 302)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-30', '2.0.1', '3:4390a2bef918c69968b16fbd4ee8fcbb', 73)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-31::owf::(Checksum: 3:8ea9aa0a598e67fcbb5518cc23f70c81)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[intent_data_type] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-31', '2.0.1', '3:8ea9aa0a598e67fcbb5518cc23f70c81', 74)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-32::owf::(Checksum: 3:87836d7a3af415c523221c80b55742b7)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_def_intent] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-32', '2.0.1', '3:87836d7a3af415c523221c80b55742b7', 75)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-33::owf::(Checksum: 3:738a85e664c3c906cee14aff1ce53308)
-- insert new sample data
INSERT INTO [dbo].[widget_def_intent] ([id], [intent_id], [receive], [send], [version], [widget_definition_id]) VALUES (305, 301, 0, 1, 0, 178)
GO

INSERT INTO [dbo].[widget_def_intent] ([id], [intent_id], [receive], [send], [version], [widget_definition_id]) VALUES (306, 302, 0, 1, 0, 178)
GO

INSERT INTO [dbo].[widget_def_intent] ([id], [intent_id], [receive], [send], [version], [widget_definition_id]) VALUES (307, 302, 1, 0, 0, 179)
GO

INSERT INTO [dbo].[widget_def_intent] ([id], [intent_id], [receive], [send], [version], [widget_definition_id]) VALUES (308, 301, 1, 0, 0, 180)
GO

INSERT INTO [dbo].[widget_def_intent_data_types] ([intent_data_type_id], [widget_definition_intent_id]) VALUES (303, 305)
GO

INSERT INTO [dbo].[widget_def_intent_data_types] ([intent_data_type_id], [widget_definition_intent_id]) VALUES (304, 306)
GO

INSERT INTO [dbo].[widget_def_intent_data_types] ([intent_data_type_id], [widget_definition_intent_id]) VALUES (304, 307)
GO

INSERT INTO [dbo].[widget_def_intent_data_types] ([intent_data_type_id], [widget_definition_intent_id]) VALUES (303, 308)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x8)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-33', '2.0.1', '3:738a85e664c3c906cee14aff1ce53308', 76)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-34::owf::(Checksum: 3:81ce4ce93951c3533756fef6d4cacfba)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[widget_def_intent] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-34', '2.0.1', '3:81ce4ce93951c3533756fef6d4cacfba', 77)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-35::owf::(Checksum: 3:59c7a92c0f57221743c838ea0c1e7b6f)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tags] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-35', '2.0.1', '3:59c7a92c0f57221743c838ea0c1e7b6f', 78)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-36::owf::(Checksum: 3:d526ccb1874fe44c40d2400d52f82940)
-- insert new sample data
INSERT INTO [dbo].[tags] ([id], [name], [version]) VALUES (309, 'grid', 0)
GO

INSERT INTO [dbo].[tags] ([id], [name], [version]) VALUES (310, 'html', 0)
GO

INSERT INTO [dbo].[tags] ([id], [name], [version]) VALUES (311, 'document_viewer', 0)
GO

INSERT INTO [dbo].[tags] ([id], [name], [version]) VALUES (312, 'stock_chart', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-36', '2.0.1', '3:d526ccb1874fe44c40d2400d52f82940', 79)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-37::owf::(Checksum: 3:5328f3c92a37153b983de54b717ed9a5)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tags] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-37', '2.0.1', '3:5328f3c92a37153b983de54b717ed9a5', 80)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-38::owf::(Checksum: 3:75ec49b903334d42d8584a310e0d17de)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tag_links] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-38', '2.0.1', '3:75ec49b903334d42d8584a310e0d17de', 81)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-39::owf::(Checksum: 3:ac51eb6f9c799aed93ad91a3d2896bf8)
-- insert new sample data
INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 313, -1, 309, 178, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 314, -1, 310, 179, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 315, -1, 311, 179, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[tag_links] ([editable], [id], [pos], [tag_id], [tag_ref], [type], [version], [visible]) VALUES (1, 316, -1, 312, 180, 'widgetDefinition', 0, 1)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x4)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-39', '2.0.1', '3:ac51eb6f9c799aed93ad91a3d2896bf8', 82)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-40::owf::(Checksum: 3:1ad4cd99dc411058555bdb225d526771)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[tag_links] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-40', '2.0.1', '3:1ad4cd99dc411058555bdb225d526771', 83)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-41::owf::(Checksum: 3:9b8027f3578751f37ca975af3ea8dd9a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-41', '2.0.1', '3:9b8027f3578751f37ca975af3ea8dd9a', 84)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-42::owf::(Checksum: 3:01f2eb3a1f8091f5f5c61a837a4c1ff8)
-- insert new sample data
INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (178, 'widget_definition', 317, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (179, 'widget_definition', 318, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (180, 'widget_definition', 319, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (16, 'widget_definition', 320, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (17, 'widget_definition', 321, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (20, 'widget_definition', 322, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (151, 'widget_definition', 323, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (154, 'widget_definition', 324, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (156, 'widget_definition', 325, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (158, 'widget_definition', 326, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (160, 'widget_definition', 327, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (163, 'widget_definition', 328, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (166, 'widget_definition', 329, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (170, 'widget_definition', 330, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'insert new sample data', GETDATE(), 'Insert Row (x14)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-42', '2.0.1', '3:01f2eb3a1f8091f5f5c61a837a4c1ff8', 85)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-43::owf::(Checksum: 3:ecc99350f7b63eee250d398d0da42de3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-43', '2.0.1', '3:ecc99350f7b63eee250d398d0da42de3', 86)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-45::owf::(Checksum: 3:ed4ba41c7537c780288b08d0ca336903)
-- Removing Fake Widgets
DELETE FROM dashboard_widget_state WHERE person_widget_definition_id IN (SELECT id FROM person_widget_definition WHERE widget_definition_id IN (SELECT id FROM widget_definition WHERE widget_guid IN ('ea5435cf-4021-4f2a-ba69-dde451d12551','fb5435cf-4021-4f2a-ba69-dde451d12551','0c5435cf-4021-4f2a-ba69-dde451d12551','1d5435cf-4021-4f2a-ba69-dde451d12551','d6543ccf-4021-4f2a-ba69-dde451d12551','e65431cf-4021-4f2a-ba69-dde451d12551','a65432cf-4021-4f2a-ba69-dde451d12551','b65434cf-4021-4f2a-ba69-dde451d12551','c65435cf-4021-4f2a-ba69-dde451d12551')))
GO

DELETE FROM person_widget_definition WHERE widget_definition_id IN (SELECT id FROM widget_definition WHERE widget_guid IN ('ea5435cf-4021-4f2a-ba69-dde451d12551','fb5435cf-4021-4f2a-ba69-dde451d12551','0c5435cf-4021-4f2a-ba69-dde451d12551','1d5435cf-4021-4f2a-ba69-dde451d12551','d6543ccf-4021-4f2a-ba69-dde451d12551','e65431cf-4021-4f2a-ba69-dde451d12551','a65432cf-4021-4f2a-ba69-dde451d12551','b65434cf-4021-4f2a-ba69-dde451d12551','c65435cf-4021-4f2a-ba69-dde451d12551'))
GO

DELETE FROM widget_definition_widget_types WHERE widget_definition_id IN (SELECT id FROM widget_definition WHERE widget_guid IN ('ea5435cf-4021-4f2a-ba69-dde451d12551','fb5435cf-4021-4f2a-ba69-dde451d12551','0c5435cf-4021-4f2a-ba69-dde451d12551','1d5435cf-4021-4f2a-ba69-dde451d12551','d6543ccf-4021-4f2a-ba69-dde451d12551','e65431cf-4021-4f2a-ba69-dde451d12551','a65432cf-4021-4f2a-ba69-dde451d12551','b65434cf-4021-4f2a-ba69-dde451d12551','c65435cf-4021-4f2a-ba69-dde451d12551'))
GO

DELETE FROM widget_definition WHERE widget_guid IN ('ea5435cf-4021-4f2a-ba69-dde451d12551','fb5435cf-4021-4f2a-ba69-dde451d12551','0c5435cf-4021-4f2a-ba69-dde451d12551','1d5435cf-4021-4f2a-ba69-dde451d12551','d6543ccf-4021-4f2a-ba69-dde451d12551','e65431cf-4021-4f2a-ba69-dde451d12551','a65432cf-4021-4f2a-ba69-dde451d12551','b65434cf-4021-4f2a-ba69-dde451d12551','c65435cf-4021-4f2a-ba69-dde451d12551')
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Removing Fake Widgets', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-45', '2.0.1', '3:ed4ba41c7537c780288b08d0ca336903', 87)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-47::owf::(Checksum: 3:6afc0de689e25f431dbc9e13b5f1c37f)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-47', '2.0.1', '3:6afc0de689e25f431dbc9e13b5f1c37f', 88)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-48::owf::(Checksum: 3:15ea47b3dd0935f3ac7819d817972075)
-- Add Intents, Sample, and Administration Dashboards
INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [dashboard_position], [default_settings], [description], [guid], [id], [isdefault], [layout_config], [name], [version]) VALUES (0, 0, 0, '{}', 'This dashboard uses the sample Intents Widgets to demonstrate the widget intents workflow.', '3f59855b-d93e-dc03-c6ba-f4c33ea0177f', 320, 1, '{"xtype":"container","cls":"vbox ","layout":{"type":"vbox","align":"stretch"},"items":[{"xtype":"container","cls":"hbox top","layout":{"type":"hbox","align":"stretch"},"items":[{"xtype":"fitpane","cls":"left","flex":1,"htmlText":"50%","items":[],"widgets":[{"widgetGuid":"fe137961-039d-e7a5-7050-d6eed7ac4782","uniqueId":"ecbe0bd5-7781-d859-2dbc-13f86be406a7","dashboardGuid":"3f59855b-d93e-dc03-c6ba-f4c33ea0177f","paneGuid":"16ec8b84-a631-4e7c-d9cc-883635abd6ef","intentConfig":null,"launchData":null,"name":"NYSE Widget","active":true,"x":0,"y":34,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":538,"width":798,"background":false,"columnOrder":""}],"paneType":"fitpane","defaultSettings":{}},{"xtype":"dashboardsplitter"},{"xtype":"fitpane","cls":"right","flex":1,"htmlText":"50%","items":[],"paneType":"fitpane","widgets":[{"widgetGuid":"cd5e77f8-cb28-8574-0a8a-a535bd2c7de4","uniqueId":"66e7148e-3cd3-72ff-6a24-6143ac618b80","dashboardGuid":"3f59855b-d93e-dc03-c6ba-f4c33ea0177f","paneGuid":"443dfdc0-7165-cb7d-dd9c-f08fbe36bdb1","intentConfig":null,"launchData":null,"name":"HTML Viewer","active":false,"x":802,"y":34,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":538,"width":798,"background":false,"columnOrder":""}],"defaultSettings":{}}],"flex":1},{"xtype":"dashboardsplitter"},{"xtype":"fitpane","cls":"bottom","flex":1,"htmlText":"50%","items":[],"paneType":"fitpane","widgets":[{"widgetGuid":"92078ac9-6f21-2f5f-6afc-bdc8c915c66d","uniqueId":"b17f186c-0d31-2077-1c3b-2a43dbf83738","dashboardGuid":"3f59855b-d93e-dc03-c6ba-f4c33ea0177f","paneGuid":"410cd0ee-cbdd-f225-582e-6aaa92e058f2","intentConfig":null,"launchData":null,"name":"Stock Chart","active":false,"x":0,"y":576,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":539,"width":1600,"background":false,"columnOrder":""}],"defaultSettings":{}}],"height":"100%"}', 'Widget Intents', 0)
GO

INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [dashboard_position], [default_settings], [description], [guid], [id], [isdefault], [layout_config], [name], [version]) VALUES (0, 0, 0, '{}', '', 'c62ce95c-d16d-4ffe-afae-c46fa64a689b', 321, 0, '{"xtype":"desktoppane","flex":1,"height":"100%","items":[],"paneType":"desktoppane","widgets":[{"widgetGuid":"eb5435cf-4021-4f2a-ba69-dde451d12551","uniqueId":"17580ea1-02fc-8ca7-e794-b5644f7dc21d","dashboardGuid":"905968f7-f94d-1c9b-431c-a05dc7bb68d1","paneGuid":"f3712dc1-6e90-2469-8cb3-5b499937cac8","name":"Channel Shouter","active":false,"x":549,"y":7,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":2,"intentConfig":null,"launchData":null,"singleton":false,"floatingWidget":false,"background":false,"zIndex":19120,"height":250,"width":295},{"widgetGuid":"ec5435cf-4021-4f2a-ba69-dde451d12551","uniqueId":"9bdc8e96-f311-4a0b-c5b9-23ae5d768297","dashboardGuid":"905968f7-f94d-1c9b-431c-a05dc7bb68d1","paneGuid":"f3712dc1-6e90-2469-8cb3-5b499937cac8","name":"Channel Listener","active":true,"x":4,"y":5,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"intentConfig":null,"launchData":null,"singleton":false,"floatingWidget":false,"background":false,"zIndex":19130,"height":383,"width":540}],"defaultSettings":{"widgetStates":{"ec5435cf-4021-4f2a-ba69-dde451d12551":{"x":4,"y":5,"height":383,"width":540,"timestamp":1348064185725},"eb5435cf-4021-4f2a-ba69-dde451d12551":{"x":549,"y":7,"height":250,"width":295,"timestamp":1348064183912}}}}', 'Sample', 0)
GO

INSERT INTO [dbo].[dashboard] ([altered_by_admin], [column_count], [dashboard_position], [default_settings], [description], [guid], [id], [isdefault], [layout_config], [name], [version]) VALUES (0, 0, 0, '{}', 'This dashboard provides the widgets needed to administer dashboards, widgets, groups, and users in OWF.', '54949b5d-f0ee-4347-811e-2522a1bf96fe', 322, 0, '{"xtype":"container","cls":"vbox ","layout":{"type":"vbox","align":"stretch"},"items":[{"xtype":"container","cls":"hbox top","layout":{"type":"hbox","align":"stretch"},"items":[{"xtype":"fitpane","cls":"left","flex":1,"htmlText":"50%","items":[],"widgets":[{"widgetGuid":"b3b1d04f-97c2-4726-9575-82bb1cf1af6a","uniqueId":"9251add0-28f1-ea2e-4bee-92f0d21d940d","dashboardGuid":"79e8db83-08e7-4bc7-b2a1-958fd53eff26","paneGuid":"994cc403-2baa-dc68-d172-e8e59b937ed1","intentConfig":null,"launchData":null,"name":"Users","active":false,"x":0,"y":34,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":538,"width":798}],"paneType":"fitpane","defaultSettings":{}},{"xtype":"dashboardsplitter"},{"xtype":"fitpane","cls":"right","flex":1,"htmlText":"50%","items":[],"paneType":"fitpane","widgets":[{"widgetGuid":"b87c4a3e-aa1e-499e-ba10-510f35388bb6","uniqueId":"713c90d5-a51f-ae72-d67c-672d477b6ec7","dashboardGuid":"79e8db83-08e7-4bc7-b2a1-958fd53eff26","paneGuid":"2b47e10c-0f7d-aa9b-3e12-11ca57f229fc","intentConfig":null,"launchData":null,"name":"Groups","active":false,"x":802,"y":34,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":538,"width":798}],"defaultSettings":{}}],"flex":1},{"xtype":"dashboardsplitter"},{"xtype":"container","cls":"hbox bottom","layout":{"type":"hbox","align":"stretch"},"items":[{"xtype":"fitpane","cls":"left","flex":1,"htmlText":"50%","items":[],"widgets":[{"widgetGuid":"412ec70d-a178-41ae-a8d9-6713a430c87c","uniqueId":"4ece13a7-b58f-e7d2-2df9-3e138fa43314","dashboardGuid":"79e8db83-08e7-4bc7-b2a1-958fd53eff26","paneGuid":"af782c7d-4c38-35a1-7f81-68eb9c11c440","intentConfig":null,"launchData":null,"name":"Widgets","active":false,"x":0,"y":576,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":539,"width":798}],"paneType":"fitpane","defaultSettings":{}},{"xtype":"dashboardsplitter"},{"xtype":"fitpane","cls":"right","flex":1,"htmlText":"50%","items":[],"paneType":"fitpane","widgets":[{"widgetGuid":"9d804b74-b2a6-448a-bd04-fe286905ab8f","uniqueId":"7eaea99c-8ad5-ce3f-5325-a003b4174a54","dashboardGuid":"79e8db83-08e7-4bc7-b2a1-958fd53eff26","paneGuid":"2e8ae979-52d5-a0ab-d30b-299672fe9a50","intentConfig":null,"launchData":null,"name":"Group Dashboards","active":false,"x":802,"y":576,"zIndex":0,"minimized":false,"maximized":false,"pinned":false,"collapsed":false,"columnPos":0,"buttonId":null,"buttonOpened":false,"region":"none","statePosition":1,"singleton":false,"floatingWidget":false,"height":539,"width":798}],"defaultSettings":{}}],"flex":1}],"flex":3}', 'Administration', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Add Intents, Sample, and Administration Dashboards', GETDATE(), 'Insert Row (x3)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-48', '2.0.1', '3:15ea47b3dd0935f3ac7819d817972075', 89)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-49::owf::(Checksum: 3:9da58019b4389a434526b120cb82f0b3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[dashboard] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-49', '2.0.1', '3:9da58019b4389a434526b120cb82f0b3', 90)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-50::owf::(Checksum: 3:9b8027f3578751f37ca975af3ea8dd9a)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] ON
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-50', '2.0.1', '3:9b8027f3578751f37ca975af3ea8dd9a', 91)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-51::owf::(Checksum: 3:923063aff6c51dd622faccaae6891875)
-- Assign Intents and Sample Dashboards to OWF Users group
INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (320, 'dashboard', 331, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (321, 'dashboard', 332, 'owns', 192, 'group', 0)
GO

INSERT INTO [dbo].[domain_mapping] ([dest_id], [dest_type], [id], [relationship_type], [src_id], [src_type], [version]) VALUES (322, 'dashboard', 333, 'owns', 191, 'group', 0)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Assign Intents and Sample Dashboards to OWF Users group', GETDATE(), 'Insert Row (x3)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-51', '2.0.1', '3:923063aff6c51dd622faccaae6891875', 92)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-52::owf::(Checksum: 3:ecc99350f7b63eee250d398d0da42de3)
-- allow identity inserts
SET IDENTITY_INSERT [dbo].[domain_mapping] OFF
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'allow identity inserts', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-52', '2.0.1', '3:ecc99350f7b63eee250d398d0da42de3', 93)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-54::owf::(Checksum: 3:1030fea638ddcb2be0c8da1ad2308e80)
-- Rename HTML intents data type to text/html.
UPDATE [dbo].[intent_data_type] SET [data_type] = 'text/html' WHERE data_type='HTML'
GO

UPDATE [dbo].[intent_data_type] SET [data_type] = 'application/vnd.owf.sample.price' WHERE data_type='Prices'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Rename HTML intents data type to text/html.', GETDATE(), 'Update Data (x2)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-54', '2.0.1', '3:1030fea638ddcb2be0c8da1ad2308e80', 94)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-61::owf::(Checksum: 3:357918ca0126a890067c38257b1d37ed)
-- Remove old Sample and Administration Dashboards
DELETE FROM [dbo].[dashboard_widget_state]  WHERE dashboard_id in (101, 117, 133, 150)
GO

DELETE FROM [dbo].[domain_mapping]  WHERE dest_id=150 AND dest_type='dashboard'
GO

DELETE FROM [dbo].[dashboard]  WHERE id in (101, 117, 133, 150)
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Remove old Sample and Administration Dashboards', GETDATE(), 'Delete Data (x3)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-61', '2.0.1', '3:357918ca0126a890067c38257b1d37ed', 95)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-63::owf::(Checksum: 3:48f77118fcda6e77c7d4417b438e99c6)
-- upgrade any pwds that were pending approval to use the disabled column
update person_widget_definition
            set disabled = 1
            from person_widget_definition as pwd, tag_links as taglinks
            where pwd.id = taglinks.tag_ref and taglinks.type = 'personWidgetDefinition' and taglinks.editable = 0
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'upgrade any pwds that were pending approval to use the disabled column', GETDATE(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-63', '2.0.1', '3:48f77118fcda6e77c7d4417b438e99c6', 96)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-64::owf::(Checksum: 3:00fbecf2a78a14eda48576f0085af5d4)
-- delete any taglinks which were pending approval (have editable false)
DELETE FROM [dbo].[tag_links]  WHERE editable = 0
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'delete any taglinks which were pending approval (have editable false)', GETDATE(), 'Delete Data', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-64', '2.0.1', '3:00fbecf2a78a14eda48576f0085af5d4', 97)
GO

-- Changeset changelog_6.0.0.groovy::6.0.0-65::owf::(Checksum: 3:3259ab7fe31a394213ba7151b8a53e52)
-- Updating Sample Widget images
UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/ChannelListener.png', [image_url_small] = 'themes/common/images/widget-icons/ChannelListener.png' WHERE widget_url='examples/walkthrough/widgets/ChannelListener.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/ChannelShouter.png', [image_url_small] = 'themes/common/images/widget-icons/ChannelShouter.png' WHERE widget_url='examples/walkthrough/widgets/ChannelShouter.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/ColorClient.png', [image_url_small] = 'themes/common/images/widget-icons/ColorClient.png' WHERE widget_url='examples/walkthrough/widgets/ColorClient.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/ColorServer.png', [image_url_small] = 'themes/common/images/widget-icons/ColorServer.png' WHERE widget_url='examples/walkthrough/widgets/ColorServer.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/EventMonitor.png', [image_url_small] = 'themes/common/images/widget-icons/EventMonitor.png' WHERE widget_url='examples/walkthrough/widgets/EventMonitor.html'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/HTMLViewer.png', [image_url_small] = 'themes/common/images/widget-icons/HTMLViewer.png' WHERE widget_url='examples/walkthrough/widgets/HTMLViewer.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/NearlyEmpty.png', [image_url_small] = 'themes/common/images/widget-icons/NearlyEmpty.png' WHERE widget_url='examples/walkthrough/widgets/NearlyEmptyWidget.html'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/NYSEStock.png', [image_url_small] = 'themes/common/images/widget-icons/NYSEStock.png' WHERE widget_url='examples/walkthrough/widgets/NYSE.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/Preferences.png', [image_url_small] = 'themes/common/images/widget-icons/Preferences.png' WHERE widget_url='examples/walkthrough/widgets/Preferences.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/PriceChart.png', [image_url_small] = 'themes/common/images/widget-icons/PriceChart.png' WHERE widget_url='examples/walkthrough/widgets/StockChart.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/WidgetChrome.png', [image_url_small] = 'themes/common/images/widget-icons/WidgetChrome.png' WHERE widget_url='examples/walkthrough/widgets/WidgetChrome.gsp'
GO

UPDATE [dbo].[widget_definition] SET [image_url_large] = 'themes/common/images/widget-icons/WidgetLog.png', [image_url_small] = 'themes/common/images/widget-icons/WidgetLog.png' WHERE widget_url='examples/walkthrough/widgets/WidgetLog.gsp'
GO

INSERT INTO [dbo].[DATABASECHANGELOG] ([AUTHOR], [COMMENTS], [DATEEXECUTED], [DESCRIPTION], [EXECTYPE], [FILENAME], [ID], [LIQUIBASE], [MD5SUM], [ORDEREXECUTED]) VALUES ('owf', 'Updating Sample Widget images', GETDATE(), 'Update Data (x12)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-65', '2.0.1', '3:3259ab7fe31a394213ba7151b8a53e52', 98)
GO

-- Release Database Lock
