DROP TABLE IF EXISTS `vcslog`;
CREATE TABLE IF NOT EXISTS `vcslog` (
	`project` CHAR(64) NOT NULL,
	`repo` CHAR(64) NOT NULL,
	`vcs_type` CHAR(8) NOT NULL,
	`id` CHAR(64) NOT NULL,
	`username` VARCHAR(128) NOT NULL,
	`committed` DATETIME NOT NULL,
	`submitted_username` VARCHAR(128),
	`lines_changed` INTEGER UNSIGNED,
	`log` TEXT,
	PRIMARY KEY(`project`, `repo`, `vcs_type`, `id`),
	KEY `c_r` (`committed`, `repo`)
	KEY `c_p` (`committed`, `project`)
) DEFAULT CHARSET=utf8;