Project

General

Profile

Download (6.96 KB) Statistics
| Branch: | Tag: | Revision:
# 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.float "height", :null => false
t.float "width", :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
    (1-1/1)