X-Git-Url: https://irasnyder.com/gitweb/?a=blobdiff_plain;f=db%2Fschema.rb;h=dcfe7d98559490f0660d9443b20a31f7f05e6c79;hb=6de5aedfe8ff0bc967b3690ae53d1f4205c10798;hp=f0435a68fa47b1f4a00ebe47fd86995b40252d5a;hpb=4ab6702d5ac0ec4541e8a724ab5e4409630b5546;p=cs356-p2-videostore.git

diff --git a/db/schema.rb b/db/schema.rb
index f0435a6..dcfe7d9 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -2,7 +2,13 @@
 # migrations feature of ActiveRecord to incrementally modify your database, and
 # then regenerate this schema definition.
 
-ActiveRecord::Schema.define(:version => 12) do
+ActiveRecord::Schema.define(:version => 15) do
+
+  create_table "bitems", :force => true do |t|
+    t.column "customer_id",    :integer, :null => false
+    t.column "merchandise_id", :integer, :null => false
+    t.column "date",           :date,    :null => false
+  end
 
   create_table "coitems", :force => true do |t|
     t.column "customer_id", :integer
@@ -19,6 +25,16 @@ ActiveRecord::Schema.define(:version => 12) do
     t.column "debt",    :decimal,                :default => 0.0
   end
 
+  create_table "medias", :force => true do |t|
+    t.column "name", :string, :null => false
+  end
+
+  create_table "merchandises", :force => true do |t|
+    t.column "name",     :string,                                                 :null => false
+    t.column "quantity", :integer,                               :default => 0,   :null => false
+    t.column "price",    :decimal, :precision => 8, :scale => 2, :default => 0.0
+  end
+
   create_table "rentables", :force => true do |t|
     t.column "type",        :string
     t.column "title",       :string