X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/08f9f8af8019964a865621bc63f234579ebb3e71..8145e917e1570f0ef8570261877074a5c9bac46f:/db/schema.rb diff --git a/db/schema.rb b/db/schema.rb index 590425d..be37e18 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -2,7 +2,7 @@ # migrations feature of ActiveRecord to incrementally modify your database, and # then regenerate this schema definition. -ActiveRecord::Schema.define() do +ActiveRecord::Schema.define(:version => 2) do create_table "candidates", :force => true do |t| t.column "election_id", :integer, :null => false @@ -23,6 +23,9 @@ ActiveRecord::Schema.define() do t.column "quickuser", :string t.column "election_method", :string, :limit => 100, :default => "ssd" t.column "type", :string, :limit => 100, :default => "", :null => false + t.column "embeddable", :boolean, :default => false, :null => false + t.column "authenticated", :boolean, :default => true, :null => false + t.column "early_results", :boolean, :default => false, :null => false end add_index "elections", ["user_id"], :name => "fk_user_election" @@ -42,6 +45,14 @@ ActiveRecord::Schema.define() do t.column "rank", :integer end + create_table "sessions", :force => true do |t| + t.column "sessid", :string + t.column "data", :text + t.column "updated_at", :datetime + end + + add_index "sessions", ["sessid"], :name => "session_index" + create_table "sitealizer", :force => true do |t| t.column "path", :string t.column "ip", :string @@ -74,10 +85,11 @@ ActiveRecord::Schema.define() do create_table "voters", :force => true do |t| t.column "email", :string, :limit => 100 t.column "password", :string, :limit => 100 - t.column "contacted", :integer, :limit => 4, :default => 0, :null => false - t.column "election_id", :integer, :null => false + t.column "contacted", :integer, :limit => 4, :default => 0, :null => false + t.column "election_id", :integer, :null => false t.column "session_id", :string, :limit => 32 t.column "ipaddress", :string, :limit => 32 + t.column "type", :string, :limit => 100, :default => "", :null => false end add_index "voters", ["election_id"], :name => "fk_election_voter"