CHANGE.log

This file details the changes made on various tables of the lemlat_db since November 2015.
The file is written in Italian until 25th July 2018.

10 Novembre 2015

1)
Tabella "lessario"

l8007
les "longaev" -> les "longaeu"

n0045
gen "n" -> gen "m"

p3345
riga della fe "praesens"
n_id P3345 -> n_id p3345

m0929
gen "n" -> gen "m"

q0312
les "quoqueversum" -> les "quoqueuersum"
les "quoqueversus" -> les "quoqueuersus"

s2491
codles n3 -> codles n3n

m1909
les "mirobalan"
codles n2 -> codles n2n


2)
Tabella "forme_ecc"
Sostituito il codice 'a" con 'A" nel campo 'c01' per le seguenti righe.

'100027', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '7938', '2004-06-18 17:37:33'
'100025', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '7937', '2004-06-18 17:33:10'
'100024', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '7935', '2004-06-18 17:32:06'
'64944', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5178', '2004-03-26 15:57:10'
'64943', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5177', '2004-03-26 15:57:10'
'64942', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5176', '2004-03-26 15:57:10'
'64941', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5175', '2004-03-26 15:57:10'
'64940', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5174', '2004-03-26 15:57:10'
'64939', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5173', '2004-03-26 15:57:10'
'64938', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5172', '2004-03-26 15:57:10'
'64937', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5159', '2004-03-26 15:57:10'
'64936', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5158', '2004-03-26 15:57:10'
'64935', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5157', '2004-03-26 15:57:10'
'64934', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5156', '2004-03-26 15:57:10'
'64933', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5155', '2004-03-26 15:57:10'
'64931', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5153', '2004-03-26 15:57:10'
'64930', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5152', '2004-03-26 15:57:10'
'64929', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5151', '2004-03-26 15:57:10'
'64928', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5150', '2004-03-26 15:57:10'
'64926', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5148', '2004-03-26 15:57:10'
'64924', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5145', '2004-03-26 15:57:10'
'64923', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5146', '2004-03-26 15:57:10'
'64922', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5144', '2004-03-26 15:57:10'
'64921', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5143', '2004-03-26 15:57:10'
'64920', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5142', '2004-03-26 15:57:10'
'64918', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5140', '2004-03-26 15:57:10'
'64917', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5139', '2004-03-26 15:57:10'
'64916', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5138', '2004-03-26 15:57:10'
'64915', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5137', '2004-03-26 15:57:10'
'64914', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5136', '2004-03-26 15:57:10'
'64912', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5134', '2004-03-26 15:57:10'
'64896', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5166', '2004-03-26 15:57:10'
'64886', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5121', '2004-03-26 15:57:10'
'64881', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5116', '2004-03-26 15:57:10'
'64880', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '1', '5115', '2004-03-26 15:57:10'
'64879', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5114', '2004-03-26 15:57:10'
'64878', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5113', '2004-03-26 15:57:10'
'64877', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5112', '2004-03-26 15:57:10'
'64875', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5110', '2004-03-26 15:57:10'
'64874', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5109', '2004-03-26 15:57:10'
'64873', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5108', '2004-03-26 15:57:10'
'64872', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5107', '2004-03-26 15:57:10'
'64871', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5106', '2004-03-26 15:57:10'
'64870', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5105', '2004-03-26 15:57:10'
'64869', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5104', '2004-03-26 15:57:10'
'64868', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5103', '2004-03-26 15:57:10'
'64867', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5102', '2004-03-26 15:57:10'
'64866', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5101', '2004-03-26 15:57:10'
'64865', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5100', '2004-03-26 15:57:10'
'64864', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5099', '2004-03-26 15:57:10'
'64863', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5098', '2004-03-26 15:57:10'
'64862', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5097', '2004-03-26 15:57:10'
'64861', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5096', '2004-03-26 15:57:10'
'64860', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5095', '2004-03-26 15:57:10'
'64859', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5094', '2004-03-26 15:57:10'
'64858', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5093', '2004-03-26 15:57:10'
'64857', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5092', '2004-03-26 15:57:10'
'64856', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5091', '2004-03-26 15:57:10'
'64855', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5090', '2004-03-26 15:57:10'
'64854', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5089', '2004-03-26 15:57:10'
'64853', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5088', '2004-03-26 15:57:10'
'64852', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '3', '5087', '2004-03-26 15:57:10'
'64851', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5086', '2004-03-26 15:57:10'
'64850', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5085', '2004-03-26 15:57:10'
'64849', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5084', '2004-03-26 15:57:10'
'64848', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5083', '2004-03-26 15:57:10'
'64847', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5082', '2004-03-26 15:57:10'
'64846', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5081', '2004-03-26 15:57:10'
'64845', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5080', '2004-03-26 15:57:10'
'64844', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5079', '2004-03-26 15:57:10'
'64841', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5074', '2004-03-26 15:57:10'
'64840', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5073', '2004-03-26 15:57:10'
'64839', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5072', '2004-03-26 15:57:10'
'64838', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '2', '5071', '2004-03-26 15:57:10'
'64834', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '3', '5067', '2004-03-26 15:57:10'
'64833', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5066', '2004-03-26 15:57:10'
'64831', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5064', '2004-03-26 15:57:10'
'64830', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5063', '2004-03-26 15:57:10'
'64829', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '3', '5062', '2004-03-26 15:57:10'
'64828', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5061', '2004-03-26 15:57:10'
'64827', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5060', '2004-03-26 15:57:10'
'64826', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '1', '5059', '2004-03-26 15:57:10'
'64825', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5058', '2004-03-26 15:57:10'
'64822', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5055', '2004-03-26 15:57:10'
'64821', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5054', '2004-03-26 15:57:10'
'64820', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5053', '2004-03-26 15:57:10'
'64819', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5052', '2004-03-26 15:57:10'
'64818', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5051', '2004-03-26 15:57:10'
'64817', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5050', '2004-03-26 15:57:10'
'64816', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5049', '2004-03-26 15:57:10'
'64815', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5214', '2004-03-26 15:57:10'
'64813', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5213', '2004-03-26 15:57:10'
'64812', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5212', '2004-03-26 15:57:10'
'64811', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5211', '2004-03-26 15:57:10'
'64809', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5209', '2004-03-26 15:57:10'
'64808', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5208', '2004-03-26 15:57:10'
'64806', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5206', '2004-03-26 15:57:10'
'64805', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5205', '2004-03-26 15:57:10'
'64803', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5203', '2004-03-26 15:57:10'
'64802', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5202', '2004-03-26 15:57:10'
'64799', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5199', '2004-03-26 15:57:10'
'64798', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '1', '5198', '2004-03-26 15:57:10'
'64797', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '1', '5197', '2004-03-26 15:57:10'
'64796', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '3', '5196', '2004-03-26 15:57:10'
'64792', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5192', '2004-03-26 15:57:10'
'64791', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5191', '2004-03-26 15:57:10'
'64790', NULL, '', 'a', 'o', '-', '-', '-', 'r', '-', '-', '-', '1', '5190', '2004-03-26 15:57:10'
'64789', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5189', '2004-03-26 15:57:10'
'64788', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '-', '5188', '2004-03-26 15:57:10'
'64785', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '3', '5185', '2004-03-26 15:57:10'
'64783', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5183', '2004-03-26 15:57:10'
'64782', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5182', '2004-03-26 15:57:10'
'64781', NULL, '', 'a', 'u', '-', '-', '-', 'r', '-', '-', '-', '1', '5181', '2004-03-26 15:57:10'
'64780', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5180', '2004-03-26 15:57:10'
'64779', NULL, '', 'a', 'f', '-', '-', '-', 'r', '-', '-', '-', '1', '5179', '2004-03-26 15:57:10'


3) Tabella Lemmario:
removed follwing duplicate lines:

'1200','aestiuus/-os','n2/1','','af-','a1030'
'1216','aeternus','N2/1','*','af-','a1043'
'1908','ambiguus','n2/1','','af-','a1624'
'3081','arbitrarius','N2/1','*','af-','a2652'
'3109','arcanus','N2/1','*','af-','a2675'
'3653','assiduus','N2/1','*','af-','a3163'
'4964','breuis','N3A','*','af-','b0630'
'6013','carus','N2/1','*','af-','c0721'
'6644','certus','n2/1','','af-','c1275'
'6999','cieo','V2','','af-','c1604'
'8276','commodus','n2/1','','af-','c2708'
'9512','continuus','N2/1','*','af-','c3758'
'10018','cottidianus','N2/1','*','af-','c4212'
'10064','crastinus','n2/1','','af-','c4258'
'10089','creber','N2/1','*','af-','c4277'
'14958','exiguus','n2/1','','af-','e1489'
'15597','fallo','V3','','af-','f0127'
'17587','gratuitus','N2/1','*','af-','g0572'
'18371','hornus','n2/1','','af-','h0575'
'19056','immeritus','N2/1','*','af-','i0371'
'19539','inauspicatus','N2/1','*','af-','i9805'
'19620','incertus','n2/1','','af-','i0878'
'20414','infinitus','n2/1','','af-','i1581'
'20993','insperatus','N2/1','*','af-','i2089'
'21707','inuitus','N2/1','*','af-','i2715'
'23132','limus','n2/1','','af-','l0805'
'23229','liquidus','n2/1','','af-','l0885'
'23378','longinquus','N2/1','*','af-','l1018'
'23862','magnus','N2/1','*','af-','m0132'
'24039','manifestus','N2/1','*','af-','m0292'
'24279','matutinus','n2/1','','af-','m0497'
'24877','minimus','N2/1','*','af-','m1031'
'25044','modicus','n2/1','','af-','m1174'
'25484','multimodus','N2/1','*','af-','m1657'
'25524','multus','N2/1','*','af-','m1695'
'25714','mutuus','n2/1','','af-','m1878'
'25971','necessarius','n2/1','','af-','n0141'
'26190','nimius','n2/1','','af-','n0312'
'27389','omnimodus','N2/1','*','af-','o0713'
'28513','paruus','N2/1','*','af-','p0490'
'28659','paucus','n2/1','','af-','p0605'
'28682','paullulus','N2/1','*','af-','p0623'
'28686','paullus','N2/1','*','af-','p0625'
'28717','pauxillus','N2/1','*','af-','p0649'
'29465','permagnus','N2/1','*','af-','p1335'
'29517','permultus','n2/1','','af-','p1381'
'29541','pernimius','N2/1','*','af-','p1404'
'29629','perpetuus','n2/1','','af-','p1484'
'31069','postremus','N2/1','*','af-','p2736'
'32735','proximus','N2/1','*','af-','p4245'
'33295','quadripertitus','N2/1','*','af-','q0069'
'36225','sedulus','N2/1','*','af-','s0932'
'36496','sempiternus','N2/1','*','af-','s1191'
'36758','serus','n2/1','','af-','s1431'
'37323','solus','N2/1','*','af-','s1947'
'39092','superfluus','N2/1','*','af-','s3558'
'39258','superuacaneus','N2/1','*','af-','s3715'
'39359','supremus','N2/1','*','af-','s3813'
'39857','tempestiuus','N2/1','*','af-','t0245'
'40694','tranquillus','n2/1','','af-','t0968'
'41312','tumultuarius','N2/1','*','af-','t1734'
'41433','tutus','N2/1','*','af-','t1848'
'42026','uerus','N2/1','*','af-','u0469'
'42601','ultimus','N2/1','*','af-','u0943'



12 novembre 2015

Tabella: forme_ecc
riga pr_key 1636 & les_id 30873
colonna c03: F > H


Tabella Lessario:
added new les: par:
n_id 'p4697'
smv '+'
les 'par'
codles 'v1r'
s_omo 'b'
pr_key '100093'

Tabella Lemmario:
added new lemma
id_lemma '28435' 
lemma 'paro'
codlem 'V1'
codmorf 'VmF'
n_id 'p0419'




1 Dicembre 2015

Tabella "lessario"
- aggiunta la riga con pr_key 100094 -> n_id "a3440", les "audi", cod les "v7s", lem "audiui". Motivo: gestire forme come "audierunt", "audierit"

- aggiunta la riga con pr_key 100095 -> n_id "c3712", les "contend", cod les "v7s". Motivo: gestire forme come "contenderunt", "contenderant"

- modificata riga con pr_key 52001 -> les "relinq" cambiato in "relinqu". Motivo: produrre lemma "relinquo" e non "relinqo"

- aggiunta riga con pr_key 100096 -> n_id "p5011", les "propterea", codles "i". Motivo: assenza in LEMLAT del lemma "propterea"


2 Dicembre 2015

