-- -- A mapping table that restricts the MIME types associated with a -- content type. -- CREATE TABLE cr_content_mime_type_map ( content_type varchar(1000) NOT NULL, mime_type varchar(200) NOT NULL, PRIMARY KEY (content_type,mime_type), CONSTRAINT cr_content_mime_map_ctyp_fk REFERENCES cr_mime_types (), CONSTRAINT cr_content_mime_map_pk REFERENCES cr_mime_types (), CONSTRAINT cr_content_mime_map_typ_fk REFERENCES cr_mime_types (), CONSTRAINT cr_content_mime_map_typ_fk REFERENCES acs_object_types (), CONSTRAINT cr_content_mime_map_ctyp_fk REFERENCES acs_object_types (), CONSTRAINT cr_content_mime_map_pk REFERENCES acs_object_types () ); CREATE INDEX cr_cont_mimetypmap_mimetyp_idx ON cr_content_mime_type_map (mime_type); CREATE TRIGGER RI_ConstraintTrigger_c_341244 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341245 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610591 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610592 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 31
Begin main content
