Sha256: 43c24c6a9c08332eeb4a31f7d2539aaedaf0b4c7344e5f73c008bc6ce3510ff4

Contents?: true

Size: 527 Bytes

Versions: 29

Compression:

Stored size: 527 Bytes

Contents

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `group` varchar(255) DEFAULT 'Superfriends',
  `created_at` datetime DEFAULT NULL,
  `comment` varchar(20) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_users_on_reference` (`reference`),
  KEY `index_users_on_username_and_created_at` (`username`,`created_at`),
  KEY `index_with_a_custom_name` (`username`,`group`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

Version data entries

29 entries across 29 versions & 3 rubygems

Version Path
lhm-shopify-3.5.2 spec/fixtures/users.ddl
lhm-shopify-3.5.0 spec/fixtures/users.ddl
lhm-shopify-3.5.1 spec/fixtures/users.ddl
lhm-shopify-3.4.2 spec/fixtures/users.ddl
lhm-shopify-3.4.1 spec/fixtures/users.ddl
lhm-shopify-3.4.0 spec/fixtures/users.ddl
lhm-shopify-3.3.6 spec/fixtures/users.ddl
lhm-shopify-3.3.5 spec/fixtures/users.ddl
lhm-2.2.0 spec/fixtures/users.ddl