Heres the easy way.. The problem is that only the loot txt file contains the tables def's first. Heres how I do it, very simple..
Attatching a zip file with the 4 table defs i source in.
use eq;
drop table npc_types;
drop table lootdrop;
drop table lootdrop_entries;
drop table loottable;
drop table loottable_entries;
drop table spawn2;
drop table spawngroup;
drop table spawnentry;
source createspawn2.txt;
source createspawngroup.txt;
source createspawnentry.txt;
source createnpc_types.txt;
source loot.txt;
source npcs.txt;
source spawn2.txt;
source spawnentry.txt;
source spawngroup.txt;
If you paste this into word pad, put the resulting file in the same directory as drawde's txt files, and the 4 im putting out, you should just be able just C:\mysql\bin\mysql eq < filename.sql
and do it in one fell swoop..
|