EQEmulator Forums - EQEmu 0.4.1 Database addon

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

Code:

-- 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', '');