Contents

Sequel.migration do
  change do
    create_table :tags do
      column :id, String, primary_key: true, null: false, size: 36
      column :name, String, size: 255, null: false

      index :name, unique: true
    end

    create_table :requests_tags do
      foreign_key :tags_id, :tags, index: true, type: String, null: false, size: 36, key: [:id]
      foreign_key :requests_id, :requests, index: true, type: Integer, null: false, key: [:index]

      index [:tags_id, :requests_id], unique: true
      index [:requests_id, :tags_id], unique: true
    end
  end
end

Version data entries

27 entries across 27 versions & 1 rubygems

Version	Path
inferno_core-0.6.1	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.6.0	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.5.4	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.5.3	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.5.2	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.5.1	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.5.0	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.44	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.43	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.42	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.41	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.40	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.39	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.38	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.35	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.34	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.33	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.32	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.31	lib/inferno/db/migrations/009_add_request_tags.rb
inferno_core-0.4.30	lib/inferno/db/migrations/009_add_request_tags.rb