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

ALTER TABLE twig_meetings_invitations CHANGE idx id int(11) default '0' NOT NULL auto_increment;
ALTER TABLE twig_meetings_invitations CHANGE event_idx eventid int(11) default '0' NOT NULL;
ALTER TABLE twig_meetings_invitations CHANGE r_date thedate timestamp(14);
ALTER TABLE twig_meetings_invitations CHANGE user_idx username varchar(128) NOT NULL;

ALTER TABLE twig_meetings_registration CHANGE idx id int(11) default '0' NOT NULL auto_increment;
ALTER TABLE twig_meetings_registration CHANGE event_idx eventid int(11) default '0' NOT NULL;
ALTER TABLE twig_meetings_registration CHANGE r_date thedate timestamp(14);
ALTER TABLE twig_meetings_registration CHANGE user_idx username varchar(128) NOT NULL;

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

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

ALTER TABLE twig_bookmarks_prefs MODIFY viewgrp varchar(10) DEFAULT '0' NOT NULL;