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

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

-- Lock Database
-- Changeset changelog_3.7.0.groovy::3.7.0-2::owf::(Checksum: 3:63a5d652f5fd400ce1edecf1aaa61940)
--
        -- PostgreSQL database dump
        --

        -- Dumped from database version 9.0.4
        -- Dumped by pg_dump version 9.0.4
        -- Started on 2011-09-08 16:42:17

        SET statement_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = off;

SET check_function_bodies = false;

SET client_min_messages = warning;

SET escape_string_warning = off;

SET search_path = public, pg_catalog;

--
        -- TOC entry 1906 (class 0 OID 0)
        -- Dependencies: 1551
        -- Name: hibernate_sequence; Type: SEQUENCE SET; Schema: public; Owner: postgres
        --

        SELECT pg_catalog.setval('hibernate_sequence', 149, true);

--
        -- TOC entry 1895 (class 0 OID 37833)
        -- Dependencies: 1542
        -- Data for Name: person; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO person VALUES (1, 0, true, 'Test Admin 1', 'testAdmin1', '2011-09-08 16:40:04.338', false, 'testAdmin1@ozone3.test', NULL, 'Test Administrator 1');

INSERT INTO person VALUES (2, 0, true, 'Test User 1', 'testUser1', '2011-09-03 16:40:05.056', false, 'testUser1@ozone3.test', NULL, 'Test User 1');

INSERT INTO person VALUES (3, 0, true, 'Test User 2', 'testUser2', '2011-09-03 16:40:05.072', false, 'testUser2@ozone3.test', NULL, 'Test User 2');

INSERT INTO person VALUES (28, 0, true, 'DEFAULT_USER', 'DEFAULT_USER', '2011-09-08 16:40:05.478', false, NULL, NULL, NULL);

--
        -- TOC entry 1889 (class 0 OID 37790)
        -- Dependencies: 1536 1895
        -- Data for Name: dashboard; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO dashboard VALUES (93, 0, false, 0, false, '7c52efe0-f611-4fa5-9fa6-c92af30bc940', 0, 'tabbed', 'Tabbed Window Manager (testAdmin1)', 1);

INSERT INTO dashboard VALUES (97, 0, false, 1, false, '88df5ca6-0b9d-4f66-bff3-7268cb07e678', 0, 'accordion', 'Accordion Window Manager (testAdmin1)', 1);

INSERT INTO dashboard VALUES (101, 0, true, 2, false, '917b4cd0-ecbd-410b-afd9-42d150c26426', 0, 'desktop', 'Desktop Window Manager (testAdmin1)', 1);

INSERT INTO dashboard VALUES (105, 0, false, 3, false, 'd6137f02-53c4-4640-8ce8-17cd295b7c72', 3, 'portal', 'Portal Window Manager (testAdmin1)', 1);

INSERT INTO dashboard VALUES (109, 0, false, 0, false, '818384c0-4ed7-4166-9b69-c4e4ca508f73', 0, 'tabbed', 'Tabbed Window Manager (testUser1)', 2);

INSERT INTO dashboard VALUES (113, 0, false, 1, false, 'ae28b8d6-c291-4a47-9562-8083af1ad2d1', 0, 'accordion', 'Accordion Window Manager (testUser1)', 2);

INSERT INTO dashboard VALUES (117, 0, true, 2, false, '6f1d0c3e-821a-41ca-ac1b-ed72186bbb53', 0, 'desktop', 'Desktop Window Manager (testUser1)', 2);

INSERT INTO dashboard VALUES (121, 0, false, 3, false, 'b7530ee0-c9a3-4d46-876e-57c73486cc97', 3, 'portal', 'Portal Window Manager (testUser1)', 2);

INSERT INTO dashboard VALUES (125, 0, false, 0, false, '857aab70-fae5-4806-95f4-a37c4e5ee7d2', 0, 'tabbed', 'Tabbed Window Manager (testUser2)', 3);

INSERT INTO dashboard VALUES (129, 0, false, 1, false, 'e2b2c905-e617-4d24-829f-b8f429a49e9f', 0, 'accordion', 'Accordion Window Manager (testUser2)', 3);

INSERT INTO dashboard VALUES (133, 0, true, 2, false, '985dee86-acf5-4f35-abc1-362ca60b39b8', 0, 'desktop', 'Desktop Window Manager (testUser2)', 3);

INSERT INTO dashboard VALUES (137, 0, false, 3, false, '82d3c62b-9afb-4db0-bc02-b743522719c9', 3, 'portal', 'Portal Window Manager (testUser2)', 3);

--
        -- TOC entry 1903 (class 0 OID 37897)
        -- Dependencies: 1550
        -- Data for Name: widget_definition; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO widget_definition VALUES (6, 0, true, 'images/blue/icons/widgetIcons/widgetA.gif', 'images/blue/icons/widgetContainer/widgetAsm.gif', false, 615, '1.0', 565, 'examples/fake-widgets/widget-a.html', 'ea5435cf-4021-4f2a-ba69-dde451d12551', 'Widget A');

