View: nornix_site.vblocks
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| Handler | varchar(64) | NO | | | | |
|---|
| Data | blob | NO | | | | |
|---|
| Block | varchar(16) | NO | | | | |
|---|
| Script | text | YES | | | | |
|---|
| Type | tinyint(3) unsigned | YES | | 0 | | |
|---|
| ContentTypeNo | int(10) unsigned | NO | | 0 | | |
|---|
| LayoutNo | smallint(6) | NO | | | | |
|---|
Information| Algoritm | Updateable |
|---|
| MERGE | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | lb | index | | PRIMARY | | 4 | Using index |
| 1 | SIMPLE | b | eq_ref | PRIMARY | PRIMARY | nornix_site.lb.BlockNo | 1 | |
| 1 | SIMPLE | bt | eq_ref | PRIMARY | PRIMARY | nornix_site.b.No | 1 | |
| 1 | SIMPLE | ct | eq_ref | PRIMARY | PRIMARY | nornix_site.b.ContentTypeNo | 1 | |
CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `nornix_site`.`vblocks` AS
(select `ct`.`Handler` AS `Handler`,
`b`.`Data` AS `Data`,
`b`.`Name` AS `Block`,
`bt`.`Script` AS `Script`,
`bt`.`Type` AS `Type`,
`b`.`ContentTypeNo` AS `ContentTypeNo`,
`lb`.`LayoutNo` AS `LayoutNo`
from ((`nornix_site`.`block` `b` join (`nornix_site`.`layoutblock` `lb` join
`nornix_system`.`contenttype` `ct`)
on (((`b`.`No` = `lb`.`BlockNo`)
and (`b`.`ContentTypeNo` = `ct`.`No`))))
left join `nornix_site`.`blocktemplate` `bt` on ((`b`.`No` = `bt`.`BlockNo`))))