# 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 # database schema. If you need to create the application database on another # system, you should be using db:schema:load, not running all the migrations # 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: 20160530160739) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" create_table "disco_app_app_settings", force: :cascade do |t| t.datetime "created_at", null: false t.datetime "updated_at", null: false end create_table "disco_app_application_charges", force: :cascade do |t| t.integer "shop_id", limit: 8 t.integer "subscription_id", limit: 8 t.integer "status", default: 0 t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "shopify_id", limit: 8 t.string "confirmation_url" end create_table "disco_app_plan_codes", force: :cascade do |t| t.integer "plan_id", limit: 8 t.string "code" t.integer "trial_period_days" t.integer "amount" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "status", default: 0 end create_table "disco_app_plans", force: :cascade do |t| t.integer "status", default: 0 t.string "name" t.integer "plan_type", default: 0 t.integer "trial_period_days" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "amount", default: 0 t.string "currency", default: "USD" t.integer "interval", default: 0 t.integer "interval_count", default: 1 end create_table "disco_app_recurring_application_charges", force: :cascade do |t| t.integer "shop_id", limit: 8 t.integer "subscription_id", limit: 8 t.integer "status", default: 0 t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "shopify_id", limit: 8 t.string "confirmation_url" end create_table "disco_app_sessions", force: :cascade do |t| t.string "session_id", null: false t.text "data" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "shop_id" end add_index "disco_app_sessions", ["session_id"], name: "index_disco_app_sessions_on_session_id", unique: true, using: :btree add_index "disco_app_sessions", ["updated_at"], name: "index_disco_app_sessions_on_updated_at", using: :btree create_table "disco_app_shops", force: :cascade do |t| t.string "shopify_domain", null: false t.string "shopify_token", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "status", default: 0 t.string "domain" t.string "plan_name" t.string "name" t.jsonb "data", default: {} end add_index "disco_app_shops", ["shopify_domain"], name: "index_disco_app_shops_on_shopify_domain", unique: true, using: :btree create_table "disco_app_subscriptions", force: :cascade do |t| t.integer "shop_id" t.integer "plan_id" t.integer "status" t.integer "subscription_type" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.datetime "trial_start_at" t.datetime "trial_end_at" t.datetime "cancelled_at" t.integer "amount", default: 0 t.integer "plan_code_id", limit: 8 t.string "source" t.integer "trial_period_days" end add_index "disco_app_subscriptions", ["plan_id"], name: "index_disco_app_subscriptions_on_plan_id", using: :btree add_index "disco_app_subscriptions", ["shop_id"], name: "index_disco_app_subscriptions_on_shop_id", using: :btree create_table "js_configurations", force: :cascade do |t| t.integer "shop_id", limit: 8 t.string "label", default: "Default" t.string "locale", default: "en" end create_table "products", force: :cascade do |t| t.integer "shop_id", limit: 8 t.jsonb "data" t.datetime "created_at", null: false t.datetime "updated_at", null: false end create_table "widget_configurations", force: :cascade do |t| t.integer "shop_id", limit: 8 t.string "label", default: "Default" t.string "locale", default: "en" t.string "background_color", default: "#FFFFFF" end add_foreign_key "disco_app_application_charges", "disco_app_shops", column: "shop_id" add_foreign_key "disco_app_application_charges", "disco_app_subscriptions", column: "subscription_id" add_foreign_key "disco_app_plan_codes", "disco_app_plans", column: "plan_id" add_foreign_key "disco_app_recurring_application_charges", "disco_app_shops", column: "shop_id" add_foreign_key "disco_app_recurring_application_charges", "disco_app_subscriptions", column: "subscription_id" add_foreign_key "disco_app_sessions", "disco_app_shops", column: "shop_id", on_delete: :cascade add_foreign_key "disco_app_subscriptions", "disco_app_plan_codes", column: "plan_code_id" add_foreign_key "js_configurations", "disco_app_shops", column: "shop_id" add_foreign_key "products", "disco_app_shops", column: "shop_id" add_foreign_key "widget_configurations", "disco_app_shops", column: "shop_id" end