-- -- Each content item may be associated with any number of revisions. -- The item_id is used to associate revisions with an item. -- CREATE TABLE cr_revisions ( revision_id integer PRIMARY KEY NOT NULL, item_id integer NOT NULL, title varchar(1000), description text(-5), publish_date timestamptz, mime_type varchar(200) DEFAULT 'text/plain'::character varying, -- -- NLS_LANGUAGE is required in the same table as the content column -- for multi-lingual searching in Intermedia. -- nls_language varchar(50) DEFAULT 'en_US'::character varying, lob integer, content text(-5), content_length integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_revisions_lob_fk REFERENCES cr_items (), CONSTRAINT cr_revisions_mime_type_ref REFERENCES cr_items (), CONSTRAINT cr_revisions_rev_id_fk REFERENCES cr_items (), CONSTRAINT cr_revisions_item_id_fk REFERENCES cr_items (), CONSTRAINT cr_revisions_pk REFERENCES cr_items () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL, CONSTRAINT cr_revisions_mime_type_ref REFERENCES lobs (), CONSTRAINT cr_revisions_item_id_fk REFERENCES lobs (), CONSTRAINT cr_revisions_lob_fk REFERENCES lobs (), CONSTRAINT cr_revisions_pk REFERENCES lobs (), CONSTRAINT cr_revisions_rev_id_fk REFERENCES lobs (), CONSTRAINT cr_revisions_rev_id_fk REFERENCES cr_mime_types (), CONSTRAINT cr_revisions_pk REFERENCES cr_mime_types (), CONSTRAINT cr_revisions_mime_type_ref REFERENCES cr_mime_types (), CONSTRAINT cr_revisions_lob_fk REFERENCES cr_mime_types (), CONSTRAINT cr_revisions_item_id_fk REFERENCES cr_mime_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_revisions_rev_id_fk REFERENCES acs_objects (), CONSTRAINT cr_revisions_item_id_fk REFERENCES acs_objects (), CONSTRAINT cr_revisions_lob_fk REFERENCES acs_objects (), CONSTRAINT cr_revisions_mime_type_ref REFERENCES acs_objects (), CONSTRAINT cr_revisions_pk REFERENCES acs_objects () ); CREATE INDEX cr_revisions_by_mime_type ON cr_revisions (mime_type); CREATE INDEX cr_revisions_content_idx ON cr_revisions (); CREATE INDEX cr_revisions_item_id_idx ON cr_revisions (item_id); CREATE INDEX cr_revisions_lob_idx ON cr_revisions (lob); CREATE INDEX cr_revisions_publish_date_idx ON cr_revisions (publish_date); CREATE INDEX cr_revisions_title_idx ON cr_revisions (title); CREATE TRIGGER content_search__itrg AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE content_search__itrg (disabled) CREATE TRIGGER content_search__utrg AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE content_search__utrg (disabled) CREATE TRIGGER cr_cleanup_cr_files_del_tr BEFORE DELETE FOR EACH ROW EXECUTE PROCEDURE cr_cleanup_cr_files_del_tr (disabled) CREATE TRIGGER cr_revision_latest_tr AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE cr_revision_latest_tr (disabled) CREATE TRIGGER cr_revisions_lob_trig AFTER INSERT OR DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE on_lob_ref (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340222 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340223 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340227 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340228 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340872 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340873 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341252 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341253 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341282 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341283 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341307 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341308 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341312 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341313 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341357 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341358 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341362 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341363 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341397 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341398 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341412 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341413 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341419 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341420 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341424 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341425 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341434 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341435 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341439 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341440 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341507 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341508 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341512 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341513 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341517 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341518 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341527 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341528 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341532 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341533 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341537 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341538 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341542 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341543 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341577 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341578 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341587 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341588 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341602 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341603 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342357 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342358 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342532 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342533 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342742 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342743 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342777 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342778 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343057 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343058 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343712 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343713 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322503 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322504 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322564 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322565 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322586 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_1322587 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to cr_revisions: --bt_bug_revisions(cr_revisions_item_id_fk) --bt_bug_revisions(cr_revisions_lob_fk) --bt_bug_revisions(cr_revisions_mime_type_ref) --bt_bug_revisions(cr_revisions_pk) --bt_bug_revisions(cr_revisions_rev_id_fk) --btbug_revisions(cr_revisions_item_id_fk) --btbug_revisions(cr_revisions_lob_fk) --btbug_revisions(cr_revisions_mime_type_ref) --btbug_revisions(cr_revisions_pk) --btbug_revisions(cr_revisions_rev_id_fk) --cr_item_publish_audit(cr_revisions_item_id_fk) --cr_item_publish_audit(cr_revisions_lob_fk) --cr_item_publish_audit(cr_revisions_mime_type_ref) --cr_item_publish_audit(cr_revisions_pk) --cr_item_publish_audit(cr_revisions_rev_id_fk) --cr_items(cr_revisions_item_id_fk) --cr_items(cr_revisions_lob_fk) --cr_items(cr_revisions_mime_type_ref) --cr_items(cr_revisions_pk) --cr_items(cr_revisions_rev_id_fk) --cr_news(cr_revisions_item_id_fk) --cr_news(cr_revisions_lob_fk) --cr_news(cr_revisions_mime_type_ref) --cr_news(cr_revisions_pk) --cr_news(cr_revisions_rev_id_fk) --cr_revision_attributes(cr_revisions_item_id_fk) --cr_revision_attributes(cr_revisions_lob_fk) --cr_revision_attributes(cr_revisions_mime_type_ref) --cr_revision_attributes(cr_revisions_pk) --cr_revision_attributes(cr_revisions_rev_id_fk) --cr_wp_file_attachments(cr_revisions_item_id_fk) --cr_wp_file_attachments(cr_revisions_lob_fk) --cr_wp_file_attachments(cr_revisions_mime_type_ref) --cr_wp_file_attachments(cr_revisions_pk) --cr_wp_file_attachments(cr_revisions_rev_id_fk) --cr_wp_image_attachments(cr_revisions_item_id_fk) --cr_wp_image_attachments(cr_revisions_lob_fk) --cr_wp_image_attachments(cr_revisions_mime_type_ref) --cr_wp_image_attachments(cr_revisions_pk) --cr_wp_image_attachments(cr_revisions_rev_id_fk) --cr_wp_presentations(cr_revisions_item_id_fk) --cr_wp_presentations(cr_revisions_lob_fk) --cr_wp_presentations(cr_revisions_mime_type_ref) --cr_wp_presentations(cr_revisions_pk) --cr_wp_presentations(cr_revisions_rev_id_fk) --cr_wp_presentations_aud(cr_revisions_item_id_fk) --cr_wp_presentations_aud(cr_revisions_lob_fk) --cr_wp_presentations_aud(cr_revisions_mime_type_ref) --cr_wp_presentations_aud(cr_revisions_pk) --cr_wp_presentations_aud(cr_revisions_rev_id_fk) --cr_wp_presentations_back(cr_revisions_item_id_fk) --cr_wp_presentations_back(cr_revisions_lob_fk) --cr_wp_presentations_back(cr_revisions_mime_type_ref) --cr_wp_presentations_back(cr_revisions_pk) --cr_wp_presentations_back(cr_revisions_rev_id_fk) --cr_wp_slides(cr_revisions_item_id_fk) --cr_wp_slides(cr_revisions_lob_fk) --cr_wp_slides(cr_revisions_mime_type_ref) --cr_wp_slides(cr_revisions_pk) --cr_wp_slides(cr_revisions_rev_id_fk) --cr_wp_slides_bullet_items(cr_revisions_item_id_fk) --cr_wp_slides_bullet_items(cr_revisions_lob_fk) --cr_wp_slides_bullet_items(cr_revisions_mime_type_ref) --cr_wp_slides_bullet_items(cr_revisions_pk) --cr_wp_slides_bullet_items(cr_revisions_rev_id_fk) --cr_wp_slides_postamble(cr_revisions_item_id_fk) --cr_wp_slides_postamble(cr_revisions_lob_fk) --cr_wp_slides_postamble(cr_revisions_mime_type_ref) --cr_wp_slides_postamble(cr_revisions_pk) --cr_wp_slides_postamble(cr_revisions_rev_id_fk) --cr_wp_slides_preamble(cr_revisions_item_id_fk) --cr_wp_slides_preamble(cr_revisions_lob_fk) --cr_wp_slides_preamble(cr_revisions_mime_type_ref) --cr_wp_slides_preamble(cr_revisions_pk) --cr_wp_slides_preamble(cr_revisions_rev_id_fk) --download_archive_descs(cr_revisions_item_id_fk) --download_archive_descs(cr_revisions_lob_fk) --download_archive_descs(cr_revisions_mime_type_ref) --download_archive_descs(cr_revisions_pk) --download_archive_descs(cr_revisions_rev_id_fk) --download_archive_revisions(cr_revisions_item_id_fk) --download_archive_revisions(cr_revisions_lob_fk) --download_archive_revisions(cr_revisions_mime_type_ref) --download_archive_revisions(cr_revisions_pk) --download_archive_revisions(cr_revisions_rev_id_fk) --download_archives(cr_revisions_item_id_fk) --download_archives(cr_revisions_lob_fk) --download_archives(cr_revisions_mime_type_ref) --download_archives(cr_revisions_pk) --download_archives(cr_revisions_rev_id_fk) --etp_page_revisions(cr_revisions_item_id_fk) --etp_page_revisions(cr_revisions_lob_fk) --etp_page_revisions(cr_revisions_mime_type_ref) --etp_page_revisions(cr_revisions_pk) --etp_page_revisions(cr_revisions_rev_id_fk) --images(cr_revisions_item_id_fk) --images(cr_revisions_lob_fk) --images(cr_revisions_mime_type_ref) --images(cr_revisions_pk) --images(cr_revisions_rev_id_fk) --pa_albums(cr_revisions_item_id_fk) --pa_albums(cr_revisions_lob_fk) --pa_albums(cr_revisions_mime_type_ref) --pa_albums(cr_revisions_pk) --pa_albums(cr_revisions_rev_id_fk) --pa_photos(cr_revisions_item_id_fk) --pa_photos(cr_revisions_lob_fk) --pa_photos(cr_revisions_mime_type_ref) --pa_photos(cr_revisions_pk) --pa_photos(cr_revisions_rev_id_fk) --users_email_image(cr_revisions_item_id_fk) --users_email_image(cr_revisions_lob_fk) --users_email_image(cr_revisions_mime_type_ref) --users_email_image(cr_revisions_pk) --users_email_image(cr_revisions_rev_id_fk) --workflow_case_log_rev(cr_revisions_item_id_fk) --workflow_case_log_rev(cr_revisions_lob_fk) --workflow_case_log_rev(cr_revisions_mime_type_ref) --workflow_case_log_rev(cr_revisions_pk) --workflow_case_log_rev(cr_revisions_rev_id_fk) --xooauth_client_metadata(cr_revisions_item_id_fk) --xooauth_client_metadata(cr_revisions_lob_fk) --xooauth_client_metadata(cr_revisions_mime_type_ref) --xooauth_client_metadata(cr_revisions_pk) --xooauth_client_metadata(cr_revisions_rev_id_fk) --xooauth_credentials(cr_revisions_item_id_fk) --xooauth_credentials(cr_revisions_lob_fk) --xooauth_credentials(cr_revisions_mime_type_ref) --xooauth_credentials(cr_revisions_pk) --xooauth_credentials(cr_revisions_rev_id_fk) --xooauth_server_metadata(cr_revisions_item_id_fk) --xooauth_server_metadata(cr_revisions_lob_fk) --xooauth_server_metadata(cr_revisions_mime_type_ref) --xooauth_server_metadata(cr_revisions_pk) --xooauth_server_metadata(cr_revisions_rev_id_fk) --xowiki_page(cr_revisions_item_id_fk) --xowiki_page(cr_revisions_lob_fk) --xowiki_page(cr_revisions_mime_type_ref) --xowiki_page(cr_revisions_pk) --xowiki_page(cr_revisions_rev_id_fk) -- Table size: 18,489,344 bytes -- Table rows: 53,134
Begin main content
