# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.
-ActiveRecord::Schema.define(:version => 16) 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
+ActiveRecord::Schema.define(:version => 32) do
create_table "coitems", :force => true do |t|
t.column "customer_id", :integer
t.column "debt", :decimal, :default => 0.0
end
- create_table "medias", :force => true do |t|
+ create_table "game_genres", :force => true do |t|
+ t.column "name", :string, :null => false
+ end
+
+ create_table "game_platforms", :force => true do |t|
t.column "name", :string, :null => false
end
+ 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 "merchandise_purchases", :force => true do |t|
+ end
+
create_table "merchandises", :force => true do |t|
- t.column "name", :string, :null => false
+ 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
t.column "type", :string
t.column "customer_id", :integer
t.column "date", :date
- t.column "price", :decimal, :precision => 8, :scale => 2, :default => 0.0
+ t.column "price", :decimal, :default => 0.0
t.column "rentable_id", :integer
- t.column "due_date", :date
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 "media", :integer
- t.column "game_genre", :integer
- t.column "platform", :integer
+ t.column "type", :string
+ t.column "title", :string
+ t.column "newrelease", :boolean
+ t.column "video_genre_id", :integer
+ t.column "director", :string
+ t.column "video_media_id", :integer
+ t.column "game_genre_id", :integer
+ t.column "game_platform_id", :integer
end
- create_table "videogenres", :force => true do |t|
+# 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_genres", :force => true do |t|
t.column "name", :string, :null => false
end
+ create_table "video_medias", :force => true do |t|
+ t.column "name", :string, :null => 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
+
end