# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 6) do

  create_table "arguments", :force => true do |t|
    t.column "title", :string
    t.column "description", :text
    t.column "side_id", :integer
  end

  create_table "comments", :force => true do |t|
    t.column "argument_id", :integer
    t.column "user_id", :integer
    t.column "comment_text", :text
  end

  create_table "sides", :force => true do |t|
    t.column "topic_id", :integer
    t.column "title", :string
  end

  create_table "todo_tasks", :force => true do |t|
    t.column "title", :string
    t.column "description", :text
    t.column "type", :string
    t.column "status", :string
    t.column "originator_id", :integer
    t.column "implementor_id", :integer
  end

  create_table "topics", :force => true do |t|
    t.column "title", :string
    t.column "description", :text
  end

  create_table "users", :force => true do |t|
    t.column "login", :string, :limit => 80, :default => "", :null => false
    t.column "salted_password", :string, :limit => 40, :default => "", :null => false
    t.column "email", :string, :limit => 60, :default => "", :null => false
    t.column "firstname", :string, :limit => 40
    t.column "lastname", :string, :limit => 40
    t.column "salt", :string, :limit => 40, :default => "", :null => false
    t.column "verified", :integer, :default => 0
    t.column "role", :string, :limit => 40
    t.column "security_token", :string, :limit => 40
    t.column "token_expiry", :datetime
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
    t.column "logged_in_at", :datetime
    t.column "deleted", :integer, :default => 0
    t.column "delete_after", :datetime
  end

end