- Timestamp:
- 05/09/08 12:34:30 (4 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
branches/rel_1_2/Open-ILS/src/sql/Pg/006.schema.permissions.sql
r7158 r9543 14 14 id SERIAL PRIMARY KEY, 15 15 name TEXT NOT NULL UNIQUE, 16 parent INT REFERENCES permission.grp_tree (id) ON DELETE RESTRICT ,16 parent INT REFERENCES permission.grp_tree (id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED, 17 17 usergroup BOOL NOT NULL DEFAULT TRUE, 18 18 perm_interval INTERVAL DEFAULT '3 years'::interval NOT NULL, … … 24 24 CREATE TABLE permission.grp_perm_map ( 25 25 id SERIAL PRIMARY KEY, 26 grp INT NOT NULL REFERENCES permission.grp_tree (id) ON DELETE CASCADE ,27 perm INT NOT NULL REFERENCES permission.perm_list (id) ON DELETE CASCADE ,26 grp INT NOT NULL REFERENCES permission.grp_tree (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 27 perm INT NOT NULL REFERENCES permission.perm_list (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 28 28 depth INT NOT NULL, 29 29 grantable BOOL NOT NULL DEFAULT FALSE, … … 33 33 CREATE TABLE permission.usr_perm_map ( 34 34 id SERIAL PRIMARY KEY, 35 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE ,36 perm INT NOT NULL REFERENCES permission.perm_list (id) ON DELETE CASCADE ,35 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 36 perm INT NOT NULL REFERENCES permission.perm_list (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 37 37 depth INT NOT NULL, 38 38 grantable BOOL NOT NULL DEFAULT FALSE, … … 42 42 CREATE TABLE permission.usr_grp_map ( 43 43 id SERIAL PRIMARY KEY, 44 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE ,45 grp INT NOT NULL REFERENCES permission.grp_tree (id) ON DELETE CASCADE ,44 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 45 grp INT NOT NULL REFERENCES permission.grp_tree (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 46 46 CONSTRAINT usr_grp_once UNIQUE (usr,grp) 47 47 ); … … 82 82 CREATE TABLE permission.usr_work_ou_map ( 83 83 id SERIAL PRIMARY KEY, 84 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE ,85 work_ou INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE ,84 usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 85 work_ou INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, 86 86 CONSTRAINT usr_work_ou_once UNIQUE (usr,work_ou) 87 87 );
