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

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

-- Lock Database
-- Changeset changelog_3.7.0.groovy::3.7.0-2::owf::(Checksum: 3:ad73bb1bb782dbc77d4b92775b08af26)
DROP SEQUENCE HIBERNATE_SEQUENCE;

CREATE SEQUENCE HIBERNATE_SEQUENCE
         START WITH     1000;

Insert into PERSON (ID,VERSION,ENABLED,USER_REAL_NAME,USERNAME,LAST_LOGIN,EMAIL_SHOW,EMAIL,PREV_LOGIN,DESCRIPTION) values (1,0,1,'Test Admin 1','testAdmin1',to_timestamp('08-SEP-11 04.03.33.606000000 PM','DD-MON-RR HH.MI.SS.FF AM'),0,'testAdmin1@ozone3.test',null,'Test Administrator 1');

Insert into PERSON (ID,VERSION,ENABLED,USER_REAL_NAME,USERNAME,LAST_LOGIN,EMAIL_SHOW,EMAIL,PREV_LOGIN,DESCRIPTION) values (2,0,1,'Test User 1','testUser1',to_timestamp('03-SEP-11 04.03.34.823000000 PM','DD-MON-RR HH.MI.SS.FF AM'),0,'testUser1@ozone3.test',null,'Test User 1');

Insert into PERSON (ID,VERSION,ENABLED,USER_REAL_NAME,USERNAME,LAST_LOGIN,EMAIL_SHOW,EMAIL,PREV_LOGIN,DESCRIPTION) values (3,0,1,'Test User 2','testUser2',to_timestamp('03-SEP-11 04.03.34.839000000 PM','DD-MON-RR HH.MI.SS.FF AM'),0,'testUser2@ozone3.test',null,'Test User 2');

Insert into PERSON (ID,VERSION,ENABLED,USER_REAL_NAME,USERNAME,LAST_LOGIN,EMAIL_SHOW,EMAIL,PREV_LOGIN,DESCRIPTION) values (28,0,1,'DEFAULT_USER','DEFAULT_USER',to_timestamp('08-SEP-11 04.03.35.370000000 PM','DD-MON-RR HH.MI.SS.FF AM'),0,null,null,null);

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (6,0,1,'images/blue/icons/widgetIcons/widgetA.gif','images/blue/icons/widgetContainer/widgetAsm.gif',0,615,'1.0',565,'examples/fake-widgets/widget-a.html','ea5435cf-4021-4f2a-ba69-dde451d12551','Widget A');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (7,0,1,'images/blue/icons/widgetIcons/widgetB.gif','images/blue/icons/widgetContainer/widgetBsm.gif',0,565,'1.0',635,'examples/fake-widgets/widget-b.html','fb5435cf-4021-4f2a-ba69-dde451d12551','Widget B');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (8,0,1,'images/blue/icons/widgetIcons/widgetC.gif','images/blue/icons/widgetContainer/widgetCsm.gif',0,980,'1.0',740,'examples/fake-widgets/widget-c.html','0c5435cf-4021-4f2a-ba69-dde451d12551','Widget C');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (9,0,1,'images/blue/icons/widgetIcons/widgetD.gif','images/blue/icons/widgetContainer/widgetDsm.gif',0,630,'1.0',525,'examples/fake-widgets/widget-d.html','1d5435cf-4021-4f2a-ba69-dde451d12551','Widget D');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (10,0,1,'images/blue/icons/widgetIcons/widget1.gif','images/blue/icons/widgetContainer/widget1sm.gif',0,625,'1.0',405,'examples/fake-widgets/widget-one.html','d6543ccf-4021-4f2a-ba69-dde451d12551','Widget One');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (11,0,1,'images/blue/icons/widgetIcons/widget2.gif','images/blue/icons/widgetContainer/widget2sm.gif',0,610,'1.0',635,'examples/fake-widgets/widget-two.html','e65431cf-4021-4f2a-ba69-dde451d12551','Widget Two');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (12,0,1,'images/blue/icons/widgetIcons/widget3.gif','images/blue/icons/widgetContainer/widget3sm.gif',0,630,'1.0',540,'examples/fake-widgets/widget-three.html','a65432cf-4021-4f2a-ba69-dde451d12551','Widget Three');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (13,0,1,'images/blue/icons/widgetIcons/widget4.gif','images/blue/icons/widgetContainer/widget4sm.gif',0,675,'1.0',350,'examples/fake-widgets/widget-four.html','b65434cf-4021-4f2a-ba69-dde451d12551','Widget Four');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (14,0,1,'images/blue/icons/widgetIcons/widget5.gif','images/blue/icons/widgetContainer/widget5sm.gif',0,615,'1.0',630,'examples/fake-widgets/widget-five.html','c65435cf-4021-4f2a-ba69-dde451d12551','Widget Five');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (15,0,1,'images/blue/icons/widgetIcons/nearlyEmpty.gif','images/blue/icons/widgetContainer/nearlyEmptysm.gif',0,540,'1.0',440,'examples/walkthrough/widgets/NearlyEmptyWidget.html','bc5435cf-4021-4f2a-ba69-dde451d12551','Nearly Empty');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (16,0,1,'images/blue/icons/widgetIcons/channelShouter.gif','images/blue/icons/widgetContainer/channelShoutersm.gif',0,295,'1.0',250,'examples/walkthrough/widgets/ChannelShouter.html','eb5435cf-4021-4f2a-ba69-dde451d12551','Channel Shouter');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (17,0,1,'images/blue/icons/widgetIcons/channelListener.gif','images/blue/icons/widgetContainer/channelListenersm.gif',0,540,'1.0',440,'examples/walkthrough/widgets/ChannelListener.html','ec5435cf-4021-4f2a-ba69-dde451d12551','Channel Listener');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (18,0,1,'examples/walkthrough/images/chromeWiget_black_icon.png ','examples/walkthrough/images/chromeWiget_blue_icon.png ',0,540,'1.0',440,'examples/walkthrough/widgets/WidgetChrome.html','e8687289-f595-4b6d-9911-c714b483509d','Widget Chrome');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (19,0,1,'examples/walkthrough/images/event_monitor_black_icon.png','examples/walkthrough/images/event_monitor_blue_icon.png',0,500,'1.0',600,'examples/walkthrough/widgets/EventMonitor.html','9d2e5f85-e199-4c6a-be31-4c6954206687','Event Monitor Widget');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (20,0,1,'examples/walkthrough/images/log_icon.png','examples/walkthrough/images/log_icon_blue.png',0,540,'1.0',440,'examples/walkthrough/widgets/WidgetLog.html','4854fbd4-395c-442b-95c6-8b60702fd2b4','Widget Log');

