Skip to content

Instantly share code, notes, and snippets.

@AntoineAugusti
Created August 11, 2012 19:10
Show Gist options
  • Save AntoineAugusti/3326483 to your computer and use it in GitHub Desktop.
Save AntoineAugusti/3326483 to your computer and use it in GitHub Desktop.
CREATE TABLE `euromillions` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`nb_1` int(2) NOT NULL,
`nb_2` int(2) NOT NULL,
`nb_3` int(2) NOT NULL,
`nb_4` int(2) NOT NULL,
`nb_5` int(2) NOT NULL,
`star_1` int(2) NOT NULL,
`star_2` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment