database assignment 1

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;