SQLite format 3@ # -    #@/k++ tablecustom_productscustom_productsCREATE TABLE "custom_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "price" integer DEFAULT 0, "tax_exempt" boolean, "created_at" datetime, "updated_at" datetime)d9indexindex_carts_on_user_idcartsCREATE INDEX "index_carts_on_user_id" ON "carts" ("user_id")0?tablecartscartsCREATE TABLE "carts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K{!indexindex_cart_items_on_purchasable_type_and_purchasable_idcart_itemsCREATE INDEX "index_cart_items_on_purchasable_type_and_purchasable_id" ON "cart_items" ("purchasable_type", "purchasable_id") Q!5indexindex_cart_items_on_purchasable_idcart_itemsCREATE INDEX "index_cart_items_on_purchasable_id" ON "cart_items" ("purchasable_id")xC!indexindex_cart_items_on_cart_idcart_itemsCREATE INDEX "index_cart_items_on_cart_id" ON "cart_items" ("cart_id") !!]tablecart_itemscart_itemsCREATE TABLE "cart_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cart_id" integer, "purchasable_type" varchar, "purchasable_id" integer, "quantity" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G yindexindex_addresses_on_addressable_type_and_addressable_idaddresses CREATE INDEX "index_addresses_on_addressable_type_and_addressable_id" ON "addresses" ("addressable_type", "addressable_id") O1indexindex_addresses_on_addressable_idaddresses CREATE INDEX "index_addresses_on_addressable_id" ON "addresses" ("addressable_id")w =tableaddressesaddresses CREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "addressable_type" varchar, "addressable_id" integer, "category" varchar(64), "full_name" varchar, "address1" varchar, "address2" varchar, "city" varchar, "state_code" varchar, "country_code" varchar, "postal_code" varchar, "updated_at" datetime, "created_at" datetime) O!1indexindex_qb_tickets_on_qb_request_idqb_tickets CREATE INDEX "index_qb_tickets_on_qb_request_id" ON "qb_tickets" ("qb_request_id")]!!tableqb_ticketsqb_tickets CREATE TABLE "qb_tickets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "qb_request_id" integer, "username" varchar, "hpc_response" text, "company_file_name" varchar, "country" varchar, "qbxml_major_version" varchar, "qbxml_minor_version" varchar, "state" varchar DEFAULT 'Ready', "percent" integer DEFAULT 0, "connection_error_hresult" text, "connection_error_message" text, "last_error" text, "created_at" datetime, "updated_at" datetime)G#!indexindex_qb_requests_on_order_idqb_requestsCREATE INDEX "index_qb_requests_on_order_id" ON "qb_requests" ("order_id")##Etableqb_requestsqb_requestsCREATE TABLE "qb_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "qb_ticket_id" integer, "state" varchar DEFAULT 'Processing', "error" text, "request_type" varchar, "request_qbxml" text, "response_qbxml" text, "request_sent_at" datetime, "response_received_at" datetime, "created_at" datetime, "updated_at" datetime)W)Aindexindex_qb_order_items_on_order_item_idqb_order_itemsCREATE INDEX "index_qb_order_items_on_order_item_id" ON "qb_order_items" ("order_item_id")O))Ytableqb_order_itemsqb_order_itemsCREATE TABLE "qb_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_item_id" integer, "name" varchar, "created_at" datetime, "updated_at" datetime){G!indexindex_qb_logs_on_qb_ticket_idqb_logsCREATE INDEX "index_qb_logs_on_qb_ticket_id" ON "qb_logs" ("qb_ticket_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)9Itableqb_logsqb_logsCREATE TABLE "qb_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "qb_ticket_id" integer, "message" text, "created_at" datetime, "updated_at" date                     Du   #@/k++ tablecustom_produk++ tablecustom_productscustom_productsCREATE TABLE "custom_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "price" integer DEFAULT 0, "tax_exempt" boolean, "created_at" datetime, "updated_at" datetime)d9indexindex_carts_on_user_idcartsCREATE INDEX "index_carts_on_user_id" ON "carts" ("user_id")0?tablecartscartsCREATE TABLE "carts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K{!indexindex_cart_items_on_purchasable_type_and_purchasable_idcart_itemsCREATE INDEX "index_cart_items_on_purchasable_type_and_purchasable_id" ON "cart_items" ("purchasable_type", "purchasable_id") Q!5indexindex_cart_items_on_purchasable_idcart_itemsCREATE INDEX "index_cart_items_on_purchasable_id" ON "cart_items" ("purchasable_id")xC!indexindex_cart_items_on_cart_idcart_itemsCREATE INDEX "index_cart_items_on_cart_id" ON "cart_items" ("cart_id") !!]tablecart_itemscart_itemsCREATE TABLE "cart_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cart_id" integer, "purchasable_type" varchar, "purchasable_id" integer, "quantity" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)G yindexindex_addresses_on_addressable_type_and_addressable_idaddresses CREATE INDEX "index_addresses_on_addressable_type_and_addressable_id" ON "addresses" ("addressable_type", "addressable_id") O1indexindex_addresses_on_addressable_idaddresses CREATE INDEX "index_addresses_on_addressable_id" ON "addresses" ("addressable_id")w =tableaddressesaddresses CREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "addressable_type" varchar, "addressable_id" integer, "category" varchar(64), "full_name" varchar, "address1" varchar, "address2" varchar, "city" varchar, "state_code" varchar, "country_code" varchar, "postal_code" varchar, "updated_at" datetime, "created_at" datetime) O!1indexindex_qb_tickets_on_qb_request_idqb_tickets CREATE INDEX "index_qb_tickets_on_qb_request_id" ON "qb_tickets" ("qb_request_id")]!!tableqb_ticketsqb_tickets CREATE TABLE "qb_tickets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "qb_request_id" integer, "username" varchar, "hpc_response" text, "company_file_name" varchar, "country" varchar, "qbxml_major_version" varchar, "qbxml_minor_version" varchar, "state" varchar DEFAULT 'Ready', "percent" integer DEFAULT 0, "connection_error_hresult" text, "connection_error_message" text, "last_error" text, "created_at" datetime, "updated_at" datetime)G#!indexindex_qb_requests_on_order_idqb_requestsCREATE INDEX "index_qb_requests_on_order_id" ON "qb_requests" ("order_id")##Etableqb_requestsqb_requestsCREATE TABLE "qb_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "qb_ticket_id" integer, "state" varchar DEFAULT 'Processing', "error" text, "request_type" varchar, "request_qbxml" text, "response_qbxml" text, "request_sent_at" datetime, "response_received_at" datetime, "created_at" datetime, "updated_at" datetime)W)Aindexindex_qb_order_items_on_order_item_idqb_order_itemsCREATE INDEX "index_qb_order_items_on_order_item_id" ON "qb_order_items" ("order_item_id")O))Ytableqb_order_itemsqb_order_itemsCREATE TABLE "qb_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_item_id" integer, "name" varchar, "created_at" datetime, "updated_at" datetime){G!indexindex_qb_logs_on_qb_ticket_idqb_logsCREATE INDEX "index_qb_logs_on_qb_ticket_id" ON "qb_logs" ("qb_ticket_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)9Itableqb_logsqb_logsCREATE TABLE "qb_logs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "qb_ticket_id" integer, "message" text, "created_at" datetime, "updated_at" datetime)   H3apg S c =//indexunique_schema_migrationsschema_migrations#CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")??Etableproduct_with_float_pricesproduct_with_float_pricesCREATE TABLE "product_with_float_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "price" decimal DEFAULT 0, "tax_exempt" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)h#tableproductsproductsCREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "price" integer DEFAULT 0, "tax_exempt" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)h; indexindex_orders_on_user_idordersCREATE INDEX "index_orders_on_user_id" ON "orders" ("user_id")ctableordersordersCREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "purchase_state" varchar, "purchased_at" datetime, "payment" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "note" text, "total" integer, "tax_rate" decimal(6,3), "subtotal" integer, "tax" integer, "payment_provider" varchar, "payment_card" varchar)O}# indexindex_order_items_on_purchasable_type_and_purchasable_idorder_itemsCREATE INDEX "index_order_items_on_purchasable_type_and_purchasable_id" ON "order_items" ("purchasable_type", "purchasable_id")S#9indexindex_order_items_on_purchasable_idorder_itemsCREATE INDEX "index_order_items_on_purchasable_id" ON "order_items" ("purchasable_id")G#!indexindex_order_items_on_order_idorder_itemsCREATE INDEX "index_order_items_on_order_id" ON "order_items" ("order_id")d##tableorder_itemsorder_itemsCREATE TABLE "order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "seller_id" integer, "purchasable_type" varchar, "purchasable_id" integer, "title" varchar, "quantity" integer, "price" integer DEFAULT 0, "tax_exempt" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) itablecustomerscustomersCREATE TABLE "customers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "stripe_customer_id" varchar, "stripe_active_card" varchar, "stripe_connect_access_token" varchar, "created_at" datetime, "updated_at" datetime)k++ tablecustom_productscustom_productsCREATE TABLE "custom_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar, "price" integer DEFAULT 0, "tax_exempt" boolean, "created_at" datetime, "updated_at" datetime)d9indexindex_carts_on_user_idcartsCREATE INDEX "index_carts_on_user_id" ON "carts" ("user_id")0?tablecartscartsCREATE TABLE "carts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){!indexindex_cart_itemsl//tableschema_migrationsschema_migrations"CREATE TABLE "schema_migrations" ("version" varchar NOT NULL)i1tableusersusers!CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "encrypted_password" varchar, "reset_password_token" varchar, "reset_password_sent_at" datetime, "remember_created_at" datetime, "confirmation_sent_at" datetime, "confirmed_at" datetime, "confirmation_token" varchar, "unconfirmed_email" varchar, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar, "last_sign_in_ip" varchar, "email" varchar, "roles_mask" integer DEFAULT 0, "archived" boolean DEFAULT 'f', "updated_at" datetime, "created_at" datetime)>'';tablesubscriptionssubscriptions CREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "customer_id" integer, "stripe_plan_id" varchar, "stripe_subscription_id" varchar, "stripe_coupon_id" varchar, "title" varchar, "price" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)           5  5