SQLite format 3 @ e .K P ; 11Qtablesimple_translationsimple_translationCREATE 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 ) : @}wqke_YSMGA;5/)# ?'