https://bugzilla.wikimedia.org/show_bug.cgi?id=61813

Maarten Dammers <maar...@mdammers.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |maar...@mdammers.nl

--- Comment #4 from Maarten Dammers <maar...@mdammers.nl> ---
The current toolserver view seems to be everything but fa_description and
fa_sha1.
* fa_description should be left out as it might contain private info
* fa_sha1 is quite recent (1.21) so I think we just never added it at the
Toolserver

mysql> describe filearchive;
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| Field                | Type                                                  
                                                | Null | Key | Default | Extra
|
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
| fa_id                | int(11)                                               
                                                | NO   |     | 0       |      
|
| fa_name              | varbinary(255)                                        
                                                | NO   |     |         |      
|
| fa_archive_name      | varbinary(255)                                        
                                                | YES  |     |         |      
|
| fa_storage_group     | varbinary(16)                                         
                                                | YES  |     | NULL    |      
|
| fa_storage_key       | varbinary(64)                                         
                                                | YES  |     |         |      
|
| fa_deleted_user      | int(11)                                               
                                                | YES  |     | NULL    |      
|
| fa_deleted_timestamp | varbinary(14)                                         
                                                | YES  |     |         |      
|
| fa_deleted_reason    | blob                                                  
                                                | 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','application','audio','image','text','video','message','model','multipart')
            | YES  |     | unknown |       |
| fa_minor_mime        | varbinary(32)                                         
                                                | YES  |     | unknown |      
|
| fa_user              | int(5) unsigned                                       
                                                | YES  |     | 0       |      
|
| fa_user_text         | varbinary(255)                                        
                                                | YES  |     |         |      
|
| fa_timestamp         | varbinary(14)                                         
                                                | YES  |     |         |      
|
| fa_deleted           | tinyint(1) unsigned                                   
                                                | NO   |     | 0       |      
|
+----------------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+
20 rows in set (0.00 sec)

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to