R6.0 Database Schema Changes
1. Table changes
- changed field
-
tag
toVARCHAR(250) 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
-
- 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
-
2. Database layout
3 of 3 Files accessible from this page :
a_schematic_of_wackowiki_r6.0_database_structure.png | table structure of WackoWiki R6.0 database | 111 KiB | 11.09.2020 11:35 | |
a_schematic_of_wackowiki_r6.0_database_structure.svg | table structure of WackoWiki R6.0 database | 689 KiB | 11.09.2020 11:36 | |
wackowiki_6.0.mwb | MySQL Workbench 8.0 file for WackoWiki R6.0 | 27 KiB, 38 Views | 11.09.2020 11:33 |
MySQL Workbench 8.0 file for WackoWiki R6.0
3. Tables
Files
a_schematic_of_wackowiki_r6.0_database_structure.png | table structure of WackoWiki R6.0 database | 111 KiB | 11.09.2020 11:35 | |
a_schematic_of_wackowiki_r6.0_database_structure.svg | table structure of WackoWiki R6.0 database | 689 KiB | 11.09.2020 11:36 | |
wackowiki_6.0.mwb | MySQL Workbench 8.0 file for WackoWiki R6.0 | 27 KiB, 38 Views | 11.09.2020 11:33 |