Tabella "lessario"
- aggiunta la riga con pr_key 100097 -> n_id "t1505", les "tametsi", codles "i". Motivo: assenza in LEMLAT del lemma "tametsi"
- aggiunta la riga con pr_key 100098 -> n_id "p5656", les "priusquam", codles "i". Motivo: assenza in LEMLAT del lemma "priusquam"
- aggiunta la riga con pr_key 100099 -> n_id "r1111", les "rettul", codles "v7s". Motivo: assenza in LEMLAT della base "rettul" per il perfetto del lemma "refero"
- inserito il valore "+" nel campo "smv" della riga con pr_key 56279. Motivo: gestione delle basi del participio perfetto/futuro e del perfetto del lemma "spolio/-or", precedentemente non gestite
- aggiunta la riga con pr_key 100100 -> n_id "m1743", les "muni", codles "v7s", lem "muniui". Motivo: assenza in LEMLAT della base "muni" del perfetto del lemma "munio" (i.e. forme come "munierat" non erano gestite)
- corretto il les della riga con pr_key 41896. Da "paperc" a "peperc". Motivo: il perfetto del lemma "parco" Ë "peperci" e non "paperci"
- aggiunta la riga con pr_key 100102 -> n_id "p5519", les "praeterquam", codles "i". Motivo: assenza in LEMLAT del lemma "praeterquam"
- aggiunte le righe con pr_key 100103 e 100104: hanno rispettivamente codles "quen" e "quan". Servono per gestire le forme "quandam" e "quandam" del lemma "quidam". Per attribuire i codici morfologici a queste forme, abbiamo aggiunto le righe con pr_key 8092 e 8093 nella tabella "forme_ecc_original"


24 Marzo 2016

Tabella "lessario" (original)
- inserito il valore "v" nel campo "clem" della riga con pr_key 17739. Motivo: mancata risalita al lemma "destino" della forma eccezionale "destinato"
- corretto il valore nel campo "gen" della riga con pr_key 8741. Motivo: c'era il valore "m", che era sbagliato
- aggiunte le righe con pr_key 100105, 100106 e 100107. Motivo: mancava la base (collocut) del participio perfetto (100106), del supino (100105)e del participio futuro (100106) del lemma "colloquor". Di conseguenza, la riga con pr_key 11534 Ë stata modificata, inserendo il valore "v" nel campo "clem" e togliendo il valore "+" nel campo "smv"
- aggiunto un valore nel campo "codlem" alle righe con pr_key 3201, 3203, 4800, 4801, 8665, 8969, 9373, 9374, 9588, 9747, 12851, 18174, 18276, 21002, 21726, 64759, 26257, 27916, 41811, 41856, 43416, 43446, 45333, 45335, 47455, 47456, 56793, 60288, 60405, 65678, 42665, 27322, 27324, 27333, 27334, 27339, 27342, 27348, 27363, 32518, 32534, 6285, 6291, 65001, 65003, 65005, 23671, 23679, 65033, 28323, 28324, 28323,28324, 32607, 32608, 32618, 32592, 32595, 32596, 32597, 32598, 32599, 32600, 32603, 28309, 28314, 65025, 64999, 64992, 6274, 6276, 65066, 65054, 65106, 65118, 65127, 65139, 49778, 64711, 64731, 49793, 49775, 50261, 50270, 65080, 65092.
Motivo: si tratta di righe di forme eccezionali prive del codlem (usciva codlem *).


30 Marzo 2016

Tabella "forme_ecc" (original)
- cancellate le righe con pr_key = 6263 / 6264 / 6211. Erano errori


17 Ottobre 2016


Tabella "lessario"
- sostituto il valore "v1r" con il valore "v3r" nel campo "codles" della riga con pr_key 42091. Era un errore


4 Novembre 2016

Tabella "forme_ecc"
- riga con pr_key 5116 (les_id: 64881). Cambiati i valori dei campi c01, c02 e c03 da "Af-" a "VmH". Era un errore.


1 Dicembre 2016
Tabella "lessario"
- riga con n_id "p3970" e pr_key "48069". Cancellata perchÈ la CLEM in questione (rappresentata dalla sola riga qui in oggetto) era una immotivata duplicazione della CLEM con n_id "p3966"
- riga con n_id "r0998" e pr_key "51501". Cancellata perchÈ la CLEM in questione (rappresentata dalla sola riga qui in oggetto) era una immotivata duplicazione della CLEM con n_id "r0159"


10 Gennaio 2017
Tabella "lessario"
- sostituto il valore "v1r" con il valore "v3r" nel campo "codles" della riga con pr_key 19062. Era un errore


6 Febbraio 2017
Tabella "lessario"
- sostituto il valore "n2" con il valore "n6" nel campo "codles" della riga con pr_key 48974. Era un errore. Trattandosi di un aggettivo e non di un nome, di conseguenza, Ë stato sostituito il valore nel campo gen ("m" -> "*")


12 Aprile 2017
Tabella "lessario"
- aggiunta la CLEM con n_id r7054, che consiste di un solo LES. Lemma "repens" (CODLEM: N3A)


6 Novembre 2017
Tabella "lessario"
- sostituto (a) il valore "n7" con il valore "n32" nel campo "codles" e (b) il valore "*" con il valore "m" nel campo "gen" della riga con pr_key 61281. Era un errore


6 Dicembre 2017
Tabella "lessario"
- sostituto (a) il valore "n71" con il valore "n31" nel campo "codles" e (b) il valore "*" con il valore "f" nel campo "gen" della riga con pr_key 29024. Era un errore
Tabella "tab_le"
- - sostituto il valore "6" con il valore "4" nel campo "codLE"  della riga con pr_key 12416. Era un errore (connesso al precedente)


20 Dicembre 2017
Tabella "lessario"
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 26638. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 23163. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 26410. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 26551. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 27639. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 28454. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 28895. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 29174. Era un errore
- sostituto il valore "v3d" con il valore "v1d" nel campo "codles" della riga con pr_key 30514. Era un errore
- rimosso il valore "+" dal campo "smv" della riga con pr_key 24954. Era un errore


16 Gennaio 2018
Tabella "lessario"
Aggiunto il lemma "mas" (aggettivo), con n_id = 'm1952'. Apportate le conseguenti modifiche nella tabella 'tab_le'


29 Gennaio 2018
Tabella 'lessario'.
Modificate 61 righe con la seguente query di aggiornamento:
update lemlat_db.lessario 
set lem = '-is'
 where codles = 'n7' and les like '%ns' and lem = '';


9 Febbraio 2018
Tabella 'lessario'.
Modificato il les della riga con pr_key 14361 da 'cordalent' a 'cordolent'. Era un errore.
Modificato il codles della riga con pr_key 34932 da 'n7' a 'n32' e il genere da "*" a "2". Era un errore.


12 Febbraio 2018
Tabella 'lessario'.
Modificati codles e gen della riga con pr_key 56719. codles da "n6" a "n2"; gen da "*" a "m"

31 Maggio 2018
Tabella 'lessario'.
Aggiunta la riga con pr_key 126543. Mancava l'analisi del participio futuro di "nascor" come "natur-".

10 Luglio 2018
Tabella 'lessario'.
Sostituito codles 'v64a' con codles 'v68a' sulla riga con pr_key 21378. Motivo: lemlat non analizzava la forma impersonale di congiuntivo presente "eatur".

18 Luglio 2018
Sistemate incoerenze di attribuzione dei codici nel campo codLe del lessario e nel campo codLE di tab_le per i sueguenti pr_key:
+--------+------------+-----+------+
| pr_key | les        | LES | TAB  |
+--------+------------+-----+------+
|   2614 | alter      | r   | 1    |
|  18551 | dies       | m   | 4    |
|  18550 | dihes      | m   | 4    |
|   6268 | alterutr   | r   | 1    |
|  38451 | nemin      | r   | c    |
|  38513 | neutr      | r   | 1    |
|  39244 | nonnemin   | r   | c    |
|  64200 | utr        | r   | 1    |
|  61687 | trychn     | 2   | 5    |
|    788 | acratophor | 1   | 5    |
|  36232 | melilot    | 2   | 5    |
|  19987 | du         | p   | n    |
|  39126 | nihil      | r   | z    |
|  39127 | nil        | r   | z    |
|  39248 | nonnihil   | r   | z    |
|  39249 | nonnil     | r   | z    |
+--------+------------+-----+------+

L'unica incoerenza di attribuzione del codice nel campo codLE sussiste per il les con pr_key 41719. Il codice Ë 8 nel lessario, mentre ci sono due righe in tab_le che registrano rispettivamente i due lemmi eccezionali della clem: "panis" con codLE 3 e "pane" con codLE 5.
|  41719 | pan        | 8   | 3    |
|  41719 | pan        | 8   | 5    |


25th July 2018
- Linux binaries are now compatible with MariaDB libraries version 10.1 tested compatibility with Mysql 5.7
- lemlat_db now includes the more than 85k lexical entries of the Du Cange Glossary of Medieval Latin. Full reference:
Charles du Fresne Du Cange, Bénédictins de Saint-Maur, Pierre Carpentier, Louis Henschel, and Léopold Favre. 1883–1887. Glossarium mediae et infimae latinitatis. Niort.

13th September 2018
n_id='d2184'. Added les='dormi' (codles='v7s') to analyse forms like 'dormierant'.

17th September 2018
n_id='s9998'. Added les='satull' (codles='n6').

18th September 2018
Added n_id='a3743' and n_id='a3742', to register separate lexical entries for interjection 'a' and first letter of Latin alphabet 'a' (as reported in OLD).
Moved the graphical variant 'ah' from a0001 CLEM ('a' preposition) to a3743 CLEM (interjection).
Added n_id='a3744', to register a separate entry for lemma 'an' as preposition (as reported in OLD).

3rd October 2018
n_id = 'c2414' or n_id = 'p1306': changed columns with codles = 'v2ie' into codles = 'v2e' 

10th October 2018
Table 'lessario'.
Changed codles 'v64a' with codles 'v68a' in rows with pr_key 82, 11578, 17089, 18902, 22324, 31088, 38085, 42684, 45816, 47137, 51208, 60298, 57868, 57887, 12045, 42715, 43736, 52046, 52117, 52431, 56825..
Motivation: to analyse impersonal passive forms of present subjunctive for verbs derived from "eo" (e.g. "abeatur").

18th February 2019
Table 'lessario'.
Moved les 'rept' with codles 'N2' (pr_key='51710') from the CLEM of lemma 'repo' (n_id='r1286') to a CLEM on its own (n_id='r1512').
Motivation: "reptus" is a second declension noun with its separate entry in G&G.

21st February 2019
(A) Lemma 'pus' (particle)
Table 'lessario'. Row with pr_key = '48488' -> codles= 'n' changed to codles = 'i'
Table 'forme_ecc'. Removed row with pr_key = '6150'
Table 'lemmario'= row with id_lemma = '33102'. Changed codlem = 'N? to codlem = 'I'. Changed upostag = 'NOUN' to ' upostag = 'PART'

