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.txt 24 Dec 2008 11:10:33 -0000 1.9
+++ migration_1.5_to_1.6.txt 24 Dec 2008 14:35:28 -0000 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
