-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.15-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema minibb
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ minibb;
USE minibb;

--
-- Table structure for table `minibb`.`minibbtable_banned`
--

DROP TABLE IF EXISTS `minibbtable_banned`;
CREATE TABLE `minibbtable_banned` (
  `id` int(10) NOT NULL auto_increment,
  `banip` varchar(15) NOT NULL default '',
  `banreason` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_banned`
--

/*!40000 ALTER TABLE `minibbtable_banned` DISABLE KEYS */;
/*!40000 ALTER TABLE `minibbtable_banned` ENABLE KEYS */;


--
-- Table structure for table `minibb`.`minibbtable_forums`
--

DROP TABLE IF EXISTS `minibbtable_forums`;
CREATE TABLE `minibbtable_forums` (
  `forum_id` int(10) NOT NULL auto_increment,
  `forum_name` varchar(150) NOT NULL default '',
  `forum_desc` text NOT NULL,
  `forum_order` int(10) NOT NULL default '0',
  `forum_icon` varchar(255) NOT NULL default 'default.gif',
  `topics_count` int(10) NOT NULL default '0',
  `posts_count` int(10) NOT NULL default '0',
  `forum_group` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_forums`
--

/*!40000 ALTER TABLE `minibbtable_forums` DISABLE KEYS */;
INSERT INTO `minibbtable_forums` (`forum_id`,`forum_name`,`forum_desc`,`forum_order`,`forum_icon`,`topics_count`,`posts_count`,`forum_group`) VALUES 
 (1,'Integrex','This is for all tipics related to the Mazak Integrex machines.',1,'default.gif',0,0,'');
/*!40000 ALTER TABLE `minibbtable_forums` ENABLE KEYS */;


--
-- Table structure for table `minibb`.`minibbtable_posts`
--

DROP TABLE IF EXISTS `minibbtable_posts`;
CREATE TABLE `minibbtable_posts` (
  `post_id` int(10) NOT NULL auto_increment,
  `forum_id` int(10) NOT NULL default '1',
  `topic_id` int(10) NOT NULL default '1',
  `poster_id` int(10) NOT NULL default '0',
  `poster_name` varchar(40) NOT NULL default 'Anonymous',
  `post_text` text NOT NULL,
  `post_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `poster_ip` varchar(15) NOT NULL default '',
  `post_status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `post_id` (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `poster_ip` (`poster_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_posts`
--

/*!40000 ALTER TABLE `minibbtable_posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `minibbtable_posts` ENABLE KEYS */;


--
-- Table structure for table `minibb`.`minibbtable_send_mails`
--

DROP TABLE IF EXISTS `minibbtable_send_mails`;
CREATE TABLE `minibbtable_send_mails` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '1',
  `topic_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_send_mails`
--

/*!40000 ALTER TABLE `minibbtable_send_mails` DISABLE KEYS */;
/*!40000 ALTER TABLE `minibbtable_send_mails` ENABLE KEYS */;


--
-- Table structure for table `minibb`.`minibbtable_topics`
--

DROP TABLE IF EXISTS `minibbtable_topics`;
CREATE TABLE `minibbtable_topics` (
  `topic_id` int(10) NOT NULL auto_increment,
  `topic_title` varchar(255) NOT NULL default '',
  `topic_poster` int(10) NOT NULL default '0',
  `topic_poster_name` varchar(40) NOT NULL default 'Anonymous',
  `topic_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `topic_views` int(10) NOT NULL default '0',
  `forum_id` int(10) NOT NULL default '1',
  `topic_status` tinyint(1) NOT NULL default '0',
  `topic_last_post_id` int(10) NOT NULL default '1',
  `posts_count` int(10) NOT NULL default '0',
  `sticky` int(1) NOT NULL default '0',
  `topic_last_post_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`topic_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_last_post_id` (`topic_last_post_id`),
  KEY `sticky` (`sticky`),
  KEY `posts_count` (`posts_count`),
  KEY `topic_last_post_time` (`topic_last_post_time`),
  KEY `topic_views` (`topic_views`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_topics`
--

/*!40000 ALTER TABLE `minibbtable_topics` DISABLE KEYS */;
/*!40000 ALTER TABLE `minibbtable_topics` ENABLE KEYS */;


--
-- Table structure for table `minibb`.`minibbtable_users`
--

DROP TABLE IF EXISTS `minibbtable_users`;
CREATE TABLE `minibbtable_users` (
  `user_id` int(10) NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `user_regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `user_password` varchar(32) NOT NULL default '',
  `user_email` varchar(50) NOT NULL default '',
  `user_icq` varchar(50) NOT NULL default '',
  `user_website` varchar(100) NOT NULL default '',
  `user_occ` varchar(100) NOT NULL default '',
  `user_from` varchar(100) NOT NULL default '',
  `user_interest` varchar(150) NOT NULL default '',
  `user_viewemail` tinyint(1) NOT NULL default '0',
  `user_sorttopics` tinyint(1) NOT NULL default '1',
  `user_newpwdkey` varchar(32) NOT NULL default '',
  `user_newpasswd` varchar(32) NOT NULL default '',
  `language` char(3) NOT NULL default '',
  `activity` int(1) NOT NULL default '1',
  `num_topics` int(10) unsigned NOT NULL default '0',
  `num_posts` int(10) unsigned NOT NULL default '0',
  `user_custom1` varchar(255) NOT NULL default '',
  `user_custom2` varchar(255) NOT NULL default '',
  `user_custom3` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `minibb`.`minibbtable_users`
--

/*!40000 ALTER TABLE `minibbtable_users` DISABLE KEYS */;
INSERT INTO `minibbtable_users` (`user_id`,`username`,`user_regdate`,`user_password`,`user_email`,`user_icq`,`user_website`,`user_occ`,`user_from`,`user_interest`,`user_viewemail`,`user_sorttopics`,`user_newpwdkey`,`user_newpasswd`,`language`,`activity`,`num_topics`,`num_posts`,`user_custom1`,`user_custom2`,`user_custom3`) VALUES 
 (1,'cdw3423','0000-00-00 00:00:00','57c2877c1d84c4b49f3289657deca65c','2wsxdr5@cox.net','','','','','',0,1,'','','',1,0,0,'','','');
/*!40000 ALTER TABLE `minibbtable_users` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;