(B) upostag = 'NUM' to ordinal numerals
Table 'lemmario': changed upostag = 'ADJ' to 'NUM' to the ordinal numerals (58 in total):
'6503', 'centum', 'N', '', 'AnP', 'c1159', 'centum', 'NUM', NULL, 'B'
'10857', 'decem', 'N', '', 'AnP', 'd0144', 'decem', 'NUM', NULL, 'B'
'13113', 'ducenti', 'N2/1', '*', 'An-', 'd0360', 'ducenti', 'NUM', NULL, 'B'
'13115', 'ducentum', 'N', '', 'AnP', 'd0328', 'ducentum', 'NUM', NULL, 'B'
'13174', 'duo', 'N2/1', '*', 'An-', 'd2327', 'duo', 'NUM', NULL, 'B'
'13186', 'duodecim', 'NY', '', 'AnP', 'd2338', 'duodecim', 'NUM', NULL, 'B'
'13193', 'duodenonaginta', 'N', '', 'AnP', 'd2347', 'duodenonaginta', 'NUM', NULL, 'B'
'13194', 'duodeoctoginta', 'N', '', 'AnP', 'd2348', 'duodeoctoginta', 'NUM', NULL, 'B'
'13197', 'duodequadraginta', 'N', '', 'AnP', 'd2351', 'duodequadraginta', 'NUM', NULL, 'B'
'13200', 'duodequinquaginta', 'N', '', 'AnP', 'd2354', 'duodequinquaginta', 'NUM', NULL, 'B'
'13202', 'duodesexaginta', 'N', '', 'AnP', 'd2356', 'duodesexaginta', 'NUM', NULL, 'B'
'13205', 'duodetriginta', 'N', '', 'AnP', 'd2359', 'duodetriginta', 'NUM', NULL, 'B'
'13208', 'duodeuiginti', 'N', '', 'AnP', 'd2362', 'duodeuiginti', 'NUM', NULL, 'B'
'13211', 'duouiginti', 'N', '', 'AnP', 'd2365', 'duouiginti', 'NUM', NULL, 'B'
'24829', 'mille', 'N', '', 'AnP', 'm0992', 'mille', 'NUM', NULL, 'B'
'24830', 'mille', 'N', '', 'NnP', 'm0992', 'mille', 'NUM', NULL, 'B'
'26315', 'nonaginta', 'N', '', 'AnP', 'n0516', 'nonaginta', 'NUM', NULL, 'B'
'26324', 'nongenti', 'N2/1', '*', 'An-', 'n0355', 'nongenti', 'NUM', NULL, 'B'
'26392', 'nouem', 'N', '', 'AnP', 'n9569', 'nouem', 'NUM', NULL, 'B'
'26393', 'nouemdecim', 'N', '', 'AnP', 'n0570', 'nouemdecim', 'NUM', NULL, 'B'
'27130', 'octingenti', 'N2/1', '*', 'An-', 'o0465', 'octingenti', 'NUM', NULL, 'B'
'27134', 'octo', 'N', '', 'AnP', 'o0469', 'octo', 'NUM', NULL, 'B'
'27137', 'octodecim', 'N', '', 'AnP', 'o0470', 'octodecim', 'NUM', NULL, 'B'
'27144', 'octoginta', 'N', '', 'AnP', 'o0477', 'octoginta', 'NUM', NULL, 'B'
'33225', 'quadraginta', 'N', '', 'AnP', 'q0011', 'quadraginta', 'NUM', NULL, 'B'
'33288', 'quadringenti', 'N2/1', '*', 'An-', 'q0062', 'quadringenti', 'NUM', NULL, 'B'
'33379', 'quarranta', 'N', '', 'AnP', 'q0140', 'quarranta', 'NUM', NULL, 'B'
'33412', 'quattuor', 'N', '', 'AnP', 'q0166', 'quattuor', 'NUM', NULL, 'B'
'33416', 'quattuordecim', 'N', '', 'AnP', 'q0170', 'quattuordecim', 'NUM', NULL, 'B'
'33477', 'quindecim', 'N', '', 'AnP', 'q9224', 'quindecim', 'NUM', NULL, 'B'
'33491', 'quingenti', 'N2/1', '*', 'An-', 'q0237', 'quingenti', 'NUM', NULL, 'B'
'33502', 'quinquaginta', 'N', '', 'AnP', 'q0248', 'quinquaginta', 'NUM', NULL, 'B'
'33505', 'quinque', 'N', '', 'AnP', 'q0251', 'quinque', 'NUM', NULL, 'B'
'36200', 'sedecim', 'N', '', 'AnP', 's0908', 'sedecim', 'NUM', NULL, 'B'
'36582', 'septem', 'N', '', 'AnP', 's1272', 'septem', 'NUM', NULL, 'B'
'36584', 'septemdecim', 'N', '', 'AnP', 's1274', 'septemdecim', 'NUM', NULL, 'B'
'36619', 'septingenti', 'N2/1', '*', 'An-', 's8309', 'septingenti', 'NUM', NULL, 'B'
'36630', 'septuaginta', 'N', '', 'AnP', 's1321', 'septuaginta', 'NUM', NULL, 'B'
'36769', 'sescenti', 'N2/1', '*', 'An-', 's1441', 'sescenti', 'NUM', NULL, 'B'
'36842', 'sex', 'N', '', 'AnP', 's1512', 'sex', 'NUM', NULL, 'B'
'36848', 'sexaginta', 'N', '', 'AnP', 's1518', 'sexaginta', 'NUM', NULL, 'B'
'40871', 'trecenti', 'N2/1', '*', 'An-', 't1135', 'trecenti', 'NUM', NULL, 'B'
'40877', 'tredecim', 'N', '', 'AnP', 't1140', 'tredecim', 'NUM', NULL, 'B'
'40896', 'tres/-is', 'N3A', '*', 'An-', 't1158', 'tres/-is', 'NUM', NULL, 'B'
'41027', 'triginta', 'N', '', 'AnP', 't1273', 'triginta', 'NUM', NULL, 'B'
'42269', 'uiginti', 'N', '', 'AnP', 'u0645', 'uiginti', 'NUM', NULL, 'B'
'42703', 'undecentum', 'N', '', 'AnP', 'u1032', 'undecentum', 'NUM', NULL, 'B'
'42706', 'undecim', 'N', '', 'AnP', 'u1036', 'undecim', 'NUM', NULL, 'B'
'42717', 'undenonaginta', 'N', '', 'AnP', 'u1046', 'undenonaginta', 'NUM', NULL, 'B'
'42718', 'undeoctoginta', 'N', '', 'AnP', 'u1047', 'undeoctoginta', 'NUM', NULL, 'B'
'42721', 'undequadraginta', 'N', '', 'AnP', 'u1050', 'undequadraginta', 'NUM', NULL, 'B'
'42723', 'undequinquaginta', 'N', '', 'AnP', 'u1052', 'undequinquaginta', 'NUM', NULL, 'B'
'42725', 'undesexaginta', 'N', '', 'AnP', 'u1054', 'undesexaginta', 'NUM', NULL, 'B'
'42728', 'undetriginta', 'N', '', 'AnP', 'u1057', 'undetriginta', 'NUM', NULL, 'B'
'42733', 'undeuiginti', 'N', '', 'AnP', 'u1061', 'undeuiginti', 'NUM', NULL, 'B'
'42820', 'unus', 'N2/1', '*', 'An-', 'u1136', 'unus', 'NUM', NULL, 'B'
'43352', 'milli', 'N', '', 'AnP', 'm0992', 'milli', 'NUM', NULL, 'B'
'43431', 'trecenti', 'N2/1', '*', 'AnP', 't1135', 'trecenti', 'NUM', NULL, 'B'

1st March 2019
Table 'lessario': added value 'v' in field 'clem' for row with pr_key= '62378'. It was missing and, thus, the fe 'uetera' was not lemmatized.

Table 'forme_ecc': changed the value of field 'c02' from 'f' to 'u' for rows with les_id='40159' or les_id='40160'. Exceptional forms of lemma 'omnis'
As a consequence -> table 'lemmario': removed row with id_lemma='27399'. It was lemma 'omnis' with codmorf='Af-' (an error)

Table 'lessario: added value '-is' in field 'lem' for rows with pr_key= '54640' and '11715'.
As a consequence -> table 'lemmario': corrected the value for the lemma field of rows of lemmas with id_lemma= '8205' and '36788'

17th June 2019
- c3218: replaced LE "catafract" with "catafractes" in tab_le
- c1528: added LE "chrysanthemon" in tab_le
- l0276: added "v" in field "clem" of les "liber"
- m1911: added LE "myron" in tab_le
- q0315: removed value "quotui" from field "lem" of row with pr_key='49494' in lessario table
- m0868: replaced lem "m''liarium" with "mi''liarium" in field "lem" of row with pr_key='36353'
- removed hyphen from the following LE in tab_le: agri-cultio (les_id='6309'), agri-cultor (6310), agri-cultura (6311), decem-uir (16017), expensi-latio (23382), iuris-dictio (32717), rati-habitatio (52383), usus-capio (63577), usus-receptio (63589)

27th June 2019
Table 'lessario': removed value '=' from column 'lem' of row with pr_key '155231'. The correct lemma is 'arco' and not 'arcon'

16th July 2019
Table 'lessario': fixed clem with n_id='d1276' (lemmas "diameter", "diametros/-us/"). Added masculine noun "diameter" masculine & separated from feminine noun "diametros/-us".
Table "lemmario": clem with n_id='c4579'. Added 'SCONJ' as upostag_2
Table 'lessario': 
- clem u0750, added codLE 3 and LE in tab_le to line 62732 (uyr) to block formation and analysis of nonexistent uyrus. FE is now superfluous.
- Gender changes: 
    c1222 n -> m
    c1428 m -> n
    c1435 n -> f
    c1449 n -> m
    c1468 2 -> n
    c1501 m -> n
    c1508 m -> n
    c1532 n -> f
    c1544 n -> m
    c1564 n -> m
    c1687 n -> m
    c1947 m -> n
    c1961 m -> n
    c2141 n -> f
    c4365 n -> m (on the basis of quotations, but remains doubtful if it rather is an adjective)
    o0230 1 -> 2
- clem changes: 
    t1486, tonitruus/tonitru: added a line for the neuter version tonitru, made tonitrus and tonitruus only masculine. Added tonitruus, tonitrui m. (Gaffiot). The lemma should be tonitrus as v.
    t0109, tapete/tapes: added tapes as only masculine, removed from tapete line, now only neuter. The lemma should rather be tapete/tapetum, with tapete as v
    g0210 genu/genus/genum: according to Georges, Gaffiot, OLD and L&S, made genu only n4 n., added genus,us m. and genum,i n., and added exceptional form genus in n/v/a n. (interpreted as 3rd declension, but isolated: we do not know the genitive form). The lemma should be genu as v.
    s1727 sinape/sinapis/... : changed so that -e are only n, -is are f. Consequently removed fe's. Lemma shouldonly be -i, n.
    d1276: fe for sub. diametros is superfluous, removed and created LE for it referring to line 18065. Added codLE 3 to diameter for technical purposes.
    d2213: completely restructured. fe dracontios removed as non-existent, added a f sub dracontios (not found in many sources, only as greekish adjective for vitis). Separated dracontium, dracontea, dracontia (lat), dracontion, dracontias (gr). This entry is actually a set of very different lemmas: it is now not represented as -on/-um/-os anymore. 
    h0192, helianthes: helianthidis is not attested, only a feminine form helianthis beside n helianthes in the sources. lem and LE corrected.
    p2206, added piius as pii-us (n6), according to Georges. In any case, this brings to forms like piiissimus.
- codles changes:
    l0136, lageos: n2 -> n2e 
    c4853, cypru/cypros: n2 -> n2e
    p1975, phthiropoeos: n2 -> n2e and addition of -us/-os with respective codLE
    s1435, sesimoides: n32 -> n3n2
    t1208, trichomanes: n32 -> n3n2
    u0487, uesper: n2e -> n2
    o0625, oleaster: n2e -> n2
    n9806, nescioqui & n9807, nescioquis: pr -> fe (and added codlem PR) - formal change, but technically and logically relevant
    DB534: v6d -> v61a Note: v6d is never used and f.e. gives the incorrect form postferr
    s1751 (sinistim-): n6 -> n6s Note: b wrong codLE, no codLE for superlatives; removed also from senesterior
    p2206: n6i -> n6 (pi-us vs ?p-ius vs ?pi-ius)
    D874G, laficus: n6 -> n2 (m)
    DBFB0, raficius: n6i -> n2i (m)
- exceptional forms:
    loca as n. pl. for locus, l0360
    Added interpretations as ablative, vocative, nominative, genitive and accusative of echo (e0085)
    36420 person 3 -> 1
   
24th July 2019
Table "tabLE"
- created lemma eccezionale "cichorion"
- changed lemma eccezionale "xybaphos" in "oxybaphus"

Table "lessario"
- n_id='h0952': les "hausc" changed in "haudsc"
- n_id='83791': les 'thesaurochrysonicochry' changed into 'thesaurochrysonicochrysid'
- n_id='D79D5': les 'honorificabilitudinita' changed into 'honorificabilitudinitat'
- IMPORTANT CHANGE: extended the length of column 'les' from 22 to 25 characters

25th July 2019
Table "lessario"
- fixed errors in CLEM with n_id='a3465'
- n_id='13561': changed vale of field 'lem' from "cimber" to "calaber" 

