Timestamps are often not the right choose when it is possible to have duplicates of it for different actions from different users (Yes, it is possible to have two edits of one page in the same second, so it could be possible to have two deletion of different revisions in the same second, maybe not very likly to get, but possible).
The filearchive table has three fields:
-- Deletion information, if this file is deleted. fa_deleted_user int, fa_deleted_timestamp binary(14) default '', fa_deleted_reason_id bigint unsigned NOT NULL,
Maybe try to use similar names of the column for a different table. [Not adding columns when unused like the user and reason columns in filearchive]
On the other hand mediawiki does always use the long word "timestamp" in the schema and not short words like "time"
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4