[Top][All Lists]

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

[Bug-gnubg] Relational database minor change suggestion

From: Jim Segrave
Subject: [Bug-gnubg] Relational database minor change suggestion
Date: Tue, 10 May 2005 08:28:43 +0200
User-agent: Mutt/

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? 

Jim Segrave           address@hidden

reply via email to

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