Sha256: 4613193e2a11560b268e6b3f7fac4ad071ae7c021c61bf6836827f50eb60918d
Contents?: true
Size: 770 Bytes
Versions: 94
Compression:
Stored size: 770 Bytes
Contents
class CreateMartyGridIndexIntegers < ActiveRecord::Migration[4.2]
include Marty::Migrations
def change
table_name = "marty_grid_index_integers"
# drop deprecated version
execute("DROP TABLE IF EXISTS #{table_name}")
create_table table_name do |t|
t.datetime :created_dt, null: false
t.references :data_grid, null: false
t.string :attr, null: false
t.integer :key, array: true, null: false
t.integer :index, null: false
end
# FIXME: not sure if this index is appropriate for our queries.
# May need to break it up.
add_index table_name,
[:created_dt, :data_grid_id, :attr],
name: "index_#{table_name}"
add_index table_name, :key, using: "GIN"
add_fk table_name, :data_grids
end
end
Version data entries
94 entries across 94 versions & 1 rubygems