[DW-Changelog] dw-free: http://bugs.dwscoalition.org/show_bug.cgi?id=3530

[Dreamwidth Changelog]

        Fix absurdly long varchar definition.

        Patch by exor674. 

diffs (22 lines):

diff -r e17770214bbf -r b79f5e330c01 bin/upgrading/update-db-general.pl
--- a/bin/upgrading/update-db-general.pl        Wed Feb 23 20:23:30 2011 +0800
+++ b/bin/upgrading/update-db-general.pl        Thu Feb 24 12:08:50 2011 +0800
@@ -3920,7 +3920,7 @@ EOF
     }
 
     unless ( column_type( 'acctcode_promo', 'paid_class' ) ) {
-        do_alter( 'acctcode_promo', "ALTER TABLE acctcode_promo ADD COLUMN 
paid_class varchar(10000)" );
+        do_alter( 'acctcode_promo', "ALTER TABLE acctcode_promo ADD COLUMN 
paid_class varchar(100)" );
     }
 
     unless ( column_type( 'acctcode_promo', 'paid_months' ) ) {
@@ -3947,6 +3947,9 @@ EOF
         set_dbnote( "init_vgift_counts", 1 );
     }
 
+    unless ( column_type( 'acctcode_promo', 'paid_class' ) =~ 
/^\Qvarchar(100)\E/ ) {
+        do_alter( 'acctcode_promo', "ALTER TABLE acctcode_promo MODIFY COLUMN 
paid_class varchar(100)" );
+    }
 });
 
 
_______________________________________________
dw-changelog mailing list
dw-changelog@lists.dwscoalition.org
http://lists.dwscoalition.org/mailman/listinfo/dw-changelog