[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] Relational database minor change suggestion
From: |
Marco van Tol |
Subject: |
Re: [Bug-gnubg] Relational database minor change suggestion |
Date: |
Tue, 10 May 2005 09:06:51 +0000 |
User-agent: |
Mutt/1.5.6i |
On Tue, May 10, 2005 at 08:28:43AM +0200, Jim Segrave wrote:
>
> The table name 'match' is a reserved word in mysql, making it not
> possible to use mysql with gnubg. Changing the table name to someghing
> like bgmatch in database.py and gnubg.sql would solve this problem and
> make it possible for other databases to be used - I've already had a
> private query from someone about using Oracle.
>
> If we do change it, does anyone know if you can just do
>
> ALTER TABLE match RENAME TO bgmatch;
>
> and have that also change the constraints for an existing database?
> If so, and it is decided to rename the table, perhaps we should have a
> fixup script for existing databases?
There are ways around it in mysql if I'm not mistaking, but the most user
friendly thing is to change the table name indeed I guess. :)
Marco - Still lurking this list.
--
Je moet me niet dood maken met een blije mus