25th July 2019
Table "lessario"
- gen '2' -> '*'  (858 CASI)
- gen 'm' OR 'n' 'f' -> '' (5 CASI)
pr_key	n_id	OLD_gen	NEW_gen
89240	10142	2	*
89241	10168	2	*
89242	10169	2	*
89030	10241	2	*
89243	10244	2	*
89244	10248	2	*
89245	10275	2	*
89031	1032	2	*
89246	10342	2	*
89247	10344	2	*
89248	10362	2	*
89250	10506	2	*
89251	10516	2	*
89252	10545	2	*
89253	10547	2	*
89254	10554	2	*
89255	10556	2	*
89256	10562	2	*
89257	10620	2	*
89258	10628	2	*
89259	10693	2	*
89260	10755	2	*
89261	10781	2	*
89262	10867	2	*
89032	10884	2	*
89263	10887	2	*
89264	10895	2	*
89033	10907	2	*
89265	10914	2	*
89266	10993	2	*
89267	11054	2	*
89268	11171	2	*
89034	11201	2	*
89269	11379	2	*
89270	11430	2	*
89271	11560	2	*
89272	11610	2	*
89273	11636	2	*
89274	11683	2	*
89275	11699	2	*
89035	11782	2	*
89276	11840	2	*
89277	11934	2	*
89278	12003	2	*
89279	12159	2	*
89280	12339	2	*
89281	12342	2	*
89036	12400	2	*
89282	12420	2	*
89283	12436	2	*
89284	12449	2	*
89285	12450	2	*
89286	1246	2	*
89287	12475	2	*
89037	12483	2	*
89288	12508	2	*
89289	1254	2	*
89038	12572	2	*
89290	12661	2	*
89291	12714	2	*
89292	12728	2	*
89293	1288	2	*
89039	12912	2	*
89294	12960	2	*
89295	12998	2	*
89296	13129	2	*
89297	13162	2	*
89040	13171	2	*
89298	13172	2	*
89041	13181	2	*
89299	13289	2	*
89300	13363	2	*
89042	13413	2	*
89301	13416	2	*
89302	13448	2	*
89303	13476	2	*
89304	13582	2	*
89043	13629	2	*
89305	13667	2	*
89044	1369	2	*
89306	13962	2	*
89307	13995	2	*
89308	14036	2	*
89309	14450	2	*
89310	14533	2	*
89045	1457	2	*
89311	14697	2	*
89312	14704	2	*
89313	1474	2	*
89046	14796	2	*
89314	14822	2	*
89047	14907	2	*
89315	14955	2	*
89316	15178	2	*
89317	1519	2	*
89048	15242	2	*
89318	15367	2	*
89319	15533	2	*
89320	15548	2	*
89321	15854	2	*
89322	16036	2	*
89323	16259	2	*
89324	16266	2	*
89325	1653	2	*
89326	16543	2	*
89327	16615	2	*
89328	17171	2	*
89329	17202	2	*
89330	1726	2	*
89331	17262	2	*
89049	17621	2	*
89332	18441	2	*
89050	18479	2	*
89051	18561	2	*
89333	18601	2	*
89334	19110	2	*
89335	1976	2	*
89336	20611	2	*
89337	21150	2	*
89338	21175	2	*
89052	21201	2	*
89339	21205	2	*
89340	21253	2	*
89341	21409	2	*
89342	21775	2	*
89343	2185	2	*
89344	21946	2	*
89345	22359	2	*
89053	22498	2	*
89346	2274	2	*
89347	22839	2	*
89348	23153	2	*
89349	23170	2	*
89054	23464	2	*
89350	24466	2	*
89055	2486	2	*
89351	2487	2	*
89352	2494	2	*
89353	25039	2	*
89354	25073	2	*
89355	25229	2	*
89356	25278	2	*
89357	2542	2	*
89056	25612	2	*
89358	2583	2	*
89057	2588	2	*
89359	2606	2	*
89360	2619	2	*
89058	2623	2	*
89059	26482	2	*
89361	2656	2	*
89060	2663	2	*
89061	26774	2	*
89362	26775	2	*
89062	26918	2	*
89363	271	2	*
89364	27139	2	*
89365	2715	2	*
89063	27205	2	*
89366	27302	2	*
89367	2732	2	*
89368	2737	2	*
89369	27400	2	*
89370	27404	2	*
89371	27452	2	*
89064	2793	2	*
89372	28034	2	*
89065	28075	2	*
89066	2813	2	*
89067	2863	2	*
89373	2864	2	*
89374	28897	2	*
89068	29030	2	*
89375	29181	2	*
89376	29401	2	*
89377	29403	2	*
89378	29479	2	*
89069	29526	2	*
89070	29671	2	*
89379	29764	2	*
89380	299	2	*
89381	30279	2	*
89382	30341	2	*
89383	3065	2	*
89071	3102	2	*
89072	3105	2	*
89073	3189	2	*
89384	3190	2	*
89385	3205	2	*
89386	32169	2	*
89387	32199	2	*
89388	32477	2	*
89389	32481	2	*
89390	32573	2	*
89074	32756	2	*
89075	32770	2	*
89391	32818	2	*
89076	32969	2	*
89392	32980	2	*
89393	32988	2	*
89394	32998	2	*
89077	33017	2	*
89395	33079	2	*
89396	33126	2	*
89078	33377	2	*
89397	33399	2	*
89398	3343	2	*
89079	33566	2	*
89399	33767	2	*
89080	33907	2	*
89400	33908	2	*
89401	33909	2	*
89402	33911	2	*
89403	33912	2	*
89404	33913	2	*
89081	33918	2	*
89082	33919	2	*
89083	33920	2	*
89084	33933	2	*
89085	34093	2	*
89405	34154	2	*
89406	3430	2	*
89407	3458	2	*
89408	34743	2	*
89086	34967	2	*
89087	35127	2	*
89409	35238	2	*
89410	35264	2	*
89411	35314	2	*
89412	35366	2	*
89413	35491	2	*
89414	35566	2	*
89415	35575	2	*
89416	35628	2	*
89417	35648	2	*
89418	35739	2	*
89419	35783	2	*
89420	35785	2	*
89421	35792	2	*
89422	35808	2	*
89423	35911	2	*
89424	36106	2	*
89425	36238	2	*
89426	36260	2	*
89427	36372	2	*
89428	36474	2	*
89429	3654	2	*
89430	3655	2	*
89431	36637	2	*
89432	36646	2	*
89433	36651	2	*
89434	36718	2	*
89088	36958	2	*
89435	36964	2	*
89436	36968	2	*
89437	37242	2	*
89089	3748	2	*
89438	3753	2	*
89439	3755	2	*
89440	37625	2	*
89441	37639	2	*
89090	37681	2	*
89091	37698	2	*
89442	37708	2	*
89092	3777	2	*
89093	3789	2	*
89443	3790	2	*
89094	38085	2	*
89095	38095	2	*
89444	38275	2	*
89445	38373	2	*
89096	38394	2	*
89446	3851	2	*
89097	3860	2	*
89098	38691	2	*
89447	38728	2	*
89448	38877	2	*
89099	38895	2	*
89449	3891	2	*
89100	39303	2	*
89450	3934	2	*
89451	3937	2	*
89101	39386	2	*
89452	39456	2	*
89453	39467	2	*
89102	39508	2	*
89103	3951	2	*
89454	3953	2	*
89104	39542	2	*
89455	39544	2	*
89105	39546	2	*
89456	39554	2	*
89106	39652	2	*
89107	39673	2	*
89108	39677	2	*
89457	39678	2	*
89109	39682	2	*
89458	39687	2	*
89110	39694	2	*
89459	3979	2	*
89111	3980	2	*
89460	3982	2	*
89112	39831	2	*
89461	39864	2	*
89462	3988	2	*
89463	39905	2	*
89464	3991	2	*
89465	39910	2	*
89466	39911	2	*
89113	39913	2	*
89467	39919	2	*
89468	4015	2	*
89469	4027	2	*
89470	4070	2	*
89471	408	2	*
89114	409	2	*
89115	41685	2	*
89116	41745	2	*
89472	4223	2	*
89473	4260	2	*
89474	4296	2	*
89475	4297	2	*
89476	43175	2	*
89117	43176	2	*
89477	43177	2	*
89478	43205	2	*
89479	4348	2	*
89480	4351	2	*
89118	43756	2	*
89481	44021	2	*
89482	44029	2	*
89483	44046	2	*
89484	44048	2	*
89485	44050	2	*
89486	44053	2	*
89119	44098	2	*
89120	44278	2	*
89121	44299	2	*
89122	44339	2	*
89487	44375	2	*
89123	44388	2	*
89488	4442	2	*
89489	44470	2	*
89490	44523	2	*
89491	44618	2	*
89492	44620	2	*
89493	44621	2	*
89494	44633	2	*
89495	44761	2	*
89124	44880	2	*
89496	44884	2	*
89497	44955	2	*
89498	45034	2	*
89125	45040	2	*
89499	45050	2	*
89126	45236	2	*
89127	45239	2	*
89128	45251	2	*
89129	45314	2	*
89500	4539	2	*
89130	45471	2	*
89501	45533	2	*
89502	45541	2	*
89503	45558	2	*
89131	45576	2	*
89504	45577	2	*
89505	45641	2	*
89132	45684	2	*
89506	4570	2	*
89507	45783	2	*
89508	45872	2	*
89509	45898	2	*
89510	4592	2	*
89133	45949	2	*
89511	46	2	*
89134	46030	2	*
89512	46045	2	*
89513	46054	2	*
89514	46079	2	*
89515	46082	2	*
89516	46094	2	*
89517	46136	2	*
89518	46211	2	*
89519	46225	2	*
89520	46246	2	*
89135	46255	2	*
89521	46264	2	*
89522	46272	2	*
89523	46306	2	*
89524	46316	2	*
89136	4639	2	*
89525	46426	2	*
89526	46450	2	*
89137	46459	2	*
89527	46515	2	*
89528	46516	2	*
89529	4657	2	*
89530	4658	2	*
89138	46581	2	*
89139	46670	2	*
89531	46718	2	*
89532	46719	2	*
89533	46974	2	*
89534	47021	2	*
89535	47069	2	*
89536	47081	2	*
89140	47135	2	*
89141	4723	2	*
89537	47300	2	*
89538	47333	2	*
89539	47395	2	*
89142	47419	2	*
89540	47488	2	*
89541	47585	2	*
89542	4761	2	*
89143	47708	2	*
89543	47735	2	*
89544	47737	2	*
89545	47738	2	*
89546	47841	2	*
89144	4794	2	*
89145	47993	2	*
89146	48010	2	*
89147	48049	2	*
89547	48050	2	*
89148	48051	2	*
89548	48120	2	*
89549	48141	2	*
89550	48252	2	*
89551	48306	2	*
89552	48340	2	*
89553	48690	2	*
89554	48781	2	*
89555	48886	2	*
89556	48892	2	*
89557	48897	2	*
89558	48963	2	*
89149	48979	2	*
89559	4905	2	*
89150	49178	2	*
89560	4918	2	*
89561	49184	2	*
89562	49280	2	*
89563	49418	2	*
89564	4943	2	*
89565	49458	2	*
89566	49559	2	*
89567	49563	2	*
89151	49768	2	*
89152	49857	2	*
89568	49936	2	*
89569	50016	2	*
89570	5008	2	*
89153	50171	2	*
89571	50198	2	*
89572	5022	2	*
89573	50220	2	*
89154	50318	2	*
89574	50369	2	*
89155	50372	2	*
89575	50433	2	*
89576	5057	2	*
89156	50653	2	*
89577	50768	2	*
89157	50811	2	*
89578	50866	2	*
89579	50889	2	*
89580	50911	2	*
89158	51013	2	*
89581	51087	2	*
89582	51089	2	*
89583	51094	2	*
89159	5134	2	*
89160	51544	2	*
89584	5160	2	*
89585	51692	2	*
89586	51777	2	*
89587	51789	2	*
89588	51818	2	*
89589	5189	2	*
89590	51909	2	*
89591	51911	2	*
89161	51965	2	*
89162	5197	2	*
89592	52011	2	*
89593	5206	2	*
89594	5216	2	*
89595	52223	2	*
89163	52363	2	*
89596	52626	2	*
89597	5274	2	*
89164	52757	2	*
89598	52935	2	*
89165	5326	2	*
89166	53478	2	*
89599	53487	2	*
89600	53569	2	*
89601	53776	2	*
89602	53781	2	*
89167	53809	2	*
89603	53965	2	*
89168	5397	2	*
89604	54033	2	*
89605	54070	2	*
89606	54114	2	*
89607	54124	2	*
89608	54162	2	*
89609	54179	2	*
89610	5425	2	*
89611	54276	2	*
89612	54409	2	*
89169	54661	2	*
89613	54665	2	*
89614	54681	2	*
89615	54696	2	*
89616	5476	2	*
89617	54787	2	*
89618	54837	2	*
89619	54854	2	*
89170	54865	2	*
89620	54870	2	*
89171	54979	2	*
89621	55026	2	*
89622	55063	2	*
89623	55067	2	*
89172	55083	2	*
89624	5515	2	*
89625	55578	2	*
89173	55614	2	*
89626	55650	2	*
89174	55828	2	*
89627	55932	2	*
89175	56845	2	*
89628	56941	2	*
89176	57083	2	*
89629	57118	2	*
89177	57306	2	*
89630	57309	2	*
89631	57317	2	*
89178	57321	2	*
89632	57344	2	*
89633	57412	2	*
89634	57429	2	*
89635	5761	2	*
89636	5769	2	*
89637	57717	2	*
89638	57921	2	*
89639	57937	2	*
89640	58340	2	*
89179	58388	2	*
89180	58485	2	*
89641	5851	2	*
89642	58521	2	*
89643	58649	2	*
89644	58682	2	*
89645	5878	2	*
89646	5882	2	*
89647	58909	2	*
89648	5892	2	*
89649	5895	2	*
89650	5901	2	*
89651	59144	2	*
89652	59189	2	*
89181	59207	2	*
89653	59223	2	*
89182	59232	2	*
89654	59271	2	*
89183	59361	2	*
89184	59613	2	*
89185	59622	2	*
89655	59640	2	*
89656	5983	2	*
89657	5994	2	*
89658	59972	2	*
89659	60049	2	*
89660	60467	2	*
89661	6061	2	*
89662	60673	2	*
89663	60781	2	*
89664	60782	2	*
89665	60827	2	*
89666	6136	2	*
89667	6139	2	*
89668	61524	2	*
89669	6197	2	*
89670	6205	2	*
89672	62615	2	*
89673	628	2	*
89674	62984	2	*
89186	63042	2	*
89675	63160	2	*
89676	634	2	*
89677	63430	2	*
89187	63597	2	*
89678	63688	2	*
89679	63691	2	*
89680	63771	2	*
89681	63774	2	*
89682	63939	2	*
89683	63988	2	*
89188	64082	2	*
89684	64357	2	*
89685	64379	2	*
89686	64611	2	*
89687	64626	2	*
89688	64767	2	*
89689	64820	2	*
89690	64905	2	*
89691	64910	2	*
89189	6567	2	*
89190	6574	2	*
89692	6584	2	*
89693	6607	2	*
89694	6622	2	*
89695	6631	2	*
89696	66400	2	*
89697	6661	2	*
89698	6663	2	*
89699	6669	2	*
89700	667	2	*
89701	6757	2	*
89702	67660	2	*
89703	67819	2	*
89704	68082	2	*
89191	6835	2	*
89705	68355	2	*
89192	6839	2	*
89706	6857	2	*
89707	6859	2	*
89708	68852	2	*
89709	68979	2	*
89710	69004	2	*
89711	69431	2	*
89712	6968	2	*
89713	70030	2	*
89714	70038	2	*
89715	70051	2	*
89716	70128	2	*
89717	7092	2	*
89718	7095	2	*
90842	7096	2	*
89193	7120	2	*
89194	7122	2	*
89719	7123	2	*
89195	71301	2	*
89720	71304	2	*
89721	71382	2	*
89722	7144	2	*
89723	71620	2	*
89724	71640	2	*
89725	71642	2	*
89726	71790	2	*
89727	71806	2	*
89728	71878	2	*
89729	71937	2	*
89730	72186	2	*
89731	72197	2	*
89732	72202	2	*
89733	72541	2	*
89734	72581	2	*
89735	72614	2	*
89736	72668	2	*
89737	72689	2	*
89738	72802	2	*
89196	72902	2	*
89197	72934	2	*
89739	73031	2	*
89740	73071	2	*
89741	73074	2	*
89198	73089	2	*
89742	73239	2	*
89743	73253	2	*
89745	73493	2	*
89746	73784	2	*
89747	7386	2	*
89748	7448	2	*
89749	7457	2	*
89750	74631	2	*
89199	74643	2	*
89200	74647	2	*
89201	74648	2	*
89202	74667	2	*
89751	7467	2	*
89752	74674	2	*
89203	74684	2	*
89753	74746	2	*
89754	74749	2	*
89204	7475	2	*
89755	7516	2	*
89756	75181	2	*
89757	7520	2	*
89758	75209	2	*
89759	7548	2	*
89760	755	2	*
89205	7550	2	*
89761	7567	2	*
89762	7577	2	*
89763	76106	2	*
89764	7612	2	*
89765	76150	2	*
89766	76294	2	*
89206	7634	2	*
89767	76443	2	*
89207	7663	2	*
89768	76641	2	*
89769	76699	2	*
89770	76749	2	*
89771	76776	2	*
89208	76792	2	*
89772	76840	2	*
89773	77045	2	*
89774	77186	2	*
89775	77783	2	*
89776	78191	2	*
89777	78290	2	*
89778	78293	2	*
89779	7836	2	*
89209	7863	2	*
89780	78708	2	*
89781	78932	2	*
89782	79330	2	*
89783	79435	2	*
89784	8006	2	*
89785	80264	2	*
89786	80276	2	*
89787	80376	2	*
89788	80519	2	*
89789	80542	2	*
89790	8077	2	*
89791	8103	2	*
89792	81168	2	*
89793	81420	2	*
89794	8145	2	*
89795	81597	2	*
89796	82018	2	*
89797	82085	2	*
89798	82089	2	*
89210	82108	2	*
89799	8217	2	*
89800	82367	2	*
89801	82375	2	*
89802	82377	2	*
89211	82414	2	*
89803	82444	2	*
89804	82459	2	*
89805	82489	2	*
89806	82556	2	*
89807	82623	2	*
89808	82720	2	*
89809	82901	2	*
89810	83080	2	*
89212	8337	2	*
89811	83413	2	*
89812	83460	2	*
89813	83471	2	*
89213	8354	2	*
89214	8371	2	*
89814	8372	2	*
89815	83755	2	*
89816	83814	2	*
89817	83825	2	*
89818	83841	2	*
89819	83843	2	*
89820	83866	2	*
89821	83871	2	*
89822	83879	2	*
89215	8397	2	*
89216	8398	2	*
89823	83996	2	*
89824	84083	2	*
89825	84145	2	*
89826	84166	2	*
89827	84181	2	*
89828	84254	2	*
89829	84282	2	*
89217	843	2	*
89830	84326	2	*
89831	84367	2	*
89832	84368	2	*
89833	84390	2	*
89834	84392	2	*
89835	84492	2	*
89218	84505	2	*
89836	84525	2	*
89837	84582	2	*
89838	84660	2	*
89839	84954	2	*
89219	84974	2	*
89840	85027	2	*
89220	85241	2	*
89221	85373	2	*
89841	8556	2	*
89842	8562	2	*
89843	85952	2	*
89844	86234	2	*
89845	86270	2	*
89846	86453	2	*
89847	86456	2	*
89848	86536	2	*
89849	86543	2	*
89222	86652	2	*
89850	86654	2	*
89223	86883	2	*
89851	86903	2	*
89852	87270	2	*
89224	87393	2	*
89225	87408	2	*
89226	87426	2	*
89227	87447	2	*
89853	87558	2	*
89854	87629	2	*
89855	87650	2	*
89856	87712	2	*
89857	87760	2	*
89228	87811	2	*
89229	87851	2	*
89858	88219	2	*
89859	88231	2	*
89230	88264	2	*
89231	88279	2	*
89860	8838	2	*
89232	8844	2	*
89233	88451	2	*
89234	88463	2	*
89861	88622	2	*
89235	88635	2	*
89863	88773	2	*
89864	8899	2	*
89865	89014	2	*
89866	89135	2	*
89867	89143	2	*
89236	89201	2	*
89868	89222	2	*
89869	89267	2	*
89870	89505	2	*
89871	89743	2	*
89872	90077	2	*
89873	90181	2	*
89874	90210	2	*
89875	90249	2	*
89237	90382	2	*
89238	90383	2	*
89876	90437	2	*
89877	90501	2	*
89878	90676	2	*
89879	90699	2	*
89880	9475	2	*
89881	9478	2	*
89882	9506	2	*
89239	9568	2	*
89883	9587	2	*
89884	9597	2	*
89885	9645	2	*
89886	9701	2	*
89887	9761	2	*
89888	9806	2	*
89889	9820	2	*
89890	9954	2	*
164828	D5890	m	
164830	D9CEA	m	
165196	DB4B4	m	
165211	DC253	m	
164821	DD77G	m	

