-- 
-- Table structure for table `bannedips`
-- 

CREATE TABLE `bannedips` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `address` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `contributors`
-- 

CREATE TABLE `contributors` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `email` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `facts`
-- 

CREATE TABLE `facts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `fact` text NOT NULL,
  `votes_total` int(11) unsigned NOT NULL default '0',
  `votes_number` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `submissions`
-- 

CREATE TABLE `submissions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `fact` text NOT NULL,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;