diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/068_add_censor_table.rb | 29 | ||||
| -rw-r--r-- | db/schema.rb | 14 |
2 files changed, 42 insertions, 1 deletions
diff --git a/db/migrate/068_add_censor_table.rb b/db/migrate/068_add_censor_table.rb new file mode 100644 index 000000000..92a17d2bc --- /dev/null +++ b/db/migrate/068_add_censor_table.rb @@ -0,0 +1,29 @@ +class AddCensorTable < ActiveRecord::Migration + def self.up + create_table :censor_rules do |t| + t.column :info_request_id, :integer + t.column :user_id, :integer + t.column :public_body_id, :integer + + t.column :text, :text, :null => false + t.column :replacement, :text, :null => false + + t.column :last_edit_editor, :string, :null => false + t.column :last_edit_comment, :text, :null => false + + t.column :created_at, :datetime, :null => false + t.column :updated_at, :datetime, :null => false + end + + if ActiveRecord::Base.connection.adapter_name == "PostgreSQL" + execute "ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_info_request FOREIGN KEY (info_request_id) REFERENCES info_requests(id)" + execute "ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_user FOREIGN KEY (user_id) REFERENCES users(id)" + execute "ALTER TABLE censor_rules ADD CONSTRAINT fk_censor_rules_public_body FOREIGN KEY (public_body_id) REFERENCES public_bodies(id)" + end + end + + def self.down + drop_table :censor_rules + end +end + diff --git a/db/schema.rb b/db/schema.rb index 6939d7c41..e33f36c38 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -9,7 +9,7 @@ # # It's strongly recommended to check this file into your version control system. -ActiveRecord::Schema.define(:version => 67) do +ActiveRecord::Schema.define(:version => 68) do create_table "acts_as_xapian_jobs", :force => true do |t| t.string "model", :null => false @@ -19,6 +19,18 @@ ActiveRecord::Schema.define(:version => 67) do add_index "acts_as_xapian_jobs", ["model", "model_id"], :name => "index_acts_as_xapian_jobs_on_model_and_model_id", :unique => true + create_table "censor_rules", :force => true do |t| + t.integer "info_request_id" + t.integer "user_id" + t.integer "public_body_id" + t.text "text", :null => false + t.text "replacement", :null => false + t.string "last_edit_editor", :null => false + t.text "last_edit_comment", :null => false + t.datetime "created_at", :null => false + t.datetime "updated_at", :null => false + end + create_table "comments", :force => true do |t| t.integer "user_id", :null => false t.string "comment_type", :default => "internal_error", :null => false |