View: nornix_system.vhttpstatusinfo
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Header | varchar(48) | NO | | | | |
|---|
| Heading | varchar(255) | YES | | | | |
|---|
| Description | varchar(255) | YES | | | | |
|---|
| No | int(10) unsigned | NO | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | httpstatus | ALL | | | | 10 | |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `vhttpstatusinfo` AS
(select `httpstatus`.`Header` AS `Header`,
`nornix_system`.`get_description`(`httpstatus`.`HeadingNo`)
AS `Heading`,
`nornix_system`.`get_description`(`httpstatus`.`DescNo`)
AS `Description`,
`httpstatus`.`No` AS `No`
from `httpstatus`)