Insert into WIDGET_DEFINITION (ID,VERSION,VISIBLE,IMAGE_URL_LARGE,IMAGE_URL_SMALL,SINGLETON,WIDTH,WIDGET_VERSION,HEIGHT,WIDGET_URL,WIDGET_GUID,DISPLAY_NAME) values (21,0,1,'examples/walkthrough/images/testpref_black_icon.png','examples/walkthrough/images/testpref_blue_icon.png',0,450,'1.0',300,'examples/walkthrough/widgets/Preferences.html','920b7cc1-dd37-46ac-8457-afda62613e56','Preferences Widget');

Insert into OWF_GROUP (ID,VERSION,STATUS,EMAIL,DESCRIPTION,NAME,AUTOMATIC) values (4,0,'active','testgroup1@group1.com','TestGroup1','TestGroup1',0);

Insert into OWF_GROUP (ID,VERSION,STATUS,EMAIL,DESCRIPTION,NAME,AUTOMATIC) values (5,0,'active','testgroup2@group2.com','TestGroup2','TestGroup2',0);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (93,0,0,0,0,'b02c3687-1dc5-42d9-85ab-1e0576c0ab02',0,'tabbed','Tabbed Window Manager (testAdmin1)',1);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (97,0,0,1,0,'fbdfbea5-3625-4db3-8eeb-259358d8f943',0,'accordion','Accordion Window Manager (testAdmin1)',1);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (101,0,1,2,0,'1d92504b-2dae-4608-95e6-ab2c02545152',0,'desktop','Desktop Window Manager (testAdmin1)',1);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (105,0,0,3,0,'2f09ede2-b6cc-4a8a-8580-35f7c0235ec8',3,'portal','Portal Window Manager (testAdmin1)',1);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (109,0,0,0,0,'b43bd8ea-c25c-455e-9e4b-b5fba7144cc2',0,'tabbed','Tabbed Window Manager (testUser1)',2);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (113,0,0,1,0,'40027ae4-2330-4a75-9cd7-6551de911a13',0,'accordion','Accordion Window Manager (testUser1)',2);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (117,0,1,2,0,'3b5ea8b2-ff57-4d6b-b4ea-4682761f3b27',0,'desktop','Desktop Window Manager (testUser1)',2);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (121,0,0,3,0,'ca396204-56f6-48b5-a603-3687b06792ec',3,'portal','Portal Window Manager (testUser1)',2);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (125,0,0,0,0,'e1b5fc3b-a9f2-4648-abf8-ad3a62fd234b',0,'tabbed','Tabbed Window Manager (testUser2)',3);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (129,0,0,1,0,'18701438-8542-48bc-ac10-15867ec33246',0,'accordion','Accordion Window Manager (testUser2)',3);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (133,0,1,2,0,'d679ad4e-6303-44ea-b8eb-30731997ff2a',0,'desktop','Desktop Window Manager (testUser2)',3);

