Fields
Schema summary
DESCRIBE file;
6.1
+------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+----------------+
| file_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| page_id | int(10) unsigned | NO | MUL | 0 | |
| user_id | int(10) unsigned | NO | MUL | 0 | |
| file_name | varchar(255) | NO | MUL | | |
| file_lang | varchar(5) | NO | | | |
| file_description | varchar(255) | NO | | | |
| caption | text | YES | | NULL | |
| author | varchar(255) | NO | | | |
| source | varchar(255) | NO | | | |
| source_url | varchar(255) | NO | | | |
| license_id | int(10) unsigned | NO | | 0 | |
| created | datetime | YES | | NULL | |
| modified | datetime | YES | | NULL | |
| file_size | int(10) unsigned | NO | | 0 | |
| picture_w | int(10) unsigned | NO | | 0 | |
| picture_h | int(10) unsigned | NO | | 0 | |
| file_ext | varchar(10) | NO | | | |
| mime_type | varchar(255) | NO | | | |
| file_hash | char(40) | NO | MUL | | |
| deleted | tinyint(1) unsigned | YES | MUL | 0 | |
+------------------+---------------------+------+-----+---------+----------------+
6.0
+------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+---------------------+------+-----+---------+----------------+
| file_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| page_id | int(10) unsigned | NO | MUL | 0 | |
| user_id | int(10) unsigned | NO | MUL | 0 | |
| file_name | varchar(191) | NO | | | |
| file_lang | varchar(5) | NO | | NULL | |
| file_description | varchar(250) | NO | | NULL | |
| caption | text | YES | | NULL | |
| author | varchar(250) | NO | | NULL | |
| source | varchar(250) | NO | | NULL | |
| source_url | varchar(255) | NO | | NULL | |
| license_id | int(10) unsigned | NO | | 0 | |
| uploaded_dt | datetime | YES | | NULL | |
| modified_dt | datetime | YES | | NULL | |
| file_size | int(10) unsigned | NO | | 0 | |
| picture_w | int(10) unsigned | NO | | 0 | |
| picture_h | int(10) unsigned | NO | | 0 | |
| file_ext | varchar(10) | NO | | NULL | |
| mime_type | varchar(255) | NO | | NULL | |
| deleted | tinyint(1) unsigned | YES | MUL | 0 | |
+------------------+---------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN file;
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| wacko_file | 0 | PRIMARY | 1 | file_id | A | 110 | NULL | NULL | | BTREE | | |
| wacko_file | 0 | idx_page_id | 1 | page_id | A | 55 | NULL | NULL | | BTREE | | |
| wacko_file | 0 | idx_page_id | 2 | file_name | A | 110 | NULL | NULL | | BTREE | | |
| wacko_file | 1 | idx_page_id_2 | 1 | page_id | A | 55 | NULL | NULL | | BTREE | | |
| wacko_file | 1 | idx_page_id_2 | 2 | created | A | 110 | NULL | NULL | YES | BTREE | | |
| wacko_file | 1 | idx_deleted | 1 | deleted | A | 2 | NULL | NULL | YES | BTREE | | |
| wacko_file | 1 | idx_user_id | 1 | user_id | A | 4 | NULL | NULL | | BTREE | | |
| wacko_file | 1 | idx_file_name | 1 | file_name | A | 110 | NULL | NULL | | BTREE | | |
| wacko_file | 1 | idx_file_hash | 1 | file_hash | A | 110 | NULL | NULL | | BTREE | | |
+------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+