INSERT INTO widget_definition VALUES (7, 0, true, 'images/blue/icons/widgetIcons/widgetB.gif', 'images/blue/icons/widgetContainer/widgetBsm.gif', false, 565, '1.0', 635, 'examples/fake-widgets/widget-b.html', 'fb5435cf-4021-4f2a-ba69-dde451d12551', 'Widget B');

INSERT INTO widget_definition VALUES (8, 0, true, 'images/blue/icons/widgetIcons/widgetC.gif', 'images/blue/icons/widgetContainer/widgetCsm.gif', false, 980, '1.0', 740, 'examples/fake-widgets/widget-c.html', '0c5435cf-4021-4f2a-ba69-dde451d12551', 'Widget C');

INSERT INTO widget_definition VALUES (9, 0, true, 'images/blue/icons/widgetIcons/widgetD.gif', 'images/blue/icons/widgetContainer/widgetDsm.gif', false, 630, '1.0', 525, 'examples/fake-widgets/widget-d.html', '1d5435cf-4021-4f2a-ba69-dde451d12551', 'Widget D');

INSERT INTO widget_definition VALUES (10, 0, true, 'images/blue/icons/widgetIcons/widget1.gif', 'images/blue/icons/widgetContainer/widget1sm.gif', false, 625, '1.0', 405, 'examples/fake-widgets/widget-one.html', 'd6543ccf-4021-4f2a-ba69-dde451d12551', 'Widget One');

INSERT INTO widget_definition VALUES (11, 0, true, 'images/blue/icons/widgetIcons/widget2.gif', 'images/blue/icons/widgetContainer/widget2sm.gif', false, 610, '1.0', 635, 'examples/fake-widgets/widget-two.html', 'e65431cf-4021-4f2a-ba69-dde451d12551', 'Widget Two');

INSERT INTO widget_definition VALUES (12, 0, true, 'images/blue/icons/widgetIcons/widget3.gif', 'images/blue/icons/widgetContainer/widget3sm.gif', false, 630, '1.0', 540, 'examples/fake-widgets/widget-three.html', 'a65432cf-4021-4f2a-ba69-dde451d12551', 'Widget Three');

INSERT INTO widget_definition VALUES (13, 0, true, 'images/blue/icons/widgetIcons/widget4.gif', 'images/blue/icons/widgetContainer/widget4sm.gif', false, 675, '1.0', 350, 'examples/fake-widgets/widget-four.html', 'b65434cf-4021-4f2a-ba69-dde451d12551', 'Widget Four');

INSERT INTO widget_definition VALUES (14, 0, true, 'images/blue/icons/widgetIcons/widget5.gif', 'images/blue/icons/widgetContainer/widget5sm.gif', false, 615, '1.0', 630, 'examples/fake-widgets/widget-five.html', 'c65435cf-4021-4f2a-ba69-dde451d12551', 'Widget Five');

INSERT INTO widget_definition VALUES (15, 0, true, 'images/blue/icons/widgetIcons/nearlyEmpty.gif', 'images/blue/icons/widgetContainer/nearlyEmptysm.gif', false, 540, '1.0', 440, 'examples/walkthrough/widgets/NearlyEmptyWidget.html', 'bc5435cf-4021-4f2a-ba69-dde451d12551', 'Nearly Empty');

INSERT INTO widget_definition VALUES (16, 0, true, 'images/blue/icons/widgetIcons/channelShouter.gif', 'images/blue/icons/widgetContainer/channelShoutersm.gif', false, 295, '1.0', 250, 'examples/walkthrough/widgets/ChannelShouter.html', 'eb5435cf-4021-4f2a-ba69-dde451d12551', 'Channel Shouter');

INSERT INTO widget_definition VALUES (17, 0, true, 'images/blue/icons/widgetIcons/channelListener.gif', 'images/blue/icons/widgetContainer/channelListenersm.gif', false, 540, '1.0', 440, 'examples/walkthrough/widgets/ChannelListener.html', 'ec5435cf-4021-4f2a-ba69-dde451d12551', 'Channel Listener');

INSERT INTO widget_definition VALUES (18, 0, true, 'examples/walkthrough/images/chromeWiget_black_icon.png ', 'examples/walkthrough/images/chromeWiget_blue_icon.png ', false, 540, '1.0', 440, 'examples/walkthrough/widgets/WidgetChrome.html', 'e8687289-f595-4b6d-9911-c714b483509d', 'Widget Chrome');

INSERT INTO widget_definition VALUES (19, 0, true, 'examples/walkthrough/images/event_monitor_black_icon.png', 'examples/walkthrough/images/event_monitor_blue_icon.png', false, 500, '1.0', 600, 'examples/walkthrough/widgets/EventMonitor.html', '9d2e5f85-e199-4c6a-be31-4c6954206687', 'Event Monitor Widget');

INSERT INTO widget_definition VALUES (20, 0, true, 'examples/walkthrough/images/log_icon.png', 'examples/walkthrough/images/log_icon_blue.png', false, 540, '1.0', 440, 'examples/walkthrough/widgets/WidgetLog.html', '4854fbd4-395c-442b-95c6-8b60702fd2b4', 'Widget Log');