25th July 2019
Table "lemmario"
- gen '2' -> '*'  (858 CASI)
- gen 'm' OR 'n' 'f' -> '' (5 CASI)
id_lemma	n_id	OLD_gen	NEW_gen
48418	10142	2	*
48433	10168	2	*
48434	10169	2	*
48491	10241	2	*
48494	10244	2	*
48498	10248	2	*
48507	10275	2	*
44252	1032	2	*
48522	10342	2	*
48524	10344	2	*
48535	10362	2	*
48609	10506	2	*
48332	10516	2	*
48370	10545	2	*
48372	10547	2	*
48375	10554	2	*
48377	10556	2	*
48382	10562	2	*
48458	10620	2	*
48485	10628	2	*
48630	10693	2	*
48678	10755	2	*
48686	10781	2	*
48735	10867	2	*
48744	10884	2	*
48747	10887	2	*
48756	10895	2	*
48764	10907	2	*
48770	10914	2	*
48816	10993	2	*
48831	11054	2	*
48886	11171	2	*
48904	11201	2	*
49012	11379	2	*
49038	11430	2	*
49110	11560	2	*
49119	11610	2	*
49132	11636	2	*
49172	11683	2	*
49185	11699	2	*
49237	11782	2	*
49248	11840	2	*
49270	11934	2	*
49289	12003	2	*
49350	12159	2	*
49461	12339	2	*
49464	12342	2	*
49497	12400	2	*
49508	12420	2	*
49522	12436	2	*
49527	12449	2	*
49528	12450	2	*
44413	1246	2	*
49538	12475	2	*
49543	12483	2	*
49558	12508	2	*
44421	1254	2	*
49580	12572	2	*
49625	12661	2	*
49673	12714	2	*
49681	12728	2	*
44443	1288	2	*
49772	12912	2	*
49793	12960	2	*
49813	12998	2	*
49890	13129	2	*
49908	13162	2	*
49916	13171	2	*
49917	13172	2	*
49925	13181	2	*
49956	13289	2	*
49997	13363	2	*
50019	13413	2	*
50022	13416	2	*
50043	13448	2	*
50056	13476	2	*
50120	13582	2	*
50141	13629	2	*
50149	13667	2	*
44486	1369	2	*
50266	13962	2	*
50280	13995	2	*
50296	14036	2	*
50392	14450	2	*
50404	14533	2	*
44527	1457	2	*
50464	14697	2	*
50466	14704	2	*
44542	1474	2	*
50499	14796	2	*
50514	14822	2	*
50553	14907	2	*
50574	14955	2	*
50613	15178	2	*
44553	1519	2	*
50635	15242	2	*
50644	15367	2	*
50726	15533	2	*
50737	15548	2	*
50837	15854	2	*
50898	16036	2	*
50997	16259	2	*
51002	16266	2	*
44616	1653	2	*
51109	16543	2	*
51132	16615	2	*
51209	17171	2	*
51224	17202	2	*
44640	1726	2	*
51244	17262	2	*
51376	17621	2	*
51516	18441	2	*
51530	18479	2	*
51552	18561	2	*
51564	18601	2	*
51591	19110	2	*
44704	1976	2	*
51666	20611	2	*
51718	21150	2	*
51730	21175	2	*
51747	21201	2	*
51751	21205	2	*
51766	21253	2	*
51798	21409	2	*
51909	21775	2	*
44741	2185	2	*
51962	21946	2	*
52027	22359	2	*
52070	22498	2	*
44778	2274	2	*
52244	22839	2	*
52377	23153	2	*
52380	23170	2	*
52407	23464	2	*
52523	24466	2	*
44836	2486	2	*
44837	2487	2	*
44844	2494	2	*
52574	25039	2	*
52579	25073	2	*
52606	25229	2	*
52623	25278	2	*
44855	2542	2	*
52669	25612	2	*
44895	2583	2	*
44899	2588	2	*
44916	2606	2	*
44925	2619	2	*
44929	2623	2	*
52772	26482	2	*
44952	2656	2	*
44956	2663	2	*
52868	26774	2	*
52869	26775	2	*
52948	26918	2	*
43967	271	2	*
53022	27139	2	*
44990	2715	2	*
53029	27205	2	*
53061	27302	2	*
45004	2732	2	*
45009	2737	2	*
53093	27400	2	*
53095	27404	2	*
53115	27452	2	*
45046	2793	2	*
53252	28034	2	*
53272	28075	2	*
45057	2813	2	*
45086	2863	2	*
45087	2864	2	*
53469	28897	2	*
53502	29030	2	*
53569	29181	2	*
53641	29401	2	*
53643	29403	2	*
53667	29479	2	*
53693	29526	2	*
53764	29671	2	*
53783	29764	2	*
43993	299	2	*
54096	30279	2	*
54135	30341	2	*
45156	3065	2	*
45169	3102	2	*
45172	3105	2	*
45223	3189	2	*
45224	3190	2	*
45233	3205	2	*
54334	32169	2	*
54345	32199	2	*
54397	32477	2	*
54398	32481	2	*
54419	32573	2	*
54468	32756	2	*
54473	32770	2	*
54489	32818	2	*
54524	32969	2	*
54528	32980	2	*
54531	32988	2	*
54536	32998	2	*
54541	33017	2	*
54552	33079	2	*
54562	33126	2	*
54610	33377	2	*
54616	33399	2	*
45251	3343	2	*
54652	33566	2	*
54681	33767	2	*
54701	33907	2	*
54702	33908	2	*
54703	33909	2	*
54705	33911	2	*
54706	33912	2	*
54707	33913	2	*
54711	33918	2	*
54712	33919	2	*
54713	33920	2	*
54715	33933	2	*
54744	34093	2	*
54761	34154	2	*
45319	3430	2	*
45339	3458	2	*
54837	34743	2	*
54958	34967	2	*
55037	35127	2	*
55087	35238	2	*
55103	35264	2	*
55135	35314	2	*
55145	35366	2	*
55177	35491	2	*
55218	35566	2	*
55223	35575	2	*
55245	35628	2	*
55258	35648	2	*
55299	35739	2	*
55323	35783	2	*
55325	35785	2	*
55327	35792	2	*
55338	35808	2	*
55353	35911	2	*
55410	36106	2	*
55488	36238	2	*
55500	36260	2	*
55522	36372	2	*
55542	36474	2	*
45406	3654	2	*
45407	3655	2	*
55615	36637	2	*
55617	36646	2	*
55622	36651	2	*
55650	36718	2	*
55761	36958	2	*
55766	36964	2	*
55770	36968	2	*
55896	37242	2	*
45444	3748	2	*
45449	3753	2	*
45451	3755	2	*
56092	37625	2	*
56106	37639	2	*
56124	37681	2	*
56129	37698	2	*
56134	37708	2	*
45467	3777	2	*
45479	3789	2	*
45480	3790	2	*
56355	38085	2	*
56359	38095	2	*
56456	38275	2	*
56499	38373	2	*
56513	38394	2	*
45511	3851	2	*
45519	3860	2	*
56584	38691	2	*
56596	38728	2	*
56640	38877	2	*
56652	38895	2	*
45538	3891	2	*
56880	39303	2	*
45564	3934	2	*
45567	3937	2	*
56941	39386	2	*
56976	39456	2	*
56983	39467	2	*
56998	39508	2	*
45572	3951	2	*
45573	3953	2	*
57038	39542	2	*
57039	39544	2	*
57045	39546	2	*
57057	39554	2	*
57078	39652	2	*
57092	39673	2	*
57095	39677	2	*
57096	39678	2	*
57098	39682	2	*
57102	39687	2	*
57109	39694	2	*
45583	3979	2	*
45584	3980	2	*
45585	3982	2	*
57121	39831	2	*
57123	39864	2	*
45591	3988	2	*
57139	39905	2	*
45594	3991	2	*
57141	39910	2	*
57142	39911	2	*
57144	39913	2	*
57147	39919	2	*
45608	4015	2	*
45615	4027	2	*
45645	4070	2	*
44015	408	2	*
44016	409	2	*
57221	41685	2	*
57225	41745	2	*
45764	4223	2	*
45777	4260	2	*
45789	4296	2	*
45790	4297	2	*
57276	43175	2	*
57277	43176	2	*
57278	43177	2	*
57282	43205	2	*
45797	4348	2	*
45799	4351	2	*
57302	43756	2	*
57395	44021	2	*
57402	44029	2	*
57419	44046	2	*
57421	44048	2	*
57423	44050	2	*
57426	44053	2	*
57446	44098	2	*
57465	44278	2	*
57483	44299	2	*
57508	44339	2	*
57531	44375	2	*
57543	44388	2	*
45814	4442	2	*
57594	44470	2	*
57618	44523	2	*
56821	44618	2	*
56824	44620	2	*
56825	44621	2	*
56837	44633	2	*
57386	44761	2	*
57644	44880	2	*
57648	44884	2	*
57675	44955	2	*
57694	45034	2	*
57696	45040	2	*
57702	45050	2	*
57779	45236	2	*
57780	45239	2	*
57787	45251	2	*
57799	45314	2	*
45850	4539	2	*
57858	45471	2	*
57897	45533	2	*
57903	45541	2	*
57911	45558	2	*
57914	45576	2	*
57915	45577	2	*
57955	45641	2	*
57967	45684	2	*
45872	4570	2	*
57990	45783	2	*
58027	45872	2	*
58040	45898	2	*
45882	4592	2	*
58062	45949	2	*
43833	46	2	*
58100	46030	2	*
58102	46045	2	*
58105	46054	2	*
58113	46079	2	*
58114	46082	2	*
58117	46094	2	*
58135	46136	2	*
58163	46211	2	*
58186	46225	2	*
58199	46246	2	*
58204	46255	2	*
58209	46264	2	*
58215	46272	2	*
58171	46306	2	*
58182	46316	2	*
45889	4639	2	*
58272	46426	2	*
58279	46450	2	*
58282	46459	2	*
58306	46515	2	*
58307	46516	2	*
45894	4657	2	*
45895	4658	2	*
58330	46581	2	*
58381	46670	2	*
58405	46718	2	*
58406	46719	2	*
58526	46974	2	*
58540	47021	2	*
58559	47069	2	*
58568	47081	2	*
58588	47135	2	*
45911	4723	2	*
58672	47300	2	*
58684	47333	2	*
58705	47395	2	*
58712	47419	2	*
58722	47488	2	*
58761	47585	2	*
45929	4761	2	*
58797	47708	2	*
58805	47735	2	*
58807	47737	2	*
58808	47738	2	*
58832	47841	2	*
45957	4794	2	*
58897	47993	2	*
58906	48010	2	*
58927	48049	2	*
58928	48050	2	*
58929	48051	2	*
58964	48120	2	*
58972	48141	2	*
58999	48252	2	*
59019	48306	2	*
59035	48340	2	*
59223	48690	2	*
59297	48781	2	*
59348	48886	2	*
59353	48892	2	*
59357	48897	2	*
59390	48963	2	*
59398	48979	2	*
46024	4905	2	*
59524	49178	2	*
46035	4918	2	*
59526	49184	2	*
59577	49280	2	*
59627	49418	2	*
46043	4943	2	*
59637	49458	2	*
59704	49559	2	*
59707	49563	2	*
59795	49768	2	*
59825	49857	2	*
59842	49936	2	*
59897	50016	2	*
46070	5008	2	*
59986	50171	2	*
60009	50198	2	*
46079	5022	2	*
60027	50220	2	*
60091	50318	2	*
60129	50369	2	*
60132	50372	2	*
60159	50433	2	*
46090	5057	2	*
60270	50653	2	*
60311	50768	2	*
60325	50811	2	*
60363	50866	2	*
60381	50889	2	*
60402	50911	2	*
60467	51013	2	*
60504	51087	2	*
60505	51089	2	*
60509	51094	2	*
46124	5134	2	*
60702	51544	2	*
46131	5160	2	*
60768	51692	2	*
60809	51777	2	*
60817	51789	2	*
60837	51818	2	*
46155	5189	2	*
60882	51909	2	*
60884	51911	2	*
60912	51965	2	*
46163	5197	2	*
60941	52011	2	*
46169	5206	2	*
46178	5216	2	*
61011	52223	2	*
61041	52363	2	*
61143	52626	2	*
46211	5274	2	*
61178	52757	2	*
61201	52935	2	*
46235	5326	2	*
61322	53478	2	*
61323	53487	2	*
61348	53569	2	*
61406	53776	2	*
61409	53781	2	*
61430	53809	2	*
61495	53965	2	*
46280	5397	2	*
61537	54033	2	*
61564	54070	2	*
61589	54114	2	*
61596	54124	2	*
61609	54162	2	*
61614	54179	2	*
46297	5425	2	*
61650	54276	2	*
61661	54409	2	*
61791	54661	2	*
61794	54665	2	*
61807	54681	2	*
61816	54696	2	*
46312	5476	2	*
61862	54787	2	*
61883	54837	2	*
61895	54854	2	*
61906	54865	2	*
61920	54870	2	*
61960	54979	2	*
61995	55026	2	*
62026	55063	2	*
62030	55067	2	*
62040	55083	2	*
46333	5515	2	*
62195	55578	2	*
62203	55614	2	*
62219	55650	2	*
62261	55828	2	*
62280	55932	2	*
62381	56845	2	*
62416	56941	2	*
62463	57083	2	*
62491	57118	2	*
62559	57306	2	*
62562	57309	2	*
62568	57317	2	*
62572	57321	2	*
62580	57344	2	*
62600	57412	2	*
62605	57429	2	*
46443	5761	2	*
46442	5769	2	*
62725	57717	2	*
62788	57921	2	*
62792	57937	2	*
62929	58340	2	*
62951	58388	2	*
63006	58485	2	*
46504	5851	2	*
63026	58521	2	*
63066	58649	2	*
63077	58682	2	*
46516	5878	2	*
46519	5882	2	*
63181	58909	2	*
46526	5892	2	*
46529	5895	2	*
46535	5901	2	*
63284	59144	2	*
63303	59189	2	*
63308	59207	2	*
63318	59223	2	*
63321	59232	2	*
63346	59271	2	*
63367	59361	2	*
63470	59613	2	*
63477	59622	2	*
63487	59640	2	*
46603	5983	2	*
46609	5994	2	*
63580	59972	2	*
63617	60049	2	*
63748	60467	2	*
46639	6061	2	*
63769	60673	2	*
63820	60781	2	*
63821	60782	2	*
63830	60827	2	*
46659	6136	2	*
46662	6139	2	*
63908	61524	2	*
46676	6197	2	*
46679	6205	2	*
64027	62615	2	*
44087	628	2	*
64272	62984	2	*
64319	63042	2	*
64389	63160	2	*
44093	634	2	*
64535	63430	2	*
64585	63597	2	*
64617	63688	2	*
64618	63691	2	*
64644	63771	2	*
64646	63774	2	*
64694	63939	2	*
64701	63988	2	*
64727	64082	2	*
64802	64357	2	*
64818	64379	2	*
64909	64611	2	*
64913	64626	2	*
64950	64767	2	*
64958	64820	2	*
64972	64905	2	*
64974	64910	2	*
46774	6567	2	*
46781	6574	2	*
46786	6584	2	*
46796	6607	2	*
46803	6622	2	*
46811	6631	2	*
65064	66400	2	*
46832	6661	2	*
46834	6663	2	*
46840	6669	2	*
44109	667	2	*
46875	6757	2	*
65174	67660	2	*
65206	67819	2	*
65236	68082	2	*
46920	6835	2	*
65284	68355	2	*
46924	6839	2	*
46936	6857	2	*
46938	6859	2	*
65352	68852	2	*
65360	68979	2	*
65368	69004	2	*
65471	69431	2	*
46997	6968	2	*
65507	70030	2	*
65509	70038	2	*
65515	70051	2	*
65523	70128	2	*
47036	7092	2	*
47039	7095	2	*
47040	7096	2	*
47064	7120	2	*
47066	7122	2	*
47067	7123	2	*
65611	71301	2	*
65614	71304	2	*
65652	71382	2	*
47079	7144	2	*
65710	71620	2	*
65727	71640	2	*
65729	71642	2	*
65770	71790	2	*
65774	71806	2	*
65791	71878	2	*
65810	71937	2	*
65890	72186	2	*
65899	72197	2	*
65904	72202	2	*
65988	72541	2	*
66009	72581	2	*
66017	72614	2	*
66039	72668	2	*
66055	72689	2	*
66083	72802	2	*
66117	72902	2	*
66139	72934	2	*
66163	73031	2	*
66171	73071	2	*
66174	73074	2	*
66183	73089	2	*
66234	73239	2	*
66242	73253	2	*
66326	73493	2	*
66400	73784	2	*
47118	7386	2	*
47146	7448	2	*
47150	7457	2	*
66540	74631	2	*
66545	74643	2	*
66549	74647	2	*
66550	74648	2	*
66555	74667	2	*
47157	7467	2	*
66562	74674	2	*
66572	74684	2	*
66592	74746	2	*
66595	74749	2	*
47163	7475	2	*
47179	7516	2	*
66645	75181	2	*
47180	7520	2	*
66654	75209	2	*
47184	7548	2	*
44168	755	2	*
47186	7550	2	*
47193	7567	2	*
47198	7577	2	*
66830	76106	2	*
47215	7612	2	*
66844	76150	2	*
66890	76294	2	*
47229	7634	2	*
66929	76443	2	*
47252	7663	2	*
66981	76641	2	*
66995	76699	2	*
67014	76749	2	*
67025	76776	2	*
67034	76792	2	*
67047	76840	2	*
67087	77045	2	*
67107	77186	2	*
67252	77783	2	*
67302	78191	2	*
67310	78290	2	*
67313	78293	2	*
47354	7836	2	*
47363	7863	2	*
67395	78708	2	*
67418	78932	2	*
67447	79330	2	*
67449	79435	2	*
47415	8006	2	*
67467	80264	2	*
67471	80276	2	*
67505	80376	2	*
67520	80519	2	*
67529	80542	2	*
47440	8077	2	*
47456	8103	2	*
67555	81168	2	*
67571	81420	2	*
47475	8145	2	*
67586	81597	2	*
67683	82018	2	*
67704	82085	2	*
67706	82089	2	*
67718	82108	2	*
47525	8217	2	*
67820	82367	2	*
67828	82375	2	*
67830	82377	2	*
67858	82414	2	*
67872	82444	2	*
67883	82459	2	*
67897	82489	2	*
67920	82556	2	*
67941	82623	2	*
67984	82720	2	*
68026	82901	2	*
68060	83080	2	*
47588	8337	2	*
68101	83413	2	*
68122	83460	2	*
68132	83471	2	*
47599	8354	2	*
47609	8371	2	*
47610	8372	2	*
68289	83755	2	*
68318	83814	2	*
68329	83825	2	*
68340	83841	2	*
68342	83843	2	*
68352	83866	2	*
68355	83871	2	*
68358	83879	2	*
47625	8397	2	*
47626	8398	2	*
68417	83996	2	*
68462	84083	2	*
68488	84145	2	*
68500	84166	2	*
68514	84181	2	*
68554	84254	2	*
68561	84282	2	*
44192	843	2	*
68574	84326	2	*
68599	84367	2	*
68600	84368	2	*
68617	84390	2	*
68619	84392	2	*
68652	84492	2	*
68656	84505	2	*
68663	84525	2	*
68681	84582	2	*
68686	84660	2	*
68717	84954	2	*
68723	84974	2	*
68732	85027	2	*
68741	85241	2	*
68768	85373	2	*
47712	8556	2	*
47716	8562	2	*
68839	85952	2	*
68902	86234	2	*
68918	86270	2	*
68951	86453	2	*
68953	86456	2	*
68976	86536	2	*
68980	86543	2	*
69016	86652	2	*
69018	86654	2	*
69652	86883	2	*
69659	86903	2	*
69799	87270	2	*
69820	87393	2	*
69831	87408	2	*
69840	87426	2	*
69850	87447	2	*
69858	87558	2	*
69882	87629	2	*
69894	87650	2	*
69062	87712	2	*
69073	87760	2	*
69092	87811	2	*
69105	87851	2	*
69221	88219	2	*
69230	88231	2	*
69243	88264	2	*
69246	88279	2	*
47823	8838	2	*
47829	8844	2	*
69283	88451	2	*
69286	88463	2	*
69310	88622	2	*
69317	88635	2	*
69341	88773	2	*
47865	8899	2	*
69394	89014	2	*
69425	89135	2	*
69431	89143	2	*
69446	89201	2	*
69460	89222	2	*
69464	89267	2	*
69502	89505	2	*
69554	89743	2	*
69618	90077	2	*
69702	90181	2	*
69713	90210	2	*
69728	90249	2	*
69760	90382	2	*
69761	90383	2	*
69866	90437	2	*
69875	90501	2	*
69970	90676	2	*
69981	90699	2	*
48050	9475	2	*
48053	9478	2	*
48071	9506	2	*
48110	9568	2	*
48122	9587	2	*
48132	9597	2	*
48177	9645	2	*
48218	9701	2	*
48255	9761	2	*
48276	9806	2	*
48283	9820	2	*
48322	9954	2	*
152499	D5890	m	
152500	D9CEA	m	
128746	DB4B4	m	
152502	DC253	m	
152498	DD77G	m	

