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