[Koha-devel] SQL Standards

[Joshua M. Ferraro]

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
address@hidden |Full Demos at http://liblime.com/koha |1(888)KohaILS