View: nornix_system.vxhtmlcontenttypes
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | int(10) unsigned | YES | | 0 | | |
|---|
| Name | varchar(64) | YES | | | | |
|---|
| Description | varchar(255) | YES | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | documenttype | ALL | PRIMARY | | | 3 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | docconttype | ref | DocCont | DocCont | nornix_system.documenttype.No | 9 | Using index |
| 1 | SIMPLE | contenttype | eq_ref | PRIMARY | PRIMARY | nornix_system.docconttype.ContentTypeNo | 1 | Using where |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `vxhtmlcontenttypes` AS
(select `contenttype`.`No` AS `No`,
`contenttype`.`Name` AS `Name`,
`nornix_system`.`get_description`(`contenttype`.`DescNo`)
AS `Description`
from (`docconttype` left join (`documenttype` join `contenttype`)
on (((`documenttype`.`No` = `docconttype`.`DocumentTypeNo`)
and (`contenttype`.`No` = `docconttype`.`ContentTypeNo`))))
where (`documenttype`.`Name` = _utf8'XHTML')
order by `contenttype`.`No`)