Toolserver:Database schema/Images and media
This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.
Images and media edit
Image edit
Image table | |||||
---|---|---|---|---|---|
Field | Type | Null | Key | Default | Extra |
img_name | varchar(255) | No | |||
img_size | int(8) unsigned | No | 0 | ||
img_width | int(5) | No | 0 | ||
img_height | int(5) | No | 0 | ||
img_metadata | mediumblob | No | Null | ||
img_bits | int(3) | No | 0 | ||
img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | Yes | Null | ||
img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | No | Unknown | ||
img_minor_mime | varchar(32) | No | Unknown | ||
img_description | tinyblob | No | Null | ||
img_user | int(5) unsigned | No | 0 | ||
img_user_text | varchar(255) | No | |||
img_timestamp | varchar(14) | No | |||
img_sha1 | varchar(32) | No |
Filearchive edit
Filearchivee table | |||||
---|---|---|---|---|---|
Field | Type | Null | Key | Default | Extra |
fa_id | int(11) | No | 0 | ||
fa_name | varchar(255) | No | |||
fa_archive_name | varchar(255) | Yes | |||
fa_storage_group | varchar(16) | Yes | Null | ||
fa_storage_key | varchar(64) | Yes | |||
fa_deleted_user | int(11) | Yes | Null | ||
fa_deleted_timestamp | varchar(14) | Yes | |||
fa_deleted_reason | text | Yes | Null | ||
fa_size | int(8) unsigned | Yes | 0 | ||
fa_width | int(5) | Yes | 0 | ||
fa_height | int(5) | Yes | 0 | ||
fa_metadata | mediumblob | Yes | Null | ||
fa_bits | int(3) | Yes | 0 | ||
fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | Yes | Null | ||
fa_major_mime | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | Yes | unknown | ||
fa_minor_mime | varchar(32) | Yes | unknown | ||
fa_user | int(5) unsigned | Yes | 0 | ||
fa_user_text | varchar(255) | Yes | |||
fa_timestamp | varchar(14) | Yes | |||
fa_deleted | tinyint(1) unsigned | No | 0 |
Oldimage edit
Oldimage table | |||||
---|---|---|---|---|---|
Field | Type | Null | Key | Default | Extra |
oi_name | varchar(255) | No | |||
oi_archive_name | varchar(255) | No | |||
oi_size | int(8) unsigned | No | 0 | ||
oi_width | int(5) | No | 0 | ||
oi_height | int(5) | No | 0 | ||
oi_bits | int(3) | No | 0 | ||
oi_description | tinyblob | No | Null | ||
oi_user | int(5) unsigned | No | 0 | ||
oi_user_text | varchar(255) | No | |||
oi_timestamp | varchar(14) | No | |||
oi_metadata | mediumblob | No | Null | ||
oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | Yes | Null | ||
oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | No | Unknown | ||
oi_minor_mime | varchar(32) | No | Unknown | ||
oi_deleted | tinyint(3) unsigned | No | |||
oi_sha1 | varchar(32) | No |
Imagelinks edit
Imagelinks table | |||||
---|---|---|---|---|---|
Field | Type | Null | Key | Default | Extra |
il_from | var(8) unsigned | No | 0 | ||
il_to | varchar(255) | No |