SQLite format 3@ q[Wq-S-q##)tablecreditcardscreditcardsCREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "verification_value" text, "month" varchar(255), "year" varchar(255), "cc_type" varchar(255), "display_number" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "checkout_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)d ++tablecreditcard_txnscreditcard_txnsCREATE TABLE "creditcard_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creditcard_payment_id" integer, "txn_type" integer, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)+ -tablecouponscoupons CREATE TABLE "coupons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "description" varchar(255), "usage_limit" integer, "combine" boolean, "expires_at" datetime, "starts_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S utablecountriescountries CREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_name" varchar(255), "iso" varchar(255), "iso3" varchar(255), "name" varchar(255), "numcode" integer) W)?indexindex_configurations_on_name_and_typeconfigurations CREATE INDEX "index_configurations_on_name_and_type" ON "configurations" ("name", "type")a ))}tableconfigurationsconfigurations CREATE TABLE "configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(50), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?Mtablecheckoutscheckouts CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "email" varchar(255), "ip_address" varchar(255), "special_instructions" text, "bill_address_id" integer, "completed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)##etablecalculatorscalculatorsCREATE TABLE "calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer NOT NULL, "calculable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)YtableassetsassetsCREATE TABLE "assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "attachment_width" integer, "attachment_height" integer, "attachment_size" integer, "position" integer, "viewable_type" varchar(50), "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "type" varchar(75), "attachment_updated_at" datetime)##{tableadjustmentsadjustmentsCREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "position" integer, "adjustment_source_id" integer, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "type" varchar(255), "description" varchar(255), "adjustment_source_type" varchar(255), "secondary_type" varchar(255), "order_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)8?tableaddressesaddressesCREATE TABLE "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), "state_id" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("G@y:R$9# o2p^L:(tbP>, x f T B 0  | j X F 4 "  n \ J 8 &   r ` N < *   v d R @ .  zhVD2o)20121121030250n)20121121030249m)20121121030248l)20121121030247k)20121121030246j)20121121030245i)20121121030244h)20121121030243g)20121121030242f)20121121030241e)20121121030240d)20121121030239c)20121121030238b)20121121030237a)20121121030236`)20121121030235_)20121121030234^)20121121030233])20121121030232\)20121121030231[)20121121030230Z)20121121030229Y)20121121030228X)20121121030227W)20121121030226V)20121121030225U)20121121030224T)20121121030223S)20121121030222R)20121121030221Q)20121121030220P)20121121030219O)20121121030218N)20121121030217M)20121121030216L)20121121030215K)20121121030214J)20121121030213I)20121121030212H)20121121030211G)20121121030210F)20121121030209E)20121121030208D)20121121030207C)20121121030206B)20121121030205A)20121121030204@)20121121030203?)20121121030202>)20121121030201=)20121121030200<)20121121030199;)20121121030198:)201211210301979)201211210301968)201211210301957)201211210301946)201211210301935)201211210301924)201211210301913)201211210301902)201211210301891)201211210301880)20121121030187/)20121121030186.)20121121030185-)20121121030184,)20121121030183+)20121121030182*)20121121030181))20121121030180()20121121030179')20121121030178&)20121121030177%)20121121030176$)20121121030175#)20121121030174")20121121030173!)20121121030172 )20121121030171)20121121030170)20121121030169)20121121030168)20121121030167)20121121030166)20121121030165)20121121030164)20121121030163)20121121030162)20121121030161)20121121030160)20121121030159)20121121030158)20121121030157)20121121030156)20121121030155)20121121030154)20121121030153 )20121121030152 )20121121030151 )20121121030150 )20121121030149 )20121121030148)20121121030147)20121121030146)20121121030145)20121121030144)20121121030143)20121121030142)20121121030141)20121121030140 o{hUB/ q^K8% z g T A .   p ] J 7 $  y f S @ -   o \ I 6 #  x e R ? ,  n[H5")20121121030250o)20121121030249n)20121121030248m)20121121030247l)20121121030246k)20121121030245j)20121121030244i)20121121030243h)20121121030242g)20121121030241f)20121121030240e)20121121030239d)20121121030238c)20121121030237b)20121121030236a)20121121030235`)20121121030234_)20121121030233^)20121121030232])20121121030231\)20121121030230[)20121121030229Z)20121121030228Y)20121121030227X)20121121030226W)20121121030225V)20121121030224U)20121121030223T)20121121030222S)20121121030221R)20121121030220Q)20121121030219P)20121121030218O)20121121030217N)20121121030216M)20121121030215L)20121121030214K)20121121030213J)20121121030212I)20121121030211H)20121121030210G)20121121030209F)20121121030208E)20121121030207D)20121121030206C)20121121030205B)20121121030204A)20121121030203@)20121121030202?)20121121030201>)20121121030200=)20121121030199<)20121121030198;)20121121030197:)201211210301969)201211210301958)201211210301947)201211210301936)201211210301925)201211210301914)201211210301903)201211210301892)201211210301881)201211210301870)20121121030186/)20121121030185.)20121121030184-)20121121030183,)20121121030182+)20121121030181*)20121121030180))20121121030179()20121121030178')20121121030177&)20121121030176%)20121121030175$)20121121030174#)20121121030173")20121121030172!)20121121030171 )20121121030170)20121121030169)20121121030168)20121121030167)20121121030166)20121121030165)20121121030164)20121121030163)20121121030162)20121121030161)20121121030160)20121121030159)20121121030158)20121121030157)20121121030156)20121121030155)20121121030154)20121121030153)20121121030152 )20121121030151 )20121121030150 )20121121030149 )20121121030148 )20121121030147)20121121030146)20121121030145)20121121030144)20121121030143)20121121030142)20121121030141)20121121030140              \ f w w wD   q##)tablecreditcardscreditcardsCREATE TABLE "creditcards" ("id" Iq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")?tableaddressesaddreW5Kindexindex_configurations_on_name_and_typespree_configurations CREATE INDEX "index_configurations_on_name_and_type" ON "spree_configurations" ("name", "type")s 55 tablespree_configurationsspree_configurations CREATE TABLE "spree_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(50), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)-[##{tableadjustmentsadj++1tablecreditcard_txnscreditcard_txnsCREATE TABLE "cr!//qtablespree_calculatorsspree_calculatorsCREATE TABLE "spree_calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer NOT NULL, "calculable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) }%%}tablespree_assetsspree_assetsCREATE TABLE "spree_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "attachment_width" integer, "attachment_height" integer, "attachment_size" integer, "position" integer, "viewable_type" varchar(50), "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "type" varchar(75), "attachment_updated_at" datetime, "alt" text) ##etablecalculatorscalculatorsCREATE TABLE "calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer NOT NULL, "calculable_type" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) Mtablecheckoutscheckouts CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "email" varchar(255), "ip_address" varchar(255), "special_instructions" teb++{tablespree_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), "state_id" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "company" varchar(255))e ++tablespree_countriesspree_countries CREATE 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)+ -tablecouponscoupons CREATE TABLE "coupons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "description" varchar(255), "usage_limit" integer, "combine" boolean, "expires_at" datetime, "starts_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)[++tablecreditcard_txnscreditcard_txnsCREATE TABLE "creditcard_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creditcard_payment_id" integer, "txn_type" integer, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)##)tablecreditcardscreditcardsC++Ktablespree_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), "state_id" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  m 3 ` !AAKtablespree_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 NOT NULL, "updated_at" datetime NOT NULL)))tablespree_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, "permalink" varchar(255), "meta_description" varchar(255), "meta_keywords" varchar(255), "tax_category_id" integer, "shipping_category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "count_on_hand" integer DEFAULT 0 NOT NULL)119tableproduct_propertiesproduct_properties&CREATE TABLE "product_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" varchar(255), "product_id" integer, "property_id" integer, "created_at" datetime NOT NULL, "updated_at" datetim"==Etablespree_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 NOT NULL, "updated_at" datetime NOT NULL) SaEaindexindex_option_values_variants_on_variant_idspree_option_values_variantsCREATE INDEX "index_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")"EEGtablespree_option_values_variantsspree_option_values_variantsCREATE TABLE "spree_option_values_variants" ("variant_id" integer, "option_value_id" integer)'33utablespree_option_valuesspree_option_valuesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL)&GGKtablespree_option_types_prototypesspree_option_types_prototypesCREATE TABLE "spree_option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)11etablespree_option_typesspree_option_typesCREATE TABLE "spree_option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "presentation" varchar(100), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer DEFAULT 0 NOT NULL)I-1indexindex_line_items_on_variant_idspree_line_itemsCREATE INDEX "index_line_items_on_variant_id" ON "spree_line_items" ("variant_id")E-)indexindex_line_items_on_order_idspree_line_itemsCREATE INDEX "index_line_items_on_order_id" ON "spree_line_items" ("order_id")$--{tablespree_line_itemsspree_line_itemsCREATE TABLE "spree_line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "variant_id" integer, "quantity" integer NOT NULL, "price" decimal(8,2) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i77qtablespree_inventory_unitsspree_inventory_unitsCREATE TABLE "spree_inventory_units" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "lock_version" integer DEFAULT 0, "state" varchar(255), "variant_id" integer, "order_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "shipment_id" integer, "return_authorization_id" integer)                  : [ g ) ,&5f]&[[[[[[[[[[\9--ktablespree_taxonomiesspree_taxonomies>CREATE TABLE "spree_taxonomies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)++7tablespree_tax_ratesspree_tax_rates=CREATE TABLE "spree_tax_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,4), "zone_id" integer, "tax_category_id" integer, "created_at" datetime NOT NULL, "updated4755 tablespree_tax_categoriesspree_tax_categories11Ctablespree_zone_membersspree_zone_membersCCREATE TABLE "spree_zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_id" integer, "zoneable_type" varchar(255), "zone_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]:%%}tablespree_taxonsspree_taxons?CREATE 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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lft" integer, "rgt" integer, "icon_file_name" varchar(255), "icon_content_type" varchar(255), "icon_file_size" integer, "icon_updated_at" datetime, "description" text)      ! d$TU7Iindexindex_inventory_units_on_shipment_idspree_inventory_unitsOCREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")[UCC=tablespree_return_authorizationsspree_return_authorizationsPCREATE TABLE "spree_return_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "state" varchar(255), "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "reason" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)V))Ytablespree_trackersspree_trackersQCREATE TABLE "spree_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "analytics_id" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]E+)indexindex_addresses_on_firstnamespree_addressesTCREATE INDEX "index_addresses_on_firstname" ON "spree_addresses" ("firstname")^C+%indexindex_addresses_on_lastnamespree_addressesUCREATE INDEX "index_addresses_on_lastname" ON "spree_addresses" ("lastname")}a?+indexindex_shipments_on_numberspree_shipmentsXCREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number") c779tablespree_payment_methodsspree_payment_methodsRCREATE 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', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "display_on" varchar(255))g))itablespree_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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "source_id" integer, "source_type" varchar(255), "payment_method_id" integer, "state" varchar(255), "response_code" varchar(255), "avs_response" varchar(255))~m11'tablespree_mail_methodsspree_mail_methodsZCREATE TABLE "spree_mail_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)p//3tablespree_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 NOT NULL, "updated_at" datetime NOT NULL)q11]tablespree_credit_cardsspree_credit_cards CREATE 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), "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255)):v--'tablespree_activatorsspree_activatorsCREATE TABLE "spree_activators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" varchar(255), "expires_at" datetime, "created_at" datetime, "updated_at" datetime, "starts_at" datetime, "name" varchar(255), "event_name" varchar(255), "type" varchar(255))1wc5Windexindex_spree_configurations_on_name_and_typespree_configurations CREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "type")xQ-5indexindex_spree_line_items_on_order_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")yU-=indexindex_spree_line_items_on_variant_idspree_line_itemsCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id")       {&V2 B { CZZ<Etablepaymen;e%%9tablespree[UCC=tablespree_return_authorizationsspree_return_authorizationsPCREATE TABLE "spree_return_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "state" varchar(255), "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "reason" text, "created_at" datetime NOT NULL, " FM#9indexindex_users_on_openid_identifierspree_usersCREATE INDEX "index_users_IzmEmindexindex_spree_option_values_variants_on_variant_idspree_option_values_variantsCREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")-_7Qindexindex_spree_products_taxons_on_product_idspree_products_taxons-CREATE INDEX "index_spree_products_taxons_on_product_id" ON "spree_products_taxons" ("product_id")'[7Iindexindex_spree_products_taxons_on_taxon_idspree_products_taxons.CREATE INDEX "index_spree_products_taxons_on_taxon_id" ON "spree_products_taxons" ("taxon_id")Q/5indexindex_spree_roles_users_on_role_idspree_roles_users4CREATE INDEX "index_spree_roles_users_on_role_id" ON "spree_roles_users" ("role_id")Q/5indexindex_spree_roles_users_on_user_idspree_roles_users5CREATE INDEX "index_spree_roles_users_on_user_id" ON "spree_roles_users" ("user_id")X//_tablespree_adjustmentsspree_adjustmentsCREATE TABLE "spree_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "amount" decimal(8,2), "label" varchar(255), "source_type" varchar(255), "adjustable_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "mandatory" boolean, "locked" boolean, "originator_id" integer, "originator_type" varchar(255), "eligible" boolean DEFAULT 't', "adjustable_type" varchar(255))G/7indexindex_adjustments_on_order_idspree_adjustments#CREATE INDEX "index_adjustments_on_order_id" ON "spree_adjustments" ("adjustable_id")x//tablespree_preferencesspree_preferencesCREATE TABLE "spree_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "owner_id" integer(30), "owner_type" varchar(50), "group_id" integer, "group_type" varchar(50), "value" text(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "key" varchar(255), "value_type" varchar(255)) I/3indexindex_spree_preferences_on_keyspree_preferences"CREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")" %%tablespree_assetsspree_assetsCREATE TABLE "spree_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "attachment_width" integer, "attachment_height" integer, "attachment_file_size" integer, "position" integer, "viewable_type" varchar(50), "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_assetsKCREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id") Y%Oindexindex_assets_on_viewable_type_and_typespree_assetsLCREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")h ++tablespree_tax_ratesspree_tax_rates=CREATE TABLE "spree_tax_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,5), "zone_id" integer, "tax_category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "included_in_price" boolean DEFAULT 'f', "name" varchar(255), "show_rate_in_label" boolean DEFAULT 't')0CCgtablespree_tokenized_permissionsspree_tokenized_permissionsVCREATE TABLE "spree_tokenized_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissable_id" integer, "permissable_type" varchar(255), "token" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)9GCuindexindex_tokenized_name_and_typespree_tokenized_permissionsYCREATE INDEX "index_tokenized_name_and_type" ON "spree_tokenized_permissions" ("permissable_id", "permissable_type")             s  x a[]i-#indexemail_idx_uniquespree_usersCREATE UNIQUE INDEX "email_idx_unique" ON "spree_users" ("email")h##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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "authentication_token" varchar(255), "unlock_token" varchar(255), "locked_at" datetime, "remember_created_at" datetime, "reset_password_sent_at" datetime)M#9indexindex_users_on_persistence_tokenspree_usersCREATE INDEX "index_users_on_persistence_token" ON "spree_users" ("persistence_token")Q)5indexindex_spree_variants_on_product_idspree_variantsBCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")[))qtablespree_variantsspree_variantsACREATE TABLE "spree_variants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sku" varchar(255) DEFAULT '' NOT NULL, "price" decimal(8,2) NOT NULL, "weight" decimal(8,2), "height" decimal(8,2), "width" decimal(8,2), "depth" decimal(8,2), "deleted_at" datetime, "is_master" boolean DEFAULT 'f', "product_id" integer, "count_on_hand" integer DEFAULT 0, "cost_price" decimal(8,2), "position" integer, "lock_version" integer DEFAULT 0)O)1indexindex_spree_products_on_permalinkspree_products+CREATE INDEX "index_spree_products_on_permalink" ON "spree_products" ("permalink")E)indexindex_spree_products_on_namespree_products*CREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")Q)5indexindex_spree_products_on_deleted_atspree_products)CREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")U)=indexindex_spree_products_on_available_onspree_products(CREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on")\))stablespree_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, "permalink" varchar(255), "meta_description" varchar(255), "meta_keywords" varchar(255), "tax_category_id" integer, "shipping_category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "count_on_hand" integer DEFAULT 0)}E%indexindex_spree_orders_on_numberspree_orders CREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number") %%Utablespree_ordersspree_ordersCREATE 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, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "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)   ('Y@