summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorAndreas Baumann <abaumann@yahoo.com>2012-05-06 12:51:36 +0200
committerAndreas Baumann <abaumann@yahoo.com>2012-05-06 12:51:36 +0200
commitbc26616b1af435f7c7509ff3f5b70bc3991015b2 (patch)
tree11fd917530d860b3e59bc5d2075729a90f464a72 /schema.sql
parentb80d19d023149d81fc80ff873d96cf14617db06d (diff)
downloadpgfuse-bc26616b1af435f7c7509ff3f5b70bc3991015b2.tar.gz
pgfuse-bc26616b1af435f7c7509ff3f5b70bc3991015b2.tar.bz2
added mount option blocksize, can be set when creating the filsystem
(first write), schema.sql doesn't contain block size information anymore
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql9
1 files changed, 1 insertions, 8 deletions
diff --git a/schema.sql b/schema.sql
index 7822205..2f5c202 100644
--- a/schema.sql
+++ b/schema.sql
@@ -18,7 +18,7 @@ CREATE TABLE dir (
CREATE TABLE data (
dir_id BIGINT,
block_no BIGINT NOT NULL DEFAULT 0,
- data BYTEA NOT NULL DEFAULT repeat(E'\\000',4096)::bytea,
+ data BYTEA,
PRIMARY KEY( dir_id, block_no ),
FOREIGN KEY( dir_id ) REFERENCES dir( id )
);
@@ -35,13 +35,6 @@ CREATE INDEX dir_parent_id_idx ON dir( parent_id );
-- TODO: should be created by the program after checking the OS
-- it is running on (for full POSIX compatibility)
--- make sure 'dir' entries always get a first block in the 'data'
--- table
-CREATE OR REPLACE RULE "dir_insert" AS ON
- INSERT TO dir WHERE NEW.mode & 16384 = 0
- DO ALSO INSERT INTO data( dir_id )
- VALUES ( currval( 'dir_id_seq' ) );
-
-- garbage collect deleted file entries, delete all blocks in 'data'
CREATE OR REPLACE RULE "dir_remove" AS ON
DELETE TO dir WHERE OLD.mode & 16384 = 0