PhatAC/sqldumps/tele_locatio...

-- phpMyAdmin SQL Dump
-- version 4.4.15.8
-- https://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 01, 2017 at 10:32 AM
-- Server version: 5.6.31
-- PHP Version: 5.5.38

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `phatac`
--

-- --------------------------------------------------------

--
-- Table structure for table `tele_locations`
--

CREATE TABLE IF NOT EXISTS `tele_locations` (
  `ID` int(11) NOT NULL,
  `Description` varchar(50) NOT NULL,
  `Command` varchar(50) NOT NULL,
  `Landblock` varchar(50) NOT NULL,
  `Position_X` varchar(50) NOT NULL,
  `Position_Y` varchar(50) NOT NULL,
  `Position_Z` varchar(50) NOT NULL,
  `Orientation_W` varchar(50) NOT NULL,
  `Orientation_X` varchar(50) NOT NULL,
  `Orientation_Y` varchar(50) NOT NULL,
  `Orientation_Z` varchar(50) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tele_locations`
--

INSERT INTO `tele_locations` (`ID`, `Description`, `Command`, `Landblock`, `Position_X`, `Position_Y`, `Position_Z`, `Orientation_W`, `Orientation_X`, `Orientation_Y`, `Orientation_Z`) VALUES
(1, 'Teletown - Aerlinthe', 'Aerlinthe Island', 'BAE8001D', '42A80000', '42D20000', '41D00A3D', '00000000', '00000000', '00000000', 'BF800000'),
(2, 'Teletown - Ahurenga', 'Ahurenga', '0FB90009', '422C0000', '4109999A', '3BA3D70A', 'BF7AE7B4', '00000000', '00000000', 'BE4B46FE'),
(3, 'Teletown - Al-Arqas', 'Al-Arqas', '8F58003B', '4337D9DB', '4270BB64', '411536F4', '3F3504F7', '00000000', '00000000', 'BF3504F7'),
(4, 'Teletown - Al-Jalima', 'Al-Jalima', '8588002C', '42F0B7CF', '42BEF0A4', '42B4192C', '3F800000', '00000000', '00000000', '00000000'),
(5, 'Teletown - Arwic', 'Arwic', 'C6A90009', '423B3852', '4087020C', '4228051F', '3F800000', '00000000', '00000000', '00000000'),
(6, 'Teletown - Ayan Baqur', 'Ayan Baqur', '11340025', '42C79EE7', '42D7D1C7', '4228051F', '3F3603A3', '00000000', '00000000', 'BF3404DA'),
(7, 'Teletown - Baishi', 'Baishi', 'CE410007', '4149999A', '4318CCCD', '425C3852', 'BF0B6D76', '00000000', '00000000', 'BF56B325'),
(8, 'Teletown - Bandit Castle', 'Bandit Castle', 'BDD00006', '41873333', '42F10000', '42E63333', '3F3504F7', '00000000', '00000000', 'BF3504F7'),
(9, 'Teletown - Beach Fort', 'Beach Fort', '42DE000C', '41C80000', '42A90000', '3BA3D70A', 'BF2E976C', '00000000', '00000000', 'BF3B3A04'),
(10, 'Teletown - Bluespire', 'Bluespire', '21B00017', '4240C28F', '4325E3D7', '3BA3D70A', 'BDAB3F64', '00000000', '00000000', 'BF7F1A7E'),
(11, 'Teletown - Candeth Keep', 'Candeth Keep', '2B11003D', '433D2358', '42C59A27', '4240051F', 'BF6DE29B', '00000000', '00000000', 'BEBD2C38'),
(12, 'Teletown - Cragstone', 'Cragstone', 'BB9F0040', '43295BA6', '43284042', '4258051F', '3F142492', '00000000', '00000000', 'BF50C804'),
(13, 'Teletown - Crater Lake Village', 'Mt Esper-Crater Village', '90D00107', '42BF0AC1', '42A80000', '438A9A3D', 'BF3504F7', '00000000', '00000000', 'BF3504F7'),
(14, 'Teletown - Danby''s Outpost', 'Danby''s Outpost', '5A9C0004', '41BC0000', '429A3333', '40C028F6', '00000000', '00000000', '00000000', 'BF800000'),
(15, 'Teletown - Dryreach', 'Dryreach', 'DB75003B', '433A0000', '42820000', '42100000', 'BF400000', '00000000', '00000000', '3F266666'),
(16, 'Teletown - Eastham', 'Eastham', 'CE940035', '43170D91', '42E13852', '418B5687', 'BF6FC383', '00000000', '00000000', 'BEB36FA0'),
(17, 'Teletown - Fort Tethana', 'Fort Tethana', '2681001D', '429B6666', '42D83333', '43700147', 'BF05C26E', '00000000', '00000000', 'BF5A469D'),
(18, 'Teletown - Glenden Wood', 'Glenden Wood', 'A0A40025', '42C09AA0', '42EFB1AA', '426FD194', '3F3504F7', '00000000', '00000000', 'BF3504F7'),
(19, 'Teletown - Greenspire', 'Greenspire', '2BB5003C', '4332F53F', '42AD23D7', '3BA3D70A', '3EB466F5', '00000000', '00000000', 'BF6F951C'),
(20, 'Teletown - Hebian-to', 'Hebian-to', 'E64E002F', '430A4DD3', '4321E7AE', '41A05194', '3F6C8366', '00000000', '00000000', 'BEC3EF07'),
(21, 'Teletown - Holtburg', 'Holtburg', 'A9B40019', '42A80000', '40E33333', '42BC0290', '3F7F35F4', '00000000', '00000000', 'BDA0AF1D'),
(22, 'Teletown - Kara', 'Kara', 'BA170039', '43353333', '404CCCCD', '43279AE1', 'BF5919AC', '00000000', '00000000', 'BF07A8C6'),
(23, 'Teletown - Khayyaban', 'Khayyaban', '9F44001A', '42B40000', '41C46C8B', '4212344F', 'BF4858FF', '00000000', '00000000', 'BF1F5D25'),
(24, 'Teletown - Kryst', 'Kryst', 'E822002A', '4304B333', '4217999A', '41A0D70B', 'BF5DB3D0', '00000000', '00000000', 'BF000000'),
(25, 'Teletown - Lin', 'Lin', 'DC3C0011', '426EE148', '412C624E', '419069D0', 'BEB77C03', '00000000', '00000000', 'BF6EFF19'),
(26, 'Teletown - Linvak Tukal', 'Linvak Tukal', 'A21E001A', '42A60000', '42180000', '440C1733', '3F800000', '00000000', '00000000', '00000000'),
(27, 'Teletown - Lytelthorpe', 'Lytelthorpe', 'C0800007', '413B9168', '431B8F5C', '42041CC2', 'BECE0286', '00000000', '00000000', 'BF6A5CE6'),
(28, 'Teletown - MacNiall''s Freehold', 'MacNiall''s Freehold', 'F224001A', '42A3999A', '42040000', '3BA3D70A', '3E76DC5D', '00000000', '00000000', 'BF787326'),
(29, 'Teletown - Mayoi', 'Mayoi', 'E6320021', '42D6D581', '412C353F', '41EF433E', 'BF248DC1', '00000000', '00000000', 'BF441B76'),
(30, 'Teletown - Nanto', 'Nanto', 'E63E0022', '42C1EB85', '4216E354', '42952625', '00000000', '00000000', '00000000', 'BF800000'),
(31, 'Teletown - Neydisa', 'Neydisa', '95D60033', '4312E666', '428E999A', '42C786D4', 'BF3B3A04', '00000000', '00000000', 'BF2E976C'),
(32, 'Teletown - Oolutanga''s Refuge', 'Oolutanga''s Refuge', 'F6820033', '4311B333', '42476B85', '4268051F', 'BEEF61ED', '00000000', '00000000', 'BF624BDC'),
(33, 'Teletown - Plateau Village', 'Plateau Village', '49B70021', '42C83333', '41A66666', '436E9D03', 'BF167914', '00000000', '00000000', 'BF4F1BBD'),
(34, 'Teletown - Qalaba''r', 'Qalaba''r', '9722003A', '43285AA0', '41C4F1AA', '42CC0290', 'BF6C3BF7', '00000000', '00000000', 'BEC5464E'),
(35, 'Teletown - Redspire', 'Redspire', '17B2002A', '43049F7D', '41CE78D5', '4230051F', '3F7F9C95', '00000000', '00000000', 'BD6189BE'),
(36, 'Teletown - Rithwic', 'Rithwic', 'C98C0028', '42E354CA', '433E424E', '41B00A3D', 'BF3504F7', '00000000', '00000000', 'BF3504F7'),
(37, 'Teletown - Samsur', 'Samsur', '977B000C', '41CE7CEE', '4293B4BC', '3BA3D70A', '3F6E1134', '00000000', '00000000', 'BEBC4157'),
(38, 'Teletown - Sawato', 'Sawato', 'C95B0001', '416CCCCD', '3E99999A', '4140147A', '3F6E2FE0', '00000000', '00000000', 'BEBBA605'),
(39, 'Teletown - Shoushi', 'Shoushi', 'DA55001D', '42A9999A', '42C60000', '41A00A3D', '3F800000', '00000000', '00000000', '00000000'),
(40, 'Teletown - Singularity Caul', 'Singularity Caul Island', '09040008', '41366666', '433C999A', '42AF0B18', 'BF7F1077', '00000000', '00000000', 'BDAEEF1C'),
(41, 'Teletown - Stonehold', 'Stonehold', '64D5000B', '41F00000', '42480000', '429C0290', '3F57E879', '00000000', '00000000', 'BF098C7E'),
(42, 'Teletown - Timaru', 'Timaru', '1DB60025', '42C50000', '42C43333', '42F00290', '3F4F5EEA', '00000000', '00000000', 'BF161C7A'),
(43, 'Teletown - Tou-Tou', 'Tou-Tou', 'F65C002B', '42FCC625', '42589687', '41A00A3D', '3F6DBBAE', '00000000', '00000000', 'BEBDEFE9'),
(44, 'Teletown - Tufa', 'Tufa', '876C0008', '40000000', '433AE666', '41900A3D', 'BF3504F7', '00000000', '00000000', 'BF3504F7'),
(45, 'Teletown - Underground City', 'Underground City', '01E901AD', '42F00000', 'C3020000', 'C13FEB86', 'BF36E47E', '00000000', '00000000', 'BF332064'),
(46, 'Teletown - Uziz', 'Uziz', 'A260003C', '4336EB44', '42AFDE35', '41A00A3D', 'BEBA17D3', '00000000', '00000000', 'BF6E7DED'),
(47, 'Teletown - Wai Jhou', 'Wai Jhou', '3F31001F', '42A6334D', '431C310A', '4031EC53', '3F0A3AD2', '00000000', '00000000', '3F577910'),
(48, 'Teletown - Xarabydun', 'Xarabydun', '934B0021', '42D899D2', '40C32B22', '4191273D', 'BF76ED35', '00000000', '00000000', 'BE871A5D'),
(49, 'Teletown - Yanshi', 'Yanshi', 'B46F001E', '42966666', '42F83333', '420AC0DB', '3F800000', '00000000', '00000000', '00000000'),
(50, 'Teletown - Yaraq', 'Yaraq', '7D64000D', '41FF3333', '42D13333', '413F258C', '3F13BFC6', '00000000', '00000000', 'BF510F73'),
(51, 'Teletown - Zaikhal', 'Zaikhal', '80900013', '4281B9DB', '425EBF7D', '42F80290', 'BF6E0CBF', '00000000', '00000000', 'BEBC57C1');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tele_locations`
--
ALTER TABLE `tele_locations`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tele_locations`
--
ALTER TABLE `tele_locations`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=52;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;