SQLite format 3@ C-e++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)1c5Windexindex_spree_configurations_on_name_and_typespree_configurationsCREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "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)} //)tablespree_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) 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")# %% tablespree_assetsspree_assets CREATE 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) G/7indexindex_adjustments_on_order_idspree_adjustments CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_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), "originator_id" integer, "originator_type" varchar(255), "amount" decimal(8,2), "label" varchar(255), "mandatory" boolean, "locked" boolean, "eligible" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)C+%indexindex_addresses_on_lastnamespree_addressesCREATE INDEX "index_addresses_on_lastname" ON "spree_addresses" ("lastname")E+)indexindex_addresses_on_firstnamespree_addressesCREATE INDEX "index_addresses_on_firstname" ON "spree_addresses" ("firstname")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)G--Atablespree_activatorsspree_activatorsCREATE TABLE "spree_activators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "expires_at" datetime, "starts_at" datetime, "name" varchar(255), "event_name" varchar(255), "type" varchar(255), "usage_limit" integer, "match_policy" varchar(255) DEFAULT 'all', "code" varchar(255), "advertise" boolean DEFAULT 'f', "path" varchar(255), "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrZE)|thnVcI^5U~GO5@+ 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$!)20141202172111 )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{)20141112193529z)20141112193528y)20141112193527x)20141112193526w)20141112193525v)20141112193524u)20141112193523t)20141112193522s)20141112193521r)20141112193520q)20141112193519p)20141112193518o)20141112193517n)20141112193516m)20141112193515l)20141112193514k)20141112193513j)20141112193512i)20141112193511h)20141112193510g)20141112193509f)20141112193508e)20141112193507d)20141112193506c)20141112193505b)20141112193504a)20141112193503`)20141112193502_)20141112193501^)20141112193500])20141112193499\)20141112193498[)20141112193497Z)20141112193496Y)20141112193495X)20141112193494W)20141112193493V)20141112193492U)20141112193491T)20141112193490S)20141112193489R)20141112193488Q)20141112193487P)20141112193486O)20141112193485N)20141112193484M)20141112193483L)20141112193482K)20141112193481J)20141112193480I)20141112193479H)20141112193478G)20141112193477F)20141112193476E)20141112193475D)20141112193474C)20141112193473B)20141112193472A)20141112193471@)20141112193470?)20141112193469>)20141112193468=)20141112193467<)20141112193466;)20141112193465:)201411121934649)201411121934638)201411121934627)201411121934616)201411121934605)201411121934594)201411121934583)201411121934572)201411121934561)201411121934550)20141112193454/)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 |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<()20141202172111)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  % spree_stores? spree_shipping_categories7 spree_stock_locations               s`<s G GLLY@//gtabQ %%etablespree_assetsspree_assets CREATE 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)))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) //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)q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")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)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") %% tablespree_assetsspree_assets CREATE 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) C%%indexindex_assets_on_viewable_idspree_assets CREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id") Y%Oindexindex_assets_on_viewable_type_and_typespree_assets CREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")//)tablespree_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)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")~))1tablespree_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)  O K (P&++}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 't', "updated_at" datetime)33Qtablespree_option_valuesspree_option_values!CREATE 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)&GGKtablespree_option_types_prototypesspree_option_types_prototypes CREATE TABLE "spree_option_types_prototypes" ("prototype_id" integer, "option_type_id" integer) 11Atablespree_option_typesspree_option_typesCREATE 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)11tablespree_mail_methodsspree_mail_methodsCREATE TABLE "spree_mail_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)p//tablespree_log_entriesspree_log_entriesCREATE 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) U-=indexindex_spree_line_items_on_variant_idspree_line_itemsCREp//tablespree_log_entriesspree_log_entriesCREATE 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) 11Atablespree_option_typesspree_option_typesCREATE 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)&GGKtablespree_option_types_prototypesspree_option_types_prototypes CREATE TABLE "spree_option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)33Qtablespree_option_valuesspree_option_values!CREATE 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)"EEGtablespree_option_values_variantsspree_option_values_variants"CREATE TABLE "spree_option_values_variants" ("variant_id" integer, "option_value_id" integer)y  E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variants#CREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_values_variants" ("variant_id", "option_value_id")I!mEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variants$CREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")(AA'tablespree_product_option_typesspree_product_option_types,CREATE 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)%)==]tablespree_product_propertiesspree_product_properties-CREATE 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)-*Y=Qindexindex_product_properties_on_product_idspree_product_properties.CREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id")           NK  e  9 HHHL}S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at")u~?%indexindex_spree_stores_on_urlspree_storesCREATE INDEX "index_spree_stores_on_url" ON "spree_stores" ("url")S+9indexindex_spree_addresses_on_country_idspree_addressesCREATE INDEX "index_spree_addr}S-9indexindex_spree_promotions_on_starts_atspree_promotionsCREATE INDEX "index_spree_promotions_on_starts_at" ON "spree_promotions" ("starts_at")u~?%indexindex_spree_stores_on_urlspree_storesCREATE INDEX "index_spree_stores_on_url" ON "spree_stores" ("url")S+9indexindex_spree_addresses_on_country_idspree_addressesCREATE INDEX "index_spree_addresses_on_country_id" ON "spree_addresses" ("country_id")O+1indexindex_spree_addresses_on_state_idspree_addressesCREATE INDEX "index_spree_addresses_on_state_id" ON "spree_addresses" ("state_id")Iu/{indexindex_spree_adjustments_on_source_id_and_source_typespree_adjustmentsiCREATE INDEX "index_spree_adjustments_on_source_id_and_source_type" ON "spree_adjustments" ("source_id", "source_type") Y1Eindexindex_spree_credit_cards_on_address_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_address_id" ON "spree_credit_cards" ("address_id")I)%indexindex_spree_gateways_on_activespree_gatewaysCREATE INDEX "index_spree_gateways_on_active" ON "spree_gateways" ("active")O)1indexindex_spree_gateways_on_test_modespree_gatewaysCREATE INDEX "index_spree_gateways_on_test_mode" ON "spree_gateways" ("test_mode")Uy7indexindex_spree_inventory_units_on_return_authorization_idspree_inventory_unitsCREATE INDEX "index_spree_inventory_units_on_return_authorization_id" ON "spree_inventory_units" ("return_authorization_id")Ju/{indexindex_spree_log_entries_on_source_id_and_source_typespree_log_entriesCREATE INDEX "index_spree_log_entries_on_source_id_and_source_type" ON "spree_log_entries" ("source_id", "source_type") O%1indexindex_spree_orders_on_approver_idspree_ordersCREATE INDEX "index_spree_orders_on_approver_id" ON "spree_orders" ("approver_id") W%Aindexindex_spree_orders_on_bill_address_idspree_ordersCREATE INDEX "index_spree_orders_on_bill_address_id" ON "spree_orders" ("bill_address_id"). e%]indexindex_spree_orders_on_confirmation_deliveredspree_ordersCREATE INDEX "index_spree_orders_on_confirmation_delivered" ON "spree_orders" ("confirmation_delivered") Y%Eindexindex_spree_orders_on_considered_riskyspree_ordersCREATE INDEX "index_spree_orders_on_considered_risky" ON "spree_orders" ("considered_risky") S%9indexindex_spree_orders_on_created_by_idspree_ordersCREATE INDEX "index_spree_orders_on_created_by_id" ON "spree_orders" ("created_by_id") W%Aindexindex_spree_orders_on_ship_address_idspree_ordersCREATE INDEX "index_spree_orders_on_ship_address_id" ON "spree_orders" ("ship_address_id")"]%Mindexindex_spree_orders_on_shipping_method_idspree_ordersCREATE INDEX "index_spree_orders_on_shipping_method_id" ON "spree_orders" ("shipping_method_id")c;indexindex_spree_orders_promotions_on_order_id_and_promotion_idspree_orders_promotionsCREATE INDEX "index_spree_orders_promotions_on_order_id_and_promotion_id" ON "spree_orders_promotions" ("order_id", "promotion_id")o)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentsCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type")<eA]indexindex_spree_product_option_types_on_positionspree_product_option_typesCREATE INDEX "index_spree_product_option_types_on_position" ON "spree_product_option_types" ("position")4a=Uindexindex_spree_product_properties_on_positionspree_product_propertiesCREATE INDEX "index_spree_product_properties_on_position" ON "spree_product_properties" ("position")  h S +iiiiiiiiKl775tablespree_products_taxonsspree_products_taxons4CREATE TABLE "spree_products_taxons" ("product_id" integer, "taxon_id" integer, "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer)"~EEGtablespree_shipping_methods_zonesspree_shipping_methods_zoneskCREATE TABLE "spree_shipping_methods_zones" ("shipping_method_id" integer, "zone_id" integer)'n[7Iindexindex_spree_products_taxons_on_taxon_idspree_products_taxons7CREATE INDEX "index_spree_products_taxons_on_taxon_id" ON "spree_products_taxons" ("taxon_id")-m_7Qindexindex_spree_products_taxons_on_product_idspree_products_taxons6CREATE INDEX "index_spree_products_taxons_on_product_id" ON "spree_products_taxons" ("product_id")P>77tablespree_payment_methodsspree_payment_methods(CREATE 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'h77mtablespree_payment_methodsspree_payment_methods(CREATE 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) P%%stablespree_pricesspree_pricesbCREATE TABLE "spree_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer NOT NULL, "amount" decimal(8,2), "currency" varchar(255), "deleted_at" datetime)0ZYCQindexindex_promotion_rules_users_on_user_idspree_promotion_rules_usersaCREATE INDEX "index_promotion_rules_users_on_user_id" ON "spree_promotion_rules_users" ("user_id")NYmCyindexindex_promotion_rules_users_on_promotion_rule_idspree_promotion_rules_users`CREATE INDEX "index_promotion_rules_users_on_promotion_rule_id" ON "spree_promotion_rules_users" ("promotion_rule_id")XCCCtablespree_promotion_rules_usersspree_promotion_rules_users_CREATE TABLE "spree_promotion_rules_users" ("user_id" integer, "promotion_rule_id" integer)WM79indexindex_promotion_rules_on_user_idspree_promotion_rules^CREATE INDEX "index_promotion_rules_on_user_id" ON "spree_promotion_rules" ("user_id")_7]indexindex_promotion_rules_on_product_group_idspree_promotion_rules]CREATE INDEX "index_promotion_rules_on_product_group_id" ON "spree_promotion_rules" ("product_group_id")/77wtablespree_promotion_rulesspree_promotion_rules\CREATE TABLE "spree_promotion_rules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "activator_id" integer, "user_id" integer, "product_group_id" integer, "type" varchar(255), "created_at" datetime, "updated_at" datetime, "code" varchar(255));;?tablespree_promotion_actionsspree_promotion_actions[CREATE TABLE "spree_promotion_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "activator_id" integer, "position" integer, "type" varchar(255))SOOwtablespree_promotion_action_line_itemsspree_promotion_action_line_itemsZCREATE TABLE "spree_promotion_action_line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_action_id" integer, "variant_id" integer, "quantity" integer DEFAULT 1)ZRsIindexindex_products_promotion_rules_on_promotion_rule_idspree_products_promotion_rulesYCREATE INDEX "index_products_promotion_rules_on_promotion_rule_id" ON "spree_products_promotion_rules" ("promotion_rule_id")EQeIiindexindex_products_promotion_rules_on_product_idspree_products_promotion_rulesXCREATE INDEX "index_products_promotion_rules_on_product_id" ON "spree_products_promotion_rules" ("product_id")*PIIOtablespree_products_promotion_rulesspree_products_promotion_rulesWCREATE TABLE "spree_products_promotion_rules" ("product_id" integer, "promotion_rule_id" integer)       |z'&y%%#tablespree_ordersspree_orders&CREATE TABLE "spree_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(15), "item_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "total" decimal(8,2) DEFAULT 0.0 NOT NULL, "state" varchar(255), "adjustment_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "user_id" integer, "completed_at" datetime, "bill_address_id" integer, "ship_address_id" integer, "payment_total" decimal(8,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))-*Y=Qindexindex_product_properties_on_product_idspree_product_properties.CREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id") ==!tablespree_product_propertiesspree_product_properties-CREATE 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)(AA'tablespree_product_option_typesspree_product_option_types,CREATE 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) ))Etablespree_paymentsspree_payments)CREATE TABLE "s )){tablespree_paymentsspree_payments)CREATE TABLE "spree_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,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))%)==]tablespree_product_propertiesspree_product_properties-CREATE 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)E%indexindex_spree_orders_on_numberspree_orders'CREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")z%%1tablespree_ordersspree_orders&CREATE TABLE "spree_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(15), "item_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "total" decimal(8,2) DEFAULT 0.0 NOT NULL, "state" varchar(255), "adjustment_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "user_id" integer, "completed_at" datetime, "bill_address_id" integer, "ship_address_id" integer, "payment_total" decimal(8,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)I!mEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variants$CREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")y  E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variants#CREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "spree_option_values_variants" ("variant_id", "option_value_id")"EEGtablespree_option_values_variantsspree_option_values_variants"CREATE TABLE "spree_option_values_variants" ("variant_id" integer, "option_value_id" integer)      *        210/  D  & KKKKKKK-Q)5indexindex_spree_U)=indexindex_spree_products_on_available_onspree_products0CREATE INDEX "index_spree_products_o077+tablespree_products_taxonsspree_products_taxons4CREATE TABLE "spree_products_taxons" ("product_id" integer, "taxon_id" integer)-1_7Qindexindex_spree_products_taxons_on_product_idspree_products_taxons6CREATE INDEX "index_spree_products_taxons_on_product_id" ON "spree_products_ta77+tablespree_products_taxonsspree_products_taxons4CREATE TABLE "spree_products_taxons" (D++7tablespree_shipmentsspree_shipments@CREATE TABLE "spree_shipments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracking" varchar(255), "number" varchar(255), "cost" decimal(8,2), "shipped_at" datetime, "order_id" integer, "shipping_method_id" integer, "address_id" integer, "state" varchar(255), "created_at" datetime, "updated_at" datetime, "stock_location_id" integer)g3--tablespree_propertiesspree_properties8CREATE TABLE "spree_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentation" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)4CCAtablespree_properties_prototypesspree_properties_prototypes9CREATE TABLE "spree_properties_prototypes" ("prototype_id" integer, "property_id" integer)A5--5tablespree_prototypesspree_prototypes:CREATE TABLE "spree_prototypes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) CCtablespree_return_authorizationsspree_return_authorizations;CREATE TABLE "spree_return_authorizations" ("id" INTEGER PI@%%Utablespree_statesspree_statesECREATE TABLE "spree_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country_id" integer, "updated_at" datetime)7##Otablespree_rolesspree_rolesCREATE INDEX "index_spree_roles_users_on_role_id" ON "spree_roles_users" ("role_id"):Q/5indexindex_spree_roles_users_on_user_idspree_roles_users?CREATE INDEX "index_spree_roles_users_on_user_id" ON "spree_roles_users" ("user_id") ++}tablespree_shipmentsspree_shipments@CREATE TABLE "spree_shipments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracking" varchar(255), "number" varchar(255), "cost" decimal(8,2), "shipped_at" datetime, "order_id" integer, "shipping_method_id" integer, "address_id" integer, "state" varchar(255), "created_at" datetime, "updated_at" datetime) ?+indexindex_shipments_on_numberspree_shipmentsACREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number")\=??Gtablespree_shipping_categoriesspree_shipping_categoriesBCREATE TABLE "spree_shipping_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)K{99 tablespree_shipping_methodsspree_shipping_methodsCCREATE TABLE "spree_shipping_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "zone_id" integer, "display_on" varchar(255), "shipping_category_id" integer, "match_none" boolean, "match_all" boolean, "match_one" boolean, "deleted_at" datetime, "created_at" datetime, "updated_at" datetime)L?33?tablespree_state_changesspree_state_changesDCREATE TABLE "spree_state_changes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "previous_state" varchar(255), "stateful_id" integer, "user_id" integer, "stateful_type" varchar(255), "next_state" varchar(255), "created_at" datetime, "updated_at" datetime)%%'tablespree_statesspree_statesECREATE TABLE "spree_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country_id" integer)  64           @AADefault2014-11-12 19:34:25.6417872014-11-12 19:34:25.641787      k G Op##!tablespree_usersspree_usersQCREATE 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, "remember_created_at" datetime, "reset_password_sent_at" datetime, "created_at" datetime, "updated_at" datetime, "api_key" varchar(40))O##ytablespree_zonesspree_zonesVCREATE 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)zN11tablespree_zone_membersspree_zone_membersTCREATE 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)}J))5tablespree_trackersspree_trackersPCREATE 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)9IGCuindexindex_tokenized_name_and_typespree_tokenized_permissionsOCREATE INDEX "index_tokenized_name_and_type" ON "spree_tokenized_permissions" ("permissable_id", "permissable_type")HCCCtablespree_tokenized_permissionsspree_tokenized_permissionsNCREATE 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)GC%%indexindex_taxons_on_taxonomy_idspree_taxonsMCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")zF?%indexindex_taxons_on_permalinkspree_taxonsLCREATE INDEX "index_taxons_on_permalink" ON "spree_taxons" ("permalink")zE?%indexindex_taxons_on_parent_idspree_taxonsKCREATE INDEX "index_taxons_on_parent_id" ON "spree_taxons" ("parent_id")6D%%/tablespree_taxonsspree_taxonsJCREATE 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)hC--tablespree_taxonomiesspree_taxonomiesICREATE TABLE "spree_taxonomies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime, "position" integer DEFAULT 0)mB++tablespree_tax_ratesspree_tax_ratesHCREATE TABLE "spree_tax_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,5), "zone_id" integer, "tax_category_id" integer, "included_in_price" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "name" varchar(255), "show_rate_in_label" boolean DEFAULT 't', "deleted_at" datetime)"A55gtablespree_tax_categoriesspree_tax_categoriesFCREATE TABLE "spree_tax_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "is_default" boolean DEFAULT 'f', "deleted_at" datetime, "created_at" datetime, "updated_at" datetime)            R  "[ [q""" F))itablespree_paymentsspree_payments)CREATE 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), "uncaptured_amount" decimal(10,2) DEFAULT 0.0) +))tablespree_variantsspree_variantsRCREATE TABLE "spree_variants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar(255) DEFAULT '' NOT NULL, "weight" decimal(8,2), "height" decimal(8,2), "width" decimal(8,2), "depth" decimal(8,2), "deleted_at" datetime, "is_master" boolean DX99Ktablespree_shipping_methodsspree_shipping_methodsCCREATE TABLE "spree_shipping_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_on" varchar(255), "deleted_at" datetime, "created_at" datetime, "updated_at" datetime, "tracking_url" varchar(255), "admin_name" varchar(255), "tax_category_id" integer)6e7]indexindex_spree_stock_movements_on_stock_item_idspree_stock_movementssCREATE INDEX "index_spree_stock_movements_on_stock_item_id" ON "spree_stock_movements" ("stock_item_id")B77#tablespree_stock_movementsspree_stock_movementsrCREATE TABLE "spree_stock_movements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stock_item_id" integer, "quantity" integer DEFAULT 0, "action" varchar(255), "created_at" datetime, "updated_at" datetime, "originator_id" integer, "originator_type" varchar(255))gCCUtablespree_return_authorizationsspree_return_authorizations;CREATE TABLE "spree_return_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "state" varchar(255), "amount" decimal(10,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "reason" text, "created_at" datetime, "updated_at" datetime, "stock_location_id" integer)M)-indexindex_spree_payments_on_order_idspree_paymentsdCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")))) tablespree_paymentsspree_payments)CREATE 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)) A99tablespree_shipping_methodsspree_shipping_methodsCCREATE TABLE "spree_shipping_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_on" varchar(255), "deleted_at" datetime, "created_at" datetime, "updated_at" datetime, "tracking_url" varchar(255), "admin_name" varchar(255)) M%indexindex_spree_shipping_method_categories_on_shipping_category_idspree_shipping_method_categoriesoCREATE INDEX "index_spree_shipping_method_categories_on_shipping_category_id" ON "spree_shipping_method_categories" ("shipping_category_id")rMindexindex_spree_shipping_method_categories_on_shipping_method_idspree_shipping_method_categoriesmCREATE INDEX "index_spree_shipping_method_categories_on_shipping_method_id" ON "spree_shipping_method_categories" ("shipping_method_id"),MMKtablespree_shipping_method_categoriesspree_shipping_method_categorieslCREATE 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, "updated_at" datetime)         NNN9 J 6 : C%55)tablespree_shipping_ratesspree_shipping_ratespCREATE TABLE "spree_shipping_rates" ("id" INTEGER PRIMARY KEY AUTOINCRC%55)tablespree_shipping_ratesspree_shipping_ratespCREATE TABLE "spree_shipping_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "shipment_id" integer, "shipping_method_id" integer, "selected" boolean DEFAULT 'f', "cost" decimal(8,2) DEFAULT 0, "created_at" datetime, "updated_at" datetime, "tax_rate_id" integer)5&K5windexspree_shipping_rates_join_indexspree_shipping_ratesqCREATE UNIQUE INDEX "spree_shipping_rates_join_index" ON "spree_shipping_rates" ("shipment_id", "shipping_method_id")B'77#tablespree_stock_transfersspree_stock_transfersuCREATE TABLE "spree_stock_transfers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "reference" varchar(255), "source_location_id" integer, "destination_location_id" integer, "created_at" datetime, "updated_at" datetime, "number" varchar(255))!(W7Aindexindex_spree_stock_transfers_on_numberspree_stock_transferswCREATE INDEX "index_spree_stock_transfers_on_number" ON "spree_stock_transfers" ("number")E)o7qindexindex_spree_stock_transfers_on_source_location_idspree_stock_transfersvCREATE INDEX "index_spree_stock_transfers_on_source_location_id" ON "spree_stock_transfers" ("source_location_id")T*y7indexindex_spree_stock_transfers_on_destination_location_idspree_stock_transfersxCREATE INDEX "index_spree_stock_transfers_on_destination_location_id" ON "spree_stock_transfers" ("destination_location_id")l.77wtablespree_inventory_unitsspree_inventory_unitsCREATE 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)/O7=indexindex_inventory_units_on_order_idspree_inventory_unitsCREATE INDEX "index_inventory_units_on_order_id" ON "spree_inventory_units" ("order_id")$0U7Iindexindex_inventory_units_on_shipment_idspree_inventory_unitsCREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")!1S7Eindexindex_inventory_units_on_variant_idspree_inventory_unitsCREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")J2//Ctablespree_stock_itemsspree_stock_itemseCREATE 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, "updated_at" datetime, "backorderable" boolean DEFAULT 'f', "deleted_at" datetime)23e/]indexindex_spree_stock_items_on_stock_location_idspree_stock_itemsfCREATE INDEX "index_spree_stock_items_on_stock_location_id" ON "spree_stock_items" ("stock_location_id") 4E/Yindexstock_item_by_loc_and_var_idspree_stock_itemsgCREATE INDEX "stock_item_by_loc_and_var_id" ON "spree_stock_items" ("stock_location_id", "variant_id")577[tablespree_stock_locationsspree_stock_locationshCREATE TABLE "spree_stock_locations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "address1" varchar(255), "address2" varchar(255), "city" varchar(255), "state_id" integer, "state_name" varchar(255), "country_id" integer, "zipcode" varchar(255), "phone" varchar(255), "active" boolean DEFAULT 't', "backorderable_default" boolean DEFAULT 'f', "propagate_all_variants" boolean DEFAULT 't', "admin_name" varchar(255))     :  *11tablespree_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), "first_name" varchar(255), "last_name" 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)F7//;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')8G/7indexindex_adjustments_on_order_idspree_adjustments CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustabF7//;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')8G/7indexindex_adjustments_on_order_idspree_adjustments CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_id")#>++}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),?-- tablespree_promotionsspree_promotionsCREATE TABLE "spree_promotions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "expires_at" datetime, "starts_at" datetime, "name" varchar(255), "type" varchar(255), "usage_limit" integer, "match_policy" varchar(255) DEFAULT 'all', "code" varchar(255), "advertise" boolean DEFAULT 'f', "path" varchar(255), "created_at" datetime, "updated_at" datetime)?+indexindex_shipments_on_numberspree_shipmentsACREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number")O+1indexindex_spree_shipments_on_order_idspree_shipmentsjCREATE INDEX "index_spree_shipmen0H%%#tablespree_ordersspree_orders&CREATE 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)}IE%indexindex_spree_orders_on_numberspree_orders'CREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")    fe NAAdefault2014-11-12 19:34:24.6060392014-11-12 19:34:24.606039ttt SRe A@      S 7 pkH%%Atablespree_ordersspree_orders&CREATE 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))vV5)indexpermalink_idx_uniquespree_products{CREATE UNIQUE INDEX "permalink_idx_unique" ON "spree_products" ("slug")TE)indexindex_spree_products_on_namespree_products2CREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")SQ)5indexindex_spree_products_on_deleted_atspree_products1CREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")JG%!indexindex_spree_orders_on_user_idspree_orderszCREATE INDEX "index_spree_orders_on_user_id" ON "spree_orders" ("user_id")KQ%5indexindex_spree_orders_on_completed_atspree_orders|CREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")3Lc7Yindexindex_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")M;;3tablespree_orders_promotionsspree_orders_promotions~CREATE TABLE "spree_orders_promotions" ("order_id" integer, "promotion_id" integer)fN[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")QO//Qtablespree_preferencesspree_preferences*CREATE TABLE "spree_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "key" varchar(255), "created_at" datetime, "updated_at" datetime)PI/3indexindex_spree_preferences_on_keyspree_preferences+CREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")Q))otablespree_productsspree_products/CREATE TABLE "spree_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) DEFAULT '' NOT NULL, "description" text, "available_on" datetime, "deleted_at" datetime, "slug" varchar(255), "meta_description" text, "meta_keywords" varchar(255), "tax_category_id" integer, "shipping_category_id" integer, "created_at" datetime, "updated_at" datetime)RU)=indexindex_spree_products_on_available_onspree_products0CREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on")SQ)5indexindex_spree_products_on_deleted_atspree_products1CREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")TE)indexindex_spree_products_on_namespree_products2CREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")vV5)indexpermalink_idx_uniquespree_products{CREATE UNIQUE INDEX "permalink_idx_unique" ON "spree_products" ("slug") {3210/  p    bb  N @@@@@@@`]/Xg%_indeiW-?indexindex_spree_promotions_on_id_and_type@Y77tablespree_promotion_rulesspree_promoWE)indexindex_spree_products_on_slugspree_productsoCREATE INDEX "index_spree_products_on_slug" ON "spree_products" ("slug")/Xg%_indexindex_spree_prWE)indexindex_spree_products_on_slugspree_productsoCREATE INDEX "index_spree_products_on_slug" ON "spree_products" ("slug")/g%_indexindex_spree_prices_on_variant_id_and_currencyspree_prices3CREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")@Y77tablespree_promotion_rulesspree_promotion_rules\CREATE TABLE "spree_promotion_rules" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_id" integer, "user_id" integer, "product_group_id" integer, "type" varchar(255), "created_at" datetime, "updated_at" datetime, "code" varchar(255), "preferences" text)3Z_7]indexindex_promotion_rules_on_product_group_idspree_promotion_rules]CREATE INDEX "index_promotion_rules_on_product_group_id" ON "spree_promotion_rules" ("product_group_id")[M79indexindex_promotion_rules_on_user_idspree_promotion_rulesCREATE INDEX "index_promotion_rules_on_user_id" ON "spree_promotion_rules" ("user_id");;?tablespree_promotion_actionsspree_promotion_actions[CREATE TABLE "spree_promotion_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_id" integer, "position" integer, "type" varchar(255)) ]EEtablespree_payment_capture_eventsspree_payment_capture_eventsCREATE TABLE "spree_payment_capture_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(10,2) DEFAULT 0.0, "payment_id" integer, "created_at" datetime, "updated_at" datetime)J^mEmindexindex_spree_payment_capture_events_on_payment_idspree_payment_capture_eventsCREATE INDEX "index_spree_payment_capture_events_on_payment_id" ON "spree_payment_capture_events" ("payment_id") ))/tablespree_variantsspree_variantsRCREATE 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(8,2), "position" integer, "cost_currency" varchar(255), "track_inventory" boolean DEFAULT 't', "tax_category_id" integer, "updated_at" datetime)Q)5indexindex_spree_variants_on_product_idspree_variantsSCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")C)indexindex_spree_variants_on_skuspree_varik\;;mtablespree_promotion_actionsspree_promotion_actions[CREATE TABLE "spree_promotion_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_id" integer, "position" integer, "type" varchar(255), "deleted_at" datetime)0ca7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type") dY/Cindexindex_spree_calculators_on_id_and_typespree_calculatorsCREATE INDEX "index_spree_calculators_on_id_and_type" ON "spree_calculators" ("id", "type")ce/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")_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id")8ge;[indexindex_spree_promotion_actions_on_id_and_typespree_promotion_actionsCREATE INDEX "index_spree_promotion_actions_on_id_and_type" ON "spree_promotion_actions" ("id", "type")g%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesbCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency") ?M%-indexindex_spree_prices_on_deleted_atspree_pricesCREATE INDEX "index_spree_prices_on_deleted_at" ON "spree_prices" ("deleted_at"){D))1tablespree_variantsspree_variantsRCREATE 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)EQ)5indexindex_spree_variants_on_product_idspree_variantsSCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")   EGf A  !iR)w7indexindex_spree_stock_locations_on_propagate_all_variantsspree_stock_locationsCREATE INDEX "index_spree_stock_locations_on_propagate_all_variants" ON "spree_stock_locations" ("propagate_all_variants")(*[7Iindexindex_spree_stock_locations_on_state_idspree_stock_locationsCREATE INDEX "index_spree_stoc|FC)indexindex_spree_variants_on_skuspree_variantsyCREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku") G[)Iindexindex_spree_variants_on_tax_category_idspree_variants}CREATE INDEX "index_spree_variants_on_tax_category_id" ON "spree_variants" ("tax_category_id")HQ)5indexindex_spree_variants_on_deleted_atspree_variantsCREATE INDEX "index_spree_variants_on_deleted_at" ON "spree_variants" ("deleted_at")IO)1indexindex_spree_variants_on_is_masterspree_variantsCREATE INDEX "index_spree_variants_on_is_master" ON "spree_variants" ("is_master") JM)-indexindex_spree_variants_on_positionspree_variantsCREATE INDEX "index_spree_variants_on_position" ON "spree_variants" ("position")!K[)Iindexindex_spree_variants_on_track_inventoryspree_variantsCREATE INDEX "index_spree_variants_on_track_inventory" ON "spree_variants" ("track_inventory")CL111tablespree_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)MS19indexindex_spree_credit_cards_on_user_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_user_id" ON "spree_credit_cards" ("user_id")7Ng1aindexindex_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")"OY1Eindexindex_spree_credit_cards_on_address_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_address_id" ON "spree_credit_cards" ("address_id")6Pc;Yindexindex_spree_promotion_actions_on_deleted_atspree_promotion_actionsCREATE INDEX "index_spree_promotion_actions_on_deleted_at" ON "spree_promotion_actions" ("deleted_at")hQ)) tablespree_paymentsspree_payments)CREATE 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)) RM)-indexindex_spree_payments_on_order_idspree_paymentsdCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")'S_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id")>To)oindexindex_spree_payments_on_source_id_and_source_typespree_paymentsCREATE INDEX "index_spree_payments_on_source_id_and_source_type" ON "spree_payments" ("source_id", "source_type")NZ--Otablespree_line_itemsspree_line_itemsCREATE 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)          d) b3       ( 3 F `X bS+9indexindex_spree_shipments_on_address_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_address_id" ON "spree_shipments" ("address_id")+aa+Uindexindex_spree_shipments_on_stock_location_idspree_sc##-tablespree_usersspree_usersQCREATE 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)dQ#5indexindex_spree_users_on_spree_api_keyspree_usersCREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key")[Q-5indexindex_spree_line_items_on_order_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")\U-=indexindex_spree_line_items_on_variant_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id"))]_-Qindexindex_spree_line_items_on_tax_category_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_tax_category_id" ON "spree_line_items" ("tax_category_id")Z^++ktablespree_shipmentsspree_shipments@CREATE TABLE "spree_shipments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tracking" varchar(255), "number" varchar(255), "cost" decimal(10,2) DEFAULT 0.0, "shipped_at" datetime, "order_id" integer, "address_id" integer, "state" varchar(255), "created_at" datetime, "updated_at" datetime, "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, "pre_tax_amount" decimal(8,2) DEFAULT 0)}_?+indexindex_shipments_on_numberspree_shipmentsACREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number")`O+1indexindex_spree_shipments_on_order_idspree_shipmentsjCREATE INDEX "index_spree_shipments_on_order_id" ON "spree_shipments" ("order_id")+aa+Uindexindex_spree_shipments_on_stock_location_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_stock_location_id" ON "spree_shipments" ("stock_location_id")bS+9indexindex_spree_shipments_on_address_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_address_id" ON "spree_shipments" ("address_id")##!tablespree_userW##mtablespree_usersspree_usersQCREATE 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_siMMtablesp~fAAtablemercado_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)je-#indexemail_idx_uniquespree_usersCREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email")       jjA@         t  t   t    4 v T x + *+]5Mindexindex_spree_tax_categories_on_deleted_atspree_tax_categoriesCREATE INDEX "index_spree_tax_categories_on_deleted_at" ON "spree_tax_categories" ("deleted_at")*,]5Mindexindex_spree_tax_categories_on_is_defaultspree_tax_categoriesCREATE INDEX "index_spree_tax_categories_on_is_default" ON "spree_tax_categories" ("is_default")-S+9indexindex_spree_tax_rates_on_deleted_atspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_deleted_at" ON "spree_tax_rates" ("deleted_at")+.a+Uindexindex_spree_tax_rates_on_included_in_pricespree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_included_in_price" ON "spree_tax_rates" ("included_in_price")./c+Yindexindex_spree_tax_rates_on_show_rate_in_labelspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_show_rate_in_label" ON "spree_tax_rates" ("show_rate_in_label")%0]+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") 1M+-indexindex_spree_tax_rates_on_zone_idspree_tax_ratesCREATE INDEX "index_spree_tax_rates_on_zone_id" ON "spree_tax_rates" ("zone_id")2Q-5indexindex_spree_taxonomies_on_positionspree_taxonomiesCREATE INDEX "index_spree_taxonomies_on_position" ON "spree_taxonomies" ("position")3I%%indexindex_spree_taxons_on_positionspree_taxonsCREATE INDEX "index_spree_taxons_on_position" ON "spree_taxons" ("position")4I)%indexindex_spree_trackers_on_activespree_trackersCREATE INDEX "index_spree_trackers_on_active" ON "spree_trackers" ("active")5Q)5indexindex_spree_variants_on_deleted_atspree_variantsCREATE INDEX "index_spree_variants_on_deleted_at" ON "spre "K_-Qindexindex_spree_line_items_on_tax_category_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_tax_category_id" ON "spree_line_items" ("tax_category_id") "U-=indexindex_spree_line_items_on_variant_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")9S19indexindex_spree_zone_members_on_zone_idspree_zone_membersCREATE INDEX "index_spree_zone_members_on_zone_id" ON "spree_zone_members" ("zone_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") ;M#-indexindex_spree_zones_on_default_taxspree_zonesCREATE INDEX "index_spree_zones_on_default_tax" ON "spree_zones" ("default_tax")6<k%gindexindex_spree_orders_on_user_id_and_created_by_idspree_ordersCREATE INDEX "index_spree_orders_on_user_id_and_created_by_id" ON "spree_orders" ("user_id", "created_by_id")Y=%%utablespree_pricesspree_prices3CREATE 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)/>g%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesbCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency") ?M%-indexindex_spree_prices_on_deleted_atspree_pricesCREATE INDEX "index_spree_prices_on_deleted_at" ON "spree_prices" ("deleted_at")--9tablespree_line_itemsspree_line_itemsCREATE 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(8,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))Q-5indexindex_spree_line_items_on_order_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")            }ySR       jA@ Q