CREATE TABLE `admins` (
  `userID` int(10) unsigned NOT NULL auto_increment,
  `userLogin` varchar(10) NOT NULL default '',
  `userPassword` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`userID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `admins` VALUES (1, 'admin', 'admin');

CREATE TABLE `bad_words` (
  `wordID` int(10) unsigned NOT NULL auto_increment,
  `word` text,
  PRIMARY KEY  (`wordID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

CREATE TABLE `cache_feed` (
  `itemID` int(10) unsigned NOT NULL auto_increment,
  `file_name` varchar(255) NOT NULL default '',
  `timeCreated` datetime NOT NULL default '0000-00-00 00:00:00',
  `exipredAfter` int(11) NOT NULL default '0',
  `keywords` text,
  `cache_size` int(11) default NULL,
  `size` int(11) NOT NULL default '0',
  PRIMARY KEY  (`itemID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE `settings` (
  `settID` int(10) unsigned NOT NULL auto_increment,
  `useCache` tinyint(1) default '1',
  `cacheTime` int(11) default NULL,
  `noFoundString` blob,
  `cache_size` int(11) default NULL,
  PRIMARY KEY  (`settID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `settings` VALUES (1, 0, 3600, 0x20202020203c6469763e0d0a202020202020203c623e3c62723e3c62723e3c666f6e7420636f6c6f723d2223464630303030223e536f7272792c206e6f207265636f72647320666f756e642074686174206d6174636820796f75722071756572792e3c2f666f6e743e3c62723e3c62723e3c2f623e0d0a202020202020203c623e53756767657374696f6e733a3c2f623e3c62723e3c62723e0d0a2020202020202054727920616e6f74686572207365617263682063617465676f72792028652e672e207765622c20696d616765732c206574632e293c62723e3c62723e0d0a202020202020204d616b65207375726520616c6c20776f72647320696e20796f757220717565727920617265207370656c6c656420636f72726563746c793c62723e3c62723e0d0a2020202020202054727920612073686f727465722071756572792c206f72207265706c61636520736f6d65206b6579776f7264733c62723e3c62723e0d0a2020202020203c2f6469763e3c62723e, 2);

CREATE TABLE `terms` (
  `termID` int(10) unsigned NOT NULL auto_increment,
  `keyword` text,
  `date` date default NULL,
  `type` enum('web','images','news','video','audio') default 'web',
  `count` int(11) default NULL,
  PRIMARY KEY  (`termID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ;