R6.1 Database Schema Changes

1. Table changes

1. added field
   1. acl_id INT(10) to acl table
   2. group_member_id INT(10) to usergroup_member table
   3. typografica TINYINT(1) to page table
   4. file_hash CHAR(40) to file table
2. changed field
   1. timezone to VARCHAR(100) in user_setting table
   2. query to VARCHAR(255) in cache table
   3. caption to DEFAULT NULL in file table
   4. category to VARCHAR(255) in category table
   5. category_description to TEXT in category table
3. renamed field
   1. lost_password_request_count to password_request_count in user table
   2. uploaded_dt to created in file table
   3. modified_dt to modified in file table
   4. name to hash in cache table
4. removed field
   1. footer_rating from page table
   2. typografica from user_setting table
   3. dst from user_setting table
5. added index
   1. idx_user_id to menu table
   2. idx_page_id to menu table
   3. idx_lang to menu table
   4. idx_user_id to watch table
   5. idx_page_id to watch table

2. Removed tables

• poll table
• rating table

3. Database layout

4. Tables