X-Git-Url: https://projects.mako.cc/source/selectricity/blobdiff_plain/86087be54da5f8c3af8fa475fafebd0c5527da9f..c124da51136711bb57d3d8ca57ba00b7af0a1e64:/db/schema.rb?ds=inline diff --git a/db/schema.rb b/db/schema.rb index ec0093b..6c038de 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -42,6 +42,16 @@ ActiveRecord::Schema.define() do t.column "rank", :integer end + create_table "sitealizer", :force => true do |t| + t.column "path", :string + t.column "ip", :string + t.column "referer", :string + t.column "language", :string + t.column "user_agent", :string + t.column "created_at", :datetime + t.column "created_on", :date + end + create_table "tokens", :force => true do |t| t.column "token", :string, :limit => 100, :default => "", :null => false t.column "vote_id", :integer, :null => false @@ -64,10 +74,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"