[ljcom] r12822: LJSUP-13388: LJ Shop - Styles

U   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,