Skip to content

Instantly share code, notes, and snippets.

@niklio

niklio/gist:7aa8cbed16830dae4c77

Created September 17, 2015 13:20
Show Gist options
  • Save niklio/7aa8cbed16830dae4c77 to your computer and use it in GitHub Desktop.
Save niklio/7aa8cbed16830dae4c77 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE TABLE `space_ship` (
`name` varchar(128) NOT NULL,
`seq_num` bigint(20) NOT NULL,
`country` varchar(128) NOT NULL,
`captain` varchar(128),
`flight` timestamp,
PRIMARY KEY (seq_num),
UNIQUE KEY (captain, flight),
UNIQUE KEY (name, seq_num)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment