Page 1 of 1
Postgresql database scheme
Posted: Thu Feb 24, 2005 1:03 pm
by 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
.
Re: Postgresql database scheme
Posted: Thu Feb 24, 2005 1:36 pm
by 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
Posted: Thu Feb 24, 2005 6:43 pm
by 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
.
Posted: Sun Feb 27, 2005 12:22 am
by garvinhicking
You never know!
I'm looking forward to your suggestions!
Regards,
Garvin