WackoWiki: Database

https://wackowiki.org/doc     Version: 32 (24.06.2022 10:49)

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]

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.0 KiB  17.08.2023 09:44 
a_schematic_of_wackowiki_r6.1_database_structure.svg[link26] table structure of WackoWiki R6.1 database 623.2 KiB  17.08.2023 09:42 
wackowiki_6.1.mwb[link27] MySQL Workbench 8.0 file for WackoWiki R6.1 27.3 KiB  17.08.2023 09:42 

-> 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