Sha256: ca5cc08f391773a8f1048581bb227ff692caf0324ba298cf348d3f17b0992b4e

Contents?: true

Size: 509 Bytes

Versions: 15

Compression:

Stored size: 509 Bytes

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

15 entries across 15 versions & 1 rubygems

Version Path
riddle-2.1.0 spec/fixtures/sql/structure.sql
riddle-2.0.0 spec/fixtures/sql/structure.sql
riddle-1.5.12 spec/fixtures/sql/structure.sql
riddle-1.5.11 spec/fixtures/sql/structure.sql
riddle-1.5.10 spec/fixtures/sql/structure.sql
riddle-1.5.9 spec/fixtures/sql/structure.sql
riddle-1.5.8 spec/fixtures/sql/structure.sql
riddle-1.5.7 spec/fixtures/sql/structure.sql
riddle-1.5.6 spec/fixtures/sql/structure.sql
riddle-1.5.5 spec/fixtures/sql/structure.sql
riddle-1.5.4 spec/fixtures/sql/structure.sql
riddle-1.5.3 spec/fixtures/sql/structure.sql
riddle-1.5.2 spec/fixtures/sql/structure.sql
riddle-1.5.1 spec/fixtures/sql/structure.sql
riddle-1.5.0 spec/fixtures/sql/structure.sql