1 files changed, 17 insertions, 0 deletions
diff --git a/db/migrate/20170319193517_add_badge_id_to_users.rb b/db/migrate/20170319193517_add_badge_id_to_users.rb
new file mode 100644
index 0000000..4738e11
--- /dev/null
+++ b/db/migrate/20170319193517_add_badge_id_to_users.rb
@@ -0,0 +1,17 @@
+class AddBadgeIdToUsers < ActiveRecord::Migration
+  def change
+
+    create_table "badges", force: :cascade do |t|
+      t.string  "name"
+      t.string  "symbol"
+      t.string  "color"
+    end
+
+    Badge.create!({name: "none", symbol: "", color: "#000"})
+    dbadge = Badge.create!({name: "donor", symbol: "$", color: "#f60"})
+
+    add_column :users, :badge_id, :integer, default: 1
+    User.where(donor: true).update_all(badge_id: dbadge.id)
+    remove_column :users, :donor
+  end
+end