ALTER TABLE twig_mail_prefs ADD draftfold text NOT NULL;

ALTER TABLE twig_acls RENAME access TO alevel;
ALTER TABLE twig_session RENAME session TO sdata;
ALTER TABLE twig_schedule RENAME start TO itemstart; 
ALTER TABLE twig_schedule RENAME finish TO itemstop; 

CREATE INDEX twig_accounts_username_index ON twig_accounts (username);
CREATE INDEX twig_acls_identity_index ON twig_acls (identity);
CREATE INDEX twig_acl_groups_username_index ON twig_acl_groups (username);
CREATE INDEX twig_bookmarks_username_index ON twig_bookmarks (username);
CREATE INDEX twig_bookmarks_groupid_index ON twig_bookmarks (groupid);
CREATE INDEX twig_bookmarks_prefs_username_index ON twig_bookmarks_prefs (username);
CREATE INDEX twig_contacts_username_index ON twig_contacts (username);
CREATE INDEX twig_contacts_groupid_index ON twig_contacts (groupid);
CREATE INDEX twig_contacts_prefs_username_index ON twig_contacts_prefs (username);
CREATE INDEX twig_context_username_index ON twig_context (username);
CREATE INDEX twig_context_sid_index ON twig_context (sid);
CREATE INDEX twig_folders_owner_index ON twig_folders (owner);
CREATE INDEX twig_folders_groupname_index ON twig_folders (groupname);
CREATE INDEX twig_global_prefs_username_index ON twig_global_prefs (username);
CREATE INDEX twig_groups_owner_index ON twig_groups (owner);
CREATE INDEX twig_mail_prefs_username_index ON twig_mail_prefs (username);
CREATE INDEX twig_members_groupid_index ON twig_members (groupid);
CREATE INDEX twig_schedule_username_index ON twig_schedule (username);
CREATE INDEX twig_schedule_thedate_index ON twig_schedule (thedate);
CREATE INDEX twig_schedule_groupid_index ON twig_schedule (groupid);
CREATE INDEX twig_schedule_start_index ON twig_schedule (itemstart);
CREATE INDEX twig_schedule_finish_index ON twig_schedule (itemstop);
CREATE INDEX twig_schedule_prefs_username_index ON twig_schedule_prefs (username);
CREATE INDEX twig_todo_username_index ON twig_todo (username);
CREATE INDEX twig_todo_prefs_username_index ON twig_todo_prefs (username);