doc/fuse_db.sql
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;
 $$;
-