terom@24: CREATE TABLE inodes (ino serial4 primary key, type char(3), mode int2, size int8);
terom@24: CREATE TABLE file_tree ("offset" serial4 primary key, name varchar(256) NOT NULL, parent int4 references inodes(ino) NOT NULL, inode int4 references inodes(ino) NOT NULL);
terom@24: 
terom@24: INSERT INTO inodes VALUES (1, 'DIR', 365, 0);
terom@24: INSERT INTO inodes VALUES (2, 'REG', 292, 0);
terom@24: INSERT INTO file_tree (name, parent, inode) VALUES ('foo', 1, 2);
terom@24: