R6.1 Database Schema Changes


See also Database Schema Changes for WackoWiki versions 6.0, 5.5.

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
  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

2. Removed tables

  • poll table
  • rating table

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 table structure of WackoWiki R6.1 database 88.0 KiB  17.08.2023 09:44 
a_schematic_of_wackowiki_r6.1_database_structure.svg table structure of WackoWiki R6.1 database 623.2 KiB  17.08.2023 09:42 
wackowiki_6.1.mwb MySQL Workbench 8.0 file for WackoWiki R6.1 27.3 KiB  17.08.2023 09:42 

MySQL Workbench 8.0 file for WackoWiki R6.0

4. Tables

Files

a_schematic_of_wackowiki_r6.1_database_structure.png table structure of WackoWiki R6.1 database 88.0 KiB  17.08.2023 09:44 
a_schematic_of_wackowiki_r6.1_database_structure.svg table structure of WackoWiki R6.1 database 623.2 KiB  17.08.2023 09:42 
wackowiki_6.1.mwb MySQL Workbench 8.0 file for WackoWiki R6.1 27.3 KiB  17.08.2023 09:42