Dear Simon, At 08.26 16/09/2009, Simon Mitchell wrote:

Hi guy, am having a play with a script to convert the current mysql kohastructure.sql to postgresql etc. My thinking is that any updates to the mysql kohastructure.sql could be handled by automatically by a script.

i'm not sure this is the best path to have Koha on MySQL and on Postgresl. Chris Cormack is working on this topic (support Ps in Koha). I think he prefer to use a perl module as abstract layer (DBIx::Class).

Firstly I have noticed that some table name and columns names are not quoted. Could some one fix that the next time an edit is done.

And

My postgresql database complains that there is no unique key on aqbookfund bookfundid My thinking is this is cause by REFERENCES `aqbookfund` (`bookfundid`) which should be REFERENCES `aqbookfund` (`bookfundid`,`branchcode`) in table aqorderbreakdown.

Does this need to be fixed or is bookfundid unique and justs needs a unique key?

In fact not all relations are present into .sql code. In fact to check to situation you need to see the code in the API (../C4 dirs). Documentation on DB level of Koha here: http://wiki.koha.org/doku.php?id=en:development:dbschema Attention on documentation about ver 3.0.3: Comments are correct, images not always. Bye Zeno Tajoli CILEA - Segrate (MI) tajoliAT_SPAM_no_prendiATcilea.it (Indirizzo mascherato anti-spam; sostituisci quanto tra AT con @)