Postgresql database scheme
Postgresql database scheme
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 .
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Postgresql database scheme
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
You never know! I'm looking forward to your suggestions!
Regards,
Garvin
Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/