ALTER TABLE twig_mail_prefs ADD draftfold text NOT NULL; ALTER TABLE twig_acls CHANGE access alevel int(10) unsigned DEFAULT '0' NOT NULL; ALTER TABLE twig_session CHANGE session sdata longtext NOT NULL; ALTER TABLE twig_accounts CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_accounts ADD INDEX(username); ALTER TABLE twig_acls CHANGE identity identity VARCHAR (64) not null; ALTER TABLE twig_acls ADD INDEX(identity); ALTER TABLE twig_acl_groups CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_acl_groups ADD INDEX(username); ALTER TABLE twig_bookmarks CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_bookmarks ADD INDEX(username); ALTER TABLE twig_bookmarks CHANGE groupid groupid INT (11) not null; ALTER TABLE twig_bookmarks ADD INDEX(groupid); ALTER TABLE twig_bookmarks_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_bookmarks_prefs ADD INDEX(username); ALTER TABLE twig_contacts CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_contacts ADD INDEX(username); ALTER TABLE twig_contacts CHANGE groupid groupid INT (11) not null; ALTER TABLE twig_contacts ADD INDEX(groupid); ALTER TABLE twig_contacts_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_contacts_prefs ADD INDEX(username); ALTER TABLE twig_context CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_context ADD INDEX(username); ALTER TABLE twig_context CHANGE sid sid INT (11) not null; ALTER TABLE twig_context ADD INDEX(sid); ALTER TABLE twig_folders CHANGE owner owner VARCHAR (20) not null; ALTER TABLE twig_folders ADD INDEX(owner); ALTER TABLE twig_folders CHANGE groupname groupname VARCHAR (255) not null; ALTER TABLE twig_folders ADD INDEX(groupname); ALTER TABLE twig_global_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_global_prefs ADD INDEX(username); ALTER TABLE twig_groups CHANGE owner owner VARCHAR (20) not null; ALTER TABLE twig_groups ADD INDEX(owner); ALTER TABLE twig_mail_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_mail_prefs ADD INDEX(username); ALTER TABLE twig_members CHANGE groupid groupid INT (11) not null; ALTER TABLE twig_members ADD INDEX(groupid); ALTER TABLE twig_schedule CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_schedule ADD INDEX(username); ALTER TABLE twig_schedule CHANGE thedate thedate VARCHAR (20) not null; ALTER TABLE twig_schedule ADD INDEX(thedate); ALTER TABLE twig_schedule CHANGE groupid groupid INT (11) not null; ALTER TABLE twig_schedule ADD INDEX(groupid); ALTER TABLE twig_schedule CHANGE start itemstart TIMESTAMP (14) not null; ALTER TABLE twig_schedule ADD INDEX(itemstart); ALTER TABLE twig_schedule CHANGE finish itemstop TIMESTAMP (14) not null; ALTER TABLE twig_schedule ADD INDEX(itemstop); ALTER TABLE twig_schedule_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_schedule_prefs ADD INDEX(username); ALTER TABLE twig_todo CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_todo ADD INDEX(username); ALTER TABLE twig_todo_prefs CHANGE username username VARCHAR (20) not null; ALTER TABLE twig_todo_prefs ADD INDEX(username);