annotate db/schema.rb @ 226:fb9909885d63

Also support plain gzip
author Edho Arief <edho@myconan.net>
date Mon, 13 May 2013 13:19:33 +0900
parents 0f9f29274663
children 080dd141898c
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
176
a9dba6a3008b Initial work to add paste deletion.
Edho Arief <edho@myconan.net>
parents: 23
diff changeset
1 # encoding: UTF-8
2
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
2 # This file is auto-generated from the current state of the database. Instead
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
3 # of editing this file, please use the migrations feature of Active Record to
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
4 # incrementally modify your database, and then regenerate this schema definition.
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
5 #
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
6 # Note that this schema.rb definition is the authoritative source for your
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
7 # database schema. If you need to create the application database on another
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
8 # system, you should be using db:schema:load, not running all the migrations
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
9 # from scratch. The latter is a flawed and unsustainable approach (the more migrations
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
10 # you'll amass, the slower it'll run and the greater likelihood for issues).
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
11 #
196
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
12 # It's strongly recommended that you check this file into your version control system.
2
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
13
221
0f9f29274663 Add index to pastes.secret
Edho Arief <edho@myconan.net>
parents: 207
diff changeset
14 ActiveRecord::Schema.define(version: 20130512032335) do
2
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
15
196
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
16 create_table "pastes", force: true do |t|
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
17 t.string "ip", limit: 50, null: false
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
18 t.text "paste", null: false
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
19 t.string "paste_hash", limit: 150, null: false
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
20 t.datetime "created_at", null: false
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
21 t.datetime "updated_at", null: false
176
a9dba6a3008b Initial work to add paste deletion.
Edho Arief <edho@myconan.net>
parents: 23
diff changeset
22 t.string "key"
207
ee7829c7c2a2 Prepare for private pastes.
Edho Arief <edho@myconan.net>
parents: 196
diff changeset
23 t.string "secret"
2
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
24 end
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
25
196
8d465a93fcb4 Update the schema, too (with p.much nothing).
Edho Arief <edho@myconan.net>
parents: 176
diff changeset
26 add_index "pastes", ["ip", "paste_hash"], name: "index_pastes_on_ip_and_hash", unique: true, using: :btree
221
0f9f29274663 Add index to pastes.secret
Edho Arief <edho@myconan.net>
parents: 207
diff changeset
27 add_index "pastes", ["secret"], name: "index_pastes_on_secret", using: :btree
2
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
28
42de15334db1 Added the pastes.
Edho Arief <edho@myconan.net>
parents:
diff changeset
29 end