-- -- a mapping table for extension to mime_type in db version of ns_guesstype data -- CREATE TABLE cr_extension_mime_type_map ( extension varchar(200) PRIMARY KEY NOT NULL, mime_type varchar(200), CONSTRAINT cr_mime_ext_map_mime_type_ref REFERENCES cr_mime_types (), CONSTRAINT cr_mime_type_extension_map_pk REFERENCES cr_mime_types () ); CREATE INDEX cr_extension_mime_type_map_idx ON cr_extension_mime_type_map (mime_type); CREATE TRIGGER RI_ConstraintTrigger_c_341389 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341390 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 24,576 bytes -- Table rows: 332
Begin main content
