-- -- Folders are used to support a virtual file system within the content -- repository. -- CREATE TABLE cr_folders ( folder_id integer PRIMARY KEY NOT NULL, label varchar(1000), description text(-5), has_child_folders bool DEFAULT false, has_child_symlinks bool DEFAULT false, package_id integer, CONSTRAINT cr_flder_pkg_id_fk REFERENCES apm_packages (), CONSTRAINT cr_folders_folder_id_fk REFERENCES apm_packages (), CONSTRAINT cr_folders_pk REFERENCES apm_packages () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_folders_pk REFERENCES cr_items (), CONSTRAINT cr_flder_pkg_id_fk REFERENCES cr_items (), CONSTRAINT cr_folders_folder_id_fk REFERENCES cr_items () ); CREATE INDEX cr_folders_package_id_idx ON cr_folders (package_id); CREATE TRIGGER RI_ConstraintTrigger_a_340977 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340978 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341259 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341260 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341267 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341268 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341279 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341280 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341567 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341568 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342422 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342423 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342437 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342438 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342442 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342443 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342762 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342763 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342962 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342963 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to cr_folders: --bt_projects(cr_flder_pkg_id_fk) --bt_projects(cr_folders_folder_id_fk) --bt_projects(cr_folders_pk) --cr_folder_type_map(cr_flder_pkg_id_fk) --cr_folder_type_map(cr_folders_folder_id_fk) --cr_folder_type_map(cr_folders_pk) --dav_site_node_folder_map(cr_flder_pkg_id_fk) --dav_site_node_folder_map(cr_folders_folder_id_fk) --dav_site_node_folder_map(cr_folders_pk) --fs_root_folders(cr_flder_pkg_id_fk) --fs_root_folders(cr_folders_folder_id_fk) --fs_root_folders(cr_folders_pk) --fs_rss_subscrs(cr_flder_pkg_id_fk) --fs_rss_subscrs(cr_folders_folder_id_fk) --fs_rss_subscrs(cr_folders_pk) --fs_simple_objects(cr_flder_pkg_id_fk) --fs_simple_objects(cr_folders_folder_id_fk) --fs_simple_objects(cr_folders_pk) --pa_package_root_folder_map(cr_flder_pkg_id_fk) --pa_package_root_folder_map(cr_folders_folder_id_fk) --pa_package_root_folder_map(cr_folders_pk) --sp_folders(cr_flder_pkg_id_fk) --sp_folders(cr_folders_folder_id_fk) --sp_folders(cr_folders_pk) -- Table size: 24,576 bytes -- Table rows: 334
Begin main content
