SQLite format 3@ tt-  gS//Qtablespree_calculatorsspree_calculatorsCREATE TABLE "spree_calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer, "calculable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "preferences" text) Y%Oindexindex_assets_on_viewable_type_and_typespree_assetsCREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")C%%indexindex_assets_on_viewable_idspree_assetsCREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id")Q%%etablespree_assetsspree_assetsCREATE TABLE "spree_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "viewable_type" varchar(255), "attachment_width" integer, "attachment_height" integer, "attachment_file_size" integer, "position" integer, "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "type" varchar(75), "attachment_updated_at" datetime, "alt" text, "created_at" datetime, "updated_at" datetime)I u/{indexindex_spree_adjustments_on_source_id_and_source_typespree_adjustmentsCREATE INDEX "index_spree_adjustments_on_source_id_and_source_type" ON "spree_adjustments" ("source_id", "source_type") 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")F//;tablespree_adjustmentsspree_adjustments CREATE TABLE "spree_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "source_type" varchar(255), "adjustable_id" integer, "adjustable_type" varchar(255), "amount" decimal(10,2), "label" varchar(255), "mandatory" boolean, "eligible" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "state" varchar(255), "order_id" integer, "included" boolean DEFAULT 'f')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")P++Wtablespree_addressesspree_addressesCREATE TABLE "spree_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar(255), "lastname" varchar(255), "address1" varchar(255), "address2" varchar(255), "city" varchar(255), "zipcode" varchar(255), "phone" varchar(255), "state_name" varchar(255), "alternative_phone" varchar(255), "company" varchar(255), "state_id" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)}AAtablemercado_pago_notificationsmercado_pago_notificationsCREATE TABLE "mercado_pago_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "topic" varchar(255), "operatioˁD9(qv\eIR8A(1!                   SSSxz _ & I}AAtablemercado_pago_notificationsmercado_pago_notificationsCREATE TABLE "mercado_pago_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "topic" varchar(255), "operation_id" varchar(255), "created_at" datet}AAtablemercado_pago_notificationsmercado_pago_notificationsCREATE TABLE "mercado_pago_notifications" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "topic" varchar(255), "operation_id" varchar(255), "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)P++Wtablespree_addressesspree_addressesCREATE TABLE "spree_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar(255), "lastname" varchar(255), "address1" varchar(255), "address2" varchar(255), "city" varchar(255), "zipcode" varchar(255), "phone" varchar(255), "state_name" varchar(255), "alternative_phone" varchar(255), "company" varchar(255), "state_id" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime)S+9indexindex_spree_addresses_on_country_idspree_addressesCREATE INDEX "index_spree_addresses_on_country_id" ON "spree_addresses" ("country_id")E+)indexindex_addresses_on_firstnamespree_addressesCREATE INDEX "index_addresses_on_firstname" ON "spree_addresses" ("firstname")C+%indexindex_addresses_on_lastnamespree_addressesCREATE INDEX "index_addresses_on_lastname" ON "spree_addresses" ("lastname")O+1indexindex_spree_addresses_on_state_idspree_addressesCREATE INDEX "index_spree_addresses_on_state_id" ON "spree_addresses" ("state_id")F//;tablespree_adjustmentsspree_adjustments CREATE TABLE "spree_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "source_type" varchar(255), "adjustable_id" integer, "adjustable_type" varchar(255), "amount" decimal(10,2), "label" varchar(255), "mandatory" boolean, "eligible" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "state" varchar(255), "order_id" integer, "included" boolean DEFAULT 'f')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") G/7indexindex_adjustments_on_order_idspree_adjustments CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_id") S/9indexindex_spree_adjustments_on_eligiblespree_adjustments CREATE INDEX "index_spree_adjustments_on_eligible" ON "spree_adjustments" ("eligible") S/9indexindex_spree_adjustments_on_order_idspree_adjustments CREATE INDEX "index_spree_adjustments_on_order_id" ON "spree_adjustments" ("order_id")I u/{indexindex_spree_adjustments_on_source_id_and_source_typespree_adjustmentsCREATE INDEX "index_spree_adjustments_on_source_id_and_source_type" ON "spree_adjustments" ("source_id", "source_type")Q%%etablespree_assetsspree_assetsCREATE TABLE "spree_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "viewable_type" varchar(255), "attachment_width" integer, "attachment_height" integer, "attachment_file_size" integer, "position" integer, "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "type" varchar(75), "attachment_updated_at" datetime, "alt" text, "created_at" datetime, "updated_at" datetime)C%%indexindex_assets_on_viewable_idspree_assetsCREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id") Y%Oindexindex_assets_on_viewable_type_and_typespree_assetsCREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")//Qtablespree_calculatorsspree_calculatorsCREATE TABLE "spree_calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer, "calculable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "preferences" text)  ?#g M f )Ymi O7=indexindex!#S7Eindexindex_inventory_units_on_variant_idspree_inventory_units&CREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")b/indexindex_spree_calculators_on_calculable_id_and_calculable_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_calculable_id_and_calculable_typb/indexindex_spree_calculators_on_calculable_id_and_calculable_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_calculable_id_and_calculable_type" ON "spree_calculators" ("calculable_id", "calculable_type")Y/Cindexindex_spree_calculators_on_id_and_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_id_and_type" ON "spree_calculators" ("id", "type")a55etablespree_configurationsspree_configurationsCREATE TABLE "spree_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(50), "created_at" datetime, "updated_at" datetime)1c5Windexindex_spree_configurations_on_name_and_typespree_configurationsCREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "type")#++}tablespree_countriesspree_countriesCREATE TABLE "spree_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_name" varchar(255), "iso" varchar(255), "iso3" varchar(255), "name" varchar(255), "numcode" integer, "states_required" boolean DEFAULT 'f', "updated_at" datetime)C111tablespree_credit_cardsspree_credit_cardsCREATE TABLE "spree_credit_cards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "month" varchar(255), "year" varchar(255), "cc_type" varchar(255), "last_digits" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255), "created_at" datetime, "updated_at" datetime, "name" varchar(255), "user_id" integer, "payment_method_id" integer)!Y1Eindexindex_spree_credit_cards_on_address_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_address_id" ON "spree_credit_cards" ("address_id")6g1aindexindex_spree_credit_cards_on_payment_method_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_payment_method_id" ON "spree_credit_cards" ("payment_method_id")S19indexindex_spree_credit_cards_on_user_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_user_id" ON "spree_credit_cards" ("user_id")))Ytablespree_gatewaysspree_gatewaysCREATE TABLE "spree_gateways" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "server" varchar(255) DEFAULT 'test', "test_mode" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "preferences" text)I)%indexindex_spree_gateways_on_activespree_gatewaysCREATE INDEX "index_spree_gateways_on_active" ON "spree_gateways" ("active")O)1indexindex_spree_gateways_on_test_modespree_gateways CREATE INDEX "index_spree_gateways_on_test_mode" ON "spree_gateways" ("test_mode")l77wtablespree_inventory_unitsspree_inventory_units!CREATE TABLE "spree_inventory_units" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "state" varchar(255), "variant_id" integer, "order_id" integer, "shipment_id" integer, "return_authorization_id" integer, "created_at" datetime, "updated_at" datetime, "pending" boolean DEFAULT 't', "line_item_id" integer)3c7Yindexindex_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") O7=indexindex_inventory_units_on_order_idspree_inventory_units#CREATE INDEX "index_inventory_units_on_order_id" ON "spree_inventory_units" ("order_id")T!y7indexindex_spree_inventory_units_on_return_authorization_idspree_inventory_units$CREATE INDEX "index_spree_inventory_units_on_return_authorization_id" ON "spree_inventory_units" ("return_authorization_id")                  bb A H _4-33Qtablespree_I2mEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variants6CREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")y1 E/$"U7Iindexindex_inventory_units_on_shipment_idspree_inventory_units%CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")!#S7Eindexindex_inventory_units_$"U7Iindexindex_inventory_units_on_shipment_idspree_inventory_units%CREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")!#S7Eindexindex_inventory_units_on_variant_idspree_inventory_units&CREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")P$--Stablespree_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, "updated_at" datetime, "currency" varchar(255), "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, "pre_tax_amount" decimal(8,2) DEFAULT 0.0)%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")(&_-Qindexindex_spree_line_items_on_tax_category_idspree_line_items*CREATE INDEX "index_spree_line_items_on_tax_category_id" ON "spree_line_items" ("tax_category_id")'U-=indexindex_spree_line_items_on_variant_idspree_line_items+CREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")p(//tablespree_log_entriesspree_log_entries,CREATE TABLE "spree_log_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "source_type" varchar(255), "details" text, "created_at" datetime, "updated_at" datetime)I)u/{indexindex_spree_log_entries_on_source_id_and_source_typespree_log_entries-CREATE INDEX "index_spree_log_entries_on_source_id_and_source_type" ON "spree_log_entries" ("source_id", "source_type") *11Atablespree_option_typesspree_option_types.CREATE TABLE "spree_option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "presentation" varchar(100), "position" integer DEFAULT 0 NOT NULL, "created_at" datetime, "updated_at" datetime)+U1=indexindex_spree_option_types_on_positionspree_option_types/CREATE INDEX "index_spree_option_types_on_position" ON "spree_option_types" ("position")&,GGKtablespree_option_types_prototypesspree_option_types_prototypes0CREATE TABLE "spree_option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)-33Qtablespree_option_valuesspree_option_values1CREATE TABLE "spree_option_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer, "name" varchar(255), "presentation" varchar(255), "option_type_id" integer, "created_at" datetime, "updated_at" datetime)1.c3Yindexindex_spree_option_values_on_option_type_idspree_option_values2CREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")/W3Aindexindex_spree_option_values_on_positionspree_option_values3CREATE INDEX "index_spree_option_values_on_position" ON "spree_option_values" ("position")"0EEGtablespree_option_values_variantsspree_option_values_variants4CREATE TABLE "spree_option_values_variants" ("variant_id" integer, "option_value_id" integer)y1 E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variants5CREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_values_variants" ("variant_id", "option_value_id")                ff2t Q  B }4a?;;3tablespree_orders_promotionsspree_orders_promotI2mEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variants6CREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")I2mEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variants6CREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")03%%#tablespree_ordersspree_orders7CREATE 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(255), "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, "shipping_method_id" integer, "shipment_state" varchar(255), "payment_state" varchar(255), "email" varchar(255), "special_instructions" text, "created_at" datetime, "updated_at" datetime, "currency" varchar(255), "last_ip_address" varchar(255), "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(255) 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 'f', "considered_risky" boolean DEFAULT 'f', "guest_token" varchar(255), "state_lock_version" integer DEFAULT 0 NOT NULL) 4O%1indexindex_spree_orders_on_approver_idspree_orders9CREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id")5W%Aindexindex_spree_orders_on_bill_address_idspree_orders:CREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id")6Q%5indexindex_spree_orders_on_completed_atspree_orders;CREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")-7e%]indexindex_spree_orders_on_confirmation_deliveredspree_ordersCREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id")}:E%indexindex_spree_orders_on_numberspree_orders?CREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number");W%Aindexindex_spree_orders_on_ship_address_idspree_orders@CREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")!<]%Mindexindex_spree_orders_on_shipping_method_idspree_ordersACREATE INDEX "index_spree_orders_on_shipping_method_id" ON "spree_orders" ("shipping_method_id")5=k%gindexindex_spree_orders_on_user_id_and_created_by_idspree_ordersBCREATE INDEX "index_spree_orders_on_user_id_and_created_by_id" ON "spree_orders" ("user_id", "created_by_id")>G%!indexindex_spree_orders_on_user_idspree_ordersCCREATE INDEX "index_spree_orders_on_user_id" ON "spree_orders" ("user_id")?;;3tablespree_orders_promotionsspree_orders_promotionsDCREATE TABLE "spree_orders_promotions" ("order_id" integer, "promotion_id" integer)b@;indexindex_spree_orders_promotions_on_order_id_and_promotion_idspree_orders_promotionsECREATE INDEX "index_spree_orders_promotions_on_order_id_and_promotion_id" ON "spree_orders_promotions" ("order_id", "promotion_id") AEEtablespree_payment_capture_eventsspree_payment_capture_eventsFCREATE 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, "updated_at" datetime)                 a5 [ 7 u VJIBmEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_eventsGCREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_IBmEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_eventsGCREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_events" ("payment_id")'C77mtablespree_payment_methodsspree_payment_methodsHCREATE TABLE "spree_payment_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "deleted_at" datetime, "created_at" datetime, "updated_at" datetime, "display_on" varchar(255), "auto_capture" boolean, "preferences" text)/Da7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsJCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")hE)) tablespree_paymentsspree_paymentsKCREATE TABLE "spree_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "source_id" integer, "source_type" varchar(255), "payment_method_id" integer, "state" varchar(255), "response_code" varchar(255), "avs_response" varchar(255), "created_at" datetime, "updated_at" datetime, "identifier" varchar(255), "cvv_response_code" varchar(255), "cvv_response_message" varchar(255)) FM)-indexindex_spree_payments_on_order_idspree_paymentsLCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")&G_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsMCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id")=Ho)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentsNCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type")QI//Qtablespree_preferencesspree_preferencesOCREATE TABLE "spree_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "key" varchar(255), "created_at" datetime, "updated_at" datetime)JI/3indexindex_spree_preferences_on_keyspree_preferencesPCREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")YK%%utablespree_pricesspree_pricesQCREATE TABLE "spree_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer NOT NULL, "amount" decimal(10,2), "currency" varchar(255), "deleted_at" datetime) LM%-indexindex_spree_prices_on_deleted_atspree_pricesRCREATE INDEX "index_spree_prices_on_deleted_at" ON "spree_prices" ("deleted_at")/Mg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesSCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")NAA'tablespree_product_option_typesspree_product_option_typesTCREATE TABLE "spree_product_option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer, "product_id" integer, "option_type_id" integer, "created_at" datetime, "updated_at" datetime)MOqAuindexindex_spree_product_option_types_on_option_type_idspree_product_option_typesUCREATE INDEX "index_spree_product_option_types_on_option_type_id" ON "spree_product_option_types" ("option_type_id");PeA]indexindex_spree_product_option_types_on_positionspree_product_option_typesVCREATE INDEX "index_spree_product_option_types_on_position" ON "spree_product_option_types" ("position")AQiAeindexindex_spree_product_option_types_on_product_idspree_product_option_typesWCREATE INDEX "index_spree_product_option_types_on_product_id" ON "spree_product_option_types" ("product_id")%R==]tablespree_product_propertiesspree_product_propertiesXCREATE TABLE "spree_product_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "product_id" integer, "property_id" integer, "created_at" datetime, "updated_at" datetime, "position" integer DEFAULT 0)                   |;r9 2 J ' O$ 63Sa=Uindexindex_spree_product_properties_on_positionspree_product_propertiesYCREATE INDEX "index_spree_product_properties_on_position" ON "spree_product_properties" ("position")-TY=Qindexindex_product_properties_on_product_idspree_product_propertiesZCREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id")C%%indexindex_taxons_on_taxonomy_idspree_taxonsCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")?CCCtablespree_tokenized_permissionsspree_tokenized_permissionsCREATE TABLE "spree_tokenized_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissable_id" integer, "permissable_type" varchar(255), "token" varchar(255), "created_at" datetime, "updated_at" datetime):@GCuindexindex_tokenized_name_and_typespree_tokenized_permissionsCREATE INDEX "index_tokenized_name_and_type" ON "spree_tokenized_permissions" ("permissable_id", "permissable_type")~A))5tablespree_trackersspree_trackersCREATE TABLE "spree_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environm7:%%/tablespree_taxonsspree_taxonsCREATE TABLE "spree_taxons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "position" integer DEFAULT 0, "name" varchar(255) NOT NULL, "permalink" varchar(255), "taxonomy_id" integer, "lft" integer, "rgt" integer, "icon_file_name" varchar(255), "icon_content_type" varchar(255), "icon_file_size" integer, "icon_updated_at" datetime, "description" text, "created_at" datetime, "updated_at" datetime, "meta_title" varchar(255), "meta_description" varchar(255), "meta_keywords" varchar(255), "depth" integer){;?%indexindex_taxons_on_parent_idspree_taxonsCREATE INDEX "index_taxons_on_parent_id" ON "spree_taxons" ("parent_id"){<?%indexindex_taxons_on_permalinkspree_taxonsCREATE INDEX "index_taxons_on_permalink" ON "spree_taxons" ("permalink")=I%%indexindex_spree_taxons_on_positionspree_taxonsCREATE INDEX "index_spree_taxons_on_position" ON "spree_taxons" ("position")>C%%indexindex_taxons_on_taxonomy_idspree_taxonsCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")?CCCtablespree_tokenized_permissionsspree_tokenized_permissionsCREATE TABLE "spree_tokenized_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissable_id" integer, "permissable_type" varchar(255), "token" varchar(255), "created_at" datetime, "updated_at" datetime):@GCuindexindex_tokenized_name_and_typespree_tokenized_permissionsCREATE INDEX "index_tokenized_name_and_type" ON "spree_tokenized_permissions" ("permissable_id", "permissable_type")~A))5tablespree_trackersspree_trackersCREATE TABLE "spree_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "analytics_id" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)BI)%indexindex_spree_trackers_on_activespree_trackersCREATE INDEX "index_spree_trackers_on_active" ON "spree_trackers" ("active")tC##-tablespree_usersspree_usersCREATE TABLE "spree_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "encrypted_password" varchar(128), "password_salt" varchar(128), "email" varchar(255), "remember_token" varchar(255), "persistence_token" varchar(255), "reset_password_token" varchar(255), "perishable_token" varchar(255), "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "authentication_token" varchar(255), "unlock_token" varchar(255), "locked_at" datetime, "reset_password_sent_at" datetime, "created_at" datetime, "updated_at" datetime, "spree_api_key" varchar(48), "remember_created_at" datetime)jD-#indexemail_idx_uniquespree_usersCREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email")                 .U ~  7 \/.T=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")rS//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) RM#-indexindex_spree_zones_on_default_taxspree_zonesCREATE INDEX "index_spree_zones_on_default_tax" ON "spree_zones" ("default_tax")Q##ytablespree_zonesspree_zonesCREATE TABLE "spree_zones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "default_tax" boolean DEFAULT 'f', "zone_members_count" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)ZP1indexindex_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")OS19indexindex_spree_zone_members_on_zone_idspree_zone_membersCREATE INDEX "index_spree_zone_members_on_zone_id" ON "spree_zone_members" ("zone_id")EQ#5indexindex_spree_users_on_spree_api_keyspree_usersCREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")|F))1tablespree_variantsspree_variantsCREATE TABLE "spree_variants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar(255) 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 'f', "product_id" integer, "cost_price" decimal(10,2), "position" integer, "cost_currency" varchar(255), "track_inventory" boolean DEFAULT 't', "tax_category_id" integer, "updated_at" datetime)GQ)5indexindex_spree_variants_on_deleted_atspree_variantsCREATE INDEX "index_spree_variants_on_deleted_at" ON "spree_variants" ("deleted_at")HO)1indexindex_spree_variants_on_is_masterspree_variantsCREATE INDEX "index_spree_variants_on_is_master" ON "spree_variants" ("is_master") IM)-indexindex_spree_variants_on_positionspree_variantsCREATE INDEX "index_spree_variants_on_position" ON "spree_variants" ("position")JQ)5indexindex_spree_variants_on_product_idspree_variantsCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")}KC)indexindex_spree_variants_on_skuspree_variantsCREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku")!L[)Iindexindex_spree_variants_on_tax_category_idspree_variantsCREATE INDEX "index_spree_variants_on_tax_category_id" ON "spree_variants" ("tax_category_id")!M[)Iindexindex_spree_variants_on_track_inventoryspree_variantsCREATE INDEX "index_spree_variants_on_track_inventory" ON "spree_variants" ("track_inventory"){N11tablespree_zone_membersspree_zone_membersCREATE TABLE "spree_zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_id" integer, "zoneable_type" varchar(255), "zone_id" integer, "created_at" datetime, "updated_at" datetime)     p^L:(tbP>, x f T B 0  | j X F 4 "  n \ J 8 &   r ` N < *   v d R @ .  zhVD2 ~lZH6$zgTA.p]J7$!)20141112193566 )20141112193565)20141112193564)20141112193563)20141112193562)20141112193561)20141112193560)20141112193559)20141112193558)20141112193557)20141112193556)20141112193555)20141112193554)20141112193553)20141112193552)20141112193551)20141112193550)20141112193549)20141112193548)20141112193547 )20141112193546 )20141112193545 )20141112193544 )20141112193543 )20141112193542)20141112193541)20141112193540)20141112193539)20141112193538)20141112193537)20141112193536)20141112193535)20141112193534)20141112193533)20141112193532~)20141112193531})20141112193530|)20141112193529{)20141112193528z)20141112193527y)20141112193526x)20141112193525w)20141112193524v)20141112193523u)20141112193522t)20141112193521s)20141112193520r)20141112193519q)20141112193518p)20141112193517o)20141112193516n)20141112193515m)20141112193514l)20141112193513k)20141112193512j)20141112193511i)20141112193510h)20141112193509g)20141112193508f)20141112193507e)20141112193506d)20141112193505c)20141112193504b)20141112193503a)20141112193502`)20141112193501_)20141112193500^)20141112193499])20141112193498\)20141112193497[)20141112193496Z)20141112193495Y)20141112193494X)20141112193493W)20141112193492V)20141112193491U)20141112193490T)20141112193489S)20141112193488R)20141112193487Q)20141112193486P)20141112193485O)20141112193484N)20141112193483M)20141112193482L)20141112193481K)20141112193480J)20141112193479I)20141112193478H)20141112193477G)20141112193476F)20141112193475E)20141112193474D)20141112193473C)20141112193472B)20141112193471A)20141112193470@)20141112193469?)20141112193468>)20141112193467=)20141112193466<)20141112193465;)20141112193464:)201411121934639)201411121934628)201411121934617)201411121934606)201411121934595)201411121934584)201411121934573)201411121934562)201411121934551)201411121934540)20141112193453/)20141112193452.)20141112193451-)20141112193450,)20141112193449+)20141112193448*)20141112193447))20141112193446()20141112193445')20141112193444&)20141112193443%)20141112193442$)20141112193441#)20141112193440")20141112193439!)20141112193438 )20141112193437)20141112193436)20141112193435)20141112193434)20141112193433)20141112193432)20141112193431)20141112193430)20141112193429)20141112193428)20141112193427)20141112193426)20141112193425)20141112193424)20141112193423)20141112193422)20141112193421)20141112193420)20141112193419 )20141112193418 )20141112193417 )20141112193416 )20141112193415 )20141112193414)20141112193413)20141112193412)20141112193411)20141112193410)20141112193409)20141112193408)20141112193407)20141202172111 |iVC0 r_L9& { h U B /  q ^ K 8 %  z g T A .   p ] J 7 $  y f S @ -  o\I6#xeR?,lXD0|hT@,xdP<()20141112193566)20141112193565)20141112193564)20141112193563)20141112193562)20141112193561)20141112193560)20141112193559)20141112193558)20141112193557)20141112193556)20141112193555)20141112193554)20141112193553)20141112193552)20141112193551)20141112193550)20141112193549)20141112193548)20141112193547)20141112193546)20141112193545)20141112193544)20141112193543)20141112193542)20141112193541)20141112193540)20141112193539)20141112193538)20141112193537)20141112193536)20141112193535)20141112193534)20141112193533)20141112193532)20141112193531~)20141112193530})20141112193529|)20141112193528{)20141112193527z)20141112193526y)20141112193525x)20141112193524w)20141112193523v)20141112193522u)20141112193521t)20141112193520s)20141112193519r)20141112193518q)20141112193517p)20141112193516o)20141112193515n)20141112193514m)20141112193513l)20141112193512k)20141112193511j)20141112193510i)20141112193509h)20141112193508g)20141112193507f)20141112193506e)20141112193505d)20141112193504c)20141112193503b)20141112193502a)20141112193501`)20141112193500_)20141112193499^)20141112193498])20141112193497\)20141112193496[)20141112193495Z)20141112193494Y)20141112193493X)20141112193492W)20141112193491V)20141112193490U)20141112193489T)20141112193488S)20141112193487R)20141112193486Q)20141112193485P)20141112193484O)20141112193483N)20141112193482M)20141112193481L)20141112193480K)20141112193479J)20141112193478I)20141112193477H)20141112193476G)20141112193475F)20141112193474E)20141112193473D)20141112193472C)20141112193471B)20141112193470A)20141112193469@)20141112193468?)20141112193467>)20141112193466=)20141112193465<)20141112193464;)20141112193463:)201411121934629)201411121934618)201411121934607)201411121934596)201411121934585)201411121934574)201411121934563)201411121934552)201411121934541)201411121934530)20141112193452/)20141112193451.)20141112193450-)20141112193449,)20141112193448+)20141112193447*)20141112193446))20141112193445()20141112193444')20141112193443&)20141112193442%)20141112193441$)20141112193440#)20141112193439")20141112193438!)20141112193437 )20141112193436)20141112193435)20141112193434)20141112193433)20141112193432)20141112193431)20141112193430)20141112193429)20141112193428)20141112193427)20141112193426)20141112193425)20141112193424)20141112193423)20141112193422)20141112193421)20141112193420)20141112193419)20141112193418 )20141112193417 )20141112193416 )20141112193415 )20141112193414 )20141112193413)20141112193412)20141112193411)20141112193410)20141112193409)20141112193408)20141112193407) 20141202172111