CREATE TABLE auth_authorities (
authority_id integer PRIMARY KEY NOT NULL,
short_name varchar(255),
pretty_name varchar(4000),
--
-- Contact information (phone, email, etc.) to be displayed
-- as a last resort when people are having problems with an authority.
--
help_contact_text varchar(4000),
help_contact_text_format varchar(200),
enabled_p bool DEFAULT true NOT NULL,
sort_order integer NOT NULL,
auth_impl_id integer,
pwd_impl_id integer,
--
-- Any username in this url must be on the syntax foo={username}
-- and {username} will be replaced with the real username
--
forgotten_pwd_url varchar(4000),
--
-- Any username in this url must be on the syntax foo={username}
-- and {username} will be replaced with the real username
--
change_pwd_url varchar(4000),
register_impl_id integer,
register_url varchar(4000),
user_info_impl_id integer,
get_doc_impl_id integer,
process_doc_impl_id integer,
batch_sync_enabled_p bool DEFAULT false NOT NULL,
allow_user_entered_info_p bool DEFAULT false NOT NULL,
search_impl_id integer,
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects (),
CONSTRAINT auth_authority_userinf_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_short_name_un REFERENCES acs_objects (),
CONSTRAINT auth_authority_reg_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_pwd_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authority_auth_impl_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_search_impl_id_fk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_pk REFERENCES acs_objects (),
CONSTRAINT auth_authorities_aid_fk REFERENCES acs_objects (),
CONSTRAINT $2 REFERENCES acs_objects (),
CONSTRAINT $1 REFERENCES acs_objects ()
);
CREATE UNIQUE INDEX auth_authority_short_name_un ON auth_authorities (short_name);
CREATE TRIGGER RI_ConstraintTrigger_c_340204 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340205 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340234 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340235 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340779 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340780 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340784 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340785 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340789 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340790 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340794 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340795 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340799 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340800 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340804 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340805 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340822 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340823 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340827 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340828 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343052 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343053 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to auth_authorities:
--auth_batch_jobs($1)
--auth_batch_jobs($2)
--auth_batch_jobs(auth_authorities_aid_fk)
--auth_batch_jobs(auth_authorities_pk)
--auth_batch_jobs(auth_authorities_search_impl_id_fk)
--auth_batch_jobs(auth_authority_auth_impl_fk)
--auth_batch_jobs(auth_authority_pwd_impl_fk)
--auth_batch_jobs(auth_authority_reg_impl_fk)
--auth_batch_jobs(auth_authority_short_name_un)
--auth_batch_jobs(auth_authority_userinf_impl_fk)
--auth_driver_params($1)
--auth_driver_params($2)
--auth_driver_params(auth_authorities_aid_fk)
--auth_driver_params(auth_authorities_pk)
--auth_driver_params(auth_authorities_search_impl_id_fk)
--auth_driver_params(auth_authority_auth_impl_fk)
--auth_driver_params(auth_authority_pwd_impl_fk)
--auth_driver_params(auth_authority_reg_impl_fk)
--auth_driver_params(auth_authority_short_name_un)
--auth_driver_params(auth_authority_userinf_impl_fk)
--users($1)
--users($2)
--users(auth_authorities_aid_fk)
--users(auth_authorities_pk)
--users(auth_authorities_search_impl_id_fk)
--users(auth_authority_auth_impl_fk)
--users(auth_authority_pwd_impl_fk)
--users(auth_authority_reg_impl_fk)
--users(auth_authority_short_name_un)
--users(auth_authority_userinf_impl_fk)
-- Table size: 8,192 bytes
-- Table rows: 2
Begin main content
