Re: [Bug-gnubg] Relational database minor change suggestion

[Marco van Tol]

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