DROP TABLE IF EXISTS `cvslog`;
CREATE TABLE IF NOT EXISTS `cvslog` (
	`id` integer NOT NULL AUTO_INCREMENT,
	`repo` varchar(32) NOT NULL,
	`user` varchar(128) NOT NULL,
	`committed` datetime NOT NULL,
	`log` text,
	PRIMARY KEY(`id`),
	KEY `c_r` (`committed`, `repo`),
	KEY `r_c` (`repo`, `committed`)
);

DROP TABLE IF EXISTS `cvsfiles`;
CREATE TABLE IF NOT EXISTS `cvsfiles` (
	`cvslog_id` integer NOT NULL,
	`path` varchar(128) NOT NULL,
	`filename` varchar(128) NOT NULL,
	`revision` varchar(32) NOT NULL,
	KEY `cid_p_f_r` (`cvslog_id`, `path`, `filename`, `revision`),
	UNIQUE `p_f_r` (`path`, `filename`, `revision`)
);