yeah there are a few changes with 0.4.3.
Added " minstatus smallint(5) not null default 0, " to guilds
Added " npc_spells_id int(11) unsigned not null default '0', " to npc_types
Removed " usedspells varchar(70) NOT NULL default '', " from Npc_Types
Added " zoneid smallint(5) not null default '0', " to character_
And they added these two tables
Quote:
Create Table npc_spells (
id int(11) unsigned not null auto_increment primary key,
name tinytext,
parent_list int(11) unsigned not null default 0,
attack_proc smallint(5) not null default -1,
proc_chance tinyint(3) not null default 3
);
create table npc_spells_entries (
id int(11) unsigned not null auto_increment primary key,
npc_spells_id int(11) not null,
spellid smallint(5) not null default 0,
type smallint(5) unsigned not null default 0,
minlevel tinyint(3) unsigned not null default 0,
maxlevel tinyint(3) unsigned not null default 255,
manacost smallint(5) not null default '-1',
recast_delay int(11) not null default '-1',
priority smallint(5) not null default 0,
index npc_spells_id (npc_spells_id)
);
|
I think thats it.