Contents

DROP TABLE IF EXISTS `people`;

CREATE TABLE `people` (
  `id` int(11) NOT NULL auto_increment,
  `first_name` varchar(50) NOT NULL,
  `middle_initial` varchar(10) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `street_address` varchar(200) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `postcode` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `birthday` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
riddle-1.0.3	spec/fixtures/sql/structure.sql
riddle-1.0.2	spec/fixtures/sql/structure.sql
riddle-1.0.1	spec/fixtures/sql/structure.sql
riddle-1.0.0	spec/fixtures/sql/structure.sql