INSERT INTO widget_definition VALUES (21, 0, true, 'examples/walkthrough/images/testpref_black_icon.png', 'examples/walkthrough/images/testpref_blue_icon.png', false, 450, '1.0', 300, 'examples/walkthrough/widgets/Preferences.html', '920b7cc1-dd37-46ac-8457-afda62613e56', 'Preferences Widget');

--
        -- TOC entry 1896 (class 0 OID 37843)
        -- Dependencies: 1543 1895 1903
        -- Data for Name: person_widget_definition; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO person_widget_definition VALUES (29, 0, 1, true, 0, 6);

INSERT INTO person_widget_definition VALUES (30, 0, 1, true, 1, 7);

INSERT INTO person_widget_definition VALUES (31, 0, 1, true, 2, 8);

INSERT INTO person_widget_definition VALUES (32, 0, 1, true, 3, 9);

INSERT INTO person_widget_definition VALUES (33, 0, 1, true, 4, 10);

INSERT INTO person_widget_definition VALUES (34, 0, 1, true, 5, 11);

INSERT INTO person_widget_definition VALUES (35, 0, 1, true, 6, 12);

INSERT INTO person_widget_definition VALUES (36, 0, 1, true, 7, 13);

INSERT INTO person_widget_definition VALUES (37, 0, 1, true, 8, 14);

INSERT INTO person_widget_definition VALUES (38, 0, 1, true, 9, 15);

INSERT INTO person_widget_definition VALUES (39, 0, 1, true, 10, 16);

INSERT INTO person_widget_definition VALUES (40, 0, 1, true, 11, 17);

INSERT INTO person_widget_definition VALUES (41, 0, 1, true, 12, 18);

INSERT INTO person_widget_definition VALUES (42, 0, 1, true, 13, 19);

INSERT INTO person_widget_definition VALUES (43, 0, 1, true, 14, 20);

INSERT INTO person_widget_definition VALUES (44, 0, 1, true, 15, 21);

INSERT INTO person_widget_definition VALUES (45, 0, 2, true, 0, 6);

INSERT INTO person_widget_definition VALUES (46, 0, 2, true, 1, 7);

INSERT INTO person_widget_definition VALUES (47, 0, 2, true, 2, 8);

INSERT INTO person_widget_definition VALUES (48, 0, 2, true, 3, 9);

INSERT INTO person_widget_definition VALUES (49, 0, 2, true, 4, 10);

INSERT INTO person_widget_definition VALUES (50, 0, 2, true, 5, 11);

INSERT INTO person_widget_definition VALUES (51, 0, 2, true, 6, 12);

INSERT INTO person_widget_definition VALUES (52, 0, 2, true, 7, 13);

INSERT INTO person_widget_definition VALUES (53, 0, 2, true, 8, 14);

INSERT INTO person_widget_definition VALUES (54, 0, 2, true, 9, 15);

INSERT INTO person_widget_definition VALUES (55, 0, 2, true, 10, 16);

INSERT INTO person_widget_definition VALUES (56, 0, 2, true, 11, 17);

INSERT INTO person_widget_definition VALUES (57, 0, 2, true, 12, 18);

INSERT INTO person_widget_definition VALUES (58, 0, 2, true, 13, 19);

INSERT INTO person_widget_definition VALUES (59, 0, 2, true, 14, 20);

INSERT INTO person_widget_definition VALUES (60, 0, 2, true, 15, 21);

INSERT INTO person_widget_definition VALUES (61, 0, 3, true, 0, 6);

INSERT INTO person_widget_definition VALUES (62, 0, 3, true, 1, 7);

INSERT INTO person_widget_definition VALUES (63, 0, 3, true, 2, 8);

INSERT INTO person_widget_definition VALUES (64, 0, 3, true, 3, 9);

INSERT INTO person_widget_definition VALUES (65, 0, 3, true, 4, 10);

INSERT INTO person_widget_definition VALUES (66, 0, 3, true, 5, 11);

INSERT INTO person_widget_definition VALUES (67, 0, 3, true, 6, 12);

INSERT INTO person_widget_definition VALUES (68, 0, 3, true, 7, 13);

INSERT INTO person_widget_definition VALUES (69, 0, 3, true, 8, 14);

INSERT INTO person_widget_definition VALUES (70, 0, 3, true, 9, 15);

INSERT INTO person_widget_definition VALUES (71, 0, 3, true, 10, 16);

INSERT INTO person_widget_definition VALUES (72, 0, 3, true, 11, 17);

INSERT INTO person_widget_definition VALUES (73, 0, 3, true, 12, 18);

INSERT INTO person_widget_definition VALUES (74, 0, 3, true, 13, 19);

INSERT INTO person_widget_definition VALUES (75, 0, 3, true, 14, 20);

INSERT INTO person_widget_definition VALUES (76, 0, 3, true, 15, 21);

INSERT INTO person_widget_definition VALUES (77, 0, 28, true, 0, 6);

INSERT INTO person_widget_definition VALUES (78, 0, 28, true, 1, 7);

INSERT INTO person_widget_definition VALUES (79, 0, 28, true, 2, 8);

INSERT INTO person_widget_definition VALUES (80, 0, 28, true, 3, 9);

INSERT INTO person_widget_definition VALUES (81, 0, 28, true, 4, 10);

INSERT INTO person_widget_definition VALUES (82, 0, 28, true, 5, 11);

