Committer: wisest-owl
LJSUP-12092: Error when save individual userpicU 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)");