main
1# encoding: UTF-8
2# This file is auto-generated from the current state of the database. Instead
3# of editing this file, please use the migrations feature of Active Record to
4# incrementally modify your database, and then regenerate this schema definition.
5#
6# Note that this schema.rb definition is the authoritative source for your
7# database schema. If you need to create the application database on another
8# system, you should be using db:schema:load, not running all the migrations
9# from scratch. The latter is a flawed and unsustainable approach (the more migrations
10# you'll amass, the slower it'll run and the greater likelihood for issues).
11#
12# It's strongly recommended that you check this file into your version control system.
13
14ActiveRecord::Schema.define(version: 20141115172026) do
15
16 # These are extensions that must be enabled in order to support this database
17 enable_extension "plpgsql"
18
19 create_table "environments", force: true do |t|
20 t.string "name"
21 t.integer "service_id"
22 t.string "api_key"
23 t.datetime "created_at"
24 t.datetime "updated_at"
25 end
26
27 add_index "environments", ["service_id"], name: "index_environments_on_service_id", using: :btree
28
29 create_table "failures", force: true do |t|
30 t.integer "environment_id"
31 t.string "message"
32 t.string "hostname"
33 t.string "error_type"
34 t.text "backtrace", default: [], array: true
35 t.datetime "created_at"
36 t.datetime "updated_at"
37 end
38
39 add_index "failures", ["environment_id"], name: "index_failures_on_environment_id", using: :btree
40
41 create_table "services", force: true do |t|
42 t.string "name"
43 t.datetime "created_at"
44 t.datetime "updated_at"
45 end
46
47 create_table "sessions", force: true do |t|
48 t.integer "user_id"
49 t.string "ip_address"
50 t.datetime "created_at"
51 t.datetime "updated_at"
52 t.datetime "revoked_at"
53 t.string "key", null: false
54 end
55
56 add_index "sessions", ["key"], name: "index_sessions_on_key", using: :btree
57 add_index "sessions", ["revoked_at"], name: "index_sessions_on_revoked_at", using: :btree
58
59 create_table "users", force: true do |t|
60 t.string "email"
61 t.string "password_digest"
62 t.datetime "created_at"
63 t.datetime "updated_at"
64 end
65
66 create_table "videos", force: true do |t|
67 t.string "title"
68 t.text "description"
69 t.string "uri"
70 t.integer "user_id"
71 t.datetime "created_at"
72 t.datetime "updated_at"
73 end
74
75end