class CreateKirguduBaseSecurityEmailConfirmations < ActiveRecord::Migration
	def change
		create_table :kirgudu_base_security_email_confirmations do |t|
			t.integer :user_id, limit: 8, null: false
			t.string :code, limit: 30, null: false
			t.datetime :expire_at, null: false
			t.datetime :sent_at, null: false

			t.timestamps
		end

		add_index :kirgudu_base_security_email_confirmations, :user_id, name: "idx_krgd_bs_sec_email_confm_user_id"
		add_index :kirgudu_base_security_email_confirmations, :code, name: "idx_krgd_bs_sec_email_confm_code"
		add_index :kirgudu_base_security_email_confirmations, :expire_at, name: "idx_krgd_bs_sec_email_confm_expire_at"
		add_index :kirgudu_base_security_email_confirmations, :sent_at, name: "idx_krgd_bs_sec_email_confm_sent_at"
	end
end