-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE TABLE treedemo (
    id INTEGER NOT NULL,
    parentid INTEGER,
    typ VARCHAR(20),
    PRIMARY KEY(id)
);

INSERT INTO treedemo VALUES(1,null,'Folder');
INSERT INTO treedemo VALUES(2,1,'Folder');
INSERT INTO treedemo VALUES(3,2,'Folder');
INSERT INTO treedemo VALUES(4,3,'Folder');
INSERT INTO treedemo VALUES(5,3,'Content');
INSERT INTO treedemo VALUES(6,3,'Folder');
INSERT INTO treedemo VALUES(7,6,'Content');
INSERT INTO treedemo VALUES(8,6,'Content');

DROP TABLE treedemo;
