|
# This file is auto-generated from the current state of the database. Instead of editing this file,
|
|
# please use the migrations feature of Active Record to incrementally modify your database, and
|
|
# then regenerate this schema definition.
|
|
#
|
|
# Note that this schema.rb definition is the authoritative source for your database schema. If you need
|
|
# to create the application database on another system, you should be using db:schema:load, not running
|
|
# all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations
|
|
# you'll amass, the slower it'll run and the greater likelihood for issues).
|
|
#
|
|
# It's strongly recommended to check this file into your version control system.
|
|
|
|
ActiveRecord::Schema.define(:version => 20090411170814) do
|
|
|
|
create_table "artwork_conditions", :force => true do |t|
|
|
t.string "name", :limit => 64, :null => false
|
|
t.integer "position", :limit => 11, :null => false
|
|
end
|
|
|
|
add_index "artwork_conditions", ["name"], :name => "nom", :unique => true
|
|
|
|
create_table "artwork_groups", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.integer "artwork_set_id", :limit => 11, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
t.text "comment"
|
|
end
|
|
|
|
add_index "artwork_groups", ["name"], :name => "nom", :unique => true
|
|
add_index "artwork_groups", ["name"], :name => "nom_2"
|
|
|
|
create_table "artwork_materials", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
end
|
|
|
|
add_index "artwork_materials", ["name"], :name => "nom", :unique => true
|
|
add_index "artwork_materials", ["name"], :name => "nom_2"
|
|
|
|
create_table "artwork_materials_artworks", :id => false, :force => true do |t|
|
|
t.integer "artwork_id", :limit => 10, :null => false
|
|
t.integer "artwork_material_id", :limit => 10, :null => false
|
|
end
|
|
|
|
add_index "artwork_materials_artworks", ["artwork_material_id", "artwork_id"], :name => "artwork_material_id", :unique => true
|
|
|
|
create_table "artwork_placement_reasons", :force => true do |t|
|
|
t.string "name", :limit => 64, :null => false
|
|
end
|
|
|
|
add_index "artwork_placement_reasons", ["name"], :name => "nom", :unique => true
|
|
|
|
create_table "artwork_sets", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
t.text "comment"
|
|
end
|
|
|
|
add_index "artwork_sets", ["name"], :name => "nom", :unique => true
|
|
add_index "artwork_sets", ["name"], :name => "nom_2"
|
|
|
|
create_table "artwork_sizes", :force => true do |t|
|
|
t.integer "height", :limit => 10, :null => false
|
|
t.integer "width", :limit => 10, :null => false
|
|
t.boolean "standard", :default => false, :null => false
|
|
end
|
|
|
|
add_index "artwork_sizes", ["height", "width"], :name => "proportion", :unique => true
|
|
|
|
create_table "artwork_steps", :force => true do |t|
|
|
t.string "filename", :limit => 512, :null => false
|
|
t.date "date"
|
|
t.integer "artwork_id", :limit => 20
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
t.integer "size", :limit => 20, :null => false
|
|
t.string "content_type", :limit => 64, :null => false
|
|
t.integer "height", :limit => 11, :null => false
|
|
t.integer "width", :limit => 11, :null => false
|
|
t.integer "parent_id", :limit => 20
|
|
t.string "thumbnail", :limit => 64
|
|
t.string "type", :limit => 64, :null => false
|
|
t.string "comment", :limit => 512
|
|
end
|
|
|
|
add_index "artwork_steps", ["filename"], :name => "image_filename", :unique => true
|
|
|
|
create_table "artwork_supports", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.string "acronym", :limit => 8
|
|
end
|
|
|
|
add_index "artwork_supports", ["name", "acronym"], :name => "nom", :unique => true
|
|
add_index "artwork_supports", ["name"], :name => "nom_2"
|
|
|
|
create_table "artwork_supports_artworks", :id => false, :force => true do |t|
|
|
t.integer "artwork_support_id", :limit => 10, :null => false
|
|
t.integer "artwork_id", :limit => 20, :null => false
|
|
end
|
|
|
|
add_index "artwork_supports_artworks", ["artwork_support_id", "artwork_id"], :name => "artwork_support_id", :unique => true
|
|
|
|
create_table "artworks", :force => true do |t|
|
|
t.integer "artwork_set_id", :limit => 20
|
|
t.string "artwork_set_position", :limit => 32
|
|
t.integer "artwork_group_id", :limit => 20
|
|
t.string "artwork_group_position", :limit => 32
|
|
t.string "title", :limit => 256, :null => false
|
|
t.integer "artwork_size_id", :limit => 10, :null => false
|
|
t.integer "artwork_condition_id", :limit => 10, :null => false
|
|
t.integer "artwork_placement_reason_id", :limit => 10
|
|
t.string "placement_location", :limit => 256
|
|
t.date "placement_date"
|
|
t.text "comment"
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
create_table "exhibition_artwork", :force => true do |t|
|
|
t.integer "exhibition_id", :limit => 20, :null => false
|
|
t.integer "artwork_id", :limit => 20, :null => false
|
|
t.integer "position", :limit => 20, :null => false
|
|
end
|
|
|
|
add_index "exhibition_artwork", ["exhibition_id", "artwork_id"], :name => "exhibition_id", :unique => true
|
|
|
|
create_table "exhibitions", :force => true do |t|
|
|
t.string "name", :limit => 128, :null => false
|
|
t.date "start", :null => false
|
|
t.date "end", :null => false
|
|
t.string "place", :limit => 128, :null => false
|
|
t.boolean "hidden", :default => false, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "exhibitions", ["name"], :name => "nom", :unique => true
|
|
add_index "exhibitions", ["name"], :name => "nom_2"
|
|
|
|
create_table "sessions", :force => true do |t|
|
|
t.string "session_id", :null => false
|
|
t.text "data"
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
end
|
|
|
|
add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
|
|
add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
|
|
|
|
create_table "users", :force => true do |t|
|
|
t.string "login", :limit => 64, :null => false
|
|
t.string "real_name", :limit => 256
|
|
t.string "email", :limit => 128
|
|
t.string "hashed_password", :limit => 512, :null => false
|
|
t.string "salt", :limit => 64, :null => false
|
|
t.datetime "created_at"
|
|
t.datetime "updated_at"
|
|
t.boolean "admin", :default => false, :null => false
|
|
t.string "prefered_language", :limit => 16
|
|
end
|
|
|
|
add_index "users", ["login"], :name => "login", :unique => true
|
|
add_index "users", ["real_name"], :name => "real_name", :unique => true
|
|
|
|
end
|