View source for Database

#||
|| {{toc numerate=1}} | {{tree}} ||
||#

===Table Structure===
  1. acl
  2. auth_token
  1. cache
  2. category
  3. category_assignment
  4. config
  5. external_link
  5. file
  6. file_link
  1. log
  2. menu
  2. ((!/Layout/page page))
  1. page_link
  1. rating
  1. referrer
  1. revision
  2. poll
  1. user
  2. user_setting
  3. usergroup
  4. usergroup_member
  5. watch

====Access MySQL via command line====
%% mysql -h 127.0.0.1 -P 3306 -u root -p <database> %%
%% mysql> DESCRIBE table_name; %%

====Database Diagram ====
{{files page="/Dev/Release/R6.0/Database"}}
-> ((http://dev.mysql.com/workbench/ MySQL Workbench))

====Database Script ====


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

====Naming====
Use **singular** for table names, e.g. “page” not “pages”
A table structure describes a specific entity

====Proposed Database Schema Changes====
  * ((Release/R5.5/Database R5.5))
  * ((Release/R6.0/Database R6.0))