Because I wanted to execute the arcscripts_full.sql script I noticed that the graveyards table is not the same as it is in the world structure:

World structure:


WhyDB:


I wanted to execute the following line:


The differents why I can not execute the command:
1. zoneid is tinyint
2. faction is not int(10)

Remarks:
Because no one of the unfriendly arcemu guys give me an usable answer I still don't know 100% if this very old script is still needed.

You can't apply it because faction is an enum with values '0', '1' and '3'.
And you query try to set it to '4' which is not accepted.
0 mean horde, 1 mean alliance and 3 mean both.
Fix your query .

`zoneid` tinyint(1) unsigned NOT NULL,
`adjacentzoneid` tinyint(1) unsigned NOT NULL,

indeed those are bad too, how could someone set those to tinyint (tinyint supports numbers from 0 - 256 and there are zones with id over 5k !)

proper table should be:

CREATE TABLE `graveyards` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`position_x` float NOT NULL DEFAULT '0',
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`zoneid` smallint(5) unsigned NOT NULL,
`adjacentzoneid` smallint(5) unsigned NOT NULL,
`mapid` smallint(5) unsigned NOT NULL,
`faction` enum('0','1','3') NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Graveyard System';

OK, that is what I wanted to hear. - so your table is better - OK.

The other problem is that
1. I don't know if it is neccesary to execute the arcscripts_full.sql. You see it yourself. Some Queries are even wrong in this sql script (the part I posted is a part of the whole script).
2. I don't know 100% for what the query(ies) is (are)

i will take a look when i will have a time.