View source for R6.0 Database Schema Changes

{{toc numerate=1}}

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

===Table changes===
  1. changed field 
    1. ##tag## to ##VARCHAR(255) BINARY## in page table
    1. ##cache_time##  to ##DATETIME## in cache table
    1. ##log_time##  to ##DATETIME## in log table
    1. ##rating_time##  to ##DATETIME## in rating table
    1. ##watch_time##  to ##DATETIME## in watch table
    1. ##cache_lang##  to ##VARCHAR(5)## in cache table
    1. ##user_lang##  to ##VARCHAR(5)## in user_setting table
    1. ##page_lang##  to ##VARCHAR(5)## in page table
    1. ##page_lang##  to ##VARCHAR(5)## in revision table
    1. ##category_lang##  to ##VARCHAR(5)## in category table
    1. ##file_lang##  to ##VARCHAR(5)## in file table
    1. ##menu_lang##  to ##VARCHAR(5)## in menu table
    1. ##referrer## to ##VARCHAR(2083)## in referrer table
    1. ##email## to ##VARCHAR(254)## in user table
    1. ##query## to ##VARCHAR(255)## in cache table
  1. removed field 
    1. ##supertag## from page table
    1. ##supertag## from revision table
    1. ##to_supertag## from page_link table
    1. ##account_lang## from user table
    1. ##fingerprint## from user table
    1. ##group_lang## from usergroup table
    1. ##hits## from file table 

===Database layout===
file:/Dev/Release/R6.0/Database/a_schematic_of_wackowiki_r6.0_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}}