CREATE TABLE download_archives ( archive_id integer PRIMARY KEY NOT NULL, archive_type_id integer, archive_desc_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT download_archives_a_id_fk REFERENCES cr_items (), CONSTRAINT download_archives_a_id_pk REFERENCES cr_items (), CONSTRAINT download_archives_ad_id_fk REFERENCES cr_items (), CONSTRAINT download_archives_at_id_fk REFERENCES cr_items (), CONSTRAINT download_archives_at_id_fk REFERENCES cr_revisions (), CONSTRAINT download_archives_ad_id_fk REFERENCES cr_revisions (), CONSTRAINT download_archives_a_id_pk REFERENCES cr_revisions (), CONSTRAINT download_archives_a_id_fk REFERENCES cr_revisions (), CONSTRAINT download_archives_at_id_fk REFERENCES download_archive_types (), CONSTRAINT download_archives_a_id_fk REFERENCES download_archive_types (), CONSTRAINT download_archives_a_id_pk REFERENCES download_archive_types (), CONSTRAINT download_archives_ad_id_fk REFERENCES download_archive_types () ); CREATE INDEX download_archives_d_id ON download_archives (archive_desc_id); CREATE INDEX download_archives_t_id ON download_archives (archive_type_id); CREATE TRIGGER RI_ConstraintTrigger_c_341599 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341600 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341604 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341605 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341609 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341610 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 129
Begin main content
