-- -- The acs_privilege_hierarchy gives us an easy way to say: The foo -- privilege is a superset of the bar privilege. -- CREATE TABLE acs_privilege_hierarchy ( privilege varchar(100) NOT NULL, child_privilege varchar(100) NOT NULL, PRIMARY KEY (privilege,child_privilege), CONSTRAINT acs_priv_hier_child_priv_fk REFERENCES acs_privileges (), CONSTRAINT acs_priv_hier_priv_fk REFERENCES acs_privileges (), CONSTRAINT acs_privilege_hierarchy_pk REFERENCES acs_privileges (), CONSTRAINT acs_privilege_hierarchy_pk REFERENCES acs_privileges (), CONSTRAINT acs_priv_hier_child_priv_fk REFERENCES acs_privileges (), CONSTRAINT acs_priv_hier_priv_fk REFERENCES acs_privileges () ); CREATE INDEX acs_priv_hier_child_priv_idx ON acs_privilege_hierarchy (child_privilege); CREATE TRIGGER RI_ConstraintTrigger_c_340489 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340490 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340494 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340495 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 84
Begin main content
