X-Git-Url: https://irasnyder.com/gitweb/?a=blobdiff_plain;f=db%2Fschema.rb;h=f9d22a08ea2b667f64636244976c2dba8a490ab9;hb=bbf13350a73e14c5448f6fb0077126b7d92cdb48;hp=c773ea17db36baa4a605a30816a2bdb3445fa876;hpb=0acc9549b65f2c3cd1840f39e31f2177a98bc55e;p=cs356-p2-videostore.git

diff --git a/db/schema.rb b/db/schema.rb
index c773ea1..f9d22a0 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 => 4) do
+ActiveRecord::Schema.define(:version => 27) do
 
   create_table "coitems", :force => true do |t|
     t.column "customer_id", :integer
@@ -13,22 +13,86 @@ ActiveRecord::Schema.define(:version => 4) 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|
-    t.column "title", :string
-    t.column "genre", :string
+  create_table "game_policies", :force => true do |t|
+    t.column "day",         :integer,                               :null => false
+    t.column "fee",         :decimal, :precision => 8, :scale => 2, :null => false
+    t.column "period",      :integer
+    t.column "description", :string
   end
 
-  create_table "videos", :force => true do |t|
-    t.column "rentable_id", :integer
+  create_table "gamegenres", :force => true do |t|
+    t.column "name", :string, :null => false
+  end
+
+  create_table "gameplatforms", :force => true do |t|
+    t.column "name", :string, :null => false
+  end
+
+  create_table "medias", :force => true do |t|
+    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 "title",    :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 "purchases", :force => true do |t|
+    t.column "type",           :string
+    t.column "customer_id",    :integer
+    t.column "date",           :date
+    t.column "price",          :decimal, :default => 0.0
+    t.column "rentable_id",    :integer
+    t.column "merchandise_id", :integer
+    t.column "quantity",       :integer
+  end
+
+  create_table "rentable_policies", :force => true do |t|
+    t.column "name",        :string,  :null => false
+    t.column "value",       :integer
+    t.column "description", :string,  :null => false
+  end
+
+  create_table "rentables", :force => true do |t|
+    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 "genre",       :integer
+    t.column "media",       :integer
+    t.column "game_genre",  :integer
+    t.column "platform",    :integer
+  end
+
+# Could not dump table "sqlite_sequence" because of following StandardError
+#   Unknown type '' for column 'name'
+
+  create_table "users", :force => true do |t|
+    t.column "name",            :string,                     :null => false
+    t.column "hashed_password", :string
+    t.column "salt",            :string
+    t.column "manager",         :boolean, :default => false
+  end
+
+  create_table "video_policies", :force => true do |t|
+    t.column "day",         :integer,                               :null => false
+    t.column "fee",         :decimal, :precision => 8, :scale => 2, :null => false
+    t.column "period",      :integer
+    t.column "description", :string
+  end
+
+  create_table "videogenres", :force => true do |t|
+    t.column "name", :string, :null => false
   end
 
 end