qyHEP3hB

1DROP TABLE IF EXISTS `account_forcepermission`;
2CREATE TABLE `account_forcepermission` (
3    `AccountID` int(11) unsigned NOT NULL DEFAULT '0',
4    `realmID` int(3) unsigned NOT NULL DEFAULT '0',
5    `Security` int(3) unsigned NOT NULL DEFAULT '0',
6    `Comment` varchar(32) NOT NULL DEFAULT '',
7    PRIMARY KEY (AccountID, realmID)
8) DEFAULT CHARSET=utf8;
9
10ALTER TABLE realmd_db_version CHANGE COLUMN required_12112_01_realmd_account_access required_10008_01_realmd_realmd_db_version  bit;
11
12
13ALTER TABLE `account`
14    ADD COLUMN  `gmlevel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Gm level' AFTER `sha_pass_hash`;