SQLite format 3@ 3.S`))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/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")h /'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") //ktablefriendly_id_slugsfriendly_id_slugs CREATE TABLE "friendly_id_slugs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime(6), "updated_at" datetime(6))Z ##{tablespree_usersspree_users CREATE TABLE "spree_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "crypted_password" varchar(128), "salt" varchar(128), "email" varchar, "remember_token" varchar, "remember_token_expires_at" varchar, "persistence_token" varchar, "single_access_token" varchar, "perishable_token" varchar, "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar, "last_login_ip" varchar, "login" varchar, "ship_address_id" integer, "bill_address_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "openid_identifier" varchar)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" ("4' |@l\сN@1#mo\`KO:A'1  & Tp^L:(tbP>, x f T&)20211108200445%)20211108200444$)20211108200443#)20211108200442")20211108200441!)20211108200440 )20211108200439)20211108200438)20211108200437)20211108200436)20211108200435)20211108200434)20211108200433)20211108200432)20211108200431)20211108200430)20211108200429)20211108200428)20211108200427)20211108200426)20211108200425)20211108200424)20211108200423)20211108200422)20211108200421 )20211108200420 )20211108200419 )20211108200418 )20211108200417 )20211108200416)20211108200415)20211108200414)20211108200413)20211108200412)20211108200411)20211108200410)20211108200409)20211108200408 & /|iVC0 r_L9& { h U B /)20211108200445&)20211108200444%)20211108200443$)20211108200442#)20211108200441")20211108200440!)20211108200439 )20211108200438)20211108200437)20211108200436)20211108200435)20211108200434)20211108200433)20211108200432)20211108200431)20211108200430)20211108200429)20211108200428)20211108200427)20211108200426)20211108200425)20211108200424)20211108200423)20211108200422)20211108200421)20211108200420 )20211108200419 )20211108200418 )20211108200417 )20211108200416 )20211108200415)20211108200414)20211108200413)20211108200412)20211108200411)20211108200410)20211108200409) 20211108200408 H#AAenvironmenttest2021-11-08 20:04:23.3216292021-11-08 20:04:23.321629 # environment              CC) \ CC##)tablespree_usersspree_users CREATE TABLE "spree_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "crypted_password" varchar(128), "salt" varchar(128), "email" varchar, "remember_token" varchar, "remember_token_expires_at" varchar, "persistence_token" varchar, "single_access_token" varchar, "perishable_token" varchar, "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar, "last_login_ip" varchar, "login" varchar, "ship_address_id" integer, "bill_address_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "openid_identifier" varchar, "api_key" varchar(40))#[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id")Cq/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")h /'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") //ktablefriendly_id_slugsfriendly_id_slugs CREATE TABLE "friendly_id_slugs" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(50), "scope" varchar, "created_at" datetime(6), "updated_at" datetime(6))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  5 C T w ; ae/]indexindex_spree_adjustments_ nY%Oindexindex_assets_on_v C%%indexindex_assets_on_viewable_idspree_assets$CREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id")H %%Stablespree_assetsspree_assets#CREATE 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(6), "updated_at" datetime(6))Iu/{indexindex_spree_adjustments_on_source_id_and_source_typespree_adjustments"CREATE INDEX "index_spree_adjustments_on_source_id_and_source_type" ON "spree_adjustments" ("source_id", "source_type")//9tablespree_adjustmentsspree_adjustmentsCREATE TABLE "spree_adjustments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "source_type" varchar, "source_id" integer, "adjustable_type" varchar, "adjustable_id" integer NOT NULL, "amount" decimal(10,2), "label" varchar, "eligible" boolean DEFAULT 1, "created_at" datetime(6), "updated_at" datetime(6), "order_id" integer NOT NULL, "included" boolean DEFAULT 0, "promotion_code_id" integer, "adjustment_reason_id" integer, "finalized" boolean DEFAULT 0 NOT NULL)'Y=Eindexindex_spree_adjustment_reasons_on_codespree_adjustment_reasonsCREATE INDEX "index_spree_adjustment_reasons_on_code" ON "spree_adjustment_reasons" ("code")-]=Mindexindex_spree_adjustment_reasons_on_activespree_adjustment_reasonsCREATE INDEX "index_spree_adjustment_reasons_on_active" ON "spree_adjustment_reasons" ("active")==tablespree_adjustment_reasonsspree_adjustment_reasonsCREATE TABLE "spree_adjustment_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "code" varchar, "active" boolean DEFAULT 1, "created_at" datetime(6), "updated_at" datetime(6))O+1indexindex_spree_addresses_on_state_idspree_addressesCREATE INDEX "index_spree_addresses_on_state_id" ON "spree_addresses" ("state_id")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")S+9indexindex_spree_addresses_on_country_idspree_addressesCREATE INDEX "index_spree_addresses_on_country_id" ON "spree_addresses" ("country_id")$++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), "updated_at" datetime(6))_/Qindexindex_fr)_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type")2e/]indexindex_spree_adjustments_on_promotion_code_idspree_adjustments!CREATE INDEX "index_spree_adjustments_on_promotion_code_id" ON "spree_adjustments" ("promotion_code_id")S/9indexindex_spree_adjustments_on_order_idspree_adjustments CREATE INDEX "index_spree_adjustments_on_order_id" ON "spree_adjustments" ("order_id")S/9indexindex_spree_adjustments_on_eligiblespree_adjustmentsCREATE INDEX "index_spree_adjustments_on_eligible" ON "spree_adjustments" ("eligible")G/7indexindex_adjustments_on_order_idspree_adjustmentsCREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_id")b/indexindex_spree_adjustments_on_adjustable_id_and_adjustable_typespree_adjustmentsCREATE INDEX "index_spree_adjustments_on_adjustable_id_and_adjustable_type" ON "spree_adjustments" ("adjustable_id", "adjustable_type")                   mm]M h L ^ : ` KO7=indexindex_inventory_units_on_order_]7Mindexindex_spree_inventory_units_on_carton_idspree_inventory_units6CREATE INDEX "index_spree_inventory_units_on_carton_id" ON "spree_inventory_units" ("carton_id")`77Ytablespree_inventory_unitsspree_inventory_units5CREATE TABLE "spree_inventory_units" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar, "variant_id" integer, "order_id" integer, "shipment_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "pending" boolean DEFAULT 1, "line_item_id" integer, "carton_id" integer)!C%%indexindex_assets_on_viewable_idspree_assets$CREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id")s099tablespree_customer_returnsspree_customer_returns4CREATE TABLE "spree_customer_returns" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar, "stock_location_id" integer, "created_at" datetime(6), "updated_at" datetime(6))/S19indexindex_spree_credit_cards_on_user_idspree_credit_cards3CREATE INDEX "index_spree_credit_cards_on_user_id" ON "spree_credit_cards" ("user_id")6.g1aindexindex_spree_credit_cards_on_payment_method_idspree_credit_cards2CREATE INDEX "index_spree_credit_cards_on_payment_method_id" ON "spree_credit_cards" ("payment_method_id")L-11Ctablespree_credit_cardsspree_credit_cards1CREATE TABLE "spree_credit_cards" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "month" varchar, "year" varchar, "cc_type" varchar, "last_digits" varchar, "gateway_customer_profile_id" varchar, "gateway_payment_profile_id" varchar, "created_at" datetime(6), "updated_at" datetime(6), "name" varchar, "user_id" integer, "payment_method_id" integer, "default" boolean DEFAULT 0 NOT NULL, "address_id" integer),E+indexindex_spree_countries_on_isospree_countries0CREATE INDEX "index_spree_countries_on_iso" ON "spree_countries" ("iso")*+++ tablespree_countriesspree_countries/CREATE TABLE "spree_countries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_name" varchar, "iso" varchar, "iso3" varchar, "name" varchar, "numcode" integer, "states_required" boolean DEFAULT 0, "updated_at" datetime(6), "created_at" datetime(6))"*]'Mindexindex_spree_cartons_on_stock_location_idspree_cartons.CREATE INDEX "index_spree_cartons_on_stock_location_id" ON "spree_cartons" ("stock_location_id"))G'/indexindex_spree_cartons_on_numberspree_cartons-CREATE UNIQUE INDEX "index_spree_cartons_on_number" ON "spree_cartons" ("number")A(m'{indexindex_spree_cartons_on_imported_from_shipment_idspree_cartons,CREATE UNIQUE INDEX "index_spree_cartons_on_imported_from_shipment_id" ON "spree_cartons" ("imported_from_shipment_id")'Y'Eindexindex_spree_cartons_on_external_numberspree_cartons+CREATE INDEX "index_spree_cartons_on_external_number" ON "spree_cartons" ("external_number")w&''-tablespree_cartonsspree_cartons*CREATE TABLE "spree_cartons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar, "external_number" varchar, "stock_location_id" integer, "address_id" integer, "shipping_method_id" integer, "tracking" varchar, "shipped_at" datetime, "created_at" datetime(6), "updated_at" datetime(6), "imported_from_shipment_id" integer)%Y/Cindexindex_spree_calculators_on_id_and_typespree_calculators)CREATE INDEX "index_spree_calculators_on_id_and_type" ON "spree_calculators" ("id", "type")b$/indexindex_spree_calculators_on_calculable_id_and_calculable_typespree_calculators(CREATE INDEX "index_spree_calculators_on_calculable_id_and_calculable_type" ON "spree_calculators" ("calculable_id", "calculable_type") #//Itablespree_calculatorsspree_calculators&CREATE TABLE "spree_calculators" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "calculable_type" varchar, "calculable_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "preferences" text) "Y%Oindexindex_assets_on_viewable_type_and_typespree_assets%CREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")                   : : p:::::::::&r q=//tablespree_log_entriesspree_loc3Yindexindex_spree_option_values_on_option_type_idspree_option_valuesHCREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")B33Itablespree_option_valuesspree_option_valuesGCREATE 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), "updated_at" datetime(6))AU1=indexindex_spree_option_types_on_positionspree_option_typesFCREATE INDEX "index_spree_option_types_on_position" ON "spree_option_types" ("position")d]7Mindexindex_spree_inventory_units_on_carton_idspree_inventory_units6CREATE INDEX "index_spree_inventory_units_on_carton_id" ON "spree_inventory_units" ("carton_id")@11Mtablespree_option_typesspree_option_typesECREATE 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), "updated_at" datetime(6))?EEtablespree_option_type_prototypesspree_option_type_prototypesDCREATE TABLE "spree_option_type_prototypes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "prototype_id" integer, "option_type_id" integer, "created_at" datetime(6), "updated_at" datetime(6))I>u/{indexindex_spree_log_entries_on_source_id_and_source_typespree_log_entriesCCREATE INDEX "index_spree_log_entries_on_source_id_and_source_type" ON "spree_log_entries" ("source_id", "source_type")q=//tablespree_log_entriesspree_log_entriesBCREATE TABLE "spree_log_entries" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "source_type" varchar, "source_id" integer, "details" text, "created_at" datetime(6), "updated_at" datetime(6)) acU-=indexindex_spree_line_items_on_variant_idspree_line_itemsACREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")Q-5indexindex_spree_line_items_on_order_idspree_line_items@CREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")1--tablespree_line_itemsspree_line_items?CREATE TABLE "spree_line_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer, "order_id" integer, "quantity" integer NOT NULL, "price" decimal(10,2) NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "currency" varchar, "cost_price" decimal(10,2), "tax_category_id" integer, "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);9g;aindexindex_spree_line_item_actions_on_line_item_idspree_line_item_actions>CREATE INDEX "index_spree_line_item_actions_on_line_item_id" ON "spree_line_item_actions" ("line_item_id")28a;Uindexindex_spree_line_item_actions_on_action_idspree_line_item_actions=CREATE INDEX "index_spree_line_item_actions_on_action_id" ON "spree_line_item_actions" ("action_id")$7;;_tablespree_line_item_actionsspree_line_item_actionsH33#tablespree_order_mutexesspree_order_mutexesNCREATE TABLE "spree_order_mutexes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer NOT NULL, "created_at" datetime(6))IGmEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variantsMCREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")yF E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variantsLCREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_values_variants" ("variant_id", "option_value_id")EEEtablespree_option_values_variantsspree_option_values_variantsJCREATE TABLE "spree_option_values_variants" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer, "option_value_id" integer, "created_at" datetime(6), "updated_at" datetime(6)) W3Ai OO%1indexindex_spree_orders_on_guest_tokenspree_ordersUCREATE INDEX "index_spree_orders_on_guest_token" ON "spree_orders" ("guest_token")NS%9indexindex_spree_orders_on_created_by_idspree_ordersTCREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id")MQ%5indexindex_spree_orders_on_completed_atspree_ordersSCREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")LW%Aindexindex_spree_orders_on_bill_address_idspree_ordersRCREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id") KO%1indexindex_spree_orders_on_approver_idspree_ordersQCREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id")DW3Aindexindex_spree_option_values_on_positionspree_option_valuesICREATE INDEX "index_spree_option_values_on_position" ON "spree_option_values" ("position")c3YindexinSG%!inde}PE%indexindex_spree_orders_on_numberspree_ordersVCREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")1Cc3Yindexindex_spree_option_values_on_option_type_idspree_option_valuesHCREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")B33Itablespree_option_valuesspree_option_valuesGCREATE 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), "updated_at" datetime(6))                 m)+H j)))77 tablespree_payment_methodsspree_payment_methods`CREATE TABLE "spree_payment_methods" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar, "name" varchar, "description" text, "active" boolean DEFAULT 1, "deleted_at" datetime, "created_at" datetime(6), "updated_at" datetime(6), "display_on" varchar, "auto_capture" boolean, "preferences" text, "preference_source" varchar, "position" integer DEFAULT 0, "available_to_users" boolean DEFAULT 1, "available_to_admin" boolean DEFAULT 1)`I/3indexindex_spree_preferences_on_keyspree_preferencesgCREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")R_//Stablespree_preferencesspree_preferencesfCREATE TABLE "spree_preferences" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "key" varchar, "created_at" datetime(6), "updated_at" datetime(6))QW%Aindexindex_spree_orders_on_ship_address_idspree_ordersWCREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")}PE%indexindex_spree_orders_on_numberspree_ordersVCREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")=^o)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentseCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type")&]_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsdCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id") \M)-indexindex_spree_payments_on_order_idspree_paymentscCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")I[))Mtablespree_paymentsspree_paymentsbCREATE TABLE "spree_payments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10,2) DEFAULT '0.0' NOT NULL, "order_id" integer, "source_type" varchar, "source_id" integer, "payment_method_id" integer, "state" varchar, "response_code" varchar, "avs_response" varchar, "created_at" datetime(6), "updated_at" datetime(6), "number" varchar, "cvv_response_code" varchar, "cvv_response_message" varchar)a7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsaCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")IXmEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_events_CREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_events" ("payment_id")WEE'tablespree_payment_capture_eventsspree_payment_capture_events^CREATE 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), "updated_at" datetime(6))JVq;uindexindex_spree_orders_promotions_on_promotion_code_idspree_orders_promotions]CREATE INDEX "index_spree_orders_promotions_on_promotion_code_id" ON "spree_orders_promotions" ("promotion_code_id")bU;indexindex_spree_orders_promotions_on_order_id_and_promotion_idspree_orders_promotions[CREATE INDEX "index_spree_orders_promotions_on_order_id_and_promotion_id" ON "spree_orders_promotions" ("order_id", "promotion_id")T;;7tablespree_orders_promotionsspree_orders_promotionsZCREATE TABLE "spree_orders_promotions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "promotion_id" integer, "promotion_code_id" integer, "created_at" datetime(6), "updated_at" datetime(6))SG%!indexindex_spree_orders_on_user_idspree_ordersYCREATE INDEX "index_spree_orders_on_user_id" ON "spree_orders" ("user_id")5Rk%gindexindex_spree_orders_on_user_id_and_created_by_idspree_ordersXCREATE INDEX "index_spree_orders_on_user_id_and_created_by_id" ON "spree_orders" ("user_id", "created_by_id")     `         ih      V G }XQ [7Iindexindex_spree_:77tablespree_products_taxonsspree_products_taxons|CREE)indexindex_spree_products_on_namespree_productszCREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")qQ)5indexindex_spree_products_on_deleted_atspree_productsyCREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")pU)=indexindex_spree_products_on_available_onspree_productsxCREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on")N%%Ytablespree_pricesspree_priceshCREATE TABLE "spree_prices" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer NOT NULL, "amount" decimal(10,2), "currency" varchar, "deleted_at" datetime, "is_default" boolean DEFAULT 1 NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "country_iso" varchar(2))Jo))Otablespree_productsspree_productswCREATE TABLE "spree_products" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar DEFAULT '' NOT NULL, "description" text, "available_on" datetime, "deleted_at" datetime, "slug" varchar, "meta_description" text, "meta_keywords" varchar, "tax_category_id" integer, "shipping_category_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "promotionable" boolean DEFAULT 1, "meta_title" varchar)G> 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"):"55tablespree_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), "updated_at" datetime(6))S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at"),![?Iindexindex_spree_reimbursement_types_on_typespree_reimbursement_typesCREATE INDEX "index_spree_reimbursement_types_on_type" ON "spree_reimbursement_types" ("type")' ??[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), "updated_at" datetime(6), "type" varchar)SCC+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, "created_at" datetime(6), "updated_at" datetime(6)) ['Iindexindex_spree_refunds_on_reimbursement_idspree_refundsCREATE INDEX "index_spree_refunds_on_reimbursement_id" ON "spree_refunds" ("reimbursement_id")O'=indexindex_refunds_on_refund_reason_idspree_refundsCREATE INDEX "index_refunds_on_refund_reason_id" ON "spree_refunds" ("refund_reason_id")O'1indexindex_spree_refunds_on_payment_idspree_refundsCREATE INDEX "index_spree_refunds_on_payment_id" ON "spree_refunds" ("payment_id")A''?tablespree_refundsspree_refundsCREATE TABLE "spree_refunds" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "payment_id" integer, "amount" decimal(10,2) DEFAULT '0.0' NOT NULL, "transaction_id" varchar, "created_at" datetime(6), "updated_at" datetime(6), "refund_reason_id" integer, "reimbursement_id" integer)55Qtablespree_refund_reasonsspree_refund_reasonsCREATE TABLE "spree_refund_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 1, "mutable" boolean DEFAULT 1, "created_at" datetime(6), "updated_at" datetime(6), "code" varchar)C--7tablespree_prototypesspree_prototypesCREATE TABLE "spree_prototypes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6)),]9Mindexindex_spree_prototype_taxons_on_taxon_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_taxon_id" ON "spree_prototype_taxons" ("taxon_id")8e9]indexindex_spree_prototype_taxons_on_prototype_idspree_prototype_taxonsCREATE INDEX "index_spree_prototype_taxons_on_prototype_id" ON "spree_prototype_taxons" ("prototype_id")q99{tablespree_prototype_taxonsspree_prototype_taxonsCREATE TABLE "spree_prototype_taxons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "taxon_id" integer, "prototype_id" integer, "created_at" datetime(6), "updated_at" datetime(6))}??tablespree_property_prototypesspree_property_prototypesCREATE TABLE "spree_property_prototypes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "prototype_id" integer, "property_id" integer, "created_at" datetime(6), "updated_at" datetime(6))d--ytablespree_propertiesspree_propertiesCREATE TABLE "spree_properties" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "presentation" varchar NOT NULL, "created_at" datetime(6), "updated_at" datetime(6))                #X  Mwk:_# caXa+Uindexindex_spree_shipments_on_stockO+1indexindex_spree_shipments_on_order_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_order_id" ON "spree_shipments" ("order_id")~1?+indexindex_shipments_on_numberspree_shipmentsCREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number")70i+eindexindex_spree_shipments_on_deprecated_address_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_deprecated_address_id" ON "spree_shipments" ("deprecated_address_id")>/++1tablespree_shipmentsspree_shipmentsCREATE TABLE "spree_shipments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tracking" varchar, "number" varchar, "cost" decimal(10,2) DEFAULT '0.0', "shipped_at" datetime, "order_id" integer, "deprecated_address_id" integer, "state" varchar, "created_at" datetime(6), "updated_at" datetime(6), "stock_location_id" integer, "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).Q/5indexindex_spree_roles_users_on_user_idspree_roles_usersCREATE INDEX "index_spree_roles_users_on_user_id" ON "spree_roles_users" ("user_id")-Q/5indexindex_spree_roles_users_on_role_idspree_roles_usersCREATE INDEX "index_spree_roles_users_on_role_id" ON "spree_roles_users" ("role_id")\,//etablespree_roles_usersspree_roles_usersCREATE TABLE "spree_roles_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "role_id" integer, "user_id" integer, "created_at" datetime(6), "updated_at" datetime(6))4+##-tablespree_rolesspree_rolesCREATE TABLE "spree_roles" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6))*551tablespree_return_reasonsspree_return_reasonsCREATE TABLE "spree_return_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 1, "mutable" boolean DEFAULT 1, "created_at" datetime(6), "updated_at" datetime(6))R)y1indexindex_spree_return_items_on_exchange_inventory_unit_idspree_return_itemsCREATE INDEX "index_spree_return_items_on_exchange_inventory_unit_id" ON "spree_return_items" ("exchange_inventory_unit_id").(]1Yindexindex_return_items_on_customer_return_idspree_return_itemsCREATE INDEX "index_return_items_on_customer_return_id" ON "spree_return_items" ("customer_return_id")'11Otablespree_return_itemsspree_return_itemsCREATE TABLE "spree_return_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "return_authorization_id" integer, "inventory_unit_id" integer, "exchange_variant_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "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, "acceptance_status" varchar, "customer_return_id" integer, "reimbursement_id" integer, "exchange_inventory_unit_id" integer, "acceptance_status_errors" text, "preferred_reimbursement_type_id" integer, "override_reimbursement_type_id" integer, "resellable" boolean DEFAULT 1 NOT NULL, "return_reason_id" integer)i&Cindexindex_return_authorizations_on_return_authorization_reason_idspree_return_authorizationsCREATE INDEX "index_return_authorizations_on_return_authorization_reason_id" ON "spree_return_authorizations" ("return_reason_id")Q%CC'tablespree_return_authorizationsspree_return_authorizationsCREATE TABLE "spree_return_authorizations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar, "state" varchar, "order_id" integer, "memo" text, "created_at" datetime(6), "updated_at" datetime(6), "stock_location_id" integer, "return_reason_id" integer)$$Y5Eindexindex_spree_reimbursements_on_order_idspree_reimbursementsCREATE INDEX "index_spree_reimbursements_on_order_id" ON "spree_reimbursements" ("order_id")                ^^Qo 8 M V % a99Ctablespree_shipping_methodsspree_shipping_methodsCREATE TABLE "spree_shipping_methods" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "display_on" varchar, "deleted_at" datetime, "created_at" datetime(6), "updated_at" datetime(6), "tracking_url" varchar, "admin_name" varchar, "tax_category_id" integer, "code" varchar, "available_to_all" boolean DEFAULT 1, "carrier" varchar, "service_level" varchar, "available_to_users" boolean DEFAULT 1)2O+1indexindex_spree_shipments_on_order_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_order_id" ON "spree_shipments" ("order_id")A@i?eindexindex_spree_shipping_rate_taxes_on_tax_rate_idspree_shipping_rate_taxesCREATE INDEX "index_spree_shipping_rate_taxes_on_tax_rate_id" ON "spree_shipping_rate_taxes" ("tax_rate_id")P?s?yindexindex_spree_shipping_rate_taxes_on_shipping_rate_idspree_shipping_rate_taxesCREATE INDEX "index_spree_shipping_rate_taxes_on_shipping_rate_id" ON "spree_shipping_rate_taxes" ("shipping_rate_id")A>??tablespree_shipping_rate_taxesspree_shipping_rate_taxesCREATE TABLE "spree_shipping_rate_taxes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,2) DEFAULT '0.0' NOT NULL, "tax_rate_id" integer, "shipping_rate_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)k9iindexindex_spree_shipping_methods_on_tax_category_idspree_shipping_methodsCREATE INDEX "index_spree_shipping_methods_on_tax_category_id" ON "spree_shipping_methods" ("tax_category_id");CCtablespree_shipping_method_zonesspree_shipping_method_zonesCREATE TABLE "spree_shipping_method_zones" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "shipping_method_id" integer, "zone_id" integer, "created_at" datetime(6), "updated_at" datetime(6))?:IWiindexsstock_location_id_spree_sm_slspree_shipping_method_stock_locationsCREATE INDEX "sstock_location_id_spree_sm_sl" ON "spree_shipping_method_stock_locations" ("stock_location_id")@9IWkindexshipping_method_id_spree_sm_slspree_shipping_method_stock_locationsCREATE INDEX "shipping_method_id_spree_sm_sl" ON "spree_shipping_method_stock_locations" ("shipping_method_id")-8WW7tablespree_shipping_method_stock_locationsspree_shipping_method_stock_locationsCREATE TABLE "spree_shipping_method_stock_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "shipping_method_id" integer, "stock_location_id" integer, "created_at" datetime(6), "updated_at" datetime(6))s7Mindexindex_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")g6[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")35MMWtablespree_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), "updated_at" datetime(6))^4??Itablespree_shipping_categoriesspree_shipping_categoriesCREATE TABLE "spree_shipping_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6))+3a+Uindexindex_spree_shipments_on_stock_location_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_stock_location_id" ON "spree_shipments" ("stock_location_id")                F   v37w: \GGQtablespree_store_credit_categoriesspree_se7]indexindex_spree_stock_movements_on_stock_item_idspree_stock_movementsCREATE INDEX "index_spree_stock_movements_on_stock_item_id" ON "spree_stock_movements" ("stock_item_id")QP[7Iindexindex_spree_stock_locations_on_state_idspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_state_id" ON "spree_stock_locations" ("state_id")LA559tablespree_shipping_ratesspree_shipping_ratesCREATE TABLE "spree_shipping_rates" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "shipment_id" integer, "shipping_method_id" integer, "selected" boolean DEFAULT 0, "cost" decimal(8,2) DEFAULT '0.0', "created_at" datetime(6), "updated_at" datetime(6), "tax_rate_id" integer).N_7Qindexindex_spree_stock_locations_on_country_idspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_country_id" ON "spree_stock_locations" ("country_id")RM77Atablespree_stock_locationsspree_stock_locationsCREATE TABLE "spree_stock_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6), "default" boolean DEFAULT 0 NOT NULL, "address1" varchar, "address2" varchar, "city" varchar, "state_id" integer, "state_name" varchar, "country_id" integer, "zipcode" varchar, "phone" varchar, "active" boolean DEFAULT 1, "backorderable_default" boolean DEFAULT 0, "propagate_all_variants" boolean DEFAULT 1, "admin_name" varchar, "position" integer DEFAULT 0, "restock_inventory" boolean DEFAULT 1 NOT NULL, "fulfillable" boolean DEFAULT 1 NOT NULL, "code" varchar, "check_stock_on_transfer" boolean DEFAULT 1)L/Windexindex_spree_stock_items_on_variant_id_and_stock_location_idspree_stock_itemsCREATE UNIQUE INDEX "index_spree_stock_items_on_variant_id_and_stock_location_id" ON "spree_stock_items" ("variant_id", "stock_location_id") WHERE deleted_at is null3Ke/]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")!JE/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")IW/Aindexindex_spree_stock_items_on_deleted_atspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_deleted_at" ON "spree_stock_items" ("deleted_at")OH//Ktablespree_stock_itemsspree_stock_itemsCREATE TABLE "spree_stock_items" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "stock_location_id" integer, "variant_id" integer, "count_on_hand" integer DEFAULT 0 NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "backorderable" boolean DEFAULT 0, "deleted_at" datetime) GM%-indexindex_spree_states_on_country_idspree_statesCREATE INDEX "index_spree_states_on_country_id" ON "spree_states" ("country_id")]F%%{tablespree_statesspree_statesCREATE TABLE "spree_states" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "abbr" varchar, "country_id" integer, "updated_at" datetime(6), "created_at" datetime(6))EU3=indexindex_spree_state_changes_on_user_idspree_state_changesCREATE INDEX "index_spree_state_changes_on_user_id" ON "spree_state_changes" ("user_id")_D3indexindex_spree_state_changes_on_stateful_id_and_stateful_typespree_state_changesCREATE INDEX "index_spree_state_changes_on_stateful_id_and_stateful_type" ON "spree_state_changes" ("stateful_id", "stateful_type")?C33#tablespree_state_changesspree_state_changesCREATE 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), "updated_at" datetime(6))6BK5windexspree_shipping_rates_join_indexspree_shipping_ratesCREATE UNIQUE INDEX "spree_shipping_rates_join_index" ON "spree_shipping_rates" ("shipment_id", "shipping_method_id")                 Z o D o"/w}    T CCWtablespree_store_payment_methodsspr;S??tablespree_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), "user_total_amount" decimal(8,2) DEFAULT '0.0' NOT NULL, "authorization_code" varchar NOT NULL, "deleted_at" datetime, "originator_type" varchar, "originator_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "update_reason_id" integer, "amount_remaining" decimal(8,2) DEFAULT NULL, "store_credit_reason_id" integer)(O[7Iindexindex_spree_stock_locations_on_state_idspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_state_id" ON "spree_stock_locations" ("state_id") #S???tablespree_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), "user_total_amount" decimal(8,2) DEFAULT '0.0' NOT NULL, "authorization_code" varchar NOT NULL, "deleted_at" datetime, "originator_type" varchar, "originator_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "update_reason_id" integer, "amount_remaining" decimal(8,2) DEFAULT NULL)vXOOYtablespree_store_credit_update_reasonsspree_store_credit_update_reasonsCREATE TABLE "spree_store_credit_update_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6))4Wa=Uindexindex_spree_store_credit_types_on_priorityspree_store_credit_typesCREATE INDEX "index_spree_store_credit_types_on_priority" ON "spree_store_credit_types" ("priority")oV==otablespree_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), "updated_at" datetime(6))MUq?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")>Tg?aindexindex_spree_store_credit_events_on_deleted_atspree_store_credit_eventsCREATE INDEX "index_spree_store_credit_events_on_deleted_at" ON "spree_store_credit_events" ("deleted_at") ??ctablespree_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), "user_total_amount" decimal(8,2) DEFAULT '0.0' NOT NULL, "authorization_code" varchar NOT NULL, "deleted_at" datetime, "originator_type" varchar, "originator_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "update_reason_id" integer)jRGGQtablespree_store_credit_categoriesspree_store_credit_categoriesCREATE TABLE "spree_store_credit_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime(6), "updated_at" datetime(6))Te7&Z[3Iindexindex_spree_store_credits_on_deleted_atspree_store_creditsCREATE INDEX "index_spree_store_credits_on_deleted_at" ON "spree_store_credits" ("deleted_at")7Qe7]indexindex_spree_stock_movements_on_stock_item_idspree_stock_movementsCREATE INDEX "index_spree_stock_movements_on_stock_item_id" ON "spree_stock_movements" ("stock_item_id")QP77?tablespree_stock_movementsspree_stock_movementsCREATE TABLE "spree_stock_movements" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "stock_item_id" integer, "quantity" integer DEFAULT 0, "action" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "originator_type" varchar, "originator_id" integer)[7I[U3=indexindex_spree_store_credits_on_type_idspree_store_creditsCREATE INDEX "index_spree_store_credits_on_type_id" ON "spree_store_credits" ("type_id")        ix - 4 \ =Tli U 6TQQ tablemEmindexindex_spree_variant_property_rules_on_product_idspree_variant_property_rulesCREATE INDEX "index_spree_variant_property_rules_on_product_id" ON "spree_variant_property_rules" ("product_id")|EEtablespree_variant_property_rulesspree_variant_property_rules CREATE TABLE "spree_variant_property_rules" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)d{mQindexindex_spree_variant_property_rule_values_on_rulespree_variant_property_rule_values CREATE INDEX "index_spree_variant_property_rule_values_on_rule" ON "spree_variant_property_rule_values" ("variant_property_rule_id")ez{Q indexindex_spree_variant_property_rule_values_on_property_idspree_variant_property_rule_values CREATE INDEX "index_spree_variant_property_rule_values_on_property_id" ON "spree_variant_property_rule_values" ("property_id")PyQQ tablespree_variant_property_rule_valuesspree_variant_property_rule_values CREATE TABLE "spree_variant_property_rule_values" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "position" integer DEFAULT 0, "property_id" integer, "variant_property_rule_id" integer, "created_at" datetime(6), "updated_at" datetime(6))xYYindexindex_spree_variant_prop_rule_conditions_on_rule_and_optvalspree_variant_property_rule_conditions CREATE INDEX "index_spree_variant_prop_rule_conditions_on_rule_and_optval" ON "spree_variant_property_rule_conditions" ("variant_property_rule_id", "option_value_id")FwYYetablespree_variant_property_rule_conditionsspree_variant_property_rule_conditionsCREATE TABLE "spree_variant_property_rule_conditions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "option_value_id" integer, "variant_property_rule_id" integer, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)9vcAYindexindex_spree_user_stock_locations_on_user_idspree_user_stock_locationsCREATE INDEX "index_spree_user_stock_locations_on_user_id" ON "spree_user_stock_locations" ("user_id")uAA tablespree_user_stock_locationsspree_user_stock_locationsCREATE TABLE "spree_user_stock_locations" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "stock_location_id" integer, "created_at" datetime(6), "updated_at" datetime(6))!tW5Aindexindex_spree_user_addresses_on_user_idspree_user_addressesCREATE INDEX "index_spree_user_addresses_on_user_id" ON "spree_user_addresses" ("user_id")Tsu5 indexindex_spree_user_addresses_on_user_id_and_address_idspree_user_addressesCREATE UNIQUE INDEX "index_spree_user_addresses_on_user_id_and_address_id" ON "spree_user_addresses" ("user_id", "address_id")*r]5Mindexindex_spree_user_addresses_on_address_idspree_user_addressesCREATE INDEX "index_spree_user_addresses_on_address_id" ON "spree_user_addresses" ("address_id")Gq55/tablespree_user_addressesspree_user_addressesCREATE TABLE "spree_user_addresses" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "address_id" integer NOT NULL, "default" boolean DEFAULT 0, "archived" boolean DEFAULT 0, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)7pg1aindexindex_spree_unit_cancels_on_inventory_unit_idspree_unit_cancelsCREATE INDEX "index_spree_unit_cancels_on_inventory_unit_id" ON "spree_unit_cancels" ("inventory_unit_id")o117tablespree_unit_cancelsspree_unit_cancelsCREATE TABLE "spree_unit_cancels" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "inventory_unit_id" integer NOT NULL, "reason" varchar, "created_by" varchar, "created_at" datetime(6), "updated_at" datetime(6))nC%%indexindex_taxons_on_taxonomy_idspree_taxonsCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")mI%%indexindex_spree_taxons_on_positionspree_taxonsCREATE INDEX "index_spree_taxons_on_position" ON "spree_taxons" ("position")        e ^8nn;3 oNNE g%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesjCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")VEE-tablespree_wallet_payment_sourcesspree_wallet_payment_sourcesCREATE TABLE "spree_wallet_payment_sources" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "payment_source_type" varchar NOT NULL, "payment_source_id" integer NOT NULL, "default" boolean DEFAULT 0 NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, CONSTRAINT "fk_rails_5dd6e027c5" FOREIGN KEY ("user_id") REFERENCES "spree_users" ("id") )##mtablespree_zonesspree_zonesCREATE 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), "updated_at" datetime(6))Z1indexindex_spree_zone_members_on_zoneable_id_and_zoneable_typespree_zone_membersCREATE INDEX "index_spree_zone_members_on_zoneable_id_and_zoneable_type" ON "spree_zone_members" ("zoneable_id", "zoneable_type")S19indexindex_spree_zone_members_on_zone_idspree_zone_membersCREATE INDEX "index_spree_zone_members_on_zone_id" ON "spree_zone_members" ("zone_id")|11!tablespree_zone_membersspree_zone_membersCREATE TABLE "spree_zone_members" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_type" varchar, "zoneable_id" integer, "zone_id" integer, "created_at" datetime(6), "updated_at" datetime(6))![)Iindexindex_spree_variants_on_track_inventoryspree_variantsCREATE INDEX "index_spree_variants_on_track_inventory" ON "spree_variants" ("track_inventory")![)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_variantsCREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku")Q)5indexindex_spree_variants_on_product_idspree_variantsCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id") M)-indexindex_spree_variants_on_positionspree_variantsCREATE INDEX "index_spree_variants_on_position" ON "spree_variants" ("position") ~))Stablespree_variantsspree_variantsCREATE TABLE "spree_variants" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar DEFAULT '' NOT NULL, "weight" decimal(8,2) DEFAULT '0.0', "height" decimal(8,2), "width" decimal(8,2), "depth" decimal(8,2), "deleted_at" datetime, "is_master" boolean DEFAULT 0, "product_id" integer, "cost_price" decimal(10,2), "position" integer, "cost_currency" varchar, "track_inventory" boolean DEFAULT 1, "tax_category_id" integer, "updated_at" datetime(6), "created_at" datetime(6)) O%1indexindex_spree_prices_on_country_isospree_pricesiCREATE INDEX "index_spree_prices_on_country_iso" ON "spree_prices" ("country_iso")b %%tablespree_pricesspree_priceshCREATE 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(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "country_iso" varchar(2) DEFAULT NULL)J}mEmindexindex_spree_variant_property_rules_on_product_idspree_variant_property_rulesCREATE INDEX "index_spree_variant_property_rules_on_product_id" ON "spree_variant_property_rules" ("product_id") wEWindexindex_spree_wallet_payment_sources_on_source_and_userspree_wallet_payment_sourcesCREATE UNIQUE INDEX "index_spree_wallet_payment_sources_on_source_and_user" ON "spree_wallet_payment_sources" ("user_id", "payment_source_id", "payment_source_type")A gEaindexindex_spree_wallet_payment_sources_on_user_idspree_wallet_payment_sourcesCREATE INDEX "index_spree_wallet_payment_sources_on_user_id" ON "spree_wallet_payment_sources" ("user_id")                 G T "#{ #G o ='++/tablespree_tax_ratesspree_tax_ratesCREATE TABLE "spree_tax_rates" ("id" integer NOT NULL PRIMARY KEY, "amount" decimal(8,5) DEFAULT NULL, "zone_id" integer DEFAULT NULL, "included_in_price" boolean DEFAULT 0, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "name" varchar DEFAULT NULL, "show_rate_in_label" boolean DEFAULT 1, "deleted_at" datetime DEFAULT NULL, "starts_at" datetime, "expires_at" datetime)]%yGindexindex_spree_tax_rate_tax_categories_on_tax_category_idspree_tax_rate_tax_categories%CREATE INDEX "index_spree_tax_rate_tax_categories_on_tax_category_id" ON "spree_tax_rate_tax_categories" ("tax_category_id")i$GGQtablespree_tax_rate_tax_categoriesspree_tax_rate_tax_categories;CREATE TABLE "spree_tax_rate_tax_categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "tax_category_id" integer NOT NULL, "tax_rate_id" integer NOT NULL)!#S7Eindexindex_inventory_units_on_variant_idspree_inventory_units9CREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")$"U7Iindexindex_inventory_units_on_shipment_idspree_inventory_units8CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")3!c7Yindexindex_spree_inventory_units_on_line_item_idspree_inventory_units7CREATE INDEX "index_spree_inventory_units_on_line_item_id" ON "spree_inventory_units" ("line_item_id")* ]7Mindexindex_spree_inventory_units_on_carton_idspree_inventory_units6CREATE INDEX "index_spree_inventory_units_on_carton_id" ON "spree_inventory_units" ("carton_id")77Ktablespree_inventory_unitsspree_inventory_units5CREATE TABLE "spree_inventory_units" ("id" integer NOT NULL PRIMARY KEY, "state" varchar DEFAULT NULL, "variant_id" integer DEFAULT NULL, "shipment_id" integer DEFAULT NULL, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "pending" boolean DEFAULT 1, "line_item_id" integer DEFAULT NULL, "carton_id" integer DEFAULT NULL)u?%indexindex_spree_taxons_on_rgtspree_taxons$CREATE INDEX "index_spree_taxons_on_rgt" ON "spree_taxons" ("rgt")u?%indexindex_spree_taxons_on_lftspree_taxons#CREATE INDEX "index_spree_taxons_on_lft" ON "spree_taxons" ("lft")U3=indexindex_spree_store_credits_on_user_idspree_store_credits"CREATE INDEX "index_spree_store_credits_on_user_id" ON "spree_store_credits" ("user_id")U3=indexindex_spree_store_credits_on_type_idspree_store_creditsCREATE INDEX "index_spree_store_credits_on_type_id" ON "spree_store_credits" ("type_id")&[3Iindexindex_spree_store_credits_on_deleted_atspree_store_creditsCREATE INDEX "index_spree_store_credits_on_deleted_at" ON "spree_store_credits" ("deleted_at")o%++/ta{*?#indexindex_spree_roles_on_namespree_rolesCREATE UNIQUE INDEX "index_spree_roles_on_name" ON "spree_roles" ("name")oS+9indexindex_spree_tax_rates_on_deleted_atspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_deleted_at" ON "spree_tax_rates" ("deleted_at")Q&qGuindexindex_spree_tax_rate_tax_categories_on_tax_rate_idspree_tax_rate_tax_categories&CREATE INDEX "index_spree_tax_rate_tax_categories_on_tax_rate_id" ON "spree_tax_rate_tax_categories" ("tax_rate_id")s33 tablespree_store_creditsspree_store_creditsCREATE TABLE "spree_store_credits" ("id" integer NOT NULL PRIMARY KEY, "user_id" integer DEFAULT NULL, "category_id" integer DEFAULT NULL, "created_by_id" integer DEFAULT NULL, "amount" decimal(8,2) DEFAULT '0.0' NOT NULL, "amount_used" decimal(8,2) DEFAULT '0.0' NOT NULL, "amount_authorized" decimal(8,2) DEFAULT '0.0' NOT NULL, "currency" varchar DEFAULT NULL, "memo" text DEFAULT NULL, "deleted_at" datetime DEFAULT NULL, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "type_id" integer DEFAULT NULL, "invalidated_at" datetime DEFAULT NULL)M+-indexindex_spree_tax_rates_on_zone_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_zone_id" ON "spree_tax_rates" ("zone_id")               DSD= . K  Rl_[zQ#5indexindex_spree_users_on_spree_api_keyspree_users)CREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_ S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at");9k-iindexindex_spree_promotions_on_promotion_category_idspree_promotionsCREATE INDEX "index_spree_promotions_on_promotion_category_id" ON "spree_promotions" ("promotion_category_id")8W-?indexindex_spree_promotions_on_id_and_typespree_promotionsCREATE INDEX "index_spree_promotions_on_id_and_type" ON "spree_promotions" ("id", "type")7U-=indexindex_spree_promotions_on_expires_atspree_promotionsCRE{*?#indexindex_spree_roles_on_namespree_rolesCREATE UNIQUE INDEX "index_spree_roles_on_name" ON "spree_roles" ("name") )M+-indexindex_spree_tax_rates_on_zone_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_zone_id" ON "spree_tax_rates" ("zone_id")(S+9indexindex_spree_tax_rates_on_deleted_atspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_deleted_at" ON "spree_tax_rates" ("deleted_at")n4-- tablespree_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', "advertise" boolean DEFAULT 0, "path" varchar DEFAULT NULL, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "promotion_category_id" integer DEFAULT NULL, "per_code_usage_limit" integer DEFAULT NULL, "apply_automatically" boolean DEFAULT 0) 3AAtablespree_store_credit_reasonsspree_store_credit_reasons/CREATE TABLE "spree_store_credit_reasons" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "active" boolean DEFAULT 1, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)b2}E indexindex_spree_store_shipping_methods_on_shipping_method_idspree_store_shipping_methods.CREATE INDEX "index_spree_store_shipping_methods_on_shipping_method_id" ON "spree_store_shipping_methods" ("shipping_method_id")D1iEeindexindex_spree_store_shipping_methods_on_store_idspree_store_shipping_methods-CREATE INDEX "index_spree_store_shipping_methods_on_store_id" ON "spree_store_shipping_methods" ("store_id")-0EE[tablespree_store_shipping_methodsspree_store_shipping_methods,CREATE TABLE "spree_store_shipping_methods" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "store_id" integer NOT NULL, "shipping_method_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)_/{E indexindex_spree_promotion_rules_stores_on_promotion_rule_idspree_promotion_rules_stores+CREATE INDEX "index_spree_promotion_rules_stores_on_promotion_rule_id" ON "spree_promotion_rules_stores" ("promotion_rule_id")D.iEeindexindex_spree_promotion_rules_stores_on_store_idspree_promotion_rules_stores*CREATE INDEX "index_spree_promotion_rules_stores_on_store_id" ON "spree_promotion_rules_stores" ("store_id")&-EEMtablespree_promotion_rules_storesspree_promotion_rules_stores(CREATE TABLE "spree_promotion_rules_stores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "store_id" integer NOT NULL, "promotion_rule_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL),##wtablespree_zonesspree_zonesCREATE TABLE "spree_zones" ("id" integer NOT NULL PRIMARY KEY, "name" varchar DEFAULT NULL, "description" varchar DEFAULT NULL, "zone_members_count" integer DEFAULT 0, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL)?+i/qindexindex_spree_roles_users_on_user_id_and_role_idspree_roles_users'CREATE UNIQUE INDEX "index_spree_roles_users_on_user_id_and_role_id" ON "spree_roles_users" ("user_id", "role_id")                         e n ~  EN;##ctablespree_usersspree_users CREATE 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, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "spree_api_key" varchar(48) DEFAULT NULL, "authentication_token" varchar DEFAULT NULL, "unlock_token" varchar DEFAULT NULL, "locked_at" datetime DEFAULT NULL, "remember_created_at" datetime, "reset_password_sent_at" datetime, "deleted_at" datetime, "confirmation_token" varchar, "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar)<Q#5indexindex_spree_users_on_spree_api_keyspree_users0CREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")4##Etablespree_usersspree_users CREATE 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,T?#indexindex_spree_users_on_reset_password_token_solidus_auth_devisespree_users3CREATE UNIQUE INDEX "index_spree_users_on_reset_password_token_solidus_auth_devise" ON "spree_users" ("reset_password_token")>K#)indexindex_spree_users_on_deleted_atspree_users2CREATE INDEX "index_spree_users_on_deleted_at" ON "spree_users" ("deleted_at")j=-#indexemail_idx_uniquespree_users1CREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email"):S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at");9k-iindexindex_spree_promotions_on_promotion_category_idspree_promotionsCREATE INDEX "index_spree_promotions_on_promotion_category_id" ON "spree_promotions" ("promotion_category_id")8W-?indexindex_spree_promotions_on_id_and_typespree_promotionsCREATE INDEX "index_spree_promotions_on_id_and_type" ON "spree_promotions" ("id", "type")7U-=indexindex_spree_promotions_on_expires_atspree_promotionsCREATE INDEX "index_spree_promotions_on_expires_at" ON "spree_promotions" ("expires_at")56g-aindexindex_spree_promotions_on_apply_automaticallyspree_promotionsCREATE INDEX "index_spree_promotions_on_apply_automatically" ON "spree_promotions" ("apply_automatically")5S-9indexindex_spree_promotions_on_advertisespree_promotionsCREATE INDEX "index_spree_promotions_on_advertise" ON "spree_promotions" ("advertise")       ) RR<Q#5indexindex_spree_users_on_spree_api_keyspree_users)CREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")/##tablespree_usersspree_users CREATE 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, "remember_created_at" 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, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "spree_api_key" varchar(48) DEFAULT NULL, "authentication_token" varchar DEFAULT NULL, "unlock_token" varchar DEFAULT NULL, "locked_at" datetime DEFAULT NULL):S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at");9k-iindexindex_spree_promotions_on_promotion_category_idspree_promotionsCREATE INDEX "index_spree_promotions_on_promotion_category_id" ON "spree_promotions" ("promotion_category_id")8W-?indexindex_spree_promotions_on_id_and_typespree_promotionsCREATE INDEX "index_spree_promotions_on_id_and_type" ON "spree_promotions" ("id", "type")7U-=indexindex_spree_promotions_on_expires_atspree_promotionsCREATE INDEX "index_spree_promotions_on_expires_at" ON "spree_promotions" ("expires_at")56g-aindexindex_spree_promotions_on_apply_automaticallyspree_promotionsCREATE INDEX "index_spree_promotions_on_apply_automatically" ON "spree_promotions" ("apply_automatically")5S-9indexindex_spree_promotions_on_advertisespree_promotionsCREATE INDEX "index_spree_promotions_on_advertise" ON "spree_promotions" ("advertise")