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

[Renzo Campagna]

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