/*

CREATE DATABASE `easyspider` ;
DROP TABLE IF EXISTS `easyspider`;
CREATE TABLE `easyspider`;


*/



CREATE TABLE `easyspider` (
  `date` varchar(30) NOT NULL default '',
  `url`  varchar(255) NOT NULL default '',
   
  `metakeys_keywords` text NOT NULL default '',
  `metakeys_description` text NOT NULL default '',
  `metakeys_author` varchar(250) NOT NULL default '',
  `metakeys_rest` text NOT NULL default '',
       
  `title` text NOT NULL default '',
  
  `h1` text NOT NULL default '',
  `h2` text NOT NULL default '',
  `h3` text NOT NULL default '',
  `h4` text NOT NULL default '',
  `h5` text NOT NULL default '',
  `h6` text NOT NULL default '',

  `region_name1` varchar(255) NOT NULL default '',  
  `region_content1` text NOT NULL default '',  
  `region_name2` varchar(255) NOT NULL default '',  
  `region_content2` text NOT NULL default '', 
  `region_name3` varchar(255) NOT NULL default '',  
  `region_content3` text NOT NULL default '', 
  `region_name4` varchar(255) NOT NULL default '',  
  `region_content4` text NOT NULL default '', 
  `region_name5` varchar(255) NOT NULL default '',  
  `region_content5` text NOT NULL default '', 
   
  `gewichtung_50` text NOT NULL default '',  
  `gewichtung_30` text NOT NULL default '',  
  `gewichtung_15` text NOT NULL default '',  
  `gewichtung_5` text NOT NULL default '',  
  
  `links` text NOT NULL default '',  
  
  `id` int(33) NOT NULL auto_increment,
  
  PRIMARY KEY  (`id`),
  
  FULLTEXT KEY `date` (`date`),
  FULLTEXT KEY `url` (`url`),  
  FULLTEXT KEY `metakeys_keywords` (`metakeys_keywords`),
  FULLTEXT KEY `metakeys_description` (`metakeys_description`),
  FULLTEXT KEY `metakeys_author` (`metakeys_author`),
  FULLTEXT KEY `metakeys_rest` (`metakeys_rest`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `h1` (`h1`),
  FULLTEXT KEY `h2` (`h2`),
  FULLTEXT KEY `h3` (`h3`),
  FULLTEXT KEY `h4` (`h4`),
  FULLTEXT KEY `h5` (`h5`),
  FULLTEXT KEY `h6` (`h6`),
  FULLTEXT KEY `region_name1` (`region_name1`), 
  FULLTEXT KEY `region_content1` (`region_content1`), 
  FULLTEXT KEY `region_name2` (`region_name2`), 
  FULLTEXT KEY `region_content2` (`region_content2`), 
  FULLTEXT KEY `region_name3` (`region_name3`), 
  FULLTEXT KEY `region_content3` (`region_content3`), 
  FULLTEXT KEY `region_name4` (`region_name4`), 
  FULLTEXT KEY `region_content4` (`region_content4`), 
  FULLTEXT KEY `region_name5` (`region_name5`), 
  FULLTEXT KEY `region_content5` (`region_content5`), 
  FULLTEXT KEY `gewichtung_50` (`gewichtung_50`), 
  FULLTEXT KEY `gewichtung_30` (`gewichtung_30`), 
  FULLTEXT KEY `gewichtung_15` (`gewichtung_15`), 
  FULLTEXT KEY `gewichtung_5` (`gewichtung_5`), 
  FULLTEXT KEY `links` (`links`)
   
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;