{{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