Overview

JForum
UBB

Sheet 1: JForum
Jforum UBB Migration Notes Parsed
user_id integer NOT NULL DEFAULT nextval('jforum_users_seq'::regclass), n/a Need to generate sequence X
user_active integer,
Default to 1
username character varying(50) NOT NULL DEFAULT ''::character varying, 0. login name Check max length X
user_password character varying(32) NOT NULL DEFAULT ''::character varying, 1. password Encrypt before add, check max length X
user_session_time integer NOT NULL DEFAULT 0, n/a Leave default
user_session_page integer NOT NULL DEFAULT 0, n/a Leave default
user_lastvisit timestamp without time zone NOT NULL DEFAULT now(), n/a Leave default
user_regdate timestamp without time zone NOT NULL DEFAULT now(), 10. Join date mm-dd-yyyy Parse date X
user_level integer,
Stay blank
user_posts integer NOT NULL DEFAULT 0, 7. Post count
X
user_timezone character varying(5) NOT NULL DEFAULT ''::character varying,
Leave default – user can change in profile after
user_style integer,
Leave default – user can change in profile after
user_lang character varying(255),
Leave default – user can change in profile after
user_dateformat character varying(20) NOT NULL DEFAULT '%d/%M/%Y %H:%i'::character varying, n/a Leave default
user_new_privmsg integer NOT NULL DEFAULT 0, n/a Leave default
user_unread_privmsg integer NOT NULL DEFAULT 0, n/a Leave default
user_last_privmsg timestamp without time zone,
Leave default – no Pms
user_emailtime timestamp without time zone,
Leave default – no Pms
user_viewemail integer DEFAULT 0, 11. yes/no show email address
X
user_attachsig integer DEFAULT 1, n/a Leave default
user_allowhtml integer DEFAULT 0, n/a Leave default
user_allowbbcode integer DEFAULT 1, n/a Leave default
user_allowsmilies integer DEFAULT 1, n/a Leave default
user_allowavatar integer DEFAULT 1, n/a Leave default
user_allow_pm integer DEFAULT 1, 27 yes/no accept PMs Yes/no --> 1/0 X
user_allow_viewonline integer DEFAULT 1, n/a Leave default
user_notify integer DEFAULT 1,
Leave default – no notification
user_notify_pm integer DEFAULT 1, 28 yes/no email notify for Pms Yes/no --> 1/0 X
user_popup_pm integer DEFAULT 1,
Leave default – no notification
rank_id integer DEFAULT 0, 8. Member/Junior Member/Administrator/Moderator
X
user_avatar character varying(100), n/a Leave default
user_avatar_type integer NOT NULL DEFAULT 0, n/a Leave default
user_email character varying(255) NOT NULL DEFAULT ''::character varying, 2. email
X
user_icq character varying(15),
Leave default – n/a
user_website character varying(255), 3. Homepage
X
user_from character varying(100),
Leave default – n/a
user_sig text, 12. Sig Migrate any UBB characters (links)
user_sig_bbcode_uid character varying(10),
Leave default – n/a
user_aim character varying(255),
Leave default – n/a
user_yim character varying(255),
Leave default – n/a
user_msnm character varying(255),
Leave default – n/a
user_occ character varying(100),
Leave default – n/a
user_interests character varying(255),
Leave default – n/a
user_biography text,
Leave default – n/a
user_actkey character varying(32),
Leave default – n/a
gender character(1),
Leave default – n/a
themes_id integer,
Leave default – n/a
deleted integer, 24 yes if profile locked; blank otherwise Yes --> 1, other --> blank X
user_viewonline integer DEFAULT 1,
Leave default – n/a
security_hash character varying(32),
Leave default – n/a
user_karma numeric(10,2),
Leave default – n/a
user_authhash character varying(32),
Leave default – n/a
user_notify_always integer DEFAULT 0,
Leave default – n/a
user_notify_text integer DEFAULT 0,
Leave default – n/a
user_first_name character varying(35) NOT NULL DEFAULT ''::character varying, 15 Display name Parse up through first space X
user_last_name character varying(35) NOT NULL DEFAULT ''::character varying, 15 Display name Parse up through last space X
custom_title 31 custom title
X
user_picture 20 Picture
X




Also, UBB line 4 controls if user banned/disabled


Sheet 2: UBB
UBB Mapped to Jforum
0. login name Yes
1. password Yes
2. email Yes
3. Homepage Yes
4. Permissions. Write or AdminWrite & forumid,forumid,forumid; no No – setup via roles
"Write" if unable to post notes
5 n/a
6 n/a
7. Post count Yes
8. Member/Junior Member/Administrator/Moderator Yes
9 n/a
10. Join date mm-dd-yyyy Yes
11. yes/no show email address Yes
12. Sig Yes
13 n/a
14 yes/no Can we send you email
15 Display name Yes
16 n/a
17 n/a
18 n/a
19 n/a
20 Picture Yes
21 Default topic view day count ?
22 n/a
23 Display name of last profile editor |^| member number of last profile editor |^| Profile last edited date mm-dd-yyyy No – happens through moderation log
24 yes if profile locked; blank otherwise Yes
25 yes/no show user rating No – don't use this in UBB
26 n/a
27 yes/no accept PMs Yes
28 yes/no email notify for PMs Yes
29 yes/no Can send PMs ? - do we need this
30 Last post date|forum|thread number|post in thread ? not needed
31 custom title, if present Yes