26th July 2019
Table "lemmario"
Modifica campo lemma per i seguenti (106 CASI)
id_lemma	n_id	OLD_lemma	NEW_lemma
44238	1015	acerues	aceruetis
48613	10654	axas	axatis
48748	10902	baes	baetis
48827	11065	bals	baltis
49006	11375	baudeguns	baudegundis
49015	11382	baus	bautis
49135	11562	bens	bendis
49242	11803	bibrax	bibractis
49239	11804	bibracs	bibractis
49651	12692	britomars	britomartis
49704	12767	brunichils	brunichildis
49730	12812	bubass	bubastis
49989	13358	caeless	caelestis
50186	13792	callas	callatis
50462	14699	carmens	carmentis
44520	1483	acs	actis
50976	16207	charybs	charybdis
51065	16439	chrodechils	chrodechildis
51358	17608	clis	clitis
51378	17645	clo	clonis
51451	17929	cocliens	cocliensis
44710	2123	ado	adonis
51945	21830	cro	crinis
52185	22754	cys	cytis
52241	22844	dalmas	dalmatis
52339	23020	das	datis
52514	24423	derces	dercetis
53442	28784	encras	encratis
53486	28948	ens	ensis
54686	33802	forens	forensis
45325	3436	agdess	agdestis
54987	35034	galonas	galonatis
55442	36151	gorgos	gorgotis
55647	36728	gyps	gyptis
45428	3700	agress	agrestis
55838	37111	harmass	harmastis
56470	38299	hippotens	hippotensis
56583	38694	hortens	hortensis
45559	3878	alax	alacer
56633	38868	hyaros	hyarotis
56961	39436	ics	ictis
45913	4091	alx	alcis
57541	44386	issas	issatis
58078	46113	las	latis
58314	46519	lemo	leminis
58399	46723	leps	leptis
58486	46866	leucophryis	leucophrys
58511	46895	leus	leutis
59313	48822	macess	macestis
59372	48926	macs	mactis
59399	48981	madianis	madianitis
60061	48987	mas	madis
59459	49065	maeos	maeotis
59666	49500	maluginens	maluginensis
59906	50040	mareos	mareotis
60060	50068	marx	margis
60349	50849	mefis	mefitis
60667	51419	mens	mensis
60738	51557	merx	mergis
60870	51886	mets	mettis
60908	51954	mics	mictis
61353	53535	murx	murgi
61668	54318	naucras	naucratis
62064	55165	nimers	nimertis
62128	55358	noduterens	noduterensis
62355	56383	obroas	obroatis
62503	57146	oeno	oenonis
62538	57268	ofiuns	ofiuntis
46419	5747	anas	anatis
62820	58110	oras	oratis
62937	58351	oriuns	oriundis
63130	58783	ouis	ouidis
63987	62533	pess	pestis
65134	67520	pros	protis
46913	6827	anyss	anystis
46992	6976	aphrodis	aphroditis
47046	7099	apollo	apollinis
65942	72401	saes	saetis
66362	72461	sax	sagis
66044	72676	salmorus	salmorudis
66173	73011	sans	sandis
66285	73255	sars	sardis
66379	73686	scals	scaldis
67068	76612	so	sinis
67662	81917	syrs	syrtis
67663	81918	syrs	syrtis
47528	8225	argess	argestis
68037	83020	terens	terensis
68088	83312	tethyis	tethys
68306	83791	thesaurochrysonicochry	thesaurochrysonicochrysides
68633	84170	tix	ticis
68556	84256	timonis	timonitis
68641	84284	to	tingi
68888	86189	tubacs	tubactis
68928	86280	tulx	tulcis
69835	87569	us	utis
69883	87630	uxans	uxantis
69201	88147	uecs	uectis
69565	89824	uirods	uiroddis
69589	89919	uisurx	uisurgis
69577	90009	uis	uitis
70017	90789	zes	zetis
70035	90827	ziobes	ziobetis
48012	9358	astars	astartis
44209	950	acdess	acdestis
48611	974	ax	acer

