Skip to content

Instantly share code, notes, and snippets.

@jayjanssen
Created January 9, 2013 20:59
Show Gist options
  • Select an option

  • Save jayjanssen/4496889 to your computer and use it in GitHub Desktop.

Select an option

Save jayjanssen/4496889 to your computer and use it in GitHub Desktop.
CREATE TABLE `ids` (
`id` BIGINT(21) UNSIGNED NOT NULL AUTO_INCREMENT,
`stub` CHAR(1) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY (`stub`)
)
CREATE TABLE `ids` (
`id` BIGINT(21) UNSIGNED NOT NULL AUTO_INCREMENT,
`stub` CHAR(1) NOT NULL,
PRIMARY KEY (`id`,`stub`),
UNIQUE KEY (`stub`)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment