vadvs (vadvs) wrote in changelog,
vadvs
vadvs
changelog

[ljcom] r8248: move alter command to appropriate place

Committer: vsukhanov
move alter command to appropriate place
U   trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2010-03-04 06:34:41 UTC (rev 8247)
+++ trunk/bin/upgrading/update-db-local.pl	2010-03-04 06:35:54 UTC (rev 8248)
@@ -1747,6 +1747,13 @@
                 "ALTER TABLE shop_vgifts ADD COLUMN max_age int(10) UNSIGNED DEFAULT NULL"
         );
     }
+
+    unless (column_type("recbill_cc", "addr") eq 'varchar(120)') {
+        do_alter("recbill_cc",
+                 "ALTER TABLE recbill_cc " .
+                 "CHANGE addr addr varchar(120) NOT NULL");
+    }
+
 });
 
 1;  # true

Tags: ljcom, pl, vadvs
Subscribe

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments