ChaosEMU/ChaosCore — Issue #26: Missing sql file
Author: dtzeus
Created: 2011-10-26 18:38:58+00:00
State: open

missing gmisland_teleport.sql in sql/tools folder

-- Put this SQL in character database.
DROP TABLE IF EXISTS `gmisland_teleport`;
CREATE TABLE `gmisland_teleport` (
`map` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`x` DOUBLE NOT NULL DEFAULT '0',
`y` DOUBLE NOT NULL DEFAULT '0',
`z` DOUBLE NOT NULL DEFAULT '0',
`orientation` DOUBLE NOT NULL DEFAULT '0',
`comment` VARCHAR(255),
PRIMARY KEY (`map`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;

INSERT INTO `gmisland_teleport` (
`map`,`x`,`y`,`z`,`orientation`,`comment`)
VALUES (
'13','1.118799','0.477914','-144.708650','3.133046','Jail Box');