spec/dummy/db/schema.rb in tb_banners-1.2.1 vs spec/dummy/db/schema.rb in tb_banners-1.3.beta1
- old
+ new
@@ -1,6 +1,5 @@
-# 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
@@ -9,113 +8,107 @@
# 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: 20160310164644) do
+ActiveRecord::Schema.define(version: 20_160_310_164_644) do
- create_table "spud_banner_sets", force: :cascade do |t|
- t.string "name", limit: 255, null: false
- t.integer "width", limit: 4, null: false
- t.integer "height", limit: 4, null: false
- t.boolean "cropped", default: true
- t.datetime "created_at"
- t.datetime "updated_at"
- t.boolean "has_rich_text", default: false
+ create_table 'spud_banner_sets', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.string 'name', null: false
+ t.integer 'width', null: false
+ t.integer 'height', null: false
+ t.boolean 'cropped', default: true
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.boolean 'has_rich_text', default: false
+ t.index ['name'], name: 'index_spud_banner_sets_on_name', unique: true, using: :btree
end
- add_index "spud_banner_sets", ["name"], name: "index_spud_banner_sets_on_name", unique: true, using: :btree
-
- create_table "spud_banners", force: :cascade do |t|
- t.integer "spud_banner_set_id", limit: 4, null: false
- t.string "link_to", limit: 255
- t.string "link_target", limit: 255, default: "_self"
- t.string "title", limit: 255
- t.string "alt", limit: 255
- t.integer "sort_order", limit: 4, default: 0
- t.string "banner_file_name", limit: 255
- t.string "banner_content_type", limit: 255
- t.integer "banner_file_size", limit: 4
- t.datetime "banner_updated_at"
- t.datetime "created_at"
- t.datetime "updated_at"
- t.text "rich_text", limit: 65535
- t.date "start_date"
- t.date "end_date"
+ create_table 'spud_banners', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.integer 'spud_banner_set_id', null: false
+ t.string 'link_to'
+ t.string 'link_target', default: '_self'
+ t.string 'title'
+ t.string 'alt'
+ t.integer 'sort_order', default: 0
+ t.string 'banner_file_name'
+ t.string 'banner_content_type'
+ t.integer 'banner_file_size'
+ t.datetime 'banner_updated_at'
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.text 'rich_text', limit: 65_535
+ t.date 'start_date'
+ t.date 'end_date'
+ t.index ['spud_banner_set_id'], name: 'index_spud_banners_on_spud_banner_set_id', using: :btree
end
- add_index "spud_banners", ["spud_banner_set_id"], name: "index_spud_banners_on_spud_banner_set_id", using: :btree
-
- create_table "spud_liquid_tags", force: :cascade do |t|
- t.integer "attachment_id", limit: 4
- t.string "attachment_type", limit: 255
- t.string "tag_name", limit: 255
- t.string "value", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
+ create_table 'spud_liquid_tags', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.integer 'attachment_id'
+ t.string 'attachment_type'
+ t.string 'tag_name'
+ t.string 'value'
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.index ['tag_name', 'value'], name: 'index_spud_liquid_tags_on_tag_name_and_value', using: :btree
end
- add_index "spud_liquid_tags", ["tag_name", "value"], name: "index_spud_liquid_tags_on_tag_name_and_value", using: :btree
-
- create_table "spud_permissions", force: :cascade do |t|
- t.string "name", limit: 255, null: false
- t.string "tag", limit: 255, null: false
- t.datetime "created_at"
- t.datetime "updated_at"
+ create_table 'spud_permissions', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.string 'name', null: false
+ t.string 'tag', null: false
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.index ['tag'], name: 'index_spud_permissions_on_tag', unique: true, using: :btree
end
- add_index "spud_permissions", ["tag"], name: "index_spud_permissions_on_tag", unique: true, using: :btree
-
- create_table "spud_role_permissions", force: :cascade do |t|
- t.integer "spud_role_id", limit: 4, null: false
- t.string "spud_permission_tag", limit: 255, null: false
- t.datetime "created_at"
- t.datetime "updated_at"
+ create_table 'spud_role_permissions', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.integer 'spud_role_id', null: false
+ t.string 'spud_permission_tag', null: false
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.index ['spud_permission_tag'], name: 'index_spud_role_permissions_on_spud_permission_tag', using: :btree
+ t.index ['spud_role_id'], name: 'index_spud_role_permissions_on_spud_role_id', using: :btree
end
- add_index "spud_role_permissions", ["spud_permission_tag"], name: "index_spud_role_permissions_on_spud_permission_tag", using: :btree
- add_index "spud_role_permissions", ["spud_role_id"], name: "index_spud_role_permissions_on_spud_role_id", using: :btree
-
- create_table "spud_roles", force: :cascade do |t|
- t.string "name", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
+ create_table 'spud_roles', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.string 'name'
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
end
- create_table "spud_user_settings", force: :cascade do |t|
- t.integer "spud_user_id", limit: 4
- t.string "key", limit: 255
- t.string "value", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
+ create_table 'spud_user_settings', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.integer 'spud_user_id'
+ t.string 'key'
+ t.string 'value'
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
end
- create_table "spud_users", force: :cascade do |t|
- t.string "first_name", limit: 255
- t.string "last_name", limit: 255
- t.boolean "super_admin"
- t.string "login", limit: 255, null: false
- t.string "email", limit: 255, null: false
- t.string "crypted_password", limit: 255, null: false
- t.string "password_salt", limit: 255, null: false
- t.string "persistence_token", limit: 255, null: false
- t.string "single_access_token", limit: 255, null: false
- t.string "perishable_token", limit: 255, null: false
- t.integer "login_count", limit: 4, default: 0, null: false
- t.integer "failed_login_count", limit: 4, default: 0, null: false
- t.datetime "last_request_at"
- t.datetime "current_login_at"
- t.datetime "last_login_at"
- t.string "current_login_ip", limit: 255
- t.string "last_login_ip", limit: 255
- t.datetime "created_at"
- t.datetime "updated_at"
- t.string "time_zone", limit: 255
- t.integer "spud_role_id", limit: 4
- t.boolean "requires_password_change", default: false
+ create_table 'spud_users', force: :cascade, options: 'ENGINE=InnoDB DEFAULT CHARSET=utf8' do |t|
+ t.string 'first_name'
+ t.string 'last_name'
+ t.boolean 'super_admin'
+ t.string 'login', null: false
+ t.string 'email', null: false
+ t.string 'crypted_password', null: false
+ t.string 'password_salt', null: false
+ t.string 'persistence_token', null: false
+ t.string 'single_access_token', null: false
+ t.string 'perishable_token', null: false
+ t.integer 'login_count', default: 0, null: false
+ t.integer 'failed_login_count', default: 0, null: false
+ t.datetime 'last_request_at'
+ t.datetime 'current_login_at'
+ t.datetime 'last_login_at'
+ t.string 'current_login_ip'
+ t.string 'last_login_ip'
+ t.datetime 'created_at'
+ t.datetime 'updated_at'
+ t.string 'time_zone'
+ t.integer 'spud_role_id'
+ t.boolean 'requires_password_change', default: false
+ t.index ['email'], name: 'index_spud_users_on_email', using: :btree
+ t.index ['login'], name: 'index_spud_users_on_login', using: :btree
+ t.index ['spud_role_id'], name: 'index_spud_users_on_spud_role_id', using: :btree
end
-
- add_index "spud_users", ["email"], name: "index_spud_users_on_email", using: :btree
- add_index "spud_users", ["login"], name: "index_spud_users_on_login", using: :btree
- add_index "spud_users", ["spud_role_id"], name: "index_spud_users_on_spud_role_id", using: :btree
end