db41016m.sql

-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Host: mysql52.hoster.ru
-- Generation Time: Aug 26, 2011 at 08:47 PM
-- Server version: 5.5.1
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `db41016m`
--

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

--
-- Table structure for table `aids_bridge_to_english2`
--

DROP TABLE IF EXISTS `aids_bridge_to_english2`;
CREATE TABLE `aids_bridge_to_english2` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_cambridge_english_grammar`
--

DROP TABLE IF EXISTS `aids_cambridge_english_grammar`;
CREATE TABLE `aids_cambridge_english_grammar` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_effortless_english_lessons`
--

DROP TABLE IF EXISTS `aids_effortless_english_lessons`;
CREATE TABLE `aids_effortless_english_lessons` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_englishpod`
--

DROP TABLE IF EXISTS `aids_englishpod`;
CREATE TABLE `aids_englishpod` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_english_for_business_meetings`
--

DROP TABLE IF EXISTS `aids_english_for_business_meetings`;
CREATE TABLE `aids_english_for_business_meetings` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_english_for_russian_speakers`
--

DROP TABLE IF EXISTS `aids_english_for_russian_speakers`;
CREATE TABLE `aids_english_for_russian_speakers` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_essays`
--

DROP TABLE IF EXISTS `aids_essays`;
CREATE TABLE `aids_essays` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_golitsynsky_exercises2006`
--

DROP TABLE IF EXISTS `aids_golitsynsky_exercises2006`;
CREATE TABLE `aids_golitsynsky_exercises2006` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_golitsynsky_keys2004`
--

DROP TABLE IF EXISTS `aids_golitsynsky_keys2004`;
CREATE TABLE `aids_golitsynsky_keys2004` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_golitsynsky_keys2007`
--

DROP TABLE IF EXISTS `aids_golitsynsky_keys2007`;
CREATE TABLE `aids_golitsynsky_keys2007` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_golitsynsky_spoken_english1998`
--

DROP TABLE IF EXISTS `aids_golitsynsky_spoken_english1998`;
CREATE TABLE `aids_golitsynsky_spoken_english1998` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_grammar`
--

DROP TABLE IF EXISTS `aids_grammar`;
CREATE TABLE `aids_grammar` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_idiom_drills`
--

DROP TABLE IF EXISTS `aids_idiom_drills`;
CREATE TABLE `aids_idiom_drills` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_learning_english_words`
--

DROP TABLE IF EXISTS `aids_learning_english_words`;
CREATE TABLE `aids_learning_english_words` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_quizzes`
--

DROP TABLE IF EXISTS `aids_quizzes`;
CREATE TABLE `aids_quizzes` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_quotations_in_english`
--

DROP TABLE IF EXISTS `aids_quotations_in_english`;
CREATE TABLE `aids_quotations_in_english` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_rozentalorpho`
--

DROP TABLE IF EXISTS `aids_rozentalorpho`;
CREATE TABLE `aids_rozentalorpho` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_tests`
--

DROP TABLE IF EXISTS `aids_tests`;
CREATE TABLE `aids_tests` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_topics`
--

