Database
1. Table Structure
- acl
- auth_token
- cache
- category
- category_assignment
- config
- external_link
- file
- file_link
- log
- menu
- page
- 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
- page_link
- a reference to internal Wiki page
- rating
- referrer
- revision
- poll
- user
- user_setting
- usergroup
- usergroup_member
- 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
There are no attached files to display.0 of 0 Files accessible from this page :
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