--- dbtables.live	2004-11-19 04:25:09.645467200 -0800
+++ dbtables.dev	2004-11-19 04:23:34.668897600 -0800
@@ -48 +48 @@ CREATE TABLE `links` (
-  KEY `tonode` (`to_node`,`linktype`)
+  UNIQUE KEY `to_node` (`to_node`,`linktype`)
@@ -71 +71 @@ CREATE TABLE `node` (
-  `nodeupdated` timestamp(14) NOT NULL,
+  `lastupdate` timestamp(14) NOT NULL,
@@ -82,0 +83,3 @@ CREATE TABLE `node` (
+  KEY `type_nodetype` (`type_nodetype`,`createtime`),
+  KEY `createtime` (`createtime`,`type_nodetype`),
+  KEY `author_user` (`author_user`),
@@ -84,3 +86,0 @@ CREATE TABLE `node` (
-  KEY `author` (`author_user`),
-  KEY `typecreatetime` (`type_nodetype`,`createtime`),
-  KEY `createtimetype` (`createtime`,`type_nodetype`),
@@ -95 +95,4 @@ CREATE TABLE `nodegroup` (
-  PRIMARY KEY  (`nodegroup_id`,`rank`)
+  PRIMARY KEY  (`nodegroup_id`,`rank`),
+  UNIQUE KEY `uidx_grp_node` (`nodegroup_id`,`node_id`),
+  KEY `idx_nodegroup_id` (`nodegroup_id`),
+  KEY `idx_node_id` (`node_id`)
@@ -142,0 +146 @@ CREATE TABLE `user` (
+  `scratchpadbackup` text,
@@ -212,2 +215,0 @@ CREATE TABLE `sourcecode` (
--- table relatednodes doesn't exist
-
@@ -227,2 +228,0 @@ CREATE TABLE `HTTP_USER_AGENT` (
--- table search words doesn't exist
-
@@ -245 +245 @@ CREATE TABLE `message` (
-  KEY `for_user` (`for_user`,`archive`,`tstamp`)
+  UNIQUE KEY `for_user` (`for_user`,`archive`,`tstamp`)
@@ -332 +332 @@ CREATE TABLE `cachedinfo` (
-  KEY `codeidAndKey` (`code_id`,`cachekey`(16))
+  UNIQUE KEY `codeidAndKey` (`code_id`,`cachekey`(50))
@@ -338,0 +339 @@ CREATE TABLE `keywords` (
+  `keyword_user` int(11) default NULL,
@@ -370,0 +372 @@ CREATE TABLE `considernodes` (
+  `considertype` enum('General','Title','Format','Move','Unapprove','Reap','Unreap','Reparent','Duplicate','OT') NOT NULL default 'General',
@@ -487,0 +490,9 @@ CREATE TABLE `ip` (
+CREATE TABLE `iplog` (
+  `ip_id` int(11) NOT NULL default '0',
+  `user_id` int(11) NOT NULL default '0',
+  `tstamp` timestamp(14) NOT NULL,
+  PRIMARY KEY  (`ip_id`,`user_id`),
+  KEY `ipuser` (`ip_id`,`user_id`),
+  KEY `user` (`user_id`)
+) TYPE=MyISAM
+
@@ -498,9 +508,0 @@ CREATE TABLE `approved` (
-CREATE TABLE `iplog` (
-  `ip_id` int(11) NOT NULL default '0',
-  `user_id` int(11) NOT NULL default '0',
-  `tstamp` timestamp(14) NOT NULL,
-  PRIMARY KEY  (`ip_id`,`user_id`),
-  KEY `ipuser` (`ip_id`,`user_id`),
-  KEY `user` (`user_id`)
-) TYPE=MyISAM
-
@@ -545,0 +548,3 @@ CREATE TABLE `scratchpad` (
+  `backupuser_id` int(11) default NULL,
+  `backuppublic` int(1) default NULL,
+  `backupprivatetext` text,
@@ -552 +557 @@ CREATE TABLE `scratchpad` (
-CREATE TABLE `approves` (
+CREATE TABLE `approvalhistory` (
@@ -557,0 +563 @@ CREATE TABLE `approves` (
+  UNIQUE KEY `uniqAppHist` (`approves_id`,`user_approves`,`whenapproves`),
@@ -562,20 +568,17 @@ CREATE TABLE `approves` (
-CREATE TABLE `dbstats` (
-  `stattype` smallint(6) NOT NULL default '0',
-  `duration` smallint(6) NOT NULL default '0',
-  `began` timestamp(14) NOT NULL,
-  `value` double default NULL,
-  PRIMARY KEY  (`stattype`,`duration`,`began`)
-) TYPE=MyISAM
-
-CREATE TABLE `dbstattype` (
-  `typecode` smallint(6) NOT NULL default '0',
-  `statabbr` varchar(20) default NULL,
-  `statdesc` varchar(80) default NULL,
-  `statcomment` text,
-  PRIMARY KEY  (`typecode`)
-) TYPE=MyISAM
-
-CREATE TABLE `dbstatduration` (
-  `durcode` smallint(6) NOT NULL default '0',
-  `durabbr` varchar(10) default NULL,
-  PRIMARY KEY  (`durcode`)
+CREATE TABLE `level` (
+  `level_id` int(11) NOT NULL auto_increment,
+  `levelnum` int(2) NOT NULL default '0',
+  `minxp` int(6) NOT NULL default '0',
+  `maxxp` int(6) NOT NULL default '0',
+  `votes` int(3) NOT NULL default '0',
+  `faq_id` int(11) default NULL,
+  PRIMARY KEY  (`level_id`),
+  UNIQUE KEY `uidx_levelnum` (`levelnum`)
+) TYPE=MyISAM
+
+CREATE TABLE `approvalstatus` (
+  `approved_id` int(11) NOT NULL default '0',
+  `user_approved` int(11) default NULL,
+  `whenapproved` timestamp(14) NOT NULL,
+  `status` varchar(4) default NULL,
+  PRIMARY KEY  (`approved_id`)
@@ -598,8 +600,0 @@ CREATE TABLE `picked_nodes` (
-CREATE TABLE `approval` (
-  `approved_id` int(11) NOT NULL default '0',
-  `user_approved` int(11) default NULL,
-  `whenapproved` timestamp(14) NOT NULL,
-  `status` varchar(4) default NULL,
-  PRIMARY KEY  (`approved_id`)
-) TYPE=MyISAM
-