View: nornix_system.vmimetypes

Structure
NameTypeNullKeyDefaultExtraComment
Noint(10) unsignedNO0
Namevarchar(48)NO
Descriptionvarchar(255)YES
Categoryvarchar(48)YES
Extensionsvarchar(341)YES
Information
AlgoritmUpdateable
UNDEFINED NO
Explain
IdSelect typeTableTypePossible keysKeyRefRowsExtra
1SIMPLEmtALL24Using temporary; Using filesort
1SIMPLEmeALL32
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER 
VIEW `vmimetypes` AS 
(select `mt`.`No` AS `No`,
`mt`.`Name` AS `Name`,
`nornix_system`.`get_description`(`mt`.`DescNo`)
AS `Description`,
substring_index(`mt`.`Name`,
_utf8'/',
1)
AS `Category`,
group_concat(`me`.`Extension` separator ',
')
AS `Extensions` 
from (`mimetype` `mt` left join `mimeextension` `me` on ((`mt`.`No` = `me`.`MimeTypeNo`)))
group by `mt`.`No` order by `mt`.`Name`)