Author: kevinshen Date: 2010-02-04 08:32:37 +0100 (Thu, 04 Feb 2010) New Revision: 40860
Added: CMSContainer/branches/b1_5/CMSContainer/migration/migration_1.5.14_to_1.5.15.txt Log: CMSC-1634 Newsletter: check and improve the subscriptionrecord builder Added: CMSContainer/branches/b1_5/CMSContainer/migration/migration_1.5.14_to_1.5.15.txt =================================================================== --- CMSContainer/branches/b1_5/CMSContainer/migration/migration_1.5.14_to_1.5.15.txt (rev 0) +++ CMSContainer/branches/b1_5/CMSContainer/migration/migration_1.5.14_to_1.5.15.txt 2010-02-04 07:32:37 UTC (rev 40860) @@ -0,0 +1,20 @@ +Migration document: + +From version: 1.5.14 +To version: 1.5.15 + + +Name: Alter two fields of the table subscriptionrecord +Goal: Change the type of the two fields +Type: sql-script +--- Start script --- +ALTER TABLE mm_subscriptionrecord MODIFY subscriber VARCHAR(11) +ALTER TABLE mm_subscriptionrecord MODIFY format VARCHAR(256) + +ALTER TABLE live_subscriptionrecord MODIFY subscriber VARCHAR(11) +ALTER TABLE live_subscriptionrecord MODIFY format VARCHAR(256) + +--- End script --- +Exceptions/errors/other problems and what to do: +* +* _______________________________________________ Cvs mailing list Cvs@lists.mmbase.org http://lists.mmbase.org/mailman/listinfo/cvs