Massive Cleanup

[cs356-p2-videostore.git] / db / migrate / 016_create_purchases.rb

diff --git a/db/migrate/016_create_purchases.rb b/db/migrate/016_create_purchases.rb
index 08bb7aa..773d49f 100644 (file)
--- a/db/migrate/016_create_purchases.rb
+++ b/db/migrate/016_create_purchases.rb
@@ -1,9 +1,21 @@
 class CreatePurchases < ActiveRecord::Migration
   def self.up
     create_table :purchases do |t|
+      # STI Required
+      t.column :type, :string
+
+      # Both
       t.column :customer_id, :integer
-      t.column :purchaseable_id, :integer
-      t.column :purchaseable_type, :string
+      t.column :date, :date
+      t.column :price, :decimal, :precision => 8, :scale => 2, :default => 0
+
+      # RentablePurchase only
+      t.column :rentable_id, :integer
+      t.column :due_date, :date
+
+      # MerchandisePurchase only
+      t.column :merchandise_id, :integer
+      t.column :quantity, :integer
     end
   end