CREATE TABLE acs_permissions ( object_id integer NOT NULL, grantee_id integer NOT NULL, privilege varchar(100) NOT NULL, PRIMARY KEY (object_id,grantee_id,privilege), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_permissions_grantee_id_fk REFERENCES parties (), CONSTRAINT acs_permissions_object_id_fk REFERENCES parties (), CONSTRAINT acs_permissions_pk REFERENCES parties (), CONSTRAINT acs_permissions_privilege_fk REFERENCES parties () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_permissions_privilege_fk REFERENCES acs_objects (), CONSTRAINT acs_permissions_pk REFERENCES acs_objects (), CONSTRAINT acs_permissions_object_id_fk REFERENCES acs_objects (), CONSTRAINT acs_permissions_grantee_id_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_permissions_privilege_fk REFERENCES acs_privileges (), CONSTRAINT acs_permissions_grantee_id_fk REFERENCES acs_privileges (), CONSTRAINT acs_permissions_object_id_fk REFERENCES acs_privileges (), CONSTRAINT acs_permissions_pk REFERENCES acs_privileges () ); CREATE INDEX acs_permissions_grantee_idx ON acs_permissions (grantee_id); CREATE INDEX acs_permissions_object_id_idx ON acs_permissions (object_id); CREATE INDEX acs_permissions_privilege_idx ON acs_permissions (privilege); CREATE TRIGGER RI_ConstraintTrigger_c_340474 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340475 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340479 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340480 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340484 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340485 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 2,293,760 bytes -- Table rows: 50,514
Begin main content
