Author: jkoster Date: 2010-02-23 10:25:27 +0100 (Tue, 23 Feb 2010) New Revision: 41148
Modified: CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.6_to_1.7.txt Log: CMSC-1330 - Some MMBase 1.9 fields need updates too. Modified: CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.6_to_1.7.txt =================================================================== --- CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.6_to_1.7.txt 2010-02-23 09:25:26 UTC (rev 41147) +++ CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.6_to_1.7.txt 2010-02-23 09:25:27 UTC (rev 41148) @@ -247,3 +247,37 @@ * * * + + +Name: convert database to new MMBase 1.9 style +Goal: +Type: script +--- Start --- +ALTER TABLE mm_attachments MODIFY title text; +ALTER TABLE live_attachments MODIFY title text; + +ALTER TABLE mm_cronjobs MODIFY config text NULL; +ALTER TABLE mm_cronjobs ADD lastrun datetime NULL; +ALTER TABLE mm_cronjobs ADD m_count integer; +ALTER TABLE mm_cronjobs ADD lastcost integer; + +ALTER TABLE live_cronjobs MODIFY config text NULL; +ALTER TABLE live_cronjobs ADD lastrun datetime NULL; +ALTER TABLE live_cronjobs ADD m_count integer; +ALTER TABLE live_cronjobs ADD lastcost integer; + +--Please check if the email-tables are empty before running the following lines! +ALTER TABLE mm_email MODIFY mailtime datetime NULL; +ALTER TABLE mm_email MODIFY buildtime datetime NULL; +ALTER TABLE mm_email MODIFY repeattime datetime NULL; +ALTER TABLE mm_email MODIFY mailedtime datetime NULL; + +ALTER TABLE live_email MODIFY mailtime datetime NULL; +ALTER TABLE live_email MODIFY buildtime datetime NULL; +ALTER TABLE live_email MODIFY repeattime datetime NULL; +ALTER TABLE live_email MODIFY mailedtime datetime NULL; +--- End --- +Exceptions/errors/other problems and what to do: +* +* +* _______________________________________________ Cvs mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/cvs
