[ljcom] r11895: LJSUP-12092: Error when save individual ...

U   trunk/bin/upgrading/update-db-local.pl

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2012-05-05 07:47:05 UTC (rev 11894)
+++ trunk/bin/upgrading/update-db-local.pl	2012-05-05 08:23:03 UTC (rev 11895)
@@ -1148,6 +1148,7 @@
   `visibility` char(1) NOT NULL DEFAULT 'D',
   `is_enabled` tinyint(4) DEFAULT '0',
   `img_src` varchar(200) NOT NULL,
+  `individ_buyer` varchar(15) default '',
   PRIMARY KEY (`uh_id`)
 )
 EOC
@@ -2331,6 +2332,11 @@
                  "ALTER TABLE shop_userheads MODIFY uh_desc_sup VARCHAR(200) DEFAULT ''");
     }
 
+    unless (column_type("shop_userheads", "individ_buyer")) {
+        do_alter("shop_userheads",
+                "ALTER TABLE shop_userheads ADD individ_buyer VARCHAR(15) NOT NULL DEFAULT ''");
+    }
+
     unless (column_type("smsru_phones", "phone") =~ /char/i) {
         do_alter("smsru_phones",
             "ALTER TABLE smsru_phones MODIFY phone VARCHAR(12)");