CREATE TABLE download_archive_revisions ( revision_id integer PRIMARY KEY NOT NULL, approved_p bool, approved_date timestamptz, approved_user integer, approved_comment text(-5), file_size integer NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT download_ar_id_fk REFERENCES cr_revisions (), CONSTRAINT download_ar_id_pk REFERENCES cr_revisions (), CONSTRAINT download_ar_usr_fk REFERENCES cr_revisions (), CONSTRAINT download_ar_usr_fk REFERENCES users (), CONSTRAINT download_ar_id_fk REFERENCES users (), CONSTRAINT download_ar_id_pk REFERENCES users () ); CREATE INDEX download_at_rev_id ON download_archive_revisions (revision_id); CREATE TRIGGER RI_ConstraintTrigger_c_341579 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341580 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341584 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341585 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341617 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341618 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341657 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341658 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to download_archive_revisions: --download_downloads(download_ar_id_fk) --download_downloads(download_ar_id_pk) --download_downloads(download_ar_usr_fk) --download_revision_data(download_ar_id_fk) --download_revision_data(download_ar_id_pk) --download_revision_data(download_ar_usr_fk) -- Table size: 16,384 bytes -- Table rows: 184
Begin main content
