· 5 years ago · Mar 21, 2020, 10:51 PM
1
2DROP TABLE IF EXISTS `characters_data`;
3
4CREATE TABLE `characters_data` (
5
6CREATE TABLE `characters_data` (
7 `guid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
8 `customExtraFlag` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Feautres',
9 `lockoutFlag` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Double Lockouts',
10 `stanceFlag` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Delayed Stance Restore',
11 `royalBoostFlag` mediumint(8) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Royal Boost Flag',
12 `exodusBoostFlag` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Custom Player System';
14
15
16ALTER TABLE `characters_data`
17 ADD PRIMARY KEY (`guid`);
18COMMIT;