View: nornix_system.vmimedatafromname
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| 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 | | |
|---|
Information| Algoritm | Updateable |
|---|
| UNDEFINED | YES |
Explain| Id | Select type | Table | Type | Possible keys | Key | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mime | ALL | | | | 24 | |
| 1 | SIMPLE | dtype | eq_ref | UniqueMime | UniqueMime | nornix_system.mime.No | 1 | |
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER
VIEW `vmimedata
fromname` 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`
from (`mimetype` `mime` left join `documenttype` `dtype` on ((`dtype`.`MimeTypeNo` =
`mime`.`No`))))