SQLite format 3@ \-%G 119tablecms_category_typescms_category_types CREATE TABLE "cms_category_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)Xtablecms_pagescms_pages CREATE TABLE "cms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "version" integer, "lock_version" integer DEFAULT 0, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime, "latest_version" integer)r //tablecms_page_versionscms_page_versions CREATE TABLE "cms_page_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "original_record_id" integer, "version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime)bKtablecms_pagescms_pages CREATE TABLE "cms_pages" ("id" INTEGER PRIMARY KEY AUTOINCRE //5tablecms_content_typescms_content_types CREATE TABLE "cms_content_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "content_type_group_id" integer, "priority" integer DEFAULT 2, "created_at" datetime, "updated_at" datetime)V ;;Ctablecms_content_type_groupscms_content_type_groups CREATE TABLE "cms_content_type_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)??/tablecms_dynamic_view_versionscms_dynamic_view_versionsCREATE TABLE "cms_dynamic_view_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "format" varchar(255), "handler" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime, "original_record_id" integer, "version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer)\//gtablecms_dynamic_viewscms_dynamic_viewsCREATE TABLE "cms_dynamic_views" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "format" varchar(255), "handler" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime, "version" integer, "lock_version" integer DEFAULT 0, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer)u=indexindex_cms_users_on_logincms_usersCREATE UNIQUE INDEX "index_cms_users_on_login" ON "cms_users" ("login")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) tablecms_userscms_usersCREATE TABLE "cms_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(40), "first_name" varchar(40), "last_name" varchar(40), "email" varchar(40), "crypted_password" varchar(40), "salt" varchar(40), "created_at" datetime, "updated_at" datetime, "expires_at" datetime, "remember_token" varchar(40), "remember_token_expires_at" datetime, "reset_token" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q]ɃOMՃ߃2b@tك$ tKIdW% p^L:(tbP>, x f T B 0  | j X F 4 "  n \ J 8 &   r ` N < *   v d R @ .  zhVD2 ~lZH6$zgTA. )20140915230205 )20140915222679 )20140915222678 )20140915222677)20140915222676)20140915222675)20140915222674)20140915222673)20140915222672)20140915222671)20140915222670)20140915222669)20140915222668)20140915222667~)20140915222666})20140915222665|)20140915222664{)20140915222663z)20140915222662y)20140915222661x)20140915222660w)20140915222659v)20140915222658u)20140915222657t)20140915222656s)20140915222655r)20140915222654q)20140915222653p)20140915222652o)20140915222651n)20140915222650m)20140915222649l)20140915222648k)20140915222647j)20140915222646i)20140915222645h)20140915222644g)20140915222643f)20140915222642e)20140915222641d)20140915222640c)20140915222639b)20140915222638a)20140915222637`)20140915222636_)20140915222635^)20140915222634])20140915222633\)20140915222632[)20140915222631Z)20140915222630Y)20140915222629X)20140915222628W)20140915222627V)20140915222626U)20140915222625T)20140915222624S)20140915222623R)20140915222622Q)20140915222621P)20140915222620O)20140915222619N)20140915222618M)20140915222617L)20140915222616K)20140915222615J)20140915222614I)20140915222613H)20140915222612G)20140915222611F)20140915222610E)20140915222609D)20140915222608C)20140915222607B)20140915222606A)20140915222605@)20140915222604?)20140915222603>)20140915222602=)20140915222601<)20140915222600;)20140915222599:)201409152225989)201409152225978)201409152225967)201409152225956)201409152225945)201409152225934)201409152225923)201409152225912)201409152225901)201409152225890)20140915222588/)20140915222587.)20140915222586-)20140915222585,)20140915222584+)20140915222583*)20140915222582))20140915222581()20140915222580')20140915222579&)20140915222578%)20140915222577$)20140915222576#)20140915222575")20140915222574!)20140915222573 )20140915222572)20140915222571)20140915222570)20140915222569)20140915222568)20140915222567)20140915222566)20140915222565)20140915222564)20140915222563)20140915222562)20140915222561)20140915222560)20140915222559)20140915222558)20140915222557)20140915222556)20140915222555)20140915222554 )20140915222553 )20140915222552 )20140915222551 )20140915222550 )20140915222549)20140915222548)20140915222547)20140915222546)20140915222545)20140915222544)20140915222543)20140911222417)20140911222416 |iVC0 r_L9& { h U B /  q ^ K 8 %  z g T A .   p ] J 7 $  y f S @ -  o\I6#xeR?,lXD0)20140915230205)20140915222679)20140915222678)20140915222677)20140915222676)20140915222675)20140915222674)20140915222673)20140915222672)20140915222671)20140915222670)20140915222669)20140915222668)20140915222667)20140915222666~)20140915222665})20140915222664|)20140915222663{)20140915222662z)20140915222661y)20140915222660x)20140915222659w)20140915222658v)20140915222657u)20140915222656t)20140915222655s)20140915222654r)20140915222653q)20140915222652p)20140915222651o)20140915222650n)20140915222649m)20140915222648l)20140915222647k)20140915222646j)20140915222645i)20140915222644h)20140915222643g)20140915222642f)20140915222641e)20140915222640d)20140915222639c)20140915222638b)20140915222637a)20140915222636`)20140915222635_)20140915222634^)20140915222633])20140915222632\)20140915222631[)20140915222630Z)20140915222629Y)20140915222628X)20140915222627W)20140915222626V)20140915222625U)20140915222624T)20140915222623S)20140915222622R)20140915222621Q)20140915222620P)20140915222619O)20140915222618N)20140915222617M)20140915222616L)20140915222615K)20140915222614J)20140915222613I)20140915222612H)20140915222611G)20140915222610F)20140915222609E)20140915222608D)20140915222607C)20140915222606B)20140915222605A)20140915222604@)20140915222603?)20140915222602>)20140915222601=)20140915222600<)20140915222599;)20140915222598:)201409152225979)201409152225968)201409152225957)201409152225946)201409152225935)201409152225924)201409152225913)201409152225902)201409152225891)201409152225880)20140915222587/)20140915222586.)20140915222585-)20140915222584,)20140915222583+)20140915222582*)20140915222581))20140915222580()20140915222579')20140915222578&)20140915222577%)20140915222576$)20140915222575#)20140915222574")20140915222573!)20140915222572 )20140915222571)20140915222570)20140915222569)20140915222568)20140915222567)20140915222566)20140915222565)20140915222564)20140915222563)20140915222562)20140915222561)20140915222560)20140915222559)20140915222558)20140915222557)20140915222556)20140915222555)20140915222554)20140915222553 )20140915222552 )20140915222551 )20140915222550 )20140915222549 )20140915222548)20140915222547)20140915222546)20140915222545)20140915222544)20140915222543)20140911222417) 20140911222416 CC:'5AAcmsadminCMSAdministratorcmsadmin@example.com2014-09-26 20:10:15.5850012014-09-26 20:10:15.585001$2a$10$hvWDY0TywLcm1Npz9C8tMOnEnF2KtvMWeGIZiuKOrLdgcdt.xSk1SCms::User  zeP0 BkW* C C C C C C >cms_portlets , cms_portlet cms_portlet_attributes  spree_line_items X spree_tokenized_permissions 8 spree_orders  spree_)spree_products spree_prices%spree_prices)spree_variants? spree_shipping_categories% cms_portlets1cms_group_sections+cms_html_blocks)cms_connectors;cms_html_block_versions/cms_section_nodes/cms_page_versions cms_pages%cms_sections  cms_sites 7cms_group_permissions Acms_user_group_memberships !cms_groups Acms_group_type_permissions +cms_group_types+cms_permissions  cms_users1spree_zone_members#spree_zones%spree_states6#spree_roles/ spree_preferences+spree_countries 5 cmsadmin@example.com    - )/- AAPage Not Found/system/not_founddefault.html.erbtttff2014-09-26 20:10:16.4975402014-09-26 20:10:16.497540%5-  d-  AAHome/default.html.erbtftff2014-09-26 20:10:16.4352002014-09-26 20:10:16.435200%5- AAServer Error/system/server_errordefault.html.erbtttff2014-09-26 20:10:16.5903152014-09-26 20:10:16.590315'7- AAAccess Denied/system/access_denieddefault.html.erbtttff2014-09-26 20:10:16.5552862014-09-26 20:10:16.555286e-  AA Home/default.html.erbtftff2014-09-26 20:10:16.4352002014-09-26 20:10:16.435200    8 v '-  AAHome/default.html.erbtftffAll Products Portlet 'Inventory' was added to the 'main' container2014-09-30 16:56:50.1160462014-09-30 16:56:50.116046<%5- AAServer Error/system/server_errordefault.html.erbtttffHtml Block 'Server Error' was added to the 'main' container2014-09-26 20:10:16.9271672014-09-26 20:10:16.927167?'7- AAAccess Denied/system/access_denieddefault.html.erbtttffHtml Block 'Access Denied' was added to the 'main' container2014-09-26 20:10:16.8575162014-09-26 20:10:16.857516=)/- AAPage Not Found/system/not_founddefault.html.erbtttffHtml Block 'Page Not Found' was added to the 'main' container2014-09-26 20:10:16.7428182014-09-26 20:10:16.742818%5-  AAServer Error/system/server_errordefault.html.erbtttffCreated2014-09-26 20:10:16.5926542014-09-26 20:10:16.600407'7-  AAAccess Denied/system/access_denieddefault.html.erbtttffCreated2014-09-26 20:10:16.5577112014-09-26 20:10:16.568195)/-  AAPage Not Found/system/not_founddefault.html.erbtttffCreated2014-09-26 20:10:16.4998872014-09-26 20:10:16.509813j-  AAHome/default.html.erbtftffCreated2014-09-26 20:10:16.4479332014-09-26 20:10:16.458648       E555555jq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschemaq//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)11tablespree_zone_membersspree_zone_membersCREATE TABLE "spree_zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_id" integer, "zoneable_type" varchar(255), "zone_id" integer, "created_at" datetime, "updated_at" datetime)##ytablespree_zonesspree_zonesCREATE TABLE "spree_zones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "default_tax" boolean DEFAULT 'f', "zone_members_count" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime)Q)5indexindex_spree_variants_on_product_idspree_variantsCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")C)indexindex_spree_variants_on_skuspree_variantsCREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku")[)Iindexindex_spree_variants_on_tax_category_idspree_variantsCREATE INDEX "index_spree_variants_on_tax_category_id" ON "spree_variants" ("tax_category_id")pI;;wtablecms_attachment_versionscms_attachment_versionsCREATE TABLE "cms_attachment_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "data_file_name" varchar(255), "data_file_path" varchar(255), "file_location" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "data_fingerprint" varchar(255), "attachable_type" varchar(255), "attachment_name" varchar(255), "attachable_id" integer, "attachable_version" integer, "cardinality" varchar(255), "original_record_id" integer, "version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime)MJs;yindexindex_cms_attachment_versions_on_original_record_idcms_attachment_versionsRCREATE INDEX "index_cms_attachment_versions_on_original_record_id" ON "cms_attachment_versions" ("original_record_id")The server encountered an unexpected condition that prevented it from fulfilling the request.

