X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/ad088c1324d08a65f6f5336bedf7a88a8a8950e7..19a1975ef6170d77997da210512b370cc883af64:/db/schema.rb

diff --git a/db/schema.rb b/db/schema.rb
index 0d99d2e..c30d3f6 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
 #
 # 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
@@ -18,38 +18,34 @@ ActiveRecord::Schema.define(:version => 3) do
   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"