Skip to content

Instantly share code, notes, and snippets.

@clippit

clippit/schema.sql

Created May 27, 2012 08:34
Show Gist options
  • Save clippit/2802860 to your computer and use it in GitHub Desktop.
Save clippit/2802860 to your computer and use it in GitHub Desktop.
Download ZIP
database assignment 1
Raw
schema.sql
CREATE TABLE `test` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`col1` enum('Mike','Bob','Jack','Alice','Cathy','Ann','Betty','Cindy','Mary','Jane') NOT NULL,
`col2` varchar(5) NOT NULL,
`col3` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment