[ljcom] r12864: LJSUP-14163: Store history of limit soci...

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

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2012-11-01 14:44:24 UTC (rev 12863)
+++ trunk/bin/upgrading/update-db-local.pl	2012-11-02 06:38:54 UTC (rev 12864)
@@ -667,6 +667,18 @@
 )
 EOC
 
+register_tablecreate('paidrepost_settings_history', <<'EOC');
+CREATE TABLE `paidrepost_settings_history` (
+  `accid` int(11) NOT NULL AUTO_INCREMENT,
+  `userid` int(11) NOT NULL DEFAULT '0',
+  `param` enum('limit_sc') NOT NULL,
+  `value` varchar(30) NOT NULL,                                            
+  `timestamp` int(11) NOT NULL DEFAULT '0',
+  KEY `accid` (`accid`),
+  KEY `userid` (`userid`)
+)
+EOC
+
 register_tablecreate('paiduser', <<'EOC');
 CREATE TABLE `paiduser` (
   `userid` int(10) unsigned NOT NULL,