added first stab at a kiosk mode

[selectricity-live] / db / schema.rb

diff --git a/db/schema.rb b/db/schema.rb
index c30d3f6432ce8537f02313607ea7d17c56683169..0d99d2e959895f1b34b81551bdd0c25e5fb8926d 100644 (file)
--- 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)
+ActiveRecord::Schema.define(:version => 3) do
 
   create_table "candidates", :force => true do |t|
     t.integer "election_id",                :null => false
@@ -18,34 +18,38 @@ ActiveRecord::Schema.define(:version => 3)
   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   "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"
   end
 
   add_index "elections", ["user_id"], :name => "fk_user_election"
 
   create_table "pictures", :force => true do |t|
-    t.string  "filename",     :limit => 200
-    t.binary  "data"
-    t.string  "filetype",     :limit => 100
-    t.integer "candidate_id"
+    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"
   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"