From 9c4856bdb11fc9311ab30a97224cee3dfaec492f Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Sat, 20 Feb 2016 22:53:20 +0100 Subject: Initial commit --- db/schema.rb | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 db/schema.rb (limited to 'db/schema.rb') diff --git a/db/schema.rb b/db/schema.rb new file mode 100644 index 000000000..49ba23f19 --- /dev/null +++ b/db/schema.rb @@ -0,0 +1,45 @@ +# encoding: UTF-8 +# This file is auto-generated from the current state of the database. Instead +# of editing this file, please use the migrations feature of Active Record to +# incrementally modify your database, and then regenerate this schema definition. +# +# Note that this schema.rb definition is the authoritative source for your +# database schema. If you need to create the application database on another +# system, you should be using db:schema:load, not running all the migrations +# from scratch. The latter is a flawed and unsustainable approach (the more migrations +# you'll amass, the slower it'll run and the greater likelihood for issues). +# +# It's strongly recommended that you check this file into your version control system. + +ActiveRecord::Schema.define(version: 20160220211917) do + + # These are extensions that must be enabled in order to support this database + enable_extension "plpgsql" + + create_table "accounts", force: :cascade do |t| + t.string "username", default: "", null: false + t.string "domain" + t.string "verify_token", default: "", null: false + t.string "secret", default: "", null: false + t.text "private_key" + t.text "public_key", default: "", null: false + t.string "remote_url", default: "", null: false + t.string "salmon_url", default: "", null: false + t.string "hub_url", default: "", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + add_index "accounts", ["username", "domain"], name: "index_accounts_on_username_and_domain", unique: true, using: :btree + + create_table "statuses", force: :cascade do |t| + t.string "uri", default: "", null: false + t.integer "account_id", null: false + t.text "text", default: "", null: false + t.datetime "created_at", null: false + t.datetime "updated_at", null: false + end + + add_index "statuses", ["uri"], name: "index_statuses_on_uri", unique: true, using: :btree + +end -- cgit