Committer: wisest-owl
LJSUP-13388: LJ Shop - StylesU trunk/bin/upgrading/update-db-local.pl
Modified: trunk/bin/upgrading/update-db-local.pl =================================================================== --- trunk/bin/upgrading/update-db-local.pl 2012-10-24 13:49:08 UTC (rev 12821) +++ trunk/bin/upgrading/update-db-local.pl 2012-10-24 14:50:49 UTC (rev 12822) @@ -1213,6 +1213,48 @@ ) EOC +register_tablecreate('shop_themes', <<'EOC'); +CREATE TABLE `shop_themes` ( + `t_id` int(11) NOT NULL auto_increment, + `t_name` varchar(30) default NULL, + `t_descr` varchar(200) default NULL, + `author` varchar(15) default NULL, + `owner` varchar(15) default NULL, + `price_default` int(10) unsigned default NULL, + `price_buyout` int(10) unsigned default NULL, + `paid_discount` int(10) unsigned default NULL, + `pos` int(10) unsigned default '0', + `is_disabled` tinyint(1) default '1', + `time_create` datetime default NULL, + `user_create` varchar(15) default NULL, + `available_for` tinyint(3) unsigned default NULL, + `bought_cnt` int(11) NOT NULL default '0', + `version` int(11) NOT NULL, + `s2lid` int(10) unsigned default NULL, + `s2tid` int(10) unsigned default NULL, + PRIMARY KEY (`t_id`), + UNIQUE KEY `s2tid` (`s2tid`), + KEY `available_for` (`available_for`) +) +EOC + +register_tablecreate('shop_themes_cats', <<'EOC'); +CREATE TABLE `shop_themes_cats` ( + `t_id` int(11) NOT NULL, + `cat_name` varchar(20) NOT NULL default '', + UNIQUE KEY `t_id` (`t_id`,`cat_name`) +) +EOC + +register_tablecreate('shop_themes_files', <<'EOC'); +CREATE TABLE `shop_themes_files` ( + `t_id` int(11) NOT NULL, + `filename` varchar(200) NOT NULL, + `type` varchar(10) NOT NULL default '', + KEY `t_id` (`t_id`) +) +EOC + register_tablecreate('sms_promo', <<'EOC'); CREATE TABLE `sms_promo` ( `userid` int(10) unsigned NOT NULL,