1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
CREATE TABLE dir (
id SERIAL PRIMARY KEY,
parent_id INTEGER REFERENCES dir( id ),
name TEXT,
path TEXT,
UNIQUE( name, parent_id ),
UNIQUE( path ),
size INTEGER DEFAULT 0,
mode INTEGER NOT NULL DEFAULT 0,
uid INTEGER NOT NULL DEFAULT 0,
gid INTEGER NOT NULL DEFAULT 0,
ctime TIMESTAMP,
mtime TIMESTAMP,
atime TIMESTAMP
);
-- TODO: 512 is STANDARD_BLOCK_SIZE in config.h, must be in sync!
CREATE TABLE data (
id SERIAL PRIMARY KEY,
dir_id INTEGER,
block_no INTEGER NOT NULL DEFAULT 0,
FOREIGN KEY( dir_id ) REFERENCES dir( id ),
data BYTEA NOT NULL DEFAULT repeat(E'\\000',512)::bytea
);
-- create indexes for fast data access
CREATE INDEX data_dir_id_idx ON data( dir_id );
CREATE INDEX data_block_no_idx ON data( block_no );
-- create an index on the parent_id for
-- directory listings
CREATE INDEX dir_parent_id_idx ON dir( parent_id );
-- 16384 == S_IFDIR (S_IFDIR)
-- 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
DO ALSO DELETE FROM data WHERE dir_id=OLD.id;
-- self-referencing anchor for root directory
-- 16895 = S_IFDIR and 0777 permissions
-- TODO: should be done from outside, see note above
INSERT INTO dir( id, parent_id, name, path, size, mode, uid, gid, ctime, mtime, atime )
VALUES( 0, 0, '/', '/', 0, 16895, 0, 0, NOW( ), NOW( ), NOW( ) );
|
