Riklin, the character_corpse_items table is not in either of the PEQ dumps as it is a table that is created by the server code itself.
Niteryder1969: the ALTER TABLE will fail, because db_update.pl runs *before* world actually gets around to running. You need to go ahead and let world run by hitting 0 at the db_update.pl prompt. Once it's run once, exit and re-run, and the next time db_update.pl will work because world will have had a chance to create the missing table.
Alternatively, you can simply create the table yourself. Here is the command (taken from common/database.cpp):
Code:
CREATE TABLE `character_corpse_items` (
`corpse_id` int(11) unsigned NOT NULL,
`equip_slot` int(11) unsigned NOT NULL,
`item_id` int(11) unsigned DEFAULT NULL,
`charges` int(11) unsigned DEFAULT NULL,
`aug_1` int(11) unsigned DEFAULT '0',
`aug_2` int(11) unsigned DEFAULT '0',
`aug_3` int(11) unsigned DEFAULT '0',
`aug_4` int(11) unsigned DEFAULT '0',
`aug_5` int(11) unsigned DEFAULT '0',
`aug_6` int(11) unsigned DEFAULT '0',
`attuned` smallint(5) NOT NULL DEFAULT '0',
PRIMARY KEY(`corpse_id`, `equip_slot`)) ENGINE = InnoDB DEFAULT CHARSET = latin1;