spec/dummy/db/schema.rb in tb_checkout-1.0.3 vs spec/dummy/db/schema.rb in tb_checkout-1.0.4
- old
+ new
@@ -11,121 +11,121 @@
#
# It's strongly recommended that you check this file into your version control system.
ActiveRecord::Schema.define(version: 20140915234534) do
- create_table "spud_permissions", force: true do |t|
- t.string "name", null: false
- t.string "tag", null: false
+ 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"
end
add_index "spud_permissions", ["tag"], name: "index_spud_permissions_on_tag", unique: true, using: :btree
- create_table "spud_role_permissions", force: true do |t|
- t.integer "spud_role_id", null: false
- t.string "spud_permission_tag", null: false
+ 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"
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: true do |t|
- t.string "name"
+ create_table "spud_roles", force: :cascade do |t|
+ t.string "name", limit: 255
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "spud_user_settings", force: true do |t|
- t.integer "spud_user_id"
- t.string "key"
- t.string "value"
+ 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"
end
- create_table "spud_users", force: true 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
+ create_table "spud_users", force: :cascade do |t|
+ t.string "first_name", limit: 255
+ t.string "last_name", limit: 255
+ t.boolean "super_admin", limit: 1
+ 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"
- t.string "last_login_ip"
+ 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"
- t.integer "spud_role_id"
+ t.string "time_zone", limit: 255
+ t.integer "spud_role_id", limit: 4
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
- create_table "tb_checkout_basic_products", force: true do |t|
- t.string "description"
- t.decimal "price", precision: 8, scale: 2
+ create_table "tb_checkout_basic_products", force: :cascade do |t|
+ t.string "description", limit: 255
+ t.decimal "price", precision: 8, scale: 2
t.datetime "created_at"
t.datetime "updated_at"
end
- create_table "tb_checkout_cart_items", force: true do |t|
- t.integer "cart_id", null: false
- t.integer "item_id", null: false
- t.string "item_type", null: false
- t.string "item_description"
- t.decimal "item_price", precision: 8, scale: 2
- t.integer "quantity", default: 1
+ create_table "tb_checkout_cart_items", force: :cascade do |t|
+ t.integer "cart_id", limit: 4, null: false
+ t.integer "item_id", limit: 4, null: false
+ t.string "item_type", limit: 255, null: false
+ t.string "item_description", limit: 255
+ t.decimal "item_price", precision: 8, scale: 2
+ t.integer "quantity", limit: 4, default: 1
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "tb_checkout_cart_items", ["cart_id"], name: "index_tb_checkout_cart_items_on_cart_id", using: :btree
add_index "tb_checkout_cart_items", ["item_id", "item_type"], name: "index_tb_checkout_cart_items_on_item_id_and_item_type", using: :btree
- create_table "tb_checkout_carts", force: true do |t|
- t.integer "spud_user_id"
+ create_table "tb_checkout_carts", force: :cascade do |t|
+ t.integer "spud_user_id", limit: 4
t.string "session_id", limit: 32
- t.boolean "is_completed", default: false
- t.boolean "is_abandoned", default: false
+ t.boolean "is_completed", limit: 1, default: false
+ t.boolean "is_abandoned", limit: 1, default: false
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "tb_checkout_carts", ["spud_user_id"], name: "index_tb_checkout_carts_on_spud_user_id", using: :btree
- create_table "tb_checkout_transactions", force: true do |t|
- t.integer "cart_id"
- t.string "status", default: "pending"
- t.string "invoice_num"
+ create_table "tb_checkout_transactions", force: :cascade do |t|
+ t.integer "cart_id", limit: 4
+ t.string "status", limit: 255, default: "pending"
+ t.string "invoice_num", limit: 255
t.integer "gateway_transaction_id", limit: 8
- t.decimal "amount_charged", precision: 8, scale: 2
- t.string "card_display"
- t.string "card_type"
- t.string "billing_first_name"
- t.string "billing_last_name"
- t.string "billing_address_1"
- t.string "billing_address_2"
- t.string "billing_city"
- t.string "billing_state"
- t.string "billing_postal"
- t.text "response_text"
+ t.decimal "amount_charged", precision: 8, scale: 2
+ t.string "card_display", limit: 255
+ t.string "card_type", limit: 255
+ t.string "billing_first_name", limit: 255
+ t.string "billing_last_name", limit: 255
+ t.string "billing_address_1", limit: 255
+ t.string "billing_address_2", limit: 255
+ t.string "billing_city", limit: 255
+ t.string "billing_state", limit: 255
+ t.string "billing_postal", limit: 255
+ t.text "response_text", limit: 65535
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "spud_user_id"
+ t.integer "spud_user_id", limit: 4
t.string "session_id", limit: 32
end
add_index "tb_checkout_transactions", ["cart_id"], name: "index_tb_checkout_transactions_on_cart_id", using: :btree
add_index "tb_checkout_transactions", ["session_id"], name: "index_tb_checkout_transactions_on_session_id", using: :btree