<p>I need to create a database table to store different changelog/auditing
(when something was added, deleted, modified, etc). I don't need to store particularly detailed info, so I was thinking something along the lines of:</p>
<ul>
<li>id (for the event)</li>
<li>user that triggered it</li>
<li>event name</li>
<li>event description</li>
<li>timestamp of the event</li>
</ul>
<p>Am I missing something here? Obviously, I can keep improving the design, although I don't plan on making it complicated (creating other tables for event types or stuff like that is out of the question since it's a complication for my need).</p>

There are many ways to do this.  My favorite way is:
Add a
```
mod_user
```
field to your source table (the one you want to log).
Create a log table that contains the fields you want to log, plus a
```
log_datetime
```
and
```
seq_num
```
field.
```
seq_num
```
is the primary key.
Build a trigger on the source table that inserts the current record into the log table whenever any monitored field is changed.
Now you've got a record of every change and who made it.