file table
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 | | | +------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+