INSERT INTO person_widget_definition VALUES (83, 0, 28, true, 6, 12);

INSERT INTO person_widget_definition VALUES (84, 0, 28, true, 7, 13);

INSERT INTO person_widget_definition VALUES (85, 0, 28, true, 8, 14);

INSERT INTO person_widget_definition VALUES (86, 0, 28, true, 9, 15);

INSERT INTO person_widget_definition VALUES (87, 0, 28, true, 10, 16);

INSERT INTO person_widget_definition VALUES (88, 0, 28, true, 11, 17);

INSERT INTO person_widget_definition VALUES (89, 0, 28, true, 12, 18);

INSERT INTO person_widget_definition VALUES (90, 0, 28, true, 13, 19);

INSERT INTO person_widget_definition VALUES (91, 0, 28, true, 14, 20);

INSERT INTO person_widget_definition VALUES (92, 0, 28, true, 15, 21);

--
        -- TOC entry 1890 (class 0 OID 37797)
        -- Dependencies: 1537 1896 1889
        -- Data for Name: dashboard_widget_state; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO dashboard_widget_state VALUES (94, 0, 'none', false, 200, 33, false, 'c9f0f455-22b3-4633-a55c-9cd604d9dd66', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 93, 0, 0);

INSERT INTO dashboard_widget_state VALUES (95, 0, 'none', false, 200, 34, false, 'a0bd5fa1-99a2-49fd-8bf4-57085cd1c69c', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 93, 0, 0);

INSERT INTO dashboard_widget_state VALUES (96, 0, 'none', false, 200, 35, false, 'bc01fe86-3045-412c-bed3-fc2ef1d9c48d', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 93, 0, 0);

INSERT INTO dashboard_widget_state VALUES (98, 0, 'accordion', false, 200, 33, false, '04c97f93-2d0f-4b31-a5d5-66723f154974', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 97, 0, 0);

INSERT INTO dashboard_widget_state VALUES (99, 0, 'rightSideNorth', false, 200, 34, false, '789aac73-1f27-441f-8727-7b8e25ccf801', 435, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 97, 0, 0);

INSERT INTO dashboard_widget_state VALUES (100, 0, 'rightSideCenter', false, 200, 35, false, '52d20928-51ea-49cf-9c16-21d7d2a9e04d', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 97, 200, 0);

INSERT INTO dashboard_widget_state VALUES (102, 0, 'none', false, 100, 33, false, '83958046-e409-4d56-a03b-09b5a3ec8399', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 101, 200, 200);

INSERT INTO dashboard_widget_state VALUES (103, 0, 'none', false, 200, 34, false, '7ea1fdd4-8b0d-47c6-a62a-326a6df9cc0c', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 101, 250, 250);

INSERT INTO dashboard_widget_state VALUES (104, 0, 'none', false, 222, 35, false, 'ce8ee71f-ce79-4845-afbf-18a0a875a56e', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 101, 300, 300);

INSERT INTO dashboard_widget_state VALUES (106, 0, 'none', false, 0, 37, false, '65ad55e6-565b-4652-b870-c57c3eacc4b6', 300, false, 'Widget Five', NULL, 0, 464, NULL, false, false, 0, false, 105, 0, 0);

INSERT INTO dashboard_widget_state VALUES (107, 0, 'none', false, 0, 36, false, '19082645-4f59-48ac-800a-5570f46dd853', 400, false, 'Widget Four', NULL, 1, 464, NULL, false, false, 1, false, 105, 0, 0);

INSERT INTO dashboard_widget_state VALUES (108, 0, 'none', false, 0, 35, false, '73ba89a0-eab8-4621-b7c8-8da895f17262', 540, false, 'Widget Three', NULL, 2, 630, NULL, false, false, 2, false, 105, 0, 0);

INSERT INTO dashboard_widget_state VALUES (110, 0, 'none', false, 200, 49, false, 'e319e587-7211-4b82-86df-29d182a8ef96', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 109, 0, 0);

INSERT INTO dashboard_widget_state VALUES (111, 0, 'none', false, 200, 50, false, 'f4f13ad6-1d02-451b-ac98-34e8649b84f9', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 109, 0, 0);

INSERT INTO dashboard_widget_state VALUES (112, 0, 'none', false, 200, 51, false, 'da89fb98-b49c-4733-81f8-e9a14e321a83', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 109, 0, 0);

INSERT INTO dashboard_widget_state VALUES (114, 0, 'accordion', false, 200, 49, false, '4da7958c-49ae-450d-aaf1-d3de8cce0722', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 113, 0, 0);

INSERT INTO dashboard_widget_state VALUES (115, 0, 'rightSideNorth', false, 200, 50, false, 'a015bf17-4daa-47c8-9cc9-6036cd629b40', 435, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 113, 0, 0);

INSERT INTO dashboard_widget_state VALUES (116, 0, 'rightSideCenter', false, 200, 51, false, '09f5abd7-31e0-4ac7-bc54-ffe2e69f7911', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 113, 200, 0);

INSERT INTO dashboard_widget_state VALUES (118, 0, 'none', false, 100, 49, false, '5ea660a2-936b-4210-83db-f9d6381dc818', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 117, 200, 200);

