Manual:Image table/pl

Tabela image opisuje zdjęcia i inne przesłane pliki. Przechowywana jest treść strony opisowej podobnie jak inne strony. Zobacz też: Manual:Image Administration.

Pola

 * 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
mysql> DESCRIBE mw_image; +-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+ 14 rows in set (0,00 sec)
 * 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 |         |       |

+-++--+-+-+---+ +-++--+-+-+---+ +-++--+-+-+---+
 * 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  |      |     |         |       |