landsandboat/sql/transport.sql

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Structure de la table `transport`
--

DROP TABLE IF EXISTS `transport`;
CREATE TABLE IF NOT EXISTS `transport` (
  `id` tinyint(3) unsigned NOT NULL,
  `name` tinytext NOT NULL,
  `transport` int(10) unsigned NOT NULL DEFAULT '0',
  `door` int(10) unsigned NOT NULL DEFAULT '0',
  `dock_x` float(7,3) NOT NULL DEFAULT '0.000',
  `dock_y` float(7,3) NOT NULL DEFAULT '0.000',
  `dock_z` float(7,3) NOT NULL DEFAULT '0.000',
  `dock_rot` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `boundary` smallint(5) unsigned NOT NULL DEFAULT '0',
  `anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `time_offset` smallint(5) unsigned NOT NULL DEFAULT '0',
  `time_interval` smallint(5) unsigned NOT NULL DEFAULT '0',
  `time_anim_arrive` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `time_waiting` smallint(5) unsigned NOT NULL DEFAULT '0',
  `time_anim_depart` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `zone` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=Aria TRANSACTIONAL=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Contenu de la table `transport`
--

INSERT INTO `transport` VALUES (1,'Kazham-Jeuno_Airship',17801320,17801319,-4.000,-3.497,32.125,128,512,18,19,90,360,20,50,20,226);
INSERT INTO `transport` VALUES (2,'Jeuno-Kazham_Airship',17784936,17784935,-4.000,10.450,117.000,64,477,24,25,270,360,20,50,20,226);
INSERT INTO `transport` VALUES (3,'Jeuno-Sandoria_Airship',17784936,17784932,-68.000,10.450,117.000,64,474,18,19,0,360,12,60,12,223);
INSERT INTO `transport` VALUES (4,'Jeuno-Windurst_Airship',17784936,17784934,-6.000,10.450,-117.000,192,476,22,23,90,360,12,60,12,225);
INSERT INTO `transport` VALUES (5,'Jeuno-Bastok_Airship',17784936,17784933,-70.000,10.450,-117.000,192,475,20,21,180,360,12,60,16,224);
INSERT INTO `transport` VALUES (6,'Sandoria-Jeuno_Airship',17727598,17727595,20.000,-2.000,44.000,64,369,18,19,180,360,12,60,16,223);
INSERT INTO `transport` VALUES (7,'Windurst-Jeuno_Airship',17760420,17760419,242.281,-3.522,61.994,96,416,18,19,270,360,18,60,14,225);
INSERT INTO `transport` VALUES (8,'Bastok-Jeuno_Airship',17743971,17743965,-36.458,6.365,-77.322,128,315,18,19,0,360,14,60,16,224);
INSERT INTO `transport` VALUES (9,'Selbina-Mhaura_Boat',17793088,17793087,9.294,0.000,-69.775,0,485,18,19,382,480,18,80,17,220);
INSERT INTO `transport` VALUES (10,'Mhaura-Selbina_Boat',17797182,17797181,-0.516,0.026,-8.409,0,493,18,19,382,480,18,80,17,221);
INSERT INTO `transport` VALUES (11,'Mhaura-Whitegate_Boat',17797182,17797181,-0.516,0.026,-8.409,0,493,18,19,142,480,18,80,17,46);
INSERT INTO `transport` VALUES (12,'Whitegate-Mhaura_Boat',16982046,16982044,-20.726,3.389,-154.231,0,569,18,19,142,480,18,80,16,47);
INSERT INTO `transport` VALUES (13,'Whitegate-Nashmau_Boat',16982046,16982045,20.726,3.389,154.231,128,570,20,21,282,480,18,180,17,58);
INSERT INTO `transport` VALUES (14,'Nashmau-Whitegate_Boat',16994327,16994326,3.240,3.389,-114.221,0,571,22,23,282,480,18,180,16,59);
INSERT INTO `transport` VALUES (15,'Manaclip_Bibiki-Tours',16793984,16793985,491.500,0.000,687.400,128,0,18,19,710,720,20,40,20,3);
INSERT INTO `transport` VALUES (16,'Manaclip_Bibiki-Purgonorgo',16793984,16793985,491.500,0.000,687.400,128,0,18,19,270,720,20,40,20,3);
INSERT INTO `transport` VALUES (17,'Manaclip_Purgonorgo-Bibiki',16793984,16793986,-392.000,0.000,-364.000,128,0,20,21,500,720,20,40,20,3);
INSERT INTO `transport` VALUES (18,'Selbina-Mhaura_Boat_Pirates',17793088,17793087,9.294,0.000,-69.775,0,485,18,19,382,480,18,80,17,227); -- Due to the way transport.cpp evicts from zones, causes duplicate onTransportEvent trigger in town
INSERT INTO `transport` VALUES (19,'Mhaura-Selbina_Boat_Pirates',17797182,17797181,-0.516,0.026,-8.409,0,493,18,19,382,480,18,80,17,228); -- Due to the way transport.cpp evicts from zones, causes duplicate onTransportEvent trigger in town
INSERT INTO `transport` VALUES (20,'Barge_South-Central',16785748,16785756,246.377,0.0,-529.793,192,0,18,19,0,1440,15,35,15,0);
INSERT INTO `transport` VALUES (21,'Barge_Central-South-Day',16785748,16785757,-125.04,0.0,72.79,160,0,20,21,260,1440,15,35,15,1);
INSERT INTO `transport` VALUES (22,'Barge_South-OOS-Day',16785748,0,246.377,0.0,-529.793,64,0,23,0,520,1440,15,6,15,1);
INSERT INTO `transport` VALUES (23,'Barge_South-North',16785748,16785756,246.377,0.0,-529.793,192,0,18,19,560,1440,15,35,15,0);
INSERT INTO `transport` VALUES (24,'Barge_North-OOS',16785748,0,-291.355,0.0,516.868,160,0,22,0,945,1440,15,6,15,1);
INSERT INTO `transport` VALUES (25,'Barge_North-Central',16785748,16785758,-291.355,0.0,516.868,32,0,24,25,990,1440,15,40,15,0);
INSERT INTO `transport` VALUES (26,'Barge_Central-South-Night',16785748,16785757,-125.04,0.0,72.79,160,0,20,21,1140,1440,15,35,15,1);
INSERT INTO `transport` VALUES (27,'Barge_South-OOS-Night',16785748,0,246.377,0.0,-529.793,64,0,23,0,1400,1440,15,6,15,1);
INSERT INTO `transport` VALUES (28,'Pirates_to-Selbina',17707045,0,-30.0,0.0,0.0,192,0,18,19,70,480,20,177,21,0);
INSERT INTO `transport` VALUES (29,'Pirates_to-Mhaura',17711140,0,30.0,0.0,0.0,192,0,18,19,70,480,20,177,21,0);