--
-- Each content item has a row in this table, as well as a row in
-- the acs_objects table. The parent_id is used to place an
-- item in a directory or place it within another container item.
--
CREATE TABLE cr_items (
item_id integer PRIMARY KEY NOT NULL,
parent_id integer NOT NULL,
name varchar(400) NOT NULL,
locale varchar(4),
live_revision integer,
latest_revision integer,
publish_status varchar(40),
--
-- The content type constrains the type of revision that may be
-- added to this item (an item should have revisions of only one type).
-- If null, then no revisions should be allowed.
--
content_type varchar(1000),
storage_type cr_item_storage_type_enum DEFAULT 'text'::cr_item_storage_type_enum NOT NULL,
storage_area_key varchar(100) DEFAULT 'CR_FILES'::character varying NOT NULL,
tree_sortkey varbit(-5) NOT NULL,
max_child_sortkey varbit(-5),
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT cr_items_latest_revision_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_live_revision_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_item_id_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_locale_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_parent_id_ck REFERENCES acs_objects (),
CONSTRAINT cr_items_parent_id_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_pk REFERENCES acs_objects (),
CONSTRAINT cr_items_pub_status_chk REFERENCES acs_objects (),
CONSTRAINT cr_items_rev_type_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_storage_type REFERENCES acs_objects (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES acs_objects () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL,
CONSTRAINT cr_items_item_id_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_latest_revision_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_live_revision_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_locale_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_parent_id_ck REFERENCES cr_revisions (),
CONSTRAINT cr_items_parent_id_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_pk REFERENCES cr_revisions (),
CONSTRAINT cr_items_pub_status_chk REFERENCES cr_revisions (),
CONSTRAINT cr_items_rev_type_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_storage_type REFERENCES cr_revisions (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES cr_revisions () ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL ON DELETE SET NULL,
CONSTRAINT cr_items_live_revision_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_item_id_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_latest_revision_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_locale_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_parent_id_ck REFERENCES cr_revisions (),
CONSTRAINT cr_items_parent_id_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_pk REFERENCES cr_revisions (),
CONSTRAINT cr_items_pub_status_chk REFERENCES cr_revisions (),
CONSTRAINT cr_items_rev_type_fk REFERENCES cr_revisions (),
CONSTRAINT cr_items_storage_type REFERENCES cr_revisions (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES cr_revisions (),
CONSTRAINT cr_items_parent_id_fk REFERENCES cr_locales (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES cr_locales (),
CONSTRAINT cr_items_storage_type REFERENCES cr_locales (),
CONSTRAINT cr_items_rev_type_fk REFERENCES cr_locales (),
CONSTRAINT cr_items_pub_status_chk REFERENCES cr_locales (),
CONSTRAINT cr_items_pk REFERENCES cr_locales (),
CONSTRAINT cr_items_parent_id_ck REFERENCES cr_locales (),
CONSTRAINT cr_items_locale_fk REFERENCES cr_locales (),
CONSTRAINT cr_items_live_revision_fk REFERENCES cr_locales (),
CONSTRAINT cr_items_latest_revision_fk REFERENCES cr_locales (),
CONSTRAINT cr_items_item_id_fk REFERENCES cr_locales () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT cr_items_storage_type REFERENCES acs_objects (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES acs_objects (),
CONSTRAINT cr_items_rev_type_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_pub_status_chk REFERENCES acs_objects (),
CONSTRAINT cr_items_pk REFERENCES acs_objects (),
CONSTRAINT cr_items_parent_id_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_parent_id_ck REFERENCES acs_objects (),
CONSTRAINT cr_items_locale_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_live_revision_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_latest_revision_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_item_id_fk REFERENCES acs_objects (),
CONSTRAINT cr_items_tree_sortkey_un REFERENCES acs_object_types (),
CONSTRAINT cr_items_storage_type REFERENCES acs_object_types (),
CONSTRAINT cr_items_rev_type_fk REFERENCES acs_object_types (),
CONSTRAINT cr_items_pub_status_chk REFERENCES acs_object_types (),
CONSTRAINT cr_items_pk REFERENCES acs_object_types (),
CONSTRAINT cr_items_parent_id_fk REFERENCES acs_object_types (),
CONSTRAINT cr_items_parent_id_ck REFERENCES acs_object_types (),
CONSTRAINT cr_items_locale_fk REFERENCES acs_object_types (),
CONSTRAINT cr_items_live_revision_fk REFERENCES acs_object_types (),
CONSTRAINT cr_items_latest_revision_fk REFERENCES acs_object_types (),
CONSTRAINT cr_items_item_id_fk REFERENCES acs_object_types ()
);
CREATE INDEX cr_items_by_content_type ON cr_items (content_type);
CREATE UNIQUE INDEX cr_items_by_latest_revision ON cr_items (latest_revision);
CREATE UNIQUE INDEX cr_items_by_live_revision ON cr_items (live_revision);
CREATE INDEX cr_items_by_locale ON cr_items (locale);
CREATE INDEX cr_items_by_parent_id ON cr_items (parent_id);
CREATE INDEX cr_items_name ON cr_items (name);
CREATE UNIQUE INDEX cr_items_tree_sortkey_un ON cr_items (tree_sortkey);
CREATE UNIQUE INDEX cr_items_unique_id ON cr_items (parent_id, item_id);
CREATE UNIQUE INDEX cr_items_unique_name ON cr_items (parent_id, name);
CREATE TRIGGER content_item_search__utrg BEFORE UPDATE FOR EACH ROW EXECUTE PROCEDURE content_item_search__utrg (disabled)
CREATE TRIGGER cr_items_publish_update_tr BEFORE UPDATE FOR EACH ROW EXECUTE PROCEDURE cr_items_publish_update_tr (disabled)
CREATE TRIGGER cr_items_tree_insert_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE cr_items_tree_insert_tr (disabled)
CREATE TRIGGER cr_items_tree_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE cr_items_tree_update_tr (disabled)
CREATE TRIGGER cr_items_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE cr_items_update_tr (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340382 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340383 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340412 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340413 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340687 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340688 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340867 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340868 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341222 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341223 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341247 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341248 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341277 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341278 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341292 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341293 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341302 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341303 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341327 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341328 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341342 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341343 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341354 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341355 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341359 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341360 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341364 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341365 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341369 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341370 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341374 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341375 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341407 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341408 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341417 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341418 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341442 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341443 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341452 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341453 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341457 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341458 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341597 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341598 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341647 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341648 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342737 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342738 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342772 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342773 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342982 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342983 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343272 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343273 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343672 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343673 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343677 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343678 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343682 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343683 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343697 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343698 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343722 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343742 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343743 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343747 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343748 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343752 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343753 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343762 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343763 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343767 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343768 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322630 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322631 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322647 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322648 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343723 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_1610601 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_1610602 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Tables with foreign keys that refer to cr_items:
--acs_mail_multipart_parts(cr_items_item_id_fk)
--acs_mail_multipart_parts(cr_items_latest_revision_fk)
--acs_mail_multipart_parts(cr_items_live_revision_fk)
--acs_mail_multipart_parts(cr_items_locale_fk)
--acs_mail_multipart_parts(cr_items_parent_id_ck)
--acs_mail_multipart_parts(cr_items_parent_id_fk)
--acs_mail_multipart_parts(cr_items_pk)
--acs_mail_multipart_parts(cr_items_pub_status_chk)
--acs_mail_multipart_parts(cr_items_rev_type_fk)
--acs_mail_multipart_parts(cr_items_storage_type)
--acs_mail_multipart_parts(cr_items_tree_sortkey_un)
--acs_messages(cr_items_item_id_fk)
--acs_messages(cr_items_latest_revision_fk)
--acs_messages(cr_items_live_revision_fk)
--acs_messages(cr_items_locale_fk)
--acs_messages(cr_items_parent_id_ck)
--acs_messages(cr_items_parent_id_fk)
--acs_messages(cr_items_pk)
--acs_messages(cr_items_pub_status_chk)
--acs_messages(cr_items_rev_type_fk)
--acs_messages(cr_items_storage_type)
--acs_messages(cr_items_tree_sortkey_un)
--apm_package_versions(cr_items_item_id_fk)
--apm_package_versions(cr_items_latest_revision_fk)
--apm_package_versions(cr_items_live_revision_fk)
--apm_package_versions(cr_items_locale_fk)
--apm_package_versions(cr_items_parent_id_ck)
--apm_package_versions(cr_items_parent_id_fk)
--apm_package_versions(cr_items_pk)
--apm_package_versions(cr_items_pub_status_chk)
--apm_package_versions(cr_items_rev_type_fk)
--apm_package_versions(cr_items_storage_type)
--apm_package_versions(cr_items_tree_sortkey_un)
--bt_bugs(cr_items_item_id_fk)
--bt_bugs(cr_items_latest_revision_fk)
--bt_bugs(cr_items_live_revision_fk)
--bt_bugs(cr_items_locale_fk)
--bt_bugs(cr_items_parent_id_ck)
--bt_bugs(cr_items_parent_id_fk)
--bt_bugs(cr_items_pk)
--bt_bugs(cr_items_pub_status_chk)
--bt_bugs(cr_items_rev_type_fk)
--bt_bugs(cr_items_storage_type)
--bt_bugs(cr_items_tree_sortkey_un)
--cr_child_rels(cr_items_item_id_fk)
--cr_child_rels(cr_items_latest_revision_fk)
--cr_child_rels(cr_items_live_revision_fk)
--cr_child_rels(cr_items_locale_fk)
--cr_child_rels(cr_items_parent_id_ck)
--cr_child_rels(cr_items_parent_id_fk)
--cr_child_rels(cr_items_pk)
--cr_child_rels(cr_items_pub_status_chk)
--cr_child_rels(cr_items_rev_type_fk)
--cr_child_rels(cr_items_storage_type)
--cr_child_rels(cr_items_tree_sortkey_un)
--cr_extlinks(cr_items_item_id_fk)
--cr_extlinks(cr_items_latest_revision_fk)
--cr_extlinks(cr_items_live_revision_fk)
--cr_extlinks(cr_items_locale_fk)
--cr_extlinks(cr_items_parent_id_ck)
--cr_extlinks(cr_items_parent_id_fk)
--cr_extlinks(cr_items_pk)
--cr_extlinks(cr_items_pub_status_chk)
--cr_extlinks(cr_items_rev_type_fk)
--cr_extlinks(cr_items_storage_type)
--cr_extlinks(cr_items_tree_sortkey_un)
--cr_folders(cr_items_item_id_fk)
--cr_folders(cr_items_latest_revision_fk)
--cr_folders(cr_items_live_revision_fk)
--cr_folders(cr_items_locale_fk)
--cr_folders(cr_items_parent_id_ck)
--cr_folders(cr_items_parent_id_fk)
--cr_folders(cr_items_pk)
--cr_folders(cr_items_pub_status_chk)
--cr_folders(cr_items_rev_type_fk)
--cr_folders(cr_items_storage_type)
--cr_folders(cr_items_tree_sortkey_un)
--cr_item_keyword_map(cr_items_item_id_fk)
--cr_item_keyword_map(cr_items_latest_revision_fk)
--cr_item_keyword_map(cr_items_live_revision_fk)
--cr_item_keyword_map(cr_items_locale_fk)
--cr_item_keyword_map(cr_items_parent_id_ck)
--cr_item_keyword_map(cr_items_parent_id_fk)
--cr_item_keyword_map(cr_items_pk)
--cr_item_keyword_map(cr_items_pub_status_chk)
--cr_item_keyword_map(cr_items_rev_type_fk)
--cr_item_keyword_map(cr_items_storage_type)
--cr_item_keyword_map(cr_items_tree_sortkey_un)
--cr_item_publish_audit(cr_items_item_id_fk)
--cr_item_publish_audit(cr_items_latest_revision_fk)
--cr_item_publish_audit(cr_items_live_revision_fk)
--cr_item_publish_audit(cr_items_locale_fk)
--cr_item_publish_audit(cr_items_parent_id_ck)
--cr_item_publish_audit(cr_items_parent_id_fk)
--cr_item_publish_audit(cr_items_pk)
--cr_item_publish_audit(cr_items_pub_status_chk)
--cr_item_publish_audit(cr_items_rev_type_fk)
--cr_item_publish_audit(cr_items_storage_type)
--cr_item_publish_audit(cr_items_tree_sortkey_un)
--cr_item_rels(cr_items_item_id_fk)
--cr_item_rels(cr_items_latest_revision_fk)
--cr_item_rels(cr_items_live_revision_fk)
--cr_item_rels(cr_items_locale_fk)
--cr_item_rels(cr_items_parent_id_ck)
--cr_item_rels(cr_items_parent_id_fk)
--cr_item_rels(cr_items_pk)
--cr_item_rels(cr_items_pub_status_chk)
--cr_item_rels(cr_items_rev_type_fk)
--cr_item_rels(cr_items_storage_type)
--cr_item_rels(cr_items_tree_sortkey_un)
--cr_item_template_map(cr_items_item_id_fk)
--cr_item_template_map(cr_items_latest_revision_fk)
--cr_item_template_map(cr_items_live_revision_fk)
--cr_item_template_map(cr_items_locale_fk)
--cr_item_template_map(cr_items_parent_id_ck)
--cr_item_template_map(cr_items_parent_id_fk)
--cr_item_template_map(cr_items_pk)
--cr_item_template_map(cr_items_pub_status_chk)
--cr_item_template_map(cr_items_rev_type_fk)
--cr_item_template_map(cr_items_storage_type)
--cr_item_template_map(cr_items_tree_sortkey_un)
--cr_release_periods(cr_items_item_id_fk)
--cr_release_periods(cr_items_latest_revision_fk)
--cr_release_periods(cr_items_live_revision_fk)
--cr_release_periods(cr_items_locale_fk)
--cr_release_periods(cr_items_parent_id_ck)
--cr_release_periods(cr_items_parent_id_fk)
--cr_release_periods(cr_items_pk)
--cr_release_periods(cr_items_pub_status_chk)
--cr_release_periods(cr_items_rev_type_fk)
--cr_release_periods(cr_items_storage_type)
--cr_release_periods(cr_items_tree_sortkey_un)
--cr_revisions(cr_items_item_id_fk)
--cr_revisions(cr_items_latest_revision_fk)
--cr_revisions(cr_items_live_revision_fk)
--cr_revisions(cr_items_locale_fk)
--cr_revisions(cr_items_parent_id_ck)
--cr_revisions(cr_items_parent_id_fk)
--cr_revisions(cr_items_pk)
--cr_revisions(cr_items_pub_status_chk)
--cr_revisions(cr_items_rev_type_fk)
--cr_revisions(cr_items_storage_type)
--cr_revisions(cr_items_tree_sortkey_un)
--cr_symlinks(cr_items_item_id_fk)
--cr_symlinks(cr_items_latest_revision_fk)
--cr_symlinks(cr_items_live_revision_fk)
--cr_symlinks(cr_items_locale_fk)
--cr_symlinks(cr_items_parent_id_ck)
--cr_symlinks(cr_items_parent_id_fk)
--cr_symlinks(cr_items_pk)
--cr_symlinks(cr_items_pub_status_chk)
--cr_symlinks(cr_items_rev_type_fk)
--cr_symlinks(cr_items_storage_type)
--cr_symlinks(cr_items_tree_sortkey_un)
--cr_templates(cr_items_item_id_fk)
--cr_templates(cr_items_latest_revision_fk)
--cr_templates(cr_items_live_revision_fk)
--cr_templates(cr_items_locale_fk)
--cr_templates(cr_items_parent_id_ck)
--cr_templates(cr_items_parent_id_fk)
--cr_templates(cr_items_pk)
--cr_templates(cr_items_pub_status_chk)
--cr_templates(cr_items_rev_type_fk)
--cr_templates(cr_items_storage_type)
--cr_templates(cr_items_tree_sortkey_un)
--download_archives(cr_items_item_id_fk)
--download_archives(cr_items_latest_revision_fk)
--download_archives(cr_items_live_revision_fk)
--download_archives(cr_items_locale_fk)
--download_archives(cr_items_parent_id_ck)
--download_archives(cr_items_parent_id_fk)
--download_archives(cr_items_pk)
--download_archives(cr_items_pub_status_chk)
--download_archives(cr_items_rev_type_fk)
--download_archives(cr_items_storage_type)
--download_archives(cr_items_tree_sortkey_un)
--download_repository(cr_items_item_id_fk)
--download_repository(cr_items_latest_revision_fk)
--download_repository(cr_items_live_revision_fk)
--download_repository(cr_items_locale_fk)
--download_repository(cr_items_parent_id_ck)
--download_repository(cr_items_parent_id_fk)
--download_repository(cr_items_pk)
--download_repository(cr_items_pub_status_chk)
--download_repository(cr_items_rev_type_fk)
--download_repository(cr_items_storage_type)
--download_repository(cr_items_tree_sortkey_un)
--pa_albums(cr_items_item_id_fk)
--pa_albums(cr_items_latest_revision_fk)
--pa_albums(cr_items_live_revision_fk)
--pa_albums(cr_items_locale_fk)
--pa_albums(cr_items_parent_id_ck)
--pa_albums(cr_items_parent_id_fk)
--pa_albums(cr_items_pk)
--pa_albums(cr_items_pub_status_chk)
--pa_albums(cr_items_rev_type_fk)
--pa_albums(cr_items_storage_type)
--pa_albums(cr_items_tree_sortkey_un)
--pa_collection_photo_map(cr_items_item_id_fk)
--pa_collection_photo_map(cr_items_latest_revision_fk)
--pa_collection_photo_map(cr_items_live_revision_fk)
--pa_collection_photo_map(cr_items_locale_fk)
--pa_collection_photo_map(cr_items_parent_id_ck)
--pa_collection_photo_map(cr_items_parent_id_fk)
--pa_collection_photo_map(cr_items_pk)
--pa_collection_photo_map(cr_items_pub_status_chk)
--pa_collection_photo_map(cr_items_rev_type_fk)
--pa_collection_photo_map(cr_items_storage_type)
--pa_collection_photo_map(cr_items_tree_sortkey_un)
--static_pages(cr_items_item_id_fk)
--static_pages(cr_items_latest_revision_fk)
--static_pages(cr_items_live_revision_fk)
--static_pages(cr_items_locale_fk)
--static_pages(cr_items_parent_id_ck)
--static_pages(cr_items_parent_id_fk)
--static_pages(cr_items_pk)
--static_pages(cr_items_pub_status_chk)
--static_pages(cr_items_rev_type_fk)
--static_pages(cr_items_storage_type)
--static_pages(cr_items_tree_sortkey_un)
--workflow_case_log(cr_items_item_id_fk)
--workflow_case_log(cr_items_latest_revision_fk)
--workflow_case_log(cr_items_live_revision_fk)
--workflow_case_log(cr_items_locale_fk)
--workflow_case_log(cr_items_parent_id_ck)
--workflow_case_log(cr_items_parent_id_fk)
--workflow_case_log(cr_items_pk)
--workflow_case_log(cr_items_pub_status_chk)
--workflow_case_log(cr_items_rev_type_fk)
--workflow_case_log(cr_items_storage_type)
--workflow_case_log(cr_items_tree_sortkey_un)
--xooauth_credentials(cr_items_item_id_fk)
--xooauth_credentials(cr_items_latest_revision_fk)
--xooauth_credentials(cr_items_live_revision_fk)
--xooauth_credentials(cr_items_locale_fk)
--xooauth_credentials(cr_items_parent_id_ck)
--xooauth_credentials(cr_items_parent_id_fk)
--xooauth_credentials(cr_items_pk)
--xooauth_credentials(cr_items_pub_status_chk)
--xooauth_credentials(cr_items_rev_type_fk)
--xooauth_credentials(cr_items_storage_type)
--xooauth_credentials(cr_items_tree_sortkey_un)
--xowiki_form_instance_item_index(cr_items_item_id_fk)
--xowiki_form_instance_item_index(cr_items_latest_revision_fk)
--xowiki_form_instance_item_index(cr_items_live_revision_fk)
--xowiki_form_instance_item_index(cr_items_locale_fk)
--xowiki_form_instance_item_index(cr_items_parent_id_ck)
--xowiki_form_instance_item_index(cr_items_parent_id_fk)
--xowiki_form_instance_item_index(cr_items_pk)
--xowiki_form_instance_item_index(cr_items_pub_status_chk)
--xowiki_form_instance_item_index(cr_items_rev_type_fk)
--xowiki_form_instance_item_index(cr_items_storage_type)
--xowiki_form_instance_item_index(cr_items_tree_sortkey_un)
--xowiki_last_visited(cr_items_item_id_fk)
--xowiki_last_visited(cr_items_latest_revision_fk)
--xowiki_last_visited(cr_items_live_revision_fk)
--xowiki_last_visited(cr_items_locale_fk)
--xowiki_last_visited(cr_items_parent_id_ck)
--xowiki_last_visited(cr_items_parent_id_fk)
--xowiki_last_visited(cr_items_pk)
--xowiki_last_visited(cr_items_pub_status_chk)
--xowiki_last_visited(cr_items_rev_type_fk)
--xowiki_last_visited(cr_items_storage_type)
--xowiki_last_visited(cr_items_tree_sortkey_un)
--xowiki_page_instance(cr_items_item_id_fk)
--xowiki_page_instance(cr_items_latest_revision_fk)
--xowiki_page_instance(cr_items_live_revision_fk)
--xowiki_page_instance(cr_items_locale_fk)
--xowiki_page_instance(cr_items_parent_id_ck)
--xowiki_page_instance(cr_items_parent_id_fk)
--xowiki_page_instance(cr_items_pk)
--xowiki_page_instance(cr_items_pub_status_chk)
--xowiki_page_instance(cr_items_rev_type_fk)
--xowiki_page_instance(cr_items_storage_type)
--xowiki_page_instance(cr_items_tree_sortkey_un)
--xowiki_references(cr_items_item_id_fk)
--xowiki_references(cr_items_latest_revision_fk)
--xowiki_references(cr_items_live_revision_fk)
--xowiki_references(cr_items_locale_fk)
--xowiki_references(cr_items_parent_id_ck)
--xowiki_references(cr_items_parent_id_fk)
--xowiki_references(cr_items_pk)
--xowiki_references(cr_items_pub_status_chk)
--xowiki_references(cr_items_rev_type_fk)
--xowiki_references(cr_items_storage_type)
--xowiki_references(cr_items_tree_sortkey_un)
--xowiki_tags(cr_items_item_id_fk)
--xowiki_tags(cr_items_latest_revision_fk)
--xowiki_tags(cr_items_live_revision_fk)
--xowiki_tags(cr_items_locale_fk)
--xowiki_tags(cr_items_parent_id_ck)
--xowiki_tags(cr_items_parent_id_fk)
--xowiki_tags(cr_items_pk)
--xowiki_tags(cr_items_pub_status_chk)
--xowiki_tags(cr_items_rev_type_fk)
--xowiki_tags(cr_items_storage_type)
--xowiki_tags(cr_items_tree_sortkey_un)
--xowiki_unresolved_references(cr_items_item_id_fk)
--xowiki_unresolved_references(cr_items_latest_revision_fk)
--xowiki_unresolved_references(cr_items_live_revision_fk)
--xowiki_unresolved_references(cr_items_locale_fk)
--xowiki_unresolved_references(cr_items_parent_id_ck)
--xowiki_unresolved_references(cr_items_parent_id_fk)
--xowiki_unresolved_references(cr_items_pk)
--xowiki_unresolved_references(cr_items_pub_status_chk)
--xowiki_unresolved_references(cr_items_rev_type_fk)
--xowiki_unresolved_references(cr_items_storage_type)
--xowiki_unresolved_references(cr_items_tree_sortkey_un)
-- Table size: 4,628,480 bytes
-- Table rows: 34,592
Tables: