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

-- 
-- Table structure for table 'bad_keywords'
-- 

CREATE TABLE bad_keywords (
  id int(11) NOT NULL auto_increment,
  keyword text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'banned'
-- 

CREATE TABLE banned (
  id int(11) NOT NULL auto_increment,
  domain text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'categories'
-- 

CREATE TABLE categories (
  id int(11) NOT NULL auto_increment,
  parent int(11) default NULL,
  title text collate utf8_unicode_ci,
  path text collate utf8_unicode_ci,
  description text collate utf8_unicode_ci,
  keywords text collate utf8_unicode_ci,
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'config'
-- 

CREATE TABLE config (
  version int(11) NOT NULL default '0',
  title text collate utf8_unicode_ci NOT NULL,
  description text collate utf8_unicode_ci NOT NULL,
  keywords text collate utf8_unicode_ci NOT NULL,
  email text collate utf8_unicode_ci NOT NULL,
  admin text collate utf8_unicode_ci NOT NULL,
  recip_regex text collate utf8_unicode_ci NOT NULL,
  recip_required tinyint(4) NOT NULL default '0',
  captcha tinyint(4) NOT NULL default '0',
  new_links int(11) NOT NULL default '0',
  recip_links int(11) NOT NULL default '0',
  sub_cat_num int(11) NOT NULL default '0',
  num_links tinyint(4) NOT NULL default '10',
  num_pages tinyint(4) NOT NULL default '25',
  chars_title int(11) NOT NULL default '100',
  chars_desc int(11) NOT NULL default '500',
  addurl_gpr tinyint(4) NOT NULL default '0',
  spider_FollowMode tinyint(4) NOT NULL default '2',
  spider_FollowMatch text collate utf8_unicode_ci NOT NULL,
  spider_NonFollowMatch text collate utf8_unicode_ci NOT NULL,
  spider_FollowRedirects tinyint(4) NOT NULL default '1',
  spider_FollowRedirectsTillContent tinyint(4) NOT NULL default '1',
  spider_ReceiveContentType tinytext collate utf8_unicode_ci NOT NULL,
  spider_PageLimit int(11) NOT NULL default '0',
  spider_TrafficLimit int(11) NOT NULL default '0',
  spider_ContentSizeLimit int(11) NOT NULL default '0',
  spider_ConnectionTimeout int(11) NOT NULL default '10',
  spider_StreamTimeout int(11) NOT NULL default '2',
  spider_CookieHandling tinyint(4) NOT NULL default '1',
  spider_UserAgent tinytext collate utf8_unicode_ci NOT NULL,
  spider_TitleMax int(11) NOT NULL default '100',
  spider_DescriptionMax int(11) NOT NULL default '10000',
  spider_DiplayContent tinyint(4) NOT NULL default '0',
  spider_Untitled tinytext collate utf8_unicode_ci NOT NULL,
  spider_pause tinyint(4) NOT NULL default '0',
  spider_delete tinyint(4) NOT NULL default '0',
  admin_limit tinyint(4) NOT NULL default '30',
  admin_set_time_limit int(11) NOT NULL default '30',
  admin_stats tinyint(4) NOT NULL default '0',
  admin_gpr tinyint(4) NOT NULL default '0',
  admin_dmoz_check tinyint(4) NOT NULL default '0',
  admin_count_pages tinyint(4) NOT NULL default '0',
  file_gsm tinytext collate utf8_unicode_ci NOT NULL,
  file_static tinytext collate utf8_unicode_ci NOT NULL,
  file_ext tinytext collate utf8_unicode_ci NOT NULL,
  chmod int(11) NOT NULL default '777',
  search_log tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (version)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'links'
-- 

CREATE TABLE links (
  id int(11) NOT NULL auto_increment,
  url text collate utf8_unicode_ci,
  title text collate utf8_unicode_ci,
  description text collate utf8_unicode_ci,
  `date` date NOT NULL default '0000-00-00',
  recip tinyint(1) NOT NULL default '0',
  gpr tinyint(2) NOT NULL default '0',
  category_id int(11) NOT NULL default '0',
  visible tinyint(1) NOT NULL default '1',
  email tinytext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (id),
  FULLTEXT KEY links (url,title,description)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'new_links'
-- 

CREATE TABLE new_links (
  id int(11) NOT NULL auto_increment,
  url text collate utf8_unicode_ci NOT NULL,
  title text collate utf8_unicode_ci NOT NULL,
  description text collate utf8_unicode_ci NOT NULL,
  email tinytext collate utf8_unicode_ci NOT NULL,
  category int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'pages'
-- 

CREATE TABLE pages (
  id int(11) NOT NULL auto_increment,
  link_id int(11) NOT NULL default '0',
  url text collate utf8_unicode_ci NOT NULL,
  title text collate utf8_unicode_ci NOT NULL,
  description text collate utf8_unicode_ci NOT NULL,
  gpr tinyint(4) NOT NULL default '0',
  recip tinyint(4) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  size int(32) NOT NULL default '0',
  PRIMARY KEY  (id),
  FULLTEXT KEY pages (url,title,description)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- 
-- Table structure for table 'search_log'
-- 

CREATE TABLE search_log (
  id int(11) NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  matches int(11) NOT NULL default '0',
  `text` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (id),
  FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
