-- -- This table stores the types of archives that can be stored in a given download repository. -- CREATE TABLE download_archive_types ( archive_type_id integer PRIMARY KEY NOT NULL, repository_id integer, pretty_name varchar(100) NOT NULL, description varchar(500) NOT NULL, CONSTRAINT download_archive_rep_id_fk REFERENCES download_repository (), CONSTRAINT download_archive_types_pk REFERENCES download_repository () ); CREATE INDEX download_archive_types_rid ON download_archive_types (repository_id); CREATE TRIGGER RI_ConstraintTrigger_c_341594 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341595 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341607 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341608 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341632 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341633 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to download_archive_types: --download_archive_metadata(download_archive_rep_id_fk) --download_archive_metadata(download_archive_types_pk) --download_archives(download_archive_rep_id_fk) --download_archives(download_archive_types_pk) -- Table size: 8,192 bytes -- Table rows: 15
Begin main content
