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
  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
  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. 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 KiB  26.06.2022 10:15 
a_schematic_of_wackowiki_r6.1_database_structure.svg table structure of WackoWiki R6.1 database 618 KiB  26.06.2022 10:15 
wackowiki_6.1.mwb MySQL Workbench 8.0 file for WackoWiki R6.1 27 KiB  26.06.2022 10:12 

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 KiB  26.06.2022 10:15 
a_schematic_of_wackowiki_r6.1_database_structure.svg table structure of WackoWiki R6.1 database 618 KiB  26.06.2022 10:15 
wackowiki_6.1.mwb MySQL Workbench 8.0 file for WackoWiki R6.1 27 KiB  26.06.2022 10:12 

Read comments (0 comments)