SQLite format 3@ }i}.0:Xd|vpjd^XVpE`4S A veE6ԃ yeE*lzYlF0XJZ5>-H )20190729091748c    4444444444444444            qC) \ E6q   *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")6 ++#tablespree_addressesspree_addresses CREATE 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)c cA/indexindex_active_storage_attachments_uniquenessactive_storage_attachments CREATE 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_attachments CREATE INDEX "index_active_storage_attachments_on_blob_id" ON "active_storage_attachments" ("blob_id")AA5tableactive_storage_attachmentsactive_storage_attachments CREATE 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") )O5?indexindex_active_storage_blobs_on_keyactive_storage_blobsCREATE UNIQUE INDEX "index_active_storage_blobs_on_key" ON "active_storage_blobs" ("key")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)B55'tableactive_storage_blobsactive_storage_blobsCREATE 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)N55?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)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/indexsqlite_autoindex_schema_migrations_1schema_migrations  <} b< 6 6 6tt #%33mtablespree_option_valuesspree_option_values)CREATE 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)##11qtablespree_option_typesspree_option_types'CREATE 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) %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) ! !))Ytablespree_gatewaysspree_gatewaysCREATE TABLE "spree_gateways" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "name" varchar, "description" text, "active" boolean DEFAULT 1, "environment" varchar DEFAULT 'development', "server" varchar DEFAULT 'test', "test_mode" boolean DEFAULT 1, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "preferences" text)!//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) 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")                                1E = x 111111111111" >##Etablespree_rolesspree_rolesCCREATE TABLE "spree_roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar)ZT<--[tablespree_prototypesspree_prototypesACREATE 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_properties?CREATE 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) (80==tablespree_product_propertiesspree_product_properties4CREATE 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)-1Y=Qindexindex_product_properties_on_product_idspree_product_properties6CREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id")n&/AAWtablespree_product_option_typesspree_product_option_types3CREATE 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)                      : h  S:] LBH55'tablespree_tax_categoriesspree_tax_categoriesNCREATE TABLE "spree_tax_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" varchar, "is_default" boolean DEFAULT 0, "deleted_at" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "tax_code" varchar) "5V##1tablespree_zonesspree_zones]CREATE TABLE "spree_zones" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "description" varchar, "default_tax" boolean DEFAULT 0, "zone_members_count" integer DEFAULT 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "kind" varchar) U11Etablespree_zone_membersspree_zone_members\CREATE 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){J--)tablespree_taxonomiesspree_taxonomiesPCREATE 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)|I++/tablespree_tax_ratesspree_tax_ratesOCREATE 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 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "name" varchar, "show_rate_in_label" boolean DEFAULT 1, "deleted_at" datetime)Z*ZOOwtablespree_promotion_action_line_itemsspree_promotion_action_line_itemsaCREATE TABLE "spree_promotion_action_line_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_action_id" integer, "variant_id" integer, "quantity" integer DEFAULT 1)?G%%Atablespree_statesspree_statesMCREATE TABLE "spree_states" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "abbr" varchar, "country_id" integer, "updated_at" datetime)PF33Gtablespree_state_changesspree_state_changesLCREATE 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)oD??mtablespree_shipping_categoriesspree_shipping_categoriesICREATE 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)              h v p999g..=@ 6e7]indexindex_spree_stock_movements_on_stock_item_idspree_stock_movements{CREATE INDEX "index_spree_stock_movements_on_stock_item_id" ON "spree_stock_movements" ("stock_item_id")v77 tablespree_stock_movementsspree_stock_movementsyCREATE TABLE "spree_stock_movements" ("id" integer NOT NULL PRIMARY KEY, "stock_item_id" integer DEFAULT NULL, "quantity" integer DEFAULT 0, "action" varchar DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "originator_type" varchar DEFAULT NULL, "originator_id" integer DEFAULT NULL) 99?tablespree_shipping_methodsspree_shipping_methodsKCREATE 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)rMindexindex_spree_shipping_method_categories_on_shipping_method_idspree_shipping_method_categoriesuCREATE INDEX "index_spree_shipping_method_categories_on_shipping_method_id" ON "spree_shipping_method_categories" ("shipping_method_id")DMM{tablespree_shipping_method_categoriesspree_shipping_method_categoriestCREATE 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)'u[7Iindexindex_spree_products_taxons_on_taxon_idspree_products_taxons>CREATE INDEX "index_spree_products_taxons_on_taxon_id" ON "spree_products_taxons" ("taxon_id")-t_7Qindexindex_spree_products_taxons_on_product_idspree_products_taxons=CREATE INDEX "index_spree_products_taxons_on_product_id" ON "spree_products_taxons" ("product_id")es77itablespree_products_taxonsspree_products_taxons  G 4aaa>>>CC?tablespree_reimbursement_creditsspree_reimbursement_creditsCREATE TABLE "spree_reimbursement_credits" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10,2) DEFAULT 0.0 NOT NULL, "reimbursement_id" integer, "creditable_id" integer, "creditable_type" varchar)9??tablespree_reimbursement_typesspree_reimbursement_typesCREATE TABLE "spree_reimbursement_types" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 1, "mutable" boolean DEFAULT 1, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "type" varchar) #t ?#indexindex_spree_zones_on_kindspree_zonesCREATE INDEX "index_spree_zones_on_kind" ON "spree_zones" ("kind")k~''tablespree_refundsspree_refundsqCREATE 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)$}Y5Eindexindex_spree_reimbursements_on_order_idspree_reimbursementsCREATE INDEX "index_spree_reimbursements_on_order_id" ON "spree_reimbursements" ("order_id")B|m5mindexindex_spree_reimbursements_on_customer_return_idspree_reimbursementsCREATE INDEX "index_spree_reimbursements_on_customer_return_id" ON "spree_reimbursements" ("customer_return_id")L{559tablespree_reimbursementsspree_reimbursementsCREATE TABLE "spree_reimbursements" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar, "reimbursement_status" varchar, "customer_return_id" integer, "order_id" integer, "total" decimal(10,2), "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL) /,[?Iindexindex_spree_reimbursement_types_on_typespree_reimbursement_typesCREATE INDEX "index_spree_reimbursement_types_on_type" ON "spree_reimbursement_types" ("type")RO'=indexindex_refunds_on_refund_reason_idspree_refundsCREATE INDEX "index_refunds_on_refund_reason_id" ON "spree_refunds" ("refund_reason_id")                    L  X^L m#@RgCaindexindex_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")[QyCindexindex_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")1WY)Eindexindex_spree_products_on_discontinue_onspree_productsECREATE INDEX "index_spree_products_on_discontinue_on" ON "spree_products" ("discontinue_on") ,T]9Mindexindex_spree_prototype_taxons_on_taxon_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_taxon_id" ON "spree_prototype_taxons" ("taxon_id")0Ka7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")iJ77qtablespree_payment_methodsspree_payment_methods/CREATE TABLE "spree_payment_methods" ("id" integer NOT NULL PRIMARY KEY, "type" varchar DEFAULT NULL, "name" varchar DEFAULT NULL, "description" text DEFAULT NULL, "active" boolean DEFAULT 1, "deleted_at" datetime DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "display_on" varchar DEFAULT 'both', "auto_capture" boolean DEFAULT NULL, "preferences" text DEFAULT NULL, "position" integer DEFAULT 0)IS+9indexindex_spree_shipments_on_address_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_address_id" ON "spree_shipments" ("address_id")+Ha+Uindexindex_spree_shipments_on_stock_location_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_stock_location_id" ON "spree_shipments" ("stock_location_id")GO+1indexindex_spree_shipments_on_order_idspree_shipmentsrCREATE INDEX "index_spree_shipments_on_order_id" ON "spree_shipments" ("order_id") ^S9indexindex_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")bLW/Aindexindex_spree_calculators_on_deleted_atspree_calculatorsCREATE INDEX "index_spree_calculators_on_deleted_at" ON "spree_calculators" ("deleted_at")                    00 SX00000000V.V$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")&_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsvCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id") M)-indexindex_spree_payments_on_order_idspree_paymentskCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")O))Ytablespree_paymentsspree_payments0CREATE 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)E)+indexindex_spree_products_on_slugspree_productsUCREATE UNIQUE INDEX "index_spree_products_on_slug" ON "spree_products" ("slug")=99tablespree_prototype_taxonsspree_prototype_taxonsCREATE TABLE "spree_prototype_taxons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "taxon_id" integer, "prototype_id" integer)v         \V g g 0\\\jjjoj||+W/Aindexindex_spree_stock_items_on_variant_idspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_variant_id" ON "spree_stock_items" ("variant_id")34&a=Uindexindex_spree_store_credit_types_on_priorityspree_store_credit_typesCREATE INDEX "index_spree_store_credit_types_on_priority" ON "spree_store_credit_types" ("priority")%==tablespree_store_credit_typesspree_store_credit_typesCREATE 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)B$U?{indexspree_store_credit_events_originatorspree_store_credit_eventsCREATE INDEX "spree_store_credit_events_originator" ON "spree_store_credit_events" ("originator_id", "originator_type")M#q?uindexindex_spree_store_credit_events_on_store_credit_idspree_store_credit_eventsCREATE INDEX "index_spree_store_credit_events_on_store_credit_id" ON "spree_store_credit_events" ("store_credit_id")_"??Ktablespree_store_credit_eventsspree_store_credit_eventsCREATE TABLE "spree_store_credit_events" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "store_credit_id" integer NOT NULL, "action" varchar NOT NULL, "amount" decimal(8,2), "authorization_code" varchar NOT NULL, "user_total_amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "originator_id" integer, "originator_type" varchar, "deleted_at" datetime, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)|!GGutablespree_store_credit_categoriesspree_store_credit_categories CREATE 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_credits CREATE INDEX "spree_store_credits_originator" ON "spree_store_credits" ("originator_id", "originator_type")U3=indexindex_spree_store_credits_on_type_idspree_store_credits CREATE INDEX "index_spree_store_credits_on_type_id" ON "spree_store_credits" ("type_id")U3=indexindex_spree_store_credits_on_user_idspree_store_creditsVCREATE INDEX "index_spree_store_credits_on_user_id" ON "spree_store_credits" ("user_id")&[3Iindexindex_spree_store_credits_on_deleted_atspree_store_creditsCREATE INDEX "index_spree_store_credits_on_deleted_at" ON "spree_store_credits" ("deleted_at")     [ R$B + Tb T!HE++Gtablespree_shipmentsspree_shipmentsGCREATE 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))D_-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")CU-=indexindex_spree_line_items_on_variant_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")BQ-5indexindex_spree_line_items_on_order_idspree_line_items"CREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")*A--tablespree_line_itemsspree_line_items!CREATE TABLE "spree_line_items" ("id" integer NOT NULL PRIMARY KEY, "variant_id" integer DEFAULT NULL, "order_id" integer DEFAULT NULL, "quantity" integer NOT NULL, "price" decimal(10,2) NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "currency" varchar DEFAULT NULL, "cost_price" decimal(10,2) DEFAULT NULL, "tax_category_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)@W/Aindexindex_friendly_id_slugs_on_deleted_atfriendly_id_slugs~CREATE INDEX "index_friendly_id_slugs_on_deleted_at" ON "friendly_id_slugs" ("deleted_at")I?u/{indexindex_spree_adjustments_on_source_id_and_source_typespree_adjustmentsnCREATE INDEX "index_spree_adjustments_on_source_id_and_source_type" ON "spree_adjustments" ("source_id", "source_type")>S/9indexindex_spree_adjustments_on_order_idspree_adjustmentsiCREATE INDEX "index_spree_adjustments_on_order_id" ON "spree_adjustments" ("order_id")=S/9indexindex_spree_adjustments_on_eligiblespree_adjustments`CREATE INDEX "index_spree_adjustments_on_eligible" ON "spree_adjustments" ("eligible")b</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 1, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "state" varchar DEFAULT NULL, "order_id" integer NOT NULL, "included" boolean DEFAULT 0) b|iVC0 r_L9& { h U B /  q ^ K 8 %  z g T A .   p ] J 7 $  y f S @ -  o\I6#xeR?,lXD0|hT@,xdP<(t`L8$p\H4  ')20190729091747b)20190729091746a)20190729091745`)20190729091744_)20190729091743^)20190729091742])20190729091741\)20190729091740[)20190729091739Z)20190729091738Y)20190729091737X)20190729091736W)20190729091735V)20190729091734U)20190729091733T)20190729091732S)20190729091731R)20190729091730Q)20190729091729P)20190729091728O)20190729091727N)20190729091726M)20190729091725L)20190729091724K)20190729091723J)20190729091722I)20190729091721H)20190729091720G)20190729091719F)20190729091718E)20190729091717D)20190729091716C)20190729091715B)20190729091714A)20190729091713@)20190729091712?)20190729091711>)20190729091710=)20190729091709<)20190729091708;)20190729091707:)201907290917069)201907290917058)201907290917047)201907290917036)201907290917025)201907290917014)201907290917003)201907290916992)201907290916981)201907290916970)20190729091696/)20190729091695.)20190729091694-)20190729091693,)20190729091692+)20190729091691*)20190729091690))20190729091689()20190729091688')20190729091687&)20190729091686%)20190729091685$)20190729091684#)20190729091683")20190729091682!)20190729091681 )20190729091680)20190729091679)20190729091678)20190729091677)20190729091676)20190729091675)20190729091674)20190729091673)20190729091672)20190729091671)20190729091670)20190729091669)20190729091668)20190729091667)20190729091666)20190729091665)20190729091664)20190729091663)20190729091662 )20190729091661 )20190729091660 )20190729091659 )20190729091658 )20190729091657)20190729091656)20190729091655)20190729091654)20190729091653)20190729091652)20190729091651) 20190729091650 {hUB/ q^K8% t ` L 8 $  p \ H 4 l X D 0   | h T @ ,   x d P < (  t`L8$p\H4  lXD0|hT@,xdP<(t`L8$p\H4  )20190729091931)20190729091930)20190729091929)20190729091928)20190729091927)20190729091926)20190729091925)20190729091924)20190729091923)20190729091922)20190729091921)20190729091920)20190729091919)20190729091918 )20190729091917 )20190729091916 )20190729091915 )20190729091914 )20190729091913)20190729091912)20190729091911)20190729091910)20190729091909)20190729091908)20190729091907)20190729091906)20190729091905)20190729091904)20190729091903)20190729091902)20190729091901)20190729091900)20190729091899)20190729091898)20190729091897)20190729091896)20190729091895)20190729091894)20190729091893)20190729091892)20190729091891)20190729091890)20190729091889)20190729091888)20190729091887)20190729091886)20190729091885)20190729091884)20190729091883)20190729091882)20190729091881)20190729091880)20190729091879)20190729091878)20190729091877)20190729091876)20190729091875)20190729091874)20190729091873)20190729091872)20190729091871)20190729091870)20190729091869)20190729091868)20190729091867)20190729091866)20190729091865)20190729091864)20190729091863)20190729091862)20190729091861)20190729091860)20190729091859)20190729091858)20190729091857)20190729091856)20190729091855)20190729091854)20190729091853)20190729091852)20190729091851)20190729091850)20190729091849)20190729091848)20190729091847)20190729091846)20190729091845)20190729091844)20190729091843)20190729091842)20190729091841)20190729091840)20190729091839)20190729091838)20190729091837)20190729091836)20190729091835)20190729091834)20190729091833)20190729091832)20190729091831)20190729091830)20190729091829)20190729091828)20190729091827)20190729091826)20190729091825)20190729091824)20190729091823)20190729091822)20190729091821)20190729091820)20190729091819)20190729091818)20190729091817)20190729091816)20190729091815)20190729091814)20190729091813)20190729091812)20190729091811)20190729091810)20190729091809)20190729091808)20190729091807)20190729091806)20190729091805)20190729091804)20190729091803)20190729091802)20190729091801)20190729091800)20190729091799)20190729091798)20190729091797)20190729091796)20190729091795)20190729091794)20190729091793)20190729091792)20190729091791)20190729091790)20190729091789)20190729091788)20190729091787)20190729091786)20190729091785)20190729091784)20190729091783)20190729091782)20190729091781)20190729091780)20190729091779)20190729091778)20190729091777)20190729091776)20190729091775~)20190729091774})20190729091773|)20190729091772{)20190729091771z)20190729091770y)20190729091769x)20190729091768w)20190729091767v)20190729091766u)20190729091765t)20190729091764s)20190729091763r)20190729091762q)20190729091761p)20190729091760o)20190729091759n)20190729091758m)20190729091757l)20190729091756k)20190729091755j)20190729091754i)20190729091753h)20190729091752g)20190729091751f)20190729091750e)20190729091749d &8 _ 68N~  nfEE_tablespree_option_type_prototypesspree_option_type_prototypes(CREATE TABLE "spree_option_type_prototypes" ("prototype_id" integer DEFAULT NULL, "option_type_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)bu??Stablespree_property_prototypesspree_property_prototypes@CREATE TABLE "spree_property_prototypes" ("prototype_id" integer DEFAULT NULL, "property_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)ptA%indexindex_promotion_rules_users_on_user_id_and_promotion_rule_idspree_promotion_rule_usershCREATE INDEX "index_promotion_rules_users_on_user_id_and_promotion_rule_id" ON "spree_promotion_rule_users" ("user_id", "promotion_rule_id")LsmAwindexindex_promotion_rules_users_on_promotion_rule_idspree_promotion_rule_usersfCREATE INDEX "index_promotion_rules_users_on_promotion_rule_id" ON "spree_promotion_rule_users" ("promotion_rule_id")frAAWtablespree_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)zqG1indexindex_products_promotion_rules_on_promotion_rule_and_productspree_product_promotion_rulesCREATE INDEX "index_products_promotion_rules_on_promotion_rule_and_product" ON "spree_product_promotion_rules" ("promotion_rule_id", "product_id")CpeGgindexindex_products_promotion_rules_on_product_idspree_product_promotion_rules_CREATE INDEX "index_products_promotion_rules_on_product_id" ON "spree_product_promotion_rules" ("product_id")roGGctablespree_product_promotion_rulesspree_product_promotion_rules^CREATE TABLE "spree_product_promotion_rules" ("product_id" integer DEFAULT NULL, "promotion_rule_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)^n9indexindex_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"),m]9Mindexindex_spree_order_promotions_on_order_idspree_order_promotionsCREATE INDEX "index_spree_order_promotions_on_order_id" ON "spree_order_promotions" ("order_id")Vl99Gtablespree_order_promotionsspree_order_promotions,CREATE TABLE "spree_order_promotions" ("order_id" integer DEFAULT NULL, "promotion_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)UkuC}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")jiCC[tablespree_option_value_variantsspree_option_value_variants*CREATE TABLE "spree_option_value_variants" ("variant_id" integer DEFAULT NULL, "option_value_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)VhuE}indexindex_spree_option_type_prototypes_on_option_type_idspree_option_type_prototypesCREATE INDEX "index_spree_option_type_prototypes_on_option_type_id" ON "spree_option_type_prototypes" ("option_type_id")         p^L:(tbP>, x f T B 0  | j X F 4 "  n \ J 8 &   r ` N < *   v d R @ .  zhVD2 ~lZH6$zgTA.p]J7$yfS@-o\I6#xeR?,H)20190729091849G)20190729091848F)20190729091847E)20190729091846D)20190729091845C)20190729091844B)20190729091843A)20190729091842@)20190729091841?)20190729091840>)20190729091839=)20190729091838<)20190729091837;)20190729091836:)201907290918359)201907290918348)201907290918337)201907290918326)201907290918315)201907290918304)201907290918293)201907290918282)201907290918271)201907290918260)20190729091825/)20190729091824.)20190729091823-)20190729091822,)20190729091821+)20190729091820*)20190729091819))20190729091818()20190729091817')20190729091816&)20190729091815%)20190729091814$)20190729091813#)20190729091812")20190729091811!)20190729091810 )20190729091809)20190729091808)20190729091807)20190729091806)20190729091805)20190729091804)20190729091803)20190729091802)20190729091801)20190729091800)20190729091799)20190729091798)20190729091797)20190729091796)20190729091795)20190729091794)20190729091793)20190729091792)20190729091791 )20190729091790 )20190729091789 )20190729091788 )20190729091787 )20190729091786)20190729091785)20190729091784)20190729091783)20190729091782)20190729091781)20190729091780)20190729091779)20190729091778)20190729091777)20190729091776~)20190729091775})20190729091774|)20190729091773{)20190729091772z)20190729091771y)20190729091770x)20190729091769w)20190729091768v)20190729091767u)20190729091766t)20190729091765s)20190729091764r)20190729091763q)20190729091762p)20190729091761o)20190729091760n)20190729091759m)20190729091758l)20190729091757k)20190729091756j)20190729091755i)20190729091754h)20190729091753g)20190729091752f)20190729091751e)20190729091750d)20190729091749c)20190729091748b)20190729091747a)20190729091746`)20190729091745_)20190729091744^)20190729091743])20190729091742\)20190729091741[)20190729091740Z)20190729091739Y)20190729091738X)20190729091737W)20190729091736V)20190729091735U)20190729091734T)20190729091733S)20190729091732R)20190729091731Q)20190729091730P)20190729091729O)20190729091728N)20190729091727M)20190729091726L)20190729091725K)20190729091724J)20190729091723I)20190729091722H)20190729091721G)20190729091720F)20190729091719E)20190729091718D)20190729091717C)20190729091716B)20190729091715A)20190729091714@)20190729091713?)20190729091712>)20190729091711=)20190729091710<)20190729091709;)20190729091708:)201907290917079)201907290917068)201907290917057)201907290917046)201907290917035)201907290917024)201907290917013)201907290917002)201907290916991)201907290916980)20190729091697/)20190729091696.)20190729091695-)20190729091694,)20190729091693+)20190729091692*)20190729091691))20190729091690()20190729091689')20190729091688&)20190729091687%)20190729091686$)20190729091685#)20190729091684")20190729091683!)20190729091682 )20190729091681)20190729091680)20190729091679)20190729091678)20190729091677)20190729091676)20190729091675)20190729091674)20190729091673)20190729091672)20190729091671)20190729091670)20190729091669)20190729091668)20190729091667)20190729091666)20190729091665)20190729091664)20190729091663 )20190729091662 )20190729091661 )20190729091660 )20190729091659 )20190729091658)20190729091657)20190729091656)20190729091655)20190729091654)20190729091653)20190729091652)20190729091651)20190729091650 R {hUB/ q^K8% z g T A .   p ] J 7 $  y f S @ -   o \ I 6 #  )20190729091931)20190729091930)20190729091929)20190729091928)20190729091927)20190729091926)20190729091925)20190729091924)20190729091923)20190729091922)20190729091921)20190729091920)20190729091919 )20190729091918 )20190729091917 )20190729091916 )20190729091915 )20190729091914)20190729091913)20190729091912)20190729091911)20190729091910)20190729091909)20190729091908)20190729091907)20190729091906)20190729091905)20190729091904~)20190729091903})20190729091902|)20190729091901{)20190729091900z)20190729091899y)20190729091898x)20190729091897w)20190729091896v)20190729091895u)20190729091894t)20190729091893s)20190729091892r)20190729091891q)20190729091890p)20190729091889o)20190729091888n)20190729091887m)20190729091886l)20190729091885k)20190729091884j)20190729091883i)20190729091882h)20190729091881g)20190729091880f)20190729091879e)20190729091878d)20190729091877c)20190729091876b)20190729091875a)20190729091874`)20190729091873_)20190729091872^)20190729091871])20190729091870\)20190729091869[)20190729091868Z)20190729091867Y)20190729091866X)20190729091865W)20190729091864V)20190729091863U)20190729091862T)20190729091861S)20190729091860R)20190729091859Q)20190729091858P)20190729091857O)20190729091856N)20190729091855M)20190729091854L)20190729091853K)20190729091852J)20190729091851I)20190729091850    }p tJJQ}  [ i P,qEuindexindex_spree_option_type_prototypes_on_prototype_idspree_option_type_prototypesCREATE INDEX "index_spree_order_promotions_on_promotion_id" ON "spree_order_promotions" ("promotion_id")F.kCiindexindex_spree_option_value_variants_on_variant_idspree_option_value_variants=CREATE INDEX "index_spree_option_value_variants_on_variant_id" ON "spree_option_value_variants" ("variant_id")~- C;indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_value_variants+CREATE UNIQUE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_value_variants" ("variant_id", "option_value_id")A cCgindexindex_spree_return_authorizations_on_numberspree_return_authorizationsCREATE UNIQUE INDEX "index_spree_return_authorizations_on_number" ON "spree_return_authorizations" ("number") I)3indexindex_spree_payments_on_numberspree_paymentsCREATE UNIQUE INDEX "index_spree_payments_on_number" ON "spree_payments" ("number") Q 3 (@ ~ ) x lw=!indexindex_spree_tags_on_namespree_tags)CREATE UNIQUE INDEX "index_spree_tags_on_name" ON "spree_tags" ("name")))etablespree_taggingsspree_taggings(CREATE TABLE "spree_taggings" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_type" varchar, "taggable_id" integer, "tagger_type" varchar, "tagger_id" integer, "context" varchar(128), "created_at" datetime)!!! tablespree_tagsspree_tags'CREATE TABLE "spree_tags" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "taggings_count" integer DEFAULT 0)lk,[?Iindexindex_spree_shipping_categories_on_namespree_shipping_categories#CREATE INDEX "index_spree_shipping_categories_on_name" ON "spree_shipping_categories" ("name")owI-%indexindex_spree_properties_on_namespree_properties!CREATE 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"){I%%indexindex_spree_assets_on_positionspree_assetsCREATE INDEX "index_spree_assets_on_position" ON "spree_assets" ("position")jzCC[tablespree_shipping_method_zonesspree_shipping_method_zonessCREATE TABLE "spree_shipping_method_zones" ("shipping_method_id" integer DEFAULT NULL, "zone_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL)yO-1indexindex_spree_role_users_on_role_idspree_role_usersCREATE INDEX "index_spree_role_users_on_role_id" ON "spree_role_users" ("role_id")xO-1indexindex_spree_role_users_on_user_idspree_role_usersFCREATE INDEX "index_spree_role_users_on_user_id" ON "spree_role_users" ("user_id")>o)oindexindex_spree_taggings_on_tagger_id_and_tagger_typespree_taggings0CREATE INDEX "index_spree_taggings_on_tagger_id_and_tagger_type" ON "spree_taggings" ("tagger_id", "tagger_type") K))indexindex_spree_taggings_on_contextspree_taggings/CREATE INDEX "index_spree_taggings_on_context" ON "spree_taggings" ("context") O)1indexindex_spree_taggings_on_tagger_idspree_taggings.CREATE INDEX "index_spree_taggings_on_tagger_id" ON "spree_taggings" ("tagger_id")>w--/tablespree_role_usersspree_role_usersDCREATE TABLE "spree_role_users" ("role_id" integer DEFAULT NULL, "user_id" integer DEFAULT NULL, "id" integer PRIMARY KEY AUTOINCREMENT NOT NULL) W)Aindexindex_spree_taggings_on_taggable_typespree_taggings-CREATE INDEX "index_spree_taggings_on_taggable_type" ON "spree_taggings" ("taggable_type") S)9indexindex_spree_taggings_on_taggable_idspree_taggings,CREATE INDEX "index_spree_taggings_on_taggable_id" ON "spree_taggings" ("taggable_id") I)%indexindex_spree_taggings_on_tag_idspree_taggings+CREATE INDEX "index_spree_taggings_on_tag_id" ON "spree_taggings" ("tag_id")<1))indexspree_taggings_idxspree_taggings*CREATE UNIQUE INDEX "spree_taggings_idx" ON "spree_taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")   ` f C#F X`$(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_itemsCREATE INDEX "index_return_items_on_customer_return_id" ON "spree_return_items" ("customer_return_id")_11gtablespree_return_itemsspree_return_itemsCREATE 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 1 NOT NULL)Uy7indexindex_spree_inventory_units_on_original_return_item_idspree_inventory_units2CREATE INDEX "index_spree_inventory_units_on_original_return_item_id" ON "spree_inventory_units" ("original_return_item_id")Y)Eindexindex_spree_variants_on_discontinue_onspree_variantsCREATE INDEX "index_spree_variants_on_discontinue_on" ON "spree_variants" ("discontinue_on")![)Iindexindex_spree_variants_on_track_inventoryspree_variantsCREATE INDEX "index_spree_variants_on_track_inventory" ON "spree_variants" ("track_inventory") M)-indexindex_spree_variants_on_positionspree_variantsCREATE INDEX "index_spree_variants_on_position" ON "spree_variants" ("position")O)1indexindex_spree_variants_on_is_masterspree_variantsCREATE INDEX "index_spree_variants_on_is_master" ON "spree_variants" ("is_master")Q)5indexindex_spree_variants_on_deleted_atspree_variantsCREATE INDEX "index_spree_variants_on_deleted_at" ON "spree_variants" ("deleted_at")![)Iindexindex_spree_variants_on_tax_category_idspree_variantsCREATE INDEX "index_spree_variants_on_tax_category_id" ON "spree_variants" ("tax_category_id")|C)indexindex_spree_variants_on_skuspree_variants[CREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku")Q)5indexindex_spree_variants_on_product_idspree_variantsZCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")')) tablespree_variantsspree_variants#CREATE TABLE "spree_variants" ("id" integer NOT NULL PRIMARY KEY, "sku" varchar DEFAULT '' NOT NULL, "weight" decimal(8,2) DEFAULT '0.0', "height" decimal(8,2) DEFAULT NULL, "width" decimal(8,2) DEFAULT NULL, "depth" decimal(8,2) DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "is_master" boolean DEFAULT 0, "product_id" integer DEFAULT NULL, "cost_price" decimal(10,2) DEFAULT NULL, "position" integer DEFAULT NULL, "cost_currency" varchar DEFAULT NULL, "track_inventory" boolean DEFAULT 1, "tax_category_id" integer DEFAULT NULL, "updated_at" datetime NOT NULL, "discontinue_on" datetime DEFAULT NULL, "created_at" datetime NOT NULL)1)iindexspree_taggings_idyspree_taggings1CREATE INDEX "spree_taggings_idy" ON "spree_taggings" ("taggable_id", "taggable_type", "tagger_id", "context")    8s % 2Vj? ( g 6 _?1indexindex_spree_return_items_on_override_reimbursement_type_idspree_return_itemsNCREATE INDEX "index_spree_return_items_on_override_reimbursement_type_id" ON "spree_return_items" ("override_reimbursement_type_id")b>1indexindex_spree_return_items_on_preferred_reimbursement_type_idspree_return_itemsMCREATE INDEX "index_spree_return_items_on_preferred_reimbursement_type_id" ON "spree_return_items" ("preferred_reimbursement_type_id")==k1iindexindex_spree_return_items_on_exchange_variant_idspree_return_itemsLCREATE INDEX "index_spree_return_items_on_exchange_variant_id" ON "spree_return_items" ("exchange_variant_id")4<e1]indexindex_spree_return_items_on_reimbursement_idspree_return_itemsKCREATE INDEX "index_spree_return_items_on_reimbursement_id" ON "spree_return_items" ("reimbursement_id")7;g1aindexindex_spree_return_items_on_inventory_unit_idspree_return_itemsJCREATE 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_itemsICREATE INDEX "index_spree_return_items_on_return_authorization_id" ON "spree_return_items" ("return_authorization_id")[9yCindexindex_spree_return_authorizations_on_stock_location_idspree_return_authorizationsHCREATE INDEX "index_spree_return_authorizations_on_stock_location_id" ON "spree_return_authorizations" ("stock_location_id")@8gCaindexindex_spree_return_authorizations_on_order_idspree_return_authorizationsGCREATE INDEX "index_spree_return_authorizations_on_order_id" ON "spree_return_authorizations" ("order_id")h7wC!indexindex_reimbursement_credits_on_creditable_id_and_typespree_reimbursement_creditsFCREATE INDEX "index_reimbursement_credits_on_creditable_id_and_type" ON "spree_reimbursement_credits" ("creditable_id", "creditable_type")X6wCindexindex_spree_reimbursement_credits_on_reimbursement_idspree_reimbursement_creditsDCREATE INDEX "index_spree_reimbursement_credits_on_reimbursement_id" ON "spree_reimbursement_credits" ("reimbursement_id") 5['Iindexindex_spree_refunds_on_reimbursement_idspree_refundsCCREATE INDEX "index_spree_refunds_on_reimbursement_id" ON "spree_refunds" ("reimbursement_id")=AeC]indexindex_spree_shipping_method_zones_on_zone_idspree_shipping_method_zonesPCREATE INDEX "index_spree_shipping_method_zones_on_zone_id" ON "spree_shipping_method_zones" ("zone_id")y@ M%indexindex_spree_shipping_method_categories_on_shipping_category_idspree_shipping_method_categoriesOCREATE INDEX "index_spree_shipping_method_categories_on_shipping_category_id" ON "spree_shipping_method_categories" ("shipping_category_id")4O'1indexindex_spree_refunds_on_payment_idspree_refundsBCREATE INDEX "index_spree_refunds_on_payment_id" ON "spree_refunds" ("payment_id")83e9]indexindex_spree_prototype_taxons_on_prototype_idspree_prototype_taxonsACREATE INDEX "index_spree_prototype_taxons_on_prototype_id" ON "spree_prototype_taxons" ("prototype_id")A2i?eindexindex_spree_property_prototypes_on_property_idspree_property_prototypes@CREATE INDEX "index_spree_property_prototypes_on_property_id" ON "spree_property_prototypes" ("property_id")D1k?iindexindex_spree_property_prototypes_on_prototype_idspree_property_prototypes?CREATE INDEX "index_spree_property_prototypes_on_prototype_id" ON "spree_property_prototypes" ("prototype_id")                    `. 2 G x;:  BSI-3indexindex_spree_promotions_on_codespree_promotionsCREATE UNIQUE INDEX "index_spree_promotions_on_code" ON "spree_promotions" ("code")OI%%indexindex_spree_taxons_on_positionspree_taxonsCREATE INDEX "index_spree_taxons_on_position" ON "spree_taxons" ("position")NC%%indexindex_taxons_on_taxonomy_idspree_taxonsTCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")zM?%indexindex_taxons_on_permalinkspree_taxonsSCREATE INDEX "index_taxons_on_permalink" ON "spree_taxons" ("permalink")zL?%indexindex_taxons_on_parent_idspree_taxonsRCREATE INDEX "index_taxons_on_parent_id" ON "spree_taxons" ("parent_id")2K%%'tablespree_taxonsspree_taxonsQCREATE 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)JI)%indexindex_spree_trackers_on_activespree_trackersCREATE INDEX "index_spree_trackers_on_active" ON "spree_trackers" ("active")I))gtablespree_trackersspree_trackersWCREATE TABLE "spree_trackers" ("id" integer NOT NULL PRIMARY KEY, "analytics_id" varchar DEFAULT NULL, "active" boolean DEFAULT 1, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "engine" integer DEFAULT 0 NOT NULL)iH/'indexindex_friendly_id_slugs_on_slug_and_sluggable_type_and_scopefriendly_id_slugsCREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope" ON "friendly_id_slugs" ("slug", "sluggable_type", "scope")DGq/sindexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")gF7indexindex_stock_movements_on_originator_id_and_originator_typespree_stock_movementsUCREATE INDEX "index_stock_movements_on_originator_id_and_originator_type" ON "spree_stock_movements" ("originator_id", "originator_type")3Ee/]indexindex_spree_stock_items_on_stock_location_idspree_stock_itemsTCREATE INDEX "index_spree_stock_items_on_stock_location_id" ON "spree_stock_items" ("stock_location_id")BDm5mindexindex_spree_shipping_rates_on_shipping_method_idspree_shipping_ratesSCREATE INDEX "index_spree_shipping_rates_on_shipping_method_id" ON "spree_shipping_rates" ("shipping_method_id")-C_5Qindexindex_spree_shipping_rates_on_shipment_idspree_shipping_ratesRCREATE INDEX "index_spree_shipping_rates_on_shipment_id" ON "spree_shipping_rates" ("shipment_id")SxRA%indexindex_spree_taxons_on_namespree_taxons&CREATE INDEX "index_spree_taxons_on_name" ON "spree_taxons" ("name")^B{C indexindex_spree_shipping_method_zones_on_shipping_method_idspree_shipping_method_zonesQCREATE INDEX "index_spree_shipping_method_zones_on_shipping_method_id" ON "spree_shipping_method_zones" ("shipping_method_id")uQ?%indexindex_spree_taxons_on_rgtspree_taxons%CREATE INDEX "index_spree_taxons_on_rgt" ON "spree_taxons" ("rgt")uP?%indexindex_spree_taxons_on_lftspree_taxons$CREATE INDEX "index_spree_taxons_on_lft" ON "spree_taxons" ("lft")                 [-{`,0p/`E%+indexindex_spree_orders_on_numberspree_ordersCREATE UNIQUE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")_I%%indexindex_spree_orders_on_store_idspree_ordersCREATE INDEX "index_spree_orders_on_store_id" ON "spree_orders" ("store_id") ^O%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").Xe%]indexindex_spree_orders_on_confirmation_deliveredspree_ordersCREATE INDEX "index_spree_orders_on_confirmation_delivered" ON "spree_orders" ("confirmation_delivered")WW%Aindexindex_spree_orders_on_bill_address_idspree_ordersCREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id") VO%1indexindex_spree_orders_on_approver_idspree_ordersCREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id")UQ%5indexindex_spree_orders_on_completed_atspree_orders.CREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at"):T%%7tablespree_ordersspree_orders-CREATE 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 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 0, "considered_risky" boolean DEFAULT 0, "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)[W%Aindexindex_spree_orders_on_ship_address_idspree_ordersCREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")ZS%9indexindex_spree_orders_on_created_by_idspree_ordersCREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id")YY%Eindexindex_spree_orders_on_considered_riskyspree_ordersCREATE INDEX "index_spree_orders_on_considered_risky" ON "spree_orders" ("considered_risky")                 p?r }'md  dM%-indexindex_spree_prices_on_deleted_atspree_pricesCREATE INDEX "index_spree_prices_on_deleted_at" ON "spree_prices" ("deleted_at")/cg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesjCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")-b%%tablespree_pricesspree_prices;CREATE 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){aC%indexindex_spree_orders_on_tokenspree_ordersWCREATE INDEX "index_spree_orders_on_token" ON "spree_orders" ("token")pU#=indexindex_spree_users_on_bill_address_idspree_usersZCREATE INDEX "index_spree_users_on_bill_address_id" ON "spree_users" ("bill_address_id")oK#)indexindex_spree_users_on_deleted_atspree_usersYCREATE INDEX "index_spree_users_on_deleted_at" ON "spree_users" ("deleted_at")in-#indexemail_idx_uniquespree_usersgCREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email")m##Etablespree_usersspree_usersYCREATE TABLE "spree_users" ("id" integer NOT NULL PRIMARY KEY, "encrypted_password" varchar(128) DEFAULT NULL, "password_salt" varchar(128) DEFAULT NULL, "email" varchar DEFAULT NULL, "remember_token" varchar DEFAULT NULL, "persistence_token" varchar DEFAULT NULL, "reset_password_token" varchar DEFAULT NULL, "perishable_token" varchar DEFAULT NULL, "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" datetime DEFAULT NULL, "current_sign_in_at" datetime DEFAULT NULL, "last_sign_in_at" datetime DEFAULT NULL, "current_sign_in_ip" varchar DEFAULT NULL, "last_sign_in_ip" varchar DEFAULT NULL, "login" varchar DEFAULT NULL, "ship_address_id" integer DEFAULT NULL, "bill_address_id" integer DEFAULT NULL, "authentication_token" varchar DEFAULT NULL, "unlock_token" varchar DEFAULT NULL, "locked_at" datetime DEFAULT NULL, "reset_password_sent_at" datetime DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "remember_created_at" datetime DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "confirmation_token" varchar DEFAULT NULL, "confirmed_at" datetime DEFAULT NULL, "confirmation_sent_at" datetime DEFAULT NULL, "spree_api_key" varchar(48) DEFAULT NULL)Hl==!tablespree_sisow_transactionsspree_sisow_transactions\CREATE TABLE "spree_sisow_transactions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "transaction_id" varchar, "entrance_code" varchar, "status" varchar, "sha1" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "transaction_type" varchar)"fY1Eindexindex_spree_credit_cards_on_deleted_atspree_credit_cardsXCREATE INDEX "index_spree_credit_cards_on_deleted_at" ON "spree_credit_cards" ("deleted_at") eM%-indexindex_spree_prices_on_variant_idspree_pricesCREATE INDEX "index_spree_prices_on_variant_id" ON "spree_prices" ("variant_id")              g >  9 Zi}11{tablespree_dummy_modelsspree_dummy_modelsiCREATE TABLE "spree_dummy_models" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N|m?{indexindex_spree_oauth_access_tokens_on_refresh_tokenspree_oauth_access_tokenshCREATE UNIQUE INDEX "index_spree_oauth_access_tokens_on_refresh_token" ON "spree_oauth_access_tokens" ("refresh_token")S{u?}indexindex_spree_oauth_access_tokens_on_resource_owner_idspree_oauth_access_tokensgCREATE INDEX "index_spree_oauth_access_tokens_on_resource_owner_id" ON "spree_oauth_access_tokens" ("resource_owner_id")6z]?[indexindex_spree_oauth_access_tokens_on_tokenspree_oauth_access_tokensfCREATE UNIQUE INDEX "index_spree_oauth_access_tokens_on_token" ON "spree_oauth_access_tokens" ("token")Jyo?qindexindex_spree_oauth_access_tokens_on_application_idspree_oauth_access_tokenseCREATE INDEX "index_spree_oauth_access_tokens_on_application_id" ON "spree_oauth_access_tokens" ("application_id")x???tablespree_oauth_access_tokensspree_oauth_access_tokenscCREATE TABLE "spree_oauth_access_tokens" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_owner_id" integer, "application_id" integer, "token" varchar NOT NULL, "refresh_token" varchar, "expires_in" integer, "revoked_at" datetime, "created_at" datetime NOT NULL, "scopes" varchar, "previous_refresh_token" varchar DEFAULT '' NOT NULL)6w]?[indexindex_spree_oauth_access_grants_on_tokenspree_oauth_access_grantsbCREATE UNIQUE INDEX "index_spree_oauth_access_grants_on_token" ON "spree_oauth_access_grants" ("token")Jvo?qindexindex_spree_oauth_access_grants_on_application_idspree_oauth_access_grantsaCREATE INDEX "index_spree_oauth_access_grants_on_application_id" ON "spree_oauth_access_grants" ("application_id")u??tablespree_oauth_access_grantsspree_oauth_access_grants`CREATE TABLE "spree_oauth_access_grants" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_owner_id" integer NOT NULL, "application_id" integer NOT NULL, "token" varchar NOT NULL, "expires_in" integer NOT NULL, "redirect_uri" text NOT NULL, "created_at" datetime NOT NULL, "revoked_at" datetime, "scopes" varchar),tW=Oindexindex_spree_oauth_applications_on_uidspree_oauth_applications_CREATE UNIQUE INDEX "index_spree_oauth_applications_on_uid" ON "spree_oauth_applications" ("uid")s==5tablespree_oauth_applicationsspree_oauth_applications^CREATE TABLE "spree_oauth_applications" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "uid" varchar NOT NULL, "secret" varchar NOT NULL, "redirect_uri" text NOT NULL, "scopes" varchar DEFAULT '' NOT NULL, "confidential" boolean DEFAULT 1 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)rQ#5indexindex_spree_users_on_spree_api_keyspree_users]CREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")qU#=indexindex_spree_users_on_ship_address_idspree_users[CREATE INDEX "index_spree_users_on_ship_address_id" ON "spree_users" ("ship_address_id")