INSERT INTO dashboard_widget_state VALUES (119, 0, 'none', false, 200, 50, false, '20b21563-e731-4688-8146-758852361d00', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 117, 250, 250);

INSERT INTO dashboard_widget_state VALUES (120, 0, 'none', false, 222, 51, false, '919d671a-33e1-4a34-830b-ee3f1c8cc4fb', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 117, 300, 300);

INSERT INTO dashboard_widget_state VALUES (122, 0, 'none', false, 0, 53, false, 'dc7cf38d-edf4-4b11-83e4-a1f2dba8ab60', 300, false, 'Widget Five', NULL, 0, 464, NULL, false, false, 0, false, 121, 0, 0);

INSERT INTO dashboard_widget_state VALUES (123, 0, 'none', false, 0, 52, false, '1a220b1e-e330-4c12-8f73-8556662c3769', 400, false, 'Widget Four', NULL, 1, 464, NULL, false, false, 1, false, 121, 0, 0);

INSERT INTO dashboard_widget_state VALUES (124, 0, 'none', false, 0, 51, false, 'fa3ad641-bec1-41a8-9681-4d8696b6ca05', 540, false, 'Widget Three', NULL, 2, 630, NULL, false, false, 2, false, 121, 0, 0);

INSERT INTO dashboard_widget_state VALUES (126, 0, 'none', false, 200, 65, false, 'c95b24db-c6a9-4082-9222-324af66874d2', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 125, 0, 0);

INSERT INTO dashboard_widget_state VALUES (127, 0, 'none', false, 200, 66, false, 'd0ecabd8-9e1f-4415-9619-7bbb930bb17e', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 125, 0, 0);

INSERT INTO dashboard_widget_state VALUES (128, 0, 'none', false, 200, 67, false, '1c1bb64c-776c-462e-be8a-3b0bbc7e56e5', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 125, 0, 0);

INSERT INTO dashboard_widget_state VALUES (130, 0, 'accordion', false, 200, 65, false, '16afbf81-874e-467d-9b6e-04bfd76c9db7', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 129, 0, 0);

INSERT INTO dashboard_widget_state VALUES (131, 0, 'rightSideNorth', false, 200, 66, false, 'adde2971-01d4-4e38-87e1-1937a96a94b3', 435, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 129, 0, 0);

INSERT INTO dashboard_widget_state VALUES (132, 0, 'rightSideCenter', false, 200, 67, false, '9c7b3695-7d8a-4bd1-a868-76f4e820de17', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 129, 200, 0);

INSERT INTO dashboard_widget_state VALUES (134, 0, 'none', false, 100, 65, false, '23643536-c7db-4560-ad76-fff7b9f3c48c', 405, false, 'Widget One', NULL, 0, 625, NULL, false, false, 0, false, 133, 200, 200);

INSERT INTO dashboard_widget_state VALUES (135, 0, 'none', false, 200, 66, false, '249beede-47b1-4c95-bf6c-97de96efab7b', 635, false, 'Widget Two', NULL, 0, 610, NULL, false, false, 1, true, 133, 250, 250);

INSERT INTO dashboard_widget_state VALUES (136, 0, 'none', false, 222, 67, false, 'ba3e8b1e-684d-4044-acdc-2c4d5e649e5c', 540, false, 'Widget Three', NULL, 0, 630, NULL, false, false, 2, false, 133, 300, 300);

INSERT INTO dashboard_widget_state VALUES (138, 0, 'none', false, 0, 69, false, 'f24323bf-0b86-4fc6-a327-ed496e58d623', 300, false, 'Widget Five', NULL, 0, 464, NULL, false, false, 0, false, 137, 0, 0);

INSERT INTO dashboard_widget_state VALUES (139, 0, 'none', false, 0, 68, false, 'b125783c-b3ae-418e-bea9-d8f119660c10', 400, false, 'Widget Four', NULL, 1, 464, NULL, false, false, 1, false, 137, 0, 0);

INSERT INTO dashboard_widget_state VALUES (140, 0, 'none', false, 0, 67, false, '62f562d0-8443-42bd-95c2-818a4189ee03', 540, false, 'Widget Three', NULL, 2, 630, NULL, false, false, 2, false, 137, 0, 0);

--
        -- TOC entry 1891 (class 0 OID 37807)
        -- Dependencies: 1538
        -- Data for Name: domain_mapping; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO domain_mapping VALUES (22, 0, 4, 'group', 'owns', 6, 'widget_definition');

INSERT INTO domain_mapping VALUES (23, 0, 4, 'group', 'owns', 7, 'widget_definition');

INSERT INTO domain_mapping VALUES (24, 0, 5, 'group', 'owns', 6, 'widget_definition');

INSERT INTO domain_mapping VALUES (25, 0, 5, 'group', 'owns', 7, 'widget_definition');

--
        -- TOC entry 1892 (class 0 OID 37815)
        -- Dependencies: 1539 1890
        -- Data for Name: eventing_connections; Type: TABLE DATA; Schema: public; Owner: postgres
        --



        --
        -- TOC entry 1893 (class 0 OID 37820)
        -- Dependencies: 1540
        -- Data for Name: owf_group; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO owf_group VALUES (4, 0, 'active', 'testgroup1@group1.com', 'TestGroup1', 'TestGroup1', false);

