[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-devel] SQL Standards

From: Joshua M. Ferraro
Subject: [Koha-devel] SQL Standards
Date: Fri, 4 May 2007 11:15:04 -0500 (CDT)

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?


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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]