CREATE TABLE attachments_fs_root_folder_map ( package_id integer NOT NULL, folder_id integer NOT NULL, PRIMARY KEY (package_id,folder_id), CONSTRAINT attach_fldr_map_folder_id_fk REFERENCES fs_root_folders (), CONSTRAINT attach_fldr_map_package_id_fk REFERENCES fs_root_folders (), CONSTRAINT attach_fldr_map_package_id_un REFERENCES fs_root_folders (), CONSTRAINT attach_fldr_map_pk REFERENCES fs_root_folders (), CONSTRAINT attach_fldr_map_pk REFERENCES apm_packages (), CONSTRAINT attach_fldr_map_folder_id_fk REFERENCES apm_packages (), CONSTRAINT attach_fldr_map_package_id_fk REFERENCES apm_packages (), CONSTRAINT attach_fldr_map_package_id_un REFERENCES apm_packages () ); CREATE UNIQUE INDEX attach_fldr_map_package_id_un ON attachments_fs_root_folder_map (package_id); CREATE INDEX attachments_fsr_fm_folder_id_i ON attachments_fs_root_folder_map (folder_id); CREATE TRIGGER RI_ConstraintTrigger_c_340759 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340760 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340764 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340765 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
OpenACS – The Toolkit for Online Communities : Schema Browser : Table: attachments_fs_root_folder_map
Begin main content
