[% my @links = split /^/, q!ArthurTwoShedsJackson BuryingtheCat Cinema-TelevisionInterview GavinMillarrrrrWrites IveGotTwoLegs JohannGambolputty...ofUlm Me,Doctor MedicalLove MissAnneElk NudgeNudge,KnowWhatIMean OriginalBookshopSketch RockNotes Self-defenseAgainstFruit SermonontheMount SpottheBrainCell St.VictorofPython StakeYourClaims TheAdvertisingSketch TheAirlinePilotsSketch TheAlbatrossSketch TheArchitectSketch TheArgumentClinicSketch TheAustralianTableWineSketch TheBanterSketch TheBarberShopSketch TheBicycleRepairManSketch TheBlackmailSketch TheBlessingfromtheLord TheBookshopSketch TheBraveandBoldSirRobin TheBruces TheBuyingtheBedSketch TheCheeseShopSketch TheChurchBells TheCompleteSwampCastle TheContradictionSketch TheCrunchyFrogSketch TheCyclingSketch TheDeadBishopSketch TheDeadParrotSketch TheDinosaurSketch TheElectionSketch TheFishLicenceSketch TheHagglingSketch TheHairDressersonMtEverest TheHungarianPhrasebookSketch TheKnightsWhoSayNi TheLifeboatSketch TheManWhoSpeaksinAnagrams TheManwithThreeButtocks TheMenBeingEatenbyaCrocodile TheMoneyProgrammeSketch TheNewsforParrots TheNorthMineheadBye-election TheOvineAviationSketch ThePackageTourComplaint ThePenguinSketch ThePetShopSketch-1video ThePetShopSketch-2 ThePiranhaBrothersStory TheRalphMellishStory TheSheepintheTreesSketch TheSpamSketch TheSpanishInquisitionSketch TheStorySoFar TheStringSketch TheTaleofSirGalahad TheTaleofSirLancelot TheUndertakerSketch TheWeAreSoPoorSketch TheWoodySketch WordAssociationFootball!; $links[rand @links] %] #### --- 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 -