ALTER TABLE twig_global_prefs ADD tstyle1 int4 default 5 not null; ALTER TABLE twig_notes ADD attachmime text; ALTER TABLE twig_notes MODIFY attachment image; ALTER TABLE twig_meetings_invitations CHANGE idx id INT default '0' NOT NULL auto_increment; ALTER TABLE twig_meetings_invitations CHANGE event_idx eventid INT default '0' NOT NULL; ALTER TABLE twig_meetings_invitations CHANGE r_date thedate TIMESTAMP NOT NULL; ALTER TABLE twig_meetings_invitations CHANGE user_idx username varchar(128) NOT NULL; ALTER TABLE twig_meetings_registration CHANGE idx id INT default '0' NOT NULL auto_increment; ALTER TABLE twig_meetings_registration CHANGE event_idx eventid INT default '0' NOT NULL; ALTER TABLE twig_meetings_registration CHANGE r_date thedate TIMESTAMP NOT NULL; ALTER TABLE twig_meetings_registration CHANGE user_idx username varchar(128) NOT NULL; ALTER TABLE twig_main_prefs ADD features varchar(128) NOT NULL; 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 IS NULL OR type='';