1 # This file is autogenerated. Instead of editing this file, please use the
2 # migrations feature of ActiveRecord to incrementally modify your database, and
3 # then regenerate this schema definition.
5 ActiveRecord::Schema.define(:version => 16) do
7 create_table "bitems", :force => true do |t|
8 t.column "customer_id", :integer, :null => false
9 t.column "merchandise_id", :integer, :null => false
10 t.column "date", :date, :null => false
13 create_table "coitems", :force => true do |t|
14 t.column "customer_id", :integer
15 t.column "rentable_id", :integer
16 t.column "out_date", :date, :default => '2007-11-21'
17 t.column "due_date", :date
20 create_table "customers", :force => true do |t|
21 t.column "name", :string
22 t.column "address", :text, :limit => 255
23 t.column "email", :string
24 t.column "phone", :string
25 t.column "debt", :decimal, :default => 0.0
28 create_table "medias", :force => true do |t|
29 t.column "name", :string, :null => false
32 create_table "merchandises", :force => true do |t|
33 t.column "name", :string, :null => false
34 t.column "quantity", :integer, :default => 0, :null => false
35 t.column "price", :decimal, :precision => 8, :scale => 2, :default => 0.0
38 create_table "purchases", :force => true do |t|
39 t.column "type", :string
40 t.column "customer_id", :integer
41 t.column "date", :date
42 t.column "price", :decimal, :precision => 8, :scale => 2, :default => 0.0
43 t.column "rentable_id", :integer
44 t.column "due_date", :date
45 t.column "merchandise_id", :integer
46 t.column "quantity", :integer
49 create_table "rentables", :force => true do |t|
50 t.column "type", :string
51 t.column "title", :string
52 t.column "newrelease", :boolean, :default => false
53 t.column "video_genre", :integer
54 t.column "director", :string
55 t.column "media", :integer
56 t.column "game_genre", :integer
57 t.column "platform", :integer
60 create_table "videogenres", :force => true do |t|
61 t.column "name", :string, :null => false