R6.0 Database Schema Changes
See also Database Schema Changes for WackoWiki versions 6.1[link1], 5.5[link2].
1. Table changes
- changed field
-
tag
toVARCHAR(255) BINARY
in page table -
cache_time
toDATETIME
in cache table -
log_time
toDATETIME
in log table -
rating_time
toDATETIME
in rating table -
watch_time
toDATETIME
in watch table -
cache_lang
toVARCHAR(5)
in cache table -
user_lang
toVARCHAR(5)
in user_setting table -
page_lang
toVARCHAR(5)
in page table -
page_lang
toVARCHAR(5)
in revision table -
category_lang
toVARCHAR(5)
in category table -
file_lang
toVARCHAR(5)
in file table -
menu_lang
toVARCHAR(5)
in menu table -
referrer
toVARCHAR(2083)
in referrer table -
email
toVARCHAR(254)
in user table -
query
toVARCHAR(255)
in cache table
-
- removed field
-
supertag
from page table -
supertag
from revision table -
to_supertag
from page_link table -
account_lang
from user table -
fingerprint
from user table -
group_lang
from usergroup table -
hits
from file table
-
2. Database layout
3 of 3 Files accessible from this page :
a_schematic_of_wackowiki_r6.0_database_structure.png[link3] | table structure of WackoWiki R6.0 database | 92.2 KiB | 12.05.2022 14:42 | |
a_schematic_of_wackowiki_r6.0_database_structure.svg[link4] | table structure of WackoWiki R6.0 database | 660.7 KiB | 12.05.2022 14:43 | |
wackowiki_6.0.mwb[link5] | MySQL Workbench 8.0 file for WackoWiki R6.0 | 27.1 KiB | 12.05.2022 14:43 |
MySQL Workbench[link6] 8.0 file for WackoWiki R6.0
3. Tables
- [link1] https://wackowiki.org/doc/Dev/Release/R6.1/Database
- [link2] https://wackowiki.org/doc/Dev/Release/R5.5/Database
- [link3] https://wackowiki.org/doc/Dev/Release/R6.0/Database/file?get=a_schematic_of_wackowiki_r6.0_database_structure.png
- [link4] https://wackowiki.org/doc/Dev/Release/R6.0/Database/file?get=a_schematic_of_wackowiki_r6.0_database_structure.svg
- [link5] https://wackowiki.org/doc/Dev/Release/R6.0/Database/file?get=wackowiki_6.0.mwb
- [link6] http://dev.mysql.com/workbench/
- [link7] https://wackowiki.org/doc/Dev/Database/Layout
- [link8] https://wackowiki.org/doc/Dev/Database/Layout/acl
- [link9] https://wackowiki.org/doc/Dev/Database/Layout/authtoken
- [link10] https://wackowiki.org/doc/Dev/Database/Layout/cache
- [link11] https://wackowiki.org/doc/Dev/Database/Layout/category
- [link12] https://wackowiki.org/doc/Dev/Database/Layout/categoryassignment
- [link13] https://wackowiki.org/doc/Dev/Database/Layout/config
- [link14] https://wackowiki.org/doc/Dev/Database/Layout/externallink
- [link15] https://wackowiki.org/doc/Dev/Database/Layout/filelink
- [link16] https://wackowiki.org/doc/Dev/Database/Layout/files
- [link17] https://wackowiki.org/doc/Dev/Database/Layout/log
- [link18] https://wackowiki.org/doc/Dev/Database/Layout/menu
- [link19] https://wackowiki.org/doc/Dev/Database/Layout/page
- [link20] https://wackowiki.org/doc/Dev/Database/Layout/pagelink
- [link21] https://wackowiki.org/doc/Dev/Database/Layout/referrer
- [link22] https://wackowiki.org/doc/Dev/Database/Layout/revision
- [link23] https://wackowiki.org/doc/Dev/Database/Layout/user
- [link24] https://wackowiki.org/doc/Dev/Database/Layout/usergroup
- [link25] https://wackowiki.org/doc/Dev/Database/Layout/usergroupmember
- [link26] https://wackowiki.org/doc/Dev/Database/Layout/usersetting
- [link27] https://wackowiki.org/doc/Dev/Database/Layout/watches