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