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