Menu
▾
▴
[Aplaws-commit] r2310 - in trunk/ccm-ldn-types-esdservice: sql/ccm-ldn-types-esdservice sql/ccm-ldn-types-esdservice/update sql/ccm-ldn-types-esdservice/update/default sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1 src/WEB-INF/content-types/com/arsdigita/london/contenttypes
|
From: <pb...@fe...> - 2012-05-05 07:13:43
|
Author: pboy
Date: 2012-05-05 07:13:29 +0000 (Sat, 05 May 2012)
New Revision: 2310
Added:
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/ren_esdservice_table.sql
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/upd_system_tables.sql
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/oracle-se-6.6.0-6.6.1.sql
trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/postgres-6.6.0-6.6.1.sql
Modified:
trunk/ccm-ldn-types-esdservice/src/WEB-INF/content-types/com/arsdigita/london/contenttypes/ESDService.xml
Log:
Added missing upgrade script ccm-ldn-types-esdservice.
Added: trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/ren_esdservice_table.sql
===================================================================
--- trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/ren_esdservice_table.sql (rev 0)
+++ trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/ren_esdservice_table.sql 2012-05-05 07:13:29 UTC (rev 2310)
@@ -0,0 +1,41 @@
+--
+-- Copyright (C) 2012 Peter Boy 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
+--
+-- $Id: ren_esdservice_table.sql pboy $
+
+-- rename ct_esdservice table to ct_ldn_esdservice table following
+-- ccm naming conventions to make maintenance tasks easier
+
+
+-- if we could figure out the old names we could rename constraints too
+-- alter table ct_esdservice drop constraint ... ;
+-- alter table ct_esdservice drop constraint ... ;
+-- alter table ct_esdservice drop constraint ... ;
+
+alter table ct_esdservice RENAME TO ct_ldn_esdservice ;
+
+-- alter table ct_ldn_esdservice
+-- add constraint ct_ldn_esdserv_serv_id_p_5dac0 PRIMARY KEY(service_id);
+-- alter table ct_ldn_esdservice
+-- add constraint ct_ldn_esdserv_cont_id_f_r4d1z FOREIGN KEY (contact_id)
+-- references ct_ldn_contacts (contact_id) MATCH SIMPLE
+-- ON UPDATE NO ACTION ON DELETE NO ACTION;
+-- alter table ct_ldn_esdservice
+-- add constraint ct_ldn_esdserv_serv_id_f_tfkqn FOREIGN KEY (service_id)
+-- references cms_articles (article_id) MATCH SIMPLE
+-- ON UPDATE NO ACTION ON DELETE NO ACTION;
+
Added: trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/upd_system_tables.sql
===================================================================
--- trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/upd_system_tables.sql (rev 0)
+++ trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/default/6.6.0-6.6.1/upd_system_tables.sql 2012-05-05 07:13:29 UTC (rev 2310)
@@ -0,0 +1,90 @@
+--
+-- Copyright (C) 2012 Peter Boy 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
+--
+-- $Id: upd_system_tables.sql pboy $
+
+-- rename ccm-cms-types-contact to ccm-ldn-types-contact
+-- adjust various system tables to the new name of content type
+
+alter table init_requirements drop constraint init_requirements_init_f_cmmdn ;
+alter table init_requirements drop constraint init_require_requ_init_f_i6rgg ;
+
+update inits
+ set class_name='com.arsdigita.london.contenttypes.ESDServiceInitializer'
+ where class_name='com.arsdigita.cms.contenttypes.ESDServiceInitializer' ;
+
+update init_requirements
+ set init='com.arsdigita.london.contenttypes.ESDServiceInitializer'
+ where init='com.arsdigita.cms.contenttypes.ESDServiceInitializer' ;
+
+ALTER TABLE init_requirements
+ ADD CONSTRAINT init_requirements_init_f_cmmdn FOREIGN KEY (init)
+ REFERENCES inits (class_name) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION;
+ALTER TABLE init_requirements
+ ADD CONSTRAINT init_require_requ_init_f_i6rgg FOREIGN KEY (required_init)
+ REFERENCES inits (class_name) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION;
+
+
+update content_types
+ set object_type='com.arsdigita.london.contenttypes.ESDService',
+ label='ESD Service',
+ description='An ESDService',
+ classname='com.arsdigita.london.contenttypes.ESDService'
+ where classname='com.arsdigita.cms.contenttypes.ESDService' ;
+
+update authoring_steps
+ set label_key='ESD Service Properties',
+ label_bundle='com.arsdigita.london.contenttypes.ESDServiceResources',
+ description_key='Edit the basic ESDService properties',
+ description_bundle='com.arsdigita.london.contenttypes.ESDServiceResources',
+ component='com.arsdigita.london.contenttypes.ui.ESDServicePropertiesStep'
+ where component='com.arsdigita.cms.contenttypes.ui.ESDServicePropertiesStep' ;
+
+update authoring_steps
+ set label_key='ESD Service Contact',
+ label_bundle='com.arsdigita.london.contenttypes.ESDServiceResources',
+ description_key='Edit/Choose the associated Contact object',
+ description_bundle='com.arsdigita.london.contenttypes.ESDServiceResources',
+ component='com.arsdigita.london.contenttypes.ui.ESDServiceChooseContactStep'
+ where component='com.arsdigita.cms.contenttypes.ui.ESDServiceChooseContactStep' ;
+
+
+
+update acs_objects
+ set (object_type,default_domain_class) =
+ ('com.arsdigita.london.contenttypes.ESDService' ,
+ 'com.arsdigita.london.contenttypes.ESDService' )
+ where default_domain_class like 'com.arsdigita.cms.contenttypes.ESDService' ;
+
+update lucene_docs
+ set type='com.arsdigita.london.contenttypes.ESDService'
+ where type='com.arsdigita.cms.contenttypes.ESDService' ;
+
+update vcx_generic_operations
+ set value=replace(value,'cms.contenttypes.ESDService', 'london.contenttypes.ESDService')
+ where value like '%cms.contenttypes.ESDService%';
+
+update vcx_obj_changes
+ set obj_id=replace(obj_id,'cms.contenttypes.ESDService', 'london.contenttypes.ESDService')
+ where obj_id like '%cms.contenttypes.ESDService%';
+
+update vcx_tags
+ set tagged_oid=replace(tagged_oid,'cms.contenttypes.ESDService', 'london.contenttypes.ESDService')
+ where tagged_oid like '%cms.contenttypes.ESDService%';
+
Added: trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/oracle-se-6.6.0-6.6.1.sql
===================================================================
--- trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/oracle-se-6.6.0-6.6.1.sql (rev 0)
+++ trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/oracle-se-6.6.0-6.6.1.sql 2012-05-05 07:13:29 UTC (rev 2310)
@@ -0,0 +1,21 @@
+--
+-- Copyright (C) 2012 Peter Boy 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
+--
+-- $Id: oracle-se-6.6.0-6.6.1.sql pboy $
+
+@@ default/6.6.0-6.6.1/ren_esdservice_table.sql
+@@ default/6.6.0-6.6.1/upd_system_tables.sql
Added: trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/postgres-6.6.0-6.6.1.sql
===================================================================
--- trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/postgres-6.6.0-6.6.1.sql (rev 0)
+++ trunk/ccm-ldn-types-esdservice/sql/ccm-ldn-types-esdservice/update/postgres-6.6.0-6.6.1.sql 2012-05-05 07:13:29 UTC (rev 2310)
@@ -0,0 +1,27 @@
+--
+-- Copyright (C) 2012 Peter Boy 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
+--
+-- $Id: postgres-6.6.0-6.6.1.sql pboy $
+
+\echo APLAWS ldn esdservice 6.6.0 -> 6.6.1 Upgrade Script (PostgreSQL)
+
+begin;
+
+\i default/6.6.0-6.6.1/ren_esdservice_table.sql
+\i default/6.6.0-6.6.1/upd_system_tables.sql
+
+commit;
Modified: trunk/ccm-ldn-types-esdservice/src/WEB-INF/content-types/com/arsdigita/london/contenttypes/ESDService.xml
===================================================================
--- trunk/ccm-ldn-types-esdservice/src/WEB-INF/content-types/com/arsdigita/london/contenttypes/ESDService.xml 2012-05-05 07:13:05 UTC (rev 2309)
+++ trunk/ccm-ldn-types-esdservice/src/WEB-INF/content-types/com/arsdigita/london/contenttypes/ESDService.xml 2012-05-05 07:13:29 UTC (rev 2310)
@@ -4,21 +4,21 @@
xsi:schemaLocation="http://xmlns.redhat.com/cms/content-types content-types.xsd">
<ctd:content-type
- label="ESDService"
+ label="ESD Service"
description="An ESDService for Tamaside"
objectType="com.arsdigita.london.contenttypes.ESDService"
classname="com.arsdigita.london.contenttypes.ESDService">
<ctd:authoring-kit createComponent="com.arsdigita.cms.ui.authoring.PageCreate">
<ctd:authoring-step
- label="ESDService Properties"
+ label="ESD Service Properties"
description="Edit the basic ESDService properties"
component="com.arsdigita.london.contenttypes.ui.ESDServicePropertiesStep"/>
<ctd:include href="/WEB-INF/content-types/edit-body-text-step.xml"/>
<ctd:authoring-step
- label="Service Contact"
+ label="ESD Service Contact"
description="Edit/Choose the associated Contact object"
component="com.arsdigita.london.contenttypes.ui.ESDServiceChooseContactStep"/>
|