Insert into DASHBOARD (ID,VERSION,ISDEFAULT,DASHBOARD_POSITION,ALTERED_BY_ADMIN,GUID,COLUMN_COUNT,LAYOUT,NAME,USER_ID) values (137,0,0,3,0,'f3dc711e-bf34-41c6-95f8-8ca36b8f502f',3,'portal','Portal Window Manager (testUser2)',3);

Insert into DOMAIN_MAPPING (ID,VERSION,SRC_ID,SRC_TYPE,RELATIONSHIP_TYPE,DEST_ID,DEST_TYPE) values (22,0,4,'group','owns',6,'widget_definition');

Insert into DOMAIN_MAPPING (ID,VERSION,SRC_ID,SRC_TYPE,RELATIONSHIP_TYPE,DEST_ID,DEST_TYPE) values (23,0,4,'group','owns',7,'widget_definition');

Insert into DOMAIN_MAPPING (ID,VERSION,SRC_ID,SRC_TYPE,RELATIONSHIP_TYPE,DEST_ID,DEST_TYPE) values (24,0,5,'group','owns',6,'widget_definition');

Insert into DOMAIN_MAPPING (ID,VERSION,SRC_ID,SRC_TYPE,RELATIONSHIP_TYPE,DEST_ID,DEST_TYPE) values (25,0,5,'group','owns',7,'widget_definition');

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (29,0,1,1,0,6);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (30,0,1,1,1,7);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (31,0,1,1,2,8);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (32,0,1,1,3,9);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (33,0,1,1,4,10);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (34,0,1,1,5,11);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (35,0,1,1,6,12);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (36,0,1,1,7,13);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (37,0,1,1,8,14);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (38,0,1,1,9,15);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (39,0,1,1,10,16);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (40,0,1,1,11,17);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (41,0,1,1,12,18);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (42,0,1,1,13,19);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (43,0,1,1,14,20);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (44,0,1,1,15,21);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (45,0,2,1,0,6);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (46,0,2,1,1,7);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (47,0,2,1,2,8);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (48,0,2,1,3,9);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (49,0,2,1,4,10);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (50,0,2,1,5,11);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (51,0,2,1,6,12);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (52,0,2,1,7,13);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (53,0,2,1,8,14);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (54,0,2,1,9,15);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (55,0,2,1,10,16);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (56,0,2,1,11,17);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (57,0,2,1,12,18);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (58,0,2,1,13,19);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (59,0,2,1,14,20);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (60,0,2,1,15,21);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (61,0,3,1,0,6);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (62,0,3,1,1,7);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (63,0,3,1,2,8);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (64,0,3,1,3,9);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (65,0,3,1,4,10);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (66,0,3,1,5,11);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (67,0,3,1,6,12);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (68,0,3,1,7,13);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (69,0,3,1,8,14);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (70,0,3,1,9,15);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (71,0,3,1,10,16);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (72,0,3,1,11,17);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (73,0,3,1,12,18);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (74,0,3,1,13,19);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (75,0,3,1,14,20);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (76,0,3,1,15,21);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (77,0,28,1,0,6);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (78,0,28,1,1,7);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (79,0,28,1,2,8);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (80,0,28,1,3,9);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (81,0,28,1,4,10);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (82,0,28,1,5,11);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (83,0,28,1,6,12);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (84,0,28,1,7,13);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (85,0,28,1,8,14);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (86,0,28,1,9,15);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (87,0,28,1,10,16);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (88,0,28,1,11,17);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (89,0,28,1,12,18);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (90,0,28,1,13,19);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (91,0,28,1,14,20);

Insert into PERSON_WIDGET_DEFINITION (ID,VERSION,PERSON_ID,VISIBLE,PWD_POSITION,WIDGET_DEFINITION_ID) values (92,0,28,1,15,21);

Insert into 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 (94,0,'none',0,200,33,0,'6017b78a-8c3f-4f3c-9892-727b65ce9b09',405,0,'Widget One',null,0,625,null,0,0,0,0,93,0,0);

Insert into 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 (95,0,'none',0,200,34,0,'a036edd3-e715-4482-969b-8e08db560fbf',635,0,'Widget Two',null,0,610,null,0,0,1,1,93,0,0);

Insert into 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 (96,0,'none',0,200,35,0,'8df5ef4f-6e0b-4272-a25d-77db89a39ad1',540,0,'Widget Three',null,0,630,null,0,0,2,0,93,0,0);

Insert into 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 (98,0,'accordion',0,200,33,0,'fd251873-18ca-4393-a199-1c9785eef67e',405,0,'Widget One',null,0,625,null,0,0,0,0,97,0,0);

Insert into 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 (99,0,'rightSideNorth',0,200,34,0,'5105bc15-525d-4abc-9aef-08ce96ad7958',435,0,'Widget Two',null,0,610,null,0,0,1,1,97,0,0);

Insert into 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 (100,0,'rightSideCenter',0,200,35,0,'ed05cb4a-f303-4937-a7b1-57d8f7039af8',540,0,'Widget Three',null,0,630,null,0,0,2,0,97,200,0);

