Mercurial > hg > webserver / file revision

insert into Resource (nodename, iscollection) values ('', true);

insert into Resource(parent_id,  nodename) values
((select resource_id from Resource where parent_id is null), 'file1.txt'),
((select resource_id from Resource where parent_id is null), 'file2.txt'),
((select resource_id from Resource where parent_id is null), 'file3.txt'),
((select resource_id from Resource where parent_id is null), 'file4.txt');

insert into Resource(parent_id,  nodename, iscollection) values
((select resource_id from Resource where parent_id is null), 'dir1', true);

insert into Resource(parent_id,  nodename, iscollection) values
((select resource_id from Resource where nodename = 'dir1'), 'dir2', true);

insert into Resource(parent_id,  nodename) values
((select resource_id from Resource where nodename = 'dir1'), 'd1file1.txt'),
((select resource_id from Resource where nodename = 'dir2'), 'd2file1.txt'),
((select resource_id from Resource where nodename = 'dir2'), 'd2file2.txt');