Why is there no ID column with qa_eventlog?

Question

With some plugins I need to delete certain events from table qa_eventlog.

However, since there is no "id" column, I cannot safely delete the events.

What was the design (performance?) decision not to add IDs to the eventlog table?

And would it be safe to add the ID column?

Comments

How would an ID column make deleting rows from that table any safer? You'd still need to identify the events you want deleted.

---

Delete from qa_eventlog
where id = 557

Try to delete with the recent structure. You cannot pinpoint the entry.

---

Again, how would you determine that the row with ID 557 is the one you want deleted? You can use the same criteria for actually deleting the row.

---

Furthermore, deleting from that table suggests you're selecting from it. That's probably the underlying issue. It's better for plugins to create their own tables

---

Having several plugins using the qa_eventlog table as a central table for reading events and displaying what is going on in the forum.

In general (that was my initial question): Is there any performance issue if adding a unique id column?

---

You mean other than potentially breaking code that relies on the table being defined as it currently is (e.g. for inserts)? No.