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.txt 17 Dec 2008 07:43:09 -0000 1.3
+++ migration_1.5_to_1.6.txt 17 Dec 2008 09:56:31 -0000 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
