Menu
▾
▴
[Jboss-svn-commits] JBL Code SVN: r1026 - in prod/forge: . portal-extensions/forge-forums portal-extensions/forge-forums/scripts portal-extensions/forge-prj-freezone/src/java/org/jboss/forge/projects/freezone portal-extensions/forge-wiki portal-extensions/forge-wiki/docs portal-extensions/forge-wiki/lib portal-extensions/forge-wiki/src/etc portal-extensions/forge-wiki/src/etc/org/jboss/wiki portal-extensions/forge-wiki/src/java/org/jboss/wiki portal-extensions/forge-wiki/src/java/org/jboss/wiki/management portal-extensions/forge-wiki/src/java/org/jboss/wiki/plugins portal-extensions/forge-wiki/src/web/WEB-INF/jsp portal-extensions/forge-wiki/src/web/WEB-INF/tld
Author: dam...@jb... Date: 2005-08-30 18:57:05 -0400 (Tue, 30 Aug 2005) New Revision: 1026 Added: prod/forge/portal-extensions/forge-forums/scripts/ prod/forge/portal-extensions/forge-forums/scripts/all.sql prod/forge/portal-extensions/forge-forums/scripts/conv.sql prod/forge/portal-extensions/forge-forums/scripts/diff.sql prod/forge/portal-extensions/forge-forums/scripts/nukes3.sql prod/forge/portal-extensions/forge-forums/scripts/portal-keys.sql prod/forge/portal-extensions/forge-forums/scripts/portal-pure.sql prod/forge/portal-extensions/forge-forums/scripts/test.sql prod/forge/portal-extensions/forge-wiki/docs/wiki-reversed.zuml prod/forge/portal-extensions/forge-wiki/lib/ prod/forge/portal-extensions/forge-wiki/lib/cglib2.jar prod/forge/portal-extensions/forge-wiki/lib/commons-beanutils.jar prod/forge/portal-extensions/forge-wiki/lib/commons-collections.jar prod/forge/portal-extensions/forge-wiki/lib/commons-lang.jar prod/forge/portal-extensions/forge-wiki/lib/commons-logging.jar prod/forge/portal-extensions/forge-wiki/lib/dom4j.jar prod/forge/portal-extensions/forge-wiki/lib/ehcache.jar prod/forge/portal-extensions/forge-wiki/lib/hibernate2.jar prod/forge/portal-extensions/forge-wiki/lib/hsqldb.jar prod/forge/portal-extensions/forge-wiki/lib/informa.jar prod/forge/portal-extensions/forge-wiki/lib/jdbc2_0-stdext.jar prod/forge/portal-extensions/forge-wiki/lib/jdom.jar prod/forge/portal-extensions/forge-wiki/lib/jta.jar prod/forge/portal-extensions/forge-wiki/lib/log4j-1.2.8.jar prod/forge/portal-extensions/forge-wiki/lib/lucene.jar prod/forge/portal-extensions/forge-wiki/lib/odmg.jar prod/forge/portal-extensions/forge-wiki/lib/xalan.jar prod/forge/portal-extensions/forge-wiki/lib/xml-apis.jar prod/forge/portal-extensions/forge-wiki/src/etc/application.xml prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/WikiCommon.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/ prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiService.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceLocal.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceMenagement.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceRemote.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/plugins/RSSPlugin.java Removed: prod/forge/portal-content/ prod/forge/portal-extensions/forge-forums/scripts/all.sql prod/forge/portal-extensions/forge-forums/scripts/conv.sql prod/forge/portal-extensions/forge-forums/scripts/diff.sql prod/forge/portal-extensions/forge-forums/scripts/nukes3.sql prod/forge/portal-extensions/forge-forums/scripts/portal-keys.sql prod/forge/portal-extensions/forge-forums/scripts/portal-pure.sql prod/forge/portal-extensions/forge-forums/scripts/test.sql prod/forge/portal-extensions/forge-wiki/lib/cglib2.jar prod/forge/portal-extensions/forge-wiki/lib/commons-beanutils.jar prod/forge/portal-extensions/forge-wiki/lib/commons-collections.jar prod/forge/portal-extensions/forge-wiki/lib/commons-lang.jar prod/forge/portal-extensions/forge-wiki/lib/commons-logging.jar prod/forge/portal-extensions/forge-wiki/lib/dom4j.jar prod/forge/portal-extensions/forge-wiki/lib/ehcache.jar prod/forge/portal-extensions/forge-wiki/lib/hibernate2.jar prod/forge/portal-extensions/forge-wiki/lib/hsqldb.jar prod/forge/portal-extensions/forge-wiki/lib/informa.jar prod/forge/portal-extensions/forge-wiki/lib/jdbc2_0-stdext.jar prod/forge/portal-extensions/forge-wiki/lib/jdom.jar prod/forge/portal-extensions/forge-wiki/lib/jta.jar prod/forge/portal-extensions/forge-wiki/lib/log4j-1.2.8.jar prod/forge/portal-extensions/forge-wiki/lib/lucene.jar prod/forge/portal-extensions/forge-wiki/lib/odmg.jar prod/forge/portal-extensions/forge-wiki/lib/xalan.jar prod/forge/portal-extensions/forge-wiki/lib/xml-apis.jar prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiService.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceLocal.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceMenagement.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/management/WikiServiceRemote.java Modified: prod/forge/portal-extensions/forge-prj-freezone/src/java/org/jboss/forge/projects/freezone/Freezone.java prod/forge/portal-extensions/forge-wiki/maven.xml prod/forge/portal-extensions/forge-wiki/project.properties prod/forge/portal-extensions/forge-wiki/project.xml prod/forge/portal-extensions/forge-wiki/src/etc/org/jboss/wiki/WikiTypes.xml prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/WikiPortlet.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/WikiType.java prod/forge/portal-extensions/forge-wiki/src/java/org/jboss/wiki/plugins/HTMLTranslator.java prod/forge/portal-extensions/forge-wiki/src/web/WEB-INF/jsp/Wiki.jsp prod/forge/portal-extensions/forge-wiki/src/web/WEB-INF/tld/wiki.tld Log: MERGED: -r 1020:1025 https://svn.labs.jboss.com/qa/forge into prod forge. Still need to add the eloqua tracking links. Copied: prod/forge/portal-extensions/forge-forums/scripts (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts) Deleted: prod/forge/portal-extensions/forge-forums/scripts/all.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/all.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/all.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,13 +0,0 @@ --- THIS SHOULD BE RUN ON AN EXISTING NUKES3 DATABASE. PORTAL FORUMS TABLES AND --- PORTAL USERS TABLES WILL BE CREATED AND POPULATED WITH DATA. - -\. portal-pure.sql -\. conv.sql -\. portal-keys.sql - --- AFTER ADDING THE KEYS: UPDATING POST COUNT - --- ANY IDEAS WHY THIS ISN'T WORKING? ---UPDATE jbp_forums_posters posters SET posters.jbp_post_count = 10; ---- (SELECT COUNT(posts.jbp_id) FROM jbp_forums_posts posts WHERE --- posts.jbp_poster_id = posters.jbp_id); Copied: prod/forge/portal-extensions/forge-forums/scripts/all.sql (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts/all.sql) Deleted: prod/forge/portal-extensions/forge-forums/scripts/conv.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/conv.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/conv.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,97 +0,0 @@ --- 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; - --- 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"; Copied: prod/forge/portal-extensions/forge-forums/scripts/conv.sql (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts/conv.sql) Deleted: prod/forge/portal-extensions/forge-forums/scripts/diff.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/diff.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/diff.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,263 +0,0 @@ --- 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 portlet, 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: 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; - Copied: prod/forge/portal-extensions/forge-forums/scripts/diff.sql (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts/diff.sql) Deleted: prod/forge/portal-extensions/forge-forums/scripts/nukes3.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/nukes3.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/nukes3.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,759 +0,0 @@ --- 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 */; - Copied: prod/forge/portal-extensions/forge-forums/scripts/nukes3.sql (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts/nukes3.sql) Deleted: prod/forge/portal-extensions/forge-forums/scripts/portal-keys.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/portal-keys.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/portal-keys.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,113 +0,0 @@ --- ADDING KEYS AND INDEXES TO EXISITING PORTAL TABLES - AFTER A DATA IMPORT - --- --- Table structure for table `jbp_forums_categories` --- - -ALTER TABLE jbp_forums_categories - MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id); - --- --- Table structure for table `jbp_forums_forums` --- - -ALTER TABLE jbp_forums_forums MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id), - ADD INDEX (jbp_category_id), - ADD INDEX (jbp_last_post_id), - ADD FOREIGN KEY (jbp_category_id) REFERENCES jbp_forums_categories (jbp_id), - ADD FOREIGN KEY (jbp_last_post_id) REFERENCES jbp_forums_posts (jbp_id); - --- --- Table structure for table `jbp_forums_forumswatch` --- - -ALTER TABLE jbp_forums_forumswatch - ADD PRIMARY KEY (jbp_id), - ADD INDEX (jbp_forum_id), - ADD FOREIGN KEY (jbp_forum_id) REFERENCES jbp_forums_forums (jbp_id), - ADD FOREIGN KEY (jbp_id) REFERENCES jbp_forums_watch (jbp_id); - --- --- Table structure for table `jbp_forums_poll_option` --- - -ALTER TABLE jbp_forums_poll_option - ADD PRIMARY KEY (jbp_poll_id, jbp_poll_option_position), - ADD INDEX (jbp_poll_id), - ADD FOREIGN KEY (jbp_poll_id) REFERENCES jbp_forums_polls (jbp_id); - --- --- Table structure for table `jbp_forums_poll_voted` --- - -ALTER TABLE jbp_forums_poll_voted - ADD PRIMARY KEY (jbp_poll_id, jbp_poll_voted), - ADD INDEX (jbp_poll_id), - ADD FOREIGN KEY (jbp_poll_id) REFERENCES jbp_forums_polls (jbp_id); - --- --- Table structure for table `jbp_forums_polls` --- - -ALTER TABLE jbp_forums_polls - MODIFY jbp_poll_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_poll_id); - --- --- Table structure for table `jbp_forums_posters` --- - -ALTER TABLE jbp_forums_posters - MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id), - ADD UNIQUE (jbp_user_id); - --- --- Table structure for table `jbp_forums_posts` --- - -ALTER TABLE jbp_forums_posts - MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id), - ADD INDEX (jbp_topic_id), - ADD INDEX (jbp_poster_id), - ADD FOREIGN KEY (jbp_topic_id) REFERENCES jbp_forums_topics (jbp_id), - ADD FOREIGN KEY (jbp_poster_id) REFERENCES jbp_forums_posters (jbp_id); - --- --- Table structure for table `jbp_forums_topics` --- - -ALTER TABLE jbp_forums_topics - MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id), - ADD INDEX (jbp_forum_id), - ADD INDEX (jbp_poll), - ADD INDEX (jbp_last_post_id), - ADD INDEX (jbp_first_post_id), - ADD INDEX (jbp_poster), - ADD FOREIGN KEY (jbp_forum_id) REFERENCES jbp_forums_forums (jbp_id), - ADD FOREIGN KEY (jbp_poll) REFERENCES jbp_forums_polls (jbp_id), - ADD FOREIGN KEY (jbp_last_post_id) REFERENCES jbp_forums_posts (jbp_id), - ADD FOREIGN KEY (jbp_first_post_id) REFERENCES jbp_forums_posts (jbp_id), - ADD FOREIGN KEY (jbp_poster) REFERENCES jbp_forums_posters (jbp_id); - --- --- Table structure for table `jbp_forums_topicswatch` --- - --- AS THIS FEATURE IS NOT YET IMPLEMENTED, LEAVING IT OUT. - --- --- Table structure for table `jbp_forums_watch` --- - -ALTER TABLE jbp_forums_watch - MODIFY jbp_id int(11) NOT NULL auto_increment, - ADD PRIMARY KEY (jbp_id), - ADD INDEX (jbp_poster_id), - ADD FOREIGN KEY (jbp_poster_id) REFERENCES jbp_forums_posters (jbp_id); - --- REST OF THE TABLES ALREADY HAVE KEY INFO. Copied: prod/forge/portal-extensions/forge-forums/scripts/portal-keys.sql (from rev 1025, qa/forge/portal-extensions/forge-forums/scripts/portal-keys.sql) Deleted: prod/forge/portal-extensions/forge-forums/scripts/portal-pure.sql =================================================================== --- qa/forge/portal-extensions/forge-forums/scripts/portal-pure.sql 2005-08-30 22:23:01 UTC (rev 1025) +++ prod/forge/portal-extensions/forge-forums/scripts/portal-pure.sql 2005-08-30 22:57:05 UTC (rev 1026) @@ -1,249 +0,0 @@ --- 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, - `jbp_poster_id` int(11) default NULL, - `jbp_mode` int(11) default NULL -) ENGINE=MyISAM; -- DEFAULT CHARSET=latin1; - --- FROM NOW ON, KEY INFORMATION IS PRESENT - IT DOES NOT CONFILCT WITH DATA --- IMPORT. - --- --- 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) defau... [truncated message content] |
