Hey gang, I recently got some feedback for how to make Koha's database definitions more portable to other RDMSs. Thanks to Dan Scott for the following recommendations: 1. don't use SQL92 keywords as field names, table names, etc. 2. tables shouldn't be defined with TYPE=MyISAM 3. get rid of quotes around integer values 4. remove nonsensical date defaults like 0000-00-00 (why not use NULL) 5. add SET SQL_MODE='ANSI_QUOTES' to allow using double-quotes for SQL name delimiters To this list I'll also add that we should pick a more noticeable location for the SQL definitions file to avoid confusion in the future. I'd suggest we keep it in installer/kohastructure.sql These seem like some fairly trivial changes to make. Any takers? Other comments? Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS