Contents

class AddHasDynamicColumns < ActiveRecord::Migration
	def self.up
		create_table :dynamic_columns do |t|
			t.integer :field_scope_id
			t.string :field_scope_type

			t.string :dynamic_type
			t.string :key
			t.string :data_type

			t.timestamps null: false
		end
		add_index(:dynamic_columns, [:field_scope_id, :field_scope_type, :dynamic_type], name: 'index1')
		create_table :dynamic_column_validations do |t|
			t.integer :dynamic_column_id

			t.string :error
			t.string :regexp

			t.timestamps null: false
		end
		create_table :dynamic_column_options do |t|
			t.integer :dynamic_column_id
			t.string :key

			t.timestamps null: false
		end
		create_table :dynamic_column_data do |t|
			t.string :owner_type
			t.integer :owner_id
			t.integer :dynamic_column_id
			t.integer :dynamic_column_option_id
			t.string :value

			t.timestamps null: false
		end
		add_index(:dynamic_column_data, [:owner_id, :owner_type, :dynamic_column_id], name: 'index2')
	end

	def self.down
		drop_table :dynamic_columns
	end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
has_dynamic_columns-0.3.10	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.9	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.8	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.6	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.5	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.3	lib/generators/has_dynamic_columns/templates/migration.rb
has_dynamic_columns-0.3.2	lib/generators/has_dynamic_columns/templates/migration.rb