X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/653b4c93bc3bbd976bfced39790f74917d58d221..14ac1babc2517320a2c90fa9b4ac36a5a6e68018:/db/migrate/20140507110937_create_changeset_comments.rb

diff --git a/db/migrate/20140507110937_create_changeset_comments.rb b/db/migrate/20140507110937_create_changeset_comments.rb
new file mode 100644
index 000000000..a44fd61ce
--- /dev/null
+++ b/db/migrate/20140507110937_create_changeset_comments.rb
@@ -0,0 +1,16 @@
+require 'migrate'
+
+class CreateChangesetComments < ActiveRecord::Migration
+  def change
+    create_table :changeset_comments do |t|
+      t.column :changeset_id, :bigint, :null => false
+      t.column :author_id, :bigint, :null =>  false
+      t.text :body, :null => false
+      t.timestamp :created_at, :null => false
+      t.boolean :visible, :null => false
+    end
+    add_foreign_key :changeset_comments, [:changeset_id], :changesets, [:id]
+    add_foreign_key :changeset_comments, [:author_id], :users, [:id]
+    add_index :changeset_comments, :created_at
+  end
+end