[Top][All Lists]

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

Re: [Koha-devel] SQL Standards

From: MJ Ray
Subject: Re: [Koha-devel] SQL Standards
Date: Sat, 05 May 2007 00:36:20 +0100
User-agent: Heirloom mailx 12.2 01/07/07

"Joshua M. Ferraro" <address@hidden> wrote:
> 1. don't use SQL92 keywords as field names, table names, etc.

Can this be replaced with:
1. SQL-quote all field names, table names, etc
as I suggested in 2004ish?

> 2. tables shouldn't be defined with TYPE=MyISAM
> 3. get rid of quotes around integer values

These two seem fine.

> 4. remove nonsensical date defaults like 0000-00-00 (why not use NULL)

Probably OK... or maybe should use epoch instead?  That would avoid
having to handle NULL dates.

> 5. add SET SQL_MODE='ANSI_QUOTES' to allow using double-quotes for 
> SQL name delimiters

MySQL only? ;-)

> 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?

Needs a working koha-HEAD which I don't have (as mentioned elsewhere)
so I can't take right now.  Kick me later if needed.

MJ Ray - see/vidu http://mjr.towers.org.uk/email.html
Experienced webmaster-developers for hire http://www.ttllp.co.uk/
Also: statistician, sysadmin, online shop builder, workers co-op.
Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/

reply via email to

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