Author: kevinshen
Date: 2010-02-04 08:32:19 +0100 (Thu, 04 Feb 2010)
New Revision: 40859
Modified:
CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.7.1_to_1.7.2.txt
Log:
CMSC-1634 Newsletter: check and improve the subscriptionrecord builder
Modified:
CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.7.1_to_1.7.2.txt
===================================================================
---
CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.7.1_to_1.7.2.txt
2010-02-04 07:31:59 UTC (rev 40858)
+++
CMSContainer/branches/b1_7/CMSContainer/migration/migration_1.7.1_to_1.7.2.txt
2010-02-04 07:32:19 UTC (rev 40859)
@@ -45,3 +45,18 @@
*
*
*
+
+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
