changeset 35 | 4f10421681d2 |
parent 33 | c71f3053c714 |
child 37 | c3880f3b4de8 |
--- a/doc/fuse_db.sql Fri Oct 17 19:28:27 2008 +0300 +++ b/doc/fuse_db.sql Fri Oct 17 20:12:20 2008 +0300 @@ -31,6 +31,7 @@ ALTER TABLE inodes ALTER COLUMN ino SET DEFAULT nextval('ino_seq'::regclass); ALTER TABLE file_tree ADD COLUMN ino int4; +ALTER TABLE file_tree ADD CONSTRAINT file_tree_ino_fkey FOREIGN KEY (ino) REFERENCES inodes (ino); UPDATE file_tree SET ino = inode; ALTER TABLE file_tree DROP COLUMN inode; @@ -41,4 +42,3 @@ ELSE 0 END; $$; -