SQLite format 3@ t-gV(Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)U tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "resource_id" integer, "resource_type" varchar(255), "created_at" datetime, "updated_at" datetime)? ]tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "created_at" datetime, "updated_at" datetime, "first_name" varchar(255), "last_name" varchar(255), "country_id" integer) O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") W3Aindexindex_globalize_languages_on_rfc_3066globalize_languages CREATE INDEX "index_globalize_languages_on_rfc_3066" ON "globalize_languages" ("rfc_3066")" Y3Eindexindex_globalize_languages_on_iso_639_3globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_3" ON "globalize_languages" ("iso_639_3")" Y3Eindexindex_globalize_languages_on_iso_639_2globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_2" ON "globalize_languages" ("iso_639_2")"Y3Eindexindex_globalize_languages_on_iso_639_1globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_1" ON "globalize_languages" ("iso_639_1")33Ytableglobalize_languagesglobalize_languagesCREATE TABLE "globalize_languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_639_1" varchar(2), "iso_639_2" varchar(3), "iso_639_3" varchar(3), "rfc_3066" varchar(255), "english_name" varchar(255), "english_name_locale" varchar(255), "english_name_modifier" varchar(255), "native_name" varchar(255), "native_name_locale" varchar(255), "native_name_modifier" varchar(255), "macro_language" boolean, "direction" varchar(255), "pluralization" varchar(255), "scope" varchar(1))S39indexindex_globalize_countries_on_localeglobalize_countriesCREATE INDEX "index_globalize_countries_on_locale" ON "globalize_countries" ("locale")O31indexindex_globalize_countries_on_codeglobalize_countriesCREATE INDEX "index_globalize_countries_on_code" ON "globalize_countries" ("code")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)@33'tableglobalize_countriesglobalize_countriesCREATE TABLE "globalize_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(2), "english_name" varchar(255), "date_format" varchar(255), "currency_format" varchar(255), "currency_code" varchar(3), "thousands_sep" varchar(2), "decimal_sep" varchar(2), "currency_decimal_sep" varchar(2), "number_grouping_scheme" varchar(255), "continent" varchar(255), "locale" varchar(255))=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("vT~D`5M)=+ 2 |p^L:(tbP>, x f T B 0  |2)201410041547251)201406011516310)20140523134543/)20140428122156.)20140423113417-)20140328205246,)20140303121217+)20140217135228*)20131128201053))20130605184116()20130531212537')20130507123255&)20130206213720%)20121103181909$)20141114170962#)20141114170961")20141114170960!)20141114170959 )20141114170958)20141114170957)20141114170956)20141114170955)20141114170954)20141114170953)20141114170952)20141114170951)20141114170950)20141114170949)20141114170948)20141114170947)20141114170946)20141114170945)20141114170944)20141114170943)20141114170942)20141114170941)20141114170940 )20141114170939 )20141114170938 )20141114170937 )20141114170936 )20141114170935)20141114170934)20141114170933)20141114170932)20141114170931)20141114170930)20141114170929)20141114170928)20141114170927 2 K B /  q ^ K|iVC0 r_L9& { h U)201410041547252)201406011516311)201405231345430)20140428122156/)20140423113417.)20140328205246-)20140303121217,)20140217135228+)20131128201053*)20130605184116))20130531212537()20130507123255')20130206213720&)20121103181909%)20141114170962$)20141114170961#)20141114170960")20141114170959!)20141114170958 )20141114170957)20141114170956)20141114170955)20141114170954)20141114170953)20141114170952)20141114170951)20141114170950)20141114170949)20141114170948)20141114170947)20141114170946)20141114170945)20141114170944)20141114170943)20141114170942)20141114170941)20141114170940)20141114170939 )20141114170938 )20141114170937 )20141114170936 )20141114170935 )20141114170934)20141114170933)20141114170932)20141114170931)20141114170930)20141114170929)20141114170928) 20141114170927q Y+ ] 0  p ?  n ?  y T # n > d6R^9wG X)wQf+xN%S GNGuineaGNSwesternAfrica%R GMGambiaGMDwesternAfrica2Q 'GLGreenlandDKK.,,westernNorth America(P GIGibraltarGIPwesternEurope$O GHGhanaGHCwesternAfrica3N ''GFFrench GuianaEURwesternSouth America'M GEGeorgiaGEL.,,westernAsia-L 'GDGrenadaXCDwesternNorth America9K )GBUnited Kingdom£%nGBP,..westernEuropeen-UK$J GAGabonXAFwesternAfrica-I FRFrance%n €EUR,,westernEurope0H )FOFaeroe IslandsDKK.,,westernEurope*G !FMMicronesiaUSDwesternOceania6F -'FKFalkland IslandsFKPwesternSouth America$E FJFijiFJDwesternOceania*D FIFinlandEUR ,,westernEurope*C ETEthiopiaETB,..westernAfrica-B ESSpain%n €EUR.,,westernEurope)A EREritreaERN,..westernAfrica-@ )EHWestern SaharaMADwesternAfrica'? EGEgyptEGP,..westernAfrica*> EEEstoniaEEK ,,westernEurope0= 'ECEcuadorUSD.,,westernSouth America)< DZAlgeriaDZD,..westernAfrica;; 1'DODominican RepublicDOP,..westernNorth America.: 'DMDominicaXCDwesternNorth America)9 DKDenmarkDKK.,,westernEurope'8 DJDjiboutiDJFwesternAfrica17 DEGermany%n €EUR.,,westernEuropede96 )CZCzech Republic%n KčCZK ,,westernEuropecs#5 CYCyprusCYPwesternAsia04 -CXChristmas IslandAUDwesternOceania)3 !CVCape VerdeCVEwesternAfrica*2 'CUCubaCUPwesternNorth America41 7CSSerbia and MontenegroCSDwesternEurope30 !'CRCosta RicaCRC,..westernNorth America1/ 'COColombiaCOP.,,westernSouth America(. CNChinaY%nCNY,..westernAsia'- CMCameroonXAFwesternAfrica., 'CLChileCLF.,,westernSouth America,+ %CKCook IslandsNZDwesternOceania,* 'CICote D'IvoireXAFwesternAfrica9) #CHSwitzerlandSFr. %nCHF',.westernEuropefr-CH-( )CGCongo RepublicXAFwesternAfrica7' =CFCentral African RepublicXAFwesternAfrica5& ?CDCongo Democratic RepublicwesternAfrica.% )CCCocos IslandsAUDwesternOceania/$ 'CACanadaCAD,..westernNorth America,# 'BZBelizeBZDwesternNorth America(" BYBelarusBYR..westernEurope*! BWBotswanaBWP,..westernAfrica/ 'BVBouvet IslandNOKwesternAntartica# BTBhutanBTNwesternAsia- 'BSBahamasBSDwesternNorth America3 'BRBrazilR$%nBRR.,,westernSouth America0 'BOBoliviaBOB.,,westernSouth America. /BNBrunei DarussalamBNDwesternAsia- 'BMBermudaBMDwesternNorth America$ BJBeninXAFwesternAfrica& BIBurundiBIFwesternAfrica' BHBahrainBHD,..westernAsia+ BGBulgariaBGL ,,westernEurope+ %BFBurkina FasoXAFwesternAfrica/ BEBelgium%n €EUR.,,westernEurope* !BDBangladeshBDT,..westernAsia. 'BBBarbadosBBDwesternNorth America7 9BABosnia and HerzegovinaBAM,,westernEurope) !AZAzerbaijanAZM..westernAsia+ 'AWArubaAWGwesternNorth America3 AUAustralia%n AUS$AUD,..westernOceania3 ATAustria€ %nEUR,,westernEuropede-AT. )ASAmerican SamoaUSDwesternOceania2 'ARArgentinaARA.,,westernSouth America, !AQAntarcticaNOKwesternAntartica% AOAngolaAONwesternAfrica: 5'ANNetherlands AntillesANGwesternNorth America$ AMArmeniaAMDwesternAsia) ALAlbaniaALL.,,westernEurope. 'AIAnguillaXCDwesternNorth America9 3'AGAntigua and BarbudaXCDwesternNorth America( #AFAfghanistanAFAwesternAsia4 5AEUnited Arab EmiratesAED,..westernAsia& ADAndorraEURwep(oS ||1 user_site_profiles' user_profiles roles' core_accounts users3globalize_languages3globalize_countries |ung`YRKD=6/(! yrkd]VOHA:3,%  } v o h a Z S L E > 7 0 ) "    x p h ` X P H @ 8 0 (    x p h ` X P H @ 8 0 (    x p h ` X P H @ 8 0 (    x p h ` X P H @ 8 0 (   ZWZMZAYTYEWSWFVUVNVIVGVEVCVAUZUYUSUMUGUATZTWTVTTTRTOTNTMTLTKTJTHTGTFTDTCSZSYSVSTSRSOSNSMSLSKSJSISHSGSESDSCSBSARWRUROREQAPYPWPTPSPRPNPMPLPKPHPGPFPEPAOMNZNUNRNPNONLNINGNFNENCNAMZMYMXMWMVMUMTMSMRMQMPMOMNMMMLMKMHMGMDMCMALYLVLULTLSLR~LK}LI|LC{LBzLAyKZxKYwKWvKRuKPtKNsKMrKIqKHpKGoKEnJPmJOlJMkITjISiIRhIQgIOfINeILdIEcIDbHUaHT`HR_HN^HM]HK\GY[GWZGUYGTXGSWGRVGQUGPTGNSGMRGLQGIPGHOGFNGEMGDLGBKGAJFRIFOHFMGFKFFJEFIDETCESBERAEH@EG?EE>EC=DZ<DO;DM:DK9DJ8DE7CZ6CY5CX4CV3CU2CS1CR0CO/CN.CM-CL,CK+CI*CH)CG(CF'CD&CC%CA$BZ#BY"BW!BV BTBSBRBOBNBMBJBIBHBGBFBEBDBBBAAZAWAUAT AS AR AQ AO ANAMALAIAGAFAE AD zupkfa\WRMHC>94%  rmhc^YTOJE@;61,'"  { v q l f ` Z T N H B < 6 0 * $     | v p j d ^ X R L F @ : 4 . ( "     z t n h b \ V P J D > 8 2 $      * w* en~}|{zyxwvutsrqponjamlkjihgf en-INedcba`_^]\[ZYXWVUTSRQPONML en-UKKJIHGFEDCBA@?>=<;:98de7cs6543210/.-,+* fr-CH)('&%$#"!  de-AT      tkD R +  U ' Y -  g . T W0b;zL(xM }Z1L%X-%QkskaskasKashmirifltrL3M+knkankanKannadaಕನ್ನಡfltrL(K#klkalkalKalaallisutfltrL3#jajpnjpnJapanese日本語fltrc = 1L%\jvjavjavJavanesefltrL:()ititaitaItalianitalianofltrc == 1 ? 1 : 2L/!isislislIcelandicÍslenskafltrL$ikipkipkInupiaqtltrL7~!-idindindIndonesianBahasa indonesiafltrLT|#eiainainaInterlinguaInternational Auxiliary Language AssociationfltrC(k#ieileileInterlinguefltrC&diuikuikuInuktituttltrL&WiiiiiiiiYiSichuanfltrL >ioidoidoIdofltrC!0igiboiboIgbofltrL3")hyhyehyeArmenianՀայերենfltrL1 huhunhunHungarianMagyarfltrc = 1L~r-hrhrvhrvCroatianHrvatskifltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L&BhohmohmoHiri MotufltrL1'+hihinhinHindiहिंदीfltrL#hzherherHererofltrL;!)hehebhebHebrewעבריתfrtlc == 1 ? 1 : 2L( )shhbsSerbo-CroatiantltrL'hahauhauHausaHausafltrL4;hthathatHaitian; Haitian CreolefltrL%2gugujgujGujaratifltrL$gngrngrnGuaranitltrL!MgvglvglvManxfltrE+DglglgglgGalleganGalegofltrL@C;gaglegleIrishGaeilgefltrc==1 ? 1 : c==2 ? 2 : 3L?@;gdglaglaGaelicScotsfltrc==1 ? 1 : c==2 ? 2 : 3L9";fffulfulFulahFulfulde, Pulaar, PulartltrL$fyfryfryFrisiantltrL: )frfrafraFrenchFrançaisfltrc == 1 ? 1 : 2L7o)fifinfinFinnishsuomifltrc == 1 ? 1 : 2L#mfjfijfijFijianfltrL.a!fafasfasPersianفارسیtltrL$^fofaofaoFaroesefltrL&MeeeweeweEweƐʋɛfltrL*IeueuseusBasqueeuskerafltrL8;)etestestEstonianEestifltrc == 1 ? 1 : 2L4')eoepoepoEsperantofltrc == 1 ? 1 : 2C2)enengengEnglishfltrc == 1 ? 1 : 2LN)-)elellellGreekModern (1453-)Ελληνικάfltrc == 1 ? 1 : 2L%`dzdzodzoDzongkhafltrL#GdvdivdivDivehifltrL8)dedeudeuGermanDeutschfltrc == 1 ? 1 : 2L6[)dadandanDanishDanskfltrc == 1 ? 1 : 2L)IcycymcymWelshCymraegfltrL!ucrcrecreCreetltrL%]cocoscosCorsicanfltrL$\kwcorcorCornishfltrL$ncvchvchvChuvashfltrL)mcuchuchuSlavicChurchfltrA$^cechecheChechenfltrL%ZchchachaChamorrofltrL|Q-cscescesCzechčeštinafltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L+cacatcatCatalanCatalàfltrL8|1bgbulbulBulgarianБългарскиfltrL#(brbrebreBretonfltrL$kbsbosbosBosnianfltrL$\bobodbodTibetanfltrL$QbibisbisBislamafltrL$hbnbenbenBengalifltrL;f!5bebelbelBelarusianБеларускаяfltrL.!bmbambamBambaraBamanankanfltrL$babakbakBashkirfltrL3p##azazeazeAzerbaijaniazərbaycantltrL#cayaymaymAymaratltrL$9aeaveaveAvestanfltrA#6avavaavaAvaricfltrL%xasasmasmAssamesefltrL&ZanargargAragonesefltrL1T)araraaraArabicالعربيةtrtlL0w%amamhamhAmharicአማርኛfltrL!?akakaakaAkantltrL/rafafrafrAfrikaansAfrikaansfltrL=!;ababkabkAbkhazianаҧсуа бызшәаfltrL!aaaarsQrQ 7 = 7[{sckS;CK3+  [s{k[ScC3#K + C c 3 s k ; { + K# S   #  C k [ c S K ; s { 3 + #    [ K s ; { k S C ; c 3 # +    { s k c [ S K Czuzh<za9yixhwo(wavovi_veXuz?urukugtwtrwtkqtsCtnBtotitthOtlCtgBte&tttatysvswsurssLsr-sc!sqesstsosdsnsmseslsksijsasgrurnrormqupsptpl|pi8paosxomgoreojocnynoenbWnnJnlnengyndonrGnv7na6mymsXmiFmnmomtmgmkmrmlmhlgnluilbglt ln li lv kla ilo dku kj ko 2kg .kv -ky rw ki km {kk kr ka ks kn kl ja jv \it (is !ik id ia ie iu ii io ig hy hu hr rho Bhi 'hz he sh ha ht gugngvMglDgaCgd@fffyfrfiofjmfaafo^eeMeuIet;eo'eneldzdvGdedacycruco]kw\cvcucechcscabgbrbskbo\bibnhbefbmbaazayaeavasxanZarTamakafrab!aa  |sjaXOF=4+"wne\SJA8/& ~ u l c Z Q H ? 6 - $   y p g ^ U L C : 1 (    } t k b Y P G > 5 , #    x o f ] T K B 9 0 '    zulzho<zha9yidxhowol(wlnvolvie_venXuzb?urdukruigtwiturwtukqtsoCtsnBtontirtthaOtglCtgkBtel&tattamtahsweswasunrsswLsrp-srd!sqispasotsomsndsnasmosmeslvslksinjsansagrusrunronrohquepusporpol|pli8panossxormgorieojiocinyanorenobWnnoJnldnepndoyndeonblGnav7nau6myamsaXmriFmonmolmltmlgmkdmarmalmahlugnlubiltzglit lin lim lav klat ilao dkur kua kor 2kon .kom -kir kin kik khm {kaz kau kat kas kan kal jpn jav \ita (isl !ipk ind ina ile iku iii ido ibo hye hun hrv rhmo Bhin 'her heb  hau hat gujgrnglvMglgDgleCgla@fulfryfrafinofijmfasafao^eweMeusIest;epo'engelldzodivGdeudancymcreucos]cor\chvchuchechacescatbulbreboskbod\bisbenhbelfbambakazeaymaveavaasmxargZaraTamhakaafrrabk!aar  |sjaXOF=4+"wne\SJA8/&  { r i ` W N E < 3 * !     v m d [ R I @ 7 . %    z q h _ V M D ; 2 )    ~ u l c Z Q H ? 6 - $   zulzho<zha9yidxhowol(wlnvolvie_venXuzb?urdukruigtwiturwtukqtsoCtsnBtontirtthaOtglCtgkBtel&tattamtahsweswasunrsswLsrp-srd!sqispasotsomsndsnasmosmeslvslksinjsansagrusrunronrohquepusporpol|pli8panossxormgorieojiocinyanorenobWnnoJnldnepndoyndeonblGnav7nau6myamsaXmriFmonmolmltmlgmkdmarmalmahlugnlubiltzglit lin lim lav klat ilao dkur kua kor 2kon .kom -kir kin kik khm {kaz kau kat kas kan kal jpn jav \ita (isl !ipk ind ina ile iku iii ido ibo hye hun hrv rhmo Bhin 'her heb hbs hau hat gujgrnglvMglgDgleCgla@fulfryfrafinofijmfasafao^eweMeusIest;epo'engelldzodivGdeudancymcreucos]cor\chvchuchechacescatbulbreboskbod\bisbenhbelfbambakazeaymaveavaasmxargZaraTamhakaafrrabk!aar ysmga[UOIC=71+% }wqke_YSMGA;5/)#  { u o i c ] W Q K E ? 9 3 - ' !      y s m g a [ U O I C = 7 1 + %      zh-Hans zh-Hant<9(_X?wqCBtOCB&rL-!j|8xgeeWJyoG76XFnig    k i d   2 . -    {        \ ( !           r B '     MDC@oma^MI;'Gu]\k\hfxZTr! NN//AAA admin@widgets.inc$2a$10$MZ4FnIyot5hD/Q6FMy0mWuIRg0c/9YqoAoQeFFj7RmemsnxTvU25W2014-12-01 09:47:56.3278622014-12-01 09:47:56.3379392014-12-01 09:47:56.337939 / admin@widgets.inc   5w5@AA beta2014-12-01 09:47:21.0649612014-12-01 09:47:21.064961AAA admin2014-12-01 09:47:21.0637252014-12-01 09:47:21.063725DAAsysadmin2014-12-01 09:46:04.3190292014-12-01 09:46:04.319029    beta admin  sysadmin  beta admin  sysadmin /**'<n / y  o ddq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=/q//tableschema_miq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")@33'tableglobalize_countriesglobalize_countriesq//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")@33'tableglobalize_countriesglobalize_countriesCREATE TABLE "globalize_countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(2), "english_name" varchar(255), "date_format" varchar(255), "currency_format" varchar(255), "currency_code" varchar(3), "thousands_sep" varchar(2), "decimal_sep" varchar(2), "currency_decimal_sep" varchar(2), "number_grouping_scheme" varchar(255), "continent" varchar(255), "locale" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)O31indexindex_globalize_countries_on_codeglobalize_countriesCREATE INDEX "index_globalize_countries_on_code" ON "globalize_countries" ("code")S39indexindex_globalize_countries_on_localeglobalize_countriesCREATE INDEX "index_globalize_countries_on_locale" ON "globalize_countries" ("locale")33Ytableglobalize_languagesglobalize_languagesCREATE TABLE "globalize_languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_639_1" varchar(2), "iso_639_2" varchar(3), "iso_639_3" varchar(3), "rfc_3066" varchar(255), "english_name" varchar(255), "english_name_locale" varchar(255), "english_name_modifier" varchar(255), "native_name" varchar(255), "native_name_locale" varchar(255), "native_name_modifier" varchar(255), "macro_language" boolean, "direction" varchar(255), "pluralization" varchar(255), "scope" varchar(1))"Y3Eindexindex_globalize_languages_on_iso_639_1globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_1" ON "globalize_languages" ("iso_639_1")" Y3Eindexindex_globalize_languages_on_iso_639_2globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_2" ON "globalize_languages" ("iso_639_2")" Y3Eindexindex_globalize_languages_on_iso_639_3globalize_languages CREATE INDEX "index_globalize_languages_on_iso_639_3" ON "globalize_languages" ("iso_639_3") W3Aindexindex_globalize_languages_on_rfc_3066globalize_languages CREATE INDEX "index_globalize_languages_on_rfc_3066" ON "globalize_languages" ("rfc_3066")k5tablerolesrolesCREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "resource_id" integer, "resource_type" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)Z3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")7tableversionsversionsCREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime, "object_changes" text, "locale" varchar(255))[Gindexindex_versions_on_item_type_and_item_idversionsCREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")     ;;Ry * h  -^.'AAgtablecore_category_translationscore_category_translations&CREATE TABLE "co?w}indexindex_roles_on_name_and_resource_type_and_resource_idrolesCREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")P''Ytablecore_accountscore_accountsCREATE TAm?indexindex_roles_on_account_idrolesCREATE INDEX "index_roles_on_account_id" ON "roles" ("account_id")A##ItablepreferencespreferencesCREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "owner_id" integer NOT NULL, "owner_type" varchar(255) NOT NULL, "group_id" integer, "group_type" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)`q#9indexindex_preferences_on_owner_and_name_and_preferencepreferencesCREATE UNIQUE INDEX "index_preferences_on_owner_and_name_and_preference" ON "preferences" ("owner_id", "owner_type", "name", "group_id", "group_type")~ ++3tablecore_activitiescore_activities#CREATE TABLE "core_activities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "user_id" integer, "browser" varchar(255), "session_id" varchar(255), "ip_address" varchar(255), "controller" varchar(255), "action" varchar(255), "params" varchar(255), "slug" varchar(255), "lesson" varchar(255), "created_at" datetime)!S+9indexindex_core_activities_on_account_idcore_activities$CREATE INDEX "index_core_activities_on_account_id" ON "core_activities" ("account_id") "M+-indexindex_core_activities_on_user_idcore_activities%CREATE INDEX "index_core_activities_on_user_id" ON "core_activities" ("user_id").#''tablecore_commentscore_commentsCREATE TABLE "core_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(50) DEFAULT '', "body" text, "commentable_id" integer, "commentable_type" varchar(255), "user_id" integer, "role" varchar(255) DEFAULT 'comments', "account_id" integer, "created_at" datetime, "updated_at" datetime, "type" varchar(255), "ancestry" varchar(255), "ancestry_depth" integer DEFAULT 0)$['Iindexindex_core_comments_on_commentable_typecore_comments CREATE INDEX "index_core_comments_on_commentable_type" ON "core_comments" ("commentable_type")%W'Aindexindex_core_comments_on_commentable_idcore_comments!CREATE INDEX "index_core_comments_on_commentable_id" ON "core_comments" ("commentable_id")&I'%indexindex_core_comments_on_user_idcore_comments"CREATE INDEX "index_core_comments_on_user_id" ON "core_comments" ("user_id").'AAgtablecore_category_translationscore_category_translations&CREATE TABLE "core_category_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_category_id" integer, "locale" varchar(255), "name" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)(AAIindexindex_category_translationcore_category_translations'CREATE INDEX "index_category_translation" ON "core_category_translations" ("core_category_id")i)++ tablecore_categoriescore_categories(CREATE TABLE "core_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "row_order" integer, "account_id" integer, "created_on" datetime, "updated_on" datetime)2*II_tablecore_system_email_translationscore_system_email_translations*CREATE TABLE "core_system_email_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_system_email_id" integer, "locale" varchar(255), "subject" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime)+11_tablecore_system_emailscore_system_emails+CREATE TABLE "core_system_emails" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email_type" varchar(255), "emailable_id" integer, "emailable_type" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)   j #/AAWidgets Incadmin@widgets.inclocalhostlocal2014-12-01 09:47:21.0537412014-12-01 09:47:21.053741           !        -)'4 _YVb -stableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, " -stableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "confirmation_token" varchar(255), "confirmed_at" datetime, "confirmation_sent_at" datetime, "unconfirmed_email" varchar(255), "created_at" datetime, "updated_at" datetime, "account_id" integer)e.5 indexindex_users_on_emailusersCREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")/SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token") 0O?indexindex_users_on_confirmation_tokenusersCREATE UNIQUE INDEX "index_users_on_confirmation_token" ON "users" ("confirmation_token")m1?indexindex_users_on_account_idusersCREATE INDEX "index_users_on_account_id" ON "users" ("account_id") 811?tableuser_site_profilesuser_site_profiles3CREATE TABLE "user_site_profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_access_at" datetime, "created_at" datetime, "updated_at" datetime, "account_id" integer, "uuid" varchar(40))(9''tableuser_profilesuser_profiles,CREATE TABLE "user_profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "public_name" varchar(50) DEFAULT '', "first_name" varchar(50) DEFAULT '', "last_name" varchar(50) DEFAULT '', "address" varchar(70) DEFAULT '', "address2" varchar(70) DEFAULT '', "city" varchar(30) DEFAULT '', "state" varchar(30) DEFAULT '', "zipcode" varchar(10) DEFAULT '', "country_id" integer DEFAULT 0, "phone" varchar(20) DEFAULT '', "cell" varchar(20) DEFAULT '', "fax" varchar(20) DEFAULT '', "workphone" varchar(20) DEFAULT '', "website" varchar(50) DEFAULT '', "gender" varchar(1) DEFAULT '', "status" integer DEFAULT 0, "lock_version" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "account_id" integer, "email" varchar(255), "public_avatar" varchar(255), "public_avatar_file_size" integer, "public_avatar_content_type" varchar(255), "private_avatar" varchar(255), "private_avatar_file_size" integer, "private_avatar_content_type" varchar(255), "use_private_avatar_for_public" boolean DEFAULT 'f'),:99stablecore_payment_historiescore_payment_histories-CREATE TABLE "core_payment_histories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(30), "anchor_id" varchar(20), "order_ref" varchar(255), "item_ref" varchar(255), "item_name" varchar(255), "quantity" integer, "cost" varchar(255), "discount" varchar(255), "total_cents" integer, "total_currency" varchar(3), "payment_method" varchar(255), "payment_date" datetime, "bill_to_name" varchar(255), "item_details" text, "order_details" text, "status" varchar(255), "user_profile_id" integer, "created_on" datetime, "account_id" integer, "notify_data" text, "transaction_id" varchar(255))$;U9Gindexindex_payment_histories_on_anchor_idcore_payment_histories.CREATE INDEX "index_payment_histories_on_anchor_id" ON "core_payment_histories" ("anchor_id")!<S9Cindexindex_payment_histories_on_item_refcore_payment_histories/CREATE INDEX "index_payment_histories_on_item_ref" ON "core_payment_histories" ("item_ref")$=U9Gindexindex_payment_histories_on_order_refcore_payment_histories0CREATE INDEX "index_payment_histories_on_order_ref" ON "core_payment_histories" ("order_ref")   u   AA /adminRalfWidget2014-12-01 09:47:56.3394552014-12-01 09:47:56.379218admin@widgets.incf      10/.- ` AA U2014-12-01 09:47:56.3991512014-12-01 09:47:56.400955ab9999ba-85b4-4b5d-8fe5-4f7bbcccf361    WPe 3 ZZtmN= indexindex_taggings_on_tag_idtaggings@CREATE INDEX "index_taggings_on_tag_id"4@Gtablevotesvotes4CREATE TABLE "votes" ("id" INTE!>S9Cindexindex_payment_histories_on_owner_idcore_payment_histories1CREATE INDEX "index_payment_histories_on_owner_id" ON "core_payment_histories" ("owner_id")'?W9Kindexindex_payment_histories_on_owner_typecore_payment_histories2CREATE INDEX "index_pay!>S9Cindexindex_payment_histories_on_owner_idcore_payment_histories1CREATE INDEX "index_payment_histories_on_owner_id" ON "core_payment_histories" ("owner_id")'?W9Kindexindex_payment_histories_on_owner_typecore_payment_histories2CREATE INDEX "index_payment_histories_on_owner_type" ON "core_payment_histories" ("owner_type")4@Gtablevotesvotes4CREATE TABLE "votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "votable_id" integer, "votable_type" varchar(255), "voter_id" integer, "voter_type" varchar(255), "vote_flag" boolean, "vote_scope" varchar(255), "vote_weight" integer, "created_at" datetime, "updated_at" datetime)?Aw}indexindex_votes_on_voter_id_and_voter_type_and_vote_scopevotes6CREATE INDEX "index_votes_on_voter_id_and_voter_type_and_vote_scope" ON "votes" ("voter_id", "voter_type", "vote_scope")KB indexindex_votes_on_votable_id_and_votable_type_and_vote_scopevotes7CREATE INDEX "index_votes_on_votable_id_and_votable_type_and_vote_scope" ON "votes" ("votable_id", "votable_type", "vote_scope")CM1-indexindex_user_site_profiles_on_uuiduser_site_profiles8CREATE INDEX "index_user_site_profiles_on_uuid" ON "user_site_profiles" ("uuid")KDmtablefollowsfollows9CREATE TABLE "follows" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "followable_id" integer NOT NULL, "followable_type" varchar(255) NOT NULL, "follower_id" integer NOT NULL, "follower_type" varchar(255) NOT NULL, "blocked" boolean DEFAULT 'f' NOT NULL, "created_at" datetime, "updated_at" datetime)eE!indexfk_followsfollows:CREATE INDEX "fk_follows" ON "follows" ("follower_id", "follower_type")qF)+indexfk_followablesfollows;CREATE INDEX "fk_followables" ON "follows" ("followable_id", "followable_type")XG''otablecore_accountscore_accountsCREATE TABLE "core_accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "company_name" varchar(255), "contact_email" varchar(255), "domain" varchar(255), "account_prefix" varchar(255), "default_site_id" integer, "created_at" datetime, "updated_at" datetime, "next_invoice_num" integer DEFAULT 1000)gH)) tablecore_addressescore_addressesCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "taggings_count" integer DEFAULT 0) Mmtabletaggingstaggings?CREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "tagger_id" integer, "tagger_type" varchar(255), "context" varchar(128), "created_at" datetime)   'U ab9999ba-85b4-4b5d-8fe5-4f7bbcccf361        A      ] 5 V,4['''tableknw_documentsknw_documentsLCREATE TA)`77qtablecms_page_translationscms_page_translationsQCREATE TABLE "cms_page_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_page_id" integer, "locale" varchar(255), "title" varchar(255), "menutitle" varchar(255), "created_at" datetime, "updated_at" datetime,^P1indexindex_tags_on_nametagsBCREATE UNIQUE INDEX "index_tags_on_name" ON "tags" ("name")#Q%indextaggings_idxtaggingsACREATE UNIQUE INDEX "taggings_idx" ON "taggings" ("tag_id", "taggable_id", "taggable_type", "context", "tagger_id", "tagger_type")R99#tablecore_custom_field_defscore_custom_field_defs@CREATE TABLE "core_custom_field_defs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(255), "name" varchar(255), "field_type" varchar(255), "row_order" integer, "required" boolean DEFAULT 'f', "properties" varchar(2048), "created_at" datetime, "updated_at" datetime, "account_id" integer)1Sa9Uindexindex_core_custom_field_defs_on_account_idcore_custom_field_defsCCREATE INDEX "index_core_custom_field_defs_on_account_id" ON "core_custom_field_defs" ("account_id")WT{9indexindex_core_custom_field_defs_on_owner_id_and_owner_typecore_custom_field_defsECREATE INDEX "index_core_custom_field_defs_on_owner_id_and_owner_type" ON "core_custom_field_defs" ("owner_id", "owner_type")GUQQytablecore_custom_field_def_translationscore_custom_field_def_translationsFCREATE TABLE "core_custom_field_def_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "core_custom_field_def_id" integer, "locale" varchar(255), "label" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime)SV]Qindexcore_custom_field_def_translations_indexcore_custom_field_def_translationsGCREATE INDEX "core_custom_field_def_translations_index" ON "core_custom_field_def_translations" ("core_custom_field_def_id")2W11tablecore_custom_fieldscore_custom_fieldsHCREATE TABLE "core_custom_fields" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "owner_id" integer, "owner_type" varchar(255), "custom_field_def_id" integer, "field_data" varchar(4096), "created_at" datetime, "updated_at" datetime, "account_id" integer)!XY1Eindexindex_core_custom_fields_on_account_idcore_custom_fieldsICREATE INDEX "index_core_custom_fields_on_account_id" ON "core_custom_fields" ("account_id")GYs1windexindex_core_custom_fields_on_owner_id_and_owner_typecore_custom_fieldsJCREATE INDEX "index_core_custom_fields_on_owner_id_and_owner_type" ON "core_custom_fields" ("owner_id", "owner_type")UZindexindex_taggings_on_taggable_id_and_taggable_type_and_contexttaggingsKCREATE INDEX "index_taggings_on_taggable_id_and_taggable_type_and_context" ON "taggings" ("taggable_id", "taggable_type", "context")4['''tableknw_documentsknw_documentsLCREATE TABLE "knw_documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "subtitle" varchar(255), "content" text, "summary" text, "original_date" datetime, "published" boolean, "is_public" boolean, "requires_login" boolean, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "slug" varchar(255), "notes" text)\EE-tablecms_contentitem_translationscms_contentitem_translationsMCREATE TABLE "cms_contentitem_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_contentitem_id" integer, "locale" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)M]iEyindexindex_072c3a76f87c96e2f91149eccd2a283dca2b613fcms_contentitem_translationsNCREATE INDEX "index_072c3a76f87c96e2f91149eccd2a283dca2b613f" ON "cms_contentitem_translations" ("cms_contentitem_id"))`77qtablecms_page_translationscms_page_translationsQCREATE TABLE "cms_page_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_page_id" integer, "locale" varchar(255), "title" varchar(255), "menutitle" varchar(255), "created_at" datetime, "updated_at" datetime, "summary" text)                E 88p 9 >dddd4Tq%sindexblogname_keycms_s77]tablecms_post_translationscms_post_translationseCREATE TABLE "cms_post_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENTptablecms_blogscms_blogsbCREATE TABLE "cms_blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "published" boolean DEFAULT 'f', "is_public" boolean DEFAULT 'f', "requires_login" boolean DEFAULT 'f', "row_order" integer, "updated_on" datetime, "created0aa7Uindexindex_cms_page_translations_on_cms_page_idcms_page_translationsRCREATE INDEX "index_cms_page_translations_on_cms_page_id" ON "cms_page_translations" ("cms_page_id")g==tablecms_snippet_translationscms_snippet_translationsYCREATE TABLE "cms_snippet_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_snippet_id" integer, "locale" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)Ehm=mindexindex_cms_snippet_translations_on_cms_snippet_idcms_snippet_translationsZCREATE INDEX "index_cms_snippet_translations_on_cms_snippet_id" ON "cms_snippet_translations" ("cms_snippet_id")n77tablecms_blog_translationscms_blog_translations`CREATE TABLE "cms_blog_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_blog_id" integer, "locale" varchar(255), "title" varchar(255), "created_at" datetime, "updated_at" datetime)0oa7Uindexindex_cms_blog_translations_on_cms_blog_idcms_blog_translationsaCREATE INDEX "index_cms_blog_translations_on_cms_blog_id" ON "cms_blog_translations" ("cms_blog_id")s77]tablecms_post_translationscms_post_translationseCREATE TABLE "cms_post_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_post_id" integer, "locale" varchar(255), "title" varchar(255), "content" text, "summary" text, "created_at" datetime, "updated_at" datetime)0ta7Uindexindex_cms_post_translations_on_cms_post_idcms_post_translationsfCREATE INDEX "index_cms_post_translations_on_cms_post_id" ON "cms_post_translations" ("cms_post_id")fwtablecms_postscms_postshCREATE TABLE "cms_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "cms_blog_id" integer, "image" varchar(255), "published_on" datetime, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "notification_sent_on" datetime, "comments_count" integer DEFAULT 0, "comments_allowed" boolean)V%sindexpostname_keycms_postsiCREATE INDEX "postname_key" ON "cms_posts" ("slug")y?indexcms_posts_published_indexcms_postsjCREATE INDEX "cms_posts_published_index" ON "cms_posts" ("published_on") x%%Ytablecms_snippetscms_snippets[CREATE TABLE "cms_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "itemtype" varchar(30) DEFAULT 'markdown', "slug" varchar(255), "description" varchar(255), "enable_cache" boolean DEFAULT 't' NOT NULL, "published" boolean DEFAULT 't' NOT NULL, "created_on" datetime, "updated_on" datetime, "lock_version" integer DEFAULT 0, "account_id" integer) zM%-indexindex_cms_snippets_on_account_idcms_snippets_CREATE INDEX "index_cms_snippets_on_account_id" ON "cms_snippets" ("account_id")w{A%indexindex_cms_snippets_on_slugcms_snippetskCREATE INDEX "index_cms_snippets_on_slug" ON "cms_snippets" ("slug") |--Gtablecms_contentitemscms_contentitemsOCREATE TABLE "cms_contentitems" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_page_id" integer, "itemtype" varchar(30) DEFAULT 'textile', "container" varchar(30), "row_order" integer DEFAULT 0, "enable_cache" boolean DEFAULT 't' NOT NULL, "created_on" datetime, "updated_on" datetime, "lock_version" integer DEFAULT 0, "account_id" integer)}Q-;indexcms_contentitems_cms_page_id_indexcms_contentitemsPCREATE INDEX "cms_contentitems_cms_page_id_index" ON "cms_contentitems" ("cms_page_id")~U-=indexindex_cms_contentitems_on_account_idcms_contentitems^CREATE INDEX "index_cms_contentitems_on_account_id" ON "cms_contentitems" ("account_id")        ]XWVUS XWVUS  \[     cb   [)   2,[}T%sindexblogname_keycms_blogscCREATE INDEX "blogname_key" ON "cms_blogs" ("slug")"tablecms_blogscms_blogsbCREATE TABLE "cms_blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "pubw?indexcms_posts_published_indexcms_postsjCREATE INDEX "cms_posts_published_index" ON "cms_posts" ("published_on")T%sindexpostname_keycms_postsiCREATE INDEX "postname_key" ON "cms_posts" ("slug") tablecms_postscms_postshCREATE TABLE "cms_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "cms_blog_id" integer, "featured_image" varchar(255), "published_on" datetime, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "notification_sent_on" datetime, "comments_count" integer DEFAULT 0, "comments_allowed" boolean)X++gtablecms_media_filescms_media_files\CREATE TABLE "cms_media_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "media" varchar(255), "media_file_size" integer, "media_content_type" varchar(255), "folder" varchar(255), "generate_retina" boolean, "user_id" integer, "created_at" datetime, "updated_at" datetime, "account_id" integer)#G+aindexindex_media_folder_account_idcms_media_fileslCREATE UNIQUE INDEX "index_media_folder_account_id" ON "cms_media_files" ("media", "folder", "account_id")3CCmtablecms_media_file_translationscms_media_file_translationsmCREATE TABLE "cms_media_file_translations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "cms_media_file_id" integer, "locale" varchar(255), "title" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)ZyCindexindex_cms_media_file_translations_on_cms_media_file_idcms_media_file_translationsnCREATE INDEX "index_cms_media_file_translations_on_cms_media_file_id" ON "cms_media_file_translations" ("cms_media_file_id")N ktablecms_pagescms_pagesSCREATE TABLE "cms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(50) DEFAULT '' NOT NULL, "pagetype" varchar(20) DEFAULT 'content' NOT NULL, "published" boolean DEFAULT 'f' NOT NULL, "template" varchar(50) DEFAULT '' NOT NULL, "link" varchar(255) DEFAULT '' NOT NULL, "menuimage" varchar(255), "requires_login" boolean DEFAULT 'f', "ancestry" varchar(255), "ancestry_depth" integer DEFAULT 0, "updated_on" datetime, "created_on" datetime, "lock_version" integer DEFAULT 0 NOT NULL, "account_id" integer, "requires_subscription" boolean DEFAULT 'f', "is_public" boolean DEFAULT 't', "row_order" integer, "featured_image" varchar(255), "header_image" varchar(255))T %sindexpagename_keycms_pagesUCREATE INDEX "pagename_key" ON "cms_pages" ("slug")w Cindexindex_cms_pages_on_ancestrycms_pagesVCREATE INDEX "index_cms_pages_on_ancestry" ON "cms_pages" ("ancestry") O1indexindex_cms_pages_on_ancestry_depthcms_pagesWCREATE INDEX "index_cms_pages_on_ancestry_depth" ON "cms_pages" ("ancestry_depth")t ?indexcms_pages_published_indexcms_pagesXCREATE INDEX "cms_pages_published_index" ON "cms_pages" ("published")}G!indexindex_cms_pages_on_account_idcms_pages]CREATE INDEX "index_cms_pages_on_account_id" ON "cms_pages" ("account_id")"tablecms_blogscms_blogsbCREATE TABLE "cms_blogs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255), "published" boolean DEFAULT 'f', "is_public" boolean DEFAULT 'f', "requires_login" boolean DEFAULT 'f', "row_order" integer, "updated_on" datetime, "created_on" datetime, "account_id" integer, "lock_version" integer DEFAULT 0 NOT NULL, "comments_allowed" boolean, "header_image" varchar(255), "requires_subscription" boolean DEFAULT 'f', "owner_id" integer, "owner_type" varchar(255), "image_email_header" varchar(255))T%sindexblogname_keycms_blogscCREATE INDEX "blogname_key" ON "cms_blogs" ("slug")t?indexcms_blogs_published_indexcms_blogsdCREATE INDEX "cms_blogs_published_index" ON "cms_blogs" ("published")   ih     Sx= Y+ ] 0  p ?  n ?  y T # n > d6R^9wG X)wQf+xN%S GNGuineaGNSwesternAfrica%R GMGambiaGMDwesternAfrica2Q 'GLGreenlandDKK.,,westernNorth America(P GIGibraltarGIPwesternEurope$O GHGhanaGHCwesternAfrica3N ''GFFrench GuianaEURwesternSouth America'M GEGeorgiaGEL.,,westernAsia-L 'GDGrenadaXCDwesternNorth America9K )GBUnited Kingdom£%nGBP,..westernEuropeen-UK$J GAGabonXAFwesternAfrica-I FRFrance%n €EUR,,westernEurope0H )FOFaeroe IslandsDKK.,,westernEurope*G !FMMicronesiaUSDwesternOceania6F -'FKFalkland IslandsFKPwesternSouth America$E FJFijiFJDwesternOceania*D FIFinlandEUR ,,westernEurope*C ETEthiopiaETB,..westernAfrica-B ESSpain%n €EUR.,,westernEurope)A EREritreaERN,..westernAfrica-@ )EHWestern SaharaMADwesternAfrica'? EGEgyptEGP,..westernAfrica*> EEEstoniaEEK ,,westernEurope0= 'ECEcuadorUSD.,,westernSouth America)< DZAlgeriaDZD,..westernAfrica;; 1'DODominican RepublicDOP,..westernNorth America.: 'DMDominicaXCDwesternNorth America)9 DKDenmarkDKK.,,westernEurope'8 DJDjiboutiDJFwesternAfrica17 DEGermany%n €EUR.,,westernEuropede96 )CZCzech Republic%n KčCZK ,,westernEuropecs#5 CYCyprusCYPwesternAsia04 -CXChristmas IslandAUDwesternOceania)3 !CVCape VerdeCVEwesternAfrica*2 'CUCubaCUPwesternNorth America41 7CSSerbia and MontenegroCSDwesternEurope30 !'CRCosta RicaCRC,..westernNorth America1/ 'COColombiaCOP.,,westernSouth America(. CNChinaY%nCNY,..westernAsia'- CMCameroonXAFwesternAfrica., 'CLChileCLF.,,westernSouth America,+ %CKCook IslandsNZDwesternOceania,* 'CICote D'IvoireXAFwesternAfrica9) #CHSwitzerlandSFr. %nCHF',.westernEuropefr-CH-( )CGCongo RepublicXAFwesternAfrica7' =CFCentral African RepublicXAFwesternAfrica5& ?CDCongo Democratic RepublicwesternAfrica.% )CCCocos IslandsAUDwesternOceania/$ 'CACanadaCAD,..westernNorth America,# 'BZBelizeBZDwesternNorth America(" BYBelarusBYR..westernEurope*! BWBotswanaBWP,..westernAfrica/ 'BVBouvet IslandNOKwesternAntartica# BTBhutanBTNwesternAsia- 'BSBahamasBSDwesternNorth America3 'BRBrazilR$%nBRR.,,westernSouth America0 'BOBoliviaBOB.,,westernSouth America. /BNBrunei DarussalamBNDwesternAsia- 'BMBermudaBMDwesternNorth America$ BJBeninXAFwesternAfrica& BIBurundiBIFwesternAfrica' BHBahrainBHD,..westernAsia+ BGBulgariaBGL ,,westernEurope+ %BFBurkina FasoXAFwesternAfrica/ BEBelgium%n €EUR.,,westernEurope* !BDBangladeshBDT,..westernAsia. 'BBBarbadosBBDwesternNorth America7 9BABosnia and HerzegovinaBAM,,westernEurope) !AZAzerbaijanAZM..westernAsia+ 'AWArubaAWGwesternNorth America3 AUAustralia%n AUS$AUD,..westernOceania3 ATAustria€ %nEUR,,westernEuropede-AT. )ASAmerican SamoaUSDwesternOceania2 'ARArgentinaARA.,,westernSouth America, !AQAntarcticaNOKwesternAntartica% AOAngolaAONwesternAfrica: 5'ANNetherlands AntillesANGwesternNorth America$ AMArmeniaAMDwesternAsia) ALAlbaniaALL.,,westernEurope. 'AIAnguillaXCDwesternNorth America9 3'AGAntigua and BarbudaXCDwesternNorth America( #AFAfghanistanAFAwesternAsia4 5AEUnited Arab EmiratesAED,..westernAsia& ADAndorraEURwesternEurope Urh8 p E  R ,  z R % X  h ?uM%t9 ]0 \)uM%sCX'X&0( -PFFrench PolynesiaXPFwesternOceania-' 'PEPeruPEI,..westernSouth America/& 'PAPanamaPAB,..westernNorth America$% OMOmanOMR,..westernAsia.$ #NZNew ZealandNZD,..westernOceania$# NUNiueNZDwesternOceania%" NRNauruAUDwesternOceania%! NPNepalNPR,..westernAsia. NONorwaykr %nNOK ,,westernEurope2 #NLNetherlands€ %nEUR,,westernEurope2 'NINicaraguaNIC,..westernNorth America& NGNigeriaNGNwesternAfrica. )NFNorfolk IslandAUDwesternOceania$ NENigerXOFwesternAfrica- 'NCNew CaledoniaXPFwesternOceania& NANamibiaNADwesternAfrica) !MZMozambiqueMZMwesternAfrica( MYMalaysiaMYR,..westernAsia/ 'MXMexicoMXN,..westernNorth America% MWMalawiMWKwesternAfrica% MVMaldivesMVRwesternAsia( MUMauritiusMURwesternAfrica' MTMaltaMTL,..westernEurope0 !'MSMontserratXCDwesternNorth America) !MRMauritaniaMROwesternAfrica0 !'MQMartiniqueEURwesternNorth America8 =MPNorthern Mariana IslandsUSDwesternOceania" MOMacaoMOPwesternAsia' MNMongoliaMNT..westernAsia! MMMyanmarwesternAsia# MLMaliXAFwesternAfrica* MKMacedoniaMKD,,westernEurope0 -MHMarshall IslandsUSDwesternOceania) !MGMadagascarMGFwesternAfrica& MDMoldovaMDLwesternEurope% MCMonacoEURwesternEurope) MAMoroccoMAD,..westernAfrica8 9LYLibyan Arab JamahiriyaLYD,..westernAfrica) LVLatviaLVL ,,westernEurope, !LULuxembourgEUR.,,westernEurope+ LTLithuaniaLTL.,,westernEurope& LSLesothoLSLwesternAfrica&~ LRLiberiaLRDwesternAfrica&} LKSri LankaLKRwesternAsia,| 'LILiechtensteinCHFwesternEurope/{ 'LCSt. LuciaXCDwesternNorth America'z LBLebanonLBP,..westernAsia@y MLALao People's Democratic RepublicLAK,..westernAsia'x !KZKazakhstanKZTwesternAsia4w )'KYCayman IslandsKYDwesternNorth America&v KWKuwaitKWD,..westernAsia+u #KRSouth KoreaKRW,..westernAsia(t #KPNorth KoreaKPWwesternAsia9s 3'KNSt. Kitts and NevisXCDwesternNorth America&r KMComorosKMFwesternAfrica(q KIKiribatiAUDwesternOceania%p KHCambodiaKHRwesternAsia,o +KGKyrgyz RepublicKGSwesternAsia$n KEKenyaKESwesternAfrica+m JPJapan¥%nJPY,..westernAsiaja&l JOJordanJOD,..westernAsia-k 'JMJamaicaJMDwesternNorth America-j ITItaly€ %nEUR.,,westernEurope)i ISIcelandISK.,,westernEurope'h IRIranIRR٬٫٫westernAsia$g IQIraqIQD,..westernAsia=f IIOBritish Indian Ocean TerritoryGBPwesternAfrica.e INIndiaRs.%nINR,..indianAsiaen-IN,d ILIsrael%n ₪ILS,..westernAsia)c IEIrelandEUR,..westernEurope)b IDIndonesiaIDR.,,westernAsia)a HUHungaryHUF.,,westernEurope+` 'HTHaitiHTGwesternNorth America(_ HRCroatiaHRK,,westernEurope1^ 'HNHondurasHNL,..westernNorth America<] AHMHeard and McDonald IslandsAUDwesternAntartica.\ HKHong KongHK$%nHKD,..westernAsia,[ 'GYGuyanaGYDwesternSouth America,Z 'GWGuinea-BissauGWPwesternAfrica$Y GUGuamUSDwesternOceania2X 'GTGuatemalaGTQ,..westernNorth AmericaRW e'GSSouth Georgia and the South Sandwich IslandsGBPwesternSouth America(V GRGreeceEUR.,,westernEurope0U /GQEquatorial GuineaXAFwesternAfrica0T !'GPGuadaloupeEURwesternNorth America GtI n; b ,  x N  ] /  R  A ^4 c'{Ph>IkB*o ZWZimbabweZWD,..westernAfrica%n ZMZambiaZMKwesternAfrica.m %ZASouth AfricaZAR,..westernAfrica&l YTMayotteEURwesternAfrica"k YEYemen,..westernAsia%j WSSamoaWSTwesternOceania9i ?WFWallis and Futuna IslandsXPFwesternOceania'h VUVanuatuVUVwesternOceania(g VNViet NamVND.,,westernAsia7f /'VIUS Virgin IslandsUSDwesternNorth AmericaL ='TCTurks and Caicos IslandsUSDwesternNorth America(K SZSwazilandSZLwesternAfrica4J 5SYSyrian Arab RepublicSYP,..westernAsia4I #'SVEl SalvadorSVC,..westernNorth America4H 7STSao Tome and PrincipeSTDwesternAfrica.G 'SRSurinameSRGwesternSouth America&F SOSomaliaSOSwesternAfrica&E SNSenegalXOFwesternAfrica)D !SMSan MarinoEURwesternEurope+C %SLSierra LeoneSLLwesternAfrica+B SKSlovakiaSKK ,,westernEurope;A ESJSvalbard & Jan Mayen IslandsNOKwesternEurope)@ SISloveniaSIT,,westernEurope)? !SHSt. HelenaSHPwesternAfrica)> SGSingaporeSGD,..westernAsia,= SESweden%n krSEK,,westernEurope'< SDSudanSDP,..westernAfrica); !SCSeychellesSCRwesternAfrica/: +SBSolomon IslandsSBDwesternOceania+9 %SASaudi ArabiaSAR..westernAsia%8 RWRwandaRWFwesternAfrica37 1RURussian FederationRUB..westernEurope)6 RORomaniaROL.,,westernEurope&5 REReunionEURwesternAfrica%4 QAQatarQAR,..westernAsia13 'PYParaguayPYG.,,westernSouth America%2 PWPalauUSDwesternOceania01 PTPortugal%n €EUR.$$westernEurope/0 7PSPalestinian TerritorywesternAsia4/ #'PRPuerto RicoUSD,..westernNorth America/. +PNPitcairn IslandNZDwesternOceania=- ;'PMSt. Pierre and MiquelonEURwesternNorth America(, PLPolandPLN.,,westernEurope(+ PKPakistanPKR,..westernAsia+* #PHPhilippinesPHP,..westernAsia0) -PGPapua New GuineaPGKwesternOceania OmIkD R +  U ' Y -  g . T W0b;zL(xM }Z1L%X-%QkskaskasKashmirifltrL3M+knkankanKannadaಕನ್ನಡfltrL(K#klkalkalKalaallisutfltrL3#jajpnjpnJapanese日本語fltrc = 1L%\jvjavjavJavanesefltrL:()ititaitaItalianitalianofltrc == 1 ? 1 : 2L/!isislislIcelandicÍslenskafltrL$ikipkipkInupiaqtltrL7~!-idindindIndonesianBahasa indonesiafltrLT|#eiainainaInterlinguaInternational Auxiliary Language AssociationfltrC(k#ieileileInterlinguefltrC&diuikuikuInuktituttltrL&WiiiiiiiiYiSichuanfltrL >ioidoidoIdofltrC!0igiboiboIgbofltrL3")hyhyehyeArmenianՀայերենfltrL1 huhunhunHungarianMagyarfltrc = 1L~r-hrhrvhrvCroatianHrvatskifltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L&BhohmohmoHiri MotufltrL1'+hihinhinHindiहिंदीfltrL#hzherherHererofltrL;!)hehebhebHebrewעבריתfrtlc == 1 ? 1 : 2L( )shhbsSerbo-CroatiantltrL'hahauhauHausaHausafltrL4;hthathatHaitian; Haitian CreolefltrL%2gugujgujGujaratifltrL$gngrngrnGuaranitltrL!MgvglvglvManxfltrE+DglglgglgGalleganGalegofltrL@C;gaglegleIrishGaeilgefltrc==1 ? 1 : c==2 ? 2 : 3L?@;gdglaglaGaelicScotsfltrc==1 ? 1 : c==2 ? 2 : 3L9";fffulfulFulahFulfulde, Pulaar, PulartltrL$fyfryfryFrisiantltrL: )frfrafraFrenchFrançaisfltrc == 1 ? 1 : 2L7o)fifinfinFinnishsuomifltrc == 1 ? 1 : 2L#mfjfijfijFijianfltrL.a!fafasfasPersianفارسیtltrL$^fofaofaoFaroesefltrL&MeeeweeweEweƐʋɛfltrL*IeueuseusBasqueeuskerafltrL8;)etestestEstonianEestifltrc == 1 ? 1 : 2L4')eoepoepoEsperantofltrc == 1 ? 1 : 2C2)enengengEnglishfltrc == 1 ? 1 : 2LN)-)elellellGreekModern (1453-)Ελληνικάfltrc == 1 ? 1 : 2L%`dzdzodzoDzongkhafltrL#GdvdivdivDivehifltrL8)dedeudeuGermanDeutschfltrc == 1 ? 1 : 2L6[)dadandanDanishDanskfltrc == 1 ? 1 : 2L)IcycymcymWelshCymraegfltrL!ucrcrecreCreetltrL%]cocoscosCorsicanfltrL$\kwcorcorCornishfltrL$ncvchvchvChuvashfltrL)mcuchuchuSlavicChurchfltrA$^cechecheChechenfltrL%ZchchachaChamorrofltrL|Q-cscescesCzechčeštinafltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L+cacatcatCatalanCatalàfltrL8|1bgbulbulBulgarianБългарскиfltrL#(brbrebreBretonfltrL$kbsbosbosBosnianfltrL$\bobodbodTibetanfltrL$QbibisbisBislamafltrL$hbnbenbenBengalifltrL;f!5bebelbelBelarusianБеларускаяfltrL.!bmbambamBambaraBamanankanfltrL$babakbakBashkirfltrL3p##azazeazeAzerbaijaniazərbaycantltrL#cayaymaymAymaratltrL$9aeaveaveAvestanfltrA#6avavaavaAvaricfltrL%xasasmasmAssamesefltrL&ZanargargAragonesefltrL1T)araraaraArabicالعربيةtrtlL0w%amamhamhAmharicአማርኛfltrL!?akakaakaAkantltrL/rafafrafrAfrikaansAfrikaansfltrL=!;ababkabkAbkhazianаҧсуа бызшәаfltrL!aaaaraarAfarfltrL P]7Q) a .  ^ 2 W /  S ,  c = b2a:g9qK&j=b&"QtttattatTatarfltrL"JtatamtamTamilfltrL%FtytahtahTahitianfltrL9)svswesweSwedishsvenskafltrc == 1 ? 1 : 2L4swswaswaSwahiligenericKiswahilitltrL&rsusunsunSundanesefltrL"LsssswsswSwatifltrL*-srsrpsrpSerbianSrpskifltrL&!scsrdsrdSardiniantltrL*sqsqisqiAlbanianshqiptltrL:)esspaspaSpanishEspañolfltrc == 1 ? 1 : 2L*zstsotsotSothoSouthernfltrL)tsosomsomSomaliSomalifltrL#SsdsndsndSindhifltrL"PsnsnasnaShonafltrL#DsmsmosmoSamoanfltrL*;'sesmesmeNorthern SamifltrLn2'slslvslvSlovenianSlovenščinafltrc%100==1 ? 1 : c%100==2 ? 2 : c%100==3 || c%100==4 ? 3 : 4L(#-skslkslkSlovakSlovenčinafltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L&jsisinsinSinhalesefltrL%MsasansanSanskritfltrA"HsgsagsagSangofltrL4!-rurusrusRussianPyccĸийfltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L)0rnrunrunRundiKirundifltrL-roronronRomanianRomânăfltrL*'rmrohrohRaeto-RomancefltrL$xququequeQuechuatltrL+_pspuspusPushtoپښتوtltrL?!!)ptporporPortugueseportuguêsfltrc == 1 ? 1 : 2Lj| plpolpolPolishPolskifltrc==1 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L!8piplipliPalifltrA$'papanpanPanjabifltrL.x/osossossOssetian; OsseticfltrL"gomormormOromotltrL"eororioriOriyafltrL#ojojiojiOjibwatltrL-ocociociOccitanpost 1500tltrL-U-nynyanyaChichewa; NyanjafltrL9e)nonornorNorwegianNorsktltrc == 1 ? 1 : 2L.W/nbnobnobNorwegian BokmålfltrL.J/nnnnonnoNorwegian NynorskfltrL:!)nlnldnldDutchNederlandsfltrc == 1 ? 1 : 2L#nenepnepNepalifltrL#yngndondoNdongafltrL)ondndendeNdebeleNorthfltrL)GnrnblnblNdebeleSouthfltrL#7nvnavnavNavajofltrL"6nanaunauNaurufltrL$rmymyamyaBurmesefltrL6X'msmsamsaMalaygenericBahasa melayutltrL"FmimrimriMaorifltrL&}mnmonmonMongoliantltrL&{momolmolMoldavianfltrL)6mtmltmltMalteseMaltifltrL%)mgmlgmlgMalagasytltrL; !5mkmkdmkdMacedonianМакедонскиfltrL$mrmarmarMarathifltrL&mlmalmalMalayalamfltrL%mhmahmahMarshallfltrL"nlgluglugGandafltrL)i%lulublubLuba-KatangafltrL*g'lbltzltzLetzeburgeschfltrLya!%ltlitlitLithuanianLietuviškaifltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && (c%100<10 || c%100>=20) ? 2 : 3L$[lnlinlinLingalafltrL0Z!lilimlimLimburgishLimburgerfltrLVk_lvlavlavLatvianLatviešufltrc%10==1 && c%100!=11 ? 1 : c != 0 ? 2 : 3L"ilalatlatLatinfltrA dlolaolaoLaofltrL$LkukurkurKurdishtltrL%<kjkuakuaKuanyamafltrL12kokorkorKorean한국어fltrc = 1L".kgkonkonKongotltrL!-kvkomkomKomitltrL0%kykirkirKirghizКыргызfltrL3##rwkinkinKinyarwandaKinyarwandafltrL#kikikkikKikuyufltrL"{kmkhmkhmKhmerfltrL-X!kkkazkazKazakhҚазақfltrL#SkrkaukauKanuritltrL%RkakatkatGeorgianfltrL  |CvB j >  e ;  q ? .,1zh-HansSimplified ChinesefltrL/+3zh-HantTraditional ChinesefltrL(*zuzulzulZuluisiZulufltrL*<zhzhozhoChinese中文tltrL#9zazhazhaZhuangtltrL$yiyidyidYiddishtltrL"&xhxhoxhoXhosafltrL'(wowolwolWolofWoloffltrL$wawlnwlnWalloonfltrL%vovolvolVolapükfltrC7_!-vivievieVietnameseTiếng ViệtfltrL"XvevenvenVendafltrL(?uzuzbuzbUzbeko'zbektltrL)ururdurdUrduاردوfltrL p5-ukukrukrUkrainianУкраїнськаfltrc%10==1 && c%100!=11 ? 1 : c%10>=2 && c%10<=4 && (c%100<10 || c%100>=20) ? 2 : 3L#fuguiguigUighurfltrL twtwitwiTwifltrL1wtrturturTurkishTϋrkçefltrc = 1L$qtktuktukTurkmenfltrL#CtstsotsoTsongafltrL#BtntsntsnTswanafltrL/o'totontonTongaTonga IslandsfltrL%ttitirtirTigrinyafltrL6O7ththathaThaiภาษาไทยfltrL$CtltgltglTagalogfltrL"BtgtgktgkTajikfltrL5&1teteltelTeluguతెలుగుfltrL