WackoWiki: Database

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

Database

1. Table Structure

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

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[link22]:

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

-> MySQL Workbench[link26]

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