DROP TABLE IF EXISTS `bannedips`;
CREATE TABLE IF NOT EXISTS `bannedips` (
  `id` int(100) NOT NULL auto_increment,
  `ip` varchar(16) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `cats`;
CREATE TABLE IF NOT EXISTS `cats` (
  `id` int(100) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `catOrder` int(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `data`;
CREATE TABLE IF NOT EXISTS `data` (
  `sitename` varchar(200) default NULL,
  `defaultTheme` varchar(200) default NULL,
  `bannerImg` varchar(255) default NULL,
  `usersTimeout` int(10) default NULL,
  `adminEmail` varchar(255) default NULL,
  `lastAdminLogin` int(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `forums`;
CREATE TABLE IF NOT EXISTS `forums` (
  `id` int(100) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `discription` varchar(255) default NULL,
  `inCat` int(100) default NULL,
  `locked` int(1) default NULL,
  `forumOrder` int(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `guests`;
CREATE TABLE IF NOT EXISTS `guests` (
  `id` int(100) NOT NULL auto_increment,
  `user` varchar(100) default NULL,
  `date` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `online`;
CREATE TABLE IF NOT EXISTS `online` (
  `id` int(100) NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `date` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `posts`;
CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(100) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `posterId` int(100) default NULL,
  `date` int(10) default NULL,
  `inForum` int(100) default NULL,
  `inThread` int(100) default NULL,
  `post` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `smileys`;
CREATE TABLE IF NOT EXISTS `smileys` (
  `id` int(100) NOT NULL auto_increment,
  `src` varchar(255) default NULL,
  `keyVal` varchar(5) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
DROP TABLE IF EXISTS `threads`;
CREATE TABLE IF NOT EXISTS `threads` (
  `id` int(100) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `posterId` int(100) default NULL,
  `date` int(10) default NULL,
  `views` int(100) default NULL,
  `inForum` int(100) default NULL,
  `sticky` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(100) NOT NULL auto_increment,
  `username` varchar(200) default NULL,
  `password` varchar(200) default NULL,
  `email` varchar(200) default NULL,
  `fname` varchar(200) default NULL,
  `lname` varchar(200) default NULL,
  `aim` varchar(200) default NULL,
  `msn` varchar(200) default NULL,
  `yim` varchar(200) default NULL,
  `icq` varchar(200) default NULL,
  `avatar` varchar(255) default NULL,
  `sig` varchar(255) default NULL,
  `theme` varchar(255) default NULL,
  `ip` varchar(16) default NULL,
  `title` varchar(255) default NULL,
  `subtitle` varchar(255) default NULL,
  `reggedOn` int(10) default NULL,
  `vStatus` varchar(10) default NULL,
  `nSocialUserId` varchar(250) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;