View: nornix_system.vmimedatafromextension

Structure
Name	Type	Null	Default
No	int(10) unsigned	NO	0
Name	varchar(48)	NO
Compressed	tinyint(1) unsigned	NO	0
Charset	tinyint(1) unsigned	NO	0
Handler	varchar(64)	YES
DTNo	int(10) unsigned	YES	0
Filter	varchar(64)	YES
Extension	varchar(12)	NO

Information
Algoritm	Updateable
UNDEFINED	YES

Explain
Id	Select type	Table	Type	Possible keys	Key	Ref	Rows
1	SIMPLE	ext	ALL				32
1	SIMPLE	mime	eq_ref	PRIMARY	PRIMARY	nornix_system.ext.MimeTypeNo	1
1	SIMPLE	ctype	eq_ref	PRIMARY	PRIMARY	nornix_system.mime.Filter	1
1	SIMPLE	dtype	eq_ref	UniqueMime	UniqueMime	nornix_system.ext.MimeTypeNo	1

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER 
VIEW `vmimedata
fromextension` AS 
(select `mime`.`No` AS `No`,
`mime`.`Name` AS `Name`,
`mime`.`Compressed` AS `Compressed`,
`mime`.`Charset` AS `Charset`,
`dtype`.`Handler` AS `Handler`,
`dtype`.`No` AS `DTNo`,
`ctype`.`Handler` AS `Filter`,
`ext`.`Extension` AS `Extension` 
from ((`mimeextension` `ext` join (`mimetype` `mime` left join `documenttype` `dtype` on
((`dtype`.`MimeTypeNo` = `mime`.`No`))))
left join `contenttype` `ctype` on ((`ctype`.`No` = `mime`.`Filter`)))
where (`ext`.`MimeTypeNo` = `mime`.`No`))