Project

General

Profile

Edit History

Forum conversion » History » Version 9

Amber Herold, 07/07/2010 11:23 AM

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





    27
    3
    Amber Herold
    





    28
    
    
    
+Notre_posts+





    29
    
    
    





    30
    
    
    
post_id   	  topic_id   	  forum_id   	  poster_id   	  icon_id   	  poster_ip   	  post_time   	  post_approved   	  post_reported   	  enable_bbcode   	  enable_smilies   	  enable_magic_url   	  enable_sig   	  post_username   	  post_subject   	  post_text   	  post_checksum   	  post_attachment   	  bbcode_bitfield   	  bbcode_uid   	  post_postcount   	  post_edit_time   	  post_edit_reason   	  post_edit_user   	  post_edit_count   	  post_edit_locked





    31
    
    
    





    32
    4
    Amber Herold
    





    33
    
    
    





    34
    
    
    
+Notre_topics+





    35
    
    
    





    36
    
    
    
topic_id   	  forum_id   	  icon_id   	  topic_attachment   	  topic_approved   	  topic_reported   	  topic_title   	  topic_poster   	  topic_time   	  topic_time_limit   	  topic_views   	  topic_replies   	  topic_replies_real   	  topic_status   	  topic_type   	  topic_first_post_id   	  topic_first_poster_name   	  topic_first_poster_colour   	  topic_last_post_id   	  topic_last_poster_id   	  topic_last_poster_name   	  topic_last_poster_colour   	  topic_last_post_subject   	  topic_last_post_time   	  topic_last_view_time   	  topic_moved_id   	  topic_bumped   	  topic_bumper   	  poll_title   	  poll_start   	  poll_length   	  poll_max_options   	  poll_last_vote   	  poll_vote_change





    37
    
    
    





    38
    3
    Amber Herold
    
+Notre_users+





    39
    
    
    





    40
    
    
    
user_id   	  user_type   	  group_id   	  user_permissions   	  user_perm_from   	  user_ip   	  user_regdate   	  username   	  username_clean   	  user_password   	  user_passchg   	  user_pass_convert   	  user_email   	  user_email_hash   	  user_birthday   	  user_lastvisit   	  user_lastmark   	  user_lastpost_time   	  user_lastpage   	  user_last_confirm_key   	  user_last_search   	  user_warnings   	  user_last_warning   	  user_login_attempts   	  user_inactive_reason   	  user_inactive_time   	  user_posts   	  user_lang   	  user_timezone   	  user_dst   	  user_dateformat   	  user_style   	  user_rank   	  user_colour   	  user_new_privmsg   	  user_unread_privmsg   	  user_last_privmsg   	  user_message_rules   	  user_full_folder   	  user_emailtime   	  user_topic_show_days   	  user_topic_sortby_type   	  user_topic_sortby_dir   	  user_post_show_days   	  user_post_sortby_type   	  user_post_sortby_dir   	  user_notify   	  user_notify_pm   	  user_notify_type   	  user_allow_pm   	  user_allow_viewonline   	  user_allow_viewemail   	  user_allow_massemail   	  user_options   	  user_avatar   	  user_avatar_type   	  user_avatar_width   	  user_avatar_height   	  user_sig   	  user_sig_bbcode_uid   	  user_sig_bbcode_bitfield   	  user_from   	  user_icq   	  user_aim   	  user_yim   	  user_msnm   	  user_jabber   	  user_website   	  user_occ   	  user_interests   	  user_actkey   	  user_newpasswd   	  user_form_salt





    41
    5
    Amber Herold
    





    42
    
    
    





    43
    7
    Amber Herold
    
h2. Conversion tables





    44
    1
    Amber Herold
    





    45
    7
    Amber Herold
    





    46
    9
    Amber Herold
    
h3. Redmine Users





    47
    7
    Amber Herold
    





    48
    1
    Amber Herold
    
|_.Redmine Entry|_.BB Entry|





    49
    5
    Amber Herold
    
|id||





    50
    7
    Amber Herold
    
|login|notre_users->username|





    51
    1
    Amber Herold
    
|hashed_password||





    52
    5
    Amber Herold
    
|firstname||





    53
    
    
    
|lastname||





    54
    7
    Amber Herold
    
|mail|Notre_users->user_email|





    55
    1
    Amber Herold
    
|mail_notification||





    56
    5
    Amber Herold
    
|admin||





    57
    
    
    
|status||





    58
    
    
    
|last_login_on||





    59
    7
    Amber Herold
    
|language|Notre_users->user_lang|





    60
    5
    Amber Herold
    
|auth_source_id||





    61
    
    
    
|created_on||





    62
    
    
    
|updated_on||





    63
    
    
    
|type||





    64
    
    
    
|identity_url||





    65
    8
    Amber Herold
    





    66
    
    
    





    67
    9
    Amber Herold
    
h3. Redmine Boards





    68
    1
    Amber Herold
    





    69
    
    
    
|_.Redmine Entry|_.BB Entry|





    70
    9
    Amber Herold
    
|id||   	  





    71
    
    
    
|project_id||   	  





    72
    
    
    
|name||   	  





    73
    
    
    
|description||   	  





    74
    
    
    
|position||   	  





    75
    
    
    
|topics_count||   	  





    76
    
    
    
|messages_count||   	  





    77
    
    
    
|last_message_id||





    78
    1
    Amber Herold
    





    79
    
    
    





    80
    
    
    





    81
    9
    Amber Herold
    
h3. Redmine Messages





    82
    
    
    





    83
    1
    Amber Herold
    
|_.Redmine Entry|_.BB Entry|





    84
    9
    Amber Herold
    
|id||   	  





    85
    
    
    
|board_id||





    86
    
    
    
|parent_id||   	  





    87
    
    
    
|subject||   	  





    88
    
    
    
|content||   	  





    89
    
    
    
|author_id||   	  





    90
    
    
    
|replies_count||   	  





    91
    
    
    
|last_reply_id||   	  





    92
    
    
    
|created_on||   	  





    93
    
    
    
|updated_on||   	  





    94
    
    
    
|locked||   	  





    95
    
    
    
|sticky||