R6.0 Database Schema Changes

1. Table changes

  1. changed field
    1. tag to VARCHAR(255) BINARY in page table
    2. cache_time to DATETIME in cache table
    3. log_time to DATETIME in log table
    4. rating_time to DATETIME in rating table
    5. watch_time to DATETIME in watch table
    6. cache_lang to VARCHAR(5) in cache table
    7. user_lang to VARCHAR(5) in user_setting table
    8. page_lang to VARCHAR(5) in page table
    9. page_lang to VARCHAR(5) in revision table
    10. category_lang to VARCHAR(5) in category table
    11. file_lang to VARCHAR(5) in file table
    12. menu_lang to VARCHAR(5) in menu table
    13. referrer to VARCHAR(2083) in referrer table
    14. email to VARCHAR(254) in user table
  2. removed field
    1. supertag from page table
    2. supertag from revision table
    3. to_supertag from page_link table
    4. account_lang from user table
    5. fingerprint from user table
    6. group_lang from usergroup table

2. Database layout

table structure of WackoWiki R6.0 database

3 of 3 Files accessible from this page :

a_schematic_of_wackowiki_r6.0_database_structure.png table structure of WackoWiki R6.0 database 113 KiB  09.03.2021 13:15 
a_schematic_of_wackowiki_r6.0_database_structure.svg table structure of WackoWiki R6.0 database 688 KiB  09.03.2021 13:14 
wackowiki_6.0.mwb MySQL Workbench 8.0 file for WackoWiki R6.0 27 KiB, 54 Views  09.03.2021 13:16 

MySQL Workbench 8.0 file for WackoWiki R6.0

3. Tables

Show Files (3 files)