-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-4
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Oct 30, 2007 at 04:25 PM
-- Server version: 5.0.32
-- PHP Version: 5.2.0-8+etch7
-- 
-- Database: `fastss2`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `1precalc_b`
-- 

CREATE TABLE `1precalc_b` (
  `precalc` int(11) unsigned NOT NULL,
  `wid` mediumint(7) unsigned NOT NULL,
  `distance` tinyint(3) unsigned NOT NULL,
  KEY `precalc` (`precalc`,`distance`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `1precalc_opt`
-- 

CREATE TABLE `1precalc_opt` (
  `precalc` int(11) unsigned NOT NULL,
  `wid` mediumint(7) unsigned NOT NULL,
  KEY `precalc` (`precalc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `2precalc_b`
-- 

CREATE TABLE `2precalc_b` (
  `precalc` int(11) unsigned NOT NULL,
  `wid` mediumint(7) unsigned NOT NULL,
  `distance` smallint(5) unsigned NOT NULL,
  KEY `precalc` (`precalc`,`distance`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `2precalc_opt`
-- 

CREATE TABLE `2precalc_opt` (
  `precalc` int(11) unsigned NOT NULL,
  `wid` mediumint(7) unsigned NOT NULL,
  KEY `precalc` (`precalc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `page`
-- 

CREATE TABLE `page` (
  `page_id` int(8) unsigned NOT NULL default '0',
  `page_namespace` int(11) NOT NULL default '0',
  `page_title` varchar(255) character set latin1 collate latin1_bin NOT NULL default '',
  `page_restrictions` tinyblob NOT NULL,
  `page_counter` bigint(20) unsigned NOT NULL default '0',
  `page_is_redirect` tinyint(1) unsigned NOT NULL default '0',
  `page_is_new` tinyint(1) unsigned NOT NULL default '0',
  `page_random` double unsigned NOT NULL default '0',
  `page_touched` varchar(14) character set latin1 collate latin1_bin NOT NULL default '',
  `page_latest` int(8) unsigned NOT NULL default '0',
  `page_len` int(8) unsigned NOT NULL default '0',
  UNIQUE KEY `page_latest` (`page_latest`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `text`
-- 

CREATE TABLE `text` (
  `tid` int(8) unsigned NOT NULL,
  `old_text` mediumtext character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`tid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `wordcount`
-- 

CREATE TABLE `wordcount` (
  `wid` mediumint(8) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `cnt` mediumint(8) unsigned NOT NULL,
  `position` mediumint(8) unsigned NOT NULL,
  KEY `wid` (`wid`,`cnt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `wordcount2`
-- 

CREATE TABLE `wordcount2` (
  `wid` mediumint(8) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `cnt` mediumint(8) unsigned NOT NULL,
  `position` mediumint(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `wordlist`
-- 

CREATE TABLE `wordlist` (
  `wid` mediumint(8) unsigned NOT NULL,
  `tid` int(10) unsigned NOT NULL,
  `position` mediumint(8) unsigned NOT NULL,
  KEY `wid` (`wid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `words`
-- 

CREATE TABLE `words` (
  `wid` mediumint(7) unsigned NOT NULL,
  `precalc` int(11) unsigned NOT NULL,
  `word` char(20) NOT NULL,
  PRIMARY KEY  (`wid`),
  UNIQUE KEY `word` (`word`),
  KEY `precalc` (`precalc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

