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

diff --git a/db/schema.rb b/db/schema.rb
index dbb0282..f0435a6 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -2,19 +2,36 @@
 # migrations feature of ActiveRecord to incrementally modify your database, and
 # then regenerate this schema definition.
 
-ActiveRecord::Schema.define(:version => 2) do
+ActiveRecord::Schema.define(:version => 12) do
+
+  create_table "coitems", :force => true do |t|
+    t.column "customer_id", :integer
+    t.column "rentable_id", :integer
+    t.column "out_date",    :date,    :default => '2007-11-21'
+    t.column "due_date",    :date
+  end
 
   create_table "customers", :force => true do |t|
     t.column "name",    :string
-    t.column "address", :string
+    t.column "address", :text,    :limit => 255
     t.column "email",   :string
     t.column "phone",   :string
-    t.column "debt",    :decimal, :precision => 8, :scale => 2, :default => 0.0
+    t.column "debt",    :decimal,                :default => 0.0
   end
 
   create_table "rentables", :force => true do |t|
-    t.column "title", :string
-    t.column "genre", :string
+    t.column "type",        :string
+    t.column "title",       :string
+    t.column "newrelease",  :boolean, :default => false
+    t.column "video_genre", :integer
+    t.column "director",    :string
+    t.column "media",       :integer
+    t.column "game_genre",  :integer
+    t.column "platform",    :integer
+  end
+
+  create_table "videogenres", :force => true do |t|
+    t.column "name", :string, :null => false
   end
 
 end