-- 2009.05.15
ALTER TABLE `vcslog` ADD COLUMN `project` char(64) NOT NULL FIRST;
ALTER TABLE `vcslog` DROP PRIMARY KEY, ADD PRIMARY KEY (`project`, `repo`, `vcs_type`, `id`);
ALTER TABLE `vcslog` ADD KEY `c_p` (`committed`, `project`);
UPDATE `vcslog` SET `project` = `repo` WHERE `project` = '';