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);