aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20131211152641_create_public_body_change_requests.rb20
1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrate/20131211152641_create_public_body_change_requests.rb b/db/migrate/20131211152641_create_public_body_change_requests.rb
new file mode 100644
index 000000000..e3fb560a6
--- /dev/null
+++ b/db/migrate/20131211152641_create_public_body_change_requests.rb
@@ -0,0 +1,20 @@
+class CreatePublicBodyChangeRequests < ActiveRecord::Migration
+ def up
+ create_table :public_body_change_requests do |t|
+ t.column :user_email, :string
+ t.column :user_name, :string
+ t.column :user_id, :integer
+ t.column :public_body_name, :text
+ t.column :public_body_id, :integer
+ t.column :public_body_email, :string
+ t.column :source_url, :text
+ t.column :notes, :text
+ t.column :is_open, :boolean, :null => false, :default => true
+ t.timestamps
+ end
+ end
+
+ def down
+ drop_table :public_body_change_requests
+ end
+end