DROP TABLE IF EXISTS `aids_topics`;
CREATE TABLE `aids_topics` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_transcripts`
--

DROP TABLE IF EXISTS `aids_transcripts`;
CREATE TABLE `aids_transcripts` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `aids_visual_dictionary_online`
--

DROP TABLE IF EXISTS `aids_visual_dictionary_online`;
CREATE TABLE `aids_visual_dictionary_online` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_url` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `page_body` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `page_body` (`page_body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_enen_quotations`
--

DROP TABLE IF EXISTS `dict_enen_quotations`;
CREATE TABLE `dict_enen_quotations` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `entry` mediumtext NOT NULL,
  `author` mediumtext NOT NULL,
  `subject` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`),
  FULLTEXT KEY `author` (`author`),
  FULLTEXT KEY `subject` (`subject`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_enru_general`
--

DROP TABLE IF EXISTS `dict_enru_general`;
CREATE TABLE `dict_enru_general` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `entry` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`),
  FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_enru_keyboard_typo`
--

DROP TABLE IF EXISTS `dict_enru_keyboard_typo`;
CREATE TABLE `dict_enru_keyboard_typo` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `us_locale` mediumtext NOT NULL,
  `ru_locale` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `us_locale` (`us_locale`),
  FULLTEXT KEY `ru_locale` (`ru_locale`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_ruen_general`
--

DROP TABLE IF EXISTS `dict_ruen_general`;
CREATE TABLE `dict_ruen_general` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `entry` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`),
  FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_ruru_autocomplete`
--

DROP TABLE IF EXISTS `dict_ruru_autocomplete`;
CREATE TABLE `dict_ruru_autocomplete` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `entry` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dict_ruru_reverse`
--

DROP TABLE IF EXISTS `dict_ruru_reverse`;
CREATE TABLE `dict_ruru_reverse` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `entry` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `entry` (`entry`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_addressbook`
--

DROP TABLE IF EXISTS `pt_addressbook`;
CREATE TABLE `pt_addressbook` (
  `id` int(9) unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `home` text NOT NULL,
  `mobile` text NOT NULL,
  `work` text NOT NULL,
  `fax` text NOT NULL,
  `email` text NOT NULL,
  `email2` text NOT NULL,
  `homepage` text NOT NULL,
  `bday` tinyint(2) NOT NULL,
  `bmonth` tinyint(2) NOT NULL,
  `byear` varchar(4) NOT NULL,
  `address2` text NOT NULL,
  `phone2` text NOT NULL,
  `notes` text NOT NULL,
  `photo` mediumtext,
  `password` varchar(50) NOT NULL,
  `login` varchar(50) NOT NULL,
  `role` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_djvu`
--

DROP TABLE IF EXISTS `pt_djvu`;
CREATE TABLE `pt_djvu` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_title` mediumtext NOT NULL,
  `page_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_download`
--

DROP TABLE IF EXISTS `pt_download`;
CREATE TABLE `pt_download` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `title` mediumtext NOT NULL,
  `description` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `description` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_epub`
--

DROP TABLE IF EXISTS `pt_epub`;
CREATE TABLE `pt_epub` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_title` mediumtext NOT NULL,
  `page_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_externalcounters`
--

DROP TABLE IF EXISTS `pt_externalcounters`;
CREATE TABLE `pt_externalcounters` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `adddate` int(11) DEFAULT NULL,
  `random` varchar(50) DEFAULT NULL,
  `user_login` mediumtext NOT NULL,
  `referer` mediumtext NOT NULL,
  `self` mediumtext NOT NULL,
  `page_title` mediumtext NOT NULL,
  `browser` mediumtext NOT NULL,
  `number` mediumtext NOT NULL,
  `os` mediumtext NOT NULL,
  `os_number` mediumtext NOT NULL,
  `host` mediumtext NOT NULL,
  `ip` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_guestbook`
--

DROP TABLE IF EXISTS `pt_guestbook`;
CREATE TABLE `pt_guestbook` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `adddate` int(11) DEFAULT NULL,
  `user_login` varchar(40) DEFAULT NULL,
  `msg` mediumtext NOT NULL,
  `user_host` mediumtext NOT NULL,
  `user_ip` mediumtext NOT NULL,
  `self_title` mediumtext NOT NULL,
  `self_href` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `msg` (`msg`),
  FULLTEXT KEY `self_title` (`self_title`),
  FULLTEXT KEY `self_href` (`self_href`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_guestbook_demo`
--

DROP TABLE IF EXISTS `pt_guestbook_demo`;
CREATE TABLE `pt_guestbook_demo` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `adddate` int(11) DEFAULT NULL,
  `user_login` varchar(40) DEFAULT NULL,
  `msg` mediumtext NOT NULL,
  `user_host` mediumtext NOT NULL,
  `user_ip` mediumtext NOT NULL,
  `self_title` mediumtext NOT NULL,
  `self_href` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `msg` (`msg`),
  FULLTEXT KEY `self_title` (`self_title`),
  FULLTEXT KEY `self_href` (`self_href`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_guestbook_tuman`
--

DROP TABLE IF EXISTS `pt_guestbook_tuman`;
CREATE TABLE `pt_guestbook_tuman` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `adddate` int(11) DEFAULT NULL,
  `user_login` varchar(40) DEFAULT NULL,
  `msg` mediumtext NOT NULL,
  `user_host` mediumtext NOT NULL,
  `user_ip` mediumtext NOT NULL,
  `self_title` mediumtext NOT NULL,
  `self_href` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `msg` (`msg`),
  FULLTEXT KEY `self_title` (`self_title`),
  FULLTEXT KEY `self_href` (`self_href`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_pages`
--

DROP TABLE IF EXISTS `pt_pages`;
CREATE TABLE `pt_pages` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_title` mediumtext NOT NULL,
  `page_url` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `wordhash` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `wordhash` (`wordhash`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_pdf`
--

DROP TABLE IF EXISTS `pt_pdf`;
CREATE TABLE `pt_pdf` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `page_title` mediumtext NOT NULL,
  `page_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `page_title` (`page_title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pt_weekcalendar`
--

DROP TABLE IF EXISTS `pt_weekcalendar`;
CREATE TABLE `pt_weekcalendar` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `adddate` int(11) DEFAULT NULL,
  `start` mediumtext NOT NULL,
  `end` mediumtext NOT NULL,
  `title` mediumtext NOT NULL,
  `body` mediumtext NOT NULL,
  `user_host` mediumtext NOT NULL,
  `user_ip` mediumtext NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `body` (`body`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;