Skip to content

Instantly share code, notes, and snippets.

@schacon
Created October 11, 2008 00:29
Show Gist options
  • Select an option

  • Save schacon/16191 to your computer and use it in GitHub Desktop.

Select an option

Save schacon/16191 to your computer and use it in GitHub Desktop.
CREATE TABLE `git_files` (
`id` int(11) NOT NULL auto_increment,
`path` text,
`sha_value` char(40) default NULL,
`repo` char(255) default NULL,
PRIMARY KEY (`id`),
KEY `lookup` (`repo`(15),`path`(20),`sha_value`(20))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment