EQEmu 0.4.1 Database addon

[zabon]

I'm getting this error again with the new db (0.4.2) and it even has what Auldar told me to paste in.

[Tugurce]

Now all I wanna know is when the official 4.2 addon will be released

[Lurker_005]

Just a small sql file to update your DB for changes made by 4.2

I suggest using "mysql.exe -f eq < 41to42fix.sql" to load it. The -f means it will ignore any errors, like if you already added the resists stuff to your npc_types


41to42fix.sql

-- Update EQEmu 4.1 DB to a 4.2 compatable DB

ALTER TABLE `account` CHANGE `password` `password` VARCHAR(50)  NOT NULL;

ALTER TABLE `npc_types` CHANGE `npcspecialattks` `npcspecialattks` varchar(36) default '' NOT NULL;
ALTER TABLE `npc_types` ADD `MR` SMALLINT(5)  DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `CR` SMALLINT(5)  DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `DR` SMALLINT(5)  DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `FR` SMALLINT(5)  DEFAULT "0" NOT NULL;
ALTER TABLE `npc_types` ADD `PR` SMALLINT(5)  DEFAULT "0" NOT NULL;


ALTER TABLE `variables` ADD `ts` timestamp;

INSERT INTO variables VALUES ('AILevel','0','');
INSERT INTO variables VALUES ('ZSPassword', 'EQEMu', '');