[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

reply via email to

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