Contents

# frozen_string_literal: true

Sequel.migration do
  up do
    create_table(:units) do
      String :id, primary_key: true
      column :position, :geography, null: false
      Float :altitude, default: 0
      String :type
      String :name, null: true
      String :pilot, null: true
      String :group, null: true
      Integer :coalition
      Integer :heading
      Time :updated_at
      # TODO: GIST Index on the position
    end
  end

  down do
    drop_table(:units)
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
tac_scribe-0.4.0	db/001_create_unit_table.rb
tac_scribe-0.3.0-java	db/001_create_unit_table.rb
tac_scribe-0.3.0	db/001_create_unit_table.rb
tac_scribe-0.2.1	db/001_create_unit_table.rb
tac_scribe-0.2.1-java	db/001_create_unit_table.rb
tac_scribe-0.2.0-java	db/001_create_unit_table.rb
tac_scribe-0.2.0	db/001_create_unit_table.rb
tac_scribe-0.1.1	db/001_create_unit_table.rb
tac_scribe-0.1.0	db/001_create_unit_table.rb