View: nornix_site.vsiteresources

Structure
Name	Type	Null	Default
Handler	varchar(64)	YES
Data	longblob	NO
UNIX_TIMESTAMP(`TS`)	bigint(10)	NO	0
Description	varchar(127)	NO
Width	int(11) unsigned	NO	0
Height	int(11) unsigned	NO	0
MimeTypeNo	int(10) unsigned	NO	0
Name	varchar(80)	NO

Information
Algoritm	Updateable
UNDEFINED	YES

Explain
Id	Select type	Table	Type	Possible keys	Key	Ref	Rows	Extra
1	SIMPLE	r	ALL				8
1	SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	nornix_site.r.ContentTypeNo	1

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER 
VIEW `nornix_site`.`vsiteresources` AS 
(select `ct`.`Handler` AS `Handler`,
`r`.`Data` AS `Data`,
unix_timestamp(`r`.`TS`)
AS `UNIX_TIMESTAMP(``TS``)`,
`r`.`Description` AS `Description`,
`r`.`Width` AS `Width`,
`r`.`Height` AS `Height`,
`r`.`MimeTypeNo` AS `MimeTypeNo`,
`r`.`Name` AS `Name` 
from (`nornix_site`.`siteresource` `r` left join `nornix_system`.`contenttype` `ct` on ((`ct`.`No`
= `r`.`ContentTypeNo`))))