X-Git-Url: https://projects.mako.cc/source/selectricity/blobdiff_plain/7b649ccad8804580632c255b9f451482fdbbe32d..8f23a174c70223831055e1498b50c3ba260858fe:/db/schema.rb diff --git a/db/schema.rb b/db/schema.rb index 57e39ac..6c038de 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -17,6 +17,8 @@ ActiveRecord::Schema.define() do t.column "startdate", :datetime t.column "enddate", :datetime, :null => false t.column "active", :integer, :limit => 4, :default => 0, :null => false + t.column "viewable", :integer, :limit => 4, :default => 1, :null => false + t.column "notices", :integer, :limit => 4, :default => 0, :null => false t.column "user_id", :integer t.column "quickuser", :string t.column "election_method", :string, :limit => 100, :default => "ssd" @@ -40,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 @@ -62,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"