R5.5 Database Schema Changes
See also Database Schema Changes for WackoWiki versions 6.1, 6.0.
1. Table changes
- added table
-
auth_token
-
file_link
-
external_link
-
session
(optional) -
bad_behavior
(optional)
-
- renamed table
-
link
topage_link
-
upload
tofile
-
category_page
tocategory_assignment
-
- renamed field
-
session_expiration
tosession_length
in user_setting table -
parent
toparent_id
in category table -
session_time
tolast_visit
in user table -
moderator
tomoderator_id
in usergroup table -
changes_count
tolist_count
in user_setting table -> default number of records per page in lists -
description
tocategory_description
in category table -
lang
topage_lang
in page and revision table -
lang
tocategory_lang
in category table -
lang
tocache_lang
in cache table -
lang
tomenu_lang
in menu table -
lang
totag_lang
in tag table -
lang
tofile_lang
in file table -
lang
touser_lang
in user_setting table -
upload_id
tofile_id
in file table
-
- added field
-
user_ip
VARCHAR(40) to user table -
sorting_comments
to user_setting table -
description
to category table -
account_lang
to user table -
group_lang
to usergroup table -
account_status
to user table -
menu_items
in user_setting table -
version_id
to page table -
page_size
INT(10) to page and revision table -
mimetype
to file table -
assignment_id
INT(10) to category_assignment table -
object_type_id
INT(10) to category_assignment table -
object_id
INT(10) to category_assignment table -
modified_dt
DATETIME to file table -
files
INT(4) to page table -
revisions
INT(10) to page table -
license_id
INT(10) to page table -
license_id
INT(10) to file table -
author
VARCHAR(250) to file table -
source
VARCHAR(250) to file table -
source_url
VARCHAR(255) to file table
-
- removed field
-
revisions_count
in user_setting table -
salt
from user table, but remains in upgraded installation -
session_expire
from user table
-
- changed field
-
title
toVARCHAR(250)
in page and revision table -
edit_note
toVARCHAR(200)
in page and revision table -
name
toCHAR(40)
in cache table -
password
toVARCHAR(255)
in user table -
ip
toVARCHAR(45)
in log table -
ip
toVARCHAR(45)
in page table -
ip
toVARCHAR(45)
in referrer table -
ip
toVARCHAR(45)
in revision table -
user_ip
toVARCHAR(45)
in user table
-
- updated DEFAULT values for standard_handlers in config table
- added primary key
referrer_id
to referrer table
2. Database layout
3 of 3 Files accessible from this page :
a_schematic_of_wackowiki_r55_database_structure.png | table structure of WackoWiki R5.5 database | 336.5 KiB | 16.03.2020 19:04 | |
a_schematic_of_wackowiki_r55_database_structure.svg | table structure of WackoWiki R5.5 database | 936.0 KiB | 17.03.2020 16:38 | |
wackowiki_5.5.mwb | MySQL Workbench 6.3 file for WackoWiki R5.5 | 44.2 KiB | 28.05.2019 08:24 |
MySQL Workbench 6.3 file for WackoWiki R5.5