UPDATE twig_schedule SET recurtype=0 WHERE recurtype!=1; CREATE TABLE twig_schedule_recurring ( id INT DEFAULT '0' not null AUTO_INCREMENT, schid INT not null, recurtype INT not null, schedule INT, cycle INT, position INT, days VARCHAR (13), endtype INT not null, end TIMESTAMP not null, PRIMARY KEY (id), INDEX (schid), INDEX (recurtype), INDEX (endtype), INDEX (end) ); ALTER TABLE twig_announce CHANGE date thedate TIMESTAMP; ALTER TABLE twig_acls CHANGE identity ident varchar(128) NOT NULL;