-- -- Table to keep track of root folder for each instance of the photo-album -- Used for sub-site support. Each instance of the photo album has a unique -- root folder. All folders, pa_albums, pa_photos, and images within the -- package instance are descendants of the root folder. -- The one-to-one mapping is done using this table to avoid adding a column to the apm_packages -- that pertains only to the photo-album. -- CREATE TABLE pa_package_root_folder_map ( package_id integer PRIMARY KEY NOT NULL, folder_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_pack_fldr_map_fldr_id_fk REFERENCES cr_folders (), CONSTRAINT pa_pack_fldr_map_fldr_id_unq REFERENCES cr_folders (), CONSTRAINT pa_pack_fldr_map_pack_id_fk REFERENCES cr_folders (), CONSTRAINT pa_pack_fldr_map_pk REFERENCES cr_folders () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_pack_fldr_map_pk REFERENCES apm_packages (), CONSTRAINT pa_pack_fldr_map_fldr_id_fk REFERENCES apm_packages (), CONSTRAINT pa_pack_fldr_map_fldr_id_unq REFERENCES apm_packages (), CONSTRAINT pa_pack_fldr_map_pack_id_fk REFERENCES apm_packages () ); CREATE UNIQUE INDEX pa_pack_fldr_map_fldr_id_unq ON pa_package_root_folder_map (folder_id); CREATE INDEX pa_package_folder_map_by_pack ON pa_package_root_folder_map (package_id, folder_id); CREATE TRIGGER RI_ConstraintTrigger_c_342764 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342765 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342769 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342770 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 2
Begin main content
