blob: 09c6f467bd62bfb5fa805229d5b84d61e7627b11 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
class CreateInfoRequestBatches < ActiveRecord::Migration
def up
create_table :info_request_batches do |t|
t.column :title, :text, :null => false
t.column :user_id, :integer, :null => false
t.timestamps
end
add_column :info_requests, :info_request_batch_id, :integer, :null => true
if ActiveRecord::Base.connection.adapter_name == "PostgreSQL"
execute "ALTER TABLE info_requests
ADD CONSTRAINT fk_info_requests_info_request_batch
FOREIGN KEY (info_request_batch_id) REFERENCES info_request_batches(id)"
end
add_index :info_requests, :info_request_batch_id
add_index :info_request_batches, :user_id
end
def down
remove_column :info_requests, :info_request_batch_id
drop_table :info_request_batches
end
end
|
