[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv17365/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1341 - added upgrade procedure for google analytics field See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1341 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.20 retrieving revision 1.21 diff -u -b -r1.20 -r1.21 --- migration_1.5_to_1.6.txt27 Mar 2009 07:01:34 - 1.20 +++ migration_1.5_to_1.6.txt21 Apr 2009 14:33:45 - 1.21 @@ -214,3 +214,14 @@ * * * + +Name: Add google analytics id +Goal: Have a google analytics id per site +ype: sql-script +--- Start script --- +ALTER TABLE mm_site ADD COLUMN googleanalyticsid VARCHAR(40) NULL; +ALTER TABLE live_site ADD COLUMN googleanalyticsid VARCHAR(40) NULL; +--- End script --- +* +* +* \ No newline at end of file ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv9950 Modified Files: Tag: b1_6 migration_1.5_to_1.6.txt Log Message: CMSC-1348 - Newsletter: Sent At-column is not working properly See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1348 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.19 retrieving revision 1.19.2.1 diff -u -b -r1.19 -r1.19.2.1 --- migration_1.5_to_1.6.txt25 Feb 2009 10:44:26 - 1.19 +++ migration_1.5_to_1.6.txt27 Mar 2009 07:01:17 - 1.19.2.1 @@ -102,6 +102,16 @@ * * +Name: Add a sendtime column in prefix_newsletterpublication table +Goal: Used to save/get sendtime,CMSC-1348 +Type: sql-script +--- Start script --- +ALTER TABLE mm_newsletterpublication ADD sendtime datetime; +ALTER TABLE live_newsletterpublication ADD sendtime datetime; +--- End script --- +* +* +* Name: The cmsc:renderURL uses stricter page parameter input, for resolving of page location Goal: better JSP code ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv9974 Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1348 - Newsletter: Sent At-column is not working properly See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1348 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.19 retrieving revision 1.20 diff -u -b -r1.19 -r1.20 --- migration_1.5_to_1.6.txt25 Feb 2009 10:44:26 - 1.19 +++ migration_1.5_to_1.6.txt27 Mar 2009 07:01:34 - 1.20 @@ -102,6 +102,16 @@ * * +Name: Add a sendtime column in prefix_newsletterpublication table +Goal: Used to save/get sendtime,CMSC-1348 +Type: sql-script +--- Start script --- +ALTER TABLE mm_newsletterpublication ADD sendtime datetime; +ALTER TABLE live_newsletterpublication ADD sendtime datetime; +--- End script --- +* +* +* Name: The cmsc:renderURL uses stricter page parameter input, for resolving of page location Goal: better JSP code ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv2566/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1265 - Add dependencies to project.xml for Community Module See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1265 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.18 retrieving revision 1.19 diff -u -b -r1.18 -r1.19 --- migration_1.5_to_1.6.txt19 Feb 2009 15:16:38 - 1.18 +++ migration_1.5_to_1.6.txt25 Feb 2009 10:44:26 - 1.19 @@ -177,3 +177,30 @@ * * + +Name: Add dependency for Community module (if used!) +Goal: prevent class-load error +Type: add dependency to maven-base/project.xml +--- Start dependency --- + dependency +groupIdsupercsv/groupId +artifactIdSuperCSV/artifactId +version1.52/version +typejar/type +properties + war.bundle${war.bundle}/war.bundle +/properties + /dependency +dependency +groupIdspiffyframework/groupId +artifactIdspiffy-with_source-all/artifactId +version0.05/version +typejar/type +properties + war.bundle${war.bundle}/war.bundle +/properties + /dependency +--- End script --- +* +* +* ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv25789/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1253 - Reduce code duplication in edit_default templates See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1253 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.16 retrieving revision 1.17 diff -u -b -r1.16 -r1.17 --- migration_1.5_to_1.6.txt4 Feb 2009 15:32:58 - 1.16 +++ migration_1.5_to_1.6.txt14 Feb 2009 16:10:04 - 1.17 @@ -111,6 +111,8 @@ * Good: use the page= with the full page path, e.g. the input of cmsc:location to retrieve the full page path. * + + Name: Flash movies/apps do not work with Flash 10. Goal: fix it in JSPs Type: user action @@ -122,3 +124,31 @@ * * * + + +Name: Check your overridden edit_default templates +Goal: Fix JSP's +Type: user action + +--- Start script --- +Check all of the edit_default templates your project overrides. From version 1.6 up, the edit_default templates have been refactored to reduce code duplication. All commonly used parts of an edit_default template have been put into includable JSP's. See the default edit_default templates in the CMSc /cmsc/portlets/src/webapps/WEB-INF/templates/edit_defaults directory for an example. +Please do not edit the includable parts, because this might cuase problems in other portlets that use them. +--- End script --- +* +* +* + + + + + +Name: Check references to ServerUtil - Has been moved +Goal: +Type: user action + +--- Start script --- +Change all references to ServerUtil, which was located in com.finalist.cmsc.navigation. It has been moved to com.finalist.cmsc.util. +--- End script --- +* +* +* ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv14997/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1275 - Assets: URLs has both name and title, should only have title. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1275 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.15 retrieving revision 1.16 diff -u -b -r1.15 -r1.16 --- migration_1.5_to_1.6.txt23 Jan 2009 12:57:09 - 1.15 +++ migration_1.5_to_1.6.txt4 Feb 2009 15:32:58 - 1.16 @@ -43,16 +43,13 @@ Goal: Asset improvements Type: sql-script --- Start script --- -ALTER TABLE mm_urls ADD column title text NULL; +ALTER TABLE mm_urls CHANGE column name title text NULL; ALTER TABLE mm_urls MODIFY description text NULL; ALTER TABLE mm_images MODIFY title text NULL; ALTER TABLE live_images MODIFY title text NULL; -ALTER TABLE live_urls ADD column title text NULL; +ALTER TABLE live_urls CHANGE column name title text NULL; ALTER TABLE live_urls MODIFY description text NULL; - -update mm_urls set title=name; -update live_urls set title=name; --- End script --- Exceptions/errors/other problems and what to do: * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv3349/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1258 - Flash movies do not work using Flash 10 See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1258 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.14 retrieving revision 1.15 diff -u -b -r1.14 -r1.15 --- migration_1.5_to_1.6.txt20 Jan 2009 15:56:18 - 1.14 +++ migration_1.5_to_1.6.txt23 Jan 2009 12:57:09 - 1.15 @@ -113,3 +113,15 @@ * Wrong: cmsc:renderURL page=${SearchResultPage} --- where parameter is 'search' instead of full path: google.com/search * Good: use the page= with the full page path, e.g. the input of cmsc:location to retrieve the full page path. * + +Name: Flash movies/apps do not work with Flash 10. +Goal: fix it in JSPs +Type: user action +--- Start script --- +This is fixed by two requirements: +- use CMSC 1.4.15/1.5.1 or better +- Add disposition=inline to the mm:attachment tag where flash files are loaded in the views. +--- End script --- +* +* +* ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv25213/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1193 - Tag cmsc:renderURL does not take account of the host location of the page: improvement to Java code for better page input. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1193 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.13 retrieving revision 1.14 diff -u -b -r1.13 -r1.14 --- migration_1.5_to_1.6.txt13 Jan 2009 14:16:01 - 1.13 +++ migration_1.5_to_1.6.txt20 Jan 2009 15:56:18 - 1.14 @@ -104,3 +104,12 @@ * * * + + +Name: The cmsc:renderURL uses stricter page parameter input, for resolving of page location +Goal: better JSP code +Type: check your own views for the wrong usage of cmsc:renderURL with the page parameter and incomplete input +Exceptions/errors/other problems and what to do: +* Wrong: cmsc:renderURL page=${SearchResultPage} --- where parameter is 'search' instead of full path: google.com/search +* Good: use the page= with the full page path, e.g. the input of cmsc:location to retrieve the full page path. +* ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv21550/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 - Make sure contentrepository builders get updated when using Assets for the first time. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.11 retrieving revision 1.12 diff -u -b -r1.11 -r1.12 --- migration_1.5_to_1.6.txt7 Jan 2009 03:51:10 - 1.11 +++ migration_1.5_to_1.6.txt7 Jan 2009 15:47:33 - 1.12 @@ -7,18 +7,19 @@ Execute the following steps below in the given order: -Name: Add publishdate, expiredate, use_expirydate and m_status column to urls, images and attachments +Name: Add publishdate, expiredate, use_expirydate and m_status column to urls, images and attachments. Making sure contentrepository gets updated with the new builder version 3. Goal: Add publishdate, expiredate, use_expirydate and m_status column to urls, images and attachments Type: sql-script --- Start script --- ALTER TABLE mm_attachments ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); ALTER TABLE mm_images ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); ALTER TABLE mm_urls ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); +UPDATE mm_versions SET version = '2' WHERE name='contentrepository'; ALTER TABLE live_attachments ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); ALTER TABLE live_images ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); ALTER TABLE live_urls ADD column (publishdate datetime default NULL,expiredate datetime default NULL,use_expirydate bit(1) NOT NULL,m_status text); - +UPDATE live_versions SET version = '2' WHERE name='contentrepository'; --- End script --- Exceptions/errors/other problems and what to do: * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv12127 Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 Asset Maintenance See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.10 retrieving revision 1.11 diff -u -b -r1.10 -r1.11 --- migration_1.5_to_1.6.txt24 Dec 2008 14:35:28 - 1.10 +++ migration_1.5_to_1.6.txt7 Jan 2009 03:51:10 - 1.11 @@ -49,6 +49,9 @@ ALTER TABLE live_images MODIFY title text NULL; ALTER TABLE live_urls ADD column title text NULL; ALTER TABLE live_urls MODIFY description text NULL; + +update mm_urls set title=name; +update live_urls set title=name; --- End script --- Exceptions/errors/other problems and what to do: * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv6321 Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1192 Assets: add SQL script to migrate all images/attachments/URLs to new assetstable See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1192 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.6 retrieving revision 1.7 diff -u -b -r1.6 -r1.7 --- migration_1.5_to_1.6.txt17 Dec 2008 10:55:22 - 1.6 +++ migration_1.5_to_1.6.txt24 Dec 2008 08:54:35 - 1.7 @@ -54,3 +54,20 @@ * * * \ No newline at end of file + +Name: Migration from images/attachments/urls to assetelement table +Goal: migrate all images/attachments/URLs to new assetstable +Type: sql-script +--- Start script --- +insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_urls; +insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_attachments; +insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_images; + +insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_urls; +insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_attachments; +insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_images; + +--- End script --- +* +* +* \ No newline at end of file ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv20265/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1192 - Assets: add user script to move existing assets to a content channel See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1192 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.7 retrieving revision 1.8 diff -u -b -r1.7 -r1.8 --- migration_1.5_to_1.6.txt24 Dec 2008 08:54:35 - 1.7 +++ migration_1.5_to_1.6.txt24 Dec 2008 11:09:43 - 1.8 @@ -71,3 +71,15 @@ * * * \ No newline at end of file + + +Name: Move existing assets to a existing content channel +Goal: make all existing assets usable and searchable. +Type: run JSP file as admin user +--- Start --- +- Run editors/maintenance/create-relations-asset-channel.jsp + and enter the nodenumber of the channel in the repository where the unattached images should go to. +--- End --- +* +* +* ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv20351/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1192 - Assets: add user script to move existing assets to a content channel See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1192 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.8 retrieving revision 1.9 diff -u -b -r1.8 -r1.9 --- migration_1.5_to_1.6.txt24 Dec 2008 11:09:43 - 1.8 +++ migration_1.5_to_1.6.txt24 Dec 2008 11:10:33 - 1.9 @@ -73,11 +73,11 @@ * -Name: Move existing assets to a existing content channel +Name: Move existing assets to a existing content channel (only on staging) Goal: make all existing assets usable and searchable. Type: run JSP file as admin user --- Start --- -- Run editors/maintenance/create-relations-asset-channel.jsp +- Run staging/editors/maintenance/create-relations-asset-channel.jsp and enter the nodenumber of the channel in the repository where the unattached images should go to. --- End --- * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv10229/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-1192 - Assets: explanation improved See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-1192 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.9 retrieving revision 1.10 diff -u -b -r1.9 -r1.10 --- migration_1.5_to_1.6.txt24 Dec 2008 11:10:33 - 1.9 +++ migration_1.5_to_1.6.txt24 Dec 2008 14:35:28 - 1.10 @@ -55,18 +55,22 @@ * * + Name: Migration from images/attachments/urls to assetelement table -Goal: migrate all images/attachments/URLs to new assetstable +Goal: migrate all images/attachments/URLs to new assets table Type: sql-script --- Start script --- -insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_urls; -insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_attachments; -insert into mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_images; - -insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_urls; -insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_attachments; -insert into live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_images; +* First start CMSC 1.6 for the first time (it needs to create the assets tables!) +* Wait for finishing startup (editors should work) +* Stop CMSC 1.6 +* Execute the following script on database: +INSERT INTO mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_urls; +INSERT INTO mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_attachments; +INSERT INTO mm_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from mm_images; +INSERT INTO live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_urls; +INSERT INTO live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_attachments; +INSERT INTO live_assetelement select number,otype,owner,creationdate,lastmodifieddate,publishdate,expiredate,lastmodifier,creator,use_expirydate,title,description,m_status from live_images; --- End script --- * * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv20153/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 - Make SQL better. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.3 retrieving revision 1.4 diff -u -b -r1.3 -r1.4 --- migration_1.5_to_1.6.txt17 Dec 2008 07:43:09 - 1.3 +++ migration_1.5_to_1.6.txt17 Dec 2008 09:56:31 - 1.4 @@ -37,48 +37,25 @@ * * -Name: Add title column to urls -Goal: Add title column to urls -Type: sql-script Start script --- -ALTER TABLE mm_urls ADD column title text; - -ALTER TABLE live_urls ADD column title text; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* -Name: Modify description field for urls -Goal: Modify description field for urls +Name: Add title and description column to urls / images +Goal: Asset improvements Type: sql-script --- Start script --- +ALTER TABLE mm_urls ADD column title text; ALTER TABLE mm_urls MODIFY description text; - -ALTER TABLE live_urls MODIFY description text; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Modify title field for images -Goal: Modify title field for images -Type: sql-script Start script --- ALTER TABLE mm_images MODIFY title text; ALTER TABLE live_images MODIFY title text; - +ALTER TABLE live_urls ADD column title text; +ALTER TABLE live_urls MODIFY description text; --- End script --- Exceptions/errors/other problems and what to do: * * * + Name: Add workflowrel relation between workflowitem and assetelement to typerel Goal: Add workflowrel relation between workflowitem and assetelement to typerel Type: sql-script ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv22062/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 - Make SQL better. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.5 retrieving revision 1.6 diff -u -b -r1.5 -r1.6 --- migration_1.5_to_1.6.txt17 Dec 2008 10:18:21 - 1.5 +++ migration_1.5_to_1.6.txt17 Dec 2008 10:55:22 - 1.6 @@ -54,58 +54,3 @@ * * * - - -Name: Add workflowrel relation between workflowitem and assetelement to typerel -Goal: Add workflowrel relation between workflowitem and assetelement to typerel -Type: sql-script Start script --- -INSERT INTO mm_typerel SELECT 10001, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='workflowitem' AND typedef2.name='assetelement' AND reldef.sname='workflowrel'; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add creationrel relation between assetelement and contentchannel to typerel -Goal: Add creationrel relation between assetelement and contentchannel to typerel -Type: sql-script Start script --- -INSERT INTO mm_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; - -INSERT INTO live_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add deletionrel relation between assetelement and contentchannel to typerel -Goal: Add deletionrel relation between assetelement and contentchannel to typerel -Type: sql-script Start script --- -INSERT INTO mm_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; - -INSERT INTO live_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* - -Name: Add ownerrel relation between assetelement and user to typerel -Goal: Add ownerrel relation between assetelement and user to typerel -Type: sql-script Start script --- -INSERT INTO mm_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; - -INSERT INTO live_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; - End script --- -Exceptions/errors/other problems and what to do: -* -* -* \ No newline at end of file ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv20711/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 - Make SQL better. See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.4 retrieving revision 1.5 diff -u -b -r1.4 -r1.5 --- migration_1.5_to_1.6.txt17 Dec 2008 09:56:31 - 1.4 +++ migration_1.5_to_1.6.txt17 Dec 2008 10:18:21 - 1.5 @@ -42,13 +42,13 @@ Goal: Asset improvements Type: sql-script --- Start script --- -ALTER TABLE mm_urls ADD column title text; -ALTER TABLE mm_urls MODIFY description text; -ALTER TABLE mm_images MODIFY title text; - -ALTER TABLE live_images MODIFY title text; -ALTER TABLE live_urls ADD column title text; -ALTER TABLE live_urls MODIFY description text; +ALTER TABLE mm_urls ADD column title text NULL; +ALTER TABLE mm_urls MODIFY description text NULL; +ALTER TABLE mm_images MODIFY title text NULL; + +ALTER TABLE live_images MODIFY title text NULL; +ALTER TABLE live_urls ADD column title text NULL; +ALTER TABLE live_urls MODIFY description text NULL; --- End script --- Exceptions/errors/other problems and what to do: * ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv6778 Added Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 Asset Maintenance See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 migration_1.5_to_1.6.txt is new ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv12029/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 Asset Maintenance See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.1 retrieving revision 1.2 diff -u -b -r1.1 -r1.2 --- migration_1.5_to_1.6.txt16 Dec 2008 12:26:29 - 1.1 +++ migration_1.5_to_1.6.txt17 Dec 2008 04:43:15 - 1.2 @@ -7,18 +7,6 @@ Execute the following steps below in the given order: -Name: Creat a new Asset super type, AssetElement -Goal: Creat a new Asset super type, AssetElement -Type: sql-script Start script --- -CREATE TABLE mm_assetelement(number int(11) NOT NULL,otype int(11) NOT NULL,owner varchar(12) NOT NULL,creationdate datetime default NULL,lastmodifieddate datetime default NULL,publishdate datetime default NULL,expiredate datetime default NULL,lastmodifier text,creator text,use_expirydate bit(1) NOT NULL,title text,description text,m_status text,PRIMARY KEY(number),KEY otype(otype)); - End script --- -Exceptions/errors/other problems and what to do: -* -* -* - Name: Add publishdate, expiredate, use_expirydate and m_status column to urls, images and attachments Goal: Add publishdate, expiredate, use_expirydate and m_status column to urls, images and attachments Type: sql-script @@ -37,8 +25,8 @@ * * -Name: Add nodeType column to workflowitem -Goal: Add nodeType column to workflowitem +Name: Add nodetype column to workflowitem +Goal: Add nodetype column to workflowitem Type: sql-script --- Start script --- ALTER TABLE mm_workflowitem ADD column nodetype varchar(64) default NULL; @@ -49,53 +37,42 @@ * * -Name: Add asset relations -Goal: Create relations of asset -Type: contentrepository/config/applications/contentrepository.xml (installed under APP_HOME/WEB-INF/config/applications/contentrepository.xml) +Name: Add title column to urls +Goal: Add title column to urls +Type: sql-script --- Start script --- - relation from=assetelement to=contentchannel type=creationrel / - relation from=assetelement to=contentchannel type=deletionrel / - relation from=assetelement to=user type=ownerrel / +ALTER TABLE mm_urls ADD column title text; + +ALTER TABLE live_urls ADD column title text; + --- End script --- Exceptions/errors/other problems and what to do: * * * -Name: Create relations -Goal: Create relations from workflowitem to assetelement -Type: workflow/config/applications/workflow.xml (installed under APP_HOME/WEB-INF/config/applications/workflow.xml) +Name: Modify description field for urls +Goal: Modify description field for urls +Type: sql-script --- Start script --- - relation from=workflowitem to=assetelement type=workflowrel / +ALTER TABLE mm_urls MODIFY description text; + +ALTER TABLE live_urls MODIFY description text; + --- End script --- Exceptions/errors/other problems and what to do: * * * -Name: Create extends relations of asset -Goal: Create extends relations of asset -Type: contentrepository/config/applications/Resources/builders/attachments.xml,images.xml,urls.xml (installed under APP_HOME/WEB-INF/config/applications/Resources/builders/attachments.xml,images.xml,urls.xml) + +Name: Modify title field for images +Goal: Modify title field for images +Type: sql-script --- Start script --- -builder -xmlns=http://www.mmbase.org/xmlns/builder; -xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; -xsi:schemaLocation=http://www.mmbase.org/xmlns/builder -http://www.mmbase.org/xmlns/builder.xsd; -name=images maintainer=mmbase.org version=0 extends=assetelement - -builder -xmlns=http://www.mmbase.org/xmlns/builder; -xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; -xsi:schemaLocation=http://www.mmbase.org/xmlns/builder -http://www.mmbase.org/xmlns/builder.xsd; -name=urls maintainer=www.mmbase.org version=1 extends=assetelement - -builder -xmlns=http://www.mmbase.org/xmlns/builder; -xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance; -xsi:schemaLocation=http://www.mmbase.org/xmlns/builder -http://www.mmbase.org/xmlns/builder.xsd; -name=attachments maintainer=www.mmbase.org version=1 extends=assetelement +ALTER TABLE mm_images MODIFY title text; + +ALTER TABLE live_images MODIFY title text; + --- End script --- Exceptions/errors/other problems and what to do: * ___ Cvs mailing list Cvs@lists.mmbase.org
[MMBASE CVS] contributions/CMSContainer/migration migration_1.5_to_1.6.txt
Update of /var/cvs/contributions/CMSContainer/migration In directory james.mmbase.org:/tmp/cvs-serv16655/migration Modified Files: migration_1.5_to_1.6.txt Log Message: CMSC-681 Asset Maintenance See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration See also: http://www.mmbase.org/jira/browse/CMSC-681 Index: migration_1.5_to_1.6.txt === RCS file: /var/cvs/contributions/CMSContainer/migration/migration_1.5_to_1.6.txt,v retrieving revision 1.2 retrieving revision 1.3 diff -u -b -r1.2 -r1.3 --- migration_1.5_to_1.6.txt17 Dec 2008 04:43:15 - 1.2 +++ migration_1.5_to_1.6.txt17 Dec 2008 07:43:09 - 1.3 @@ -78,3 +78,57 @@ * * * \ No newline at end of file + +Name: Add workflowrel relation between workflowitem and assetelement to typerel +Goal: Add workflowrel relation between workflowitem and assetelement to typerel +Type: sql-script +--- Start script --- +INSERT INTO mm_typerel SELECT 10001, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='workflowitem' AND typedef2.name='assetelement' AND reldef.sname='workflowrel'; + +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* + +Name: Add creationrel relation between assetelement and contentchannel to typerel +Goal: Add creationrel relation between assetelement and contentchannel to typerel +Type: sql-script +--- Start script --- +INSERT INTO mm_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; + +INSERT INTO live_typerel SELECT 10002, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='creationrel'; + +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* + +Name: Add deletionrel relation between assetelement and contentchannel to typerel +Goal: Add deletionrel relation between assetelement and contentchannel to typerel +Type: sql-script +--- Start script --- +INSERT INTO mm_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; + +INSERT INTO live_typerel SELECT 10003, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='contentchannel' AND reldef.sname='deletionrel'; + +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* + +Name: Add ownerrel relation between assetelement and user to typerel +Goal: Add ownerrel relation between assetelement and user to typerel +Type: sql-script +--- Start script --- +INSERT INTO mm_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM mm_typedef typedef1, mm_typedef typedef2, mm_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; + +INSERT INTO live_typerel SELECT 10004, 7, 'system', typedef1.number, typedef2.number, reldef.number, -1 FROM live_typedef typedef1, live_typedef typedef2, live_reldef reldef WHERE typedef1.name='assetelement' AND typedef2.name='user' AND reldef.sname='ownerrel'; + +--- End script --- +Exceptions/errors/other problems and what to do: +* +* +* \ No newline at end of file ___ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs