Tuesday, January 24, 2006

A better PHPBB schema

I've just modified the phpBB schema for PostgreSQL by:
  1. Taking it from phpBB 2.0.18
  2. Placing everything in the "phpbb" schema
  3. The schema is referred to a role (owner) named "phpbb"
  4. There is some sample data in it (rubbish) you can login as "Admin" password "admin"
  5. Now the most relevant changes:
    1. Added foreign keys
    2. Added unique constraints
    3. Tested on PostgreSQL 8.1 win32
Downloadable here

Hope it helps!!
I'm looking forward to improve it from a performance point of view by proper indexing,
stay tuned for updates.

No comments: