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 NULL,
  `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

2 entries across 2 versions & 1 rubygems

Version	Path
lhm-2.1.0	spec/fixtures/users.ddl
lhm-2.0.0	spec/fixtures/users.ddl