Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
522 views
in Q2A Core by
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?
Q2A version: 1.8
by
+1
How would an ID column make deleting rows from that table any safer? You'd still need to identify the events you want deleted.
by
Delete from qa_eventlog
where id = 557

Try to delete with the recent structure. You cannot pinpoint the entry.
by
+1
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.
by
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
by
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?
by
You mean other than potentially breaking code that relies on the table being defined as it currently is (e.g. for inserts)? No.

Please log in or register to answer this question.

...