Project

General

Profile

Forum conversion » History » Version 2

Amber Herold, 07/06/2010 03:05 PM

1 1 Amber Herold
h1. Forum conversion
2
3
Notes on porting the Leginon BB to Redmine
4
5
6
h2. Redmine DB Tables
7
8
+Messages+
9
10
id   	  board_id   	  parent_id   	  subject   	  content   	  author_id   	  replies_count   	  last_reply_id   	  created_on   	  updated_on   	  locked   	  sticky
11
12
+Boards+
13
14
id   	  project_id   	  name   	  description   	  position   	  topics_count   	  messages_count   	  last_message_id
15
16
17
+Users+
18
19
id   	  login   	  hashed_password   	  firstname   	  lastname   	  mail   	  mail_notification   	  admin   	  status   	  last_login_on   	  language   	  auth_source_id   	  created_on   	  updated_on   	  type   	  identity_url
20
21
22
h2. BB DB Tables
23 2 Amber Herold
24
+Notre_forums+
25
26
forum_id   	  parent_id   	  left_id   	  right_id   	  forum_parents   	  forum_name   	  forum_desc   	  forum_desc_bitfield   	  forum_desc_options   	  forum_desc_uid   	  forum_link   	  forum_password   	  forum_style   	  forum_image   	  forum_rules   	  forum_rules_link   	  forum_rules_bitfield   	  forum_rules_options   	  forum_rules_uid   	  forum_topics_per_page   	  forum_type   	  forum_status   	  forum_posts   	  forum_topics   	  forum_topics_real   	  forum_last_post_id   	  forum_last_poster_id   	  forum_last_post_subject   	  forum_last_post_time   	  forum_last_poster_name   	  forum_last_poster_colour   	  forum_flags   	  display_subforum_list   	  display_on_index   	  enable_indexing   	  enable_icons   	  enable_prune   	  prune_next   	  prune_days   	  prune_viewed   	  prune_freq