View source for R5.5 Database Schema Changes

{{toc numerate=1}}

See also Database Schema Changes for WackoWiki versions ((/Dev/Release/R6.1/Database 6.1)), ((/Dev/Release/R6.0/Database 6.0)).

===Table changes===

  1. added table
    2. ##auth_token##
    2. ##file_link##
    3. ##external_link##
    4. ##session## (optional)
    4. ##bad_behavior## (optional)
  3. renamed table
    4. ##link## to ##page_link##
    1. ##upload## to ##file##
    2. ##category_page## to ##category_assignment##
  1. renamed field 
    1. ##session_expiration## to ##session_length## in user_setting table
    1. ##parent## to ##parent_id## in category table
    1. ##session_time## to ##last_visit## in user table
    1. ##moderator## to ##moderator_id## in usergroup table
    1.  ##changes_count## to ##list_count## in user_setting table -> default number of records per page in lists
    1. ##description## to ##category_description## in category table
    1. ##lang## to ##page_lang## in page and revision table
    1. ##lang## to ##category_lang## in category table
    1. ##lang## to ##cache_lang## in cache table
    1. ##lang## to ##menu_lang## in menu table
    1. ##lang## to ##tag_lang## in tag table
    1. ##lang## to ##file_lang## in file table
    1. ##lang## to ##user_lang## in user_setting table
    1. ##upload_id##  to ##file_id## in file table
  4. added field 
    1. ##user_ip## VARCHAR(40) to user table
    1. ##sorting_comments## to user_setting table
    1. ##description## to category table
    1. ##account_lang## to user table
    1. ##group_lang## to usergroup table
    1. ##account_status## to user table
    1. ##menu_items##  in user_setting table
    1. ##version_id## to page table
    1. ##page_size## INT(10)  to page and revision table
    1. ##mimetype## to file table
    1. ##assignment_id## INT(10) to category_assignment table
    2. ##object_type_id## INT(10) to category_assignment table
    3. ##object_id## INT(10) to category_assignment table
    4. ##modified_dt## DATETIME to file table
    5. ##files## INT(4) to page table
    6. ##revisions## INT(10) to page table
    7. ##license_id## INT(10) to page table
    8. ##license_id## INT(10) to file table
    9. ##author## VARCHAR(250) to file table
    10. ##source## VARCHAR(250) to file table
    11. ##source_url## VARCHAR(255) to file table
  9. removed field 
    1. ##revisions_count## in user_setting table
    1. ##salt## from user table, but remains in upgraded installation
    2. ##session_expire## from user table
  22. changed  field 
    1. ##title## to ##VARCHAR(250)##  in page and revision table
    1. ##edit_note## to ##VARCHAR(200)##  in page and revision table
    1. ##name## to ##CHAR(40)## in cache table
    1. ##password## to ##VARCHAR(255)## in user table
    2. ##ip## to ##VARCHAR(45)## in log table
    3. ##ip## to ##VARCHAR(45)## in page table
    4. ##ip## to ##VARCHAR(45)## in referrer table
    5. ##ip## to ##VARCHAR(45)## in revision table
    6. ##user_ip## to ##VARCHAR(45)## in user table
  1. updated DEFAULT values for standard_handlers in config table
  1. added primary key ##referrer_id## to referrer table

===Database layout===
file:/Dev/Release/R5.5/Database/a_schematic_of_wackowiki_r55_database_structure.png
{{files}}
((http://dev.mysql.com/workbench/ MySQL Workbench)) 6.3 file for WackoWiki R5.5