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

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

Author: adamw
Date: 2005-09-27 10:24:12 -0400 (Tue, 27 Sep 2005)
New Revision: 1221

Modified:
   trunk/forge/portal-extensions/forge-forums/scripts/all.sql
   trunk/forge/portal-extensions/forge-forums/scripts/conv.sql
Log:
User properties import


Modified: trunk/forge/portal-extensions/forge-forums/scripts/all.sql
===================================================================
--- trunk/forge/portal-extensions/forge-forums/scripts/all.sql	2005-09-27 13:23:35 UTC (rev 1220)
+++ trunk/forge/portal-extensions/forge-forums/scripts/all.sql	2005-09-27 14:24:12 UTC (rev 1221)
@@ -5,7 +5,3 @@
 \. conv.sql
 \. portal-keys.sql
 \. fix.sql
-
--- TODO:
--- - migrate topics watch
--- - lost fields - what's with them?

Modified: trunk/forge/portal-extensions/forge-forums/scripts/conv.sql
===================================================================
--- trunk/forge/portal-extensions/forge-forums/scripts/conv.sql	2005-09-27 13:23:35 UTC (rev 1220)
+++ trunk/forge/portal-extensions/forge-forums/scripts/conv.sql	2005-09-27 14:24:12 UTC (rev 1221)
@@ -102,3 +102,65 @@
 	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";
+
+-- Importing user properties.
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.im.aim", n.pn_user_aim
+		FROM nuke_users n
+		WHERE n.pn_user_aim IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.im.icq", n.pn_user_icq
+		FROM nuke_users n
+		WHERE n.pn_user_icq IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.im.msnm", n.pn_user_msnm
+		FROM nuke_users n
+		WHERE n.pn_user_msnm IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.interests", n.pn_user_intrest
+		FROM nuke_users n
+		WHERE n.pn_user_intrest IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.homepage", n.pn_url
+		FROM nuke_users n
+		WHERE n.pn_url IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.occupation", n.pn_user_occ
+		FROM nuke_users n
+		WHERE n.pn_user_occ IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.signature", n.pn_user_sig
+		FROM nuke_users n
+		WHERE n.pn_user_sig IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.im.yim", n.pn_user_yim
+		FROM nuke_users n
+		WHERE n.pn_user_yim IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.time-zone-offset", n.pn_timezone_offset
+		FROM nuke_users n
+		WHERE n.pn_timezone_offset IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.location", n.pn_user_from
+		FROM nuke_users n
+		WHERE n.pn_user_from IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.security.answer", n.pn_answer
+		FROM nuke_users n
+		WHERE n.pn_answer IS NOT NULL;
+
+INSERT INTO jbp_user_prop (jbp_uid, jbp_name, jbp_value)
+	SELECT n.pn_uid, "portal.user.security.question", n.pn_question
+		FROM nuke_users n
+		WHERE n.pn_question IS NOT NULL;
+