View: nornix_site.vsiteresourcelist
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Id | varbinary(254) | YES | | | | |
|---|
| Name | varchar(80) | NO | | | | |
|---|
| MimeType | varchar(48) | NO | | | | |
|---|
| MimeTypeDescription | varchar(255) | YES | | | | |
|---|
| Width | int(11) unsigned | NO | | 0 | | |
|---|
| Height | int(11) unsigned | NO | | 0 | | |
|---|
| Description | varchar(127) | NO | | | | |
|---|
| Handler | varchar(64) | YES | | | | |
|---|
| Len | bigint(10) | NO | | 0 | | |
|---|
| Icon | varchar(48) | NO | | | | |
|---|
| Extension | varchar(12) | NO | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | sr | ALL | | | | 8 | Using temporary; Using filesort |
| 1 | SIMPLE | ct | eq_ref | PRIMARY | PRIMARY | nornix_site.sr.ContentTypeNo | 1 | |
| 1 | SIMPLE | mt | eq_ref | PRIMARY | PRIMARY | nornix_site.sr.MimeTypeNo | 1 | |
| 1 | SIMPLE | me | ALL | | | | 32 | Using where |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `nornix_site`.`vsiteresourcelist` AS
(select concat_ws(_utf8'|',
`sr`.`Name`,
`mt`.`No`)
AS `Id`,
`sr`.`Name` AS `Name`,
`mt`.`Name` AS `MimeType`,
`nornix_system`.`get_description`(`mt`.`DescNo`)
AS `MimeTypeDescription`,
`sr`.`Width` AS `Width`,
`sr`.`Height` AS `Height`,
`sr`.`Description` AS `Description`,
coalesce(`ct`.`Handler`,
_utf8'ContentTypeBinary')
AS `Handler`,
length(`sr`.`Data`)
AS `Len`,
`mt`.`Icon` AS `Icon`,
`me`.`Extension` AS `Extension`
from (((`nornix_site`.`siteresource` `sr` join `nornix_system`.`mimetype` `mt` on ((`mt`.`No` =
`sr`.`MimeTypeNo`)))
left join `nornix_system`.`contenttype` `ct` on ((`sr`.`ContentTypeNo` = `ct`.`No`)))
join `nornix_system`.`mimeextension` `me` on ((`me`.`MimeTypeNo` = `sr`.`MimeTypeNo`)))
order by `sr`.`Name`,
`mt`.`Name`)