Postgresql database scheme

[rickmans]

When browsing through the current database setup of serendipity using postgresql I see there are some things missing. For example constraint (primary keys, foreign keys). And I see some mis use of datatype, for example with the sequences which go to the maximum of a bigint. Is it a suggestion to optimize this a little bit more? If you'd like I could make a suggestion of how the database could be build up more correctly .

[garvinhicking]

There should be primary keys existing. And on some occassions we chose bigint so that people could have really big blogs

However suggestions on improving the structure are always welcome. For that it would be great if you could look at our sql/db.sql file structure and see how we replace special variables depending on the MySQL or PostgreSQL database...

Regards,
Garvin

[rickmans]

Some primaries indeed exist, some other doesn't (or to say it in a better way: the ones I would define doesn't). I will take a look at the file and come back to it .

Do you really think people will make 9223372036854775807 entries . Or that there will be 9223372036854775807 authors .

[garvinhicking]

You never know! I'm looking forward to your suggestions!

Regards,
Garvin