Sha256: ad30e8ae99e6c6376d4d753aae5eb45a51e0e5a8f28974358e28e2e8eaaa164e

Contents?: true

Size: 945 Bytes

Versions: 7

Compression:

Stored size: 945 Bytes

Contents

# frozen_string_literal: true

class CreateUrbanAreaCountySubdivisions < ActiveRecord::Migration[5.0]
  def up
    return if table_exists?(:us_geo_urban_area_county_subdivisions)

    create_table :us_geo_urban_area_county_subdivisions do |t|
      t.string :urban_area_geoid, limit: 5, null: false
      t.string :county_subdivision_geoid, limit: 10, null: false
      t.float :land_area, null: false
      t.float :water_area, null: false
      t.datetime :updated_at, null: false
      t.integer :status, null: false, default: 0, limit: 1
    end

    add_index :us_geo_urban_area_county_subdivisions, [:urban_area_geoid, :county_subdivision_geoid], name: :index_us_geo_urban_area_county_subdivisions_uniq, unique: true
    add_index :us_geo_urban_area_county_subdivisions, [:county_subdivision_geoid], name: :index_us_geo_urban_area_county_subdivisions_geoid
  end

  def down
    drop_table :us_geo_urban_area_county_subdivisions
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version Path
us_geo-2.1.1 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.1.0 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.0.4 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.0.3 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.0.2 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.0.1 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb
us_geo-2.0.0 db/migrate/20230417000300_create_urban_area_county_subdivisions.rb