The efiles table contains a column named 'date' which is of type varchar. This should be a DATE column (and the date needs to be validated before attempting to insert or update). Additionally, since 'DATE' is a keyword in SQL (and not allowed as a column name in most rdbms's), I suggest the name also be changed.
Additionally, it contains a 'size' column as VARCHAR; I think this should be INTEGER.
The efiles table contains a column named 'date' which is of type varchar. This should be a DATE column (and the date needs to be validated before attempting to insert or update). Additionally, since 'DATE' is a keyword in SQL (and not allowed as a column name in most rdbms's), I suggest the name also be changed.
Additionally, it contains a 'size' column as VARCHAR; I think this should be INTEGER.