ALTER TABLE twig_schedule ADD recurtype INT;
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;