X-Git-Url: https://projects.mako.cc/source/selectricity-live/blobdiff_plain/c504b0b0ca78ebe19c64c194dda677dae48ab6fb..5e74f498cd2f8d765e309ca52a45a7c2db0a1a6f:/db/schema.rb?ds=sidebyside diff --git a/db/schema.rb b/db/schema.rb index ec0093b..1195e09 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 => 1) do create_table "candidates", :force => true do |t| t.column "election_id", :integer, :null => false @@ -28,20 +28,41 @@ ActiveRecord::Schema.define() do add_index "elections", ["user_id"], :name => "fk_user_election" create_table "pictures", :force => true do |t| - t.column "filename", :string, :limit => 200 - t.column "data", :binary - t.column "filetype", :string, :limit => 100 + t.column "filename", :string + t.column "content_type", :string + t.column "size", :integer + t.column "width", :integer + t.column "height", :integer + t.column "parent_id", :integer + t.column "thumbnail", :string + t.column "created_at", :datetime t.column "candidate_id", :integer end - add_index "pictures", ["candidate_id"], :name => "fk_candidate_picture" - create_table "rankings", :force => true do |t| t.column "vote_id", :integer t.column "candidate_id", :integer 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 + 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 +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"