X-Git-Url: https://www.irasnyder.com/gitweb/?p=cs356-p2-videostore.git;a=blobdiff_plain;f=db%2Fschema.rb;h=692ee89afd90c1fe80fa25a757171fd5b9db78d3;hp=885c6eea76d04682b2dc078c5566efad940b6a05;hb=3650c5f411112965a12718b75ccbedde3186fa15;hpb=28e07f23e1c75f7442dd87caf34f0f47109bf966

diff --git a/db/schema.rb b/db/schema.rb
index 885c6ee..692ee89 100644
--- 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 => 8) do
+ActiveRecord::Schema.define(:version => 9) do
 
   create_table "coitems", :force => true do |t|
     t.column "customer_id", :integer
@@ -19,23 +19,15 @@ ActiveRecord::Schema.define(:version => 8) do
     t.column "debt",    :decimal, :precision => 8, :scale => 2, :default => 0.0
   end
 
-  create_table "games", :force => true do |t|
-    t.column "title",       :string
-    t.column "platform",    :integer
-    t.column "genre",       :integer
-    t.column "rentable_id", :integer
-  end
-
   create_table "rentables", :force => true do |t|
-    t.column "rtype", :string
-  end
-
-  create_table "videos", :force => true do |t|
-    t.column "rentable_id", :integer
-    t.column "newrelease",  :boolean, :default => false
-    t.column "director",    :string
-    t.column "genre",       :integer
+    t.column "type",        :string
     t.column "title",       :string
+    t.column "newrelease",  :boolean, :default => false
+    t.column "video_genre", :integer
+    t.column "director",    :integer
+    t.column "media",       :integer
+    t.column "game_genre",  :integer
+    t.column "platform",    :integer
   end
 
 end