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
      Integer :speed
      Time :updated_at
      Boolean :deleted
      # TODO: GIST Index on the position
    end
  end

  down do
    drop_table(:units)
  end
end

Version data entries

23 entries across 23 versions & 1 rubygems

Version	Path
tac_scribe-0.8.1-java	db/001_create_unit_table.rb
tac_scribe-0.8.1	db/001_create_unit_table.rb
tac_scribe-0.8.0-java	db/001_create_unit_table.rb
tac_scribe-0.8.0	db/001_create_unit_table.rb
tac_scribe-0.7.6	db/001_create_unit_table.rb
tac_scribe-0.7.6-java	db/001_create_unit_table.rb
tac_scribe-0.7.5-java	db/001_create_unit_table.rb
tac_scribe-0.7.5	db/001_create_unit_table.rb
tac_scribe-0.7.4	db/001_create_unit_table.rb
tac_scribe-0.7.4-java	db/001_create_unit_table.rb
tac_scribe-0.7.3-java	db/001_create_unit_table.rb
tac_scribe-0.7.3	db/001_create_unit_table.rb
tac_scribe-0.7.3.rc1-java	db/001_create_unit_table.rb
tac_scribe-0.7.3.rc1	db/001_create_unit_table.rb
tac_scribe-0.7.1-java	db/001_create_unit_table.rb
tac_scribe-0.7.1	db/001_create_unit_table.rb
tac_scribe-0.7.0-java	db/001_create_unit_table.rb
tac_scribe-0.7.0	db/001_create_unit_table.rb
tac_scribe-0.6.4-java	db/001_create_unit_table.rb
tac_scribe-0.6.4	db/001_create_unit_table.rb