search

dracidoupe / graveyard

Open Source reimplementation of https://www.dracidoupe.cz/
https://nove.dracidoupe.cz/
MIT License
6 stars 4 forks source link

Clean up `Dovednosti.hlasoval` #105

Open Almad opened 3 years ago

Almad commented 3 years ago

Column should be possible to safely drop since the recording of votes is stored is separate tables and this is remnant of legacy approach. It is not used by majority of items anyway:

MariaDB [dracidoupe_cz]> select count(*) from dovednosti WHERE hlasoval is NULL; 
+----------+
| count(*) |
+----------+
|      154 |
+----------+
1 row in set (0.002 sec)

MariaDB [dracidoupe_cz]> select count(*) from dovednosti WHERE hlasoval is NOT NULL; 
+----------+
| count(*) |
+----------+
|       26 |
+----------+
1 row in set (0.001 sec)