2 -- Table to manage users trust network
4 DROP TABLE IF EXISTS #PFX#usersnet;
5 CREATE TABLE #PFX#usersnet (
6 owner integer REFERENCES #PFX#users (code)
7 ON DELETE cascade ON UPDATE cascade, -- network owner
8 target integer REFERENCES #PFX#users (code)
9 ON DELETE cascade ON UPDATE cascade, -- evaluated user
10 friend integer, -- friendship level
11 skill integer, -- skill level
12 trust integer, -- auth
13 ctime timestamp DEFAULT now(), -- creation time
14 mtime timestamp DEFAULT to_timestamp(0) -- modification time
17 DROP INDEX IF EXISTS #PFX#usersnet_owner_idx;
18 DROP INDEX IF EXISTS #PFX#usersnet_target_idx;
19 DROP INDEX IF EXISTS #PFX#usersnet_owner_target_idx;
20 CREATE INDEX #PFX#usersnet_owner_idx ON #PFX#usersnet (owner);
21 CREATE INDEX #PFX#usersnet_target_idx ON #PFX#usersnet (target);
22 CREATE UNIQUE INDEX #PFX#usersnet_owner_target_idx ON #PFX#usersnet (owner,target);