Author: kevinshen Date: 2010-02-04 08:31:59 +0100 (Thu, 04 Feb 2010) New Revision: 40858
Modified: CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt Log: CMSC-1634 Newsletter: check and improve the subscriptionrecord builder Modified: CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt =================================================================== --- CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt 2010-02-04 07:25:25 UTC (rev 40857) +++ CMSContainer/trunk/CMSContainer/migration/migration_1.7_to_1.8.txt 2010-02-04 07:31:59 UTC (rev 40858) @@ -44,3 +44,17 @@ * * * +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: +* +* \ No newline at end of file _______________________________________________ Cvs mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/cvs