Insert into 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 (102,0,'none',0,100,33,0,'f9486636-8ba0-4513-935a-e4c2e13c0680',405,0,'Widget One',null,0,625,null,0,0,0,0,101,200,200);

Insert into 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 (103,0,'none',0,200,34,0,'1497203c-dc5c-4787-9c16-220e87317b67',635,0,'Widget Two',null,0,610,null,0,0,1,1,101,250,250);

Insert into 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 (104,0,'none',0,222,35,0,'d2d98c3b-e49c-4d9f-839a-328eb5adc53a',540,0,'Widget Three',null,0,630,null,0,0,2,0,101,300,300);

Insert into 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 (106,0,'none',0,0,37,0,'db515893-87a6-48b4-a681-e9948d9e36cd',300,0,'Widget Five',null,0,464,null,0,0,0,0,105,0,0);

Insert into 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 (107,0,'none',0,0,36,0,'92dabc2e-614e-4f66-a0ab-ce07f4c64eca',400,0,'Widget Four',null,1,464,null,0,0,1,0,105,0,0);

Insert into 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 (108,0,'none',0,0,35,0,'5dfd2846-9d66-407d-ba82-82a74343e44f',540,0,'Widget Three',null,2,630,null,0,0,2,0,105,0,0);

Insert into 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 (110,0,'none',0,200,49,0,'e8c1d2b0-d6f6-4f76-934d-3f18a91dde43',405,0,'Widget One',null,0,625,null,0,0,0,0,109,0,0);

Insert into 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 (111,0,'none',0,200,50,0,'e1abe72c-05d8-4bdd-b3db-b5c9afec079a',635,0,'Widget Two',null,0,610,null,0,0,1,1,109,0,0);

Insert into 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 (112,0,'none',0,200,51,0,'f112df3f-b7be-47b2-b96e-7ddf61fbdc2a',540,0,'Widget Three',null,0,630,null,0,0,2,0,109,0,0);

Insert into 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 (114,0,'accordion',0,200,49,0,'8f8a9445-9d29-4aa3-87d3-b4781ed1d77a',405,0,'Widget One',null,0,625,null,0,0,0,0,113,0,0);

Insert into 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 (115,0,'rightSideNorth',0,200,50,0,'8c49ea4e-2aa2-4413-b0f0-56c4368f343f',435,0,'Widget Two',null,0,610,null,0,0,1,1,113,0,0);

Insert into 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 (116,0,'rightSideCenter',0,200,51,0,'6427ef28-1c87-4f21-b22d-c6acdc44e8bf',540,0,'Widget Three',null,0,630,null,0,0,2,0,113,200,0);

Insert into 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 (118,0,'none',0,100,49,0,'899e5cf1-5d17-45ab-b53c-ee0df13b8fc5',405,0,'Widget One',null,0,625,null,0,0,0,0,117,200,200);

Insert into 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 (119,0,'none',0,200,50,0,'0d9fbbe3-8359-4f50-bff7-109ed1fb5bf4',635,0,'Widget Two',null,0,610,null,0,0,1,1,117,250,250);

Insert into 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 (120,0,'none',0,222,51,0,'62cf9cc7-0830-4310-af28-f46736d55ddc',540,0,'Widget Three',null,0,630,null,0,0,2,0,117,300,300);

Insert into 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 (122,0,'none',0,0,53,0,'79a2c179-0135-4f2f-bcab-14b2b9a54354',300,0,'Widget Five',null,0,464,null,0,0,0,0,121,0,0);

Insert into 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 (123,0,'none',0,0,52,0,'f44e5a15-45b9-48cd-91e5-fcbe8298566d',400,0,'Widget Four',null,1,464,null,0,0,1,0,121,0,0);

Insert into 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 (124,0,'none',0,0,51,0,'30cc5423-b62a-4ba1-ac2e-910942154449',540,0,'Widget Three',null,2,630,null,0,0,2,0,121,0,0);

Insert into 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 (126,0,'none',0,200,65,0,'16bc920c-8846-4d1b-8a29-d10e7a119585',405,0,'Widget One',null,0,625,null,0,0,0,0,125,0,0);

Insert into 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 (127,0,'none',0,200,66,0,'56cbadd2-4958-4369-9bb2-79ea2f25d852',635,0,'Widget Two',null,0,610,null,0,0,1,1,125,0,0);

Insert into 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 (128,0,'none',0,200,67,0,'18bf70a6-78d9-4500-97f1-002694412399',540,0,'Widget Three',null,0,630,null,0,0,2,0,125,0,0);

Insert into 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 (130,0,'accordion',0,200,65,0,'5add92c1-cf98-4313-9369-bd3b953af1ad',405,0,'Widget One',null,0,625,null,0,0,0,0,129,0,0);

