Contents

class CreateKirguduBaseCommonPortals < ActiveRecord::Migration
	def change
		create_table :kirgudu_base_common_portals do |t|
			t.string :uin, limit: 36, null: false
			t.integer :created_by, limit: 8, null: false
			t.integer :updated_by, limit: 8, null: false
			t.integer :owned_by, limit: 8, null: false
			t.datetime :owned_at
			t.integer :administrated_by, limit: 8, null: false
			t.datetime :administrator_at

			t.string :dns_name, limit: 180, null: false
			t.string :name, limit: 180, null: false
			t.text :description

			t.integer :deletion_status_id, limit: 8, null: false, default: 0

			t.timestamps
		end

		add_index :kirgudu_base_common_portals, :dns_name, name: "idx_krgd_bs_cmn_prtls_dns_name"
		add_index :kirgudu_base_common_portals, :name, name: "idx_krgd_bs_cmn_prtls_name"

		add_index :kirgudu_base_common_portals, :created_by, name: "idx_krgd_bs_cmn_prtls_crtd_by"
		add_index :kirgudu_base_common_portals, :created_at, name: "idx_krgd_bs_cmn_prtls_crtd_at"
		add_index :kirgudu_base_common_portals, :updated_by, name: "idx_krgd_bs_cmn_prtls_updt_by"
		add_index :kirgudu_base_common_portals, :updated_at, name: "idx_krgd_bs_cmn_prtls_updt_at"
		add_index :kirgudu_base_common_portals, :owned_by, name: "idx_krgd_bs_cmn_prtls_ownd_by"
		add_index :kirgudu_base_common_portals, :owned_at, name: "idx_krgd_bs_cmn_prtls_ownd_at"
		add_index :kirgudu_base_common_portals, :administrated_by, name: "idx_krgd_bs_cmn_prtls_adm_by"
		add_index :kirgudu_base_common_portals, :administrator_at, name: "idx_krgd_bs_cmn_prtls_adm_at"

		add_index :kirgudu_base_common_portals, :uin, name: "idx_krgd_bs_cmn_prtls_uin"
		add_index :kirgudu_base_common_portals, :deletion_status_id, name: "idx_krgd_bs_cmn_prtls_dlt_sts_id"

	end
end

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
kirgudu_base-0.0.25	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.23	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.22	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.21	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.19	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.18	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.17	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.16	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.15	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.14	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.13	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.12	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.11	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.10	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.9	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.8	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.7	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.6	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.5	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb
kirgudu_base-0.0.4	db/migrate/20140208133148_create_kirgudu_base_common_portals.rb