php/mysqlitedb.db

SQLite format 3@  -
x!%viewtt1Patt1PaCREATE VIEW tt1Pa as with  pp as ( select rowid pk, i.*, '' paCh from tt1 i  union all select c.pk, c.name, c.txt, p.pa, paCh || p.rowid || '>' || p.name || ' ' from pp c join tt1 p on c.pa = p.rowid) select pk, name, txt, max(paCh) paCh from pp group by pk, name, txt-9triggertt1Tr1tt1CREATE TRIGGER tt1Tr1 after update on tt1 for each row begin update tt1 set txt = new.txt || ' <--updTri--< ' || old.txt  where rowid = old.rowid; end=]indextt1INatt1CREATE UNIQUE INDEX tt1INa on tt1 (name)Gwtablett1tt1CREATE TABLE tt1(name, txt, pa references tt1(rowid))
ff*Mwalterupdated <--updTri--< das bin ichalissiae4
merline5cyrile3
    florians3    davids2    gregors1
alissia
merlin    cyrilflorian    david
gregor        walter