CREATE TABLE download_downloads ( download_id integer PRIMARY KEY NOT NULL, user_id integer, revision_id integer, download_date timestamptz NOT NULL, download_hostname varchar(400), download_ip varchar(40), user_agent varchar(500), reason_id integer, reason text(-5), ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT download_downloads_id_pk REFERENCES download_reasons (), CONSTRAINT download_downloads_reason_fl REFERENCES download_reasons (), CONSTRAINT download_downloads_rev_fk REFERENCES download_reasons (), CONSTRAINT download_downloads_user_fk REFERENCES download_reasons () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT download_downloads_user_fk REFERENCES download_archive_revisions (), CONSTRAINT download_downloads_rev_fk REFERENCES download_archive_revisions (), CONSTRAINT download_downloads_reason_fl REFERENCES download_archive_revisions (), CONSTRAINT download_downloads_id_pk REFERENCES download_archive_revisions () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT download_downloads_user_fk REFERENCES users (), CONSTRAINT download_downloads_id_pk REFERENCES users (), CONSTRAINT download_downloads_reason_fl REFERENCES users (), CONSTRAINT download_downloads_rev_fk REFERENCES users () ); CREATE INDEX download_downloads_date_idx ON download_downloads (download_date); CREATE INDEX download_downloads_reason_id_idx ON download_downloads (reason_id); CREATE INDEX download_downloads_rev_id ON download_downloads (revision_id); CREATE INDEX download_downloads_user_id_idx ON download_downloads (user_id); CREATE TRIGGER RI_ConstraintTrigger_c_341614 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341615 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341619 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341620 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341624 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341625 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 158,466,048 bytes -- Table rows: 1.094802e+06
Begin main content
