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 => 32) do
7 create_table "coitems", :force => true do |t|
8 t.column "customer_id", :integer
9 t.column "rentable_id", :integer
10 t.column "out_date", :date, :default => '2007-11-21'
11 t.column "due_date", :date
14 create_table "customers", :force => true do |t|
15 t.column "name", :string
16 t.column "address", :text, :limit => 255
17 t.column "email", :string
18 t.column "phone", :string
19 t.column "debt", :decimal, :default => 0.0
22 create_table "game_genres", :force => true do |t|
23 t.column "name", :string, :null => false
26 create_table "game_platforms", :force => true do |t|
27 t.column "name", :string, :null => false
30 create_table "game_policies", :force => true do |t|
31 t.column "day", :integer, :null => false
32 t.column "fee", :decimal, :precision => 8, :scale => 2, :null => false
33 t.column "period", :integer
34 t.column "description", :string
37 create_table "merchandise_purchases", :force => true do |t|
40 create_table "merchandises", :force => true do |t|
41 t.column "title", :string, :null => false
42 t.column "quantity", :integer, :default => 0, :null => false
43 t.column "price", :decimal, :precision => 8, :scale => 2, :default => 0.0
46 create_table "purchases", :force => true do |t|
47 t.column "type", :string
48 t.column "customer_id", :integer
49 t.column "date", :date
50 t.column "price", :decimal, :default => 0.0
51 t.column "rentable_id", :integer
52 t.column "merchandise_id", :integer
53 t.column "quantity", :integer
56 create_table "rentable_policies", :force => true do |t|
57 t.column "name", :string, :null => false
58 t.column "value", :integer
59 t.column "description", :string, :null => false
62 create_table "rentables", :force => true do |t|
63 t.column "type", :string
64 t.column "title", :string
65 t.column "newrelease", :boolean
66 t.column "video_genre_id", :integer
67 t.column "director", :string
68 t.column "video_media_id", :integer
69 t.column "game_genre_id", :integer
70 t.column "game_platform_id", :integer
73 # Could not dump table "sqlite_sequence" because of following StandardError
74 # Unknown type '' for column 'name'
76 create_table "users", :force => true do |t|
77 t.column "name", :string, :null => false
78 t.column "hashed_password", :string
79 t.column "salt", :string
80 t.column "manager", :boolean, :default => false
83 create_table "video_genres", :force => true do |t|
84 t.column "name", :string, :null => false
87 create_table "video_medias", :force => true do |t|
88 t.column "name", :string, :null => false
91 create_table "video_policies", :force => true do |t|
92 t.column "day", :integer, :null => false
93 t.column "fee", :decimal, :precision => 8, :scale => 2, :null => false
94 t.column "period", :integer
95 t.column "description", :string