SQLite format 3@ YY-~}~tt vyihg^][^WNSmksu+HG?LCB:7;23,.%&#ux"!em y*2xw)20100306153445&   zones%zone_members<4 states?EQ rolescountries  {q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")&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), "state_id" integer, "zipcode" varchar(255), "country_id" integer, "phone" varchar(255), "created_at" datetime, "updated_at" datetime, "state_name" varchar(255), "alternative_phone" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) rr~ qtableassetsassets CREATE TABLE "assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "viewable_type" varchar(50), "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "attachment_size" integer, "position" integer, "type" varchar(75), "attachment_updated_at" datetime, "attachment_width" integer, "attachment_height" integer, "alt" text)   bbbdd}##Atablecalculatorscalculators CREATE 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, "updated_at" datetime)0O ))Ytableconfigurationsconfigurations CREATE TABLE "configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "type" varchar(50)) W)?indexindex_configurations_on_name_and_typeconfigurationsCREATE INDEX "index_configurations_on_name_and_type" ON "configurations" ("name", "type")    [Oz[\iqrC~,Z5Y *d  tablecouponscouponsCREATE TABLE "coupons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "description" varchar(255), "usage_limit" integer, "combine" boolean, "expires_at" datetime, "created_at" datetime, "updated_at" datetime, "starts_at" datetime)S utablecountriescountriesCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_name" varchar(255), "iso" varchar(255), "name" varchar(255), "iso3" varchar(255), "numcode" integer)    88E++Atableinventory_unitsinventory_unitsCREATE TABLE "inventory_units" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer, "order_id" integer, "state" varchar(255), "lock_version" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "shipment_id" integer, "return_authorization_id" integer)!!Ktableline_itemsline_itemsCREATE TABLE "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, "updated_at" datetime){E!indexindex_line_items_on_order_idline_itemsCREATE INDEX "index_line_items_on_order_id" ON "line_items" ("order_id")     3|4--+tableshipping_methodsshipping_methodsCCREATE TABLE "shipping_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zone_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "display_on" varchar(255) DEFAULT NULL)y7))-tabletax_categoriestax_categoriesFCREATE TABLE "tax_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime, "is_default" boolean DEFAULT 'f') 6tablestatesstatesECREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country_id" integer)J333;tableshipping_categoriesshipping_categoriesACREATE TABLE "shipping_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)   iy%%5tableoption_typesoption_typesCREATE TABLE "option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "presentation" varchar(100), "created_at" datetime, "updated_at" datetime, "position" integer DEFAULT 0 NOT NULL)I!%indexindex_line_items_on_variant_idline_itemsCREATE INDEX "index_line_items_on_variant_id" ON "line_items" ("variant_id");;?tableoption_types_prototypesoption_types_prototypes CREATE TABLE "option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)      MMS''Etableoption_valuesoption_values!CREATE TABLE "option_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "option_type_id" integer, "name" varchar(255), "position" integer, "presentation" varchar(255), "created_at" datetime, "updated_at" datetime)99;tableoption_values_variantsoption_values_variants#CREATE TABLE "option_values_variants" ("variant_id" integer, "option_value_id" integer)1a9Uindexindex_option_values_variants_on_variant_idoption_values_variants$CREATE INDEX "index_option_values_variants_on_variant_id" ON "option_values_variants" ("variant_id")g|!55tableproduct_option_typesproduct_option_types,CREATE TABLE "product_option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "option_type_id" integer, "position" integer, "created_at" datetime, "updated_at" datetime)    DD<u"11tableproduct_propertiesproduct_properties-CREATE TABLE "product_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "property_id" integer, "value" varchar(255), "created_at" datetime, "updated_at" datetime)A#Utableproductsproducts/CREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) DEFAULT '' NOT NULL, "description" text, "created_at" datetime, "updated_at" datetime, "permalink" varchar(255), "available_on" datetime, "tax_category_id" integer, "shipping_category_id" integer, "deleted_at" datetime, "meta_description" varchar(255), "meta_keywords" varchar(255), "count_on_hand" integer DEFAULT 0 NOT NULL)    2|p^L:(tbP>,xfTB0 |2)201008111636371)201006241755470)20100624123336/)20100624110730.)20100605152042-)20100528185820,)20100528155333+)20100506185838*)20100506180619))20100504142133()20100427121301')20100317120946&)20100306153445%)20100301163454$)20100224153127#)20100223183812")20100223170312!)20100214212536 )20100213103131)20100209144531)20100209025806)20100126103714)20100125145351)20100121183934)20100121160010)20100113203104)20100113090919)20100112151511)20100111205525)20100105132138)20100105090147)20091214183826)20091213222815)20091212161118)20091211203813)20091209202200)20091209153045 )20091126190904 )20091104151730 )20091021133257 )20091017175558 )20091016174634)20091015153048)20091015110842)20091012120519)20091008091614)20091007134354)20090923100315)20090904192342)20090823005402   HZ;D))1tableproduct_scopesproduct_scopesCREATE TABLE "product_scopes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_group_id" integer, "name" varchar(255), "arguments" text)EE)indexindex_product_groups_on_nameproduct_groupsUCREATE INDEX "index_product_groups_on_name" ON "product_groups" ("name")FO)1indexindex_product_groups_on_permalinkproduct_groupsVCREATE INDEX "index_product_groups_on_permalink" ON "product_groups" ("permalink")GE)indexindex_product_scopes_on_nameproduct_scopesWCREATE INDEX "index_product_scopes_on_name" ON "product_scopes" ("name")#H])Mindexindex_product_scopes_on_product_group_idproduct_scopesXCREATE INDEX "index_product_scopes_on_product_group_id" ON "product_scopes" ("product_group_id")   $I%indexindex_products_on_available_onproducts0CREATE INDEX "index_products_on_available_on" ON "products" ("available_on")y%Eindexindex_products_on_deleted_atproducts1CREATE INDEX "index_products_on_deleted_at" ON "products" ("deleted_at")     prg&9indexindex_products_on_nameproducts2CREATE INDEX "index_products_on_name" ON "products" ("name")v'Cindexindex_products_on_permalinkproducts4CREATE INDEX "index_products_on_permalink" ON "products" ("permalink")t(++tableproducts_taxonsproducts_taxons5CREATE TABLE "products_taxons" ("product_id" integer, "taxon_id" integer))S+9indexindex_products_taxons_on_product_idproducts_taxons6CREATE INDEX "index_products_taxons_on_product_id" ON "products_taxons" ("product_id")*O+1indexindex_products_taxons_on_taxon_idproducts_taxons7CREATE INDEX "index_products_taxons_on_taxon_id" ON "products_taxons" ("taxon_id")U+!!utablepropertiesproperties8CREATE TABLE "properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentation" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime) ,775tableproperties_prototypesproperties_prototypes9CREATE TABLE "properties_prototypes" ("prototype_id" integer, "property_id" integer)        $Ntx$Q2qtableshipmentsshipments@CREATE TABLE "shipments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "shipping_method_id" integer, "tracking" varchar(255), "created_at" datetime, "updated_at" datetime, "number" varchar(255), "cost" decimal(8,2), "shipped_at" datetime, "address_id" integer, "state" varchar(255))|1E#indexindex_roles_users_on_user_idroles_users?CREATE INDEX "index_roles_users_on_user_id" ON "roles_users" ("user_id")|0E#indexindex_roles_users_on_role_idroles_users>CREATE INDEX "index_roles_users_on_role_id" ON "roles_users" ("role_id")d/##tableroles_usersroles_users=CREATE TABLE "roles_users" ("role_id" integer, "user_id" integer)r.Ctablerolesroles%%tablezone_memberszone_membersPCREATE TABLE "zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zone_id" integer, "zoneable_id" integer, "zoneable_type" varchar(255), "created_at" datetime, "updated_at" datetime)&==CENTRAL AFRICAN REPUBLICCFCentral African RepublicCAF'CHADTDChadTCD(CHILECLChileCHL)CHINACNChinaCHN*COLOMBIACOColombiaCOL+COMOROSKMComorosCOM,CONGOCGCongoCOGX-WWCONGO, THE DEMOCRATIC REPUBLIC OF THECDCongo, the Democratic Republic of theCOD&.%%COOK ISLANDSCKCook IslandsCOK"/!!COSTA RICACRCosta RicaCRI(0''COTE D'IVOIRECICote D'IvoireCIV1CROATIAHRCroatiaHRV2CUBACUCubaCUB3CYPRUSCYCyprusCYP*4))CZECH REPUBLICCZCzech RepublicCZE5DENMARKDKDenmarkDNK z4Rlz Jb,JhD@CCFALKLAND ISLANDS (MALVINAS)FKFalkland Islands (Malvinas)FLK6DJIBOUTIDJDjiboutiDJI7DOMINICADMDominicaDMA2811DOMINICAN REPUBLICDODominican RepublicDOM9ECUADORECEcuadorECU:EGYPTEGEgyptEGY2$;##EL SALVADORSVEl SalvadorSLV0<//EQUATORIAL GUINEAGQEquatorial GuineaGNQ=ERITREAEREritreaERI>ESTONIAEEEstoniaEST?ETHIOPIAETEthiopiaETH(A''FAROE ISLANDSFOFaroe IslandsFROBFIJIFJFijiFJICFINLANDFIFinlandFINDFRANCEFRFranceFRA(E''FRENCH GUIANAGFFrench GuianaGUF.F--FRENCH POLYNESIAPFFrench PolynesiaPYFGGABONGAGabonGAB HGAMBIAGMGambiaGMBIGEORGIAGEGeorgiaGEO JGERMANYDEGermanyDEUKGHANAGHGhanaGHA LGIBRALTARGIGibraltarGIB$MGREECEGRGreeceGRC, NGREENLANDGLGreenlandGRL0OGRENADAGDGrenadaGRD4 %A[#=_ +Ea"P!!GUADELOUPEGPGuadeloupeGLP8QGUAMGUGuamGUM< RGUATEMALAGTGuatemalaGTM@SGUINEAGNGuineaGIND(T''GUINEA-BISSAUGWGuinea-BissauGNBpUGUYANAGYGuyanaGUYHVHAITIHTHaitiHTILHWGGHOLY SEE (VATICAN CITY STATE)VAHoly See (Vatican City State)VATPXHONDURASHNHondurasHNDT YHONG KONGHKHong KongHKGXZHUNGARYHUHungaryHUN\[ICELANDISIcelandISL`\INDIAINIndiaINDd ]INDONESIAIDIndonesiaIDNh@^??IRAN, ISLAMIC REPUBLIC OFIRIran, Islamic Republic ofIRNl_IRAQIQIraqIRQp`IRELANDIEIrelandIRLtaISRAELILIsraelISRxbITALYITItalyITA|cJAMAICAJMJamaicaJAMdJAPANJPJapanJPNeJORDANJOJordanJOR"f!!KAZAKHSTANKZKazakhstanKAZgKENYAKEKenyaKENhKIRIBATIKIKiribatiKIR(?iY#KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OFKPNorth KoreaPRK +7X%%1tablestate_eventsstate_eventsDCREATE TABLE "state_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stateful_id" integer, "user_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "previous_state" varchar(255), "stateful_type" varchar(255), "next_state" varchar(255))ZU+=indexindex_inventory_units_on_shipment_idinventory_unitsCREATE INDEX "index_inventory_units_on_shipment_id" ON "inventory_units" ("shipment_id")7[77 tablereturn_authorizationsreturn_authorizationshCREATE TABLE "return_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "reason" text, "state" varchar(255), "created_at" datetime, "updated_at" datetime) __ltTCindexindex_assets_on_viewable_idassetsbCREATE INDEX "index_assets_on_viewable_id" ON "assets" ("viewable_id")UYCindexindex_assets_on_viewable_type_and_typeassetscCREATE INDEX "index_assets_on_viewable_type_and_type" ON "assets" ("viewable_type", "type")!VY1Eindexindex_product_properties_on_product_idproduct_propertiesdCREATE INDEX "index_product_properties_on_product_id" ON "product_properties" ("product_id")mW 9#indexindex_option_values_variants_on_variant_id_and_option_value_idoption_values_variantsfCREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "option_values_variants" ("variant_id", "option_value_id")       latableordersorders%CREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "number" varchar(15), "item_total" decimal DEFAULT 0.0 NOT NULL, "total" decimal DEFAULT 0.0 NOT NULL, "created_at" datetime, "updated_at" datetime, "state" varchar(255), "adjustment_total" decimal DEFAULT 0.0 NOT NULL, "credit_total" decimal DEFAULT 0.0 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)em9indexindex_orders_on_numberorders'CREATE INDEX "index_orders_on_number" ON "orders" ("number")  }}k\)tabletrackerstrackersjCREATE TABLE "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)];;?tableproduct_groups_productsproduct_groups_productskCREATE TABLE "product_groups_products" ("product_id" integer, "product_group_id" integer)  zdEindexindex_addresses_on_firstnameaddressesoCREATE INDEX "index_addresses_on_firstname" ON "addresses" ("firstname")weCindexindex_addresses_on_lastnameaddressespCREATE INDEX "index_addresses_on_lastname" ON "addresses" ("lastname")qh?indexindex_shipments_on_numbershipmentstCREATE INDEX "index_shipments_on_number" ON "shipments" ("number")    QQij++ tablepayment_methodspayment_methodslCREATE TABLE "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, "updated_at" datetime, "deleted_at" datetime, "display_on" varchar(255))@k##Gtablepreferencespreferences)CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" text(255), "created_at" datetime, "updated_at" datetime)    +{-Wy:Zz+j1#KOREA, REPUBLIC OFKRSouth KoreaKORkKUWAITKWKuwaitKWT"l!!KYRGYZSTANKGKyrgyzstanKGZNmMMLAO PEOPLE'S DEMOCRATIC REPUBLICLALao People's Democratic RepublicLAOnLATVIALVLatviaLVAoLEBANONLBLebanonLBNpLESOTHOLSLesothoLSOqLIBERIALRLiberiaLBR:r99LIBYAN ARAB JAMAHIRIYALYLibyan Arab JamahiriyaLBY(s''LIECHTENSTEINLILiechtensteinLIE tLITHUANIALTLithuaniaLTU"u!!LUXEMBOURGLULuxembourgLUXvMACAOMOMacaoMACAwaMACEDONIA, THE FORMER YUGOSLAV REPUBLIC OFMKMacedoniaMKD'"x!!MADAGASCARMGMadagascarMDGyMALAWIMWMalawiMWIzMALAYSIAMYMalaysiaMYS{MALDIVESMVMaldivesMDV|MALIMLMaliMLI}MALTAMTMaltaMLT.~--MARSHALL ISLANDSMHMarshall IslandsMHLH"!!MARTINIQUEMQMartiniqueMTQ bb6q*Kl ;\@-??SAINT PIERRE AND MIQUELONPMSaint Pierre and MiquelonSPMN.MMSAINT VINCENT AND THE GRENADINESVCSaint Vincent and the GrenadinesVCT/SAMOAWSSamoaWSMr"0!!SAN MARINOSMSan MarinoSMR8177SAO TOME AND PRINCIPESTSao Tome and PrincipeSTP&2%%SAUDI ARABIASASaudi ArabiaSAU3SENEGALSNSenegalSEN"4!!SEYCHELLESSCSeychellesSYC&5%%SIERRA LEONESLSierra LeoneSLE 6SINGAPORESGSingaporeSGP7SLOVAKIASKSlovakiaSVK8SLOVENIASISloveniaSVN+9++SOLOMON ISLANDSSBSolomon IslandsSLBZ:SOMALIASOSomaliaSOM&;%%SOUTH AFRICAZASouth AfricaZAF<SPAINESSpainESP =SRI LANKALKSri LankaLKA>SUDANSDSudanSDN?SURINAMESRSurinameSUR:@99SVALBARD AND JAN MAYENSJSvalbard and Jan MayenSJM ASWAZILANDSZSwazilandSWZBSWEDENSESwedenSWE$C##SWITZERLANDCHSwitzerlandCHE EEnn/tablepaymentspayments(CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "source_id" integer, "source_type" varchar(255), "payment_method_id" integer, "state" varchar(255), "response_code" varchar(255), "avs_response" varchar(255))Zt%%wtablemail_methodsmail_methods{CREATE TABLE "mail_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)ju##tableadjustmentsadjustmentsCREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "locked" boolean, "originator_id" integer, "originator_type" varchar(255))  * vG#!indexindex_adjustments_on_order_idadjustmentsnCREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id")^w##tablelog_entrieslog_entries|CREATE TABLE "log_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "source_type" varchar(255), "details" text, "created_at" datetime, "updated_at" datetime)rx##+tablecreditcardscreditcards CREATE TABLE "creditcards" ("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), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255)) by#tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255)) %AATgz%8K^q /BUh{)20090823005402)20090904192342)20090923100315)20091007134354)20091008091614)20091012120519)20091015110842)20091015153048)20091016174634 )20091017175558 )20091021133257 )20091104151730 )20091126190904 )20091209153045)20091209202200)20091211203813)20091212161118)20091213222815)20091214183826)20100105090147)20100105132138)20100111205525)20100112151511)20100113090919)20100113203104)20100121160010)20100121183934)20100125145351)20100126103714)20100209025806)20100209144531)20100213103131 )20100214212536!)20100223170312")20100223183812#)20100224153127$)20100301163454% ,Tgz%8K^q /BUh{A.)20110314192118R)20110111122537Q)20110110130847P)20101223215658O)20101117031806N)20101111133551M)20101103212716L)20101028151745K)20100317120946')20100427121301()20100504142133))20100506180619*)20100506185838+)20100528155333,)20100528185820-)20100605152042.)20100624110730/)201006241233360)201006241755471)201008111636372)201008112058363)201008121623264)201008130235025)201008131857456)201008162121467)201008171527238)201008191701259)20100820135707:)20100901171814;)20100903203949<)20100923162011=)20100929151905>)20101008190536?)20101026184700@)20101026184714A)20101026184746B)20101026184808C)20101026184833D)20101026184855E)20101026184916F)20101026184932G)20101026184959H)20101026185022I)20101026192225J p^L:(tbP>,R)20110314192118Q)20110111122537P)20110110130847O)20101223215658N)20101117031806M)20101111133551L)20101103212716K)20101028151745J)20101026192225I)20101026185022H)20101026184959G)20101026184932F)20101026184916E)20101026184855D)20101026184833C)20101026184808B)20101026184746A)20101026184714@)20101026184700?)20101008190536>)20100929151905=)20100923162011<)20100903203949;)20100901171814:)201008201357079)201008191701258)201008171527237)201008162121466)201008131857455)201008130235024)201008121623263)20100811205836 GG?Xw.o.Yx6D55SYRIAN ARAB REPUBLICSYSyrian Arab RepublicSYR-E?TAIWAN, PROVINCE OF CHINATWTaiwanTWN"F!!TAJIKISTANTJTajikistanTJKFGEETANZANIA, UNITED REPUBLIC OFTZTanzania, United Republic ofTZABHTHAILANDTHThailandTHAITOGOTGTogoTGOJTOKELAUTKTokelauTKLKTONGATOTongaTON4L33TRINIDAD AND TOBAGOTTTrinidad and TobagoTTO MTUNISIATNTunisiaTUNNTURKEYTRTurkeyTUR&O%%TURKMENISTANTMTurkmenistanTKM>P==TURKS AND CAICOS ISLANDSTCTurks and Caicos IslandsTCAQTUVALUTVTuvaluTUVRUGANDAUGUgandaUGA SUKRAINEUAUkraineUKR$6T55UNITED ARAB EMIRATESAEUnited Arab EmiratesARE*U))UNITED KINGDOMGBUnited KingdomGBR:(V''UNITED STATESUSUnited StatesUSAHWURUGUAYUYUruguayURYZ"X!!UZBEKISTANUZUzbekistanUZB\YVANUATUVUVanuatuVUT$ ZVENEZUELAVEVenezuelaVEN^[VIET NAMVNViet NamVNM   AAKzM-indexindex_users_on_openid_identifierusersCREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier"){M-indexindex_users_on_persistence_tokenusersKCREATE INDEX "index_users_on_persistence_token" ON "users" ("persistence_token")2|C# indexix_prefs_on_owner_attr_prefpreferencesSCREATE UNIQUE INDEX "ix_prefs_on_owner_attr_pref" ON "preferences" ("owner_id", "owner_type", "name", "group_id", "group_type") }^{?X ?^}8+77SAINT KITTS AND NEVISKNSaint Kitts and NevisKNANIGERIANGNigeriaNGA6NIUENUNiueNIU:*))NORFOLK ISLANDNFNorfolk IslandNFK>>==NORTHERN MARIANA ISLANDSMPNorthern Mariana IslandsMNPDNORWAYNONorwayNORBOMANOMOmanOMNPAKISTANPKPakistanPAKJPALAUPWPalauPLWIPANAMAPAPanamaPANO.--PAPUA NEW GUINEAPGPapua New GuineaPNGVPARAGUAYPYParaguayPRYXPERUPEPeruPER\$ ##PHILIPPINESPHPhilippinesPHL`!PITCAIRNPNPitcairnPCNd"POLANDPLPolandPOLh#PORTUGALPTPortugalPRTl$$##PUERTO RICOPRPuerto RicoPRIv%QATARQAQatarQATz&REUNIONREReunionREU~'ROMANIARORomaniaROM2(11RUSSIAN FEDERATIONRURussian FederationRUS)RWANDARWRwandaRWA&*%%SAINT HELENASHSaint HelenaSHN$,##SAINT LUCIALCSaint LuciaLCA V)bZIMBABWEZWZimbabweZWEaZAMBIAZMZambiaZMB~`YEMENYEYemenYEMw*_))WESTERN SAHARAEHWestern SaharaESH0^//WALLIS AND FUTUNAWFWallis and FutunaWLFl6]55VIRGIN ISLANDS, U.S.VIVirgin Islands, U.S.VIRR;\;;VIRGIN ISLANDS, BRITISHVGVirgin Islands, BritishVGB\  0Ux:[7^ $##NEW ZEALANDNZNew ZealandNZL*"!!MAURITANIAMRMauritaniaMRT MAURITIUSMUMauritiusMUSMEXICOMXMexicoMEXLKKMICRONESIA, FEDERATED STATES OFFMMicronesia, Federated States ofFSMG655MOLDOVA, REPUBLIC OFMDMoldova, Republic ofMDAMONACOMCMonacoMCOMONGOLIAMNMongoliaMNG"!!MONTSERRATMSMontserratMSRMOROCCOMAMoroccoMAR" !!MOZAMBIQUEMZMozambiqueMOZ MYANMARMMMyanmarMMRh NAMIBIANANamibiaNAM NAURUNRNauruNRU NEPALNPNepalNPL $##NETHERLANDSNLNetherlandsNLD655NETHERLANDS ANTILLESANNetherlands AntillesANT(''NEW CALEDONIANCNew CaledoniaNCL NICARAGUANINicaraguaNIC.NIGERNENigerNER2 #EWn$9R g-'West VirginiaWV¯sAlaskaAK#ConnecticutCTc'MassachusettsMA!New MexicoNMsKentuckyKYF5District of ColumbiaDC 6UtahUTPLouisianaLA͠HVirginiaVA}%North DakotaNDԓYWyomingWY;WisconsinWIԸb)North CarolinaNCΝwNevadaNV߬HawaiiHI–IOklahomaOK'FloridaFLԻ]!CaliforniaCAģVOregonOR׫w!WashingtonWA:'New HampshireNH|ArkansasARh%PennsylvaniaPAF%Rhode IslandRI凭eMarylandMD *=Qk)<Si~')South CarolinaSC@New YorkNY/ColoradoCOGeorgiaGA 6OhioOHCTexasTXx#MississippiMSg%South DakotaSDSIllinoisILӏRMissouriMOkNebraskaNE؊ DelawareDEڪ`TennesseeTN抭!New JerseyNJIndianaIN iIowaIAPMichiganMIĒ"ArizonaAZγ=KansasKSԺLIdahoIDVermontVTܷMontanaMTMinnesotaMNEMaineMEQAlabamaAL hE!lDAA Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000D{AA`Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DAA4Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DմdAAuCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000E݀%AACountry2009-06-04 17:22:41.0000002009-06-04 17:22:41.000000D2AADCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EqAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000Dʎ<AACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DǟCAAZCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000 bA!lDɥ8AA>Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000E/AACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000D#AA5Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000D\AAtCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EfAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DMAAnCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000Eכ>AACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000E%AACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000D1AACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DTAAJCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000 B"lD AA3Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DyAA}Country2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000EŰAACountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000DpAAbCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000Dٌ'AACCountry2009-06-04 13:22:26.0000002009-06-04 13:22:26.000000D在4AA#Country2009-06-04 17:22:41.0000002009-06-04 17:22:41.000000