WackoWiki: Database

https://wackowiki.org/doc     Version: 24.06.2022 10:49

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]

1.1. Access MySQL via command line

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

 mysql> DESCRIBE table_name;

1.2. Database Diagram

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

a_schematic_of_wackowiki_r6.1_database_structure.png[link25] table structure of WackoWiki R6.1 database 88 KiB  26.06.2022 10:15 
a_schematic_of_wackowiki_r6.1_database_structure.svg[link26] table structure of WackoWiki R6.1 database 618 KiB  26.06.2022 10:15 
wackowiki_6.1.mwb[link27] MySQL Workbench 8.0 file for WackoWiki R6.1 27 KiB  26.06.2022 10:12 

-> MySQL Workbench[link28]

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