X-Git-Url: https://irasnyder.com/gitweb/?a=blobdiff_plain;f=db%2Fmigrate%2F020_rebuild_merchandises_table.rb;fp=db%2Fmigrate%2F020_rebuild_merchandises_table.rb;h=e59901a0efd27d92c20c3c7f19916f7237baeab5;hb=74561aac0964ca7bd9283ad0a9b017e02431f845;hp=0000000000000000000000000000000000000000;hpb=56db4e1da35c068e247eadbd32edd0a09eb61127;p=cs356-p2-videostore.git

diff --git a/db/migrate/020_rebuild_merchandises_table.rb b/db/migrate/020_rebuild_merchandises_table.rb
new file mode 100644
index 0000000..e59901a
--- /dev/null
+++ b/db/migrate/020_rebuild_merchandises_table.rb
@@ -0,0 +1,24 @@
+class RebuildMerchandisesTable < ActiveRecord::Migration
+
+  # This whole thing is an awful way of doing a column rename
+
+  def self.up
+    drop_table :merchandises
+
+    create_table :merchandises do |t|
+      t.column :title, :string, :null => false
+      t.column :quantity, :integer, :null => false, :default => 0
+      t.column :price, :decimal, :precision => 8, :scale =>2, :default => 0
+    end
+  end
+
+  def self.down
+    drop_table :merchandises
+
+    create_table :merchandises do |t|
+      t.column :name, :string, :null => false
+      t.column :quantity, :integer, :null => false, :default => 0
+      t.column :price, :decimal, :precision => 8, :scale =>2, :default => 0
+    end
+  end
+end