Sha256: 9e43e4a34e9f6e68c69d592a9ec257b7713c8826353dae73f6e381c86bf40ef0
Contents?: true
Size: 752 Bytes
Versions: 94
Compression:
Stored size: 752 Bytes
Contents
class CreateMartyGridIndexStrings < ActiveRecord::Migration[4.2]
include Marty::Migrations
def change
table_name = "marty_grid_index_strings"
# 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.text :key, array: true
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