Insert into 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 (131,0,'rightSideNorth',0,200,66,0,'bea43b7d-11c6-464e-bb18-4000bfe25f51',435,0,'Widget Two',null,0,610,null,0,0,1,1,129,0,0);

Insert into 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 (132,0,'rightSideCenter',0,200,67,0,'23a187eb-bcd8-44e7-a9d7-586ab4a3ea9b',540,0,'Widget Three',null,0,630,null,0,0,2,0,129,200,0);

Insert into 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 (134,0,'none',0,100,65,0,'9b2bd193-6229-43cc-952e-8bb252bd5f03',405,0,'Widget One',null,0,625,null,0,0,0,0,133,200,200);

Insert into 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 (135,0,'none',0,200,66,0,'3ef4de5c-841e-4ba0-9e01-91142f13fa18',635,0,'Widget Two',null,0,610,null,0,0,1,1,133,250,250);

Insert into 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 (136,0,'none',0,222,67,0,'74210d81-b067-41b7-81d5-7c6af6356ae8',540,0,'Widget Three',null,0,630,null,0,0,2,0,133,300,300);

Insert into 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 (138,0,'none',0,0,69,0,'c754dbce-7897-4f2d-85a9-302682bdd4d9',300,0,'Widget Five',null,0,464,null,0,0,0,0,137,0,0);

Insert into 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 (139,0,'none',0,0,68,0,'e4fa5fe9-0b8d-4e1b-9378-0a708d94e2e1',400,0,'Widget Four',null,1,464,null,0,0,1,0,137,0,0);

Insert into 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 (140,0,'none',0,0,67,0,'39cfa23c-cc91-4532-9ed6-61d8743bb6f7',540,0,'Widget Three',null,2,630,null,0,0,2,0,137,0,0);

Insert into OWF_GROUP_PEOPLE (PERSON_ID,GROUP_ID) values (2,4);

Insert into OWF_GROUP_PEOPLE (PERSON_ID,GROUP_ID) values (1,4);

Insert into OWF_GROUP_PEOPLE (PERSON_ID,GROUP_ID) values (2,5);

Insert into OWF_GROUP_PEOPLE (PERSON_ID,GROUP_ID) values (1,5);

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (144,0,'foovalue','test path entry 0',2,'foo.bar.0');

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (145,0,'foovalue','test path entry 1',2,'foo.bar.1');

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (146,0,'foovalue','test path entry 0',3,'foo.bar.0');

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (147,0,'foovalue','test path entry 1',3,'foo.bar.1');

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (148,0,'foovalue','test path entry 0',1,'foo.bar.0');

Insert into PREFERENCE (ID,VERSION,VALUE,PATH,USER_ID,NAMESPACE) values (149,0,'foovalue','test path entry 1',1,'foo.bar.1');

Insert into REQUESTMAP (ID,VERSION,URL,CONFIG_ATTRIBUTE) values (141,0,'/login/**','IS_AUTHENTICATED_ANONYMOUSLY');

Insert into REQUESTMAP (ID,VERSION,URL,CONFIG_ATTRIBUTE) values (142,0,'/denied.jsp','IS_AUTHENTICATED_ANONYMOUSLY');

Insert into REQUESTMAP (ID,VERSION,URL,CONFIG_ATTRIBUTE) values (143,0,'/**','IS_AUTHENTICATED_FULLY');

Insert into ROLE (ID,VERSION,AUTHORITY,DESCRIPTION) values (26,2,'ROLE_USER','User Role');

Insert into ROLE (ID,VERSION,AUTHORITY,DESCRIPTION) values (27,1,'ROLE_ADMIN','Admin Role');

Insert into ROLE_PEOPLE (ROLE_ID,PERSON_ID) values (26,2);

Insert into ROLE_PEOPLE (ROLE_ID,PERSON_ID) values (26,3);

Insert into ROLE_PEOPLE (ROLE_ID,PERSON_ID) values (26,28);

Insert into ROLE_PEOPLE (ROLE_ID,PERSON_ID) values (27,1);

COMMIT;

INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', '', SYSTIMESTAMP, 'Custom SQL', 'EXECUTED', 'changelog_3.7.0.groovy', '3.7.0-2', '2.0.1', '3:ad73bb1bb782dbc77d4b92775b08af26', 1);

-- Changeset changelog_3.8.0.groovy::3.8.0-7::owf::(Checksum: 3:4163f7334862d1ae47e0a16041fcc73b)
-- Updating Admin Widget Icons and Names
UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

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

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

UPDATE dashboard SET name = 'Accordion Window Manager' WHERE name like 'Accordion Window Manager (%)';

UPDATE dashboard SET name = 'Desktop Window Manager' WHERE name like 'Desktop Window Manager (%)';

UPDATE dashboard SET name = 'Portal Window Manager' WHERE name like 'Portal Window Manager (%)';

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

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

DELETE FROM role;

DELETE FROM requestmap;

DELETE FROM preference;

DELETE FROM owf_group_people;

