· 8 years ago · Jul 09, 2018, 12:20 PM
1SET FOREIGN_KEY_CHECKS=0;
2
3-- ----------------------------
4-- Table structure for teleport_locations
5-- ----------------------------
6DROP TABLE IF EXISTS `teleport_locations`;
7CREATE TABLE `teleport_locations` (
8 `id` int(10) NOT NULL AUTO_INCREMENT,
9 `name` varchar(255) NOT NULL DEFAULT 'Unnamed',
10 `description` varchar(255) DEFAULT NULL,
11 `x` float DEFAULT '0',
12 `y` float DEFAULT '0',
13 `z` float DEFAULT '0',
14 `orientation` float DEFAULT '0',
15 `mapId` smallint(6) DEFAULT '0',
16 `vpCost` int(11) DEFAULT '0',
17 `dpCost` int(11) DEFAULT '0',
18 `goldCost` int(11) DEFAULT '0',
19 `realm` int(11) DEFAULT '1',
20 `required_faction` int(1) NOT NULL DEFAULT '0',
21 PRIMARY KEY (`id`),
22 KEY `realm_fk` (`realm`),
23 CONSTRAINT `realm_fk` FOREIGN KEY (`realm`) REFERENCES `realms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
24) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
25
26-- ----------------------------
27-- Records of teleport_locations
28-- ----------------------------
29INSERT INTO `teleport_locations` VALUES ('1', 'Orgrimmar', '', '1476.97', '-4417.58', '25.4625', '0.168422', '1', '0', '0', '10', '1', '2');
30INSERT INTO `teleport_locations` VALUES ('2', 'Silvermoon City', '', '9468.02', '-7278.2', '14.2131', '0.003325', '530', '0', '0', '10', '1', '2');
31INSERT INTO `teleport_locations` VALUES ('3', 'Stormwind City', '', '-8571.08', '992.858', '96220100', '3.82602', '0', '0', '0', '10', '1', '1');
32INSERT INTO `teleport_locations` VALUES ('4', 'Darnassus', '', '9951.9', '2280.37', '1341.39', '1.52126', '1', '0', '0', '10', '1', '1');
33INSERT INTO `teleport_locations` VALUES ('5', 'Dalaran', '', '5797.86', '630.904', '647.413', '0.85853', '571', '0', '0', '10', '1', '0');
34INSERT INTO `teleport_locations` VALUES ('6', 'Honor Hold', '', '-638.729919', '2575.781982', '81.348267', '2.197900', '530', '0', '0', '10', '1', '1');
35INSERT INTO `teleport_locations` VALUES ('7', 'Thrallmar', '', '31.866728', '2657.576660', '75.250076', '0.684447', '530', '0', '0', '10', '1', '2');
36INSERT INTO `teleport_locations` VALUES ('8', 'Booty Bay', '', '-14287.526367', '556.045166', '8.890329', '4.306719', '0', '0', '0', '10', '1', '0');
37INSERT INTO `teleport_locations` VALUES ('9', 'Undercity', '', '1569.000488', '264.761169', '-43.102650', '3.858817', '0', '0', '0', '10', '1', '2');
38INSERT INTO `teleport_locations` VALUES ('10', 'Ironforge', '', '-5019.098633', '-837.049133', '496.662018', '5.411685', '0', '0', '0', '10', '1', '1');