Database Schema Changes

1. table changes


1 of 1 Files accessible from this page :

wackowiki_r5.0.mwb MySQL Workbench 5.2 file for WackoWiki R5.0 28 KiB, 50 Views  03.06.2011 13:24  View

MySQL Workbench 5.2 file for WackoWiki R5.0

1.1. acl

  • ADD page_id
  • ALT privilege to VARCHAR(10)
  • DEL page_tag
  • DEL supertag

1.2. cache

  • ADD cache_time

1.3. link

  • ADD link_id
  • ADD from_page_id
  • ADD to_page_id
  • DEL from_tag

1.4. page

  • ADD created
  • ADD title
  • ADD formatting
  • ADD edit_note
  • ADD minor_edit
  • ADD reviewed
  • ADD reviewed_time
  • ADD reviewer_id
  • ADD ip
  • ADD owner_id
  • ADD user_id
  • ADD comment_on_id INT(10)
  • ADD comments INT(4)
  • ADD show_menu_tag TINYINT(1)
  • ADD deleted TINYINT(1)
  • CHG id to page_id
  • CHG time to modified
  • DEL comment_on
  • DEL super_comment_on
  • ALT lang to VARCHAR(2)
  • DEL owner
  • DEL user
  • ? parent_id

1.5. watch

  • ADD watch_id
  • ADD user_id
  • ADD page_id
  • CHG time to watch_time
  • DEL user
  • DEL tag

1.6. referrer

  • CHG page_tag to page_id
  • CHG time to referrer_time

1.7. revision

  • CHG id to page_id
  • CHG time to modified
  • ADD page_id
  • ADD created
  • ADD title
  • ADD formatting
  • ADD edit_note
  • ADD minor_edit
  • ADD reviewed
  • ADD reviewed_time
  • ADD reviewer_id
  • ADD ip
  • ADD owner_id
  • ADD user_id
  • ADD deleted TINYINT(1)
  • ADD comment_on_id INT(10)
  • DEL comment_on
  • DEL super_comment_on
  • ALT lang to VARCHAR(2)
  • DEL owner
  • DEL user

1.8. upload

  • CHG id to upload_id
  • ADD user_id
  • DEL user
  • ? last_download

1.9. user

  • ADD user_id
  • ADD real_name
  • ADD enabled
  • ADD session_time
  • ADD session_expire
  • ADD total_pages INT(10)
  • ADD total_revisions INT(10)
  • ADD total_comments INT(10)
  • ADD total_uploads INT(10)
  • CHG lang to VARCHAR(2)
  • CHG name to user_name
  • CHG doubleclickedit to doubleclick_edit
  • CHG changepassword to change_password VARCHAR(40)
  • CHG changescount to changes_count
  • CHG revisioncount to revisions_count
  • DEL show_datetime
  • DEL motto
  • DEL lang
  • ? login_count
  • ? lost_password_request_count
  • ? failed_login_count

1.10. user_setting

  1. [more] -> options (function load_user)
    1. theme=default
    2. autocomplete=0
    3. dont_redirect=1
    4. send_watchmail=0
    5. show_files=0
    6. allow_intercom=1
    7. hide_lastsession=1
    8. validate_ip=0
    9. noid_pubs=1
  2. doubleclick_edit
  3. show_comments
  4. bookmarks
  5. motto
  6. lang
  7. show_spaces
  8. typografica
  9. session_expiration
  10. ADD timezone DECIMAL(5,2)
  11. ADD dst TINYINT(1)
  12. ADD allow_massemail TINYINT(1)

1.11. config

1.12. group

1.13. log

1.14. category

1.15. category_page

1.16. tables to Add

  • ? language
  • ? handler
  • ? privilege

2. Alter poor design


bad design

  • NOT NULL DEFAULT ''

2.1. bad naming

  • time (reserved word)

Use singular for table names, e.g. “page” not “pages”
A table structure describes a specific entity


Show Files (1 file)

Read comment (1 comment)