iftechfoundation / ifdb-suggestion-tracker

Bugs and feature requests for a future IFDB update
10 stars 0 forks source link

gamelinks table doesn't have enough metadata #417

Open dfabulich opened 7 months ago

dfabulich commented 7 months ago
MariaDB [ifdb]> describe gamelinks;
+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| gameid            | varchar(32)      | NO   | MUL |         |       |
| title             | varchar(255)     | NO   |     |         |       |
| desc              | mediumtext       | YES  |     | NULL    |       |
| url               | text             | NO   |     | NULL    |       |
| displayorder      | mediumint(9)     | NO   |     | 0       |       |
| fmtid             | int(11) unsigned | NO   |     | 0       |       |
| osid              | int(11) unsigned | YES  |     | NULL    |       |
| osvsn             | int(11) unsigned | YES  |     | NULL    |       |
| compression       | int(11) unsigned | YES  |     | NULL    |       |
| compressedprimary | varchar(255)     | YES  |     | NULL    |       |
| attrs             | int(11)          | NO   |     | 0       |       |
+-------------------+------------------+------+-----+---------+-------+

This table doesn't have an ID column, a creation date, a last modified date, or the user ID who created it.

That information is kinda available in the games_history table, but you have to try to match it by URL; that sucks.