WackoWiki: Database

https://wackowiki.org/doc     Version: 38 (07/24/2025 22:44)

Database

1. Table Structure

  1. acl[link4]
  2. auth_token[link5]
  3. cache[link6]
  4. category[link7]
  5. category_assignment[link8]
  6. config[link9]
  7. external_link[link10]
  8. file[link11]
  9. file_link[link12]
  10. log[link13]
  11. menu[link14]
  12. page[link15]
  13. page_link[link16]
  14. referrer[link17]
  15. revision[link18]
  16. user[link19]
  17. user_setting[link20]
  18. usergroup[link21]
  19. usergroup_member[link22]
  20. watch[link23]
  21. word[link24]

1.1. Access MySQL via command line

mysql
mysql -h 127.0.0.1 -P 3306 -u root -p <database>
mysql> DESCRIBE table_name;


mariadb
mariadb -u root -p -h 127.0.0.1 wacko --skip-ssl
mariadb> DESCRIBE table_name;

1.2. Database Diagram

3 of 3 Files accessible from this page Dev / Release / R 6.1 / Database[link25]:

a_schematic_of_wackowiki_r6.1_database_structure.png[link26] table structure of WackoWiki R6.1 database 88.0 KiB  08/17/2023 09:44 
a_schematic_of_wackowiki_r6.1_database_structure.svg[link27] table structure of WackoWiki R6.1 database 623.2 KiB  08/17/2023 09:42 
wackowiki_6.1.mwb[link28] MySQL Workbench 8.0 file for WackoWiki R6.1 27.3 KiB  08/17/2023 09:42 

-> MySQL Workbench[link29]

1.3. Database Script


1.4. Performance

Indexes

1.5. Naming

Use singular for table names, e.g. “page” not “pages”
A table structure describes a specific entity

1.6. Proposed Database Schema Changes