[Koha-devel] SQL Standards
Joshua M. Ferraro
jmf at liblime.com
Fri May 4 18:15:04 CEST 2007
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 at liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
More information about the Koha-devel
mailing list