Wikipedia

User:XLinkBot/Code/SQL

< User:XLinkBot‎ | Code

Two SQL-dumps of the database structures:

XLinkBot edit 

-- 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 edit 

-- 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 ;
Retrieved from "https://en.wikipedia.org/w/index.php?title=User:XLinkBot/Code/SQL&oldid=226469771"