Sequel.migration do
  up do
    run "CREATE TABLE `namespaces` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `namespace` varchar(128) NOT NULL DEFAULT '',
  `queue` varchar(128) NOT NULL DEFAULT '',
  `uri` varchar(128) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `group_owner` int(11) unsigned DEFAULT NULL,
  `user_owner` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `namespace` (`namespace`),
  KEY `active` (`active`),
  KEY `queue` (`queue`),
  KEY `uri` (`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
  end

  down do
    drop_table :namespaces
  end
end