mysql> DESCRIBE tblBOGObjectMedia; +-----------------------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ | ObjectID | int(10) unsigned | NO | PRI | 0 | | | MutatieID | int(10) unsigned | NO | | 0 | | | MediaID | int(10) unsigned | NO | PRI | 0 | | | Bestandsnaam | varchar(128) | YES | | NULL | | | sysBestandsnaam | varchar(50) | YES | | NULL | | | sysBestandAanwezig | enum('0','1') | NO | MUL | 0 | | | sysBestandMutatieID | int(10) unsigned | YES | | NULL | | | sysBestandRetrievedFromHTTP | enum('0','1') | YES | | NULL | | | sysBestandRetrievedFromFTP | enum('0','1') | YES | | NULL | | | sysBestandMd5 | varchar(32) | YES | | NULL | | | HoofdFoto | enum('0','1') | YES | MUL | NULL | | | sysDLM | datetime | YES | MUL | NULL | | | sysDOC | datetime | YES | MUL | NULL | | | sysTiaraDLM | datetime | YES | | NULL | | | sysTiaraDOC | datetime | YES | | NULL | | | sysDOR | datetime | YES | MUL | NULL | | | sysRetrievePriority | tinyint(4) | YES | MUL | NULL | | | sysRetrievePID | int(10) unsigned | YES | MUL | NULL | | | MediaGroep | enum('beeld','document') | NO | PRI | beeld | | | MediaMimeType | enum('avi','bmp','doc','flash','gif','ipx','jpg','mpeg','pdf','tiff','wmv') | YES | | NULL | | | Omschrijving | text | NO | | NULL | | | sysVersie | char(3) | YES | | NULL | | | sysVerwijderd | enum('0','1') | YES | MUL | NULL | | | uuid | char(36) | YES | | NULL | | +-----------------------------+-----------------------------------------------------------------------------+------+-----+---------+-------+ 24 rows in set (0.04 sec) mysql> SHOW INDEXES FROM tblBOGObjectMedia; +-------------------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-------------------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+ | tblBOGObjectMedia | 0 | PRIMARY | 1 | ObjectID | A | NULL | NULL | NULL | | BTREE | | | tblBOGObjectMedia | 0 | PRIMARY | 2 | MediaID | A | NULL | NULL | NULL | | BTREE | | | tblBOGObjectMedia | 0 | PRIMARY | 3 | MediaGroep | A | 478144 | NULL | NULL | | BTREE | | | tblBOGObjectMedia | 1 | sysRetrievePriority_index | 1 | sysRetrievePriority | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | sysRetrievePID_index | 1 | sysRetrievePID | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | sysDOR_index | 1 | sysDOR | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | sysDOC_index | 1 | sysDOC | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | sysBestandAanwezig_index | 1 | sysBestandAanwezig | A | 478144 | NULL | NULL | | BTREE | | | tblBOGObjectMedia | 1 | HoofdFoto_index | 1 | HoofdFoto | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | sysDLM_index | 1 | sysDLM | A | 478144 | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | setPriority_index | 1 | sysVerwijderd | A | NULL | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | setPriority_index | 2 | sysBestandAanwezig | A | NULL | NULL | NULL | | BTREE | | | tblBOGObjectMedia | 1 | setPriority_index | 3 | HoofdFoto | A | NULL | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | setPriority_index | 4 | sysDLM | A | NULL | NULL | NULL | YES | BTREE | | | tblBOGObjectMedia | 1 | setPriority_index | 5 | sysDOC | A | 478144 | NULL | NULL | YES | BTREE | | +-------------------+------------+---------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+ 15 rows in set (0.00 sec)