SQLite format 3 @ .(h P ; 11Qtablesimple_translationsimple_translation]CREATE TABLE simple_translation( written_rep TEXT, trans_list, max_score, rel_importance )33Oviewtranslation_groupedtranslation_groupedCREATE VIEW translation_grouped AS SELECT lexentry, written_rep, min(sense_num) AS min_sense_num, group_concat(sense, ' | ') AS sense_list, trans_list, max(score) AS score, max(importance) AS importance FROM ( -- force order in group_concat SELECT * FROM translation ORDER BY lexentry, written_rep, trans_list, sense_num, score DESC ) GROUP BY lexentry, written_rep, trans_list-##!tabletranslationtranslationCREATE TABLE translation( lexentry TEXT, sense_num TEXT, sense, written_rep TEXT, trans_list, score, is_good, importance ) Y \}wqke_YSMGA;5/)#{uoic]WQKE?93-'! 0sS1 e BeirutBeyrouth?PPCd BeijingPékin?T16[t: c BayernBavière?Qѥ*&b BastiaBastia?G 0a ++Basse-NormandieBasse-Normandie?MYV` BasqueBasque?S ߙ{I!_ BarbadosBarbade?0V^ BanjulBanjul?M9U&] !!BangladeshBangladesh?=(ŀP \ BangkokBangkok?N&oS,[ %)Bandar Udarabase aérienne?PAZ BamakoBamako?NݜVT*Y #'BalochistanBaloutchistan?N&oSX BaliBali?6F(!W BahrainBahreïn?T"~sE'V 'Bahasa jepangjaponais?Vvo&U +Bahasa Ot Danumdohoi?3X@?0T 1%Bahasa Chittagoniachittagonien?8 eS BahamaBahamas?쌪R BadarBadr?E,Q AzoresAçores?KT(P !%AzerbaijanAzerbaïdjan? O AyyubJob?R'* N AvignonAvignon?Pњ p M AveyronAveyron?Q'b2L --Austria-HongariaAutriche-Hongrie?Qdr&]`!K AustriaAutriche?DCo9J /9Australia SelatanAustralie-Méridionale?TA}746I +7Australia BaratAustralie-Occidentale?LiLv$H AustraliaAustralie?2XN:G AudeAude?R UF AubeAube?RzLXE AttilaAttila?M9U$D !AtlantikAtlantique?S 1 C AthenaAthènes?S 1.B '+Asia TenggaraAsie du Sud-Est?U{D_)A %#Asia SelatanAsie du Sud?TA}74,@ !-Asia DalamAsie intérieure?A'*m? AsiaAsie?6N> ArubaAruba?PPC!= ArmeniaArménie?SC< ArlesArles?NݜVT ; AriègeAriège?R U%: #AristotelesAristote?R j9 ArianeAriane?Rg8 AriadneAriane?Rg$7 ArgentinaArgentine?=(ŀP"6 ArdècheArdèche?Oz"5 ArdennesArdennes?Oĉ* ʴ&4 !!ArchimedesArchimède?Y(A+3 !+Arab SaudiArabie saoudite?2XN:!2 AntwerpenAnvers?KT01 )-Antillen KecilPetites Antilles?Pњ p90 -;Antillen BelandaAntilles néerlandaises?KcJ]47/ 31Antigua dan BarbudaAntigua-et-Barbuda?Py&. #AntartikaAntarctique?Qdr&]`"- AnguillaAnguilla?KT, AngolaAngola?Bjg&+ !!AndromakheAndromaque?MYV4* -1Andorra la VellaAndorre-la-Vieille?X!?\ ) AndorraAndorre?_Oѩ!%( !AndalusiaAndalousie?N&oS"' AnatoliaAnatolie?N&oS$& AmsterdamAmsterdam?\ZYq% AmmanAmman?P+Dxе:$ +?Amerika SerikatÉtats-Unis d’Amérique?+#x1# +-Amerika SelatanAmérique du Sud?g'S0" 7Alzheimermaladie d’Alzheimer?T,v>@! ;;Alpes-de-Haute-ProvenceAlpes-de-Haute-Provence?PPC0 ++Alpes-MaritimesAlpes-Maritimes?POv?8 AlmatyAlmaty?T%GO AllierAllier?RG'i AlkitabBible? gG" AljazairAlgérie?g'S AlgiersAlger?KcJ]4 AlbiAlbi?KcJ]4 AlbaniaAlbanie?)V" #Al-Qur’anCoran?M<}8Z# Al-QaedaAl-Qaïda?G ! AkhillesAchille?S<%1G\ AjmanAjman?E AjaccioAjaccio?RA AisneAisne?SrI AiolisÉolide?JQdq( AinAin?Rg" AgathiasAgathias?I5M/. ))Afrika SelatanAfrique du Sud?o [ ZU Y XQ W VR U TM S RT Q PR O N\ M# Lk K, Jg I' Hj G- Fo E/ Do C. Bl A* @k ?- >o =.