[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] Relational database minor change suggestion
From: |
Renzo Campagna |
Subject: |
Re: [Bug-gnubg] Relational database minor change suggestion |
Date: |
Tue, 31 May 2005 21:42:55 +0200 |
Another little minor change suggestion is to have the relational database
for windows users.
Best regards
Renzo
----- Original Message -----
From: "Holger" <address@hidden>
To: <address@hidden>
Cc: <address@hidden>
Sent: Tuesday, May 31, 2005 7:06 PM
Subject: Re: [Bug-gnubg] Relational database minor change suggestion
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.
> 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
_______________________________________________
Bug-gnubg mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/bug-gnubg