DELETE FROM dashboard_widget_state;

DELETE FROM person_widget_definition;

DELETE FROM domain_mapping;

DELETE FROM dashboard;

DELETE FROM owf_group;

DELETE FROM widget_definition;

DELETE FROM person;

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

-- Changeset changelog_4.0.0.groovy::4.0.0-7::owf::(Checksum: 3:56bfda152e35ce325993eb717dc97ddd)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO person (email_show, enabled, id, user_real_name, username, version) VALUES (0, 1, 28, 'DEFAULT_USER', 'DEFAULT_USER', 0);

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

-- Changeset changelog_4.0.0.groovy::4.0.0-10::owf::(Checksum: 3:dce1159e015f1d6314c981dfe85f5dca)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

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

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

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (30, 1, 1, 0, 1, 7);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (31, 1, 2, 0, 1, 8);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (32, 1, 3, 0, 1, 9);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (33, 1, 4, 0, 1, 10);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (34, 1, 5, 0, 1, 11);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (35, 1, 6, 0, 1, 12);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (36, 1, 7, 0, 1, 13);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (37, 1, 8, 0, 1, 14);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (38, 1, 9, 0, 1, 15);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (39, 1, 10, 0, 1, 16);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (40, 1, 11, 0, 1, 17);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (41, 1, 12, 0, 1, 18);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (42, 1, 13, 0, 1, 19);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (43, 1, 14, 0, 1, 20);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (44, 1, 15, 0, 1, 21);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (45, 2, 0, 0, 1, 6);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (46, 2, 1, 0, 1, 7);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (47, 2, 2, 0, 1, 8);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (48, 2, 3, 0, 1, 9);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (49, 2, 4, 0, 1, 10);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (50, 2, 5, 0, 1, 11);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (51, 2, 6, 0, 1, 12);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (52, 2, 7, 0, 1, 13);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (53, 2, 8, 0, 1, 14);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (54, 2, 9, 0, 1, 15);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (55, 2, 10, 0, 1, 16);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (56, 2, 11, 0, 1, 17);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (57, 2, 12, 0, 1, 18);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (58, 2, 13, 0, 1, 19);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (59, 2, 14, 0, 1, 20);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (60, 2, 15, 0, 1, 21);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (61, 3, 0, 0, 1, 6);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (62, 3, 1, 0, 1, 7);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (63, 3, 2, 0, 1, 8);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (64, 3, 3, 0, 1, 9);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (65, 3, 4, 0, 1, 10);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (66, 3, 5, 0, 1, 11);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (67, 3, 6, 0, 1, 12);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (68, 3, 7, 0, 1, 13);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (69, 3, 8, 0, 1, 14);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (70, 3, 9, 0, 1, 15);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (71, 3, 10, 0, 1, 16);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (72, 3, 11, 0, 1, 17);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (73, 3, 12, 0, 1, 18);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (74, 3, 13, 0, 1, 19);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (75, 3, 14, 0, 1, 20);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (76, 3, 15, 0, 1, 21);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (77, 28, 0, 0, 1, 6);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (78, 28, 1, 0, 1, 7);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (79, 28, 2, 0, 1, 8);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (80, 28, 3, 0, 1, 9);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (81, 28, 4, 0, 1, 10);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (82, 28, 5, 0, 1, 11);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (83, 28, 6, 0, 1, 12);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (84, 28, 7, 0, 1, 13);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (85, 28, 8, 0, 1, 14);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (86, 28, 9, 0, 1, 15);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (87, 28, 10, 0, 1, 16);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (88, 28, 11, 0, 1, 17);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (89, 28, 12, 0, 1, 18);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (90, 28, 13, 0, 1, 19);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (91, 28, 14, 0, 1, 20);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (92, 28, 15, 0, 1, 21);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (174, 1, 1, 0, 1, 151);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (177, 1, 1, 0, 1, 154);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (179, 1, 1, 0, 1, 156);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (181, 1, 1, 0, 1, 158);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (183, 1, 1, 0, 1, 160);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (185, 1, 1, 0, 1, 163);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (187, 1, 1, 0, 1, 166);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (189, 1, 1, 0, 1, 170);

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

-- Changeset changelog_4.0.0.groovy::4.0.0-16::owf::(Checksum: 3:1e537730add70b5d19a30e0139a6927f)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

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

-- Changeset changelog_4.0.0.groovy::4.0.0-19::owf::(Checksum: 3:ae622822d6d601221be17fbc04cbacf9)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

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

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

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

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

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

INSERT INTO owf_group_people (group_id, person_id) VALUES (4, 1);

INSERT INTO owf_group_people (group_id, person_id) VALUES (5, 2);

INSERT INTO owf_group_people (group_id, person_id) VALUES (5, 1);

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

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

INSERT INTO role (authority, description, id, version) VALUES ('ROLE_ADMIN', 'Admin Role', 27, 1);

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

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