26th July 2019
Table "lemmario" E "lemmas_wfr"
Aggiunti lemmi fictional estratti da "derivational_db"
Aggiornata tabella 'lemmas_wfr' coi dati del medesimi db.

26th July 2019
Table "lemmario"
modificato campo 'gen' per i seguenti 
id_lemma	n_id	OLD_gen	NEW_gen
76922	D15H3		f
102978	D66E6		n
110787	D7F8C		m
112615	D84AH		n
113386	D872A		n
118343	D95C1		f
1963	a1669		n
34841	r0684		n
92835	D455F	m	n
139159	DD545	f	n
1853	a8573	f	n
6802	c1428	m	n
6810	c1435	n	f
6827	c1449	n	m
6848	c1468	2	n
6885	c1501	m	n
6892	c1508	m	n
6918	c1532	n	f
6931	c1544	n	m
6954	c1564	n	m
7098	c1687	n	m
7373	c1947	m	n
7386	c1961	m	n
7550	c2101	f	n
7594	c2141	n	f
10186	c4365	n	m
26846	o0230	1	2
37529	s2134	*	2


26th July 2019
Table "lemmario"
modificato campo 'gen' (da '') per i seguenti:
id_lemma	NEW_gen
1615	*
43274	*
43298	*
12849	*
43579	*
13049	f
13050	f
43578	f
13049	m
13050	m
43578	m
13049	f
13050	f
43578	f
13049	n
13050	n
43578	n
13049	n
13050	n
43578	n
13355	*
23955	n
43696	n
26041	*
26178	*
26329	*
43359	*
26855	n
26861	n
30585	*
33348	*
39671	*
14837	n
14838	n
43610	n
14837	m
14838	m
43610	m
58601	m
108603	*
 
29th January 2020
Tables "lessario" and "lemmario"
e0015: gen = m->f
DD80E: gen = m->f
DD80G: gen = m->f
s2023: gen = m->f
DF14B: gen = *->m; codles=n71->n2; codlem = N2/1->N2; codmorf = Af-->NcB; upostag = ADJ->NOUN
D831D: gen = m->*; codles=n31->n7c; codlem = N3B->N3A; codmorf = NcC->Af-; upostag = NOUN->ADJ

24th February 2020
Tables "lessario" and "lemmario"
gen = f->m for rows of "lessario" with pr_key:
20197
20202
20245
20255
23386
21526
21607
27393
47065

26th February 2020
Tables "lessario" and "lemmario"
'm0218', 'm', '', '', '', '', 'mal', 'n2', '', 'b', '+', '', '', '', '', '', '', '', '35260', '2018-07-24 18:08:15', 'B'
'm0218', 'n', '', '', '', '', 'mal', 'n2n', 'ma\"lum', '', '+', '', '', '', '', '', '', '', '35261', '2018-07-24 18:08:15', 'B'
->
'm9806', 'm', '', '', '', '', 'mal', 'n2', '', 'b', '', '', '', '', '', '', '', '', '35260', '2018-07-24 18:08:15', 'B'
'm0218', 'n', '', '', '', '', 'mal', 'n2n', 'ma\"lum', '', '', '', '', '', '', '', '', '', '35261','2018-07-24 18:08:15', 'B'
Changed n_id to lemma "malus" (NOUN, II decl., masculine: "stick/tree"), because it must belong to a CLEM different than that of "ma''lum" ("apple").
In "lemmario", this implied the change of n_id for lemma "malus" (id_lemma= '23957').

3rd March 2020
Tables "lessario" and "lemmario":
- fixed gen of lemma with n_id='c0752' ("cassis,-is"): not 'f', but 'm'
- assigned the same CLEM (n_id) to "carduus" (N4) and "carduus" (N2). "carduus" (N2) was assigned n_id='c0635' instead of n_id='c0113'

9th March 2020
Tables "lessario" and "lemmario":

D58B3		v				eiec	v3r		a									170148	2018-07-24 18:16:39	D
D58B3	*					eiec	n41											170149	2018-07-24 18:16:39	D
D58B3	*	i				eiec	n6p1											170150	2018-07-24 18:16:39	D
D58B3	*	i				eiec	n6p2											170151	2018-07-24 18:16:39	D
D58B3						eiec	v7s											170688	2018-07-24 18:16:39	D
D58B4						eiic	v3r		b									124324	2018-07-24 18:16:39	D
->
D58B3		v				eiic	v5r		a									170148	2018-07-24 18:16:39	D
D58B3	*					eiect	n41											170149	2018-07-24 18:16:39	D
D58B3	*	i				eiect	n6p1											170150	2018-07-24 18:16:39	D
D58B3	*	i				eiectur	n6p2											170151	2018-07-24 18:16:39	D
D58B3						eiex	v7s											170688	2018-07-24 18:16:39	D
D58B4		v				eiic	v5r		b									124324	2018-07-24 18:16:39	D

Added lines:
D58B4	*					eiect	n41											181483	2020-03-09 13:49:25	D
D58B4	*	i				eiect	n6p1											181484	2020-03-09 13:49:25	D
D58B4	*	i				eiectur	n6p2											181485	2020-03-09 13:49:25	D
D58B4						eiex	v7s											181486	2020-03-09 13:49:25	D

'DE04C','','v','','','','suruix','v3r','','','','','','','','','',NULL,'170629','2018-07-24 18:16:39','D'
'DE04C','*','','','','','suruix','n41','','','','','','','','','',NULL,'170630','2018-07-24 18:16:39','D'
'DE04C','*','i','','','','suruix','n6p1','','','','','','','','','',NULL,'170631','2018-07-24 18:16:39','D'
'DE04C','*','i','','','','suruix','n6p2','','','','','','','','','',NULL,'170632','2018-07-24 18:16:39','D'
'DE04C','','','','','','suruix','v7s','','','','','','','','','',NULL,'170633','2018-07-24 18:16:39','D'
->
'DE04C','','v','','','','suruiu','v3i','','','','','','','','','',NULL,'170629','2018-07-24 18:16:39','D'
'DE04C','','','','','','suruix','v7s','','','','','','','','','',NULL,'170633','2018-07-24 18:16:39','D'

D4FE5	*	i				deiung	n6p1											172883	2018-07-24 18:16:39	D
D4FE5	*	i				deiung	n6p2											172884	2018-07-24 18:16:39	D
D4FE5	*					deiung	n41											172885	2018-07-24 18:16:39	D
D4FE5		v				deiung	v3r											173498	2018-07-24 18:16:39	D
->
D4FE5	*	i				deiunct	n6p1											172883	2018-07-24 18:16:39	D
D4FE5	*	i				deiunctur	n6p2											172884	2018-07-24 18:16:39	D
D4FE5	*					deiunct	n41											172885	2018-07-24 18:16:39	D
D4FE5		v				deiung	v3r											173498	2018-07-24 18:16:39	D

Added line:
D4FE5						deiunx	v7s											181487	2020-03-09 13:56:24	D

D530H		v				discurr	v3r		a									170123	2018-07-24 18:16:39	D
D530H	*					discurs	n41											170124	2018-07-24 18:16:39	D
D530H	*	i				discurs	n6p1											170125	2018-07-24 18:16:39	D
D530H	*	i				discurs	n6p2											170126	2018-07-24 18:16:39	D
->
D530H		v				discurr	v3r		a									170123	2018-07-24 18:16:39	D
D530H	*					discurs	n41											170124	2018-07-24 18:16:39	D
D530H	*	i				discurs	n6p1											170125	2018-07-24 18:16:39	D
D530H	*	i				discursur	n6p2											170126	2018-07-24 18:16:39	D

Added line:
D530H						discucurr	v7s											181488	2020-03-09 13:58:59	D

23rd March 2020
Table 'lemmario': fixed UPOSTAG for lemma with id_lemma='35896' (n_id='s0640'; "scilicet"). INTJ -> ADV

