Contents

Sequel.migration do
  up do
    run "CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) unsigned DEFAULT '1',
  `name` varchar(128) DEFAULT NULL,
  `version` tinyint(5) unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;"

    run "CREATE TABLE `groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) unsigned DEFAULT '1',
  `name` varchar(128) DEFAULT NULL,
  `version` tinyint(5) unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  end

  down do
    drop_table :groups
    drop_table :users
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
legion-data-0.1.1	lib/legion/data/migrations/011_add_users_and_groups.rb
legion-data-0.1.0	lib/legion/data/migrations/011_add_users_and_groups.rb