Add real, selectable videogenres

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

diff --git a/db/schema.rb b/db/schema.rb
index 692ee89..f099861 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 => 9) do
+ActiveRecord::Schema.define(:version => 11) do
 
   create_table "coitems", :force => true do |t|
     t.column "customer_id", :integer
@@ -13,10 +13,10 @@ ActiveRecord::Schema.define(:version => 9) do
 
   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|
@@ -30,4 +30,8 @@ ActiveRecord::Schema.define(:version => 9) do
     t.column "platform",    :integer
   end
 
+  create_table "videogenres", :force => true do |t|
+    t.column "name", :string, :null => false
+  end
+
 end