SQLite format 3@ ;.f7H[9 indexindex_action_text_rich_texts_uniquenessaction_text_rich_textsCREATE UNIQUE INDEX "index_action_text_rich_texts_uniqueness" ON "action_text_rich_texts" ("record_type", "record_id", "name")999 tableaction_text_rich_textsaction_text_rich_textsCREATE TABLE "action_text_rich_texts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "body" text, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)biG!indexindex_action_mailbox_inbound_emails_uniquenessaction_mailbox_inbound_emailsCREATE UNIQUE INDEX "index_action_mailbox_inbound_emails_uniqueness" ON "action_mailbox_inbound_emails" ("message_id", "message_checksum")T GG'tableaction_mailbox_inbound_emailsaction_mailbox_inbound_emailsCREATE TABLE "action_mailbox_inbound_emails" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "status" integer DEFAULT 0 NOT NULL, "message_id" varchar NOT NULL, "message_checksum" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)c kIindexindex_active_storage_variant_records_uniquenessactive_storage_variant_records CREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_digest")N IItableactive_storage_variant_recordsactive_storage_variant_records CREATE TABLE "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL, CONSTRAINT "fk_rails_993965df05" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )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")AA7tableactive_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" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) 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)]55]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, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL)T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migratio5F+;#-~l]ҁOÁA2%~lrYaJP8B$1 3 jp^L:(tbP>, x f T B 0  | j3)202303260957642)202303260957631)202303260957620)20230326095761/)20230326095760.)20230326095759-)20230326095758,)20230326095757+)20230326095756*)20230326095755))20230326095754()20230326095753')20230326095752&)20230326095751%)20230326095750$)20230326095749#)20230326095748")20230326095747!)20230326095746 )20230326095745)20230326095744)20230326095743)20230326095742)20230326095741)20230326095740)20230326095739)20230326095738)20230326095737)20230326095736)20230326095735)20230326095734)20230326095733)20230326095732)20230326095731)20230326095730)20230326095729)20230326095728)20230326095727 )20230326095726 )20230326095725 )20230326095724 )20230326095723 )20230326095722)20230326095721)20230326095720)20230326095719)20230326095718)20230326095717)20230326095716)20230326095715)20230326095713 3 8|iVC0 r_L9& { h U B /  q ^ K 8)202303260957643)202303260957632)202303260957621)202303260957610)20230326095760/)20230326095759.)20230326095758-)20230326095757,)20230326095756+)20230326095755*)20230326095754))20230326095753()20230326095752')20230326095751&)20230326095750%)20230326095749$)20230326095748#)20230326095747")20230326095746!)20230326095745 )20230326095744)20230326095743)20230326095742)20230326095741)20230326095740)20230326095739)20230326095738)20230326095737)20230326095736)20230326095735)20230326095734)20230326095733)20230326095732)20230326095731)20230326095730)20230326095729)20230326095728)20230326095727)20230326095726 )20230326095725 )20230326095724 )20230326095723 )20230326095722 )20230326095721)20230326095720)20230326095719)20230326095718)20230326095717)20230326095716)20230326095715) 20230326095713 H#AAenvironmenttest2023-03-26 09:57:23.2123142023-03-26 09:57:23.212314 # environment              ; i 2 w@ZH[9 indexindex_action_text_rich_texts_uniquenessaction_text_rich_textsCREATE UNIQUE INDEX "index_action_text_rich_texts_uniqueness" ON "action_text_rich_texts" ("record_type", "record_id", "name")999 tableaction_text_rich_textsaction_text_rich_textsCREATE TABLE "action_text_rich_texts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "body" text, "record_type" varchar NOT NULL, "record_id" bigint NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)biG!indexindex_action_mailbox_inbound_emails_uniquenessaction_mailbox_inbound_emailsCREATE UNIQUE INDEX "index_action_mailbox_inbound_emails_uniqueness" ON "action_mailbox_inbound_emails" ("message_id", "message_checksum")T GG'tableaction_mailbox_inbound_emailsaction_mailbox_inbound_emailsCREATE TABLE "action_mailbox_inbound_emails" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "status" integer DEFAULT 0 NOT NULL, "message_id" varchar NOT NULL, "message_checksum" varchar NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)c kIindexindex_active_storage_variant_records_uniquenessactive_storage_variant_records CREATE UNIQUE INDEX "index_active_storage_variant_records_uniqueness" ON "active_storage_variant_records" ("blob_id", "variation_digest")N IItableactive_storage_variant_recordsactive_storage_variant_records CREATE TABLE "active_storage_variant_records" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "blob_id" bigint NOT NULL, "variation_digest" varchar NOT NULL, CONSTRAINT "fk_rails_993965df05" FOREIGN KEY ("blob_id") REFERENCES "active_storage_blobs" ("id") )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")AA7tableactive_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" bigint NOT NULL, "blob_id" bigint NOT NULL, "created_at" datetime(6) 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)]55]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, "service_name" varchar NOT NULL, "byte_size" bigint NOT NULL, "checksum" varchar, "created_at" datetime(6) NOT NULL)T55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) 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  C X@hY  d88##)tablespree_usersspree_usersCREATE 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))4++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), "name" varchar)//9tablespree_adjustmentsspree_adjustments"CREATE 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))_/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_slugsCREATE 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))'Y=Eindexindex_spree_adjustment_reasons_on_codespree_adjustment_reasons!CREATE INDEX "index_spree_adjustment_reasons_on_code" ON "spree_adjustment_reasons" ("code")-]=Mindexindex_spree_adjustment_reasons_on_activespree_adjustment_reasons CREATE 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")                W#nT^ E Q $9 $ G' E+indexindex_spree_countries_on_isospree_countries6CREATE INDEX "index_spree_countries_on_iso" ON "spree_countries" ("iso")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")'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))I%u/{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")2$e/]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_adjustments&CREATE INDEX "index_spree_adjustments_on_eligible" ON "spree_adjustments" ("eligible")!G/7indexindex_adjustments_on_order_idspree_adjustments%CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_id")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")U//9tablespree_adjustmentsspree_adjustments"CREATE TABLE "spree_adjustments" ("*1++ tablespree_countriesspree_countries5CREATE 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))"0]'Mindexindex_spree_cartons_on_stock_location_idspree_cartons4CREATE INDEX "index_spree_cartons_on_stock_location_id" ON "spree_cartons" ("stock_location_id")/G'/indexindex_spree_cartons_on_numberspree_cartons3CREATE UNIQUE INDEX "index_spree_cartons_on_number" ON "spree_cartons" ("number")A.m'{indexindex_spree_cartons_on_imported_from_shipment_idspree_cartons2CREATE UNIQUE INDEX "index_spree_cartons_on_imported_from_shipment_id" ON "spree_cartons" ("imported_from_shipment_id")-Y'Eindexindex_spree_cartons_on_external_numberspree_cartons1CREATE INDEX "index_spree_cartons_on_external_number" ON "spree_cartons" ("external_number")w,''-tablespree_cartonsspree_cartons0CREATE 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")                    x1 x _ U-=indexind&//tablespree_log_entriesspree_log_entriesHCREATE TABLE "spree_log_entries" ("id" integer PRIMARY KEY AUTOx2U-=indexindex_spree_line_items_on_variant_idspree_line_itemsGCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")xQ-5indexindex_spree_line_items_on_order_idspree_line_itemsFCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")2E+indexindex_spree_countries_on_isospree_countries6CREATE INDEX "index_spree_countries_on_iso" ON "spree_countries" ("iso");)--tablespree_line_itemsspree_line_itemsECREATE 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);?g;aindexindex_spree_line_item_actions_on_line_item_idspree_line_item_actionsDCREATE INDEX "index_spree_line_item_actions_on_line_item_id" ON "spree_line_item_actions" ("line_item_id")2>a;Uindexindex_spree_line_item_actions_on_action_idspree_line_item_actionsCCREATE INDEX "index_spree_line_item_actions_on_action_id" ON "spree_line_item_actions" ("action_id")$=;;_tablespree_line_item_actionsspree_line_item_actionsBCREATE TABLE "spree_line_item_actions" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "line_item_id" integer NOT NULL, "action_id" integer NOT NULL, "quantity" integer DEFAULT 0, "created_at" datetime(6), "updated_at" datetime(6))S7Eindexindex_inventory_units_on_variant_idspree_inventory_unitsACREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")U7Iindexindex_inventory_units_on_shipment_idspree_inventory_units@CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")aO7=indexindex_inventory_units_on_order_idspree_inventory_units?CREATE INDEX "index_inventory_units_on_order_id" ON "spree_inventory_units" ("order_id")c7Yindexindex_spree_inventory_units_on_line_item_idspree_inventory_units>CREATE INDEX "index_spree_inventory_units_on_line_item_id" ON "spree_inventory_units" ("line_item_id") ]7Mindexindex_spree_inventory_units_on_carton_idspree_inventory_units=CREATE INDEX "index_spree_inventory_units_on_carton_id" ON "spree_inventory_units" ("carton_id")`77Ytablespree_inventory_unitsspree_inventory_units=<      FE   9 @ 5 ! o G9JJ!P%%tablespree_ordersspree_ordersVCREATE TABLE "spree_orders" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(32), "item_total" decimal(10,2) DEFAULT 0.0 NOT NULL, "total" decimal(10,2) DEFAULT 0.0 NOT NULL, "state" varchar, "adjustment_total" decimal(10,2) DEFAULT 0.0 NOT NULL, "user_id" integer, "completed_at" datetime, "bill_address_id" integer, "ship_address_id" integer, "payment_total" decimal(10,2) DEFAULT 0.0, "shipment_state" varchar, "payment_state" varchar, "email" varchar, "special_instructions" text, "created_at" datetime(6), "updated_at" datetime(6), "currency" varchar, "last_ip_address" varchar, "created_by_id" integer, "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, "approved_at" datetime, "confirmation_delivered" boolean DEFAULT 0, "guest_token" varchar, "canceled_at" datetime, "canceler_id" integer, "store_id" integer, "approver_name" varchar, "frontend_viewable" boolean DEFAULT 1 NOT NULL)&OW3Oindexindex_spree_order_mutexes_on_order_idspree_order_mutexesUCREATE UNIQUE INDEX "index_spree_order_mutexes_on_order_id" ON "spree_order_mutexes" ("order_id")>N33#tablespree_order_mutexesspree_order_mutexesTCREATE TABLE "spree_order_mutexes" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer NOT NULL, "created_at" datetime(6))IMmEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variantsSCREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")yL E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variantsRCREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_values_variants" ("variant_id", "option_value_id")KEEtablespree_option_values_variantsspree_option_values_variantsQCREATE 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))JW3Aindexindex_spree_option_values_on_positionspree_option_valuesPCREATE INDEX "index_spree_option_values_on_position" ON "spree_option_values" ("position")1Ic3Yindexindex_spree_option_values_on_option_type_idspree_option_valuesOCREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")H33Itablespree_option_valuesspree_option_valuesNCREATE 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))GU1=indexindex_spree_option_types_on_positionspree_option_typesMCREATE INDEX "index_spree_option_types_on_position" ON "spree_option_types" ("position")F11Mtablespree_option_typesspree_option_typesLCREATE 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))EEEtablespree_option_type_prototypesspree_option_type_prototypesKCREATE 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))IDu/{indexindex_spree_log_entries_on_source_id_and_source_typespree_log_entriesICREATE INDEX "index_spree_log_entries_on_source_id_and_source_type" ON "spree_log_entries" ("source_id", "source_type")qC//tablespree_log_entriesspree_log_entriesHCREATE 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))               o  { TFp]x! 77 tablespree_payment_methodsspree_payment_methodsfCREATE 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)J\q;uindexindex_spree_orders_promotions_on_promotion_code_idspree_orders_promotionscCREATE INDEX "index_spree_orders_promotions_on_promotion_code_id" ON "spree_orders_promotions" ("promotion_code_id")b[;indexindex_spree_orders_promotions_on_order_id_and_promotion_idspree_orders_promotionsbCREATE INDEX "index_spree_orders_promotions_on_order_id_and_promotion_id" ON "spree_orders_promotions" ("order_id", "promotion_id")Z;;7tablespree_orders_promotionsspree_orders_promotionsaCREATE 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))YG%!indexindex_spree_orders_on_user_idspree_orders`CREATE INDEX "index_spree_orders_on_user_id" ON "spree_orders" ("user_id")5Xk%gindexindex_spree_orders_on_user_id_and_created_by_idspree_orders_CREATE INDEX "index_spree_orders_on_user_id_and_created_by_id" ON "spree_orders" ("user_id", "created_by_id")WW%Aindexindex_spree_orders_on_ship_address_idspree_orders^CREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")}VE%indexindex_spree_orders_on_numberspree_orders]CREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number") UO%1indexindex_spree_orders_on_guest_tokenspree_orders\CREATE INDEX "index_spree_orders_on_guest_token" ON "spree_orders" ("guest_token")TS%9indexindex_spree_orders_on_created_by_idspree_orders[CREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id")SQ%5indexindex_spree_orders_on_completed_atspree_ordersZCREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")RW%Aindexindex_spree_orders_on_bill_address_idspree_ordersXCREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id") QO%1indexindex_spree_orders_on_approver_idspree_ordersWCREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id")Ga))Itablespree_paymentsspree_paymentshCREATE 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_methodsgCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")I^mEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_eventseCREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_events" ("payment_id")]EE#tablespree_payment_capture_eventsspree_payment_capture_eventsdCREATE 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))              f     p AWfY  H &g=aindexindex_spree_product_properties_on_property_idspree_product_properties|CREATE INDEX "index_spree_product_properties_on_property_id" ON "spree_product_properties" ("property_id")AmiAeindexindex_spree_product_option_types_on_product_idspree_product_option_typesuCREATE INDEX "index_spree_product_option_types_on_product_id" ON "spree_product_option_types" ("product_id");leA]indexindex_spree_product_option_types_on_positionspree_product_option_typestCREATE INDEX "index_spree_product_option_types_on_position" ON "spree_product_option_types" ("position")MkqAuindexindex_spree_product_option_types_on_option_type_idspree_product_option_typessCREATE INDEX "index_spree_product_option_types_on_option_type_id" ON "spree_product_option_types" ("option_type_id")jAA3tablespree_product_option_typesspree_product_option_typesrCREATE 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), "updated_at" datetime(6)) &g%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesqCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency") &O%1indexindex_spree_prices_on_country_isospree_pricespCREATE INDEX "index_spree_prices_on_country_iso" ON "spree_prices" ("country_iso") &N%%Ytablespree_pricesspree_pricesoCREATE 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))fI/3indexindex_spree_preferences_on_keyspree_preferencesnCREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")Re//Stablespree_preferencesspree_preferencesmCREATE TABLE "spree_preferences" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "key" varchar, "created_at" datetime(6), "updated_at" datetime(6))=do)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentskCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type") _)Qindexindex_spree_ bM)-indexindex_spree_payments_on_order_idspree_paymentsiCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")&q==_tablespree_product_propertiesspree_product_propertiesyCREATE TABLE "spree_product_properties" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar, "product_id" integer, "property_id" integer, "created_at" datetime(6), "updated_at" datetime(6), "position" integer DEFAULT 0)XpsGindexindex_products_promotion_rules_on_promotion_rule_idspree_product_promotion_rulesxCREATE INDEX "index_products_promotion_rules_on_promotion_rule_id" ON "spree_product_promotion_rules" ("promotion_rule_id")CoeGgindexindex_products_promotion_rules_on_product_idspree_product_promotion_ruleswCREATE INDEX "index_products_promotion_rules_on_product_id" ON "spree_product_promotion_rules" ("product_id") nGGtablespree_product_promotion_rulesspree_product_promotion_rulesvCREATE TABLE "spree_product_promotion_rules" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "promotion_rule_id" integer, "created_at" datetime(6), "updated_at" datetime(6))M)-indexindex_spree_payments_on_order_idspreWW7tablespree_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))               ==r } } } ' e/]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")]L%%{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))KU3=indexindex_spree_state_changes_on_user_idspree_state_changesCREATE INDEX "index_spree_state_changes_on_user_id" ON "spree_state_changes" ("user_id")_J3indexindex_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")?I33#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))6HK5windexspree_shipping_rates_join_indexspree_shipping_ratesCREATE UNIQUE INDEX "spree_shipping_rates_join_index" ON "spree_shipping_rates" ("shipment_id", "shipping_method_id")JG555tablespree_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)AFi?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")PEs?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")?D?? 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")99stablespree_shipping_methodsspree_shipping_methodsCREATE TABLE "spree_shipping_methods" ("id" integer PRIMARY KEY AUTOINCREMENT NOTR/!PE/Yindexstock_item_by_loc_and_var_idspree_stock_itemsCREATE INDEX "stock_item_by_loc_and_var_id" ON "spree_stock_itUB99Ctablespree_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)OW/Aindexindex_spree_stock_items_on_deleted_atspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_deleted_at" ON "spree_stock_items" ("deleted_at")ON//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) MM%-indexindex_spree_states_on_country_idspree_statesCREATE INDEX "index_spree_states_on_country_id" ON "spree_states" ("country_id")                 0[  l\n0000=??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)4]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")o\==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))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")g?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")jXGGQtablespree_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))7We7]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")QV77?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)(U[7Iindexindex_spree_stock_locations_on_state_idspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_state_id" ON "spree_stock_locations" ("state_id").T_7Qindexindex_spree_stock_locations_on_country_idspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_country_id" ON "spree_stock_locations" ("country_id")RS77Atablespree_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)R/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 null3Qe/]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")!PE/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")              [ -1[[*--tablespree_taxonomiesspree_taxonomiesCREATE TABLE "spree_taxonomies" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "position" integer DEFAULT 0) mM+-indexindex_spree_tax_rates_on_zone_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_zone_id" ON "spree_tax_rates" ("zone_id") ]+Mindexindex_spree_tax_rates_on_tax_category_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_tax_category_id" ON "spree_tax_rates" ("tax_category_id")  S+9indexindex_spree_tax_rates_on_deleted_atspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_deleted_at" ON "spree_tax_rates" ("deleted_at") o++ tablespree_tax_ratesspree_tax_ratesCREATE 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), "updated_at" datetime(6), "name" varchar, "show_rate_in_label" boolean DEFAULT 1, "deleted_at" datetime)1i55tablespree_tax_categoriesspree_tax_categoriesCREATE 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), "updated_at" datetime(6), "tax_code" varchar)hG%!indexindex_spree_stores_on_defaultspree_storesCREATE INDEX "index_spree_stores_on_default" ON "spree_stores" ("default")xgA%indexindex_spree_stores_on_codespree_storesCREATE INDEX "index_spree_stores_on_code" ON "spree_stores" ("code") %%stablespree_storesspree_storesCREATE TABLE "spree_stores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "url" varchar, "meta_description" text, "meta_keywords" text, "seo_title" varchar, "mail_from_address" varchar, "default_currency" varchar, "code" varchar, "default" boolean DEFAULT 0 NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "cart_tax_country_iso" varchar)@egCaindexindex_spree_store_payment_methods_on_store_idspree_store_payment_methodsCREATE INDEX "index_spree_store_payment_methods_on_store_id" ON "spree_store_payment_methods" ("store_id")[dyCindexindex_spree_store_payment_methods_on_payment_method_idspree_store_payment_methodsCREATE INDEX "index_spree_store_payment_methods_on_payment_method_id" ON "spree_store_payment_methods" ("payment_method_id"))cCCWtablespree_store_payment_methodsspree_store_payment_methodsCREATE TABLE "spree_store_payment_methods" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "store_id" integer NOT NULL, "payment_method_id" integer NOT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)4U3=indexindex_spree_store_credits_on_user_idspree_store_creditsCREATE INDEX "index_spree_store_credits_on_user_id" ON "spree_store_credits" ("user_id")hU3=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")33Wtablespree_store_creditsspree_store_creditsCREATE TABLE "spree_store_credits" ("id" in6f%%-tablespree_storesspree_storesCREATE TABLE "spree_stores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "url" varchar, "meta_description" text, "meta_keywords" text, "seo_title" varchar, "mail_fromKf%%Wtablespree_storesspree_storesCREATE TABLE "spree_stores" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "url" varchar, "meta_description" text, "meta_keywords" text, "seo_title" varchar, "mail_from_address" varchar, "default_currency" varchar, "code" varchar, "default" boolean DEFAULT 0 NOT NULL, "created_at" datetime(6), "updated_at" datetime(6), "cart_tax_country_iso" varchar, "available_locales" varchar, "bcc_email" varchar)                   p && +))tablespree_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), "shipping_category_id" integer)wEWindexindex_spree_wallet_payment_sources_on_source_and_userspree_wallet_payment_sources"CREATE UNIQUE INDEX "index_spree_wallet_payment_sources_on_source_and_user" ON "spree_wallet_payment_sources" ("user_id", "payment_source_id", "payment_source_type")VEE-tablespree_wallet_payment_sourcesspree_wallet_payment_sources CREATE 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") )Z 1indexindex_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")AgEaindexindex_spree_wallet_payment_sources_on_user_idspree_wallet_payment_sources!CREATE INDEX "index_spree_wallet_payment_sources_on_user_id" ON "spree_wallet_payment_sources" ("user_id")dmQindexindex_spree_variant_property_rule_values_on_rulespree_variant_property_rule_valuesCREATE INDEX "index_spree_variant_property_rule_values_on_rule" ON "spree_variant_property_rule_values" ("variant_property_rule_id")e{Q indexindex_spree_variant_property_rule_values_on_property_idspree_variant_property_rule_valuesCREATE INDEX "index_spree_variant_property_rule_values_on_property_id" ON "spree_variant_property_rule_values" ("property_id")PQQ tablespree_variant_property_rule_valuesspree_variant_property_rule_valuesCREATE 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))                   < 4 </tHt4EEitablespree_promotion_code_batchesspree_promotion_code_batches$CREATE TABLE "spree_promotion_code_batches" ("id" integer NOT NULL PRIMARY KEY, "promotion_id" integer NOT NULL, "base_code" varchar NOT NULL, "number_of_codes" integer NOT NULL, "email" varchar DEFAULT NULL, "error" varchar DEFAULT NULL, "state" varchar DEFAULT 'pending', "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "join_characters" varchar DEFAULT '_' NOT NULL, CONSTRAINT "fk_rails_c217102f50" FOREIGN KEY ("promotion_id") REFERENCES "spree_promotions" ("id") )777 tablespree_promotion_codesspree_promotion_codesCREATE TABLE "spree_promotion_codes" ("id" integer NOT NULL PRIMARY KEY, "promotion_id" integer NOT NULL, "value" varchar NOT NULL, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "promotion_code_batch_id" integer DEFAULT NULL, CONSTRAINT "fk_rails_e306e312d9" FOREIGN KEY ("promotion_code_batch_id") REFERENCES "spree_promotion_code_batches" ("id") )PqEuindexindex_spree_promotion_code_batches_on_promotion_idspree_promotion_code_batches%CREATE INDEX "index_spree_promotion_code_batches_on_promotion_id" ON "spree_promotion_code_batches" ("promotion_id")/a7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsgCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type") 77+tablespree_payment_methodsspree_payment_methodsfCREATE TABLE "spree_payment_methods" ("id" integer NOT NULL PRIMARY KEY, "type" varchar DEFAULT NULL, "name" varchar DEFAULT NULL, "description" text DEFAULT NULL, "active" &U7Kindexindex_spree_promotion_codes_on_valuespree_promotion_codes&CREATE UNIQUE INDEX "index_spree_promotion_codes_on_value" ON "spree_promotion_codes" ("value")4c7Yindexindex_spree_promotion_codes_on_promotion_idspree_promotion_codesCREATE INDEX "index_spree_promotion_codes_on_promotion_id" ON "spree_promotion_codes" ("promotion_id")U-=indexindex_spree_line_items_on_variant_idspree_line_itemsGCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")Q-5indexindex_spree_line_items_on_order_idspree_line_itemsFCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")R--Wtablespree_line_itemsspree_line_itemsECREATE 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) DEFAULT NULL, "updated_at" datetime(6) 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) g%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesqCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")ZO%1indexindex_spree_prices_on_country_isospree_pricespCREATE INDEX "index_spree_prices_on_country_iso" ON "spree_prices" ("country_iso")%%tablespree_pricesspree_pricesoCREATE TABLE "spree_prices" ("id" integer NOT NULL PRIMARY KEY, "variant_id" integer NOT NULL, "amount" decimal(10,2) DEFAULT NULL, "currency" varchar DEFAULT NUe77itablespree_payment_methodsspree_payment_methodsfCREATE 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) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "auto_capture" boolean DEFAULT NULL, "preferences" text DEFAULT NULL, "preference_source" varchar DEFAULT NULL, "position" integer DEFAULT 0, "available_to_users" boolean DEFAULT 1, "available_to_admin" boolean DEFAULT 1, "type_before_removal" varchar)                O' + )=MNO r c7Yindexindex_spree_in.-GG[tablespree_tax_rate_tax_categoriesspree_tax_rate_tax_categoriesACREATE TABLE "spree_tax_rate_tax_categories" ("id" integer NOT NULL PRIMARY KEY, "tax_category_id" integer NOT NULL, "tax_rate_id" integer NOT NULL, CONSTRAINT "fk_rails_499313ce8e" FOREIGN KEY ("tax_category_id") REFERENCES "spree_tax_categories" ("id") , CONSTRAINT "fk_rails_3e6fe87e12" FOREIGN KEY ("tax_rate_id") REFERENCES "spree_tax_rates" ("id") )!,S7Eindexindex_inventory_units_on_variant_idspree_inventory_units@CREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")$+U7Iindexindex_inventory_units_on_shipment_idspree_inventory_units?CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")3*c7Yindexindex_spree_inventory_units_on_line_item_idspree_inventory_units>CREATE INDEX "index_spree_inventory_units_on_line_item_id" ON "spree_inventory_units" ("line_item_id")*)]7Mindexindex_spree_inventory_units_on_carton_idspree_inventory_units=CREATE INDEX "index_spree_inventory_units_on_carton_id" ON "spree_inventory_units" ("carton_id")(77Ktablespree_inventory_unitsspree_inventory_unitsAAtablespree_store_credit_reasonsspree_store_credit_reasons6CREATE 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)FmEmindexindex_spree_variant_property_rules_on_product_idspree_variant_property_rulesCREATE INDEX "index_spree_N/Lg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesqCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency") KO%1indexindex_spree_prices_on_country_isospree_pricespCREATE INDEX "index_spree_prices_on_country_iso" ON "spree_prices" ("country_iso")^J%%tablespree_pricesspree_pricesoCREATE TABLE "spree_prices" ("id" integer NOT NULL PRIMARY KEY, "variant_id" integer NOT NULL, "amount" decimal(10,2) NOT 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)IG+!indexindex_spree_addrJ=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"))<EEStablespree_variant_property_rulesspree_variant_property_rulesCREATE TABLE "spree_variant_property_rules" ("id" integer NOT NULL PRIMARY KEY, "product_id" integer DEFAULT NULL, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL, "apply_to_all" boolean DEFAULT 1 NOT NULL)jF??atablespree_store_credit_eventsspree_store_credit_eventsCREATE TABLE "spree_store_credit_events" ("id" integer NOT NULL PRIMARY KEY, "store_credit_id" integer NOT NULL, "action" varchar NOT NULL, "amount" decimal(8,2) DEFAULT NULL, "user_total_amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "authorization_code" varchar NOT NULL, "deleted_at" datetime DEFAULT NULL, "originator_type" varchar DEFAULT NULL, "originator_id" integer DEFAULT NULL, "created_at" datetime(6) DEFAULT NULL, "updated_at" datetime(6) DEFAULT NULL, "amount_remaining" decimal(8,2) DEFAULT NULL, "store_credit_reason_id" integer DEFAULT NULL)   $>m @ $  NN##ctablespree_usersspree_usersCREATE 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)OQ#5indexindex_spree_users_on_spree_api_keyspree_users8CREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")4##Etablespree_usersspree_usersCREATE 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,TR#indexindex_spree_users_on_reset_password_token_solidus_auth_devisespree_users;CREATE UNIQUE INDEX "index_spree_users_on_reset_password_token_solidus_auth_devise" ON "spree_users" ("reset_password_token")QK#)indexindex_spree_users_on_deleted_atspree_users:CREATE INDEX "index_spree_users_on_deleted_at" ON "spree_users" ("deleted_at")jP-#indexemail_idx_uniquespree_users9CREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email")0Me)]indexindex_spree_variants_on_shipping_category_idspree_variantsCREATE INDEX "index_spree_variants_on_shipping_category_id" ON "spree_variants" ("shipping_category_id")/Lg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesqCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency") KO%1indexindex_spree_prices_on_country_isospree_pricespCREATE INDEX "index_spree_prices_on_country_iso" ON "spree_prices" ("country_iso")^J%%tablespree_pricesspree_pricesoCREATE TABLE "spree_prices" ("id" integer NOT NULL PRIMARY KEY, "variant_id" integer NOT NULL, "amount" decimal(10,2) NOT 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)IG+!indexindex_spree_addresses_on_namespree_addressesCREATE INDEX "index_spree_addresses_on_name" ON "spree_addresses" ("name")MHq?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")>Gg?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")