foxfirediego
New Member
- Joined
- Jul 25, 2007
- Messages
- 66
- Reaction score
- 0
i'm going to update from TFS 0.2.3 to 0.2.6 but i saw some difference between the old mysql schema do the new one:
table accounts
table players
how can i update my database to use foreign key!
thx
table accounts
Code:
`group_id` INT NOT NULL DEFAULT 1,
PRIMARY KEY (`id`),
FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
table players
Code:
FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`)
thx