| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- ALTER TABLE characters
- MODIFY `account_name` VARCHAR(45) DEFAULT NULL,
- MODIFY `obj_Id` INT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `char_name` VARCHAR(35) NOT NULL,
- MODIFY `level` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `maxHp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `curHp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `maxCp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `curCp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `maxMp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `curMp` MEDIUMINT UNSIGNED DEFAULT NULL,
- MODIFY `face` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `hairStyle` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `hairColor` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `sex` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `heading` MEDIUMINT DEFAULT NULL,
- MODIFY `x` MEDIUMINT DEFAULT NULL,
- MODIFY `y` MEDIUMINT DEFAULT NULL,
- MODIFY `z` MEDIUMINT DEFAULT NULL,
- MODIFY `exp` BIGINT UNSIGNED DEFAULT 0,
- MODIFY `expBeforeDeath` BIGINT UNSIGNED DEFAULT 0,
- MODIFY `sp` INT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `karma` INT UNSIGNED DEFAULT NULL,
- MODIFY `pvpkills` SMALLINT UNSIGNED DEFAULT NULL,
- MODIFY `pkkills` SMALLINT UNSIGNED DEFAULT NULL,
- MODIFY `clanid` INT UNSIGNED DEFAULT NULL,
- MODIFY `race` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `classid` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `transform_id` SMALLINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `deletetime` BIGINT DEFAULT NULL,
- MODIFY `cancraft` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `title` VARCHAR(16) DEFAULT NULL,
- MODIFY `rec_have` TINYINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `rec_left` TINYINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `accesslevel` MEDIUMINT DEFAULT 0,
- MODIFY `online` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `onlinetime` INT DEFAULT NULL,
- MODIFY `char_slot` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `newbie` MEDIUMINT UNSIGNED DEFAULT 1,
- MODIFY `lastAccess` BIGINT UNSIGNED DEFAULT NULL,
- MODIFY `clan_privs` MEDIUMINT UNSIGNED DEFAULT 0,
- MODIFY `wantspeace` TINYINT UNSIGNED DEFAULT 0,
- MODIFY `isin7sdungeon` TINYINT UNSIGNED NOT NULL default 0,
- MODIFY `in_jail` TINYINT UNSIGNED DEFAULT 0,
- MODIFY `jail_timer` INT UNSIGNED DEFAULT 0,
- MODIFY `power_grade` TINYINT UNSIGNED DEFAULT NULL,
- MODIFY `nobless` TINYINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `subpledge` SMALLINT NOT NULL DEFAULT 0,
- MODIFY `last_recom_date` BIGINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `lvl_joined_academy` TINYINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `apprentice` INT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `sponsor` INT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `varka_ketra_ally` TINYINT NOT NULL DEFAULT 0,
- MODIFY `clan_join_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `clan_create_expiry_time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
- MODIFY `death_penalty_level` SMALLINT UNSIGNED NOT NULL DEFAULT 0;
|
