diff options
author | bry4n <bryann83@gmail.com> | 2015-01-25 09:07:20 +0300 |
---|---|---|
committer | bry4n <bryann83@gmail.com> | 2015-01-25 09:07:20 +0300 |
commit | 4d308ca10ee15d44ec3572a4c12cb7bd832f2e60 (patch) | |
tree | ade97f7a28c85b643b8b9b6378ff3881c7d2b288 /db | |
parent | 49eb03971d13645ad8f7cae45970d2e7f99c7388 (diff) |
Rails 4.2
Diffstat (limited to 'db')
-rw-r--r-- | db/schema.rb | 85 |
1 files changed, 56 insertions, 29 deletions
diff --git a/db/schema.rb b/db/schema.rb index 4d62523d..7e198bff 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,39 +11,49 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20121211011752) do +ActiveRecord::Schema.define(version: 20141027114732) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" - create_table "books", force: true do |t| - t.string "code" + create_table "books", force: :cascade do |t| + t.string "code", limit: 255 t.datetime "created_at" t.datetime "updated_at" + t.integer "edition", default: 1 + t.string "ebook_pdf" + t.string "ebook_epub" + t.string "ebook_mobi" + t.string "ebook_html" + t.boolean "processed" + t.integer "percent_complete" + t.string "language" end add_index "books", ["code"], name: "index_books_on_code", using: :btree - create_table "chapters", force: true do |t| - t.string "title" + create_table "chapters", force: :cascade do |t| + t.string "title", limit: 255 t.integer "book_id" t.datetime "created_at" t.datetime "updated_at" t.integer "number" - t.string "sha" + t.string "sha", limit: 255 + t.string "chapter_type", default: "chapter" + t.string "chapter_number" end add_index "chapters", ["book_id"], name: "index_chapters_on_book_id", using: :btree - create_table "doc_files", force: true do |t| - t.string "name" + create_table "doc_files", force: :cascade do |t| + t.string "name", limit: 255 t.datetime "created_at" t.datetime "updated_at" end add_index "doc_files", ["name"], name: "index_doc_files_on_name", using: :btree - create_table "doc_versions", force: true do |t| + create_table "doc_versions", force: :cascade do |t| t.integer "version_id" t.integer "doc_id" t.integer "doc_file_id" @@ -51,8 +61,8 @@ ActiveRecord::Schema.define(version: 20121211011752) do t.datetime "updated_at" end - create_table "docs", force: true do |t| - t.string "blob_sha" + create_table "docs", force: :cascade do |t| + t.string "blob_sha", limit: 255 t.text "plain" t.text "html" t.datetime "created_at" @@ -61,46 +71,57 @@ ActiveRecord::Schema.define(version: 20121211011752) do add_index "docs", ["blob_sha"], name: "index_docs_on_blob_sha", using: :btree - create_table "downloads", force: true do |t| - t.string "url" - t.string "filename" - t.string "platform" + create_table "downloads", force: :cascade do |t| + t.string "url", limit: 255 + t.string "filename", limit: 255 + t.string "platform", limit: 255 t.integer "version_id" t.datetime "created_at" t.datetime "updated_at" t.datetime "release_date" end - create_table "related_items", force: true do |t| - t.string "name" - t.string "content_type" - t.string "content_url" - t.string "related_type" - t.string "related_id" + create_table "related_items", force: :cascade do |t| + t.string "name", limit: 255 + t.string "content_type", limit: 255 + t.string "content_url", limit: 255 + t.string "related_type", limit: 255 + t.string "related_id", limit: 255 t.integer "score" t.datetime "created_at" t.datetime "updated_at" end - create_table "sections", force: true do |t| - t.string "title" - t.string "slug" + create_table "sections", force: :cascade do |t| + t.string "title", limit: 255 + t.string "slug", limit: 255 t.text "plain" t.text "html" t.integer "chapter_id" t.datetime "created_at" t.datetime "updated_at" - t.string "source_url" + t.string "source_url", limit: 255 t.integer "number" end add_index "sections", ["chapter_id"], name: "index_sections_on_chapter_id", using: :btree add_index "sections", ["slug"], name: "index_sections_on_slug", using: :btree - create_table "versions", force: true do |t| - t.string "name" - t.string "commit_sha" - t.string "tree_sha" + create_table "users", force: :cascade do |t| + t.string "screen_name", limit: 255 + t.string "github_id", limit: 255 + t.string "remember_token", limit: 255 + t.datetime "created_at" + t.datetime "updated_at" + end + + add_index "users", ["github_id"], name: "index_users_on_github_id", using: :btree + add_index "users", ["remember_token"], name: "index_users_on_remember_token", using: :btree + + create_table "versions", force: :cascade do |t| + t.string "name", limit: 255 + t.string "commit_sha", limit: 255 + t.string "tree_sha", limit: 255 t.datetime "committed" t.datetime "created_at" t.datetime "updated_at" @@ -109,4 +130,10 @@ ActiveRecord::Schema.define(version: 20121211011752) do add_index "versions", ["name"], name: "index_versions_on_name", using: :btree + create_table "xrefs", force: :cascade do |t| + t.integer "section_id" + t.integer "book_id" + t.string "name" + end + end |