SQLite format 3@ -e^xi_MS)/G 5uoic]#KE?93-'!{YA} ;QWrldj^@;72.~)s#kA4dc~by$uMGO?K.K$L H9 =TDv-p(m hdDDCeYĂL> 83.)$ZV[R ۂՂ Ȃ`MÁ}up hZUHam?2"4]Ji> ;^IonO]]LAM_qbU'ZJ &TGD?d::[12IVXP0iH u*Ed2qC)20191113195927)20191113195882)20191113195836)20191113195793X)20191113195749, H#AAenvironmenttest2019-11-13 19:29:52.9260582019-11-13 19:29:52.926058 # environment  4v`B$iT4Cspree_shipping_method_zones-spree_role_users?spree_property_prototypes Aspree_promotion_rule_users Gspree_product_promotion_rules 9spree_order_promotions Cspree_option_value_variants Espree_option_type_prototypes=spree_store_credit_types? spree_reimbursement_types/friendly_id_slugs5 spree_refund_reasons&Qspree_return_authorization_reasons % spree_stores? spree_shipping_categories7spree_products_taxons  Cr) 773tablesprP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)77Ytablespree_purchase_ordersspree_purchase_ordersCREATE TABLE "spree_purchase_orders" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "po_number" varchar, "organization_name" varchar, "created_at" datetime, "updated_at" datetime, "payment_method_id" integer, "user_id" integer)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadataN55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)AU/indexsqlite_autoindex_schema_migrations_1schema_migrationsx//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY) _B_WW O5?indexindex_active_storage_blobs_on_keyactive_storage_blobs CREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")B 55'tableactive_storage_blobsactive_storage_blobs CREATE TABLE "active_storage_blobs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "key" varchar NOT NULL, "filename" varchar NOT NULL, "content_type" varchar, "metadata" text, "byte_size" bigint NOT NULL, "checksum" varchar NOT NULL, "created_at" datetime NOT NULL)$Y7Eindexindex_spree_purchase_orders_on_user_idspree_purchase_orders CREATE INDEX "index_spree_purchase_orders_on_user_id" ON "spree_purchase_orders" ("user_id")Bm7mindexindex_spree_purchase_orders_on_payment_method_idspree_purchase_ordersCREATE INDEX "index_spree_purchase_orders_on_payment_method_id" ON "spree_purchase_orders" ("payment_method_id")R     b))!!c cA/indexindex_active_storage_attachments_uniquenessactive_storage_attachmentsCREATE UNIQUE INDEX "index_active_storage_attachments_uniqueness" ON "active_storage_attachments" ("record_type", "record_id", "name", "blob_id")8 cAYindexindex_active_storage_attachments_on_blob_idactive_storage_attachmentsCREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id") AA5tableactive_storage_attachmentsactive_storage_attachmentsCREATE TABLE "active_storage_attachments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "record_type" varchar NOT NULL, "record_id" integer NOT NULL, "blob_id" integer NOT NULL, "created_at" datetime NOT NULL, CONSTRAINT "fk_rails_c3b3935057" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )    A6++#tablespree_addressesspree_addressesCREATE TABLE "spree_addresses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar, "lastname" varchar, "address1" varchar, "address2" varchar, "city" varchar, "zipcode" varchar, "phone" varchar, "state_name" varchar, "alternative_phone" varchar, "company" varchar, "state_id" integer, "country_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)   ,w,^B%%Gtablespree_assetsspree_assetsCREATE TABLE "spree_assets" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_type" varchar, "viewable_id" integer, "attachment_width" integer, "attachment_height" integer, "attachment_file_size" integer, "position" integer, "attachment_content_type" varchar, "attachment_file_name" varchar, "type" varchar(75), "attachment_updated_at" datetime, "alt" text, "created_at" datetime, "updated_at" datetime)C+%indexindex_addresses_on_lastnamespree_addressesCREATE INDEX "index_addresses_on_lastname" ON "spree_addresses" ("lastname")E+)indexindex_addresses_on_firstnamespree_addressesCREATE INDEX "index_addresses_on_firstname" ON "spree_addresses" ("firstname")     iCC- Y%Oindexindex_assets_on_viewable_type_and_typespree_assetsCREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")C%%indexindex_assets_on_viewable_idspree_assetsCREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id")^6//tablespree_calculatorsspree_calculatorsCREATE TABLE "spree_calculators" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "calculable_type" varchar, "calculable_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "preferences" text, "deleted_at" datetime)     >jd>kk#&11qtablespree_option_typesspree_option_types2CREATE TABLE "spree_option_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "presentation" varchar(100), "position" integer DEFAULT 0 NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)$//5tablespree_log_entriesspree_log_entries/CREATE TABLE "spree_log_entries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "source_type" varchar, "source_id" integer, "details" text, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)))atablespree_gatewaysspree_gateways%CREATE TABLE "spree_gateways" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "name" varchar, "description" text, "active" boolean DEFAULT 't', "environment" varchar DEFAULT 'development', "server" varchar DEFAULT 'test', "test_mode" boolean DEFAULT 't', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "preferences" text)                 >!!&2AAWtablespree_product_option_typesspree_product_option_typesBCREATE TABLE "spree_product_option_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer, "product_id" integer, "option_type_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)#(33mtablespree_option_valuesspree_option_values4CREATE TABLE "spree_option_values" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer, "name" varchar, "presentation" varchar, "option_type_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)         -4Y=Qindexindex_product_properties_on_product_idspree_product_propertiesECREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id")83==tablespree_product_propertiesspree_product_propertiesCCREATE TABLE "spree_product_properties" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar, "product_id" integer, "property_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "position" integer DEFAULT 0)) jjLL99?tablespree_shipping_methodsspree_shipping_methods]CREATE TABLE "spree_shipping_methods" ("id" integer NOT NULL PRIMARY KEY, "name" varchar DEFAULT NULL, "display_on" varchar DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "tracking_url" varchar DEFAULT NULL, "admin_name" varchar, "tax_category_id" integer, "code" varchar) zz O%%AA Spree::PaymentMethod::StoreCreditStore CreditStore Creditt2019-11-13 19:57:53.1658182019-11-13 19:57:53.165818back_end     88}DK55+tablespree_tax_categoriesspree_tax_categoriesaCREATE TABLE "spree_tax_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" varchar, "is_default" boolean DEFAULT 'f', "deleted_at" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "tax_code" varchar){M--)tablespree_taxonomiesspree_taxonomiesdCREATE TABLE "spree_taxonomies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "position" integer DEFAULT 0)L++7tablespree_tax_ratesspree_tax_ratescCREATE TABLE "spree_tax_rates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,5), "zone_id" integer, "tax_category_id" integer, "included_in_price" boolean DEFAULT 'f', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "name" varchar, "show_rate_in_label" boolean DEFAULT 't', "deleted_at" datetime)   77777T?--[tablespree_prototypesspree_prototypesRCREATE TABLE "spree_prototypes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)u=--tablespree_propertiesspree_propertiesPCREATE TABLE "spree_properties" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "presentation" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)Z       Wggg^^|$GGutablespree_store_credit_categoriesspree_store_credit_categoriesRCREATE TABLE "spree_store_credit_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)*#I3cindexspree_store_credits_originatorspree_store_creditsQCREATE INDEX "spree_store_credits_originator" ON "spree_store_credits" ("originator_id", "originator_type")"U3=indexindex_spree_store_credits_on_type_idspree_store_creditsPCREATE INDEX "index_spree_store_credits_on_type_id" ON "spree_store_credits" ("type_id")!U3=indexindex_spree_store_credits_on_user_idspree_store_creditsNCREATE INDEX "index_spree_store_credits_on_user_id" ON "spree_store_credits" ("user_id")    ]OOwtablespree_promotion_action_line_itemsspree_promotion_action_line_itemsyCREATE TABLE "spree_promotion_action_line_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_action_id" integer, "variant_id" integer, "quantity" integer DEFAULT 1)7Y##5tablespree_zonesspree_zonestCREATE TABLE "spree_zones" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" varchar, "default_tax" boolean DEFAULT 'f', "zone_members_count" integer DEFAULT 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "kind" varchar) X11Etablespree_zone_membersspree_zone_memberssCREATE TABLE "spree_zone_members" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_type" varchar, "zoneable_id" integer, "zone_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)     NwwwwauA##Etablespree_rolesspree_rolesUCREATE TABLE "spree_roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)koG??mtablespree_shipping_categoriesspree_shipping_categories\CREATE TABLE "spree_shipping_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)      ?J%%Atablespree_statesspree_states`CREATE TABLE "spree_states" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "abbr" varchar, "country_id" integer, "updated_at" datetime)PI33Gtablespree_state_changesspree_state_changes_CREATE TABLE "spree_state_changes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "previous_state" varchar, "stateful_id" integer, "user_id" integer, "stateful_type" varchar, "next_state" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  @AADefault2019-11-13 19:57:31.8348892019-11-13 19:57:31.834889      M+-indexindex_spree_tax_rates_on_zone_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_zone_id" ON "spree_tax_rates" ("zone_id")%=]+Mindexindex_spree_tax_rates_on_tax_category_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_tax_category_id" ON "spree_tax_rates" ("tax_category_id").<c+Yindexindex_spree_tax_rates_on_show_rate_in_labelspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_show_rate_in_label" ON "spree_tax_rates" ("show_rate_in_label")+;a+Uindexindex_spree_tax_rates_on_included_in_pricespree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_included_in_price" ON "spree_tax_rates" ("included_in_price"):S+9indexindex_spree_tax_rates_on_deleted_atspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_deleted_at" ON "spree_tax_rates" ("deleted_at")*9]5Mindexindex_spree_tax_categories_on_is_defaultspree_tax_categoriesCREATE INDEX "index_spree_tax_categories_on_is_default" ON "spree_tax_categories" ("is_default") h/55qtablespree_shipping_ratesspree_shipping_ratesCREATE TABLE "spree_shipping_rates" ("id" integer NOT NULL PRIMARY KEY, "shipment_id" integer DEFAULT NULL, "shipping_method_id" integer DEFAULT NULL, "selected" boolean DEFAULT 'f', "cost" decimal(8,2) DEFAULT 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "tax_rate_id" integer)60K5windexspree_shipping_rates_join_indexspree_shipping_ratesCREATE UNIQUE INDEX "spree_shipping_rates_join_index" ON "spree_shipping_rates" ("shipment_id", "shipping_method_id")U s Mindexindex_spree_shipping_method_categories_on_shipping_method_idspree_shipping_method_categoriesCREATE INDEX "index_spree_shipping_method_categories_on_shipping_method_id" ON "spree_shipping_method_categories" ("shipping_method_id")E MM{tablespree_shipping_method_categoriesspree_shipping_method_categoriesCREATE TABLE "spree_shipping_method_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "shipping_method_id" integer NOT NULL, "shipping_category_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)      PAAdefault2019-11-13 19:57:21.0389302019-11-13 19:57:21.038930fttt  XQQ{rrk''tablespree_refundsspree_refunds=CREATE TABLE "spree_refunds" ("id" integer NOT NULL PRIMARY KEY, "payment_id" integer DEFAULT NULL, "amount" decimal(10,2) DEFAULT '0.0' NOT NULL, "transaction_id" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "refund_reason_id" integer DEFAULT NULL, "reimbursement_id" integer)O'=indexindex_refunds_on_refund_reason_idspree_refunds@CREATE INDEX "index_refunds_on_refund_reason_id" ON "spree_refunds" ("refund_reason_id") AAAU4y7indexindex_spree_stock_transfers_on_destination_location_idspree_stock_transfersCREATE INDEX "index_spree_stock_transfers_on_destination_location_id" ON "spree_stock_transfers" ("destination_location_id")F3o7qindexindex_spree_stock_transfers_on_source_location_idspree_stock_transfersCREATE INDEX "index_spree_stock_transfers_on_source_location_id" ON "spree_stock_transfers" ("source_location_id")r177tablespree_stock_transfersspree_stock_transfersCREATE TABLE "spree_stock_transfers" ("id" integer NOT NULL PRIMARY KEY, "type" varchar DEFAULT NULL, "reference" varchar DEFAULT NULL, "source_location_id" integer DEFAULT NULL, "destination_location_id" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "number" varchar)  JJ[JJn<// tablespree_stock_itemsspree_stock_itemsuCREATE TABLE "spree_stock_items" ("id" integer NOT NULL PRIMARY KEY, "stock_location_id" integer DEFAULT NULL, "variant_id" integer DEFAULT NULL, "count_on_hand" integer DEFAULT 0 NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "backorderable" boolean DEFAULT 'f', "deleted_at" datetime)W!>E/Yindexstock_item_by_loc_and_var_idspree_stock_itemsCREATE INDEX "stock_item_by_loc_and_var_id" ON "spree_stock_items" ("stock_location_id", "variant_id")          +|iVC0 r_L9&{hUB/ q)20191113195748+)20191113195747*)20191113195746))20191113195745()20191113195744')20191113195743&)20191113195742%)20191113195741$)20191113195740#)20191113195739")20191113195738!)20191113195737 )20191113195736)20191113195735)20191113195734)20191113195733)20191113195732)20191113195731)20191113195730)20191113195729)20191113195728)20191113195727)20191113195726)20191113195725)20191113195724)20191113195723)20191113195722)20191113195721)20191113195720)20191113195719)20191113195718 )20191113195717 )20191113195716 )20191113195715 )20191113195714 )20191113195713)20191113195712)20191113195711)20191113195710)20191113195709)20161214191512)20161214190805) 20160111123141 /+8%zgTA. q^K{hUB/p)20191113195778I)20191113195777H)20191113195776G)20191113195775F)20191113195774E)20191113195773D)20191113195772C)20191113195771B)20191113195770A)20191113195769@)20191113195768?)20191113195767>)20191113195766=)20191113195765<)20191113195764;)20191113195763:)201911131957629)201911131957618)201911131957607)201911131957596)201911131957585)201911131957574)201911131957563)201911131957552)20191113195790U)20191113195789T)20191113195788S)20191113195787R)20191113195786Q)20191113195785P)20191113195784O)20191113195783N)20191113195782M)20191113195781L)20191113195780K)20191113195779JL)20191113195792W)20191113195791V)201911131957541)201911131957530)20191113195752/)20191113195751.)20191113195750-  !I--utablespree_promotionsspree_promotionsCREATE TABLE "spree_promotions" ("id" integer NOT NULL PRIMARY KEY, "description" varchar DEFAULT NULL, "expires_at" datetime DEFAULT NULL, "starts_at" datetime DEFAULT NULL, "name" varchar DEFAULT NULL, "type" varchar DEFAULT NULL, "usage_limit" integer DEFAULT NULL, "match_policy" varchar DEFAULT 'all', "code" varchar DEFAULT NULL, "advertise" boolean DEFAULT 'f', "path" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "promotion_category_id" integer)  2|p^L:(tbP>,xfTB0 |2)201911131957551)201911131957540)20191113195753/)20191113195752.)20191113195751-)20191113195750,)20191113195749+)20191113195748*)20191113195747))20191113195746()20191113195745')20191113195744&)20191113195743%)20191113195742$)20191113195741#)20191113195740")20191113195739!)20191113195738 )20191113195737)20191113195736)20191113195735)20191113195734)20191113195733)20191113195732)20191113195731)20191113195730)20191113195729)20191113195728)20191113195727)20191113195726)20191113195725)20191113195724)20191113195723)20191113195722)20191113195721)20191113195720)20191113195719 )20191113195718 )20191113195717 )20191113195716 )20191113195715 )20191113195714)20191113195713)20191113195712)20191113195711)20191113195710)20191113195709)20161214191512)20161214190805)20160111123141 2|p^L:(tbP>,xfTB0 |d)20191113195805c)20191113195804b)20191113195803a)20191113195802`)20191113195801_)20191113195800^)20191113195799])20191113195798\)20191113195797[)20191113195796Z)20191113195795Y)20191113195794X)20191113195793W)20191113195792V)20191113195791U)20191113195790T)20191113195789S)20191113195788R)20191113195787Q)20191113195786P)20191113195785O)20191113195784N)20191113195783M)20191113195782L)20191113195781K)20191113195780J)20191113195779I)20191113195778H)20191113195777G)20191113195776F)20191113195775E)20191113195774D)20191113195773C)20191113195772B)20191113195771A)20191113195770@)20191113195769?)20191113195768>)20191113195767=)20191113195766<)20191113195765;)20191113195764:)201911131957639)201911131957628)201911131957617)201911131957606)201911131957595)201911131957584)201911131957573)20191113195756 ^^?77Ytablespree_stock_locationsspree_stock_locationsCREATE TABLE "spree_stock_locations" ("id" integer NOT NULL PRIMARY KEY, "name" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "default" boolean DEFAULT 'f' NOT NULL, "address1" varchar DEFAULT NULL, "address2" varchar DEFAULT NULL, "city" varchar DEFAULT NULL, "state_id" integer DEFAULT NULL, "state_name" varchar DEFAULT NULL, "country_id" integer DEFAULT NULL, "zipcode" varchar DEFAULT NULL, "phone" varchar DEFAULT NULL, "active" boolean DEFAULT 't', "backorderable_default" boolean DEFAULT 'f', "propagate_all_variants" boolean DEFAULT 't', "admin_name" varchar)      lwH++%tablespree_countriesspree_countries"CREATE TABLE "spree_countries" ("id" integer NOT NULL PRIMARY KEY, "iso_name" varchar DEFAULT NULL, "iso" varchar DEFAULT NULL, "iso3" varchar DEFAULT NULL, "name" varchar DEFAULT NULL, "numcode" integer DEFAULT NULL, "states_required" boolean DEFAULT 'f', "updated_at" datetime DEFAULT NULL, "zipcode_required" boolean DEFAULT 't') pZI/3indexindex_spree_preferences_on_keyspree_preferenceszCREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")pY//tablespree_preferencesspree_preferences?CREATE TABLE "spree_preferences" ("id" integer NOT NULL PRIMARY KEY, "value" text DEFAULT NULL, "key" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)gX[M1indexunique_spree_shipping_method_categoriesspree_shipping_method_categoriesCREATE UNIQUE INDEX "unique_spree_shipping_method_categories" ON "spree_shipping_method_categories" ("shipping_category_id", "shipping_method_id")    *{hUB/T q^K8%zgA.{)20191113195835)20191113195798])20191113195834)20191113195833)20191113195832)20191113195831~)20191113195803b)20191113195827z)20191113195826y)20191113195825x)20191113195824w)20191113195823v)20191113195822u)20191113195821t)20191113195820s)20191113195819r)20191113195818q)20191113195817p)20191113195816o)20191113195815n)20191113195814m)20191113195813l)20191113195812k)20191113195811j)20191113195810i)20191113195809h)20191113195808g)20191113195807f)20191113195806e)20191113195805d)20191113195804c)20191113195802a)20191113195801`)20191113195800_)20191113195799^)20191113195797\)20191113195796[)20191113195795Z)20191113195794Y)20191113195830})20191113195829|)20191113195828{ 1xp^L:(tbP>,o\I6#x)20191113195854)20191113195853)20191113195852)20191113195851)20191113195850)20191113195849)20191113195848)20191113195847 )20191113195846 )20191113195845 )20191113195844 )20191113195843 )20191113195842)20191113195841)20191113195840)20191113195839)20191113195838)20191113195837)20191113195836)20191113195835)20191113195834)20191113195833)20191113195832~)20191113195831})20191113195830|)20191113195829{)20191113195828z)20191113195827y)20191113195826x)20191113195825w)20191113195824v)20191113195823u)20191113195822t)20191113195821s)20191113195820r)20191113195819q)20191113195818p)20191113195817o)20191113195816n)20191113195815m)20191113195814l)20191113195813k)20191113195812j)20191113195811i)20191113195810h)20191113195809g)20191113195808f)20191113195807e)20191113195806  0p{hUB/ q^K8%zgTA.pu)20191113195950t)20191113195949s)20191113195948r)20191113195947q)20191113195946p)20191113195945o)20191113195944n)20191113195943m)20191113195942l)20191113195941k)20191113195940j)20191113195939i)20191113195938h)20191113195937g)20191113195936f)20191113195935e)20191113195934d)20191113195933c)20191113195932b)20191113195931a)20191113195930`)20191113195929_)20191113195928^)20191113195927])20191113195926\)20191113195925[)20191113195924Z)20191113195923Y)20191113195922X)20191113195921W)20191113195920V)20191113195919U)20191113195918T)20191113195917S)20191113195916R)20191113195915Q)20191113195914P)20191113195913O)20191113195912N)20191113195911M)20191113195910L)20191113195909K)20191113195908J)20191113195907I)20191113195906H)20191113195905G)20191113195904F)20191113195903 yyeNS[))atablespree_productsspree_products*CREATE TABLE "spree_products" ("id" integer NOT NULL PRIMARY KEY, "name" varchar DEFAULT '' NOT NULL, "description" text DEFAULT NULL, "available_on" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "slug" varchar DEFAULT NULL, "meta_description" text DEFAULT NULL, "meta_keywords" varchar DEFAULT NULL, "tax_category_id" integer DEFAULT NULL, "shipping_category_id" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "promotionable" boolean DEFAULT 't', "meta_title" varchar, "discontinue_on" datetime)]Q)5indexindex_spree_products_on_deleted_atspree_productsGCREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")\U)=indexindex_spree_products_on_available_onspree_productsFCREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on") P~c77!tablespree_promotion_rulesspree_promotion_rules|CREATE TABLE "spree_promotion_rules" ("id" integer NOT NULL PRIMARY KEY, "promotion_id" integer DEFAULT NULL, "user_id" integer DEFAULT NULL, "product_group_id" integer DEFAULT NULL, "type" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "code" varchar DEFAULT NULL, "preferences" text)3d_7]indexindex_promotion_rules_on_product_group_idspree_promotion_rules}CREATE INDEX "index_promotion_rules_on_product_group_id" ON "spree_promotion_rules" ("product_group_id").^E)indexindex_spree_products_on_namespree_productsICREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")   ldl=of;;tablespree_promotion_actionsspree_promotion_actions{CREATE TABLE "spree_promotion_actions" ("id" integer NOT NULL PRIMARY KEY, "promotion_id" integer DEFAULT NULL, "position" integer DEFAULT NULL, "type" varchar DEFAULT NULL, "deleted_at" datetime)JhmEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_eventsCREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_events" ("payment_id")#gEEGtablespree_payment_capture_eventsspree_payment_capture_eventsCREATE TABLE "spree_payment_capture_events" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10,2) DEFAULT 0.0, "payment_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)eM79indexindex_promotion_rules_on_user_idspree_promotion_rules~CREATE INDEX "index_promotion_rules_on_user_id" ON "spree_promotion_rules" ("user_id") \co/indexindex_spree_calculators_on_calculable_id_and_calculable_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_calculable_id_and_calculable_type" ON "spree_calculators" ("calculable_id", "calculable_type") nY/Cindexindex_spree_calculators_on_id_and_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_id_and_type" ON "spree_calculators" ("id", "type")   % O Spree::PaymentMethod::StoreCredit     .D.2tc3Yindexindex_spree_option_values_on_option_type_idspree_option_valuesCREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")sW-?indexindex_spree_promotions_on_id_and_typespree_promotionsCREATE INDEX "index_spree_promotions_on_id_and_type" ON "spree_promotions" ("id", "type")\>o)oindexindex_spree_taggings_on_tagger_id_and_tagger_typespree_taggingsxCREATE INDEX "index_spree_taggings_on_tagger_id_and_tagger_type" ON "spree_taggings" ("tagger_id", "tagger_type") K))indexindex_spree_taggings_on_contextspree_taggingswCREATE INDEX "index_spree_taggings_on_context" ON "spree_taggings" ("context")O)1indexindex_spree_taggings_on_tagger_idspree_taggingsvCREATE INDEX "index_spree_taggings_on_tagger_id" ON "spree_taggings" ("tagger_id")W)Aindexindex_spree_taggings_on_taggable_typespree_taggingsuCREATE INDEX "index_spree_taggings_on_taggable_type" ON "spree_taggings" ("taggable_type") S)9indexindex_spree_taggings_on_taggable_idspree_taggingstCREATE INDEX "index_spree_taggings_on_taggable_id" ON "spree_taggings" ("taggable_id") I)%indexindex_spree_taggings_on_tag_idspree_taggingsrCREATE INDEX "index_spree_taggings_on_tag_id" ON "spree_taggings" ("tag_id")    ]]XTeO7=indexindex_inventory_units_on_order_idspree_inventory_units(CREATE INDEX "index_inventory_units_on_order_id" ON "spree_inventory_units" ("order_id")3hc7Yindexindex_spree_inventory_units_on_line_item_idspree_inventory_units^CREATE INDEX "index_spree_inventory_units_on_line_item_id" ON "spree_inventory_units" ("line_item_id")!gS7Eindexindex_inventory_units_on_variant_idspree_inventory_unitsSCREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")$fU7Iindexindex_inventory_units_on_shipment_idspree_inventory_units)CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")    \ CF\[fuAAWtablespree_promotion_rule_usersspree_promotion_rule_users$CREATE TABLE "spree_promotion_rule_users" ("user_id" integer DEFAULT NULL, "promotion_rule_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)ytG1indexindex_products_promotion_rules_on_promotion_rule_and_productspree_product_promotion_rulesvCREATE INDEX "index_products_promotion_rules_on_promotion_rule_and_product" ON "spree_product_promotion_rules" ("promotion_rule_id", "product_id")CseGgindexindex_products_promotion_rules_on_product_idspree_product_promotion_rulesqCREATE INDEX "index_products_promotion_rules_on_product_id" ON "spree_product_promotion_rules" ("product_id")rrGGctablespree_product_promotion_rulesspree_product_promotion_ruleskCREATE TABLE "spree_product_promotion_rules" ("product_id" integer DEFAULT NULL, "promotion_rule_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)    l55]tablespree_refund_reasonsspree_refund_reasons.CREATE TABLE "spree_refund_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 't', "mutable" boolean DEFAULT 't', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)HjQQytablespree_return_authorization_reasonsspree_return_authorization_reasons,CREATE TABLE "spree_return_authorization_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 't', "mutable" boolean DEFAULT 't', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)  0p{hUB/ q^K8%zgTA.pE)20191113195902D)20191113195901C)20191113195900B)20191113195899A)20191113195898@)20191113195897?)20191113195896>)20191113195895=)20191113195894<)20191113195893;)20191113195892:)201911131958919)201911131958908)201911131958897)201911131958886)201911131958875)201911131958864)201911131958853)201911131958842)201911131958831)201911131958820)20191113195881/)20191113195880.)20191113195879-)20191113195878,)20191113195877+)20191113195876*)20191113195875))20191113195874()20191113195873')20191113195872&)20191113195871%)20191113195870$)20191113195869#)20191113195868")20191113195867!)20191113195866 )20191113195865)20191113195864)20191113195863)20191113195862)20191113195861)20191113195860)20191113195859)20191113195858)20191113195857)20191113195856)20191113195855  NEGR 7AAUnauthorized purchasett2019-11-13 19:57:42.3827022019-11-13 19:57:42.382702M-AAAccidental ordertt2019-11-13 19:57:42.3761292019-11-13 19:57:42.376129T;AANo longer needed/wantedtt2019-11-13 19:57:42.3730892019-11-13 19:57:42.373089WAAADifferent from descriptiontt2019-11-13 19:57:42.3695002019-11-13 19:57:42.369500\KAADifferent from what was orderedtt2019-11-13 19:57:42.3657132019-11-13 19:57:42.365713N/AADamaged/Defectivett2019-11-13 19:57:42.3605932019-11-13 19:57:42.360593YEAAMissing parts or accessoriestt2019-11-13 19:57:42.3544522019-11-13 19:57:42.354452[IAAMissed estimated delivery datett2019-11-13 19:57:42.3483482019-11-13 19:57:42.348348S9AABetter price availablett2019-11-13 19:57:42.3412282019-11-13 19:57:42.341228 GINGpAAtablespree_promotion_categoriesspree_promotion_categories0CREATE TABLE "spree_promotion_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "code" varchar)woC-indexindex_return_authorizations_on_return_authorization_reason_idspree_return_authorizationsCREATE INDEX "index_return_authorizations_on_return_authorization_reason_id" ON "spree_return_authorizations" ("return_authorization_reason_id")3nCCktablespree_return_authorizationsspree_return_authorizationsCREATE TABLE "spree_return_authorizations" ("id" integer NOT NULL PRIMARY KEY, "number" varchar DEFAULT NULL, "state" varchar DEFAULT NULL, "order_id" integer DEFAULT NULL, "memo" text DEFAULT NULL, "created_at" datetime DEFAULT NULL, "updated_at" datetime DEFAULT NULL, "stock_location_id" integer DEFAULT NULL, "return_authorization_reason_id" integer DEFAULT NULL) N/AAReturn processingtf2019-11-13 19:57:43.3853802019-11-13 19:57:43.385380    K//$Y5Eindexindex_spree_reimbursements_on_order_idspree_reimbursements?CREATE INDEX "index_spree_reimbursements_on_order_id" ON "spree_reimbursements" ("order_id")Bm5mindexindex_spree_reimbursements_on_customer_return_idspree_reimbursements>CREATE INDEX "index_spree_reimbursements_on_customer_return_id" ON "spree_reimbursements" ("customer_return_id")*y_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugs;CREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")eL~559tablespree_reimbursementsspree_reimbursementsCREATE TABLE "spree_payments" ("id" integer NOT NULL PRIMARY KEY, "amount" decimal(10,2) DEFAULT '0.0' NOT NULL, "order_id" integer DEFAULT NULL, "source_type" varchar DEFAULT NULL, "source_id" integer DEFAULT NULL, "payment_method_id" integer DEFAULT NULL, "state" varchar DEFAULT NULL, "response_code" varchar DEFAULT NULL, "avs_response" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "number" varchar DEFAULT NULL, "cvv_response_code" varchar DEFAULT NULL, "cvv_response_message" varchar DEFAULT NULL)  mdxUA%indexindex_spree_taxons_on_namespree_taxonsCREATE INDEX "index_spree_taxons_on_name" ON "spree_taxons" ("name")uT?%indexindex_spree_taxons_on_rgtspree_taxonsCREATE INDEX "index_spree_taxons_on_rgt" ON "spree_taxons" ("rgt")uS?%indexindex_spree_taxons_on_lftspree_taxonsCREATE INDEX "index_spree_taxons_on_lft" ON "spree_taxons" ("lft")RI%%indexindex_spree_taxons_on_positionspree_taxonsiCREATE INDEX "index_spree_taxons_on_position" ON "spree_taxons" ("position")QC%%indexindex_taxons_on_taxonomy_idspree_taxonshCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")gVI-3indexindex_spree_promotions_on_codespree_promotionsCREATE UNIQUE INDEX "index_spree_promotions_on_code" ON "spree_promotions" ("code") PUZY)Eindexindex_spree_p4niEE_tablespree_option_type_prototypesspree_option_type_prototypes3CREATE TABLE "spree_option_type_prototypes" ("prototype_id" integer DEFAULT NULL, "option_type_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)ZY)Eindexindex_spree_products_on_discontinue_onspree_productsWCREATE INDEX "index_spree_products_on_discontinue_on" ON "spree_products" ("discontinue_on"),W]9Mindexindex_spree_prototype_taxons_on_taxon_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_taxon_id" ON "spree_prototype_taxons" ("taxon_id") C.W/Aindexindex_spree_stock_items_on_variant_idspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_variant_id" ON "spree_stock_items" ("variant_id")4)a=Uindexindex_spree_store_credit_types_on_priorityspree_store_credit_typesYCREATE INDEX "index_spree_store_credit_types_on_priority" ON "spree_store_credit_types" ("priority")(==tablespree_store_credit_typesspree_store_credit_typesWCREATE TABLE "spree_store_credit_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "priority" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) m>m% [3Iindexindex_spree_store_credits_on_deleted_atspree_store_creditslCREATE INDEX "index_spree_store_credits_on_deleted_at" ON "spree_store_credits" ("deleted_at")$33mtablespree_store_creditsspree_store_creditsCREATE TABLE "spree_store_credits" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "category_id" integer, "created_by_id" integer, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "amount_used" decimal(8,2) DEFAULT 0.0 NOT NULL, "memo" text, "deleted_at" datetime, "currency" varchar, "amount_authorized" decimal(8,2) DEFAULT 0.0 NOT NULL, "originator_id" integer, "originator_type" varchar, "type_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)>o)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentsCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type") SFU-=indexindex_spree_line_items_on_variant_idspree_line_items,CREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")EQ-5indexindex_spree_line_items_on_order_idspree_line_items+CREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id"))G_-Qindexindex_spree_line_items_on_tax_category_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_tax_category_id" ON "spree_line_items" ("tax_category_id")  Urb?/indexindex_spree_adjustments_on_adjustable_id_and_adjustable_typespree_adjustments.CREATE INDEX "index_spree_adjustments_on_adjustable_id_and_adjustable_type" ON "spree_adjustments" ("adjustable_id", "adjustable_type")->// tablespree_adjustmentsspree_adjustmentsCREATE TABLE "spree_adjustments" ("id" integer NOT NULL PRIMARY KEY, "source_type" varchar DEFAULT NULL, "source_id" integer DEFAULT NULL, "adjustable_type" varchar DEFAULT NULL, "adjustable_id" integer DEFAULT NULL, "amount" decimal(10,2) DEFAULT NULL, "label" varchar DEFAULT NULL, "mandatory" boolean DEFAULT NULL, "eligible" boolean DEFAULT 't', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "state" varchar DEFAULT NULL, "order_id" integer NOT NULL, "included" boolean DEFAULT 'f')     y7:y=DeC]indexindex_spree_shipping_method_zones_on_zone_idspree_shipping_method_zonesCREATE INDEX "index_spree_shipping_method_zones_on_zone_id" ON "spree_shipping_method_zones" ("zone_id")yC M%indexindex_spree_shipping_method_categories_on_shipping_category_idspree_shipping_method_categoriesCREATE INDEX "index_spree_shipping_method_categories_on_shipping_category_id" ON "spree_shipping_method_categories" ("shipping_category_id")_B1indexindex_spree_return_items_on_override_reimbursement_type_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_override_reimbursement_type_id" ON "spree_return_items" ("override_reimbursement_type_id")bA1indexindex_spree_return_items_on_preferred_reimbursement_type_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_preferred_reimbursement_type_id" ON "spree_return_items" ("preferred_reimbursement_type_id")   ssG%AANon-expiring2019-11-13 19:57:53.5509832019-11-13 19:57:53.550983B AAExpiring2019-11-13 19:57:53.5473682019-11-13 19:57:53.547368 Z$v$|2N%%'tablespree_taxonsspree_taxonseCREATE TABLE "spree_taxons" ("id" integer NOT NULL PRIMARY KEY, "parent_id" integer DEFAULT NULL, "position" integer DEFAULT 0, "name" varchar NOT NULL, "permalink" varchar DEFAULT NULL, "taxonomy_id" integer DEFAULT NULL, "lft" integer DEFAULT NULL, "rgt" integer DEFAULT NULL, "description" text DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "meta_title" varchar DEFAULT NULL, "meta_description" varchar DEFAULT NULL, "meta_keywords" varchar DEFAULT NULL, "depth" integer DEFAULT NULL)"zP?%indexindex_taxons_on_permalinkspree_taxonsgCREATE INDEX "index_taxons_on_permalink" ON "spree_taxons" ("permalink")zO?%indexindex_taxons_on_parent_idspree_taxonsfCREATE INDEX "index_taxons_on_parent_id" ON "spree_taxons" ("parent_id")MI)%indexindex_spree_trackers_on_activespree_trackersCREATE INDEX "index_spree_trackers_on_active" ON "spree_trackers" ("active")  ?{^V9indexindex_spree_prototype_taxons_on_prototype_id_and_taxon_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_prototype_id_and_taxon_id" ON "spree_prototype_taxons" ("prototype_id", "taxon_id")@UgCaindexindex_spree_promotion_rule_taxons_on_taxon_idspree_promotion_rule_taxonsCREATE INDEX "index_spree_promotion_rule_taxons_on_taxon_id" ON "spree_promotion_rule_taxons" ("taxon_id")[TyCindexindex_spree_promotion_rule_taxons_on_promotion_rule_idspree_promotion_rule_taxonsCREATE INDEX "index_spree_promotion_rule_taxons_on_promotion_rule_id" ON "spree_promotion_rule_taxons" ("promotion_rule_id") LHHHOW/Aindexindex_spree_calculators_on_deleted_atspree_calculatorsCREATE INDEX "index_spree_calculators_on_deleted_at" ON "spree_calculators" ("deleted_at")0Na7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")DEFAULT NULL, "email" varchar DEFAULT NULL, "special_instructions" text DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "currency" varchar DEFAULT NULL, "last_ip_address" varchar DEFAULT NULL, "created_by_id" integer DEFAULT NULL, "shipment_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "additional_tax_total" decimal(10,2) DEFAULT '0.0', "promo_total" decimal(10,2) DEFAULT '0.0', "channel" varchar DEFAULT 'spree', "included_tax_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "item_count" integer DEFAULT 0, "approver_id" integer DEFAULT NULL, "approved_at" datetime DEFAULT NULL, "confirmation_delivered" boolean DEFAULT 'f', "considered_risky" boolean DEFAULT 'f', "token" varchar DEFAULT NULL, "canceled_at" datetime DEFAULT NULL, "canceler_id" integer DEFAULT NULL, "store_id" integer DEFAULT NULL, "state_lock_version" integer DEFAULT 0 NOT NULL, "taxable_adjustment_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "non_taxable_adjustment_total" decimal(10,2) DEFAULT '0.0' NOT NULL) DM`DL))ktablespree_trackersspree_trackersmCREATE TABLE "spree_trackers" ("id" integer NOT NULL PRIMARY KEY, "analytics_id" varchar DEFAULT NULL, "active" boolean DEFAULT 't', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "engine" integer DEFAULT 0 NOT NULL)iK/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugs:CREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")DJq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugs/CREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")gI7indexindex_stock_movements_on_originator_id_and_originator_typespree_stock_movementsCREATE INDEX "index_stock_movements_on_originator_id_and_originator_type" ON "spree_stock_movements" ("originator_id", "originator_type") 4HH++Gtablespree_shipmentsspree_shipments-CREATE TABLE "spree_shipments" ("id" integer NOT NULL PRIMARY KEY, "tracking" varchar DEFAULT NULL, "number" varchar DEFAULT NULL, "cost" decimal(10,2) DEFAULT '0.0', "shipped_at" datetime DEFAULT NULL, "order_id" integer DEFAULT NULL, "address_id" integer DEFAULT NULL, "state" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "stock_location_id" integer DEFAULT NULL, "adjustment_total" decimal(10,2) DEFAULT '0.0', "additional_tax_total" decimal(10,2) DEFAULT '0.0', "promo_total" decimal(10,2) DEFAULT '0.0', "included_tax_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "pre_tax_amount" decimal(12,4) DEFAULT 0.0 NOT NULL, "taxable_adjustment_total" decimal(10,2) DEFAULT 0.0 NOT NULL, "non_taxable_adjustment_total" decimal(10,2) DEFAULT 0.0 NOT NULL) ,R,p]9Mindexindex_spree_order_promotions_on_order_idspree_order_promotionsCREATE INDEX "index_spree_order_promotions_on_order_id" ON "spree_order_promotions" ("order_id")Vo99Gtablespree_order_promotionsspree_order_promotions8CREATE TABLE "spree_order_promotions" ("order_id" integer DEFAULT NULL, "promotion_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)UnuC}indexindex_spree_option_value_variants_on_option_value_idspree_option_value_variantsCREATE INDEX "index_spree_option_value_variants_on_option_value_id" ON "spree_option_value_variants" ("option_value_id")^q9indexindex_spree_order_promotions_on_promotion_id_and_order_idspree_order_promotionsCREATE INDEX "index_spree_order_promotions_on_promotion_id_and_order_id" ON "spree_order_promotions" ("promotion_id", "order_id") 5m$5kM77utablespree_payment_methodsspree_payment_methodsz--/tablespree_role_usersspree_role_usersVCREATE TABLE "spree_role_users" ("role_id" integer DEFAULT NULL, "user_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)[~I%%indexindex_spree_assets_on_positionspree_assetsCREATE INDEX "index_spree_assets_on_position" ON "spree_assets" ("position") Dl,[?Iindexindex_spree_shipping_categories_on_namespree_shipping_categorieshCREATE INDEX "index_spree_shipping_categories_on_name" ON "spree_shipping_categories" ("name")GwI-%indexindex_spree_properties_on_namespree_propertiesfCREATE INDEX "index_spree_properties_on_name" ON "spree_properties" ("name")O31indexindex_spree_option_values_on_namespree_option_valuesCREATE INDEX "index_spree_option_values_on_name" ON "spree_option_values" ("name")M1-indexindex_spree_option_types_on_namespree_option_typesCREATE INDEX "index_spree_option_types_on_name" ON "spree_option_types" ("name") " YO%1indexindex_spree_orders_on_approver_idspree_ordersCREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id")XQ%5indexindex_spree_orders_on_completed_atspree_ordersCREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")>W%%?tablespree_ordersspree_orders9CREATE TABLE "spree_orders" ("id" integer NOT NULL PRIMARY KEY, "number" varchar(32) DEFAULT NULL, "item_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "total" decimal(10,2) DEFAULT '0.0' NOT NULL, "state" varchar DEFAULT NULL, "adjustment_total" decimal(10,2) DEFAULT '0.0' NOT NULL, "user_id" integer DEFAULT NULL, "completed_at" datetime DEFAULT NULL, "bill_address_id" integer DEFAULT NULL, "ship_address_id" integer DEFAULT NULL, "payment_total" decimal(10,2) DEFAULT '0.0', "shipment_state" varchar DEFAULT NULL, "payment_state" varchar \     Default ?]IBGm5mindexindex_spree_shipping_rates_on_shipping_method_idspree_shipping_ratesCREATE INDEX "index_spree_shipping_rates_on_shipping_method_id" ON "spree_shipping_rates" ("shipping_method_id")-F_5Qindexindex_spree_shipping_rates_on_shipment_idspree_shipping_ratesCREATE INDEX "index_spree_shipping_rates_on_shipment_id" ON "spree_shipping_rates" ("shipment_id")^E{C indexindex_spree_shipping_method_zones_on_shipping_method_idspree_shipping_method_zonesCREATE INDEX "index_spree_shipping_method_zones_on_shipping_method_id" ON "spree_shipping_method_zones" ("shipping_method_id") 3He/]indexindex_spree_stock_items_on_stock_location_idspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_stock_location_id" ON "spree_stock_items" ("stock_location_id") cz#^W%Aindexindex_spree_orders_on_ship_address_idspree_ordersCREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")]S%9indexindex_spree_orders_on_created_by_idspree_ordersCREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id")\Y%Eindexindex_spree_orders_on_considered_riskyspree_ordersCREATE INDEX "index_spree_orders_on_considered_risky" ON "spree_orders" ("considered_risky").[e%]indexindex_spree_orders_on_confirmation_deliveredspree_ordersCREATE INDEX "index_spree_orders_on_confirmation_delivered" ON "spree_orders" ("confirmation_delivered")ZW%Aindexindex_spree_orders_on_bill_address_idspree_ordersCREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id") a11ktablespree_return_itemsspree_return_items+CREATE TABLE "spree_return_items" ("id" integer NOT NULL PRIMARY KEY, "return_authorization_id" integer DEFAULT NULL, "inventory_unit_id" integer DEFAULT NULL, "exchange_variant_id" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "pre_tax_amount" decimal(12,4) DEFAULT '0.0' NOT NULL, "included_tax_total" decimal(12,4) DEFAULT '0.0' NOT NULL, "additional_tax_total" decimal(12,4) DEFAULT '0.0' NOT NULL, "reception_status" varchar DEFAULT NULL, "acceptance_status" varchar DEFAULT NULL, "customer_return_id" integer DEFAULT NULL, "reimbursement_id" integer DEFAULT NULL, "acceptance_status_errors" text DEFAULT NULL, "preferred_reimbursement_type_id" integer DEFAULT NULL, "override_reimbursement_type_id" integer DEFAULT NULL, "resellable" boolean DEFAULT 't' NOT NULL) ||fcE%+indexindex_spree_orders_on_numberspree_ordersCREATE UNIQUE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")bI%%indexindex_spree_orders_on_store_idspree_ordersCREATE INDEX "index_spree_orders_on_store_id" ON "spree_orders" ("store_id") aO%1indexindex_spree_orders_on_canceler_idspree_ordersCREATE INDEX "index_spree_orders_on_canceler_id" ON "spree_orders" ("canceler_id")6_k%gindexindex_spree_orders_on_user_id_and_created_by_idspree_ordersCREATE INDEX "index_spree_orders_on_user_id_and_created_by_id" ON "spree_orders" ("user_id", "created_by_id"){dC%indexindex_spree_orders_on_tokenspree_orders8CREATE INDEX "index_spree_orders_on_token" ON "spree_orders" ("token")     .hp\H4  lXD0|ht`L8$)20191113195958)20191113195957)20191113195956)20191113195955)20191113195954)20191113195953)20191113195952)20191113195951)20191113195950)20191113195949)20191113195948)20191113195947)20191113195946)20191113195945)20191113195944)20191113195943)20191113195942)20191113195941)20191113195940)20191113195939)20191113195938)20191113195937)20191113195936)20191113195935)20191113195934)20191113195933)20191113195932)20191113195931)20191113195930)20191113195929)20191113195928)20191113195973 )20191113195972 )20191113195971 )20191113195970 )20191113195969)20191113195968)20191113195967)20191113195966)20191113195965)20191113195964)20191113195963)20191113195962)20191113195961)20191113195960)20191113195959  /N//A#cCgindexindex_spree_return_authorizations_on_numberspree_return_authorizations|CREATE UNIQUE INDEX "index_spree_return_authorizations_on_number" ON "spree_return_authorizations" ("number") "I)3indexindex_spree_payments_on_numberspree_payments!CREATE UNIQUE INDEX "index_spree_payments_on_number" ON "spree_payments" ("number")!K+7indexindex_spree_shipments_on_numberspree_shipmentsYCREATE UNIQUE INDEX "index_spree_shipments_on_number" ON "spree_shipments" ("number")) W7Oindexindex_spree_stock_transfers_on_numberspree_stock_transfersCREATE UNIQUE INDEX "index_spree_stock_transfers_on_number" ON "spree_stock_transfers" ("number").]1Yindexindex_return_items_on_customer_return_idspree_return_items5CREATE INDEX "index_return_items_on_customer_return_id" ON "spree_return_items" ("customer_return_id")           "O|"3)[?Windexindex_spree_reimbursement_types_on_namespree_reimbursement_typesCREATE UNIQUE INDEX "index_spree_reimbursement_types_on_name" ON "spree_reimbursement_types" ("name")(Q5Cindexindex_spree_refund_reasons_on_namespree_refund_reasonsCREATE UNIQUE INDEX "index_spree_refund_reasons_on_name" ON "spree_refund_reasons" ("name")'O+?indexindex_spree_countries_on_iso_namespree_countriesCREATE UNIQUE INDEX "index_spree_countries_on_iso_name" ON "spree_countries" ("iso_name") &G+/indexindex_spree_countries_on_namespree_countriesCREATE UNIQUE INDEX "index_spree_countries_on_name" ON "spree_countries" ("name")%%U5Kindexindex_spree_reimbursements_on_numberspree_reimbursementsCREATE UNIQUE INDEX "index_spree_reimbursements_on_number" ON "spree_reimbursements" ("number")-$Y9Sindexindex_spree_customer_returns_on_numberspree_customer_returns}CREATE UNIQUE INDEX "index_spree_customer_returns_on_number" ON "spree_customer_returns" ("number")    / Return processing   original xU47Unauthorized purchase ;No longer needed/wanted EMissing parts or accessories"IMissed estimated delivery date#KDifferent from what was orderedADifferent from description/Damaged/Defective9 Better price available-Accidental order b%%Zbt.}E3indexspree_option_type_prototypes_prototype_id_option_type_idspree_option_type_prototypes5CREATE UNIQUE INDEX "spree_option_type_prototypes_prototype_id_option_type_id" ON "spree_option_type_prototypes" ("prototype_id", "option_type_id")G-o9qindexindex_spree_customer_returns_on_stock_location_idspree_customer_returnsCREATE INDEX "index_spree_customer_returns_on_stock_location_id" ON "spree_customer_returns" ("stock_location_id"),A%#indexindex_spree_stores_on_codespree_storesCREATE UNIQUE INDEX "index_spree_stores_on_code" ON "spree_stores" ("code"){+?#indexindex_spree_roles_on_namespree_rolesgCREATE UNIQUE INDEX "index_spree_roles_on_name" ON "spree_roles" ("name")W*mQ{indexindex_spree_return_authorization_reasons_on_namespree_return_authorization_reasonsCREATE UNIQUE INDEX "index_spree_return_authorization_reasons_on_name" ON "spree_return_authorization_reasons" ("name")   h42hDF1kCiindexindex_spree_option_value_variants_on_variant_idspree_option_value_variantsCREATE INDEX "index_spree_option_value_variants_on_variant_id" ON "spree_option_value_variants" ("variant_id")~0 C;indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_value_variants7CREATE UNIQUE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_value_variants" ("variant_id", "option_value_id")P/qEuindexindex_spree_option_type_prototypes_on_prototype_idspree_option_type_prototypesCREATE INDEX "index_spree_option_type_prototypes_on_prototype_id" ON "spree_option_type_prototypes" ("prototype_id")<82e9]indexindex_spree_order_promotions_on_promotion_idspree_order_promotionsCREATE INDEX "index_spree_order_promotions_on_promotion_id" ON "spree_order_promotions" ("promotion_id") K{hUB/ q^K )20191113195973 )20191113195972 )20191113195971 )20191113195970)20191113195969)20191113195968)20191113195967)20191113195966)20191113195965)20191113195964)20191113195963)20191113195962)20191113195961)20191113195960~)20191113195959})20191113195958|)20191113195957{)20191113195956z)20191113195955y)20191113195954x)20191113195953w)20191113195952v)20191113195951   3RD37O'1indexindex_spree_refunds_on_payment_idspree_refundsCREATE INDEX "index_spree_refunds_on_payment_id" ON "spree_refunds" ("payment_id")A5i?eindexindex_spree_property_prototypes_on_property_idspree_property_prototypesCREATE INDEX "index_spree_property_prototypes_on_property_id" ON "spree_property_prototypes" ("property_id")D4k?iindexindex_spree_property_prototypes_on_prototype_idspree_property_prototypesCREATE INDEX "index_spree_property_prototypes_on_prototype_id" ON "spree_property_prototypes" ("prototype_id")n3?)indexindex_property_prototypes_on_prototype_id_and_property_idspree_property_prototypesCREATE UNIQUE INDEX "index_property_prototypes_on_prototype_id_and_property_id" ON "spree_property_prototypes" ("prototype_id", "property_id")86e9]indexindex_spree_prototype_taxons_on_prototype_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_prototype_id" ON "spree_prototype_taxons" ("prototype_id")      F2F<h:wC!indexindex_reimbursement_credits_on_creditable_id_and_typespree_reimbursement_creditsCREATE INDEX "index_reimbursement_credits_on_creditable_id_and_type" ON "spree_reimbursement_credits" ("creditable_id", "creditable_type")X9wCindexindex_spree_reimbursement_credits_on_reimbursement_idspree_reimbursement_creditsCREATE INDEX "index_spree_reimbursement_credits_on_reimbursement_id" ON "spree_reimbursement_credits" ("reimbursement_id") 8['Iindexindex_spree_refunds_on_reimbursement_idspree_refundsCREATE INDEX "index_spree_refunds_on_reimbursement_id" ON "spree_refunds" ("reimbursement_id")@;gCaindexindex_spree_return_authorizations_on_order_idspree_return_authorizationsCREATE INDEX "index_spree_return_authorizations_on_order_id" ON "spree_return_authorizations" ("order_id")     ?]H=@k1iindexindex_spree_return_items_on_exchange_variant_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_exchange_variant_id" ON "spree_return_items" ("exchange_variant_id")7>g1aindexindex_spree_return_items_on_inventory_unit_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_inventory_unit_id" ON "spree_return_items" ("inventory_unit_id")I=s1yindexindex_spree_return_items_on_return_authorization_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_return_authorization_id" ON "spree_return_items" ("return_authorization_id")[<yCindexindex_spree_return_authorizations_on_stock_location_idspree_return_authorizationsCREATE INDEX "index_spree_return_authorizations_on_stock_location_id" ON "spree_return_authorizations" ("stock_location_id") 4?e1]indexindex_spree_return_items_on_reimbursement_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_reimbursement_id" ON "spree_return_items" ("reimbursement_id")      YY"iY1Eindexindex_spree_credit_cards_on_deleted_atspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_deleted_at" ON "spree_credit_cards" ("deleted_at") hM%-indexindex_spree_prices_on_variant_idspree_prices%CREATE INDEX "index_spree_prices_on_variant_id" ON "spree_prices" ("variant_id") gM%-indexindex_spree_prices_on_deleted_atspree_pricesCREATE INDEX "index_spree_prices_on_deleted_at" ON "spree_prices" ("deleted_at")0fg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")-e%%tablespree_pricesspree_pricesJCREATE TABLE "spree_prices" ("id" integer NOT NULL PRIMARY KEY, "variant_id" integer NOT NULL, "amount" decimal(10,2) DEFAULT NULL, "currency" varchar DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)