projects
/
cs356-p2-videostore.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Add Bitem (bought items) MVC
[cs356-p2-videostore.git]
/
db
/
schema.rb
diff --git
a/db/schema.rb
b/db/schema.rb
index
fff73ef
..
dcfe7d9
100644
(file)
--- 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.
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.
-ActiveRecord::Schema.define(:version => 7) 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
create_table "coitems", :force => true do |t|
t.column "customer_id", :integer
@@
-13,28
+19,35
@@
ActiveRecord::Schema.define(:version => 7) do
create_table "customers", :force => true do |t|
t.column "name", :string
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 "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
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
+ create_table "medias", :force => true do |t|
+ t.column "name", :string, :null => false
end
end
- create_table "rentables", :force => true do |t|
+ 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
end
- create_table "videos", :force => true do |t|
- t.column "rentable_id", :integer
+ create_table "rentables", :force => true do |t|
+ t.column "type", :string
+ t.column "title", :string
t.column "newrelease", :boolean, :default => false
t.column "newrelease", :boolean, :default => false
+ t.column "video_genre", :integer
t.column "director", :string
t.column "director", :string
- t.column "genre", :integer
- t.column "title", :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
end
end