Contents

class CreateProclaimCommentHierarchies < ActiveRecord::Migration[5.2]
	def change
		create_table :proclaim_comment_hierarchies, :id => false do |t|
			# ID of the parent/grandparent/great-grandparent/etc. comments
			t.integer  :ancestor_id, null: false

			# ID of the target comment
			t.integer  :descendant_id, null: false

			# Number of generations between the ancestor and the descendant.
			# Parent/child = 1, for example.
			t.integer  :generations, null: false
		end

		# For "all progeny of…" and leaf selects:
		add_index :proclaim_comment_hierarchies,
		          [:ancestor_id, :descendant_id, :generations],
		          :unique => true,
		          :name => "comment_anc_desc_udx"

		# For "all ancestors of…" selects,
		add_index :proclaim_comment_hierarchies,
		          [:descendant_id],
		          :name => "comment_desc_idx"
	end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
proclaim-0.6.6	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.5	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.4	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.3	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.2	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.1	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb
proclaim-0.6.0	db/migrate/20141115022230_create_proclaim_comment_hierarchies.rb