27th March 2020
Tables 'lemmario' and 'lessario': changed lemma "decius" with n_id='23275' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "adrianus" with n_id='2231' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "iuvenalis" with n_id='45050' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "alcimus" with n_id='4086' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "benedictus" with n_id='11574' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "constantinus" with n_id='20417' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "damascenus" with n_id='22856' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "festus" with n_id='32936' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "latinus" with n_id='46109' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "leuiticus" with n_id='46943' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "meliboeus" with n_id='51033' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "pyrenaeus" with n_id='68346' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "teucrus" with n_id='83412' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "theophilus" with n_id='83695' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "transtiberinus" with n_id='85245' ADJ -> PROPN

30th March 2020
Tables 'lemmario' and 'lessario': changed lemma "delius" with n_id='23902' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "demetrius" with n_id='23993' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "dionysius" with n_id='25659' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "horatius" with n_id='38589' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "hostilius" with n_id='38753' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "innocentius" with n_id='42432' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "liuius" with n_id='47686' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "manlius" with n_id='49769' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "ouidius" with n_id='58784' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "plinius" with n_id='64129' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "publius" with n_id='67859' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "statius" with n_id='78286' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "terentius" with n_id='83024' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "tiberius" with n_id='84126' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "uergilius" with n_id='88669' ADJ -> PROPN

Tables 'lemmario' and 'lessario': changed lemma "honestus" with n_id='38539' ADJ -> PROPN
Tables 'lemmario' and 'lessario': changed lemma "octauianus" with n_id='56914' ADJ -> PROPN

23rd May 2020
#Lemma "melinus" (n_id='m0650'; upostag='ADJ'; id_lemma='24469') does not have graphicl vairant with two "l' ("mellinus")
#Table: lessario
'm0167', '*', 'v', '', '', '', 'mellin', 'n6', '', 'b', '', '', '', '', '', '', '', '', '35864', '2018-07-24 18:08:15', 'B'
->
'm0167', '*', 'v', '', '', '', 'mellin', 'n6', '', '', '', '', '', '', '', '', '', '', '35864', '2018-07-24 18:08:15', 'B'

'm0650', '*', 'v', '', '', '', 'mellin', 'n6', '', 'a', '', '', '', '', '', '', '', '', '35922', '2018-07-24 18:08:15', 'B'
->
removed

'm0650', '*', 'i', '', '', '', 'melin', 'n6', 'me\"li\"nus', '', '', '', '', '', '', '', '', '', '35923', '2018-07-24 18:08:15', 'B'
->
'm0650', '*', '', '', '', '', 'melin', 'n6', 'me\"li\"nus', '', '', '', '', '', '', '', '', '', '35923', '2020-05-23 09:57:37', 'B'

#Table: lemmario
'24469', 'mellinus', 'N2/1', '*', 'Af-', 'm0650', 'mellinus', 'ADJ', NULL, 'B'
->
'24469', 'me\'\'li\'\'nus', 'N2/1', '*', 'Af-', 'm0650', 'me\'\'li\'\'nus', 'ADJ', NULL, 'B'

#Tabella 'lessario'
#Riga con pr_key='56237' (les='string'): codles='v1r' -> codles='v3r'
#Tabella 'lemmario'
#Riga con id_lemma='38065' (lemma='stringo'): codmorf='Vmf' -> codmorf='VmH'
UPDATE lessario SET codles='v3r' WHERE pr_key=56237;
UPDATE lemmario SET codmorf='VmH', codlem='V3' WHERE id_lemma=38065;

26th October 2020
Fixed gender of lemma 'exodus' (n_id='e8525'), from feminine to masculine, in table 'lessario' and in table 'lemmario'

#'adam' (n_id='1621'): added ipolemma with fl_cat:'n1e'
Table 'lessario'
Added row:
'1621', 'm', '', '', '', '', 'adam', 'n1e', '=', '', '', '', 'p', '3', '', '', '', NULL, '181490', '2020-10-26 15:58:45', 'O'
Added NX in field 'codlem', and v in field 'clem'
'1621', '', 'v', '', '', '', 'adam', 'n', '', '', '', 'NX', 'p', '', '', '', '', NULL, '84966', '2020-10-26 16:06:17', 'O'

'abraham' (n_id='437'): added ipolemma with fl_cat:'n1e'
Table 'lessario'
Added row:
'437', 'm', '', '', '', '', 'abraham', 'n1e', '=', '', '', '', 'p', '3', '', '', '', NULL, '181491', '2020-10-26 16:11:52', 'O'
Added NX in field 'codlem', and v in field 'clem'
'437', '', 'v', '', '', '', 'abraham', 'n', '', '', '', 'NX', 'p', '', '', '', '', NULL, '85156', '2020-10-26 16:10:16', 'O'

'david' (n_id='23046'): added ipolemma with fl_cat:'n3'
Table 'lessario'
Added row:
'23046', 'm', '', '', '', '', 'dauid', 'n3', '=', '', '', '', 'p', '3', '', '', '', NULL, '181492', '2020-10-26 16:14:33', 'O'
Added NX in field 'codlem', and v in field 'clem'
'23046', '', 'v', '', '', '', 'dauid', 'n', '', '', '', 'NX', 'p', '', '', '', '', NULL, '85002', '2020-10-26 16:14:25', 'O'

'israel' (n_id='44378'): added ipolemma with fl_cat:'n3' in lemlat
Table 'lessario'
Added row:
'44378', 'm', '', '', '', '', 'israel', 'n3', '=', '', '', '', 'p', '3', '', '', '', NULL, '181493', '2020-10-26 16:17:38', 'O'
Added NX in field 'codlem', and v in field 'clem'
'44378', '', 'v', '', '', '', 'israel', 'n', '', '', '', 'NX', 'p', '', '', '', '', NULL, '85163', '2020-10-26 16:17:38', 'O'

#'ioel' (n_id='44733'): added ipolemma with fl_cat:'n3' in lemlat
Table 'lessario'
Added row:
'44733', 'm', '', '', '', '', 'ioel', 'n3', '=', '', '', '', 'p', '3', '', '', '', NULL, '181494', '2020-10-26 16:20:15', 'O'
Added NX in field 'codlem', and v in field 'clem'
'44733', '', 'v', '', '', '', 'ioel', 'n', '', '', '', 'NX', 'p', '', '', '', '', NULL, '85199', '2020-10-26 16:20:15', 'O'

######################
#lemmario record:
+----------+--------+
| id_lemma | lemma  |
+----------+--------+
|    71701 | adam   |
|    95331 | dauid  |
|    95330 | dauid  |
|   112416 | ioel   |
|   112584 | israel |
+----------+--------+
# cambio upostag da 'NOUN' a 'PROPN'
#        gen     da ''     a 'm'
# per le corrispondenti entrate del lessario
+--------+--------+
| pr_key | les    |
+--------+--------+
| 164912 | adam   |
| 166046 | dauid  |
| 165667 | dauid  |
| 165122 | ioel   |
| 165757 | israel |
+--------+--------+
# cambio type da '' a 'p'
# per le corrispondenti 
forme_ecc:
c07='m'
#############################

(bugfix) lemma "curiatius" da ADJ a NOUN:
- lessario: n_id='22372' -> gen='m', codles='n2i', type='p'
- lemmario: n_id='22372' -> codlem='N2', gen='m', codmorf='NpB', upostag='PROPN'

############################

aggiunta entrata lessario/lemmario

#Tabella 'lessario'
n_id='l9921'
les='lustr'
smv='+'
codles='v1d'
lem='-or'
src='B'

#Tabella 'lemmario'
lemma='lustror'
codlem='V1'
codmorf='VmF'
n_id='l9921'
lemma_reduced='lustror'
upostag='VERB'
src='B'

#######################

BUGFIX principium:

--lemlat_db.lessario--

(1)

n_id='p4684'
pr_key=''46937''

gen='n' -> gen=''
les='princip' -> les='principium'
codles='n2ni' -> les='i'
s_omo='b' -> s_omo=''



(2)
n_id='p3568'
pr_key='46936'

s_omo='a' -> s_omo=''

--lemlat_db.lemmario--

id_lemma='31987'

codlem='N2' -> codlem='I'
gen='n' -> gen=''
codmorf='NcB' -> codmorf='X--'
upostag='NOUN' -> upostag='ADV'

#######################
eliminazione di 'gallus' i.e. n_id='g0061'
i.e.:
lessario: pr_key = 25702 
lemmario: id_lemma= 17025



###########
aggiunta les 'subsiciu' nella clem di s3118 in lemlat_db.lessario:
's3118','n','','','','','subsiciu','n2n','','','','','','','','s07','',NULL,'181496','2021-05-21 11:14:56','B'
's3118','n','','','','','subseciu','n2n','','','','','','','','','',NULL,'181497','2021-05-21 11:14:56','B'
's3118','n','','','','','succisiu','n2n','','','','','','','','s01','',NULL,'181498','2021-05-21 11:14:56','B'

aggiunta a lemlat_db.lemmario:
'157233','subsiciuum','N2','n','NcB','s3118','subsiciuum','NOUN',NULL,'B'


!!!!!!!!!!!!!!!!!!
aggiunta a lemmas_wfr:
'102','157233','38607','1','Derivation_Conversion','A-To-N',NULL
ERRORE!!!
!!!!!!!!!!!!!!!

./aggiuntePerLASLA/INSERT_lila_entry_AGGIUNTE.sql
./BUGFIX_quinquennalis.sql
./BUGFIX_gallus/bugfix_gallus.sql
./aggiuntePerEgloghe/BUGFIX_n1-as.txt
./aggiuntePerEgloghe/aggiunteManuali_BUGFIXES.sql
./BUGFIX_lemmaVariantHypo/BUGFIX_lemmaVariantHypo.txt
./BUGFIX_lemmaVariantHypo/BUGFIX_lemmaVariantHypo.sql
./BUGFIX_ceu/bugfix_ceu.sql


BUGFIX_ripo2ripare.sql

BUGFIX_diapanton_refacio_elino.sql

BUGFIX 'leuis':
UPDATE `lemlat_db`.`tab_le` SET `codLE`='d' WHERE `pr_key`='2772';
UPDATE `lemlat_db`.`tab_le` SET `codLE`='d' WHERE `pr_key`='2773’;

Modifiche per Confessiones (v.  lila_db/modifiche/aggiuntePerConfessiones/modificheLiLaLemLat.sql):
* cambiamento genere da  m a f
lemmario id_lemma: 76630, 76631
lessario n_id: D1501, D1502
* cambiamento POS da ADJ a PROPN
lemmario id_lemma 60252
lessario     n_id 50623
* cambiamento POS da ADJ a PROPN
lemmario id_lemma 62808
lessario     n_id 58063
* cambiamento POS da ADJ a PROPN
lemmario id_lemma 65067
lessario     n_id 66460
mod/modificheDucange.sql
../lemlat_db_dumps/lemlat_db_DO_10-02-2023.sql.gz

mod/modificheDucangeBF.sql
**DDL** aggiundo TS a lemmario - creo tabelle per la cacellazione dei doppioni ducange (deprecazione):
	mod/creaTabDeprecati.sql
bugfix per eliminazione duplicati (mod/eliminaDuplicati)
BUGFIX_duplicatiDucange3.sql
BUGFIX_duplicatiDucange2.sql
BUGFIX_duplicatiDucange1.sql

eliminazione duplicati ducange
BUGFIX_duplicatiDucange4.sql
bugfix eliminazione duplicati: gruppi non predendentemente considerati.

emliniazione duplicati issue #2

eliminazione duplicati estesa: ext

mod/BUGFIX_e1381.sql
mod/BUGFIX_nobiscum.sql
BUGFIX_absolute.sql
mod/BUGFIX_sallustius.sql

#######
14/11/2025

fixing les that are mistakenly tagged as n71 > n7 (and corresponding inflection types in the lemmario)

in lemlat_db.lessario: codles "n71" > "n7", codLE "d" > ""
in lila_db.lemma: fl_cat "n71" > "n7"
in one case (censualis) there are two les, one n71, the other n7; the les n71 can be removed, here are the old values for the record
c1126	*					censual	n71			+								9295	2018-07-24 18:08:15	B

here are the commands run:

UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '11020');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '24049');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '24060');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '26746');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7' WHERE (`pr_key` = '33866');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '42265');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '50685');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '50686');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '62331');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '63817');
UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7', `codLE` = '' WHERE (`pr_key` = '63818');

UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '94668');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '103090');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '103098');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '105190');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '110327');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '116551');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '122156');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '130037');
UPDATE `lila_db`.`lemma` SET `fl_cat` = 'n7' WHERE (`id_lemma` = '131065');

DELETE FROM `lemlat_db`.`lessario` WHERE (`pr_key` = '9295');

######

18/11/2025

same change as 14/11 for les with pr_key 33887 that was left out

UPDATE `lemlat_db`.`lessario` SET `codles` = 'n7' WHERE (`pr_key` = '33887');
######## mer 10 dic 2025, 18:09:03, CET
update dump file
mod/modFaria.sql
### Wed 10 Dec 2025 06:42:42 PM CET
update dump file 
Fri 22 May 2026 10:40:03 AM CEST : mod/BUGFIX_degrumor.sql