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.txt 17 Dec 2008 10:55:22 -0000 1.6
+++ migration_1.5_to_1.6.txt 24 Dec 2008 08:54:35 -0000 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
