1

CREATE TABLE inodes (ino serial4 primary key, type char(3), mode int2, size int8);

     2

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);

     3

     4

INSERT INTO inodes VALUES (1, 'DIR', 365, 0);

     5

INSERT INTO inodes VALUES (2, 'REG', 292, 0);

     6

INSERT INTO file_tree (name, parent, inode) VALUES ('foo', 1, 2);

     7