Update of /var/cvs/contributions/CMSContainer/migration
In directory james.mmbase.org:/tmp/cvs-serv4409
Modified Files:
migration_1.4_to_1.5.txt
Log Message:
CMSC-681 Asset Maintenance sql_script
See also: http://cvs.mmbase.org/viewcvs/contributions/CMSContainer/migration
See also: http://www.mmbase.org/jira/browse/CMSC-681
Index: migration_1.4_to_1.5.txt
===================================================================
RCS file:
/var/cvs/contributions/CMSContainer/migration/migration_1.4_to_1.5.txt,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -b -r1.19 -r1.20
--- migration_1.4_to_1.5.txt 17 Dec 2008 02:33:01 -0000 1.19
+++ migration_1.4_to_1.5.txt 17 Dec 2008 02:42:12 -0000 1.20
@@ -109,19 +109,7 @@
ALTER TABLE live_stylesheet ADD COLUMN overwriteable bit(1);
--- End script ---
Exceptions/errors/other problems and what to do:
-*
-*
-*
-Name: Add the static_html field and the process_status field in
newsletterpublication builder
-Goal: the static_html,save the Frozen edition ; process_status,save the status
of edition,CMSC-1143
-Type: sql-script
---- Start script ---
-ALTER TABLE mm_newsletterpublication ADD static_html text;
-ALTER TABLE mm_newsletterpublication ADD process_status varchar(50);
-ALTER TABLE live_newsletterpublication ADD static_html text;
-ALTER TABLE live_newsletterpublication ADD process_status varchar(50);
---- End script ---
*
*
*
@@ -135,36 +123,3 @@
*
*
*
-Name: Add the approved_by filed to the mm_newsletterpublication table.
-Goal: .
-Type: sql-script
---- Start script ---
-ALTER TABLE mm_newsletterpublication ADD COLUMN approved_by varchar(255);
-ALTER TABLE live_newsletterpublication ADD COLUMN approved_by varchar(255);
---- End script ---
-Exceptions/errors/other problems and what to do:
-*
-*
-*
-
-Name: Add the active field to the people table of the Community database
-Goal: .
-Type: sql-script
---- Start script ---
-ALTER TABLE people ADD COLUMN active varchar(255);
---- End script ---
-Exceptions/errors/other problems and what to do:
-*
-*
-*
-
-Name: Moved users without a status to active, in the Community database
-Goal: .
-Type: sql-script
---- Start script ---
-UPDATE people SET active='Active' WHERE active is null or active='';
---- End script ---
-Exceptions/errors/other problems and what to do:
-*
-*
-*
\ No newline at end of file
_______________________________________________
Cvs mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/cvs
