Lines Matching refs:payload

493   CREATE TABLE tree(id INTEGER PRIMARY KEY, parentid, payload);
503         SELECT id FROM tree WHERE parentid IS $parentid AND payload=$seg
523     SELECT id, '/' || payload FROM tree WHERE parentid IS NULL
525     SELECT id, p || '/' || payload FROM flat, tree WHERE parentid=fid
549         SELECT id, 1, '/' || payload FROM tree WHERE parentid IS NULL
551         SELECT id, depth+1, p||'/'||payload FROM flat, tree WHERE parentid=fid
647     SELECT id, 1, '/' || payload FROM tree WHERE parentid IS NULL
649     SELECT id, depth+1, p||'/'||payload FROM flat, tree WHERE parentid=fid
659       SELECT id, 1, ('/' || payload) COLLATE nocase 
662       SELECT id, depth+1, (p||'/'||payload)
674       SELECT id, 1, ('/' || payload)
677       SELECT id, depth+1, (p||'/'||payload) COLLATE nocase