Skip to content

Instantly share code, notes, and snippets.

@mspreij
Created May 16, 2015 22:25
Show Gist options
  • Save mspreij/58ee2967a27f40dd6740 to your computer and use it in GitHub Desktop.
Save mspreij/58ee2967a27f40dd6740 to your computer and use it in GitHub Desktop.
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first` varchar(64) NOT NULL,
`last` varchar(64) NOT NULL,
`info` text NOT NULL,
`updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment