Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
id | INT | 10 | √ | null |
|
|
||
hashvalue | CHAR | 40 | null |
|
|
|||
filename | MEDIUMTEXT | 16777215 | null |
|
|
|||
dir | MEDIUMTEXT | 16777215 | null |
|
|
|||
filesize | INT | 10 | √ | null |
|
|
||
dtcreated | TIMESTAMP | 19 | current_timestamp() |
|
|
|||
uploadcategorycode | TEXT | 65535 | √ | null |
|
|
||
owner | INT | 10 | √ | null |
|
|
||
public | TINYINT | 3 | √ | null |
|
|
||
permanent | TINYINT | 3 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |