[Jboss-svn-commits] JBL Code SVN: r1018 - trunk/forge/portal-extensions/forge-forums/scripts

[<jbo...@li...>]

Author: adamw
Date: 2005-08-30 16:12:06 -0400 (Tue, 30 Aug 2005)
New Revision: 1018

Modified:
   trunk/forge/portal-extensions/forge-forums/scripts/all.sql
   trunk/forge/portal-extensions/forge-forums/scripts/conv.sql
Log:
Newer scripts for forums migration


Modified: trunk/forge/portal-extensions/forge-forums/scripts/all.sql
===================================================================
--- trunk/forge/portal-extensions/forge-forums/scripts/all.sql	2005-08-30 19:40:45 UTC (rev 1017)
+++ trunk/forge/portal-extensions/forge-forums/scripts/all.sql	2005-08-30 20:12:06 UTC (rev 1018)
@@ -6,8 +6,5 @@
 \. 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);
+-- UPDATE jbp_forums_posters posters  SET posters.jbp_post_count = (SELECT COUNT(posts.jbp_id) 
+-- FROM jbp_forums_posts posts WHERE posts.jbp_poster_id = posters.jbp_id);

Modified: trunk/forge/portal-extensions/forge-forums/scripts/conv.sql
===================================================================
--- trunk/forge/portal-extensions/forge-forums/scripts/conv.sql	2005-08-30 19:40:45 UTC (rev 1017)
+++ trunk/forge/portal-extensions/forge-forums/scripts/conv.sql	2005-08-30 20:12:06 UTC (rev 1018)
@@ -1,11 +1,5 @@
 -- 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
@@ -38,7 +32,7 @@
 		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;
+UPDATE jbp_forums_forums SET jbp_prune_next=0 WHERE jbp_prune_next IS NULL;
 
 -- Copying data from forumswatch - two tables required here.
 -- First inserting user+mode data.