Tabela image opisuje zdjęcia i inne przesłane pliki. Przechowywana jest treść strony opisowej podobnie jak inne strony. Zobacz też: Manual:Image Administration.
- img_name
- Nazwa pliku.
- img_size
- Rozmiar pliku w bajtach.
- img_width
- szerokość
- img_height
- wysokość
- img_metadata
- Metadane
- img_bits
- ??
- img_media_type
- ??
- img_major_mime
- ??
- img_minor_mime
- ??
- img_description
- Opis podany podczas wysyłania.
- img_user
- (Manual:User_table/pl) ID użytkownika przesyłającego plik.
- img_user_text
- Nazwa użytkownika przesyłającego plik.
- img_timestamp
- Czas przesłania pliku.
- img_sha1
- Hash SHA-1 base 36 zawartości pliku. includes/GlobalFunctions.php's wfBaseConvert jest używany do konwersji pomiędzy 16 (heksadecymalny) do base 36 oraz umieszczeniu wyniku w 31 znakach.
Wersje [edit]
mysql> DESCRIBE mw_image;
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Pole | Typ | Null |Klucz|Domyślnie| Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) | NO | PRI | | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | 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 | varbinary(100) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(10) unsigned | NO | | 0 | |
| img_user_text | varchar(255) | NO | MUL | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | | |
| img_sha1 | varbinary(32) | NO | MUL | | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
14 rows in set (0,00 sec)
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Pole | Typ | Null |Klucz|Domyślnie| Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 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 | MUL | NULL | |
| img_timestamp | char(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Pole | Typ | Null |Klucz|Domyślnie| Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) | NO | PRI | NULL | |
| img_size | int(10) unsigned | NO | MUL | 0 | |
| img_width | int(11) | NO | | 0 | |
| img_height | int(11) | NO | | 0 | |
| img_metadata | mediumblob | NO | | NULL | |
| img_bits | int(11) | 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 | varbinary(32) | NO | | unknown | |
| img_description | tinyblob | NO | | NULL | |
| img_user | int(10) unsigned | NO | | 0 | |
| img_user_text | varchar(255) | NO | MUL | NULL | |
| img_timestamp | varbinary(14) | NO | MUL | NULL | |
| img_sha1 | varbinary(32) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Pole | Typ | Null |Klucz|Domyślnie| Extra |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| img_name | varchar(255) | NO | PRI | NULL | |
| img_size | int(8) unsigned | NO | MUL | 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 | | NULL | |
| img_timestamp | char(14) | NO | MUL | NULL | |
+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
+-----------------+---------------------+------+-----+---------+-------+
| Pole | Typ | Null |Klucz|Domyślnie| Extra |
+-----------------+---------------------+------+-----+---------+-------+
| img_name | varchar(255) binary | | | | |
| img_size | int(8) unsigned | | | 0 | |
| img_description | tinyblob | | | | |
| img_user | int(5) unsigned | | | 0 | |
| img_user_text | varchar(255) binary | | | | |
| img_timestamp | varchar(14) binary | | | | |
+-----------------+---------------------+------+-----+---------+-------+
