WackoWiki: R6.1 Database Schema Changes

https://wackowiki.org/doc     Version: 23 (10/10/2025 22:36)

R6.1 Database Schema Changes



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

1. 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
    5. date_preference VARCHAR(20) to user_setting table
    6. comments_offset TINYINT(1) to user_setting table
  2. changed field
    1. timezone to VARCHAR(100) in user_setting table
    2. query to VARCHAR(255) in cache table
    3. caption to DEFAULT NULL in file table
    4. category to VARCHAR(255) in category table
    5. category_description to TEXT in category table
  3. 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
  4. removed field
    1. footer_rating from page table
    2. typografica from user_setting table
    3. dst from user_setting table
  5. 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
    6. idx_file_name to file table

2. Removed tables

3. Database layout

table structure of WackoWiki R6.1 database

3 of 3 Files accessible from this page :

a_schematic_of_wackowiki_r6.1_database_structure.png[link3] table structure of WackoWiki R6.1 database 88.0 KiB  08/17/2023 09:44 
a_schematic_of_wackowiki_r6.1_database_structure.svg[link4] table structure of WackoWiki R6.1 database 623.2 KiB  08/17/2023 09:42 
wackowiki_6.1.mwb[link5] MySQL Workbench 8.0 file for WackoWiki R6.1 27.3 KiB  08/17/2023 09:42 

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

4. Tables