Menu
▾
▴
[Jboss-svn-commits] JBL Code SVN: r1006 - in trunk/forge/portal-extensions/forge-forums: . scripts
|
From: <jbo...@li...> - 2005-08-29 20:36:02
|
Author: adamw Date: 2005-08-29 16:35:56 -0400 (Mon, 29 Aug 2005) New Revision: 1006 Added: trunk/forge/portal-extensions/forge-forums/scripts/ trunk/forge/portal-extensions/forge-forums/scripts/all.sql trunk/forge/portal-extensions/forge-forums/scripts/conv.sql trunk/forge/portal-extensions/forge-forums/scripts/diff.sql trunk/forge/portal-extensions/forge-forums/scripts/nukes3.sql trunk/forge/portal-extensions/forge-forums/scripts/portal-keys.sql trunk/forge/portal-extensions/forge-forums/scripts/portal-pure.sql trunk/forge/portal-extensions/forge-forums/scripts/test.sql Log: First scripts Added: trunk/forge/portal-extensions/forge-forums/scripts/all.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/all.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/all.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,3 @@ +\. portal-pure.sql +\. conv.sql +\. portal-keys.sql Added: trunk/forge/portal-extensions/forge-forums/scripts/conv.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/conv.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/conv.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,99 @@ +-- DB CONVERT SCRIPT OF NUKES3 FORUMS TO PORTAL FORUMS W/ USERS TABLE + +-- Converting categories +--ALTER TABLE phpbb_categories RENAME TO jbp_forums_categories; +--ALTER TABLE jbp_forums_categories CHANGE cat_id jbp_id int(11) NOT NULL auto_increment, ADD PRIMARY KEY (jbp_id); +--ALTER TABLE jbp_forums_categories CHANGE cat_title jbp_title varchar(255) default NULL; +--ALTER TABLE jbp_forums_categories CHANGE cat_order jbp_order int(11) default NULL; + +-- Copying data from users (into users and posters). +-- To make things easy, we assume that poster id == user id. This makes this +-- script useable only for making a completely new portal db, not merging it +-- with an existing one. +INSERT INTO jbp_users (jbp_uid, jbp_root_pref_set_id, jbp_uname, + jbp_givenname, jbp_familyname, jbp_password, jbp_realemail, + jbp_fakeemail, jbp_regdate, jbp_viewrealemail, jbp_enabled) + SELECT n.pn_uid, NULL, n.pn_uname, n.pn_name, n.pn_fname, + n.pn_pass, n.pn_email, n.pn_femail, n.pn_user_regdate, + n.pn_user_viewemail, n.pn_enabled FROM nuke_users n; + +-- TODO: update givenname/ familyname + +INSERT INTO jbp_forums_posters (jbp_id, jbp_user_id, jbp_post_count) + SELECT n.pn_uid, n.pn_uid, 0 FROM nuke_users n; + +-- TODO: update the post count + +-- Copying data from categories. +INSERT INTO jbp_forums_categories (jbp_id, jbp_order, jbp_title) + SELECT n.cat_id, n.cat_order, n.cat_title + FROM phpbb_categories n; + +-- Copying data from forums. +INSERT INTO jbp_forums_forums (jbp_id, jbp_category_id, jbp_description, + jbp_last_post_id, jbp_name, jbp_order, jbp_topic_count, + jbp_post_count, jbp_prune_enable, jbp_prune_next, + jbp_status, jbp_type) + SELECT n.forum_id, n.cat_id, n.forum_desc, n.forum_last_post_id, + n.forum_name, n.forum_order, n.forum_topics, + n.forum_posts, n.prune_enable, n.prune_next, + n.forum_status, 0 FROM phpbb_forums n; + +-- Portal doesn't like "null" here. +UPDATE jbp_forums_forums SET jbp_prune_next=0 WHERE jbp_prune_next = NULL; + +-- Copying data from forumswatch - two tables required here. +-- First inserting user+mode data. +INSERT INTO jbp_forums_watch (jbp_poster_id, jbp_mode) + SELECT DISTINCT n.user_id, n.watch_mode FROM phpbb_forums_watch n; + +-- Now inserting the actual watches. +INSERT INTO jbp_forums_forumswatch (jbp_id, jbp_forum_id) + SELECT DISTINCT n.forum_id, p.jbp_id + FROM phpbb_forums_watch n, jbp_forums_watch p + WHERE p.jbp_poster_id = n.user_id AND p.jbp_mode = n.watch_mode; + +-- Copying topics. +INSERT INTO jbp_forums_topics (jbp_id, jbp_forum_id, jbp_view_count, + jbp_replies, jbp_first_post_id, jbp_last_post_id, + jbp_last_post_date, jbp_poster, jbp_type, jbp_status, + jbp_subject, jbp_poll) + SELECT n.topic_id, n.forum_id, n.topic_views, n.topic_replies, + n.topic_first_post_id, n.topic_last_post_id, + n.topic_last_post_time, n.topic_poster, n.topic_type, + n.topic_status, n.topic_title, NULL FROM phpbb_topics n; + +-- Copying posts. +INSERT INTO jbp_forums_posts (jbp_id, jbp_topic_id, jbp_edit_count, + jbp_edit_date, jbp_create_date, jbp_subject, jbp_text, + jbp_htmlenabled, jbp_poster_id) + SELECT n.post_id, n.topic_id, n.post_edit_count, n.post_edit_time, + n.post_time, n.post_subject, n.post_text, n.enable_html, + n.poster_id FROM phpbb_posts n; + +-- Hibernate doesn't like null-like dates. +UPDATE jbp_forums_posts SET jbp_create_date='1970-01-01 00:00:00' WHERE jbp_create_date='0000-00-00 00:00:00'; +UPDATE jbp_forums_posts SET jbp_edit_date='1970-01-01 00:00:00' WHERE jbp_edit_date='0000-00-00 00:00:00'; + +-- Copying pool options + +-- Copying pool votes + +-- Copying pools + +-- Updating the "admin" account to be the same as on labs. +UPDATE jbp_users SET jbp_password = "0E6C6B302E803D8F03C2906211D39486" WHERE jbp_uname = "admin"; + +-- Creating the "Admin" and "User" roles. +INSERT INTO jbp_roles (jbp_rid, jbp_name, jbp_displayname) VALUES (1, "Admin", "Administrators"); +INSERT INTO jbp_roles (jbp_rid, jbp_name, jbp_displayname) VALUES (2, "User", "Users"); + +-- Assigning everybody to the "User" role. +INSERT INTO jbp_role_membership (jbp_rid, jbp_uid) + SELECT 2, p.jbp_uid FROM jbp_users p; + +-- Assigning "adamw" and "admin" to the "Admin" role. +INSERT INTO jbp_role_membership (jbp_rid, jbp_uid) + SELECT 1, p.jbp_uid FROM jbp_users p WHERE p.jbp_uname = "adamw"; +INSERT INTO jbp_role_membership (jbp_rid, jbp_uid) + SELECT 1, p.jbp_uid FROM jbp_users p WHERE p.jbp_uname = "admin"; Added: trunk/forge/portal-extensions/forge-forums/scripts/diff.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/diff.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/diff.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,263 @@ +-- MySQL dump 10.9 +-- +-- Host: staging.jboss.com Database: nukes3 +-- ------------------------------------------------------ + +-- SELECTED NUKES3 TABLES WITH MIGRATION INFO TO JB PORTAL 2 DB + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nukes3`; + +USE `nukes3`; + +-- +-- Table structure for table `phpbb_categories` +-- + +CREATE TABLE `phpbb_categories` ( --> jbp_forums_categories + `cat_id` mediumint(8) unsigned NOT NULL auto_increment, --> jbp_id + `cat_title` varchar(100) NOT NULL default '', --> jbp_title + `cat_order` mediumint(8) unsigned NOT NULL default '0', --> jbp_order + PRIMARY KEY (`cat_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_forums` +-- + +CREATE TABLE `phpbb_forums` ( --> jbp_forums_forums + `forum_id` smallint(5) unsigned NOT NULL auto_increment, --> jbp_id + `cat_id` mediumint(8) unsigned default NULL, --> jbp_category_id + `forum_name` varchar(150) NOT NULL default '', --> jbp_name + -- NOTE: field type text --> varchar(255) - possible loss of data. + `forum_desc` text NOT NULL, --> jbp_description + `forum_status` tinyint(4) NOT NULL default '0', --> jbp_status + `forum_order` mediumint(8) unsigned NOT NULL default '1', --> jbp_order + `forum_posts` mediumint(8) unsigned NOT NULL default '0', --> jbp_post_count + `forum_topics` mediumint(8) unsigned NOT NULL default '0', --> jbp_topic_count + `forum_last_post_id` mediumint(8) unsigned default NULL, --> jbp_last_post_id + `prune_next` int(11) default NULL, --> jbp_prune_next + `prune_enable` tinyint(1) NOT NULL default '0', --> jbp_prune_enable + + -- NOTE: all of the auth* fields are not present in the portal DB. They probably + -- enabled forums administrators to specify what actions users can take. Data + -- loss here. + `auth_view` tinyint(2) NOT NULL default '0', + `auth_read` tinyint(2) NOT NULL default '0', + `auth_post` tinyint(2) NOT NULL default '1', + `auth_reply` tinyint(2) NOT NULL default '1', + `auth_edit` tinyint(2) NOT NULL default '3', + `auth_delete` tinyint(2) NOT NULL default '3', + `auth_sticky` tinyint(2) NOT NULL default '3', + `auth_announce` tinyint(2) NOT NULL default '3', + `auth_vote` tinyint(2) NOT NULL default '1', + `auth_pollcreate` tinyint(2) NOT NULL default '3', + `auth_attachments` tinyint(2) NOT NULL default '0', + + -- NOTE: new field in portal DB: + -- jbp_type + -- No idea what it's function is supposed to be though. + PRIMARY KEY (`forum_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_forums_watch` +-- + + -- NOTE: here is a major incompatibility. In nukes, we have a simple implementation: + -- forum_id + user_id. Here, it's more complicated: + -- 1. user_id --> jbf_forums_posters.jbp_user_id + -- 2. jbf_forums_watch.jbp_poster_id references jbf_forums_poster.jbp_id + -- 3. jbf_forums_forumswatch.jbp_id references jbf_forums_watch.jbp_id + -- Any explanation on why jbf_forums_forumswatch is needed, instead of putting jbp_forum_id + -- in jbf_forums_watch is welcome. +CREATE TABLE `phpbb_forums_watch` ( --> jbp_forums_forumswatch & jbp_forums_watch + `forum_id` mediumint(8) unsigned NOT NULL default '0', --> jbp_forums_forumswatch.jbp_forum_id + `user_id` mediumint(8) NOT NULL default '0', --> jbp_forums_watch.jbp_poster_id + --> jbp_forums_posters.jbp_user_id + `watch_mode` tinyint(3) NOT NULL default '0', --> jbp_forums_watch.jbp_mode + PRIMARY KEY (`forum_id`,`user_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_posts` +-- + +CREATE TABLE `phpbb_posts` ( --> jbp_forums_posts + `post_id` mediumint(8) unsigned NOT NULL auto_increment, --> jbp_id + `topic_id` mediumint(8) unsigned default NULL, --> jbp_topic_id + -- NOTE: This field does not have a corresponding one in portal DB. + -- But I think it's redundant anyway. You can get it get doing + -- SELECT t.forum_id FROM phpbb_topics t, php_bb posts p + -- WHERE t.topic_id = p.topic_id AND p.post_id = xx + `forum_id` smallint(5) unsigned default NULL, + -- NOTE: In phpbb, this references user_id. In forums portelt, this + -- references the posters table, (which references the users table - + -- so one addition step here). + `poster_id` mediumint(11) default NULL, --> (jbp_poster_id) + `post_time` datetime NOT NULL default '0000-00-00 00:00:00', --> jbp_create_date + -- NOTE: The next three fields are not present in portal DB. Possible + -- loss of data. Also, afaik, forums portlet doesn't support bbcode. + `poster_ip` varchar(8) NOT NULL default '', + `post_username` varchar(25) default NULL, + `enable_bbcode` tinyint(1) NOT NULL default '1', + `enable_html` tinyint(1) NOT NULL default '0', --> jbp_htmlenabled + -- NOTE: This and next fields are also not present. Possble loss of data. + `enable_smilies` tinyint(1) NOT NULL default '1', + `enable_sig` tinyint(1) NOT NULL default '1', + `post_edit_time` datetime NOT NULL default '0000-00-00 00:00:00', --> jbp_edit_date + `post_edit_count` smallint(5) unsigned NOT NULL default '0', --> jbp_edit_count + `post_subject` varchar(60) NOT NULL default '', --> jbp_subject + `post_text` text NOT NULL, --> jbp_text + PRIMARY KEY (`post_id`), + KEY `topic_id` (`topic_id`), + KEY `forum_id` (`forum_id`), + KEY `phpbb_posts_topic_id` (`topic_id`), + KEY `phpbb_posts_forum_id` (`forum_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_topics` +-- + +CREATE TABLE `phpbb_topics` ( --> jbp_forums_topics + `topic_id` mediumint(8) unsigned NOT NULL auto_increment, --> jbp_id + `forum_id` smallint(8) unsigned default NULL, --> jbp_forum_id + `topic_title` char(60) NOT NULL default '', --> jbp_subject + -- NOTE: This also has a different meaning in both DBs. See the posts table. + `topic_poster` mediumint(11) default NULL, --> (jbp_poster) + -- NOTE: This is not present in portal DB. But probably, can be calculated + -- by taking the first post date. + `topic_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_views` mediumint(8) unsigned NOT NULL default '0', --> jbp_view_count + `topic_replies` mediumint(8) unsigned NOT NULL default '0', --> jbp_replies + `topic_status` tinyint(3) NOT NULL default '0', --> jbp_status + -- NOTE: In nukes3, this field holds just a yes/no: is there a pool (most probably). + -- And in the pools table, there is a field that is a reference to this table. Now, + -- in portal DB, it's done quite differently: for each topic a corresponding entry + -- in jbp_forums_polls is created. And the jbp_poll simply = jpb_id, as the ids in + -- both tabels are the same (well, at least during my tests - but I don't see why this should + -- ever be different; however, I suppose that the original intent was for this field + -- to hold jbp_forums_polls.jbp_id, which theoretically may be different from + -- jbp_forums_topics.jbp_id, but never is, as a new poll entry is created with a new + -- topic). + `topic_vote` tinyint(1) NOT NULL default '0', --> (jbp_poll) + `topic_type` tinyint(3) NOT NULL default '0', --> jbp_type + `topic_first_post_id` mediumint(8) unsigned default NULL, --> jbp_first_post_id + `topic_last_post_id` mediumint(8) unsigned default NULL, --> jbp_last_post_id + `topic_last_post_time` datetime NOT NULL default '0000-00-00 00:00:00', --> jbp_last_post_date + -- NOTE: This field is not present in portal DB. Possible loss of data. + `topic_moved_id` mediumint(8) unsigned default NULL, + PRIMARY KEY (`topic_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_topics_watch` +-- + + -- NOTE: The table for topics watch exists in portal DB, but the feature is not + -- implemented. Also, it seemsthat the table lacks columns to hold all necessary + -- data. So here, all data would be lost. +CREATE TABLE `phpbb_topics_watch` ( --> (jbp_forums_topicswatch) + `topic_id` mediumint(8) unsigned NOT NULL default '0', --> jbp_topic_id + `user_id` mediumint(8) NOT NULL default '0', + `notify_status` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`topic_id`,`user_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_desc` +-- + +CREATE TABLE `phpbb_vote_desc` ( --> jbp_forums_polls + `vote_id` mediumint(8) unsigned NOT NULL auto_increment, --> jbp_poll_id + -- NOTE: This field is not present in portal DB. Instead, there's a field + -- in jbp_forums_topic which holds a reference to this table. Also, in reality, + -- for each topic an empty (with jbp_title = NULL) poll is created. + `topic_id` mediumint(8) unsigned default NULL, + -- NOTE: Conversion from text to varchar(255). Possible loss of data. + `vote_text` text NOT NULL, --> jbp_title + -- NOTE: Not sure what this field means. In the DB, it has values like 2003, 2004. + -- So maybe it's the year of creation? + `vote_start` int(11) NOT NULL default '0', --> (jbp_creation_date) + `vote_length` int(11) NOT NULL default '0', --> jbp_length + PRIMARY KEY (`vote_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_results` +-- + +CREATE TABLE `phpbb_vote_results` ( --> jbp_forums_poll_option + -- NOTE: No unique id in portal DB. But that's not a problem, as it's role + -- is taken by (jbp_poll_id, jbp_poll_option_position). + `vote_option_id` mediumint(8) unsigned NOT NULL auto_increment, + `vote_desc_id` mediumint(8) unsigned default NULL, --> jbp_poll_id + `vote_option_text` varchar(255) NOT NULL default '', --> jbp_question + `vote_result` int(11) NOT NULL default '0', --> jbp_votes + -- NOTE: One new field in portal DB: + -- jbp_poll_option_position + -- It can be just filled with subsequent values. + PRIMARY KEY (`vote_option_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_voters` +-- + +CREATE TABLE `phpbb_vote_voters` ( --> jbp_forums_poll_voted + -- NOTE: This field is not present in portal DB. Not information loss though, + -- as it doesn't bring any necessary information. + `vote_id` mediumint(8) unsigned NOT NULL auto_increment, + `vote_desc_id` mediumint(8) unsigned default NULL, --> jbp_poll_id + -- NOTE: Unconsequently, this is a user id, not a poster id - in the portal DB. + `vote_user_id` mediumint(8) unsigned default NULL, --> jbp_poll_voted + -- NOTE: This field is not present in portal DB. Loss of data. + `vote_user_ip` char(8) NOT NULL default '', + PRIMARY KEY (`vote_id`) +) TYPE=InnoDB; + + -- NOTE: No idea what is the role of the following two tables. + +-- +-- Table structure for table `tmp_posts` +-- + +CREATE TABLE `tmp_posts` ( + `post_id` mediumint(8) unsigned NOT NULL default '0', + `topic_id` mediumint(8) unsigned default NULL, + `forum_id` smallint(5) unsigned default NULL, + `poster_id` mediumint(11) default NULL, + `post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `poster_ip` varchar(8) NOT NULL default '', + `post_username` varchar(25) default NULL, + `enable_bbcode` tinyint(1) NOT NULL default '1', + `enable_html` tinyint(1) NOT NULL default '0', + `enable_smilies` tinyint(1) NOT NULL default '1', + `enable_sig` tinyint(1) NOT NULL default '1', + `post_edit_time` datetime NOT NULL default '0000-00-00 00:00:00', + `post_edit_count` smallint(5) unsigned NOT NULL default '0', + `post_subject` varchar(60) NOT NULL default '', + `post_text` text NOT NULL +) TYPE=InnoDB; + +-- +-- Table structure for table `tmp_topics` +-- + +CREATE TABLE `tmp_topics` ( + `topic_id` mediumint(8) unsigned NOT NULL default '0', + `forum_id` smallint(8) unsigned default NULL, + `topic_title` char(60) NOT NULL default '', + `topic_poster` mediumint(11) default NULL, + `topic_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_views` mediumint(8) unsigned NOT NULL default '0', + `topic_replies` mediumint(8) unsigned NOT NULL default '0', + `topic_status` tinyint(3) NOT NULL default '0', + `topic_vote` tinyint(1) NOT NULL default '0', + `topic_type` tinyint(3) NOT NULL default '0', + `topic_first_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_moved_id` mediumint(8) unsigned default NULL +) TYPE=InnoDB; + Added: trunk/forge/portal-extensions/forge-forums/scripts/nukes3.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/nukes3.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/nukes3.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,759 @@ +-- MySQL dump 10.9 +-- +-- Host: staging.jboss.com Database: nukes3 +-- ------------------------------------------------------ +-- Server version 3.23.58 +/*!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' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Current Database: `nukes3` +-- + +DROP DATABASE nukes3; +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nukes3`; + +USE `nukes3`; + +-- +-- Table structure for table `nuke_downloads_categories` +-- + +DROP TABLE IF EXISTS `nuke_downloads_categories`; +CREATE TABLE `nuke_downloads_categories` ( + `categoryId` bigint(20) NOT NULL auto_increment, + `title` varchar(50) NOT NULL default '', + `description` text NOT NULL, + `parentId` bigint(20) default '0', + PRIMARY KEY (`categoryId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_categories_old` +-- + +DROP TABLE IF EXISTS `nuke_downloads_categories_old`; +CREATE TABLE `nuke_downloads_categories_old` ( + `categoryId` bigint(20) NOT NULL auto_increment, + `title` varchar(50) NOT NULL default '', + `description` text NOT NULL, + `parentId` bigint(20) default '0', + PRIMARY KEY (`categoryId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_downloads` +-- + +DROP TABLE IF EXISTS `nuke_downloads_downloads`; +CREATE TABLE `nuke_downloads_downloads` ( + `downloadId` bigint(20) NOT NULL auto_increment, + `categoryId` bigint(20) default '0', + `title` varchar(100) NOT NULL default '', + `url` varchar(100) NOT NULL default '', + `description` text NOT NULL, + `timestamp` datetime default NULL, + `name` varchar(100) NOT NULL default '', + `email` varchar(100) NOT NULL default '', + `hits` int(11) NOT NULL default '0', + `submitterId` int(11) default NULL, + `downloadratingsummary` double(6,4) NOT NULL default '0.0000', + `totalvotes` int(11) NOT NULL default '0', + `totalcomments` int(11) NOT NULL default '0', + `filesize` int(11) NOT NULL default '0', + `version` varchar(10) NOT NULL default '', + `homepage` varchar(200) NOT NULL default '', + PRIMARY KEY (`downloadId`), + KEY `categoryId` (`categoryId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_downloads_old` +-- + +DROP TABLE IF EXISTS `nuke_downloads_downloads_old`; +CREATE TABLE `nuke_downloads_downloads_old` ( + `downloadId` bigint(20) NOT NULL auto_increment, + `categoryId` bigint(20) default '0', + `title` varchar(100) NOT NULL default '', + `url` varchar(100) NOT NULL default '', + `description` text NOT NULL, + `timestamp` datetime default NULL, + `name` varchar(100) NOT NULL default '', + `email` varchar(100) NOT NULL default '', + `hits` int(11) NOT NULL default '0', + `submitterId` int(11) default NULL, + `downloadratingsummary` double(6,4) NOT NULL default '0.0000', + `totalvotes` int(11) NOT NULL default '0', + `totalcomments` int(11) NOT NULL default '0', + `filesize` int(11) NOT NULL default '0', + `version` varchar(10) NOT NULL default '', + `homepage` varchar(200) NOT NULL default '', + PRIMARY KEY (`downloadId`), + KEY `categoryId` (`categoryId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_editorials` +-- + +DROP TABLE IF EXISTS `nuke_downloads_editorials`; +CREATE TABLE `nuke_downloads_editorials` ( + `editorialId` bigint(20) NOT NULL auto_increment, + `downloadId` bigint(20) default NULL, + `reviewerId` int(11) default NULL, + `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', + `editorial` text NOT NULL, + `title` varchar(100) NOT NULL default '', + PRIMARY KEY (`editorialId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_modrequest` +-- + +DROP TABLE IF EXISTS `nuke_downloads_modrequest`; +CREATE TABLE `nuke_downloads_modrequest` ( + `requestId` bigint(20) NOT NULL default '0', + `downloadId` bigint(20) default '0', + `categoryId` bigint(20) default '0', + `title` varchar(100) NOT NULL default '', + `url` varchar(100) NOT NULL default '', + `description` text NOT NULL, + `submitterId` int(11) default NULL, + `brokendownload` int(3) NOT NULL default '0', + `name` varchar(100) NOT NULL default '', + `email` varchar(100) NOT NULL default '', + `filesize` int(11) NOT NULL default '0', + `version` varchar(10) NOT NULL default '', + `homepage` varchar(200) NOT NULL default '', + PRIMARY KEY (`requestId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_newdownload` +-- + +DROP TABLE IF EXISTS `nuke_downloads_newdownload`; +CREATE TABLE `nuke_downloads_newdownload` ( + `downloadId` bigint(20) NOT NULL auto_increment, + `categoryId` bigint(20) default NULL, + `title` varchar(100) NOT NULL default '', + `url` varchar(100) NOT NULL default '', + `description` text NOT NULL, + `name` varchar(100) NOT NULL default '', + `email` varchar(100) NOT NULL default '', + `submitterId` int(11) default NULL, + `filesize` int(11) NOT NULL default '0', + `version` varchar(10) NOT NULL default '', + `homepage` varchar(200) NOT NULL default '', + PRIMARY KEY (`downloadId`), + KEY `categoryId` (`categoryId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_downloads_ratings` +-- + +DROP TABLE IF EXISTS `nuke_downloads_ratings`; +CREATE TABLE `nuke_downloads_ratings` ( + `ratingId` bigint(20) NOT NULL auto_increment, + `isOutside` tinyint(4) default NULL, + `rating` int(11) default NULL, + `hostname` varchar(250) binary default NULL, + `comments` varchar(250) binary default NULL, + `timestamp` datetime default NULL, + `userId` int(11) default NULL, + `downloadId` bigint(20) default NULL, + PRIMARY KEY (`ratingId`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_faq` +-- + +DROP TABLE IF EXISTS `nuke_faq`; +CREATE TABLE `nuke_faq` ( + `pn_question` varchar(250) binary default NULL, + `pn_submitter` varchar(250) binary default NULL, + `pn_answer` varchar(250) binary default NULL, + `pn_id` int(11) NOT NULL auto_increment, + `pn_category_id` int(11) default NULL, + PRIMARY KEY (`pn_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_faq_categories` +-- + +DROP TABLE IF EXISTS `nuke_faq_categories`; +CREATE TABLE `nuke_faq_categories` ( + `pn_name` varchar(250) binary default NULL, + `pn_language` varchar(250) binary default NULL, + `pn_id` int(11) NOT NULL auto_increment, + `pn_parent_id` int(11) default NULL, + PRIMARY KEY (`pn_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_file` +-- + +DROP TABLE IF EXISTS `nuke_file`; +CREATE TABLE `nuke_file` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_fid` varchar(255) NOT NULL default '', + `pn_uid` int(11) default NULL, + `pn_content_type` varchar(50) NOT NULL default '', + `pn_content` longblob NOT NULL, + `pn_timest` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_public` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`pn_id`), + KEY `pn_fid` (`pn_fid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_file_old` +-- + +DROP TABLE IF EXISTS `nuke_file_old`; +CREATE TABLE `nuke_file_old` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_fid` varchar(255) NOT NULL default '', + `pn_uid` int(11) default NULL, + `pn_content_type` varchar(50) NOT NULL default '', + `pn_content` longblob NOT NULL, + `pn_timest` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_public` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`pn_id`), + KEY `pn_fid` (`pn_fid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_filestat` +-- + +DROP TABLE IF EXISTS `nuke_filestat`; +CREATE TABLE `nuke_filestat` ( + `pn_vmid` varchar(16) NOT NULL default '', + `pn_id` bigint(20) NOT NULL default '0', + `pn_from` bigint(20) NOT NULL default '0', + `pn_length` bigint(20) NOT NULL default '0', + `pn_view_count` bigint(20) NOT NULL default '0', + PRIMARY KEY (`pn_vmid`,`pn_id`,`pn_from`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_group_membership` +-- + +DROP TABLE IF EXISTS `nuke_group_membership`; +CREATE TABLE `nuke_group_membership` ( + `pn_gid` int(11) NOT NULL default '0', + `pn_uid` int(11) NOT NULL default '0', + PRIMARY KEY (`pn_uid`,`pn_gid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_groups` +-- + +DROP TABLE IF EXISTS `nuke_groups`; +CREATE TABLE `nuke_groups` ( + `pn_gid` int(11) NOT NULL auto_increment, + `pn_name` varchar(255) NOT NULL default '', + PRIMARY KEY (`pn_gid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_journal` +-- + +DROP TABLE IF EXISTS `nuke_journal`; +CREATE TABLE `nuke_journal` ( + `pn_jid` int(11) NOT NULL auto_increment, + `pn_sid` int(11) default '0', + `pn_title` varchar(80) NOT NULL default '', + `pn_bodytext` text NOT NULL, + `pn_mood` varchar(48) NOT NULL default '', + `pn_pdate` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_status` tinyint(1) NOT NULL default '0', + `pn_mdate` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`pn_jid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_journal_comments` +-- + +DROP TABLE IF EXISTS `nuke_journal_comments`; +CREATE TABLE `nuke_journal_comments` ( + `pn_cid` int(11) NOT NULL auto_increment, + `pn_jid` int(11) default '0', + `pn_uid` int(11) NOT NULL default '0', + `pn_comment` text NOT NULL, + `pn_pdate` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`pn_cid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_journal_stats` +-- + +DROP TABLE IF EXISTS `nuke_journal_stats`; +CREATE TABLE `nuke_journal_stats` ( + `pn_sid` int(11) NOT NULL auto_increment, + `pn_uid` int(11) NOT NULL default '0', + `pn_nop` int(11) NOT NULL default '0', + `pn_lp` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_micro` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`pn_sid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_list_users` +-- + +DROP TABLE IF EXISTS `nuke_list_users`; +CREATE TABLE `nuke_list_users` ( + `pn_uid` int(11) NOT NULL auto_increment, + `pn_user_regdate` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_email` varchar(60) NOT NULL default '', + `pn_ip` varchar(128) NOT NULL default '', + `pn_pass` varchar(40) NOT NULL default '', + `pn_active` tinyint(1) default NULL, + PRIMARY KEY (`pn_uid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_news_comments` +-- + +DROP TABLE IF EXISTS `nuke_news_comments`; +CREATE TABLE `nuke_news_comments` ( + `comment_id` int(11) NOT NULL auto_increment, + `reason_id` int(11) NOT NULL default '0', + `score` int(11) NOT NULL default '0', + `subject` varchar(250) binary NOT NULL default '', + `comment` text NOT NULL, + `create_date` datetime NOT NULL default '0000-00-00 00:00:00', + `ip_addr` varchar(250) binary NOT NULL default '', + `parent_cid` int(11) default NULL, + `story_id` int(11) default NULL, + `author_id` int(11) default NULL, + PRIMARY KEY (`comment_id`), + KEY `nuke_news_comments_idx0` (`comment_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_news_stories` +-- + +DROP TABLE IF EXISTS `nuke_news_stories`; +CREATE TABLE `nuke_news_stories` ( + `allow_comments` tinyint(4) NOT NULL default '0', + `state` int(11) NOT NULL default '0', + `admin_notes` text, + `story_id` int(11) NOT NULL auto_increment, + `summary` text NOT NULL, + `ext_text` text NOT NULL, + `title` varchar(250) binary NOT NULL default '', + `views` int(11) NOT NULL default '0', + `create_date` datetime NOT NULL default '0000-00-00 00:00:00', + `ip_addr` varchar(250) binary NOT NULL default '', + `author_id` int(11) default NULL, + `topic_id` int(11) default NULL, + PRIMARY KEY (`story_id`), + KEY `nuke_news_stories_idx1` (`story_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_news_topics` +-- + +DROP TABLE IF EXISTS `nuke_news_topics`; +CREATE TABLE `nuke_news_topics` ( + `state` int(11) NOT NULL default '0', + `topic_id` int(11) NOT NULL auto_increment, + `image` varchar(250) binary default NULL, + `name` varchar(250) binary NOT NULL default '', + `text` varchar(250) binary NOT NULL default '', + `views` int(11) NOT NULL default '0', + `create_date` datetime NOT NULL default '0000-00-00 00:00:00', + `ip_addr` varchar(250) binary NOT NULL default '', + `creator_id` int(11) default NULL, + PRIMARY KEY (`topic_id`), + UNIQUE KEY `name` (`name`), + KEY `nuke_news_topics_idx0` (`topic_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_profile` +-- + +DROP TABLE IF EXISTS `nuke_profile`; +CREATE TABLE `nuke_profile` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_name` varchar(32) NOT NULL default '', + `pn_desc` varchar(255) NOT NULL default '', + `pn_status` tinyint(4) NOT NULL default '0', + `pn_usage` tinyint(4) NOT NULL default '0', + `pn_access` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`pn_id`), + UNIQUE KEY `pn_name` (`pn_name`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_property` +-- + +DROP TABLE IF EXISTS `nuke_property`; +CREATE TABLE `nuke_property` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_name` varchar(32) NOT NULL default '', + `pn_desc` varchar(255) NOT NULL default '', + `pn_type` tinyint(4) NOT NULL default '0', + `pn_prof_id` int(11) default NULL, + PRIMARY KEY (`pn_id`), + UNIQUE KEY `pn_prof_id` (`pn_prof_id`,`pn_name`), + KEY `pn_prof_id_2` (`pn_prof_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_property_default_value` +-- + +DROP TABLE IF EXISTS `nuke_property_default_value`; +CREATE TABLE `nuke_property_default_value` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_value` varchar(32) NOT NULL default '', + `pn_desc` varchar(255) NOT NULL default '', + `pn_order` tinyint(4) NOT NULL default '0', + `pn_property_id` int(11) default NULL, + PRIMARY KEY (`pn_id`), + KEY `pn_property_id` (`pn_property_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_property_value` +-- + +DROP TABLE IF EXISTS `nuke_property_value`; +CREATE TABLE `nuke_property_value` ( + `pn_id` int(11) NOT NULL auto_increment, + `pn_uid` int(11) default NULL, + `pn_property_id` int(11) default NULL, + `pn_value` varchar(255) NOT NULL default '', + PRIMARY KEY (`pn_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_services` +-- + +DROP TABLE IF EXISTS `nuke_services`; +CREATE TABLE `nuke_services` ( + `pn_sid` varchar(128) NOT NULL default '', + `pn_last_modified` bigint(20) NOT NULL default '0', + `pn_class_name` varchar(255) NOT NULL default '', + PRIMARY KEY (`pn_sid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_services_attributes` +-- + +DROP TABLE IF EXISTS `nuke_services_attributes`; +CREATE TABLE `nuke_services_attributes` ( + `pn_sid` varchar(128) NOT NULL default '', + `pn_aid` varchar(128) NOT NULL default '', + `pn_value` text, + PRIMARY KEY (`pn_sid`,`pn_aid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_services_attributes_old` +-- + +DROP TABLE IF EXISTS `nuke_services_attributes_old`; +CREATE TABLE `nuke_services_attributes_old` ( + `pn_sid` varchar(128) NOT NULL default '', + `pn_aid` varchar(128) NOT NULL default '', + `pn_value` text, + PRIMARY KEY (`pn_sid`,`pn_aid`) +) TYPE=InnoDB; + +-- +-- Table structure for table `nuke_users` +-- + +DROP TABLE IF EXISTS `nuke_users`; +CREATE TABLE `nuke_users` ( + `pn_uid` int(11) NOT NULL auto_increment, + `pn_uname` varchar(25) NOT NULL default '', + `pn_user_regdate` datetime NOT NULL default '0000-00-00 00:00:00', + `pn_user_viewemail` tinyint(1) NOT NULL default '1', + `pn_name` varchar(60) NOT NULL default '', + `pn_email` varchar(60) NOT NULL default '', + `pn_femail` varchar(60) NOT NULL default '', + `pn_url` varchar(254) NOT NULL default '', + `pn_timezone_offset` tinyint(4) NOT NULL default '0', + `pn_user_avatar` varchar(30) NOT NULL default 'blank.gif', + `pn_user_icq` varchar(15) NOT NULL default '', + `pn_user_aim` varchar(18) NOT NULL default '', + `pn_user_yim` varchar(25) NOT NULL default '', + `pn_user_msnm` varchar(25) NOT NULL default '', + `pn_user_from` varchar(100) NOT NULL default '', + `pn_user_lang` int(3) NOT NULL default '0', + `pn_user_occ` varchar(100) NOT NULL default '', + `pn_user_intrest` varchar(150) NOT NULL default '', + `pn_user_sig` varchar(255) NOT NULL default '', + `pn_bio` tinytext NOT NULL, + `pn_pass` varchar(40) NOT NULL default '', + `pn_theme` varchar(255) NOT NULL default '', + `pn_umode` varchar(10) NOT NULL default '', + `pn_uorder` tinyint(1) NOT NULL default '0', + `pn_thold` tinyint(1) NOT NULL default '0', + `pn_noscore` tinyint(1) NOT NULL default '0', + `pn_commentmax` int(11) NOT NULL default '4096', + `pn_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', + `pn_prev_last_visit` datetime NOT NULL default '1974-09-21 00:00:00', + `pn_question` tinytext NOT NULL, + `pn_answer` tinytext NOT NULL, + `pn_enabled` tinyint(1) NOT NULL default '1', + `pn_fname` varchar(60) default NULL, + `pn_lname` varchar(60) default NULL, + `pn_cname` varchar(80) default NULL, + `pn_street` varchar(125) default NULL, + `pn_city` varchar(80) default NULL, + `pn_state` varchar(30) default NULL, + `pn_zip` varchar(20) default NULL, + `pn_country` varchar(80) default NULL, + `pn_phone` varchar(30) default NULL, + `pn_usertype` varchar(20) default NULL, + `pn_companysize` varchar(10) default NULL, + `pn_role` varchar(20) default NULL, + `pn_interestinjboss` varchar(20) default NULL, + `pn_hardware` varchar(50) default NULL, + `pn_os` varchar(50) default NULL, + `pn_usingsince` varchar(10) default NULL, + `pn_firsthear` varchar(20) default NULL, + `pn_newsletter` tinyint(1) default '0', + `pn_salescontact` tinyint(1) default '0', + `pn_memberplusdate` datetime default '0000-00-00 00:00:00', + `pn_title` varchar(50) default NULL, + `pn_supportcontact` tinyint(1) default NULL, + PRIMARY KEY (`pn_uid`), + UNIQUE KEY `pn_uname` (`pn_uname`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_categories` +-- + +DROP TABLE IF EXISTS `phpbb_categories`; +CREATE TABLE `phpbb_categories` ( + `cat_id` mediumint(8) unsigned NOT NULL auto_increment, + `cat_title` varchar(100) NOT NULL default '', + `cat_order` mediumint(8) unsigned NOT NULL default '0', + PRIMARY KEY (`cat_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_forums` +-- + +DROP TABLE IF EXISTS `phpbb_forums`; +CREATE TABLE `phpbb_forums` ( + `forum_id` smallint(5) unsigned NOT NULL auto_increment, + `cat_id` mediumint(8) unsigned default NULL, + `forum_name` varchar(150) NOT NULL default '', + `forum_desc` text NOT NULL, + `forum_status` tinyint(4) NOT NULL default '0', + `forum_order` mediumint(8) unsigned NOT NULL default '1', + `forum_posts` mediumint(8) unsigned NOT NULL default '0', + `forum_topics` mediumint(8) unsigned NOT NULL default '0', + `forum_last_post_id` mediumint(8) unsigned default NULL, + `prune_next` int(11) default NULL, + `prune_enable` tinyint(1) NOT NULL default '0', + `auth_view` tinyint(2) NOT NULL default '0', + `auth_read` tinyint(2) NOT NULL default '0', + `auth_post` tinyint(2) NOT NULL default '1', + `auth_reply` tinyint(2) NOT NULL default '1', + `auth_edit` tinyint(2) NOT NULL default '3', + `auth_delete` tinyint(2) NOT NULL default '3', + `auth_sticky` tinyint(2) NOT NULL default '3', + `auth_announce` tinyint(2) NOT NULL default '3', + `auth_vote` tinyint(2) NOT NULL default '1', + `auth_pollcreate` tinyint(2) NOT NULL default '3', + `auth_attachments` tinyint(2) NOT NULL default '0', + PRIMARY KEY (`forum_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_forums_watch` +-- + +DROP TABLE IF EXISTS `phpbb_forums_watch`; +CREATE TABLE `phpbb_forums_watch` ( + `forum_id` mediumint(8) unsigned NOT NULL default '0', + `user_id` mediumint(8) NOT NULL default '0', + `watch_mode` tinyint(3) NOT NULL default '0', + PRIMARY KEY (`forum_id`,`user_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_posts` +-- + +DROP TABLE IF EXISTS `phpbb_posts`; +CREATE TABLE `phpbb_posts` ( + `post_id` mediumint(8) unsigned NOT NULL auto_increment, + `topic_id` mediumint(8) unsigned default NULL, + `forum_id` smallint(5) unsigned default NULL, + `poster_id` mediumint(11) default NULL, + `post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `poster_ip` varchar(8) NOT NULL default '', + `post_username` varchar(25) default NULL, + `enable_bbcode` tinyint(1) NOT NULL default '1', + `enable_html` tinyint(1) NOT NULL default '0', + `enable_smilies` tinyint(1) NOT NULL default '1', + `enable_sig` tinyint(1) NOT NULL default '1', + `post_edit_time` datetime NOT NULL default '0000-00-00 00:00:00', + `post_edit_count` smallint(5) unsigned NOT NULL default '0', + `post_subject` varchar(60) NOT NULL default '', + `post_text` text NOT NULL, + PRIMARY KEY (`post_id`), + KEY `topic_id` (`topic_id`), + KEY `forum_id` (`forum_id`), + KEY `phpbb_posts_topic_id` (`topic_id`), + KEY `phpbb_posts_forum_id` (`forum_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_topics` +-- + +DROP TABLE IF EXISTS `phpbb_topics`; +CREATE TABLE `phpbb_topics` ( + `topic_id` mediumint(8) unsigned NOT NULL auto_increment, + `forum_id` smallint(8) unsigned default NULL, + `topic_title` char(60) NOT NULL default '', + `topic_poster` mediumint(11) default NULL, + `topic_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_views` mediumint(8) unsigned NOT NULL default '0', + `topic_replies` mediumint(8) unsigned NOT NULL default '0', + `topic_status` tinyint(3) NOT NULL default '0', + `topic_vote` tinyint(1) NOT NULL default '0', + `topic_type` tinyint(3) NOT NULL default '0', + `topic_first_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_moved_id` mediumint(8) unsigned default NULL, + PRIMARY KEY (`topic_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_topics_watch` +-- + +DROP TABLE IF EXISTS `phpbb_topics_watch`; +CREATE TABLE `phpbb_topics_watch` ( + `topic_id` mediumint(8) unsigned NOT NULL default '0', + `user_id` mediumint(8) NOT NULL default '0', + `notify_status` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`topic_id`,`user_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_desc` +-- + +DROP TABLE IF EXISTS `phpbb_vote_desc`; +CREATE TABLE `phpbb_vote_desc` ( + `vote_id` mediumint(8) unsigned NOT NULL auto_increment, + `topic_id` mediumint(8) unsigned default NULL, + `vote_text` text NOT NULL, + `vote_start` int(11) NOT NULL default '0', + `vote_length` int(11) NOT NULL default '0', + PRIMARY KEY (`vote_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_results` +-- + +DROP TABLE IF EXISTS `phpbb_vote_results`; +CREATE TABLE `phpbb_vote_results` ( + `vote_option_id` mediumint(8) unsigned NOT NULL auto_increment, + `vote_desc_id` mediumint(8) unsigned default NULL, + `vote_option_text` varchar(255) NOT NULL default '', + `vote_result` int(11) NOT NULL default '0', + PRIMARY KEY (`vote_option_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `phpbb_vote_voters` +-- + +DROP TABLE IF EXISTS `phpbb_vote_voters`; +CREATE TABLE `phpbb_vote_voters` ( + `vote_id` mediumint(8) unsigned NOT NULL auto_increment, + `vote_desc_id` mediumint(8) unsigned default NULL, + `vote_user_id` mediumint(8) unsigned default NULL, + `vote_user_ip` char(8) NOT NULL default '', + PRIMARY KEY (`vote_id`) +) TYPE=InnoDB; + +-- +-- Table structure for table `tmp_posts` +-- + +DROP TABLE IF EXISTS `tmp_posts`; +CREATE TABLE `tmp_posts` ( + `post_id` mediumint(8) unsigned NOT NULL default '0', + `topic_id` mediumint(8) unsigned default NULL, + `forum_id` smallint(5) unsigned default NULL, + `poster_id` mediumint(11) default NULL, + `post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `poster_ip` varchar(8) NOT NULL default '', + `post_username` varchar(25) default NULL, + `enable_bbcode` tinyint(1) NOT NULL default '1', + `enable_html` tinyint(1) NOT NULL default '0', + `enable_smilies` tinyint(1) NOT NULL default '1', + `enable_sig` tinyint(1) NOT NULL default '1', + `post_edit_time` datetime NOT NULL default '0000-00-00 00:00:00', + `post_edit_count` smallint(5) unsigned NOT NULL default '0', + `post_subject` varchar(60) NOT NULL default '', + `post_text` text NOT NULL +) TYPE=InnoDB; + +-- +-- Table structure for table `tmp_topics` +-- + +DROP TABLE IF EXISTS `tmp_topics`; +CREATE TABLE `tmp_topics` ( + `topic_id` mediumint(8) unsigned NOT NULL default '0', + `forum_id` smallint(8) unsigned default NULL, + `topic_title` char(60) NOT NULL default '', + `topic_poster` mediumint(11) default NULL, + `topic_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_views` mediumint(8) unsigned NOT NULL default '0', + `topic_replies` mediumint(8) unsigned NOT NULL default '0', + `topic_status` tinyint(3) NOT NULL default '0', + `topic_vote` tinyint(1) NOT NULL default '0', + `topic_type` tinyint(3) NOT NULL default '0', + `topic_first_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_id` mediumint(8) unsigned default NULL, + `topic_last_post_time` datetime NOT NULL default '0000-00-00 00:00:00', + `topic_moved_id` mediumint(8) unsigned default NULL +) TYPE=InnoDB; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + Added: trunk/forge/portal-extensions/forge-forums/scripts/portal-keys.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/portal-keys.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/portal-keys.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,305 @@ +-- MySQL dump 10.9 +-- +-- Host: localhost Database: jbossportal +-- ------------------------------------------------------ +-- Server version 4.1.11 + +/*!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' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Current Database: `jbossportal` +-- + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jbossportal` /*!40100 DEFAULT CHARACTER SET latin1 */; + +USE `jbossportal`; + +-- +-- Table structure for table `jbp_forums_categories` +-- + +DROP TABLE IF EXISTS `jbp_forums_categories`; +CREATE TABLE `jbp_forums_categories` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_order` int(11) default NULL, + `jbp_title` varchar(255) default NULL, + PRIMARY KEY (`jbp_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_forums` +-- + +DROP TABLE IF EXISTS `jbp_forums_forums`; +CREATE TABLE `jbp_forums_forums` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_category_id` int(11) default NULL, + `jbp_description` varchar(255) default NULL, + `jbp_last_post_id` int(11) default NULL, + `jbp_name` varchar(255) default NULL, + `jbp_order` int(11) default NULL, + `jbp_topic_count` int(11) default NULL, + `jbp_post_count` int(11) default NULL, + `jbp_prune_enable` tinyint(1) default NULL, + `jbp_prune_next` int(11) default NULL, + `jbp_status` int(11) default NULL, + `jbp_type` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FK543743187E1ECA5A` (`jbp_category_id`), + KEY `FK54374318C1B3E31F` (`jbp_last_post_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_forumswatch` +-- + +DROP TABLE IF EXISTS `jbp_forums_forumswatch`; +CREATE TABLE `jbp_forums_forumswatch` ( + `jbp_id` int(11) NOT NULL default '0', + `jbp_forum_id` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FK3A89B0B776BE0BCA` (`jbp_id`), + KEY `FK3A89B0B77892A9BA` (`jbp_forum_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_poll_option` +-- + +DROP TABLE IF EXISTS `jbp_forums_poll_option`; +CREATE TABLE `jbp_forums_poll_option` ( + `jbp_poll_id` int(11) NOT NULL default '0', + `jbp_votes` int(11) NOT NULL default '0', + `jbp_question` varchar(255) NOT NULL default '', + `jbp_poll_option_position` int(11) NOT NULL default '0', + PRIMARY KEY (`jbp_poll_id`,`jbp_poll_option_position`), + KEY `FKFF2EB50F8050E3A` (`jbp_poll_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_poll_voted` +-- + +DROP TABLE IF EXISTS `jbp_forums_poll_voted`; +CREATE TABLE `jbp_forums_poll_voted` ( + `jbp_poll_id` int(11) NOT NULL default '0', + `jbp_poll_voted` int(11) NOT NULL default '0', + PRIMARY KEY (`jbp_poll_id`,`jbp_poll_voted`), + KEY `FK3A29E2E08050E3A` (`jbp_poll_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_polls` +-- + +DROP TABLE IF EXISTS `jbp_forums_polls`; +CREATE TABLE `jbp_forums_polls` ( + `jbp_poll_id` int(11) NOT NULL auto_increment, + `jbp_title` varchar(255) default NULL, + `jbp_length` int(11) default NULL, + `jbp_creation_date` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`jbp_poll_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_posters` +-- + +DROP TABLE IF EXISTS `jbp_forums_posters`; +CREATE TABLE `jbp_forums_posters` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_user_id` int(11) default NULL, + `jbp_post_count` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + UNIQUE KEY `jbp_user_id` (`jbp_user_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_posts` +-- + +DROP TABLE IF EXISTS `jbp_forums_posts`; +CREATE TABLE `jbp_forums_posts` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_topic_id` int(11) default NULL, + `jbp_edit_count` int(11) default NULL, + `jbp_edit_date` datetime default NULL, + `jbp_create_date` datetime default NULL, + `jbp_subject` varchar(255) default NULL, + `jbp_text` text, + `jbp_htmlenabled` tinyint(1) default NULL, + `jbp_poster_id` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FKF2C0436DBFB64FFA` (`jbp_topic_id`), + KEY `FKF2C0436D499BFC7A` (`jbp_poster_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_topics` +-- + +DROP TABLE IF EXISTS `jbp_forums_topics`; +CREATE TABLE `jbp_forums_topics` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_forum_id` int(11) default NULL, + `jbp_view_count` int(11) default NULL, + `jbp_replies` int(11) default NULL, + `jbp_first_post_id` int(11) default NULL, + `jbp_last_post_id` int(11) default NULL, + `jbp_last_post_date` datetime default NULL, + `jbp_poster` int(11) default NULL, + `jbp_type` int(11) default NULL, + `jbp_status` int(11) default NULL, + `jbp_subject` varchar(255) default NULL, + `jbp_poll` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FK6C1A04CA7892A9BA` (`jbp_forum_id`), + KEY `FK6C1A04CA925A910C` (`jbp_poll`), + KEY `FK6C1A04CAC1B3E31F` (`jbp_last_post_id`), + KEY `FK6C1A04CA577068CB` (`jbp_first_post_id`), + KEY `FK6C1A04CA145469A8` (`jbp_poster`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_topicswatch` +-- + +DROP TABLE IF EXISTS `jbp_forums_topicswatch`; +CREATE TABLE `jbp_forums_topicswatch` ( + `jbp_id` int(11) NOT NULL default '0', + `jbp_topic_id` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FK46F62E4576BE0BCA` (`jbp_id`), + KEY `FK46F62E45BFB64FFA` (`jbp_topic_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_watch` +-- + +DROP TABLE IF EXISTS `jbp_forums_watch`; +CREATE TABLE `jbp_forums_watch` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_poster_id` int(11) default NULL, + `jbp_mode` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FKF31C8C69499BFC7A` (`jbp_poster_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_role_membership` +-- + +DROP TABLE IF EXISTS `jbp_role_membership`; +CREATE TABLE `jbp_role_membership` ( + `jbp_rid` int(11) NOT NULL default '0', + `jbp_uid` int(11) NOT NULL default '0', + PRIMARY KEY (`jbp_uid`,`jbp_rid`), + KEY `FKF4101738A7430374` (`jbp_rid`), + KEY `FKF4101738E70E4BD7` (`jbp_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_roles` +-- + +DROP TABLE IF EXISTS `jbp_roles`; +CREATE TABLE `jbp_roles` ( + `jbp_rid` int(11) NOT NULL auto_increment, + `jbp_name` varchar(255) default NULL, + `jbp_displayname` varchar(255) default NULL, + PRIMARY KEY (`jbp_rid`), + UNIQUE KEY `jbp_name` (`jbp_name`), + UNIQUE KEY `jbp_displayname` (`jbp_displayname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_user_pref` +-- + +DROP TABLE IF EXISTS `jbp_user_pref`; +CREATE TABLE `jbp_user_pref` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_name` varchar(255) NOT NULL default '', + `jbp_type` int(11) default NULL, + `jbp_set_id` int(11) default NULL, + PRIMARY KEY (`jbp_id`), + KEY `FK93CC44D0AF499A90` (`jbp_set_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_user_pref_prop_value` +-- + +DROP TABLE IF EXISTS `jbp_user_pref_prop_value`; +CREATE TABLE `jbp_user_pref_prop_value` ( + `jbp_prop_id` int(11) NOT NULL default '0', + `jbp_value` varchar(255) default NULL, + `jbp_idx` int(11) NOT NULL default '0', + PRIMARY KEY (`jbp_prop_id`,`jbp_idx`), + KEY `FKC4963064D50D5281` (`jbp_prop_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_user_pref_set` +-- + +DROP TABLE IF EXISTS `jbp_user_pref_set`; +CREATE TABLE `jbp_user_pref_set` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_parent_id` int(11) default NULL, + `name` varchar(255) NOT NULL default '', + PRIMARY KEY (`jbp_id`), + KEY `FK97AA4873E3AFC41A` (`jbp_parent_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_user_prop` +-- + +DROP TABLE IF EXISTS `jbp_user_prop`; +CREATE TABLE `jbp_user_prop` ( + `jbp_uid` int(11) NOT NULL default '0', + `jbp_value` varchar(255) default NULL, + `jbp_name` varchar(255) NOT NULL default '', + PRIMARY KEY (`jbp_uid`,`jbp_name`), + KEY `FK93CC4610E70E4BD7` (`jbp_uid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_users` +-- + +DROP TABLE IF EXISTS `jbp_users`; +CREATE TABLE `jbp_users` ( + `jbp_uid` int(11) NOT NULL auto_increment, + `jbp_root_pref_set_id` int(11) default NULL, + `jbp_uname` varchar(255) default NULL, + `jbp_givenname` varchar(255) default NULL, + `jbp_familyname` varchar(255) default NULL, + `jbp_password` varchar(255) default NULL, + `jbp_realemail` varchar(255) default NULL, + `jbp_fakeemail` varchar(255) default NULL, + `jbp_regdate` datetime default NULL, + `jbp_viewrealemail` tinyint(1) default NULL, + `jbp_enabled` tinyint(1) default NULL, + PRIMARY KEY (`jbp_uid`), + UNIQUE KEY `jbp_uname` (`jbp_uname`), + KEY `FKF6060141FD4AFF8F` (`jbp_root_pref_set_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; + +/*!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 */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + Added: trunk/forge/portal-extensions/forge-forums/scripts/portal-pure.sql =================================================================== --- trunk/forge/portal-extensions/forge-forums/scripts/portal-pure.sql 2005-08-29 19:21:02 UTC (rev 1005) +++ trunk/forge/portal-extensions/forge-forums/scripts/portal-pure.sql 2005-08-29 20:35:56 UTC (rev 1006) @@ -0,0 +1,236 @@ +-- MySQL dump 10.9 +-- +-- Host: localhost Database: jbossportal +-- ------------------------------------------------------ +-- Server version 4.1.11 + +-- PORTAL DB STRUCTURE WITHOUT KEY INFORMATION (FOR A PAINLESS DATA IMPORT) + +-- +-- Table structure for table `jbp_forums_categories` +-- + +DROP TABLE IF EXISTS `jbp_forums_categories`; +CREATE TABLE `jbp_forums_categories` ( + `jbp_id` int(11) NOT NULL, + `jbp_order` int(11) default NULL, + `jbp_title` varchar(255) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_forums` +-- + +DROP TABLE IF EXISTS `jbp_forums_forums`; +CREATE TABLE `jbp_forums_forums` ( + `jbp_id` int(11) NOT NULL, + `jbp_category_id` int(11) default NULL, + `jbp_description` varchar(255) default NULL, + `jbp_last_post_id` int(11) default NULL, + `jbp_name` varchar(255) default NULL, + `jbp_order` int(11) default NULL, + `jbp_topic_count` int(11) default NULL, + `jbp_post_count` int(11) default NULL, + `jbp_prune_enable` tinyint(1) default NULL, + `jbp_prune_next` int(11) default NULL, + `jbp_status` int(11) default NULL, + `jbp_type` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_forumswatch` +-- + +DROP TABLE IF EXISTS `jbp_forums_forumswatch`; +CREATE TABLE `jbp_forums_forumswatch` ( + `jbp_id` int(11) NOT NULL default '0', + `jbp_forum_id` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_poll_option` +-- + +DROP TABLE IF EXISTS `jbp_forums_poll_option`; +CREATE TABLE `jbp_forums_poll_option` ( + `jbp_poll_id` int(11) NOT NULL default '0', + `jbp_votes` int(11) NOT NULL default '0', + `jbp_question` varchar(255) NOT NULL default '', + `jbp_poll_option_position` int(11) NOT NULL default '0' +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_poll_voted` +-- + +DROP TABLE IF EXISTS `jbp_forums_poll_voted`; +CREATE TABLE `jbp_forums_poll_voted` ( + `jbp_poll_id` int(11) NOT NULL default '0', + `jbp_poll_voted` int(11) NOT NULL default '0' +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_polls` +-- +DROP TABLE IF EXISTS `jbp_forums_polls`; +CREATE TABLE `jbp_forums_polls` ( + `jbp_poll_id` int(11) NOT NULL, + `jbp_title` varchar(255) default NULL, + `jbp_length` int(11) default NULL, + `jbp_creation_date` datetime NOT NULL default '0000-00-00 00:00:00' +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_posters` +-- + +DROP TABLE IF EXISTS `jbp_forums_posters`; +CREATE TABLE `jbp_forums_posters` ( + `jbp_id` int(11) NOT NULL, + `jbp_user_id` int(11) default NULL, + `jbp_post_count` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_posts` +-- + +DROP TABLE IF EXISTS `jbp_forums_posts`; +CREATE TABLE `jbp_forums_posts` ( + `jbp_id` int(11) NOT NULL, + `jbp_topic_id` int(11) default NULL, + `jbp_edit_count` int(11) default NULL, + `jbp_edit_date` datetime default NULL, + `jbp_create_date` datetime default NULL, + `jbp_subject` varchar(255) default NULL, + `jbp_text` text, + `jbp_htmlenabled` tinyint(1) default NULL, + `jbp_poster_id` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_topics` +-- + +DROP TABLE IF EXISTS `jbp_forums_topics`; +CREATE TABLE `jbp_forums_topics` ( + `jbp_id` int(11) NOT NULL, + `jbp_forum_id` int(11) default NULL, + `jbp_view_count` int(11) default NULL, + `jbp_replies` int(11) default NULL, + `jbp_first_post_id` int(11) default NULL, + `jbp_last_post_id` int(11) default NULL, + `jbp_last_post_date` datetime default NULL, + `jbp_poster` int(11) default NULL, + `jbp_type` int(11) default NULL, + `jbp_status` int(11) default NULL, + `jbp_subject` varchar(255) default NULL, + `jbp_poll` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_topicswatch` +-- + +DROP TABLE IF EXISTS `jbp_forums_topicswatch`; +CREATE TABLE `jbp_forums_topicswatch` ( + `jbp_id` int(11) NOT NULL default '0', + `jbp_topic_id` int(11) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_forums_watch` +-- + +DROP TABLE IF EXISTS `jbp_forums_watch`; +CREATE TABLE `jbp_forums_watch` ( + `jbp_id` int(11) NOT NULL auto_increment, + `jbp_poster_id` int(11) default NULL, + `jbp_mode` int(11) default NULL, + PRIMARY KEY (`jbp_id`) +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_role_membership` +-- + +DROP TABLE IF EXISTS `jbp_role_membership`; +CREATE TABLE `jbp_role_membership` ( + `jbp_rid` int(11) NOT NULL default '0', + `jbp_uid` int(11) NOT NULL default '0' +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_roles` +-- + +DROP TABLE IF EXISTS `jbp_roles`; +CREATE TABLE `jbp_roles` ( + `jbp_rid` int(11) NOT NULL, + `jbp_name` varchar(255) default NULL, + `jbp_displayname` varchar(255) default NULL +) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; + +-- +-- Table structure for table `jbp_user_pref` +-- + +DROP TABLE IF EXISTS `jbp_user_pref`... [truncated message content] |
