User:XLinkBot/Code/SQL

Two SQL-dumps of the database structures:

XLinkBot
-- phpMyAdmin SQL Dump -- version 2.7.0-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 18, 2008 at 12:10 PM -- Server version: 5.0.18 -- PHP Version: 5.1.1 -- -- Database: `squelchbot` --

--

-- -- Table structure for table `authorized_bots` --

CREATE TABLE `authorized_bots` ( `bot_name` varchar(16) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `blacklist` --

CREATE TABLE `blacklist` ( `id` mediumint(9) NOT NULL auto_increment,  `rule` varchar(255) default NULL,  `exempt` varchar(20) default NULL,  `cloak` varchar(25) default NULL,  `reason` varchar(255) default NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=331 ;

--

-- -- Table structure for table `freehost` --

CREATE TABLE `freehost` ( `rule` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- -- Table structure for table `hard_overrides` --

CREATE TABLE `hard_overrides` ( `id` int(11) NOT NULL auto_increment,  `rule` varchar(50) default NULL,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--

-- -- Table structure for table `log` --

CREATE TABLE `log` ( `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,  `message` varchar(255) default NULL,  FULLTEXT KEY `message` (`message`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `media` --

CREATE TABLE `media` ( `rule` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- -- Table structure for table `overrides` --

CREATE TABLE `overrides` ( `rule` varchar(50) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `payperview` --

CREATE TABLE `payperview` ( `rule` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- -- Table structure for table `petition` --

CREATE TABLE `petition` ( `rule` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- -- Table structure for table `quarantine` --

CREATE TABLE `quarantine` ( `rule` varchar(255) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `rules_stats` --

CREATE TABLE `rules_stats` ( `rule` varchar(50) default NULL,  `count` int(5) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `trusted_users` --

CREATE TABLE `trusted_users` ( `user_cloak` varchar(50) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `users` --

CREATE TABLE `users` ( `user_name` varchar(50) default NULL,  `user_time` varchar(15) default NULL,  `user_level` varchar(2) default NULL,  KEY `user_time` (`user_time`),  KEY `user_name` (`user_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `watched_rules` --

CREATE TABLE `watched_rules` ( `rule` varchar(30) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

linkwatcher
-- phpMyAdmin SQL Dump -- version 2.7.0-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 18, 2008 at 12:13 PM -- Server version: 5.0.18 -- PHP Version: 5.1.1 -- -- Database: `linkwatcher` --

--

-- -- Table structure for table `crawler` --

CREATE TABLE `crawler` ( `id` bigint(20) NOT NULL auto_increment,  `value` bigint(20) NOT NULL,  UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--

-- -- Table structure for table `crawlwikis` --

CREATE TABLE `crawlwikis` ( `wiki` varchar(50) NOT NULL,  `minimum` bigint(20) NOT NULL default '0',  PRIMARY KEY  (`wiki`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- -- Table structure for table `linkwatcher_blacklist` --

CREATE TABLE `linkwatcher_blacklist` ( `id` bigint(9) NOT NULL auto_increment,  `rule` varchar(255) default NULL,  `cloak` varchar(25) default NULL,  `reason` varchar(255) default NULL,  PRIMARY KEY  (`id`),  KEY `rule` (`rule`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=338 ;

--

-- -- Table structure for table `linkwatcher_newlinklog` --

CREATE TABLE `linkwatcher_newlinklog` ( `id` int(11) NOT NULL auto_increment,  `timestamp` timestamp NULL default CURRENT_TIMESTAMP,  `edit_id` bigint(20) NOT NULL,  `lang` varchar(20) NOT NULL,  `wikidomain` varchar(10) NOT NULL,  `namespace` varchar(10) NOT NULL,  `pagename` tinytext,  `diff` varchar(255) default NULL,  `user` varchar(255) default NULL,  `revid` bigint(20) NOT NULL,  `oldid` bigint(20) NOT NULL,  `fullurl` varchar(255) NOT NULL,  `domain` varchar(255) NOT NULL,  `indexedlink` varchar(255) NOT NULL,  `resolved` varchar(15) NOT NULL,  `ip` tinyint(4) NOT NULL,  PRIMARY KEY  (`id`),  KEY `user` (`user`),  KEY `diff` (`diff`),  KEY `fullurl` (`fullurl`),  KEY `domain` (`domain`),  KEY `index` (`indexedlink`),  KEY `revid` (`revid`),  KEY `lang` (`lang`),  KEY `oldid` (`oldid`),  KEY `wikidomain` (`wikidomain`),  KEY `namespace` (`namespace`),  KEY `resolved` (`resolved`), KEY `edit_id` (`edit_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8910727 ;

--

-- -- Table structure for table `linkwatcher_redlist` --

CREATE TABLE `linkwatcher_redlist` ( `rule` varchar(255) default NULL,  `cloak` varchar(25) default NULL,  `reason` varchar(255) default NULL,  KEY `rule` (`rule`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

-- -- Table structure for table `linkwatcher_users` --

CREATE TABLE `linkwatcher_users` ( `id` smallint(6) NOT NULL auto_increment,  `username` tinytext,  `status` tinytext,  PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8294 ;

--

-- -- Table structure for table `linkwatcher_whitelist` --

CREATE TABLE `linkwatcher_whitelist` ( `id` bigint(4) NOT NULL auto_increment,  `rule` varchar(255) default NULL,  `cloak` varchar(100) default NULL,  `reason` varchar(255) default NULL,  PRIMARY KEY  (`id`),  UNIQUE KEY `rule` (`rule`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=145 ;