Page 1 of 1

[DB] adding a new field in player table.

Posted: 31 March 2013, 00:28
by Rudolf
Hello,
I test a creation of a new field: movechoice , by player.
Here is the code in my dbmodel.sql,
ALTER TABLE `player` ADD `movechoice` TINYINT(1) NOT NULL DEFAULT 0; -- 0: no choice, 1-7 :value of move

when I launch the game, new tables 'rockarea' and 'plain' exists , but player is not altered. I don't see why...
could you hlep me?

Re: [DB] adding a new field in player table.

Posted: 31 March 2013, 12:07
by Een
Hi,

Maybe the comment at the end of the line. Some time the sql parsers do not handle comments very well. I think I already ran in such a problem.
I would suggest using lines either for a comment or for an instruction, but not both.

Re: [DB] adding a new field in player table.

Posted: 31 March 2013, 13:50
by Rudolf
it was that! thanks...
I think, that this sort of trick is good to be added in BGA documentation :)
I add this in Doc.