Re: [Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-10-12 Thread Zeno Tajoli
Hi to all, > > My preference is the first option, someone are agree, someone are > not agree. > > The real and big obstacles again first option is: > >-- Not all RDBMS support it o similar syntax > > It works only on MySQL, Postgresql, Oracle. >But not in compatible syntaxes. We are tal

Re: [Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-10-12 Thread Colin Campbell
On 10/12/2009 12:08 PM, Zeno Tajoli wrote: > Hi to all, > My preference is the first option, someone are agree, someone are not agree. > The real and big obstacles again first option is: >-- Not all RDBMS support it o similar syntax > It works only on MySQL, Postgresql, Oracle. But not i

Re: [Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-10-12 Thread Nicole Engard
I am for you adding the notes in the COMMENT in the basic SQL file - so I too am for your first option. Nicole On Mon, Oct 12, 2009 at 7:08 AM, Zeno Tajoli wrote: > Hi to all, > > I'm sorry for not attending IIRC meeting of 07-Oct-2009, but I was outside. > So, from last IIRC and now, the questi

Re: [Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-10-12 Thread Zeno Tajoli
Hi to all, I'm sorry for not attending IIRC meeting of 07-Oct-2009, but I was outside. So, from last IIRC and now, the question is: >Do we insert the command 'COMMENT' in the basic definition SQL file, >the file installer/data/mysql/kohastructure.sql ? >Or do we insert the command 'COMMENT' in a

Re: [Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-09-08 Thread Joe Atzberger
If Chris was accurate in saying that there was active pursuit of postgres compatibility, then only the second option would make sense. My own estimation is that pg-compatibility is so far from being implemented, for most code it almost doesn't matter. By that, I mean that the database representat

[Koha-devel] To mantain documentation on Mysql tables, indexess and relation

2009-09-08 Thread Zeno Tajoli
Hi to all, as I said in the last IRC meeting, http://stats.workbuffer.org/irclog/koha/2009-09-02#i_295862, as CILEA we are working on mantain dcoumentation on Mysql tables, indexeses and relations. The work done until now is here: http://wiki.koha.org/doku.php?id=en:development:dbschema The in