Another little minor change suggestion is to have the relational database for windows users.
Best regards Renzo ----- Original Message ----- From: "Holger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[email protected]> 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 [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg _______________________________________________ Bug-gnubg mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bug-gnubg
