Re: RE: [PEAR] liveuser status

Lukas Smith wrote:

About the foreign keys on the SQL file. I saw a lot of foreign keys,

but

no ON DELETE or ON UPDATE actions. Is that because you think users should decide for themselves what should happen in these cases?

Stuff like that is database specific. Actually foreign keys only show up in the ERD and not in the sql files. I did see them in the SQL files, just without the ON [action] commands.

If you use our admin interface you don't need to worry about things like that anyways. I guess so, but IMO it's much better to control the data integrity in the RDMBS, that's what it's for. Too bad MySql doesn't support triggers etc. Postgresql users can always add them themselves if they wish to do so.

thanks again! Jeropen