SQLite format 3@ $ jj##otablesimple_succsimple_succCREATE TABLE simple_succ ( title character varying(100), childid integer, id INTEGER PRIMARY KEY NOT NULL )gtablesimplesimpleCREATE TABLE simple ( title character varying(100), parentid integer, id INTEGER PRIMARY KEY NOT NULL )I#/indexcomplex_map_child_parent_complcomplex_mapCREATE UNIQUE INDEX complex_map_child_parent_compl ON complex_map (child, parent)s##-tablecomplex_mapcomplex_mapCREATE TABLE complex_map ( child integer NOT NULL, parent integer NOT NULL )uAtablecomplexcomplexCREATE TABLE complex ( title character varying(100), id INTEGER PRIMARY KEY NOT NULL )  subchild subchildrootchildrootroot    subchild subchild child child child root  rootnew subchild subchild root child root root