Server Errortff2014-09-26 20:10:16.8924242014-09-26 20:10:16.892424-C ' AA

You have tried to reach a resource or page which you do not have permission to view.

Access Deniedtff2014-09-26 20:10:16.8198642014-09-26 20:10:16.819864 ) AA

The page you tried to access does not exist on this server.

Page Not Foundtff2014-09-26 20:10:16.6580002014-09-26 20:10:16.658000  ` >U % AA

The server encountered an unexpected condition that prevented it from fulfilling the request.

Server ErrortffCreated2014-09-26 20:10:16.8945892014-09-26 20:10:16.9059876C ' AA

You have tried to reach a resource or page which you do not have permission to view.

Access DeniedtffCreated2014-09-26 20:10:16.8227712014-09-26 20:10:16.835963 ) AA

The page you tried to access does not exist on this server.

Page Not FoundtffCreated2014-09-26 20:10:16.6701602014-09-26 20:10:16.709555 kkKAAsystem/systemft2014-09-26 20:10:16.4764132014-09-26 20:10:16.476413FAAMy Site/tf2014-09-26 20:10:16.2618672014-09-26 20:10:16.261867 [ 1 AAAllProductsPortletInventoryff2014-09-30 16:56:49.4907672014-09-30 16:56:49.490767          g EAACMS Userft2014-09-26 20:10:15.7644522014-09-26 20:10:15.764452S9AARegistered Public Userff2014-09-26 20:10:15.7575462014-09-26 20:10:15.757546BAAGuesttf2014-09-26 20:10:15.7378792014-09-26 20:10:15.737879 `Y+)AAContent Editorscontent-editor2014-09-26 20:10:15.9366762014-09-26 20:10:15.936676W1AACms Administratorscms-admin2014-09-26 20:10:15.9285642014-09-26 20:10:15.928564E AAGuestguest2014-09-26 20:10:15.8977742014-09-26 20:10:15.897774     ` $ ++AApublish_contentPublish ContentAllows users to Save and Publish, Hide and Archive both Pages and Blocks.2014-09-26 20:10:15.6894592014-09-26 20:10:15.689459D %%kAAedit_contentEdit ContentAllows users to Add, Edit and Delete both Pages and Blocks. Can Save (but not Publish) and Assign them as well.2014-09-26 20:10:15.6819422014-09-26 20:10:15.681942 %)AAadministrateAdminister CMSAllows users to administer the CMS, including adding users and groups.2014-09-26 20:10:15.6729552014-09-26 20:10:15.672955        N#AADefaultexample.comt2014-09-26 20:10:16.0948242014-09-26 20:10:16.094824 8l8K AACms::Page1/32014-09-26 20:10:16.5945902014-09-26 20:10:16.594590K AACms::Page1/32014-09-26 20:10:16.5603872014-09-26 20:10:16.560387J  AACms::Page1/32014-09-26 20:10:16.5022082014-09-26 20:10:16.502208L %AACms::Section12014-09-26 20:10:16.4783622014-09-26 20:10:16.478362G  AACms::Page12014-09-26 20:10:16.4517722014-09-26 20:10:16.451772I % AACms::Section2014-09-26 20:10:16.2981582014-09-26 20:10:16.298158          fff f 5/system/server_error7/system/access_denied//system/not_found /   )content-editor cms-admin guest  tf f         0  AtUSDt2014-09-30 17:05:03.270955/  AtUSDt2014-09-30 17:04:46.676571        1/31/31/311  Cms::Page Cms::Page Cms::Page%Cms::Section Cms::Page% Cms::Section %Cms::Portlet)Cms::HtmlBlock)Cms::HtmlBlock) Cms::HtmlBlock    ff f       Inventory   /system / ' F,X];Mindexindex_cms_file_block_versions_on_versioncms_file_block_versionsOCREATE INDEX "index_cms_file_block_versions_on_version" ON "cms_file_block_versions" ("version")QY++Ytablecms_file_blockscms_file_blocksCREATE TABLE "cms_file_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "attachment_id" integer, "attachment_version" integer, "version" integer, "lock_version" integer DEFAULT 0, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime) ZM+-indexindex_cms_file_blocks_on_deletedcms_file_blocksQCREATE INDEX "index_cms_file_blocks_on_deleted" ON "cms_file_blocks" ("deleted")[G+!indexindex_cms_file_blocks_on_typecms_file_blocksCREATE INDEX "index_cms_file_blocks_on_type" ON "cms_file_blocks" ("type")T\--[tablecms_form_entriescms_form_entriesWCREATE TABLE "cms_form_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "data_columns" text, "form_id" integer, "created_at" datetime, "updated_at" datetime)e]++tablecms_form_fieldscms_form_fields CREATE TABLE "cms_form_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "form_id" integer, "label" varchar(255), "name" varchar(255), "field_type" varchar(255), "required" boolean, "position" integer, "instructions" text, "default_value" text, "choices" text, "created_at" datetime, "updated_at" datetime)-^_+]indexindex_cms_form_fields_on_form_id_and_namecms_form_fieldsMCREATE UNIQUE INDEX "index_cms_form_fields_on_form_id_and_name" ON "cms_form_fields" ("form_id", "name")D_//7tablecms_form_versionscms_form_versionsLCREATE TABLE "cms_form_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "confirmation_behavior" varchar(255), "confirmation_text" text, "confirmation_redirect" varchar(255), "notification_email" varchar(255), "original_record_id" integer, "version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime)`otablecms_formscms_forms CREATE TABLE "cms_forms" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "confirmation_behavior" varchar(255), "confirmation_text" text, "confirmation_redirect" varchar(255), "notification_email" varchar(255), "version" integer, "lock_version" integer DEFAULT 0, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime):a77tablecms_group_permissionscms_group_permissions!CREATE TABLE "cms_group_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer, "permission_id" integer)\b7indexindex_cms_group_permissions_on_group_id_and_permission_idcms_group_permissionsCREATE INDEX "index_cms_group_permissions_on_permission_id" ON "cms_group_permissions" ("permission_id")    A)Cms::HtmlBlock)Cms::HtmlB     N w] )) AASomething elsesomething-else2014-09-30 17:05:03.2254502014-09-30 17:05:03.306424 9A7 AAThe Racketeer: A Novel2014-09-29 00:00:00.000000the-racketeer-a-novel2014-09-30 17:04:46.4619912014-09-30 17:04:46.683930 P       cmsadmin     @//gtablespree_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, "state" varchar(255))uX=indexindex_cms_users_on_emailcms_usersXCREATE UNIQUE INDEX "index_cms_users_on_email" ON "cms_users" ("email")"Y[Windexindex_cms_users_on_reset_password_tokencms_usersYCREATE UNIQUE INDEX "index_cms_users_on_reset_password_token" ON "cms_users" ("reset_password_token")@--Atablespree_promotionsspree_promotionsZCREATE TABLE "spree_promotions" ("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', "patuX=indexindex_cms_users_on_emailcms_usersXCREATE UNIQUE INDEX "index_cms_users_on_email" ON "cms_users" ("email")"Y[Windexindex_cms_users_on_reset_password_tokencms_usersYCREATE UNIQUE INDEX "index_cms_users_on_reset_password_token" ON "cms_users" ("reset_password_token")P[++Wtablespree_addressesspree_addresses[CREATE 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_addresses]CREATE INDEX "index_addresses_on_firstname" ON "spree_addresses" ("firstname")]C+%indexindex_addresses_on_lastnamespree_addresses^CREATE INDEX "index_addresses_on_lastname" ON "spree_addresses" ("lastname")#`%% tablespree_assetsspree_assetsaCREATE 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)aC%%indexindex_assets_on_viewable_idspree_assetsbCREATE INDEX "index_assets_on_viewable_id" ON "spree_assets" ("viewable_id") bY%Oindexindex_assets_on_viewable_type_and_typespree_assetscCREATE INDEX "index_assets_on_viewable_type_and_type" ON "spree_assets" ("viewable_type", "type")}c//)tablespree_calculatorsspree_calculatorsdCREATE 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)ad55etablespree_configurationsspree_configurationseCREATE TABLE "spree_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(50), "created_at" datetime, "updated_at" datetime)1ec5Windexindex_spree_configurations_on_name_and_typespree_configurationsfCREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "type"){h))1tablespree_gatewaysspree_gatewaysiCREATE 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)          W K F  ^  R ` )~=[!V d~&k0x7A< ##APHILIPPINESPHPHLPhilippines`f2014-09-26 20:10:13.286488;; AMONGOLIAMNMNGMongoliaf2014-09-26 20:10:13.280846?: !!AKYRGYZSTANKGKGZKyrgyzstanf2014-09-26 20:10:13.275226?9 !!AGUADELOUPEGPGLPGuadeloupe8f2014-09-26 20:10:13.27039198 ADENMARKDKDNKDenmarkf2014-09-26 20:10:13.264692:7 ABOTSWANABWBWABotswanaHf2014-09-26 20:10:13.25945896 AURUGUAYUYURYUruguayZf2014-09-26 20:10:13.25376075 AMONACOMCMCOMonacof2014-09-26 20:10:13.24892074 AKUWAITKWKWTKuwaitf2014-09-26 20:10:13.243287G3 ))ACZECH REPUBLICCZCZECzech Republicf2014-09-26 20:10:13.237964V2 99ABOSNIA AND HERZEGOVINABABIHBosnia and HerzegovinaFf2014-09-26 20:10:13.232569E1 ''AUNITED STATESUSUSAUnited StatesHt2014-09-26 20:10:13.226946S0 55AMOLDOVA, REPUBLIC OFMDMDAMoldova, Republic off2014-09-26 20:10:13.220614H/ 1#AKOREA, REPUBLIC OFKRKORSouth Koreaf2014-09-26 20:10:13.1970937. ACYPRUSCYCYPCyprusf2014-09-26 20:10:13.1920258- ABOLIVIABOBOLBoliviaDf2014-09-26 20:10:13.186215G, ))AUNITED KINGDOMGBGBRUnited Kingdom:f2014-09-26 20:10:13.180735i+ KKAMICRONESIA, FEDERATED STATES OFFMFSMMicronesia, Federated States ofGt2014-09-26 20:10:13.175594\* Y#AKOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFKPPRKNorth Koreaf2014-09-26 20:10:13.1704893) ACUBACUCUBCubaf2014-09-26 20:10:13.1644546( ABHUTANBTBTNBhutan@f2014-09-26 20:10:13.159237S' 55AUNITED ARAB EMIRATESAEAREUnited Arab Emiratest2014-09-26 20:10:13.1536607& AMEXICOMXMEXMexicot2014-09-26 20:10:13.147936;% AKIRIBATIKIKIRKiribati(f2014-09-26 20:10:13.1417908$ ABERMUDABMBMUBermuda6CAU.S. Armed Forces - PacificAP12014-09-26 20:10:14.852441=5AAU.S. Armed Forces - EuropeAE12014-09-26 20:10:14.847507?4EAU.S. Armed Forces - AmericasAA12014-09-26 20:10:14.84235103'AWest VirginiaWV12014-09-26 20:10:14.836547)2AAlaskaAK12014-09-26 20:10:14.83142611)ASouth CarolinaSC12014-09-26 20:10:14.826392+0ANew YorkNY12014-09-26 20:10:14.821064./#AConnecticutCT12014-09-26 20:10:14.8164450.'AMassachusettsMA12014-09-26 20:10:14.810094+-AColoradoCO12014-09-26 20:10:14.804283*,AGeorgiaGA12014-09-26 20:10:14.799585-+!ANew MexicoNM12014-09-26 20:10:14.794279+*AKentuckyKY12014-09-26 20:10:14.788070.)#AMississippiMS12014-09-26 20:10:14.782695'(AIowaIA12014-09-26 20:10:14.777336*'AAlabamaAL12014-09-26 20:10:14.771478*&AWyomingWY12014-09-26 20:10:14.766154)%AOregonOR12014-09-26 20:10:14.760847($ATexasTX12014-09-26 20:10:14.754525*#AIndianaIN12014-09-26 20:10:14.748694("AMaineME12014-09-26 20:10:14.743034/!%ANorth DakotaND12014-09-26 20:10:14.737184- !ACaliforniaCA12014-09-26 20:10:14.732078'AOhioOH12014-09-26 20:10:14.726413-!ANew JerseyNJ12014-09-26 20:10:14.720558,AMinnesotaMN12014-09-26 20:10:14.714550+AVirginiaVA12014-09-26 20:10:14.697621*AFloridaFL12014-09-26 20:10:14.693037+AMarylandMD12014-09-26 20:10:14.687811,ATennesseeTN12014-09-26 20:10:14.681710*AMontanaMT12014-09-26 20:10:14.674867,ALouisianaLA12014-09-26 20:10:14.668885+AOklahomaOK12014-09-26 20:10:14.663283/%ARhode IslandRI12014-09-26 20:10:14.658935+ADelawareDE12014-09-26 20:10:14.653626*AVermontVT12014-09-26 20:10:14.648170'AUtahUT12014-09-26 20:10:14.642440)AHawaiiHI12014-09-26 20:10:14.636688/%APennsylvaniaPA12014-09-26 20:10:14.631891+ANebraskaNE12014-09-26 20:10:14.626678(AIdahoID12014-09-26 20:10:14.6215317 5ADistrict of ColumbiaDC12014-09-26 20:10:14.615595) ANevadaNV12014-09-26 20:10:14.610124+ AArkansasAR12014-09-26 20:10:14.604714+ AMissouriMO12014-09-26 20:10:14.599981) AKansasKS12014-09-26 20:10:14.5942701)ANorth CarolinaNC12014-09-26 20:10:14.5884930'ANew HampshireNH12014-09-26 20:10:14.583197+AIllinoisIL12014-09-26 20:10:14.577905*AArizonaAZ12014-09-26 20:10:14.573204,AWisconsinWI12014-09-26 20:10:14.567403-!AWashingtonWA12014-09-26 20:10:14.562109/%ASouth DakotaSD12014-09-26 20:10:14.557191+AMichiganMI12014-09-26 20:10:14.519442                h7 P  k  : T  n ";L)AASpree::Country2014-09-26 20:10:15.3423372014-09-26 20:10:15.342337K)AA1Spree::Country2014-09-26 20:10:15.3328522014-09-26 20:10:15.332852K) AASpree::Country2014-09-26 20:10:15.3234982014-09-26 20:10:15.323498K) AASpree::Country2014-09-26 20:10:15.3016892014-09-26 20:10:15.301689J) AA8Spree::Country2014-09-26 20:10:15.2934762014-09-26 20:10:15.293476K) AASpree::Country2014-09-26 20:10:15.2847542014-09-26 20:10:15.284754K) AASpree::Country2014-09-26 20:10:15.2749652014-09-26 20:10:15.274965J) AA.Spree::Country2014-09-26 20:10:15.2653442014-09-26 20:10:15.265344K) AASpree::Country2014-09-26 20:10:15.2550932014-09-26 20:10:15.255093J) AA,Spree::Country2014-09-26 20:10:15.2471692014-09-26 20:10:15.247169K) AASpree::Country2014-09-26 20:10:15.2384712014-09-26 20:10:15.238471K) AASpree::Country2014-09-26 20:10:15.2284932014-09-26 20:10:15.228493J) AAbSpree::Country2014-09-26 20:10:15.2206242014-09-26 20:10:15.220624J) AASpree::Country2014-09-26 20:10:15.2116852014-09-26 20:10:15.211685J ) AASpree::Country2014-09-26 20:10:15.2004392014-09-26 20:10:15.200439K ) AASpree::Country2014-09-26 20:10:15.1905992014-09-26 20:10:15.190599J ) AAoSpree::Country2014-09-26 20:10:15.1821222014-09-26 20:10:15.182122J ) AASpree::Country2014-09-26 20:10:15.1738732014-09-26 20:10:15.173873K ) AASpree::Country2014-09-26 20:10:15.1648682014-09-26 20:10:15.164868K) AASpree::Country2014-09-26 20:10:15.1545362014-09-26 20:10:15.154536K) AASpree::Country2014-09-26 20:10:15.1271642014-09-26 20:10:15.127164J) AA Spree::Country2014-09-26 20:10:15.1182062014-09-26 20:10:15.118206K) AASpree::Country2014-09-26 20:10:15.1096502014-09-26 20:10:15.109650J) AA^Spree::Country2014-09-26 20:10:15.1017262014-09-26 20:10:15.101726J) AALSpree::Country2014-09-26 20:10:15.0931922014-09-26 20:10:15.093192J) AA Spree::Country2014-09-26 20:10:15.0852632014-09-26 20:10:15.085263J) AAHSpree::Country2014-09-26 20:10:15.0521262014-09-26 20:10:15.052126  <k[AAEU_VATCountries that make up the EU VAT zone.f2014-09-26 20:10:14.9618632014-09-26 20:10:14.961863k'%AANorth AmericaUSA + Canadaf2014-09-26 20:10:15.0325232014-09-26 20:10:15.032523l[ AAEU_VATCouW'%AANorth AmericaUSA + Canadaf2014-09-26 20:10:15.0325232014-09-26 20:10:15.032523             USD @zGUSD              USD  USD     OOjd f K ^ + r ? u99Itablecms_page_route_optionscms_page_route_options.CREATE TABLE "cms_page_route_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_route_id" integer, "type" varchar(255), "name" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)vv+u99Itablecms_page_route_optionscms_page_route_options.CREATE TABLE "cms_page_route_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_route_id" integer, "type" varchar(255), "name" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)vv++#tablecms_page_routescms_page_routes-CREATE TABLE "cms_page_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "pattern" varchar(255), "page_id" integer, "code" text, "created_at" datetime, "updated_at" datetime)rw//tablecms_page_versionscms_page_versions CREATE TABLE "cms_page_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "original_record_id" integer, "version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime)5xg/aindexindex_cms_page_versions_on_original_record_idcms_page_versionsCREATE INDEX "index_cms_page_versions_on_original_record_id" ON "cms_page_versions" ("original_record_id")Xytablecms_pagescms_pages CREATE TABLE "cms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "version" integer, "lock_version" integer DEFAULT 0, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime, "latest_version" integer)tzAindexindex_cms_pages_on_deletedcms_pages/CREATE INDEX "index_cms_pages_on_deleted" ON "cms_pages" ("deleted")k{; indexindex_cms_pages_on_pathcms_pages0CREATE INDEX "index_cms_pages_on_path" ON "cms_pages" ("path")t|Aindexindex_cms_pages_on_versioncms_pages1CREATE INDEX "index_cms_pages_on_version" ON "cms_pages" ("version")}++Utablecms_permissionscms_permissions CREATE TABLE "cms_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "full_name" varchar(255), "description" varchar(255), "for_module" varchar(255), "created_at" datetime, "updated_at" datetime)I~99-tablecms_portlet_attributescms_portlet_attributesCREATE TABLE "cms_portlet_attributes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "portlet_id" integer, "name" varchar(255), "value" text)1a9Uindexindex_cms_portlet_attributes_on_portlet_idcms_portlet_attributes2CREATE INDEX "index_cms_portlet_attributes_on_portlet_id" ON "cms_portlet_attributes" ("portlet_id");%%9tablecms_portletscms_portletsCREATE TABLE "cms_portlets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "archived" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime, "updated_at" datetime)wA%indexindex_cms_portlets_on_namecms_portletsFCREATE INDEX "index_cms_portlets_on_name" ON "cms_portlets" ("name")U''itablecms_redirectscms_redirectsCREATE TABLE "cms_redirects" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "from_path" varchar(255), "to_path" varchar(255), "created_at" datetime, "updated_at" datetime) M'-indexindex_cms_redirects_on_from_pathcms_redirectsGCREATE INDEX "index_cms_redirects_on_from_path" ON "cms_redirects" ("from_path")     <MW K F  ^  R ` )~=[!V d~&k0x7A< ##APHILIPPINESPHPHLPhilippines`f2014-09-26 20:10:13.286488;; AMONGOLIAMNMNGMongoliaf2014-09-26 20:10:13.280846?: !!AKYRGYZSTANKGKGZKyrgyzstanf2014-09-26 20:10:13.275226?9 !!AGUADELOUPEGPGLPGuadeloupe8f2014-09-26 20:10:13.27039198 ADENMARKDKDNKDenmarkf2014-09-26 20:10:13.264692:7 ABOTSWANABWBWABotswanaHf2014-09-26 20:10:13.25945896 AURUGUAYUYURYUruguayZf2014-09-26 20:10:13.25376075 AMONACOMCMCOMonacof2014-09-26 20:10:13.24892074 AKUWAITKWKWTKuwaitf2014-09-26 20:10:13.243287G3 ))ACZECH REPUBLICCZCZECzech Republicf2014-09-26 20:10:13.237964V2 99ABOSNIA AND HERZEGOVINABABIHBosnia and HerzegovinaFf2014-09-26 20:10:13.232569E1 ''AUNITED STATESUSUSAUnited StatesHt2014-09-26 20:10:13.226946S0 55AMOLDOVA, REPUBLIC OFMDMDAMoldova, Republic off2014-09-26 20:10:13.220614H/ 1#AKOREA, REPUBLIC OFKRKORSouth Koreaf2014-09-26 20:10:13.1970937. ACYPRUSCYCYPCyprusf2014-09-26 20:10:13.1920258- ABOLIVIABOBOLBoliviaDf2014-09-26 20:10:13.186215G, ))AUNITED KINGDOMGBGBRUnited Kingdom:f2014-09-26 20:10:13.180735i+ KKAMICRONESIA, FEDERATED STATES OFFMFSMMicronesia, Federated States ofGt2014-09-26 20:10:13.175594\* Y#AKOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFKPPRKNorth Koreaf2014-09-26 20:10:13.1704893) ACUBACUCUBCubaf2014-09-26 20:10:13.1644546( ABHUTANBTBTNBhutan@f2014-09-26 20:10:13.159237S' 55AUNITED ARAB EMIRATESAEAREUnited Arab Emiratest2014-09-26 20:10:13.1536607& AMEXICOMXMEXMexicot2014-09-26 20:10:13.147936;% AKIRIBATIKIKIRKiribati(f2014-09-26 20:10:13.1417908$ ABERMUDABMBMUBermuda  H u<P_"g q4D _(5y ATONGATOTONTongaf2014-09-26 20:10:13.697978;x AMALAYSIAMYMYSMalaysiaf2014-09-26 20:10:13.6919265w ACHINACNCHNChinaf2014-09-26 20:10:13.6864398v ABAHAMASBSBHSBahamas,f2014-09-26 20:10:13.6814539u ATOKELAUTKTKLTokelauf2014-09-26 20:10:13.6766977t AMALAWIMWMWIMalawif2014-09-26 20:10:13.6711765s ACHILECLCHLChilef2014-09-26 20:10:13.666044>r !!AAZERBAIJANAZAZEAzerbaijanf2014-09-26 20:10:13.6601753q ATOGOTGTGOTogof2014-09-26 20:10:13.654252?p !!AMADAGASCARMGMDGMadagascarf2014-09-26 20:10:13.6486828o AAUSTRIAATAUTAustria(f2014-09-26 20:10:13.643901;n ATHAILANDTHTHAThailandf2014-09-26 20:10:13.639326 ADJIBOUTIDJDJIDjiboutif2014-09-26 20:10:13.3139966= ABRAZILBRBRABrazilLt2014-09-26 20:10:13.291162 yWs 9 c #&++}tablespree_countriesspree_countriesgCREATE TABLE "spree_countries" ("id" INTEGE1%c5Windexindex_spree_configurations_on_name_and_typespree_configurationsfCREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "type")#&++}tablespree_countriesspree_countriesgCREATE TABLE "sp1%c5Windexindex_spree_configurations_on_name_and_typespree_configurationsfCREATE INDEX "index_spree_configurations_on_name_and_type" ON "spree_configurations" ("name", "type")#&++}tablespree_countriesspree_countriesgCREATE 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)x'11tablespree_credit_cardsspree_credit_cardshCREATE 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)7(g1aindexindex_spree_credit_cards_on_payment_method_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_payment_method_id" ON "spree_credit_cards" ("payment_method_id"))S19indexindex_spree_credit_cards_on_user_idspree_credit_cardsCREATE INDEX "index_spree_credit_cards_on_user_id" ON "spree_credit_cards" ("user_id"){*))1tablespree_gatewaysspree_gatewaysiCREATE 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)l+77wtablespree_inventory_unitsspree_inventory_unitskCREATE 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)3,c7Yindexindex_spree_inventory_units_on_line_item_idspree_inventory_unitslCREATE INDEX "index_spree_inventory_units_on_line_item_id" ON "spree_inventory_units" ("line_item_id")-O7=indexindex_inventory_units_on_order_idspree_inventory_unitsmCREATE INDEX "index_inventory_units_on_order_id" ON "spree_inventory_units" ("order_id")$.U7Iindexindex_inventory_units_on_shipment_idspree_inventory_unitsnCREATE INDEX "index_inventory_units_on_shipment_id" ON "spree_inventory_units" ("shipment_id")!/S7Eindexindex_inventory_units_on_variant_idspree_inventory_units{CREATE INDEX "index_inventory_units_on_variant_id" ON "spree_inventory_units" ("variant_id")B0--7tablespree_line_itemsspree_line_itemsoCREATE TABLE "spree_line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer, "order_id" integer, "quantity" integer NOT NULL, "price" decimal(8,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))1Q-5indexindex_spree_line_items_on_order_idspree_line_itemspCREATE INDEX "index_spree_line_items_on_order_id" ON "spree_line_items" ("order_id")2U-=indexindex_spree_line_items_on_variant_idspree_line_itemsqCREATE INDEX "index_spree_line_items_on_variant_id" ON "spree_line_items" ("variant_id") =L~0 t 7 1  1 v 0 ~ <`"`$d*v(l.s3u=D :6 ABULGARIABGBGRBulgariadf2014-09-26 20:10:14.059190F5 ))AAMERICAN SAMOAASASMAmerican Samoaf2014-09-26 20:10:14.05331774 ALATVIALVLVALatviaf2014-09-26 20:10:14.04803583 AALGERIADZDZAAlgeria f2014-09-26 20:10:14.04212282 AALBANIAALALBAlbaniaf2014-09-26 20:10:14.008003@1 ##AAFGHANISTANAFAFGAfghanistanf2014-09-26 20:10:14.002587=0 ASRI LANKALKLKASri Lankaf2014-09-26 20:10:13.9983675/ ASPAINESESPSpainf2014-09-26 20:10:13.992244C. %%ASOUTH AFRICAZAZAFSouth Africaf2014-09-26 20:10:13.9862919- AGRENADAGDGRDGrenada4f2014-09-26 20:10:13.9806449, ASOMALIASOSOMSomaliat2014-09-26 20:10:13.974842=+ AGREENLANDGLGRLGreenland0f2014-09-26 20:10:13.969224H* ++ASOLOMON ISLANDSSBSLBSolomon IslandsZf2014-09-26 20:10:13.9637433) APERUPEPERPeru\f2014-09-26 20:10:13.9584647( AGREECEGRGRCGreece,f2014-09-26 20:10:13.952833;' ASLOVENIASISVNSloveniaf2014-09-26 20:10:13.946525;& APARAGUAYPYPRYParaguayXf2014-09-26 20:10:13.940456=% AGIBRALTARGIGIBGibraltar$f2014-09-26 20:10:13.934825;$ ASLOVAKIASKSVKSlovakiaf2014-09-26 20:10:13.929493K# --APAPUA NEW GUINEAPGPNGPapua New GuineaVf2014-09-26 20:10:13.9245455" AGHANAGHGHAGhana f2014-09-26 20:10:13.9185139! ACROATIAHRHRVCroatiaf2014-09-26 20:10:13.913015= ASINGAPORESGSGPSingaporef2014-09-26 20:10:13.9080537 APANAMAPAPANPanamaOf2014-09-26 20:10:13.903210E ''ACOTE D'IVOIRECICIVCote D'Ivoiref2014-09-26 20:10:13.8978835 APALAUPWPLWPalauIf2014-09-26 20:10:13.892333= AMAURITIUSMUMUSMauritiusf2014-09-26 20:10:13.8876439 AGERMANYDEDEUGermanyf2014-09-26 20:10:13.883063? !!ACOSTA RICACRCRICosta Ricaf2014-09-26 20:10:13.8773447 ATUVALUTVTUVTuvaluf2014-09-26 20:10:13.872243C %%ASIERRA LEONESLSLESierra Leonef2014-09-26 20:10:13.866792; APAKISTANPKPAKPakistanJt2014-09-26 20:10:13.861893? !!AMAURITANIAMRMRTMauritaniaf2014-09-26 20:10:13.8561379 AGEORGIAGEGEOGeorgia f2014-09-26 20:10:13.850672[ ==ATURKS AND CAICOS ISLANDSTCTCATurks and Caicos Islandsf2014-09-26 20:10:13.845408? !!ASEYCHELLESSCSYCSeychellesf2014-09-26 20:10:13.8394263 AOMANOMOMNOmanf2014-09-26 20:10:13.833515? !!AMARTINIQUEMQMTQMartiniquef2014-09-26 20:10:13.8281797 AGAMBIAGMGMBGambiaf2014-09-26 20:10:13.823537C %%ACOOK ISLANDSCKCOKCook Islandsf2014-09-26 20:10:13.8177688 ABELARUSBYBLRBelaruspf2014-09-26 20:10:13.812789C %%ATURKMENISTANTMTKMTurkmenistanf2014-09-26 20:10:13.8080437 ANORWAYNONORNorwayBf2014-09-26 20:10:13.802797K --AMARSHALL ISLANDSMHMHLMarshall IslandsHf2014-09-26 20:10:13.797502u WWACONGO, THE DEMOCRATIC REPUBLIC OF THECDCODCongo, the Democratic Republic of thef2014-09-26 20:10:13.7928277 ATURKEYTRTURTurkeyf2014-09-26 20:10:13.787366[ ==ANORTHERN MARIANA ISLANDSMPMNPNorthern Mariana IslandsDf2014-09-26 20:10:13.7818415 AMALTAMTMLTMaltaf2014-09-26 20:10:13.7766685 AGABONGAGABGabon f2014-09-26 20:10:13.7703535 ACONGOCGCOGCongof2014-09-26 20:10:13.764528: ABARBADOSBBBRBBarbados4f2014-09-26 20:10:13.7581679 ATUNISIATNTUNTunisiaf2014-09-26 20:10:13.752306G ))ANORFOLK ISLANDNFNFKNorfolk Island>f2014-09-26 20:10:13.7469613 AMALIMLMLIMalif2014-09-26 20:10:13.741850K --AFRENCH POLYNESIAPFPYFFrench Polynesiaf2014-09-26 20:10:13.7366519 ACOMOROSKMCOMComorost2014-09-26 20:10:13.731645>~ !!ABANGLADESHBDBGDBangladesh2f2014-09-26 20:10:13.725795Q} 33ATRINIDAD AND TOBAGOTTTTOTrinidad and Tobago f2014-09-26 20:10:13.720577;| AMALDIVESMVMDVMaldivesf2014-09-26 20:10:13.714818;{ ACOLOMBIACOCOLColombiaf2014-09-26 20:10:13.7088548z ABAHRAINBHBHRBahrain0f2014-09-26 20:10:13.702936  tC  .mp3//tablespree_log_entriesspree_log_entriesrCREATE 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) 411Atablespree_optiop3//tablespree_log_entriesspree_log_entriesrCREATE 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) 411Atablespree_option_typesspree_option_typestCREATE 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)&5GGKtablespree_option_types_prototypesspree_option_types_prototypesuCREATE TABLE "spree_option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)633Qtablespree_option_valuesspree_option_valuesvCREATE 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)27c3Yindexindex_spree_option_values_on_option_type_idspree_option_valuesCREATE INDEX "index_spree_option_values_on_option_type_id" ON "spree_option_values" ("option_type_id")"8EEGtablespree_option_values_variantsspree_option_values_variantswCREATE TABLE "spree_option_values_variants" ("variant_id" integer, "option_value_id" integer)y9 E/indexindex_option_values_variants_on_variant_id_and_option_value_idspree_option_values_variantsxCREATE 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_variantsyCREATE INDEX "index_spree_option_values_variants_on_variant_id" ON "spree_option_values_variants" ("variant_id")c;%% tablespree_ordersspree_orderszCREATE 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')<Q%5indexindex_spree_orders_on_completed_atspree_orders|CREATE INDEX "index_spree_orders_on_completed_at" ON "spree_orders" ("completed_at")~=E%indexindex_spree_orders_on_numberspree_ordersCREATE INDEX "index_spree_orders_on_number" ON "spree_orders" ("number")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")?G%!indexindex_spree_orders_on_user_idspree_ordersCREATE INDEX "index_spree_orders_on_user_id" ON "spree_orders" ("user_id")@;;3tablespree_orders_promotionsspree_orders_promotionsCREATE TABLE "spree_orders_promotions" ("order_id" integer, "promotion_id" integer)  7#^ N s bd AEEtablespree_payment_capture_eventsspree_payment_capture_eventsCREATE TABLE "spree_payment_capture_events" ("id" INTEGER PRIMARY KEY AUTOINCREMEN AEEtablespree_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)JBmEmindexindex_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")C77Etablespree_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)0Da7Sindexindex_spree_payment_methods_on_id_and_typespree_payment_methodsCREATE INDEX "index_spree_payment_methods_on_id_and_type" ON "spree_payment_methods" ("id", "type")hE)) 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)) FM)-indexindex_spree_payments_on_order_idspree_paymentsCREATE INDEX "index_spree_payments_on_order_id" ON "spree_payments" ("order_id")'G_)Qindexindex_spree_payments_on_payment_method_idspree_paymentsCREATE INDEX "index_spree_payments_on_payment_method_id" ON "spree_payments" ("payment_method_id")lH//tablespree_preferencesspree_preferencesCREATE TABLE "spree_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "value" text, "key" varchar(255), "value_type" varchar(255), "created_at" datetime, "updated_at" datetime)II/3indexindex_spree_preferences_on_keyspree_preferencesCREATE UNIQUE INDEX "index_spree_preferences_on_key" ON "spree_preferences" ("key")YJ%%stablespree_pricesspree_pricesCREATE 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)0Kg%_indexindex_spree_prices_on_variant_id_and_currencyspree_pricesCREATE INDEX "index_spree_prices_on_variant_id_and_currency" ON "spree_prices" ("variant_id", "currency")LAA'tablespree_product_option_typesspree_product_option_typesCREATE 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)&M==]tablespree_product_propertiesspree_product_propertiesCREATE 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).NY=Qindexindex_product_properties_on_product_idspree_product_propertiesCREATE INDEX "index_product_properties_on_product_id" ON "spree_product_properties" ("product_id")O))otablespree_productsspree_productsPCREATE 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) CKt> K T D zc-QQ)5indexindex_sprPU)=indexindex_spree_products_on_available_onspree_productsCREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on")QQ)5indexindex_spree_products_on_deleted_atspree_productsCREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")RE)indexindex_spree_products_on_namespree_productsCREATE IPU)=indexindex_spree_products_on_available_onspree_productsCREATE INDEX "index_spree_products_on_available_on" ON "spree_products" ("available_on")QQ)5indexindex_spree_products_on_deleted_atspree_productsCREATE INDEX "index_spree_products_on_deleted_at" ON "spree_products" ("deleted_at")RE)indexindex_spree_products_on_namespree_productsCREATE INDEX "index_spree_products_on_name" ON "spree_products" ("name")SE)indexindex_spree_products_on_slugspree_productsCREATE INDEX "index_spree_products_on_slug" ON "spree_products" ("slug")wT5)indexpermalink_idx_uniquespree_productsCREATE UNIQUE INDEX "permalink_idx_unique" ON "spree_products" ("slug")+UIIOtablespree_products_promotion_rulesspree_products_promotion_rulesCREATE TABLE "spree_products_promotion_rules" ("product_id" integer, "promotion_rule_id" integer)FVeIiindexindex_products_promotion_rules_on_product_idspree_products_promotion_rulesCREATE INDEX "index_products_promotion_rules_on_product_id" ON "spree_products_promotion_rules" ("product_id")[WsIindexindex_products_promotion_rules_on_promotion_rule_idspree_products_promotion_rulesCREATE INDEX "index_products_promotion_rules_on_promotion_rule_id" ON "spree_products_promotion_rules" ("promotion_rule_id")LX775tablespree_products_taxonsspree_products_taxonsCREATE TABLE "spree_products_taxons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "taxon_id" integer, "position" integer).Y_7Qindexindex_spree_products_taxons_on_product_idspree_products_taxonsCREATE INDEX "index_spree_products_taxons_on_product_id" ON "spree_products_taxons" ("product_id")(Z[7Iindexindex_spree_products_taxons_on_taxon_idspree_products_taxonsCREATE INDEX "index_spree_products_taxons_on_taxon_id" ON "spree_products_taxons" ("taxon_id")[OOwtablespree_promotion_action_line_itemsspree_promotion_action_line_itemsCREATE TABLE "spree_promotion_action_line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_action_id" integer, "variant_id" integer, "quantity" integer DEFAULT 1)l\;;mtablespree_promotion_actionsspree_promotion_actionsCREATE TABLE "spree_promotion_actions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "promotion_id" integer, "position" integer, "type" varchar(255), "deleted_at" datetime)6]c;Yindexindex_spree_promotion_actions_on_deleted_atspree_promotion_actionsCREATE INDEX "index_spree_promotion_actions_on_deleted_at" ON "spree_promotion_actions" ("deleted_at")8^e;[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;aindexindex_spree_promotion_actions_on_promotion_idspree_promotion_actionsCREATE INDEX "index_spree_promotion_actions_on_promotion_id" ON "spree_promotion_actions" ("promotion_id")-`77wtablespree_promotion_rulesspree_promotion_rulesCREATE 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))4a_7]indexindex_promotion_rules_on_product_group_idspree_promotion_rulesCREATE INDEX "index_promotion_rules_on_product_group_id" ON "spree_promotion_rules" ("product_group_id")bM79indexindex_promotion_rules_on_user_idspree_promotion_rulesCREATE INDEX "index_promotion_rules_on_user_id" ON "spree_promotion_rules" ("user_id") H  s h {  [ pcCCCtablespree_promotion_rules_usersspree_promotion_rules_usersCREATE TABLE "spree_promotion_rules_users" ("user_id" integer, "promotion_rule_id" integer)OdmCyindexindex_promotion_rules_users_on_promotion_rule_idspree_promotion_rules_usersCREATE INDEX "index_promotion_rules_users_on_promotion_rule_id" ON "spree_promotion_rules_users" ("promotion_rule_id")1eYCQindexindex_promotion_rules_users_on_user_idspree_promotion_rules_usersCREATE INDEX "index_promotion_rules_users_on_user_id" ON "spree_promotion_rules_users" ("user_id"),f-- tablespree_promotionsspree_promotionsZCREATE 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)gW-?indexindex_spree_promotions_on_id_and_typespree_promotionsCREATE INDEX "index_spree_promotions_on_id_and_type" ON "spree_promotions" ("id", "type")hh--tablespree_propertiesspree_propertiesCREATE TABLE "spree_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentation" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)iCCAtablespree_properties_prototypesspree_properties_prototypessCREATE TABLE "spree_properties_prototypes" ("prototype_id" integer, "property_id" integer)Bj--5tablespree_prototypesspree_prototypesCREATE TABLE "spree_prototypes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)hkCCUtablespree_return_authorizationsspree_return_authorizationsCREATE 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)l##Otablespree_rolesspree_rolesCREATE TABLE "spree_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))wm//tablespree_roles_usersspree_roles_usersCREATE TABLE "spree_roles_users" ("role_id" integer, "user_id" integer)nQ/5indexindex_spree_roles_users_on_role_idspree_roles_usersCREATE INDEX "index_spree_roles_users_on_role_id" ON "spree_roles_users" ("role_id")oQ/5indexindex_spree_roles_users_on_user_idspree_roles_usersCREATE INDEX "index_spree_roles_users_on_user_id" ON "spree_roles_users" ("user_id")Cp++=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, "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))~q?+indexindex_shipments_on_numberspree_shipmentsCREATE INDEX "index_shipments_on_number" ON "spree_shipments" ("number")rO+1indexindex_spree_shipments_on_order_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_order_id" ON "spree_shipments" ("order_id")+sa+Uindexindex_spree_shipments_on_stock_location_idspree_shipmentsCREATE INDEX "index_spree_shipments_on_stock_location_id" ON "spree_shipments" ("stock_location_id")]t??Gtablespree_shipping_categoriesspree_shipping_categoriesCREATE TABLE "spree_shipping_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) ) hY  d 2 &  [ pcCCCtablespree_promotion_rules_usersspree_promotion_rules_usersCREATE TABLE "spree_promotion_rules_users" ("user_id" integer, "promotion_rule_id" integer)OdmCyindexindex_promotion_rules_users_on_promotion_rule_idspree_promotion_rules_usersCREATE INDEX "index_promotion_rules_users_on_promotion_rule_id" ON "spree_promotion-uMMKtablespree_shipping_method_categoriesspree_shipping_method_categoriesCREATE TABLE "spree_shipping_method_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "shipping_method_id" integer NOT NULL, "shipping_category_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)gv[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")swMindexindex_spree_shipping_method_categories_on_shipping_method_idspree_shipping_method_categoriesCREATE INDEX "index_spree_shipping_method_categories_on_shipping_method_id" ON "spree_shipping_method_categories" ("shipping_method_id")Yx99Ktablespree_shipping_methodsspree_shipping_methodsCREATE 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)#yEEGtablespree_shipping_methods_zonesspree_shipping_methods_zonesCREATE TABLE "spree_shipping_methods_zones" ("shipping_method_id" integer, "zone_id" integer)Fz55-tablespree_shipping_ratesspree_shipping_ratesCREATE TABLE "spree_shipping_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "shipment_id" integer, "shipping_method_id" integer, "selected" boolean DEFAULT 'f', "cost" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "tax_rate_id" integer)6{K5windexspree_shipping_rates_join_indexspree_shipping_ratesCREATE UNIQUE INDEX "spree_shipping_rates_join_index" ON "spree_shipping_rates" ("shipment_id", "shipping_method_id")M|33?tablespree_state_changesspree_state_changesCREATE 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)J}%%Utablespree_statesspree_statesCREATE TABLE "spree_states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country_id" integer, "updated_at" datetime)K~//Ctablespree_stock_itemsspree_stock_itemsCREATE TABLE "spree_stock_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stock_location_id" integer, "variant_id" integer, "count_on_hand" integer DEFAULT 0 NOT NULL, "created_at" datetime, "updated_at" datetime, "backorderable" boolean DEFAULT 'f', "deleted_at" datetime)!E/Yindexstock_item_by_loc_and_var_idspree_stock_itemsCREATE INDEX "stock_item_by_loc_and_var_id" ON "spree_stock_items" ("stock_location_id", "variant_id")3e/]indexindex_spree_stock_items_on_stock_location_idspree_stock_itemsCREATE INDEX "index_spree_stock_items_on_stock_location_id" ON "spree_stock_items" ("stock_location_id")77[tablespree_stock_locationsspree_stock_locationsCREATE 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))  u ? f & -uMMKtablespree_shipping_method_categoriesspree_shipping_method_categoriesCREATE TABLE "spree_shipping_method_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "shipping_method_id" integer NOT NULL, "shipping_category_id" integer NOT NULL, "created_at" datetime, "updated_at" datetime)gv[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")swMindexindex_spree_shipping_method_categories_on_shipping_method_idspree_shipping_method_categoriesCREATE INDEX "index_spree_shipping_method_C77#tablespree_stock_movementsspree_stock_movementsCREATE TABLE "spree_stock_movements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stock_item_id" integer, "quantity" integer DEFAULT 0, "action" varchar(255), "created_at" datetime, "updated_at" datetime, "originator_id" integer, "originator_type" varchar(255))7e7]indexindex_spree_stock_movements_on_stock_item_idspree_stock_movementsCREATE INDEX "index_spree_stock_movements_on_stock_item_id" ON "spree_stock_movements" ("stock_item_id")C77#tablespree_stock_transfersspree_stock_transfersCREATE 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))Uy7indexindex_spree_stock_transfers_on_destination_location_idspree_stock_transfersCREATE INDEX "index_spree_stock_transfers_on_destination_location_id" ON "spree_stock_transfers" ("destination_location_id")"W7Aindexindex_spree_stock_transfers_on_numberspree_stock_transfersCREATE INDEX "index_spree_stock_transfers_on_number" ON "spree_stock_transfers" ("number")Fo7qindexindex_spree_stock_transfers_on_source_location_idspree_stock_transfersCREATE INDEX "index_spree_stock_transfers_on_source_location_id" ON "spree_stock_transfers" ("source_location_id")#55gtablespree_tax_categoriesspree_tax_categoriesCREATE 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)n ++tablespree_tax_ratesspree_tax_ratesCREATE TABLE "spree_tax_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal(8,5), "zone_id" integer, "tax_category_id" integer, "included_in_price" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "name" varchar(255), "show_rate_in_label" boolean DEFAULT 't', "deleted_at" datetime)i --tablespree_taxonomiesspree_taxonomiesCREATE 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)7 %%/tablespree_taxonsspree_taxonsCREATE TABLE "spree_taxons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "position" integer DEFAULT 0, "name" varchar(255) NOT NULL, "permalink" varchar(255), "taxonomy_id" integer, "lft" integer, "rgt" integer, "icon_file_name" varchar(255), "icon_content_type" varchar(255), "icon_file_size" integer, "icon_updated_at" datetime, "description" text, "created_at" datetime, "updated_at" datetime, "meta_title" varchar(255), "meta_description" varchar(255), "meta_keywords" varchar(255), "depth" integer) .CW 1 I q 9 ` ' g /oOUUt?d !!AMONTENEGROMEMNEMontenegrof2014-09-26 20:10:14.3044567c ASERBIARSSRBSerbiaf2014-09-26 20:10:14.299472Ub 77ASAINT KITTS AND NEVISKNKNASaint Kitts and Nevist2014-09-26 20:10:14.293979Aa ##ANEW ZEALANDNZNZLNew Zealand*f2014-09-26 20:10:14.288021^` aAMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OFMKMKDMacedonia'f2014-09-26 20:10:14.2823859_ AICELANDISISLIceland`f2014-09-26 20:10:14.277529a^ CCAFALKLAND ISLANDS (MALVINAS)FKFLKFalkland Islands (Malvinas)f2014-09-26 20:10:14.271889[] ==ACENTRAL AFRICAN REPUBLICCFCAFCentral African Republicf2014-09-26 20:10:14.267145;\ AZIMBABWEZWZWEZimbabwef2014-09-26 20:10:14.262819E[ ''ANEW CALEDONIANCNCLNew Caledoniaf2014-09-26 20:10:14.2581425Z AMACAOMOMACMacaof2014-09-26 20:10:14.2520899Y AHUNGARYHUHUNHungary\f2014-09-26 20:10:14.247525;X AETHIOPIAETETHEthiopiat2014-09-26 20:10:14.242470GW ))ACAYMAN ISLANDSKYCYMCayman Islandsf2014-09-26 20:10:14.2370017V AZAMBIAZMZMBZambia~f2014-09-26 20:10:14.232186CU %%ASAINT HELENASHSHNSaint Helenaf2014-09-26 20:10:14.226439ST 55ANETHERLANDS ANTILLESANANTNetherlands Antillesf2014-09-26 20:10:14.221219?S !!ALUXEMBOURGLULUXLuxembourgf2014-09-26 20:10:14.2149709R AESTONIAEEESTEstoniaf2014-09-26 20:10:14.209730?Q !!ACAPE VERDECVCPVCape Verdef2014-09-26 20:10:14.2042805P AYEMENYEYEMYemenwf2014-09-26 20:10:14.199245AO ##ANETHERLANDSNLNLDNetherlandsf2014-09-26 20:10:14.194551=N ALITHUANIALTLTULithuaniaf2014-09-26 20:10:14.1896969M AERITREAERERIEritreaf2014-09-26 20:10:14.1850786L ACANADACACANCanada|t2014-09-26 20:10:14.180275 ;;AVIRGIN ISLANDS, BRITISHVGVGBVirgin Islands, British\f2014-09-26 20:10:14.1038829= ALIBERIALRLBRLiberiaf2014-09-26 20:10:14.0982948< ABURUNDIBIBDIBurundilf2014-09-26 20:10:14.0929126; AANGOLAAOAGOAngolaf2014-09-26 20:10:14.0871689: ALESOTHOLSLSOLesothof2014-09-26 20:10:14.081851C9 %%ABURKINA FASOBFBFABurkina FasoVf2014-09-26 20:10:14.07646888 AANDORRAADANDAndorraf2014-09-26 20:10:14.07067397 ALEBANONLBLBNLebanonf2014-09-26 20:10:14.064222 .CW 1 I q 9 ` ' g /oOUUt?d !!AMONTENEGROMEMNEMontenegrof2014-09-22 02:17:22.1379757c ASERBIARSSRBSerbiaf2014-09-22 02:17:22.132862Ub 77ASAINT KITTS AND NEVISKNKNASaint Kitts and Nevist2014-09-22 02:17:22.127084Aa ##ANEW ZEALANDNZNZLNew Zealand*f2014-09-22 02:17:22.121669^` aAMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OFMKMKDMacedonia'f2014-09-22 02:17:22.1165009_ AICELANDISISLIceland`f2014-09-22 02:17:22.104951a^ CCAFALKLAND ISLANDS (MALVINAS)FKFLKFalkland Islands (Malvinas)f2014-09-22 02:17:22.099574[] ==ACENTRAL AFRICAN REPUBLICCFCAFCentral African Republicf2014-09-22 02:17:22.087493;\ AZIMBABWEZWZWEZimbabwef2014-09-22 02:17:22.080921E[ ''ANEW CALEDONIANCNCLNew Caledoniaf2014-09-22 02:17:22.0754255Z AMACAOMOMACMacaof2014-09-22 02:17:22.0701719Y AHUNGARYHUHUNHungary\f2014-09-22 02:17:22.064642;X AETHIOPIAETETHEthiopiat2014-09-22 02:17:22.059664GW ))ACAYMAN ISLANDSKYCYMCayman Islandsf2014-09-22 02:17:22.0550447V AZAMBIAZMZMBZambia~f2014-09-22 02:17:22.049876CU %%ASAINT HELENASHSHNSaint Helenaf2014-09-22 02:17:22.045029ST 55ANETHERLANDS ANTILLESANANTNetherlands Antillesf2014-09-22 02:17:22.040103?S !!ALUXEMBOURGLULUXLuxembourgf2014-09-22 02:17:22.0356419R AESTONIAEEESTEstoniaf2014-09-22 02:17:22.029852?Q !!ACAPE VERDECVCPVCape Verdef2014-09-22 02:17:22.0239815P AYEMENYEYEMYemenwf2014-09-22 02:17:22.001065AO ##ANETHERLANDSNLNLDNetherlandsf2014-09-22 02:17:21.996256=N ALITHUANIALTLTULithuaniaf2014-09-22 02:17:21.9911339M AERITREAERERIEritreaf2014-09-22 02:17:21.9835776L ACANADACACANCanada|t2014-09-22 02:17:21.970690 ;;AVIRGIN ISLANDS, BRITISHVGVGBVirgin Islands, British\f2014-09-22 02:17:21.8594339= ALIBERIALRLBRLiberiaf2014-09-22 02:17:21.8537578< ABURUNDIBIBDIBurundilf2014-09-22 02:17:21.8487676; AANGOLAAOAGOAngolaf2014-09-22 02:17:21.8437149: ALESOTHOLSLSOLesothof2014-09-22 02:17:21.837888C9 %%ABURKINA FASOBFBFABurkina FasoVf2014-09-22 02:17:21.83185588 AANDORRAADANDAndorraf2014-09-22 02:17:21.82627297 ALEBANONLBLBNLebanonf2014-09-22 02:17:21.820164 $ }KIEK{ ?%indexinde~))5tablespree_trackersspree_trackersCREATE TABLE "spree_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "analytics_id" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime):GCuindexindex_tokenized_name_and_typespree_tokenized_permissionsCREATE INDEX "index_tokenized_name_and##ytablespree_zonesspree_zonesCREATE TABLE "spree_zones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "default_tax" boolean DEFAULT 'f', "zone_members_count" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime){11tablespree_zone_membersspree_zone_membersCREATE TABLE "spree_zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zoneable_id" integer, "zoneable_type" varchar(255), "zone_id" integer, "created_at" datetime, "updated_at" datetime)![)Iindexindex_spree_variants_on_tax_category_idspree_variantsCREATE INDEX "index_spree_variants_on_tax_category_id" ON "spree_variants" ("tax_category_id")}C)indexindex_spree_variants_on_skuspree_variantsCREATE INDEX "index_spree_variants_on_sku" ON "spree_variants" ("sku")Q)5indexindex_spree_variants_on_product_idspree_variantsCREATE INDEX "index_spree_variants_on_product_id" ON "spree_variants" ("product_id")z))/tablespree_variantsspree_variants:CREATE 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_users_on_spree_api_keyspree_usersCREATE INDEX "index_spree_users_on_spree_api_key" ON "spree_users" ("spree_api_key"){ ?%indexindex_taxons_on_parent_idspree_taxonsCREATE INDEX "index_taxons_on_parent_id" ON "spree_taxons" ("parent_id"){ ?%indexindex_taxons_on_permalinkspree_taxonsCREATE INDEX "index_taxons_on_permalink" ON "spree_taxons" ("permalink")C%%indexindex_taxons_on_taxonomy_idspree_taxonsCREATE INDEX "index_taxons_on_taxonomy_id" ON "spree_taxons" ("taxonomy_id")CCCtablespree_tokenized_permissionsspree_tokenized_permissionsCREATE TABLE "spree_tokenized_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permissable_id" integer, "permissable_type" varchar(255), "token" varchar(255), "created_at" datetime, "updated_at" datetime):GCuindexindex_tokenized_name_and_typespree_tokenized_permissionsCREATE INDEX "index_tokenized_name_and_type" ON "spree_tokenized_permissions" ("permissable_id", "permissable_type")~))5tablespree_trackersspree_trackersCREATE TABLE "spree_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "analytics_id" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)t##-tablespree_usersspree_usersCREATE TABLE "spree_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "encrypted_password" varchar(128), "password_salt" varchar(128), "email" varchar(255), "remember_token" varchar(255), "persistence_token" varchar(255), "reset_password_token" varchar(255), "perishable_token" varchar(255), "sign_in_count" integer DEFAULT 0 NOT NULL, "failed_attempts" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "authentication_token" varchar(255), "unlock_token" varchar(255), "locked_at" datetime, "remember_created_at" datetime, "reset_password_sent_at" datetime, "created_at" datetime, "updated_at" datetime, "spree_api_key" varchar(48))