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;