[DB] adding a new field in player table.

Game development with Board Game Arena Studio
Post Reply
User avatar
Rudolf
Posts: 566
Joined: 24 December 2011, 23:04

[DB] adding a new field in player table.

Post 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?
User avatar
Een
Posts: 3861
Joined: 16 June 2010, 19:52

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

Post 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.
User avatar
Rudolf
Posts: 566
Joined: 24 December 2011, 23:04

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

Post 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.
Post Reply

Return to “Developers”