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.txt 7 Jan 2009 03:51:10 -0000 1.11
+++ migration_1.5_to_1.6.txt 7 Jan 2009 15:47:33 -0000 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
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
