View source for R6.1 Database Schema Changes

{{toc numerate=1}}

See also Database Schema Changes for WackoWiki versions ((/Dev/Release/R6.0/Database 6.0)), ((/Dev/Release/R5.5/Database 5.5)).

===Table changes===
  1. added field
    1. ##acl_id## INT(10) to acl table
    2. ##group_member_id## INT(10) to usergroup_member table
    3. ##typografica## TINYINT(1) to page table
    4. ##file_hash## CHAR(40) to file table
  1. changed field
    1. ##timezone## to ##VARCHAR(100)## in user_setting table 
    2. ##query## to ##VARCHAR(255)## in cache table
    2. ##caption## to ##DEFAULT NULL## in file table
    3. ##category## to ##VARCHAR(255)## in category table
    4. ##category_description## to ##TEXT## in category table
  1. renamed field 
    1. ##lost_password_request_count## to ##password_request_count## in user table
    2. ##uploaded_dt## to ##created## in file table
    3. ##modified_dt## to ##modified## in file table
    4. ##name## to ##hash## in cache table
  1. removed field 
    1. ##footer_rating## from page table
    2. ##typografica## from user_setting table
    3. ##dst## from user_setting table
  4. added index
    1. ##idx_user_id## to menu table
    2. ##idx_page_id## to menu table
    3. ##idx_lang## to menu table
    4.  ##idx_user_id## to watch table
    5. ##idx_page_id## to watch table

===Removed tables===
  * ##poll## table
  * ##rating## table

===Database layout===
file:/Dev/Release/R6.1/Database/a_schematic_of_wackowiki_r6.1_database_structure.png
{{files}}
((http://dev.mysql.com/workbench/ MySQL Workbench)) 8.0 file for WackoWiki R6.0

===Tables===
{{tree page="/Dev/Database/Layout" title=0}}