INSERT INTO owf_group VALUES (5, 0, 'active', 'testgroup2@group2.com', 'TestGroup2', 'TestGroup2', false);

--
        -- TOC entry 1894 (class 0 OID 37828)
        -- Dependencies: 1541 1895 1893
        -- Data for Name: owf_group_people; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO owf_group_people VALUES (4, 2);

INSERT INTO owf_group_people VALUES (4, 1);

INSERT INTO owf_group_people VALUES (5, 2);

INSERT INTO owf_group_people VALUES (5, 1);

--
        -- TOC entry 1897 (class 0 OID 37850)
        -- Dependencies: 1544 1895
        -- Data for Name: preference; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO preference VALUES (144, 0, 'foovalue', 'test path entry 0', 2, 'foo.bar.0');

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

INSERT INTO preference VALUES (146, 0, 'foovalue', 'test path entry 0', 3, 'foo.bar.0');

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

INSERT INTO preference VALUES (148, 0, 'foovalue', 'test path entry 0', 1, 'foo.bar.0');

INSERT INTO preference VALUES (149, 0, 'foovalue', 'test path entry 1', 1, 'foo.bar.1');

--
        -- TOC entry 1898 (class 0 OID 37860)
        -- Dependencies: 1545
        -- Data for Name: requestmap; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO requestmap VALUES (141, 0, '/login/**', 'IS_AUTHENTICATED_ANONYMOUSLY');

INSERT INTO requestmap VALUES (142, 0, '/denied.jsp', 'IS_AUTHENTICATED_ANONYMOUSLY');

INSERT INTO requestmap VALUES (143, 0, '/**', 'IS_AUTHENTICATED_FULLY');

--
        -- TOC entry 1899 (class 0 OID 37870)
        -- Dependencies: 1546
        -- Data for Name: role; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO role VALUES (26, 2, 'ROLE_USER', 'User Role');

INSERT INTO role VALUES (27, 1, 'ROLE_ADMIN', 'Admin Role');

--
        -- TOC entry 1900 (class 0 OID 37880)
        -- Dependencies: 1547 1899 1895
        -- Data for Name: role_people; Type: TABLE DATA; Schema: public; Owner: postgres
        --

        INSERT INTO role_people VALUES (26, 2);

INSERT INTO role_people VALUES (26, 3);

INSERT INTO role_people VALUES (26, 28);

INSERT INTO role_people VALUES (27, 1);

--
        -- TOC entry 1902 (class 0 OID 37890)
        -- Dependencies: 1549
        -- Data for Name: tags; Type: TABLE DATA; Schema: public; Owner: postgres
        --



        --
        -- TOC entry 1901 (class 0 OID 37885)
        -- Dependencies: 1548 1902
        -- Data for Name: tag_links; Type: TABLE DATA; Schema: public; Owner: postgres
        --



        -- Completed on 2011-09-08 16:42:18

        --
        -- PostgreSQL database dump complete
        --;

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', '', NOW(), 'Custom SQL', 'EXECUTED', 'changelog_3.7.0.groovy', '3.7.0-2', '2.0.1', '3:63a5d652f5fd400ce1edecf1aaa61940', 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 = FALSE 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 = FALSE 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 = FALSE 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 = FALSE 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', NOW(), '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', NOW(), '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', NOW(), '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', FALSE, TRUE, 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', FALSE, TRUE, 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', FALSE, TRUE, 3, 'Test User 2', 'testUser2', 0);

