diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/009_create_outgoing_messages.rb | 20 | ||||
| -rw-r--r-- | db/schema.rb | 12 |
2 files changed, 31 insertions, 1 deletions
diff --git a/db/migrate/009_create_outgoing_messages.rb b/db/migrate/009_create_outgoing_messages.rb new file mode 100644 index 000000000..62bf25392 --- /dev/null +++ b/db/migrate/009_create_outgoing_messages.rb @@ -0,0 +1,20 @@ +class CreateOutgoingMessages < ActiveRecord::Migration + def self.up + create_table :outgoing_messages do |t| + t.column :info_request_id, :integer + + t.column :body, :text + t.column :status, :string + + t.column :public_body_id, :integer + t.column :message_type, :string + + t.column :created_at, :datetime + t.column :updated_at, :datetime + end + end + + def self.down + drop_table :outgoing_messages + end +end diff --git a/db/schema.rb b/db/schema.rb index 08043cd76..a0e867be9 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -2,7 +2,7 @@ # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. -ActiveRecord::Schema.define(:version => 8) do +ActiveRecord::Schema.define(:version => 9) do create_table "info_requests", :force => true do |t| t.column "title", :text @@ -10,6 +10,16 @@ ActiveRecord::Schema.define(:version => 8) do t.column "public_body_id", :integer end + create_table "outgoing_messages", :force => true do |t| + t.column "info_request_id", :integer + t.column "body", :text + t.column "status", :string + t.column "public_body_id", :integer + t.column "message_type", :string + t.column "created_at", :datetime + t.column "updated_at", :datetime + end + create_table "public_bodies", :force => true do |t| t.column "name", :text t.column "short_name", :text |