In some email I received from lou <[EMAIL PROTECTED]> on Mon, 16 Jun 2003 18:36:45 +0100, wrote:
> Another thought while i was going through dbmail pgsql scheme and
> dbmail-maintenance
> integrity check.
Okay,I'm sorry Roel didnt read the comment (nah bad editor i can hardly see
anything
grey ;-( )
/* $Id: create_tables.pgsql,v 1.17 2003/03/17 16:04:09 roel Exp $
Todo:
- add foreign key constrains (will prevent inconsistence
- add / remove indexes depending on performance
*/
2 files attached
pgsql - add-foreignkeys.pgsql
mysql - same file should work. (only for InnoDB)
I just didnt notice it until I tried it on my database.
cheers
add-foreignkeys.sql
Description: Binary data
