| Jforum_topics | UBB | Migration Notes | Parsed |
| topic_id integer NOT NULL DEFAULT nextval('jforum_topics_seq'::regclass), | n/a | Need to generate sequence | X |
| forum_id integer NOT NULL DEFAULT 0, | From folder name for forum | X | |
| topic_title character varying(100) NOT NULL DEFAULT ''::character varying, | 4: subject | X | |
| user_id integer NOT NULL DEFAULT 0, | 9: user id | X | |
| topic_time timestamp without time zone NOT NULL DEFAULT now(), | X | ||
| topic_views integer DEFAULT 1, | n/a | Leave default | |
| topic_replies integer DEFAULT 0, | Add up number of rows in file (minus 1 for subject row) | ||
| topic_status integer DEFAULT 0, | X | ||
| topic_vote_id integer DEFAULT 0, | n/a | Leave default | |
| topic_type integer DEFAULT 0, | Leave default | ||
| topic_first_post_id integer DEFAULT 0, | Derived from posts table | X | |
| topic_last_post_id integer NOT NULL DEFAULT 0, | Derived from posts table | X | |
| moderated integer DEFAULT 0, | n/a | Leave default | |
| topic_moved_id integer DEFAULT 0, | |||
| Jforum_posts | UBB | Migration Notes | Parsed |
| post_id integer NOT NULL DEFAULT nextval('jforum_posts_seq'::regclass), | n/a | Need to generate sequence | X |
| topic_id integer NOT NULL DEFAULT 0, | From topic table | X | |
| forum_id integer NOT NULL DEFAULT 0, | From folder name for forum | X | |
| user_id integer NOT NULL DEFAULT 0, | 11: Member id # | X | |
| post_time timestamp without time zone, | 3 & 4: post date and time | Format from string to timestamp | X |
| poster_ip character varying(15), | 7: Ip address | X | |
| enable_bbcode integer NOT NULL DEFAULT 1, | Leave default | ||
| enable_html integer NOT NULL DEFAULT 1, | Leave default | ||
| enable_smilies integer NOT NULL DEFAULT 1, | Leave default | ||
| enable_sig integer NOT NULL DEFAULT 1, | 12: sig | X | |
| post_edit_time timestamp without time zone, | UBB shows as text. Would be duplicate info if set here | ||
| post_edit_count integer NOT NULL DEFAULT 0, | UBB shows as text. Would be duplicate info if set here | ||
| status integer DEFAULT 1, | n/a | Leave default | |
| attach integer DEFAULT 0, | n/a | Leave default | |
| need_moderate integer DEFAULT 0, | n/a | Leave default | |
| last_edited_by_display_name character varying(70), | UBB shows as text. Would be duplicate info if set here | ||
| Jforum_posts_text | UBB | Migration Notes | Parsed |
| post_id integer NOT NULL, | From posts table | X | |
| post_text text, | 6: Post text with html | X | |
| post_subject character varying(100), | 4: subject | X |
| First row – subject | ||||
| Column # | UBB – current | UBB – old | UBB – Really old | |
| 0 | A | A | A | |
| 1 | <blank> | N | N | |
| 2 | 1 | 1 | 5 | |
| 3 | Topic starter user name | Topic starter display name | Topic starter display name | <display> if not logged in |
| 4 | Subject | Subject | Subject | |
| 5 | <blank> | |||
| 6 | 1 | |||
| 7 | Xfer meesage or blank | If moved to new forum | ||
| 8 | Topic starter display name | |||
| 9 | Member id # | Blank if not logged in | ||
| Subsequent rows – threads | ||||
| Column # | UBB – current | UBB – old | UBB – Really old | |
| 0 | Z | Z | Z | N=notifications, X=close thread |
| 1 | Post # in thread (starting with 0) | Post # in thread (starting with 0) | Post # in thread (starting with 0) | |
| 2 | User name | Display name | Display name | |
| 3 | Post date – 07-28-2008 | Post Date – 01-04-99 | Post date – 07-28-2008 | |
| 4 | Post time - 07:39 am | Post time - 07:39 am | Post time - 07:39 am | |
| 5 | ||||
| 6 | Post text with html | Post text with html | Post text with html | |
| 7 | Ip address | Ip address | ||
| 8 | Reg | Reg | Unreg if not logged in | |
| 9 | 1 | |||
| 10 | Display name | Blank if not logged in | ||
| 11 | Member id # | |||
| 12 | Sig |
| UBB tag | UBB HTML | Jforum Tag |
| Quote | <blockquote><font size="1" face="Verdana, Arial">quote:</font><hr>other quote<hr></blockquote> | [quote]test[/quote] |
| quote with qb | <blockquote><font size="1" face="Verdana, Arial">quote:</font><hr>Originally posted by Jeanne Boyarsky:<br /><strong>thumbs up:<br /> <img src="graemlins/thumb.gif" border="0" alt="[thumb]" /> <br /> <br /><img src="frown.gif" ><br /> <br />[ August 24, 2008: Message edited by: Jeanne Boyarsky ]</strong><hr></blockquote> | [quote=Jeanne Boyarsky]test[/quote] |
| Code | <blockquote><font size="1" face="Verdana, Arial">code:</font><hr><pre><font size="2">public static void main(String[] args) {<br /> System.out.println("UBB tags galore");<br />}</font></pre><hr></blockquote> | Code |
| url | <a href="http://www.javaranch.com" target="_blank">JavaRanch</a> | [url=http://www.jr.com]test[/url] |
| B | <b>bold</b> | B |
| I | <i>italics</i> | I |
| List | <ul type="square"><li>one<li>two<li>three</ul> | [list]test[/list] |
| List = A | <ol type="A"><li> a<li> <b>b</b><br /></ol> | [list]test[/list] |
| List = 1 | <ol type="1"><li>c<li>d.<br /></ol> | [list]test[/list] |
| img | <img src="http://saloon.javaranch.com/ubb/moosefly.gif"> | [img]img[/img] |
| n/a | <br /> | \n |
| n/a | <p> edited by </p> | Make line breaks before and after |
| <a href="mailto:jeanne@javaranch.com">jeanne@javaranch.com</a> | n/a – just put e-mail |