INSERT INTO role_people (person_id, role_id) VALUES (3, 26);

INSERT INTO role_people (person_id, role_id) VALUES (28, 26);

INSERT INTO role_people (person_id, role_id) VALUES (1, 27);

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

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

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

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

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

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

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

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

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

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (7, 'widget_definition', 23, 'owns', 4, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (6, 'widget_definition', 24, 'owns', 5, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (7, 'widget_definition', 25, 'owns', 5, 'group', 0);

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

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

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

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

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 155, -1, 152, 154, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 157, -1, 152, 156, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 159, -1, 152, 158, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 162, -1, 152, 160, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 164, -1, 152, 163, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 165, -1, 152, 161, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 169, -1, 152, 166, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 168, -1, 152, 167, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 172, -1, 152, 170, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 173, -1, 152, 171, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 176, -1, 152, 174, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 178, -1, 152, 177, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 180, -1, 152, 179, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 182, -1, 152, 181, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 184, -1, 152, 183, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 186, -1, 152, 185, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 188, -1, 152, 187, 'personWidgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 190, -1, 152, 189, 'personWidgetDefinition', 0, 1);

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

-- Changeset changelog_4.0.0.groovy::4.0.0-45::owf::(Checksum: 3:4653ac19f692092c9152eaeb1230513d)
-- set sequence to higher number that is not used
DROP SEQUENCE hibernate_sequence;

CREATE SEQUENCE hibernate_sequence START WITH 300;

INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'set sequence to higher number that is not used', SYSTIMESTAMP, 'Drop Sequence, Create Sequence', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-45', '2.0.1', '3:4653ac19f692092c9152eaeb1230513d', 18);

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

INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', '', SYSTIMESTAMP, 'Update Data', 'EXECUTED', 'changelog_4.0.0.groovy', '4.0.0-46', '2.0.1', '3:5c1705f46d07fab68b80494982589ffe', 19);

-- 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'
        );

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'
        );

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

-- Changeset changelog_4.0.0.groovy::4.0.0-55::owf::(Checksum: 3:43c93ef1d7f35a92c470fdcfde7b2d6f)
-- Updating Admin Widget Icons and Names
UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

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

-- 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 owf_group SET automatic = 1, name = 'OWF Users' WHERE name='All Users' AND automatic=0;

UPDATE owf_group SET automatic = 1, name = 'OWF Administrators' WHERE name='OWF Admins' AND automatic=0;

INSERT INTO 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.', SYSTIMESTAMP, 'Update Data (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-5', '2.0.1', '3:a3a4f6fe76ad042b42e27bdf7b09d277', 22);

-- 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;

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

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

UPDATE widget_definition SET widget_url = 'examples/walkthrough/widgets/Preferences.gsp' WHERE widget_url='examples/walkthrough/widgets/Preferences.html';

UPDATE widget_definition SET widget_url = 'examples/walkthrough/widgets/WidgetChrome.gsp' WHERE widget_url='examples/walkthrough/widgets/WidgetChrome.html';

UPDATE widget_definition SET widget_url = 'examples/walkthrough/widgets/WidgetLog.gsp' WHERE widget_url='examples/walkthrough/widgets/WidgetLog.html';

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

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

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

-- 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 dashboard SET user_id = NULL WHERE id=150;

UPDATE dashboard_widget_state SET person_widget_definition_id = NULL WHERE dashboard_id=150;

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (150, 'dashboard', 192, 'owns', 191, 'group', 0);

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

-- Changeset changelog_5.0.0.groovy::5.0.0-15::owf::(Checksum: 3:c2d3b3571a76497a6de5db75f34c46d4)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

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

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

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (191, 1, 16, 0, 1, 173);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (192, 2, 16, 0, 1, 173);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (193, 3, 16, 0, 1, 173);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (194, 28, 17, 0, 1, 172);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (195, 1, 17, 0, 1, 172);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (196, 2, 17, 0, 1, 172);

INSERT INTO person_widget_definition (id, person_id, pwd_position, version, visible, widget_definition_id) VALUES (197, 3, 17, 0, 1, 172);

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

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

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (171, 'widget_definition', 201, 'owns', 191, 'group', 0);

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

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

INSERT INTO widget_definition_widget_types (widget_definition_id, widget_type_id) VALUES (173, 1);

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

-- Changeset changelog_6.0.0.groovy::6.0.0-19::owf::(Checksum: 3:060ed35d30b4c3f5fc656d920dd53aac)
-- insert new sample data
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

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

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

INSERT INTO widget_definition_widget_types (widget_definition_id, widget_type_id) VALUES (179, 1);

INSERT INTO widget_definition_widget_types (widget_definition_id, widget_type_id) VALUES (180, 1);

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

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

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

-- Changeset changelog_6.0.0.groovy::6.0.0-25::owf::(Checksum: 3:4653ac19f692092c9152eaeb1230513d)
-- set sequence to higher number that is not used
DROP SEQUENCE hibernate_sequence;

CREATE SEQUENCE hibernate_sequence START WITH 300;

INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'set sequence to higher number that is not used', SYSTIMESTAMP, 'Drop Sequence, Create Sequence', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-25', '2.0.1', '3:4653ac19f692092c9152eaeb1230513d', 34);

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

INSERT INTO intent (action, id, version) VALUES ('View', 302, 0);

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

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

INSERT INTO intent_data_type (data_type, id, version) VALUES ('HTML', 304, 0);

INSERT INTO intent_data_types (intent_data_type_id, intent_id) VALUES (303, 301);

INSERT INTO intent_data_types (intent_data_type_id, intent_id) VALUES (304, 302);

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

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

INSERT INTO widget_def_intent (id, intent_id, receive, send, version, widget_definition_id) VALUES (306, 302, 0, 1, 0, 178);

INSERT INTO widget_def_intent (id, intent_id, receive, send, version, widget_definition_id) VALUES (307, 302, 1, 0, 0, 179);

INSERT INTO widget_def_intent (id, intent_id, receive, send, version, widget_definition_id) VALUES (308, 301, 1, 0, 0, 180);

INSERT INTO widget_def_intent_data_types (intent_data_type_id, widget_definition_intent_id) VALUES (303, 305);

INSERT INTO widget_def_intent_data_types (intent_data_type_id, widget_definition_intent_id) VALUES (304, 306);

INSERT INTO widget_def_intent_data_types (intent_data_type_id, widget_definition_intent_id) VALUES (304, 307);

INSERT INTO widget_def_intent_data_types (intent_data_type_id, widget_definition_intent_id) VALUES (303, 308);

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

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

INSERT INTO tags (id, name, version) VALUES (310, 'html', 0);

INSERT INTO tags (id, name, version) VALUES (311, 'document_viewer', 0);

INSERT INTO tags (id, name, version) VALUES (312, 'stock_chart', 0);

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

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

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 314, -1, 310, 179, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 315, -1, 311, 179, 'widgetDefinition', 0, 1);