INSERT INTO person (email_show, enabled, id, user_real_name, username, version) VALUES (FALSE, TRUE, 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', NOW(), '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 (FALSE, 'Widget A', 565, 6, 'themes/common/images/blue/icons/widgetIcons/widgetA.gif', 'themes/common/images/blue/icons/widgetContainer/widgetAsm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget B', 635, 7, 'themes/common/images/blue/icons/widgetIcons/widgetB.gif', 'themes/common/images/blue/icons/widgetContainer/widgetBsm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget C', 740, 8, 'themes/common/images/blue/icons/widgetIcons/widgetC.gif', 'themes/common/images/blue/icons/widgetContainer/widgetCsm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget D', 525, 9, 'themes/common/images/blue/icons/widgetIcons/widgetD.gif', 'themes/common/images/blue/icons/widgetContainer/widgetDsm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget One', 405, 10, 'themes/common/images/blue/icons/widgetIcons/widget1.gif', 'themes/common/images/blue/icons/widgetContainer/widget1sm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget Two', 635, 11, 'themes/common/images/blue/icons/widgetIcons/widget2.gif', 'themes/common/images/blue/icons/widgetContainer/widget2sm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget Three', 540, 12, 'themes/common/images/blue/icons/widgetIcons/widget3.gif', 'themes/common/images/blue/icons/widgetContainer/widget3sm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget Four', 350, 13, 'themes/common/images/blue/icons/widgetIcons/widget4.gif', 'themes/common/images/blue/icons/widgetContainer/widget4sm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget Five', 630, 14, 'themes/common/images/blue/icons/widgetIcons/widget5.gif', 'themes/common/images/blue/icons/widgetContainer/widget5sm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Nearly Empty', 440, 15, 'themes/common/images/blue/icons/widgetIcons/nearlyEmpty.gif', 'themes/common/images/blue/icons/widgetContainer/nearlyEmptysm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Channel Shouter', 250, 16, 'themes/common/images/blue/icons/widgetIcons/channelShouter.gif', 'themes/common/images/blue/icons/widgetContainer/channelShoutersm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Channel Listener', 440, 17, 'themes/common/images/blue/icons/widgetIcons/channelListener.gif', 'themes/common/images/blue/icons/widgetContainer/channelListenersm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Widget Chrome', 440, 18, 'examples/walkthrough/images/chromeWiget_black_icon.png', 'examples/walkthrough/images/chromeWiget_blue_icon.png', FALSE, 0, TRUE, '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 (FALSE, 'Event Monitor Widget', 600, 19, 'examples/walkthrough/images/event_monitor_black_icon.png', 'examples/walkthrough/images/event_monitor_blue_icon.png', FALSE, 0, TRUE, '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 (FALSE, 'Widget Log', 440, 20, 'examples/walkthrough/images/log_icon.png', 'examples/walkthrough/images/log_icon_blue.png', FALSE, 0, TRUE, '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 (FALSE, 'Preferences Widget', 300, 21, 'examples/walkthrough/images/testpref_black_icon.png', 'examples/walkthrough/images/testpref_blue_icon.png', FALSE, 0, TRUE, '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 (FALSE, 'Users', 440, 151, 'themes/common/images/admin/64x64_blue_user.png', 'themes/common/images/admin/64x64_blue_user.png', FALSE, 0, TRUE, '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 (FALSE, 'User Editor', 440, 154, 'themes/common/images/admin/64x64_blue_user.png', 'themes/common/images/admin/64x64_blue_user.png', FALSE, 0, FALSE, '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 (FALSE, 'Widgets', 440, 156, 'themes/common/images/admin/64x64_blue_widget.png', 'themes/common/images/admin/64x64_blue_widget.png', FALSE, 0, TRUE, '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 (FALSE, 'Widget Editor', 493, 158, 'themes/common/images/admin/64x64_blue_widget.png', 'themes/common/images/admin/64x64_blue_widget.png', FALSE, 0, FALSE, '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 (FALSE, 'Groups', 440, 160, 'themes/common/images/admin/64x64_blue_group.png', 'themes/common/images/admin/64x64_blue_group.png', FALSE, 0, TRUE, '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 (FALSE, 'Group Editor', 440, 163, 'themes/common/images/admin/64x64_blue_group.png', 'themes/common/images/admin/64x64_blue_group.png', FALSE, 0, FALSE, '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 (FALSE, 'Group Dashboards', 440, 166, 'themes/common/images/admin/64x64_blue_dashboard.png', 'themes/common/images/admin/64x64_blue_dashboard.png', FALSE, 0, TRUE, '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 (FALSE, 'Dashboard Editor', 440, 170, 'themes/common/images/admin/64x64_blue_dashboard.png', 'themes/common/images/admin/64x64_blue_dashboard.png', FALSE, 0, FALSE, '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', NOW(), '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, TRUE, 6);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'insert new sample data', NOW(), '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 (FALSE, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '917b4cd0-ecbd-410b-afd9-42d150c26426', 101, TRUE, '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 (TRUE, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '6f1d0c3e-821a-41ca-ac1b-ed72186bbb53', 117, TRUE, '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 (FALSE, 0, NULL, NULL, 1, NULL, NULL, NULL, NULL, '985dee86-acf5-4f35-abc1-362ca60b39b8', 133, TRUE, '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 (FALSE, 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, FALSE, 'desktop', 'Administration', 1, 0);

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'insert new sample data', NOW(), '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 (FALSE, NULL, FALSE, FALSE, 0, 101, 405, 102, FALSE, FALSE, 'Widget One', 33, FALSE, '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 (TRUE, NULL, FALSE, FALSE, 0, 101, 635, 103, FALSE, FALSE, 'Widget Two', 34, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 101, 540, 104, FALSE, FALSE, 'Widget Three', 35, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 117, 405, 118, FALSE, FALSE, 'Widget One', 49, FALSE, '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 (TRUE, NULL, FALSE, FALSE, 0, 117, 635, 119, FALSE, FALSE, 'Widget Two', 50, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 117, 540, 120, FALSE, FALSE, 'Widget Three', 51, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 133, 405, 134, FALSE, FALSE, 'Widget One', 65, FALSE, '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 (TRUE, NULL, FALSE, FALSE, 0, 133, 635, 135, FALSE, FALSE, 'Widget Two', 66, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 133, 540, 136, FALSE, FALSE, 'Widget Three', 67, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 150, 382, 221, FALSE, FALSE, 'Users', 174, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 150, 382, 222, FALSE, FALSE, 'Groups', 183, FALSE, '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 (FALSE, NULL, FALSE, FALSE, 0, 150, 382, 223, FALSE, FALSE, 'Group Dashboards', 187, FALSE, '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 (TRUE, NULL, FALSE, FALSE, 0, 150, 382, 224, FALSE, FALSE, 'Widgets', 179, FALSE, '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', NOW(), '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 (FALSE, 'TestGroup1', 'testgroup1@group1.com', 4, 'TestGroup1', 'active', 0);

INSERT INTO owf_group (automatic, description, email, id, name, status, version) VALUES (FALSE, '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', NOW(), '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', NOW(), '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', NOW(), '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', NOW(), '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', NOW(), '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', NOW(), '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', NOW(), '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 (TRUE, 153, -1, 152, 151, 'widgetDefinition', 0, TRUE);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'insert new sample data', NOW(), '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 CASCADE;

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', NOW(), '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', '', NOW(), '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', NOW(), '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 = TRUE 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', NOW(), '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:9fe287989b0eecb53ec72dc98e0c2737)
-- Rename All Users and OWF Admins groups to OWF Users and OWF Administrators, then set them to automatic.
UPDATE owf_group SET automatic = TRUE, name = 'OWF Users' WHERE name='All Users' AND automatic=false;

UPDATE owf_group SET automatic = TRUE, name = 'OWF Administrators' WHERE name='OWF Admins' AND automatic=false;

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.', NOW(), 'Update Data (x2)', 'EXECUTED', 'changelog_5.0.0.groovy', '5.0.0-5', '2.0.1', '3:9fe287989b0eecb53ec72dc98e0c2737', 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', NOW(), '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', NOW(), '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 (TRUE, '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', NOW(), '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', NOW(), '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 (FALSE, 'Color Server', 300, 172, 'themes/common/images/blue/icons/widgetIcons/channelShouter.gif', 'themes/common/images/blue/icons/widgetContainer/channelShoutersm.gif', FALSE, 0, TRUE, '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 (FALSE, 'Color Client', 300, 173, 'themes/common/images/blue/icons/widgetIcons/channelListener.gif', 'themes/common/images/blue/icons/widgetContainer/channelListenersm.gif', FALSE, 0, TRUE, '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', NOW(), '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, TRUE, 173);

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

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

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

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

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

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

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

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'insert new sample data', NOW(), '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', NOW(), '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', NOW(), '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 (FALSE, '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', FALSE, 'org.owfgoss.owf.examples.NYSE', 0, TRUE, '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 (FALSE, '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', FALSE, 'org.owfgoss.owf.examples.HTMLViewer', 0, TRUE, '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 (FALSE, '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', FALSE, 'org.owfgoss.owf.examples.StockChart', 0, TRUE, '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', NOW(), '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', NOW(), '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 (TRUE, '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', NOW(), '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 CASCADE;

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', NOW(), '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', NOW(), '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', NOW(), '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, FALSE, TRUE, 0, 178);

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

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

INSERT INTO widget_def_intent (id, intent_id, receive, send, version, widget_definition_id) VALUES (308, 301, TRUE, FALSE, 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', NOW(), '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', NOW(), '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 (TRUE, 313, -1, 309, 178, 'widgetDefinition', 0, TRUE);

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

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

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

INSERT INTO databasechangelog (AUTHOR, COMMENTS, DATEEXECUTED, DESCRIPTION, EXECTYPE, FILENAME, ID, LIQUIBASE, MD5SUM, ORDEREXECUTED) VALUES ('owf', 'insert new sample data', NOW(), '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', NOW(), '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', NOW(), '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 (FALSE, 0, 0, '{}', 'This dashboard uses the sample Intents Widgets to demonstrate the widget intents workflow.', '3f59855b-d93e-dc03-c6ba-f4c33ea0177f', 320, TRUE, '{"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 (FALSE, 0, 0, '{}', '', 'c62ce95c-d16d-4ffe-afae-c46fa64a689b', 321, FALSE, '{"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 (FALSE, 0, 0, '{}', 'This dashboard provides the widgets needed to administer dashboards, widgets, groups, and users in OWF.', '54949b5d-f0ee-4347-811e-2522a1bf96fe', 322, FALSE, '{"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', NOW(), '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', NOW(), '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.', NOW(), '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', NOW(), '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 CASCADE;

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', NOW(), '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:09cb669039ed4fb2199da1cc29068b70)
-- upgrade any pwds that were pending approval to use the disabled column
update person_widget_definition pwd
            set disabled = true
            from tag_links taglinks
            where pwd.id = taglinks.tag_ref and taglinks.type = 'personWidgetDefinition' and taglinks.editable = false;

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', NOW(), 'Custom SQL', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-63', '2.0.1', '3:09cb669039ed4fb2199da1cc29068b70', 47);

-- Changeset changelog_6.0.0.groovy::6.0.0-64::owf::(Checksum: 3:84741a4f5e5ac5ee47758341f3068451)
-- delete any taglinks which were 'pending approval' (have editable false)
DELETE FROM tag_links  WHERE editable = false;

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)', NOW(), 'Delete Data', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-64', '2.0.1', '3:84741a4f5e5ac5ee47758341f3068451', 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', NOW(), 'Update Data (x12)', 'EXECUTED', 'changelog_6.0.0.groovy', '6.0.0-65', '2.0.1', '3:3259ab7fe31a394213ba7151b8a53e52', 49);

-- Release Database Lock
