[Summary view] [Print] [Text view]

   1  DROP TABLE IF EXISTS `full_text_uri_content_index`;
   2  CREATE TABLE `full_text_uri_content_index` (
   3    `id` bigint(20) NOT NULL auto_increment,
   4    `uri` varchar(150) NOT NULL default '',
   5    `content` text NOT NULL,
   6    `last_modified` bigint(20) default NULL,
   7    `title` varchar(255) NOT NULL default '',
   8    PRIMARY KEY  (`id`),
   9    KEY `uri` (`uri`),
  10    FULLTEXT KEY `content` (`content`)
  11  ) TYPE=MyISAM DEFAULT CHARSET=utf8;