[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/1.4.2.1i |
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
- [Bug-gnubg] Relational database minor change suggestion,
Jim Segrave <=