[ljcom] r7163: LJSUP-4053: personifi sql tables.

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

Modified: trunk/bin/upgrading/update-db-local.pl
===================================================================
--- trunk/bin/upgrading/update-db-local.pl	2009-03-26 11:43:10 UTC (rev 7162)
+++ trunk/bin/upgrading/update-db-local.pl	2009-03-26 11:49:18 UTC (rev 7163)
@@ -1157,6 +1157,47 @@
 
 EOC
 
+
+# list of personifi categories.
+register_tablecreate("personifi_categories", <<'EOC');
+CREATE TABLE `personifi_categories` (
+  `catid` int(11) NOT NULL auto_increment,
+  `name` varchar(255) default NULL,
+  PRIMARY KEY  (`catid`),
+  UNIQUE KEY `catid` (`catid`),
+  UNIQUE KEY `name` (`name`)
+) TYPE=InnoDB
+EOC
+
+# list of personifi categories to be used in ads
+register_tablecreate("personifi_ads_cat", <<'EOC');
+CREATE TABLE `personifi_ads_cat` (
+  `catid` int(11) NOT NULL default '0',
+  `tagname` varchar(10) default NULL,
+  `threshold` int(11) default '100',
+  `enabled` tinyint(4) default NULL,
+  PRIMARY KEY  (`catid`),
+  UNIQUE KEY `catid` (`catid`)
+) TYPE=InnoDB
+EOC
+
+# list of personifi categories to be used in ads
+register_tablecreate("personifi_logs", <<'EOC');
+CREATE TABLE `personifi_logs` (
+  `userid` int(11) NOT NULL default '0',
+  `action` varchar(50) default NULL,
+  `catid` int(11) NOT NULL default '0',
+  `field` varchar(24) default NULL,
+  `oldval` varchar(255) default NULL,
+  `newval` varchar(255) default NULL,
+  `action_time` timestamp,
+  INDEX(action_time)
+) TYPE=InnoDB
+EOC
+
+
+
+# *************************************************************
 register_alter(sub {
 
     unless (column_type("sup_sponsors", "decline_duration")) {