INSERT INTO tag_links (editable, id, pos, tag_id, tag_ref, type, version, visible) VALUES (1, 316, -1, 312, 180, 'widgetDefinition', 0, 1);

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

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

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (179, 'widget_definition', 318, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (180, 'widget_definition', 319, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (16, 'widget_definition', 320, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (17, 'widget_definition', 321, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (20, 'widget_definition', 322, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (151, 'widget_definition', 323, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (154, 'widget_definition', 324, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (156, 'widget_definition', 325, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (158, 'widget_definition', 326, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (160, 'widget_definition', 327, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (163, 'widget_definition', 328, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (166, 'widget_definition', 329, 'owns', 191, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (170, 'widget_definition', 330, 'owns', 191, 'group', 0);

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

-- 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')));

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'));

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'));

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');

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

-- Changeset changelog_6.0.0.groovy::6.0.0-48::owf::(Checksum: 3:15ea47b3dd0935f3ac7819d817972075)
-- Add Intents, Sample, and Administration Dashboards
INSERT INTO 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);

INSERT INTO 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);

INSERT INTO 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);

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

-- 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 domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (320, 'dashboard', 331, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (321, 'dashboard', 332, 'owns', 192, 'group', 0);

INSERT INTO domain_mapping (dest_id, dest_type, id, relationship_type, src_id, src_type, version) VALUES (322, 'dashboard', 333, 'owns', 191, 'group', 0);

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

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

UPDATE intent_data_type SET data_type = 'application/vnd.owf.sample.price' WHERE data_type='Prices';

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

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

DELETE FROM domain_mapping  WHERE dest_id=150 AND dest_type='dashboard';

DELETE FROM dashboard  WHERE id in (101, 117, 133, 150);

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

-- Changeset changelog_6.0.0.groovy::6.0.0-62::owf::(Checksum: 3:352d26af765a6a04e28e09f3d9433e49)
-- set sequence to higher number that is not used
DROP SEQUENCE hibernate_sequence;

CREATE SEQUENCE hibernate_sequence START WITH 334;

INSERT INTO DATABASECHANGELOG (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'set sequence to higher number that is not used', SYSTIMESTAMP, 'Drop Sequence, Create Sequence', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-62', '2.0.1', '3:352d26af765a6a04e28e09f3d9433e49', 46);

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

INSERT INTO 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', SYSTIMESTAMP, 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-63', '2.0.1', '3:ac6187e64b8b8b98e880da00e25f9f77', 47);

-- 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 tag_links  WHERE editable = 0;

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

-- Changeset changelog_6.0.0.groovy::6.0.0-65::owf::(Checksum: 3:3259ab7fe31a394213ba7151b8a53e52)
-- Updating Sample Widget images
UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

UPDATE 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';

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

-- Release Database Lock
