R6.1 Database Schema Changes


1. Table changes

  1. changed field
    1. timezone to VARCHAR(100) in user_setting table
  2. renamed field
    1. lost_password_request_count to password_request_count in user table
  3. removed field
    1. footer_rating from page table
    2. typografica from user_setting table
    3. dst from user_setting table
  4. 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 108 KiB  08.12.2021 17:24 
a_schematic_of_wackowiki_r6.1_database_structure.svg table structure of WackoWiki R6.1 database 650 KiB  08.12.2021 17:27 
wackowiki_6.1.mwb MySQL Workbench 8.0 file for WackoWiki R6.1 27 KiB  24.12.2021 05:10 

MySQL Workbench 8.0 file for WackoWiki R6.0

4. Tables

Show Files (3 files)