Add Purchase system

[cs356-p2-videostore.git] / db / schema.rb

diff --git a/db/schema.rb b/db/schema.rb
index 212ac71..2e0f138 100644 (file)
--- 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 => 16) do
+ActiveRecord::Schema.define(:version => 19) do
 
   create_table "bitems", :force => true do |t|
     t.column "customer_id",    :integer, :null => false
@@ -29,6 +29,9 @@ ActiveRecord::Schema.define(:version => 16) do
     t.column "name", :string, :null => false
   end
 
+  create_table "merchandise_purchases", :force => true do |t|
+  end
+
   create_table "merchandises", :force => true do |t|
     t.column "name",     :string,                                                 :null => false
     t.column "quantity", :integer,                               :default => 0,   :null => false
@@ -39,9 +42,8 @@ ActiveRecord::Schema.define(:version => 16) do
     t.column "type",           :string
     t.column "customer_id",    :integer
     t.column "date",           :date
-    t.column "price",          :decimal, :precision => 8, :scale => 2, :default => 0.0
+    t.column "price",          :decimal, :default => 0.0
     t.column "rentable_id",    :integer
-    t.column "due_date",       :date
     t.column "merchandise_id", :integer
     t.column "quantity",       :integer
   end
@@ -57,6 +59,9 @@ ActiveRecord::Schema.define(:version => 16) do
     t.column "platform",    :integer
   end
 
+# Could not dump table "sqlite_sequence" because of following StandardError
+#   Unknown type '' for column 'name'
+
   create_table "videogenres", :force => true do |t|
     t.column "name", :string, :null => false
   end