Blame Scripts/Php/Newbb2Phpbb/schemas/newbb-mysql.sql

878a2b
-- phpMyAdmin SQL Dump
878a2b
-- version 2.6.4-pl4
878a2b
-- http://www.phpmyadmin.net
878a2b
-- 
878a2b
-- Host: localhost
878a2b
-- Generation Time: May 07, 2006 at 01:26 PM
878a2b
-- Server version: 5.0.16
878a2b
-- PHP Version: 5.1.0
878a2b
-- 
878a2b
-- CBB 3.04
878a2b
-- 
878a2b
-- 
878a2b
-- Database: `cbb`
878a2b
-- 
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_archive`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_archive` (
878a2b
  `topic_id` int(8) unsigned NOT NULL default '0',
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  `post_text` text NOT NULL
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_attachments`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_attachments` (
878a2b
  `attach_id` int(8) unsigned NOT NULL auto_increment,
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  `name_saved` varchar(255) NOT NULL default '',
878a2b
  `name_disp` varchar(255) NOT NULL default '',
878a2b
  `mimetype` varchar(255) NOT NULL default '',
878a2b
  `online` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `attach_time` int(10) unsigned NOT NULL default '0',
878a2b
  `download` int(10) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`attach_id`),
878a2b
  KEY `post_id` (`post_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_categories`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_categories` (
878a2b
  `cat_id` smallint(3) unsigned NOT NULL auto_increment,
878a2b
  `cat_image` varchar(50) NOT NULL default '',
878a2b
  `cat_title` varchar(100) NOT NULL default '',
878a2b
  `cat_description` text NOT NULL,
878a2b
  `cat_order` smallint(3) unsigned NOT NULL default '0',
878a2b
  `cat_url` varchar(255) NOT NULL default '',
878a2b
  PRIMARY KEY  (`cat_id`),
878a2b
  KEY `cat_order` (`cat_order`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_digest`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_digest` (
878a2b
  `digest_id` int(8) unsigned NOT NULL auto_increment,
878a2b
  `digest_time` int(10) unsigned NOT NULL default '0',
878a2b
  `digest_content` text,
878a2b
  PRIMARY KEY  (`digest_id`),
878a2b
  KEY `digest_time` (`digest_time`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_forums`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_forums` (
878a2b
  `forum_id` smallint(4) unsigned NOT NULL auto_increment,
878a2b
  `forum_name` varchar(150) NOT NULL default '',
878a2b
  `forum_desc` text,
878a2b
  `parent_forum` smallint(4) unsigned NOT NULL default '0',
878a2b
  `forum_moderator` varchar(255) NOT NULL default '',
878a2b
  `forum_topics` int(8) unsigned NOT NULL default '0',
878a2b
  `forum_posts` int(10) unsigned NOT NULL default '0',
878a2b
  `forum_last_post_id` int(10) unsigned NOT NULL default '0',
878a2b
  `cat_id` smallint(3) unsigned NOT NULL default '0',
878a2b
  `forum_type` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `allow_html` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `allow_sig` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `allow_subject_prefix` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `hot_threshold` tinyint(3) unsigned NOT NULL default '10',
878a2b
  `forum_order` smallint(4) unsigned NOT NULL default '0',
878a2b
#  `allow_attachments` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `attach_maxkb` smallint(3) unsigned NOT NULL default '1000',
878a2b
  `attach_ext` varchar(255) NOT NULL default '',
878a2b
  `allow_polls` tinyint(1) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`forum_id`),
878a2b
  KEY `forum_last_post_id` (`forum_last_post_id`),
878a2b
  KEY `cat_forum` (`cat_id`,`forum_order`),
878a2b
  KEY `forum_order` (`forum_order`),
878a2b
  KEY `cat_id` (`cat_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_moderates`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_moderates` (
878a2b
  `mod_id` int(10) unsigned NOT NULL auto_increment,
878a2b
  `mod_start` int(10) unsigned NOT NULL default '0',
878a2b
  `mod_end` int(10) unsigned NOT NULL default '0',
878a2b
  `mod_desc` varchar(255) NOT NULL default '',
878a2b
  `uid` int(10) unsigned NOT NULL default '0',
878a2b
  `ip` varchar(32) NOT NULL default '',
878a2b
  `forum_id` smallint(4) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`mod_id`),
878a2b
  KEY `uid` (`uid`),
878a2b
  KEY `mod_end` (`mod_end`),
878a2b
  KEY `forum_id` (`forum_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_online`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_online` (
878a2b
  `online_forum` int(10) unsigned NOT NULL default '0',
878a2b
  `online_topic` int(8) unsigned NOT NULL default '0',
878a2b
  `online_uid` int(10) unsigned NOT NULL default '0',
878a2b
  `online_uname` varchar(255) NOT NULL default '',
878a2b
  `online_ip` varchar(32) NOT NULL default '',
878a2b
  `online_updated` int(10) unsigned NOT NULL default '0',
878a2b
  KEY `online_forum` (`online_forum`),
878a2b
  KEY `online_topic` (`online_topic`),
878a2b
  KEY `online_updated` (`online_updated`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_posts`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_posts` (
878a2b
  `post_id` int(10) unsigned NOT NULL auto_increment,
878a2b
  `pid` int(10) unsigned NOT NULL default '0',
878a2b
  `topic_id` int(8) unsigned NOT NULL default '0',
878a2b
  `forum_id` smallint(4) unsigned NOT NULL default '0',
878a2b
  `post_time` int(10) unsigned NOT NULL default '0',
878a2b
  `uid` int(10) unsigned NOT NULL default '0',
878a2b
  `poster_name` varchar(255) NOT NULL default '',
878a2b
  `poster_ip` int(11) NOT NULL default '0',
878a2b
  `subject` varchar(255) NOT NULL default '',
878a2b
  `dohtml` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `dosmiley` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `doxcode` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `dobr` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `doimage` tinyint(1) unsigned NOT NULL default '1',
878a2b
  `icon` varchar(25) NOT NULL default '',
878a2b
  `attachsig` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `approved` smallint(2) NOT NULL default '1',
878a2b
  `post_karma` int(10) unsigned NOT NULL default '0',
878a2b
  `attachment` text,
878a2b
  `require_reply` tinyint(1) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`post_id`),
878a2b
  KEY `uid` (`uid`),
878a2b
  KEY `pid` (`pid`),
878a2b
  KEY `forum_id` (`forum_id`),
878a2b
  KEY `topic_id` (`topic_id`),
878a2b
  KEY `subject` (`subject`(40)),
878a2b
  KEY `forumid_uid` (`forum_id`,`uid`),
878a2b
  KEY `topicid_uid` (`topic_id`,`uid`),
878a2b
  KEY `post_time` (`post_time`),
878a2b
  KEY `topicid_postid_pid` (`topic_id`,`post_id`,`pid`),
878a2b
  FULLTEXT KEY `search` (`subject`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_posts_text`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_posts_text` (
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  `post_text` text,
878a2b
  `post_edit` text,
878a2b
  PRIMARY KEY  (`post_id`),
878a2b
  FULLTEXT KEY `search` (`post_text`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_reads_forum`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_reads_forum` (
878a2b
  `read_id` int(10) unsigned NOT NULL auto_increment,
878a2b
  `uid` int(10) unsigned NOT NULL default '0',
878a2b
  `read_time` int(10) unsigned NOT NULL default '0',
878a2b
  `read_item` smallint(4) unsigned NOT NULL default '0',
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`read_id`),
878a2b
  KEY `uid` (`uid`),
878a2b
  KEY `read_item` (`read_item`),
878a2b
  KEY `post_id` (`post_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_reads_topic`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_reads_topic` (
878a2b
  `read_id` int(10) unsigned NOT NULL auto_increment,
878a2b
  `uid` int(10) unsigned NOT NULL default '0',
878a2b
  `read_time` int(10) unsigned NOT NULL default '0',
878a2b
  `read_item` int(8) unsigned NOT NULL default '0',
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`read_id`),
878a2b
  KEY `uid` (`uid`),
878a2b
  KEY `read_item` (`read_item`),
878a2b
  KEY `post_id` (`post_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_report`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_report` (
878a2b
  `report_id` int(8) unsigned NOT NULL auto_increment,
878a2b
  `post_id` int(10) unsigned NOT NULL default '0',
878a2b
  `reporter_uid` int(10) unsigned NOT NULL default '0',
878a2b
  `reporter_ip` int(11) NOT NULL default '0',
878a2b
  `report_time` int(10) unsigned NOT NULL default '0',
878a2b
  `report_text` varchar(255) NOT NULL default '',
878a2b
  `report_result` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `report_memo` varchar(255) NOT NULL default '',
878a2b
  PRIMARY KEY  (`report_id`),
878a2b
  KEY `post_id` (`post_id`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_topics`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_topics` (
878a2b
  `topic_id` int(8) unsigned NOT NULL auto_increment,
878a2b
  `topic_title` varchar(255) NOT NULL default '',
878a2b
  `topic_poster` int(10) unsigned NOT NULL default '0',
878a2b
  `topic_time` int(10) unsigned NOT NULL default '0',
878a2b
  `topic_views` int(10) unsigned NOT NULL default '0',
878a2b
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
878a2b
  `topic_last_post_id` int(8) unsigned NOT NULL default '0',
878a2b
  `forum_id` smallint(4) unsigned NOT NULL default '0',
878a2b
  `topic_status` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `topic_subject` smallint(3) unsigned NOT NULL default '0',
878a2b
  `topic_sticky` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `topic_digest` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `digest_time` int(10) unsigned NOT NULL default '0',
878a2b
  `approved` tinyint(2) NOT NULL default '1',
878a2b
  `poster_name` varchar(255) NOT NULL default '',
878a2b
  `rating` double(6,4) NOT NULL default '0.0000',
878a2b
  `votes` int(11) unsigned NOT NULL default '0',
878a2b
  `topic_haspoll` tinyint(1) unsigned NOT NULL default '0',
878a2b
  `poll_id` mediumint(8) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`topic_id`),
878a2b
  KEY `forum_id` (`forum_id`),
878a2b
  KEY `topic_last_post_id` (`topic_last_post_id`),
878a2b
  KEY `topic_poster` (`topic_poster`),
878a2b
  KEY `topic_forum` (`topic_id`,`forum_id`),
878a2b
  KEY `topic_sticky` (`topic_sticky`),
878a2b
  KEY `topic_digest` (`topic_digest`),
878a2b
  KEY `digest_time` (`digest_time`)
878a2b
) TYPE=MyISAM;
878a2b

878a2b
-- --------------------------------------------------------
878a2b

878a2b
-- 
878a2b
-- Table structure for table `bb_votedata`
878a2b
-- 
878a2b

878a2b
CREATE TABLE `bb_votedata` (
878a2b
  `ratingid` int(11) unsigned NOT NULL auto_increment,
878a2b
  `topic_id` int(8) unsigned NOT NULL default '0',
878a2b
  `ratinguser` int(10) unsigned NOT NULL default '0',
878a2b
  `rating` tinyint(3) unsigned NOT NULL default '0',
878a2b
  `ratinghostname` varchar(60) NOT NULL default '',
878a2b
  `ratingtimestamp` int(10) unsigned NOT NULL default '0',
878a2b
  PRIMARY KEY  (`ratingid`),
878a2b
  KEY `ratinguser` (`ratinguser`),
878a2b
  KEY `ratinghostname` (`ratinghostname`),
878a2b
  KEY `topic_id` (`topic_id`)
878a2b
) TYPE=MyISAM;