Sha256: 392389b27139c8a40d5b1ebf44d8e74378a9258f212d5771f7820b9ff287e9da
Contents?: true
Size: 743 Bytes
Versions: 22
Compression:
Stored size: 743 Bytes
Contents
class MonarchyCreateHierarchies < ActiveRecord::Migration
def change
create_table :monarchy_hierarchies do |t|
t.integer :parent_id
t.integer :resource_id, null: false
t.string :resource_type, null: false
t.timestamps null: false
end
create_table :monarchy_hierarchy_hierarchies, id: false do |t|
t.integer :ancestor_id, null: false
t.integer :descendant_id, null: false
t.integer :generations, null: false
end
add_index :monarchy_hierarchy_hierarchies, [:ancestor_id, :descendant_id, :generations],
unique: true,
name: 'hierarchy_anc_desc_idx'
add_index :monarchy_hierarchy_hierarchies, [:descendant_id], name: 'hierarchy_desc_idx'
end
end
Version data entries
22 entries across 22 versions & 1 rubygems