View: nornix_system.vmimetypes
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | NO | | 0 | | |
|---|
| Name | varchar(48) | NO | | | | |
|---|
| Description | varchar(255) | YES | | | | |
|---|
| Category | varchar(48) | YES | | | | |
|---|
| Extensions | varchar(341) | YES | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | NO |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mt | ALL | | | | 24 | Using temporary; Using filesort |
| 1 | SIMPLE | me | ALL | | | | 32 | |
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`)