[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] Relational database minor change suggestion
From: |
Jim Segrave |
Subject: |
Re: [Bug-gnubg] Relational database minor change suggestion |
Date: |
Wed, 1 Jun 2005 19:13:16 +0200 |
User-agent: |
Mutt/1.4.2.1i |
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