-- phpMyAdmin SQL Dump

-- version 2.6.4-pl4

-- http://www.phpmyadmin.net

-- 

-- Host: localhost

-- Generation Time: May 07, 2006 at 01:26 PM

-- Server version: 5.0.16

-- PHP Version: 5.1.0

-- 

-- CBB 3.04

-- 

-- 

-- Database: `cbb`

-- 

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

-- 

-- Table structure for table `bb_archive`

-- 

CREATE TABLE `bb_archive` (

  `topic_id` int(8) unsigned NOT NULL default '0',

  `post_id` int(10) unsigned NOT NULL default '0',

  `post_text` text NOT NULL

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_attachments`

-- 

CREATE TABLE `bb_attachments` (

  `attach_id` int(8) unsigned NOT NULL auto_increment,

  `post_id` int(10) unsigned NOT NULL default '0',

  `name_saved` varchar(255) NOT NULL default '',

  `name_disp` varchar(255) NOT NULL default '',

  `mimetype` varchar(255) NOT NULL default '',

  `online` tinyint(1) unsigned NOT NULL default '1',

  `attach_time` int(10) unsigned NOT NULL default '0',

  `download` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`attach_id`),

  KEY `post_id` (`post_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_categories`

-- 

CREATE TABLE `bb_categories` (

  `cat_id` smallint(3) unsigned NOT NULL auto_increment,

  `cat_image` varchar(50) NOT NULL default '',

  `cat_title` varchar(100) NOT NULL default '',

  `cat_description` text NOT NULL,

  `cat_order` smallint(3) unsigned NOT NULL default '0',

  `cat_url` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`cat_id`),

  KEY `cat_order` (`cat_order`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_digest`

-- 

CREATE TABLE `bb_digest` (

  `digest_id` int(8) unsigned NOT NULL auto_increment,

  `digest_time` int(10) unsigned NOT NULL default '0',

  `digest_content` text,

  PRIMARY KEY  (`digest_id`),

  KEY `digest_time` (`digest_time`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_forums`

-- 

CREATE TABLE `bb_forums` (

  `forum_id` smallint(4) unsigned NOT NULL auto_increment,

  `forum_name` varchar(150) NOT NULL default '',

  `forum_desc` text,

  `parent_forum` smallint(4) unsigned NOT NULL default '0',

  `forum_moderator` varchar(255) NOT NULL default '',

  `forum_topics` int(8) unsigned NOT NULL default '0',

  `forum_posts` int(10) unsigned NOT NULL default '0',

  `forum_last_post_id` int(10) unsigned NOT NULL default '0',

  `cat_id` smallint(3) unsigned NOT NULL default '0',

  `forum_type` tinyint(1) unsigned NOT NULL default '0',

  `allow_html` tinyint(1) unsigned NOT NULL default '1',

  `allow_sig` tinyint(1) unsigned NOT NULL default '1',

  `allow_subject_prefix` tinyint(1) unsigned NOT NULL default '0',

  `hot_threshold` tinyint(3) unsigned NOT NULL default '10',

  `forum_order` smallint(4) unsigned NOT NULL default '0',

#  `allow_attachments` tinyint(1) unsigned NOT NULL default '1',

  `attach_maxkb` smallint(3) unsigned NOT NULL default '1000',

  `attach_ext` varchar(255) NOT NULL default '',

  `allow_polls` tinyint(1) unsigned NOT NULL default '0',

  PRIMARY KEY  (`forum_id`),

  KEY `forum_last_post_id` (`forum_last_post_id`),

  KEY `cat_forum` (`cat_id`,`forum_order`),

  KEY `forum_order` (`forum_order`),

  KEY `cat_id` (`cat_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_moderates`

-- 

CREATE TABLE `bb_moderates` (

  `mod_id` int(10) unsigned NOT NULL auto_increment,

  `mod_start` int(10) unsigned NOT NULL default '0',

  `mod_end` int(10) unsigned NOT NULL default '0',

  `mod_desc` varchar(255) NOT NULL default '',

  `uid` int(10) unsigned NOT NULL default '0',

  `ip` varchar(32) NOT NULL default '',

  `forum_id` smallint(4) unsigned NOT NULL default '0',

  PRIMARY KEY  (`mod_id`),

  KEY `uid` (`uid`),

  KEY `mod_end` (`mod_end`),

  KEY `forum_id` (`forum_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_online`

-- 

CREATE TABLE `bb_online` (

  `online_forum` int(10) unsigned NOT NULL default '0',

  `online_topic` int(8) unsigned NOT NULL default '0',

  `online_uid` int(10) unsigned NOT NULL default '0',

  `online_uname` varchar(255) NOT NULL default '',

  `online_ip` varchar(32) NOT NULL default '',

  `online_updated` int(10) unsigned NOT NULL default '0',

  KEY `online_forum` (`online_forum`),

  KEY `online_topic` (`online_topic`),

  KEY `online_updated` (`online_updated`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_posts`

-- 

CREATE TABLE `bb_posts` (

  `post_id` int(10) unsigned NOT NULL auto_increment,

  `pid` int(10) unsigned NOT NULL default '0',

  `topic_id` int(8) unsigned NOT NULL default '0',

  `forum_id` smallint(4) unsigned NOT NULL default '0',

  `post_time` int(10) unsigned NOT NULL default '0',

  `uid` int(10) unsigned NOT NULL default '0',

  `poster_name` varchar(255) NOT NULL default '',

  `poster_ip` int(11) NOT NULL default '0',

  `subject` varchar(255) NOT NULL default '',

  `dohtml` tinyint(1) unsigned NOT NULL default '0',

  `dosmiley` tinyint(1) unsigned NOT NULL default '1',

  `doxcode` tinyint(1) unsigned NOT NULL default '1',

  `dobr` tinyint(1) unsigned NOT NULL default '1',

  `doimage` tinyint(1) unsigned NOT NULL default '1',

  `icon` varchar(25) NOT NULL default '',

  `attachsig` tinyint(1) unsigned NOT NULL default '0',

  `approved` smallint(2) NOT NULL default '1',

  `post_karma` int(10) unsigned NOT NULL default '0',

  `attachment` text,

  `require_reply` tinyint(1) unsigned NOT NULL default '0',

  PRIMARY KEY  (`post_id`),

  KEY `uid` (`uid`),

  KEY `pid` (`pid`),

  KEY `forum_id` (`forum_id`),

  KEY `topic_id` (`topic_id`),

  KEY `subject` (`subject`(40)),

  KEY `forumid_uid` (`forum_id`,`uid`),

  KEY `topicid_uid` (`topic_id`,`uid`),

  KEY `post_time` (`post_time`),

  KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),

  FULLTEXT KEY `search` (`subject`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_posts_text`

-- 

CREATE TABLE `bb_posts_text` (

  `post_id` int(10) unsigned NOT NULL default '0',

  `post_text` text,

  `post_edit` text,

  PRIMARY KEY  (`post_id`),

  FULLTEXT KEY `search` (`post_text`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_reads_forum`

-- 

CREATE TABLE `bb_reads_forum` (

  `read_id` int(10) unsigned NOT NULL auto_increment,

  `uid` int(10) unsigned NOT NULL default '0',

  `read_time` int(10) unsigned NOT NULL default '0',

  `read_item` smallint(4) unsigned NOT NULL default '0',

  `post_id` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`read_id`),

  KEY `uid` (`uid`),

  KEY `read_item` (`read_item`),

  KEY `post_id` (`post_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_reads_topic`

-- 

CREATE TABLE `bb_reads_topic` (

  `read_id` int(10) unsigned NOT NULL auto_increment,

  `uid` int(10) unsigned NOT NULL default '0',

  `read_time` int(10) unsigned NOT NULL default '0',

  `read_item` int(8) unsigned NOT NULL default '0',

  `post_id` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`read_id`),

  KEY `uid` (`uid`),

  KEY `read_item` (`read_item`),

  KEY `post_id` (`post_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_report`

-- 

CREATE TABLE `bb_report` (

  `report_id` int(8) unsigned NOT NULL auto_increment,

  `post_id` int(10) unsigned NOT NULL default '0',

  `reporter_uid` int(10) unsigned NOT NULL default '0',

  `reporter_ip` int(11) NOT NULL default '0',

  `report_time` int(10) unsigned NOT NULL default '0',

  `report_text` varchar(255) NOT NULL default '',

  `report_result` tinyint(1) unsigned NOT NULL default '0',

  `report_memo` varchar(255) NOT NULL default '',

  PRIMARY KEY  (`report_id`),

  KEY `post_id` (`post_id`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_topics`

-- 

CREATE TABLE `bb_topics` (

  `topic_id` int(8) unsigned NOT NULL auto_increment,

  `topic_title` varchar(255) NOT NULL default '',

  `topic_poster` int(10) unsigned NOT NULL default '0',

  `topic_time` int(10) unsigned NOT NULL default '0',

  `topic_views` int(10) unsigned NOT NULL default '0',

  `topic_replies` mediumint(8) unsigned NOT NULL default '0',

  `topic_last_post_id` int(8) unsigned NOT NULL default '0',

  `forum_id` smallint(4) unsigned NOT NULL default '0',

  `topic_status` tinyint(1) unsigned NOT NULL default '0',

  `topic_subject` smallint(3) unsigned NOT NULL default '0',

  `topic_sticky` tinyint(1) unsigned NOT NULL default '0',

  `topic_digest` tinyint(1) unsigned NOT NULL default '0',

  `digest_time` int(10) unsigned NOT NULL default '0',

  `approved` tinyint(2) NOT NULL default '1',

  `poster_name` varchar(255) NOT NULL default '',

  `rating` double(6,4) NOT NULL default '0.0000',

  `votes` int(11) unsigned NOT NULL default '0',

  `topic_haspoll` tinyint(1) unsigned NOT NULL default '0',

  `poll_id` mediumint(8) unsigned NOT NULL default '0',

  PRIMARY KEY  (`topic_id`),

  KEY `forum_id` (`forum_id`),

  KEY `topic_last_post_id` (`topic_last_post_id`),

  KEY `topic_poster` (`topic_poster`),

  KEY `topic_forum` (`topic_id`,`forum_id`),

  KEY `topic_sticky` (`topic_sticky`),

  KEY `topic_digest` (`topic_digest`),

  KEY `digest_time` (`digest_time`)

) TYPE=MyISAM;

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

-- 

-- Table structure for table `bb_votedata`

-- 

CREATE TABLE `bb_votedata` (

  `ratingid` int(11) unsigned NOT NULL auto_increment,

  `topic_id` int(8) unsigned NOT NULL default '0',

  `ratinguser` int(10) unsigned NOT NULL default '0',

  `rating` tinyint(3) unsigned NOT NULL default '0',

  `ratinghostname` varchar(60) NOT NULL default '',

  `ratingtimestamp` int(10) unsigned NOT NULL default '0',

  PRIMARY KEY  (`ratingid`),

  KEY `ratinguser` (`ratinguser`),

  KEY `ratinghostname` (`ratinghostname`),

  KEY `topic_id` (`topic_id`)

) TYPE=MyISAM;