Menu
▾
▴
aplaws-commit
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>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X