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

[Jim Segrave]

On Tue 31 May 2005 (19:06 +0200), Holger wrote:
> On Tue, 10 May 2005 08:28:43 +0200, Jim Segrave wrote:
> > The table name 'match' is a reserved word in mysql, making it not
> > possible to use mysql with gnubg.
> 
> You can quote all names of databases, tables, columns and aliases with
> backticks (`match`) and thus use reserved words or spaces.

Yep, but that's going to have an impact on database.py and
gnubg.sql. I'd think it's better to have names which don't need escaping

> > 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?
> 
> This will only change this table, not any other table or a constraint
> of that table to the table being changed. Therefore these tables must
> also be altered. (ALTER TABLE DROP FOREIGN KEY ... ; ALTER TABLE ...
> ADD FOREIGN KEY ... REFERENCES ...)
> 
> Regards,
> 
>       Holger

-- 
Jim Segrave           address@hidden