View: nornix_site.vcontents
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Handler | varchar(64) | NO | | | | |
|---|
| Data | mediumblob | YES | | | | |
|---|
| TS | bigint(10) | NO | | 0 | | |
|---|
| ParsesPath | tinyint(1) unsigned | NO | | 0 | | |
|---|
| Block | varchar(16) | NO | | content | | |
|---|
| Script | text | YES | | | | |
|---|
| Type | tinyint(3) unsigned | YES | | 0 | | |
|---|
| ContentTypeNo | int(10) unsigned | NO | | 0 | | |
|---|
| DocumentNo | int(10) unsigned | NO | | 0 | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | c | ALL | | | | 48 | Using where |
| 1 | SIMPLE | ct | eq_ref | PRIMARY | PRIMARY | nornix_site.c.ContentTypeNo | 1 | |
| 1 | SIMPLE | t | eq_ref | Block | Block | nornix_site.c.Block | 1 | |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `nornix_site`.`vcontents` AS
(select `ct`.`Handler` AS `Handler`,
`c`.`Data` AS `Data`,
unix_timestamp(`c`.`TS`)
AS `TS`,
`ct`.`ParsesPath` AS `ParsesPath`,
`c`.`Block` AS `Block`,
`t`.`Script` AS `Script`,
`t`.`Type` AS `Type`,
`c`.`ContentTypeNo` AS `ContentTypeNo`,
`c`.`DocumentNo` AS `DocumentNo`
from ((`nornix_site`.`content` `c` join `nornix_system`.`contenttype` `ct` on ((`c`.`ContentTypeNo`
= `ct`.`No`)))
left join `nornix_site`.`blocktemplate` `t` on ((`c`.`Block` = `t`.`Block`)))
where (`c`.`Version` = 0))