WackoWiki: R6.0 Database Schema Changes

https://wackowiki.org/doc     Version: 23 (06/03/2022 23:33)

R6.0 Database Schema Changes



See also Database Schema Changes for WackoWiki versions 6.1[link1], 5.5[link2].

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
    15. query to VARCHAR(255) in cache 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
    7. hits from file 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[link3] table structure of WackoWiki R6.0 database 92.2 KiB  05/12/2022 14:42 
a_schematic_of_wackowiki_r6.0_database_structure.svg[link4] table structure of WackoWiki R6.0 database 660.7 KiB  05/12/2022 14:43 
wackowiki_6.0.mwb[link5] MySQL Workbench 8.0 file for WackoWiki R6.0 27.1 KiB  05/12/2022 14:43 

MySQL Workbench[link6] 8.0 file for WackoWiki R6.0

3. Tables