[Aplaws-commit] r2314 - in trunk/ccm-portalworkspace: sql sql/ccm-portalworkspace/upgrade sql/ccm-portalworkspace/upgrade/default sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2 sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2 sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3 sql/ccm-portalworkspace/upgrade/oracle-se sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2 sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1 sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2 sql/ccm-portalworkspace/upgrade/postgres sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1 sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2 src

[<pb...@fe...>]

Author: pboy
Date: 2012-05-16 08:28:42 +0000 (Wed, 16 May 2012)
New Revision: 2314

Added:
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/add-workspace-pages.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2/add-navigation-directory-portlet.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3/add-flash-portlet.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/content-directory.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/fix-perm-context.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-1.4.1-1.4.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.0-6.3.1.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.1-6.3.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.1-6.5.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.2-6.5.3.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/add-workspace-pages.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-owner.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-themes.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/freeform-use-clob.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-1.4.1-1.4.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.0-6.3.1.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.1-6.3.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.1-6.5.2.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.2-6.5.3.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-owner.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-themes.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/
   trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/freeform-use-clob.sql
Removed:
   trunk/ccm-portalworkspace/sql/ccm-ldn-portal-2/
Modified:
   trunk/ccm-portalworkspace/src/ccm-portalworkspace.upgrade
Log:
Fixed update scripts.

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/add-workspace-pages.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/add-workspace-pages.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/add-workspace-pages.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,92 @@
+
+create table workspace_page_layouts (
+    layout_id INTEGER not null
+        constraint worksp_pag_layo_lay_id_p_paxph
+          primary key,
+    title VARCHAR(200) not null,
+    description VARCHAR(4000),
+    format VARCHAR(50) not null
+        constraint worksp_pag_layo_format_u_ff8p6
+	  unique
+);
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (nextval('acs_object_id_seq'), '1 Column', 'One column', '100%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (nextval('acs_object_id_seq'), '2 Column', 'Two columns, equal size', '50%,50%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (nextval('acs_object_id_seq'), '3 Column', 'Three columns, equal size', '30%,40%,30%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (nextval('acs_object_id_seq'), '4 Column', 'Four columns, equal size', '25%,25%,25%,25%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (nextval('acs_object_id_seq'), '5 Column', 'Five columns, equal size', '20%,20%,20%,20%,20%');
+
+
+alter table workspaces add default_layout_id INTEGER;
+alter table workspaces alter party_id set not null;
+-- XXX '100%' is only relevant for APLAWS...
+update workspaces set default_layout_id = (select layout_id from workspace_page_layouts where format = '100%');
+alter table workspaces alter default_layout_id set not null;
+alter table workspaces add 
+    constraint workspac_defau_layo_id_f_xvb7g foreign key (default_layout_id)
+      references workspace_page_layouts(layout_id);
+
+create table workspace_pages (
+    page_id INTEGER not null
+        constraint workspac_pages_page_id_p_iugi0
+          primary key,
+    workspace_id INTEGER,
+    layout_id INTEGER not null
+);
+alter table workspace_pages add 
+    constraint workspa_pag_workspa_id_f_4xkkr foreign key (workspace_id)
+      references workspaces(workspace_id);
+alter table workspace_pages add 
+    constraint workspac_page_layou_id_f_9uq1r foreign key (layout_id)
+      references workspace_page_layouts(layout_id);
+alter table workspace_pages add 
+    constraint workspac_pages_page_id_f_jhka1 foreign key (page_id)
+      references portals(portal_id);
+
+insert into workspace_pages (page_id, workspace_id, layout_id)
+  select portal_id, workspace_id,
+    (select layout_id from workspace_page_layouts where format = '100%')
+   from workspace_portal_map;
+
+update acs_objects 
+   set object_type = 'com.arsdigita.london.portal.WorkspacePage',
+       default_domain_class = 'com.arsdigita.london.portal.WorkspacePage'
+ where object_id in (select page_id from workspace_pages);
+
+insert into application_types (
+   application_type_id, 
+   object_type, 
+   title, 
+   description, 
+   workspace_application_p, 
+   has_full_page_view_p, 
+   has_embedded_view_p, 
+   singleton_p) 
+ values (
+   nextval('acs_object_id_seq'), 
+   'com.arsdigita.london.portal.WorkspacePage', 
+   'Portal Workspace Page', 
+   'Pages for the portal workspaces',
+   null, 
+   null,
+   null,
+   null);
+
+update applications
+   set sort_key = (select tab_number from workspace_portal_map where application_id = portal_id)
+  where application_id in (select page_id from workspace_pages);
+
+update applications
+   set application_type_id = (select application_type_id from application_types where object_type = 'com.arsdigita.london.portal.WorkspacePage')
+  where application_id in (select page_id from workspace_pages);
+
+drop table workspace_portal_map;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/1.4.1-1.4.2/add-workspace-pages.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2/add-navigation-directory-portlet.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2/add-navigation-directory-portlet.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.1-6.5.2/add-navigation-directory-portlet.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,31 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+create table portlet_navigation_directory (
+    portlet_id INTEGER not null
+        constraint port_navig_dire_por_id_p_n4lfs
+          primary key,
+    navigation_id INTEGER not null,
+    depth INTEGER not null
+);
+
+alter table portlet_navigation_directory add 
+    constraint port_navi_dir_navig_id_f_rq14k foreign key (navigation_id)
+      references nav_app(application_id);
+      
+alter table portlet_navigation_directory add 
+    constraint port_navig_dire_por_id_f_vsyyc foreign key (portlet_id)
+      references portlets(portlet_id);    
\ No newline at end of file

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3/add-flash-portlet.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3/add-flash-portlet.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/6.5.2-6.5.3/add-flash-portlet.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,38 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+create table portlet_flash (
+    portlet_id INTEGER not null
+        constraint portle_flas_portlet_id_p_d00yp
+          primary key,
+        -- referential constraint for portlet_id deferred due to circular dependencies
+    background_colour VARCHAR(7),
+    detect_key VARCHAR(32),
+    swf_file VARCHAR(2048) not null,
+    height VARCHAR(8) not null,
+    parameters VARCHAR(1024),
+    quality VARCHAR(8),
+    redirect_url VARCHAR(2048),
+    variables VARCHAR(1024),
+    version VARCHAR(8) not null,
+    width VARCHAR(8) not null,
+    xi_redirect_url VARCHAR(2048)
+);
+
+alter table portlet_flash add 
+    constraint portle_flas_portlet_id_f_bhmp4 foreign key (portlet_id)
+      references portlets(portlet_id);
+   
\ No newline at end of file

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/content-directory.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/content-directory.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/content-directory.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,28 @@
+
+create table portlet_content_directory (
+    portlet_id INTEGER not null
+        constraint port_con_direc_port_id_p_f5k1_
+          primary key,
+        -- referential constraint for portlet_id deferred due to circular dependencies
+    depth INTEGER not null,
+    layout VARCHAR(10) not null,
+    root_id INTEGER
+        -- referential constraint for root_id deferred due to circular dependencies
+);
+
+alter table portlet_content_directory add 
+    constraint port_con_direc_port_id_f_9kbkn foreign key (portlet_id)
+      references portlets(portlet_id) on delete cascade;
+alter table portlet_content_directory add 
+    constraint port_con_direct_roo_id_f_fvrr7 foreign key (root_id)
+      references cat_categories(category_id);
+
+insert into portlet_content_directory 
+  (portlet_id, root_id, layout, depth)
+  select object_id, (select category_id
+      from cat_categories
+     where name = 'Navigation'), 
+     'grid', 2
+    from acs_objects 
+   where object_type = 'com.arsdigita.london.portal.portlet.ContentDirectoryPortlet';
+


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/content-directory.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/fix-perm-context.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/fix-perm-context.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/fix-perm-context.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,3 @@
+insert into object_context_map (object_id, context_id)
+  select portal_id, workspace_id 
+    from workspace_portal_map;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/default/fix-perm-context.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/add-workspace-pages.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/add-workspace-pages.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/add-workspace-pages.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,91 @@
+
+create table workspace_page_layouts (
+    layout_id INTEGER not null
+        constraint worksp_pag_layo_lay_id_p_paxph
+          primary key,
+    title VARCHAR(200) not null,
+    description VARCHAR(4000),
+    format VARCHAR(50) not null
+        constraint worksp_pag_layo_format_u_ff8p6
+	  unique
+);
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (acs_object_id_seq.nextval, '1 Column', 'One column', '100%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (acs_object_id_seq.nextval, '2 Column', 'Two columns, equal size', '50%,50%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (acs_object_id_seq.nextval, '3 Column', 'Three columns, equal size', '30%,40%,30%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (acs_object_id_seq.nextval, '4 Column', 'Four columns, equal size', '25%,25%,25%,25%');
+
+insert into workspace_page_layouts (layout_id, title, description, format)
+  values (acs_object_id_seq.nextval, '5 Column', 'Five columns, equal size', '20%,20%,20%,20%,20%');
+
+alter table workspaces add default_layout_id INTEGER;
+alter table workspaces modify party_id not null;
+-- XXX '100%' is only relevant for APLAWS...
+update workspaces set default_layout_id = (select layout_id from workspace_page_layouts where format = '100%');
+alter table workspaces modify default_layout_id not null;
+alter table workspaces add 
+    constraint workspac_defau_layo_id_f_xvb7g foreign key (default_layout_id)
+      references workspace_page_layouts(layout_id);
+
+create table workspace_pages (
+    page_id INTEGER not null
+        constraint workspac_pages_page_id_p_iugi0
+          primary key,
+    workspace_id INTEGER,
+    layout_id INTEGER not null
+);
+alter table workspace_pages add 
+    constraint workspa_pag_workspa_id_f_4xkkr foreign key (workspace_id)
+      references workspaces(workspace_id);
+alter table workspace_pages add 
+    constraint workspac_page_layou_id_f_9uq1r foreign key (layout_id)
+      references workspace_page_layouts(layout_id);
+alter table workspace_pages add 
+    constraint workspac_pages_page_id_f_jhka1 foreign key (page_id)
+      references portals(portal_id);
+
+insert into workspace_pages (page_id, workspace_id, layout_id)
+  select portal_id, workspace_id,
+    (select layout_id from workspace_page_layouts where format = '100%')
+   from workspace_portal_map;
+
+update acs_objects 
+   set object_type = 'com.arsdigita.london.portal.WorkspacePage',
+       default_domain_class = 'com.arsdigita.london.portal.WorkspacePage'
+ where object_id in (select page_id from workspace_pages);
+
+insert into application_types (
+   application_type_id, 
+   object_type, 
+   title, 
+   description, 
+   workspace_application_p, 
+   has_full_page_view_p, 
+   has_embedded_view_p, 
+   singleton_p) 
+ values (
+   acs_object_id_seq.nextval, 
+   'com.arsdigita.london.portal.WorkspacePage', 
+   'Portal Workspace Page', 
+   'Pages for the portal workspaces',
+   null, 
+   null,
+   null,
+   null);
+
+update applications
+   set sort_key = (select tab_number from workspace_portal_map where application_id = portal_id)
+  where application_id in (select page_id from workspace_pages);
+
+update applications
+   set application_type_id = (select application_type_id from application_types where object_type = 'com.arsdigita.london.portal.WorkspacePage')
+  where application_id in (select page_id from workspace_pages);
+
+drop table workspace_portal_map;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/1.4.1-1.4.2/add-workspace-pages.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-owner.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-owner.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-owner.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,7 @@
+
+alter table workspaces add owner_id INTEGER;
+
+alter table workspaces add
+    constraint workspaces_owner_id_f_tpdju foreign key (owner_id)
+      references users(user_id);
+      


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-owner.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-themes.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-themes.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-themes.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,48 @@
+create table workspace_themes (
+    theme_id INTEGER not null
+        constraint workspac_theme_them_id_p_6_22y
+          primary key,
+        -- referential constraint for theme_id deferred due to circular dependencies
+    theme_name VARCHAR(4000),
+    theme_desc VARCHAR(4000),
+    ctx_bar_color VARCHAR(100),
+    ctx_bar_text_color VARCHAR(100),
+    active_tab_color VARCHAR(100),
+    active_tab_text_color VARCHAR(100),
+    inactive_tab_color VARCHAR(100),
+    inactive_tab_text_color VARCHAR(100),
+    top_rule VARCHAR(100),
+    bottom_rule VARCHAR(100),
+    portlet_head VARCHAR(100),
+    portlet_icon VARCHAR(100),
+    portlet_border_color VARCHAR(100),
+    portlet_border_style VARCHAR(100),
+    portlet_header_text_color VARCHAR(100),
+    page_bg_color VARCHAR(100),
+    page_bg_image VARCHAR(100),
+    narrow_bg_color VARCHAR(100),
+    body_text_color VARCHAR(100)
+);
+
+create table themeapplications (
+    theme_app_id INTEGER not null
+        constraint themeapplic_the_app_id_p_ix9jr
+          primary key
+        -- referential constraint for theme_app_id deferred due to circular dependencies
+);
+
+alter table workspaces add theme_id INTEGER;
+
+alter table workspaces add
+    constraint workspaces_theme_id_f_tpdju foreign key (theme_id)
+      references workspace_themes(theme_id);
+
+alter table workspace_themes add
+    constraint workspac_theme_them_id_f_ix7ez foreign key (theme_id)
+      references acs_objects(object_id);
+
+alter table themeapplications add
+    constraint themeapplic_the_app_id_f_ejek5 foreign key (theme_app_id)
+      references applications(application_id);
+
+


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace-themes.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,18 @@
+
+create table workspace_workspace_map (
+    referenced_workspace_id INTEGER not null,
+        -- referential constraint for referenced_workspace_id deferred due to circular dependencies
+    referencing_workspace_id INTEGER not null,
+        -- referential constraint for referencing_workspace_id deferred due to circular dependencies
+    constraint work_wor_map_ref_wor_i_p_bidbq
+      primary key(referencing_workspace_id, referenced_workspace_id)
+);
+
+alter table workspace_workspace_map add
+    constraint work_wor_map_ref_wor_i_f_md9_z foreign key (referenced_workspace_id)
+      references workspaces(workspace_id);
+alter table workspace_workspace_map add
+    constraint work_wor_map_ref_wor_i_f_nyhzz foreign key (referencing_workspace_id)
+      references workspaces(workspace_id);
+
+create index wrkspc_wrkspc_mp_rfrn_wrks_idx on workspace_workspace_map(referenced_workspace_id);


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/freeform-use-clob.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/freeform-use-clob.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/freeform-use-clob.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,9 @@
+alter table portlet_freeform_html add (
+   content_clob   CLOB
+);
+
+update portlet_freeform_html set content_clob = content;
+
+alter table portlet_freeform_html drop column content;
+
+


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se/6.3.1-6.3.2/freeform-use-clob.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-1.4.1-1.4.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-1.4.1-1.4.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-1.4.1-1.4.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1 @@
+@@ oracle-se/1.4.1-1.4.2/add-workspace-pages.sql


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-1.4.1-1.4.2.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.0-6.3.1.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.0-6.3.1.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,3 @@
+@@ oracle-se/6.3.0-6.3.1/add-workspace-themes.sql
+@@ oracle-se/6.3.0-6.3.1/add-workspace-owner.sql
+@@ oracle-se/6.3.0-6.3.1/add-workspace_workspace_map.sql


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.0-6.3.1.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.1-6.3.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.1-6.3.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.1-6.3.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1 @@
+@@ oracle-se/6.3.1-6.3.2/freeform-use-clob.sql


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.3.1-6.3.2.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.1-6.5.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.1-6.5.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.1-6.5.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,18 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+@@ default/6.5.1-6.5.2/add-navigation-directory-portlet.sql
+

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.2-6.5.3.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.2-6.5.3.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/oracle-se-6.5.2-6.5.3.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,18 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+@@ /default/6.5.2-6.5.3/add-flash-portlet.sql
+

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-owner.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-owner.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-owner.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,7 @@
+
+alter table workspaces add column owner_id INTEGER;
+
+alter table workspaces add
+    constraint workspaces_owner_id_f_mbbra foreign key (owner_id)
+      references users(user_id);
+


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-owner.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-themes.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-themes.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-themes.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,46 @@
+create table workspace_themes (
+    theme_id INTEGER not null
+        constraint workspac_theme_them_id_p_6_22y
+          primary key,
+        -- referential constraint for theme_id deferred due to circular dependencies
+    theme_name VARCHAR(4000),
+    theme_desc VARCHAR(4000),
+    ctx_bar_color VARCHAR(100),
+    ctx_bar_text_color VARCHAR(100),
+    active_tab_color VARCHAR(100),
+    active_tab_text_color VARCHAR(100),
+    inactive_tab_color VARCHAR(100),
+    inactive_tab_text_color VARCHAR(100),
+    top_rule VARCHAR(100),
+    bottom_rule VARCHAR(100),
+    portlet_head VARCHAR(100),
+    portlet_icon VARCHAR(100),
+    portlet_border_color VARCHAR(100),
+    portlet_border_style VARCHAR(100),
+    portlet_header_text_color VARCHAR(100),
+    page_bg_color VARCHAR(100),
+    page_bg_image VARCHAR(100),
+    narrow_bg_color VARCHAR(100),
+    body_text_color VARCHAR(100)
+);
+
+create table themeapplications (
+    theme_app_id INTEGER not null
+        constraint themeapplic_the_app_id_p_ix9jr
+          primary key
+        -- referential constraint for theme_app_id deferred due to circular dependencies
+);
+
+alter table workspaces add column theme_id INTEGER;
+
+alter table workspaces add
+    constraint workspaces_theme_id_f_tpdju foreign key (theme_id)
+      references workspace_themes(theme_id);
+
+alter table workspace_themes add
+    constraint workspac_theme_them_id_f_ix7ez foreign key (theme_id)
+      references acs_objects(object_id);
+
+alter table themeapplications add
+    constraint themeapplic_the_app_id_f_ejek5 foreign key (theme_app_id)
+      references applications(application_id);


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace-themes.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,18 @@
+
+create table workspace_workspace_map (
+    referenced_workspace_id INTEGER not null,
+        -- referential constraint for referenced_workspace_id deferred due to circular dependencies
+    referencing_workspace_id INTEGER not null,
+        -- referential constraint for referencing_workspace_id deferred due to circular dependencies
+    constraint work_wor_map_ref_wor_i_p_bidbq
+      primary key(referencing_workspace_id, referenced_workspace_id)
+);
+
+alter table workspace_workspace_map add
+    constraint work_wor_map_ref_wor_i_f_md9_z foreign key (referenced_workspace_id)
+      references workspaces(workspace_id);
+alter table workspace_workspace_map add
+    constraint work_wor_map_ref_wor_i_f_nyhzz foreign key (referencing_workspace_id)
+      references workspaces(workspace_id);
+
+create index wrkspc_wrkspc_mp_rfrn_wrks_idx on workspace_workspace_map(referenced_workspace_id);


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/freeform-use-clob.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/freeform-use-clob.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/freeform-use-clob.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,6 @@
+alter table portlet_freeform_html add content_clob text;
+
+update portlet_freeform_html set content_clob = content;
+
+alter table portlet_freeform_html drop content;
+


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres/6.3.1-6.3.2/freeform-use-clob.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-1.4.1-1.4.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-1.4.1-1.4.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-1.4.1-1.4.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,3 @@
+begin;
+\i default/1.4.1-1.4.2/add-workspace-pages.sql
+commit;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-1.4.1-1.4.2.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.0-6.3.1.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.0-6.3.1.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.0-6.3.1.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,5 @@
+begin;
+\i postgres/6.3.0-6.3.1/add-workspace-themes.sql
+\i postgres/6.3.0-6.3.1/add-workspace-owner.sql
+\i postgres/6.3.0-6.3.1/add-workspace_workspace_map.sql
+commit;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.0-6.3.1.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.1-6.3.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.1-6.3.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.1-6.3.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,3 @@
+begin;
+\i postgres/6.3.1-6.3.2/freeform-use-clob.sql
+commit;


Property changes on: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.3.1-6.3.2.sql
___________________________________________________________________
Added: svn:executable
   + 

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.1-6.5.2.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.1-6.5.2.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.1-6.5.2.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,20 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+begin;
+\i default/6.5.1-6.5.2/add-navigation-directory-portlet.sql
+commit;
+

Added: trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.2-6.5.3.sql
===================================================================
--- trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.2-6.5.3.sql	                        (rev 0)
+++ trunk/ccm-portalworkspace/sql/ccm-portalworkspace/upgrade/postgres-6.5.2-6.5.3.sql	2012-05-16 08:28:42 UTC (rev 2314)
@@ -0,0 +1,20 @@
+-- Copyright (C) 2008 Permeance Technologies Pty Ltd. All Rights Reserved.
+-- 
+-- This library is free software; you can redistribute it and/or modify it under
+-- the terms of the GNU Lesser General Public License as published by the Free
+-- Software Foundation; either version 2.1 of the License, or (at your option)
+-- any later version.
+-- 
+-- This library is distributed in the hope that it will be useful, but WITHOUT
+-- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
+-- details.
+-- 
+-- You should have received a copy of the GNU Lesser General Public License
+-- along with this library; if not, write to the Free Software Foundation, Inc.,
+-- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
+
+begin;
+\i default/6.5.2-6.5.3/add-flash-portlet.sql
+commit;
+

Modified: trunk/ccm-portalworkspace/src/ccm-portalworkspace.upgrade
===================================================================
--- trunk/ccm-portalworkspace/src/ccm-portalworkspace.upgrade	2012-05-10 17:33:00 UTC (rev 2313)
+++ trunk/ccm-portalworkspace/src/ccm-portalworkspace.upgrade	2012-05-16 08:28:42 UTC (rev 2314)
@@ -1,28 +1,30 @@
 <upgrade>
   <version from="1.4.1" to="1.4.2">
-    <script sql="ccm-ldn-portal/upgrade/::database::-1.4.1-1.4.2.sql"/>
+    <script sql="ccm-portalworkspace/upgrade/::database::-1.4.1-1.4.2.sql"/>
   </version>
   <version from="6.3.0" to="6.3.1">
-    <script sql="ccm-ldn-portal/upgrade/::database::-6.3.0-6.3.1.sql"/>
+    <script sql="ccm-portalworkspace/upgrade/::database::-6.3.0-6.3.1.sql"/>
   </version>
   <version from="6.3.1" to="6.3.2">
-    <script sql="ccm-ldn-portal/upgrade/::database::-6.3.1-6.3.2.sql"/>
+    <script sql="ccm-portalworkspace/upgrade/::database::-6.3.1-6.3.2.sql"/>
   </version>
   <version from="6.5.0" to="6.5.1">
-    <script class="com.arsdigita.london.portal.upgrade.CreateContainerGroups"/>
+    <script class="com.arsdigita.portalworkspace.upgrade.CreateContainerGroups"/>
   </version>
   <version from="6.5.1" to="6.5.2">
-    <script sql="ccm-ldn-portal/upgrade/::database::-6.5.1-6.5.2.sql"/>
-    <script class="com.arsdigita.london.portal.upgrade.CreateNavigationDirectoryPortlet"/>
+    <script sql="ccm-portalworkspace/upgrade/::database::-6.5.1-6.5.2.sql"/>
+    <script class="com.arsdigita.portalworkspace.upgrade.CreateNavigationDirectoryPortlet"/>
   </version>
   <version from="6.5.2" to="6.5.3">
-    <script sql="ccm-ldn-portal/upgrade/::database::-6.5.2-6.5.3.sql"/>
-    <script class="com.arsdigita.london.portal.upgrade.CreateFlashPortlet"/>
+    <script sql="ccm-portalworkspace/upgrade/::database::-6.5.2-6.5.3.sql"/>
+    <script class="com.arsdigita.portalworkspace.upgrade.CreateFlashPortlet"/>
   </version>
   <version from="6.6.0" to="6.6.1">
+    <!-- Rename ccm-ldn-portal  to ccm-portalworkspace   -->
     <script sql="ccm-portalworkspace/upgrade/::database::-6.6.0-6.6.1.sql"/>
   </version>
   <version from="6.6.1" to="6.6.2">
+    <!--  Refactored Legacy Free     --> 
     <script sql="ccm-portalworkspace/upgrade/::database::-6.6.1-6.6.2.sql"/>
   </version>
 </upgrade>