ALTER TABLE twig_global_prefs ADD tstyle1 int4 default 5 not null;

ALTER TABLE twig_notes ADD attachmime text;
ALTER TABLE twig_notes RENAME COLUMN attachment TO attachold;
ALTER TABLE twig_notes ADD attachment OID;

ALTER TABLE twig_meetings_invitations RENAME COLUMN idx TO id;
ALTER TABLE twig_meetings_invitations RENAME COLUMN event_idx TO eventid;
ALTER TABLE twig_meetings_invitations RENAME COLUMN r_date TO thedate;
ALTER TABLE twig_meetings_invitations RENAME COLUMN user_idx TO username;

ALTER TABLE twig_meetings_registration RENAME COLUMN idx TO id;
ALTER TABLE twig_meetings_registration RENAME COLUMN event_idx TO eventid;
ALTER TABLE twig_meetings_registration RENAME COLUMN r_date TO thedate;
ALTER TABLE twig_meetings_registration RENAME COLUMN user_idx TO username;

ALTER TABLE twig_main_prefs ADD features varchar(128);
ALTER TABLE twig_main_prefs ADD maxmail INT;
ALTER TABLE twig_main_prefs ADD maxmeetings INT;
ALTER TABLE twig_main_prefs ADD maxschedule INT;
ALTER TABLE twig_main_prefs ADD maxtodo INT;

UPDATE twig_groups SET type='standard' WHERE type='' OR type IS null;

GRANT UPDATE ON twaccid TO nobody;
GRANT UPDATE ON twasid TO nobody;
GRANT UPDATE ON twanid TO nobody;
GRANT UPDATE ON twbmid TO nobody;
GRANT UPDATE ON twbmprf TO nobody;
GRANT UPDATE ON twconid TO nobody;
GRANT UPDATE ON twcprf TO nobody;
GRANT UPDATE ON twfoldid TO nobody;
GRANT UPDATE ON twgpid TO nobody;
GRANT UPDATE ON groupid TO nobody;
GRANT UPDATE ON twprefsid TO nobody;
GRANT UPDATE ON twmpid TO nobody;
GRANT UPDATE ON twmeetid TO nobody;
GRANT UPDATE ON twmeetpid TO nobody;
GRANT UPDATE ON twmeetrid TO nobody;
GRANT UPDATE ON twmeetiid TO nobody;
GRANT UPDATE ON memberid TO nobody; 
GRANT UPDATE ON twnpid TO nobody;
GRANT UPDATE ON twnoteid TO nobody; 
GRANT UPDATE ON twnotepid TO nobody;
GRANT UPDATE ON twschedid TO nobody;
GRANT UPDATE ON twsrecid TO nobody;
GRANT UPDATE ON twsprf TO nobody;
GRANT UPDATE ON twtdid TO nobody;
GRANT UPDATE ON twprf TO nobody;