[%
my @links = split /^/,
q!<a href="http://www.serve.com/bonzai/monty/classics/ArthurTwoShedsJa
+ckson">ArthurTwoShedsJackson</a>
<a href="http://www.serve.com/bonzai/monty/classics/BuryingtheCat">Bur
+yingtheCat</a>
<a href="http://www.serve.com/bonzai/monty/classics/Cinema-TelevisionI
+nterview">Cinema-TelevisionInterview</a>
<a href="http://www.serve.com/bonzai/monty/classics/GavinMillarrrrrWri
+tes">GavinMillarrrrrWrites</a>
<a href="http://www.serve.com/bonzai/monty/classics/IveGotTwoLegs">Ive
+GotTwoLegs</a>
<a href="http://www.serve.com/bonzai/monty/classics/JohannGambolputty.
+..ofUlm">JohannGambolputty...ofUlm</a>
<a href="http://www.serve.com/bonzai/monty/classics/Me,Doctor">Me,Doct
+or</a>
<a href="http://www.serve.com/bonzai/monty/classics/MedicalLove">Medic
+alLove</a>
<a href="http://www.serve.com/bonzai/monty/classics/MissAnneElk">MissA
+nneElk</a>
<a href="http://www.serve.com/bonzai/monty/classics/NudgeNudge,KnowWha
+tIMean">NudgeNudge,KnowWhatIMean</a>
<a href="http://www.serve.com/bonzai/monty/classics/OriginalBookshopSk
+etch">OriginalBookshopSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/RockNotes">RockNot
+es</a>
<a href="http://www.serve.com/bonzai/monty/classics/Self-defenseAgains
+tFruit">Self-defenseAgainstFruit</a>
<a href="http://www.serve.com/bonzai/monty/classics/SermonontheMount">
+SermonontheMount</a>
<a href="http://www.serve.com/bonzai/monty/classics/SpottheBrainCell">
+SpottheBrainCell</a>
<a href="http://www.serve.com/bonzai/monty/classics/St.VictorofPython"
+>St.VictorofPython</a>
<a href="http://www.serve.com/bonzai/monty/classics/StakeYourClaims">S
+takeYourClaims</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheAdvertisingSket
+ch">TheAdvertisingSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheAirlinePilotsSk
+etch">TheAirlinePilotsSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheAlbatrossSketch
+">TheAlbatrossSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheArchitectSketch
+">TheArchitectSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheArgumentClinicS
+ketch">TheArgumentClinicSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheAustralianTable
+WineSketch">TheAustralianTableWineSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBanterSketch">T
+heBanterSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBarberShopSketc
+h">TheBarberShopSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBicycleRepairMa
+nSketch">TheBicycleRepairManSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBlackmailSketch
+">TheBlackmailSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBlessingfromthe
+Lord">TheBlessingfromtheLord</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBookshopSketch"
+>TheBookshopSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBraveandBoldSir
+Robin">TheBraveandBoldSirRobin</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBruces">TheBruc
+es</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheBuyingtheBedSke
+tch">TheBuyingtheBedSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheCheeseShopSketc
+h">TheCheeseShopSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheChurchBells">Th
+eChurchBells</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheCompleteSwampCa
+stle">TheCompleteSwampCastle</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheContradictionSk
+etch">TheContradictionSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheCrunchyFrogSket
+ch">TheCrunchyFrogSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheCyclingSketch">
+TheCyclingSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheDeadBishopSketc
+h">TheDeadBishopSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheDeadParrotSketc
+h">TheDeadParrotSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheDinosaurSketch"
+>TheDinosaurSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheElectionSketch"
+>TheElectionSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheFishLicenceSket
+ch">TheFishLicenceSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheHagglingSketch"
+>TheHagglingSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheHairDressersonM
+tEverest">TheHairDressersonMtEverest</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheHungarianPhrase
+bookSketch">TheHungarianPhrasebookSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheKnightsWhoSayNi
+">TheKnightsWhoSayNi</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheLifeboatSketch"
+>TheLifeboatSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheManWhoSpeaksinA
+nagrams">TheManWhoSpeaksinAnagrams</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheManwithThreeBut
+tocks">TheManwithThreeButtocks</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheMenBeingEatenby
+aCrocodile">TheMenBeingEatenbyaCrocodile</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheMoneyProgrammeS
+ketch">TheMoneyProgrammeSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheNewsforParrots"
+>TheNewsforParrots</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheNorthMineheadBy
+e-election">TheNorthMineheadBye-election</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheOvineAviationSk
+etch">TheOvineAviationSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/ThePackageTourComp
+laint">ThePackageTourComplaint</a>
<a href="http://www.serve.com/bonzai/monty/classics/ThePenguinSketch">
+ThePenguinSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/ThePetShopSketch-1
+">ThePetShopSketch-1</a><a href="http://www.youtube.com/watch?v=npjOS
+LCR2hE">video</a>
<a href="http://www.serve.com/bonzai/monty/classics/ThePetShopSketch-2
+">ThePetShopSketch-2</a>
<a href="http://www.serve.com/bonzai/monty/classics/ThePiranhaBrothers
+Story">ThePiranhaBrothersStory</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheRalphMellishSto
+ry">TheRalphMellishStory</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheSheepintheTrees
+Sketch">TheSheepintheTreesSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheSpamSketch">The
+SpamSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheSpanishInquisit
+ionSketch">TheSpanishInquisitionSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheStorySoFar">The
+StorySoFar</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheStringSketch">T
+heStringSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheTaleofSirGalaha
+d">TheTaleofSirGalahad</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheTaleofSirLancel
+ot">TheTaleofSirLancelot</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheUndertakerSketc
+h">TheUndertakerSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheWeAreSoPoorSket
+ch">TheWeAreSoPoorSketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/TheWoodySketch">Th
+eWoodySketch</a>
<a href="http://www.serve.com/bonzai/monty/classics/WordAssociationFoo
+tball">WordAssociationFootball</a>!;
$links[rand @links]
%]
[download]

--- 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`,`whenapprov
+es`),
@@ -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
-
[download]