CREATE TABLE fs_root_folders ( package_id integer PRIMARY KEY NOT NULL, folder_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT fs_root_folder_folder_id_fk REFERENCES cr_folders (), CONSTRAINT fs_root_folder_package_id_fk REFERENCES cr_folders (), CONSTRAINT fs_root_folder_package_id_pk REFERENCES cr_folders () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT fs_root_folder_package_id_pk REFERENCES apm_packages (), CONSTRAINT fs_root_folder_folder_id_fk REFERENCES apm_packages (), CONSTRAINT fs_root_folder_package_id_fk REFERENCES apm_packages () ); CREATE UNIQUE INDEX fs_root_folder_folder_id_un ON fs_root_folders (folder_id); CREATE TRIGGER fs_package_items_delete_trig BEFORE DELETE FOR EACH ROW EXECUTE PROCEDURE fs_package_items_delete_trig (disabled) CREATE TRIGGER fs_root_folder_delete_trig AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE fs_root_folder_delete_trig (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340757 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340758 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342424 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342425 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342429 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342430 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to fs_root_folders: --attachments_fs_root_folder_map(fs_root_folder_folder_id_fk) --attachments_fs_root_folder_map(fs_root_folder_package_id_fk) --attachments_fs_root_folder_map(fs_root_folder_package_id_pk) -- Table size: 8,192 bytes -- Table rows: 2
Begin main content
