•Re: Cleanup ALerts in Snort/ACID Mysql DB

[merlyn]

Wow. Too bad MySQL doesn't have foreign keys with ON DELETE CASCADE support, like PostgreSQL has had for a few years already.

Would be a great time saver. Might be easier just to install PostgreSQL.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.

[tunaboy]

I don't want to start up a PostgreSQL vs MySQL debate (as it is comparing apples and oranges) but if you make use of InnoDB tables then you can specify foreign keys and cascading deletes.

MySQL Documentation