1. Table Structure

1. acl 
2. auth_token
3. cache
4. category
5. category_assignment
6. config
7. external_link
8. file
9. file_link
10. log 
11. menu
12. page
    1. the latest versions of the pages and also stored comments, distinct from ordinary pages of comments that, comments that filled the fields and comment_on_id
13. page_link
    1. a reference to internal Wiki page
14. rating
15. referrer
16. revision
17. poll
18. user
19. user_setting
20. usergroup
21. usergroup_member
22. watch

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

-> MySQL Workbench

1.3. Database Script

1.4. Performance

Indexes

• Ensure indexes on columns used in WHERE, ON, GROUP BY clauses
• Always ensure JOIN conditions are indexed (and have identical data types)
• Be careful of the column order
• If you don't pick a primary key (bad idea!), one will be created for you -> And, you have no control over the key

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

• R5.5
• R6.0