#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 3) do
+ActiveRecord::Schema.define(:version => 3)
create_table "candidates", :force => true do |t|
t.integer "election_id", :null => false
end
create_table "elections", :force => true do |t|
- t.string "name", :limit => 100, :null => false
- t.text "description", :null => false
- t.integer "anonymous", :limit => 1, :default => 1, :null => false
+ t.string "name", :limit => 100, :null => false
+ t.text "description", :null => false
+ t.integer "anonymous", :limit => 1, :default => 1, :null => false
t.datetime "startdate"
- t.datetime "enddate", :null => false
- t.integer "active", :limit => 1, :default => 0, :null => false
- t.integer "viewable", :limit => 1, :default => 1, :null => false
- t.integer "notices", :limit => 1, :default => 0, :null => false
+ t.datetime "enddate", :null => false
+ t.integer "active", :limit => 1, :default => 0, :null => false
+ t.integer "viewable", :limit => 1, :default => 1, :null => false
+ t.integer "notices", :limit => 1, :default => 0, :null => false
t.integer "user_id"
t.string "quickuser"
- t.string "election_method", :limit => 100, :default => "ssd"
- t.string "type", :limit => 100, :null => false
- t.boolean "embeddable", :default => false, :null => false
- t.boolean "authenticated", :default => true, :null => false
- t.boolean "early_results", :default => false, :null => false
- t.string "embed_custom_string"
+ t.string "election_method", :limit => 100, :default => "ssd"
+ t.string "type", :limit => 100, :null => false
+ t.boolean "embeddable", :default => false, :null => false
+ t.boolean "authenticated", :default => true, :null => false
+ t.boolean "early_results", :default => false, :null => false
end
add_index "elections", ["user_id"], :name => "fk_user_election"
create_table "pictures", :force => true do |t|
- t.string "filename"
- t.string "content_type"
- t.integer "size"
- t.integer "width"
- t.integer "height"
- t.integer "parent_id"
- t.string "thumbnail"
- t.datetime "created_at"
- t.integer "candidate_id"
+ t.string "filename", :limit => 200
+ t.binary "data"
+ t.string "filetype", :limit => 100
+ t.integer "candidate_id"
end
+ add_index "pictures", ["candidate_id"], :name => "fk_candidate_picture"
+
create_table "rankings", :force => true do |t|
t.integer "vote_id"
t.integer "candidate_id"