Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null | 
                                         | 
                                    
                                         | 
                                    ||||
| filename | LONGTEXT | 2147483647 | null | 
                                         | 
                                    
                                         | 
                                    Original file name  | 
                                ||||
| quarantinedfile | LONGTEXT | 2147483647 | √ | null | 
                                         | 
                                    
                                         | 
                                    Quarantine zip file  | 
                                |||
| userid | BIGINT | 19 | null | 
                                         | 
                                    
                                        
  | 
                                    The user that uploaded the infected file.  | 
                                ||||
| reason | LONGTEXT | 2147483647 | null | 
                                         | 
                                    
                                         | 
                                    The reason for the antivirus failure  | 
                                ||||
| timecreated | BIGINT | 19 | 0 | 
                                         | 
                                    
                                         | 
                                    The time the infected file was uploaded.  | 
                                
Indexes
| Constraint Name | Type | Sort | Column(s) | 
|---|---|---|---|
| PRIMARY | Primary key | Asc | id | 
| infefile_use_ix | Performance | Asc | userid |