View: nornix_site.vlayoutlist
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| No | smallint(6) | NO | | 0 | | |
|---|
| Name | varchar(16) | NO | | | | |
|---|
| MimeText | varchar(48) | NO | | | | |
|---|
| Description | varchar(255) | YES | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | l | ALL | | | | 2 | |
| 1 | SIMPLE | m | eq_ref | PRIMARY | PRIMARY | nornix_site.l.MimeTypeNo | 1 | |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `nornix_site`.`vlayoutlist` AS
(select `l`.`No` AS `No`,
`l`.`Name` AS `Name`,
`m`.`Name` AS `MimeText`,
`nornix_system`.`get_description`(`m`.`DescNo`)
AS `Description`
from (`nornix_site`.`layout` `l` join `nornix_system`.`mimetype` `m` on ((`l`.`MimeTypeNo` =
`m`.`No`))))