-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.56-community


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

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema pos
--

CREATE DATABASE IF NOT EXISTS pos;
USE pos;

--
-- Definition of table `waitarea_data`
--

DROP TABLE IF EXISTS `waitarea_data`;
CREATE TABLE `waitarea_data` (
  `seq` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `poiname` varchar(50) DEFAULT '',
  `regioncd` smallint(6) DEFAULT '0',
  `xpos` int(10) unsigned DEFAULT '0',
  `ypos` int(10) unsigned DEFAULT '0',
  `distance` int(10) unsigned DEFAULT '50',
  `createtm` datetime DEFAULT '0000-00-00 00:00:00',
  `coordseq` smallint(5) unsigned DEFAULT '0',
  `version` smallint(5) unsigned DEFAULT '0',
  `areacode` smallint(6) DEFAULT '0',
  `areasubcode` smallint(6) DEFAULT '0',
  `sectioncode` smallint(6) DEFAULT '0',
  PRIMARY KEY (`seq`)
) ENGINE=InnoDB AUTO_INCREMENT=8132 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `waitarea_data`
--

/*!40000 ALTER TABLE `waitarea_data` DISABLE KEYS */;
INSERT INTO `waitarea_data` (`seq`,`poiname`,`regioncd`,`xpos`,`ypos`,`distance`,`createtm`,`coordseq`,`version`,`areacode`,`areasubcode`,`sectioncode`) VALUES 
 (2338,'센트리아',10,3473094,4137514,50,'2018-11-02 17:37:14',0,8,0,0,0),
 (2339,'센트리아',10,3473094,4137514,50,'2018-11-02 17:37:14',1,0,0,0,0),
 (2340,'센트리아',10,3473496,4136310,50,'2018-11-02 17:37:17',2,0,0,0,0),
 (2341,'센트리아',10,3472004,4135815,50,'2018-11-02 17:37:19',3,0,0,0,0),
 (2342,'센트리아',10,3471589,4137007,50,'2018-11-02 17:37:22',4,0,0,0,0),
 (2343,'센트리아',10,3473094,4137514,50,'2018-11-02 17:37:23',5,0,0,0,0),
 (8011,'율하',10,4646264,3633532,4,'2019-01-10 11:16:01',0,8,0,0,0),
 (8012,'율하',10,4646264,3633532,50,'2019-01-10 11:10:52',1,0,0,0,0),
 (8013,'율하',10,4646239,3626602,50,'2019-01-10 11:11:11',2,0,0,0,0),
 (8014,'율하',10,4633386,3621510,50,'2019-01-10 11:11:33',3,0,0,0,0),
 (8015,'율하',10,4617553,3623881,50,'2019-01-10 11:11:39',4,0,0,0,0),
 (8016,'율하',10,4614542,3633639,50,'2019-01-10 11:14:22',5,0,0,0,0),
 (8017,'율하',10,4628838,3638031,50,'2019-01-10 11:14:39',6,0,0,0,0),
 (8018,'율하',10,4640104,3654496,50,'2019-01-10 11:15:05',7,0,0,0,0),
 (8019,'율하',10,4641635,3643696,50,'2019-01-10 11:15:18',8,0,0,0,0),
 (8020,'율하',10,4646416,3643172,50,'2019-01-10 11:15:23',9,0,0,0,0),
 (8021,'율하',10,4646264,3633532,50,'2019-01-10 11:15:25',10,0,0,0,0),
 (8022,'부천',10,2921115,5433003,50,'2019-05-08 20:33:51',0,8,0,0,0),
 (8023,'부천',10,2921115,5433003,50,'2019-05-08 20:33:51',1,0,0,0,0),
 (8024,'부천',10,2923020,5432606,50,'2019-05-08 20:33:53',2,0,0,0,0),
 (8025,'부천',10,2922799,5431299,50,'2019-05-08 20:33:55',3,0,0,0,0),
 (8026,'부천',10,2920637,5431666,50,'2019-05-08 20:33:57',4,0,0,0,0),
 (8027,'부천',10,2921115,5433003,50,'2019-05-08 20:33:58',5,0,0,0,0),
 (8028,'부천역',50,2923378,5431696,50,'2019-06-20 09:51:47',0,0,0,0,0),
 (8029,'부천역',50,2923378,5431696,50,'2019-06-20 09:51:47',1,0,0,0,0),
 (8030,'부천역',50,2928149,5430933,50,'2019-06-20 09:51:51',2,0,0,0,0),
 (8031,'test1',10,4412040,5092166,0,'2020-08-18 16:29:16',0,0,31,0,0),
 (8032,'test1',10,4412040,5092166,0,'2020-08-18 16:29:16',1,0,31,0,0),
 (8033,'test1',10,4415700,5091966,0,'2020-08-18 16:29:19',2,0,31,0,0),
 (8034,'test1',10,4414371,5090353,0,'2020-08-18 16:29:20',3,0,31,0,0),
 (8035,'test1',10,4411212,5090630,0,'2020-08-18 16:29:21',4,0,31,0,0),
 (8038,'test2',10,4419206,5094888,50,'2020-08-18 16:30:02',0,0,31,0,0),
 (8039,'test2',10,4419206,5094888,50,'2020-08-18 16:30:02',1,0,31,0,0),
 (8040,'test2',10,4414342,5094294,50,'2020-08-18 16:30:04',2,0,31,0,0),
 (8041,'test2',10,4412798,5097443,50,'2020-08-18 16:30:05',3,0,31,0,0),
 (8042,'test2',10,4417740,5097617,50,'2020-08-18 16:30:06',4,0,31,0,0),
 (8043,'테스트1',10,3720606,2603415,50,'2020-11-20 10:45:14',0,0,32,0,0),
 (8044,'테스트1',10,3720606,2603415,50,'2020-11-20 10:45:14',1,0,32,0,0),
 (8045,'테스트1',10,3724058,2601677,50,'2020-11-20 10:45:16',2,0,32,0,0),
 (8046,'테스트1',10,3720187,2601656,50,'2020-11-20 10:45:17',3,0,32,0,0),
 (8047,'테스트1',10,3719463,2602920,50,'2020-11-20 10:45:18',4,0,32,0,0),
 (8048,'테스트1',10,3720606,2603415,50,'2020-11-20 10:45:22',5,0,32,0,0),
 (8058,'테스트2',50,3727578,2607351,50,'2021-02-02 16:09:34',0,0,0,0,0),
 (8059,'테스트2',50,3727578,2607351,50,'2021-02-02 16:09:34',1,0,0,0,0),
 (8060,'테스트2',50,3729228,2605262,50,'2021-02-02 16:09:38',2,0,0,0,0),
 (8061,'테스트2',50,3729263,2608323,50,'2021-02-02 16:09:41',3,0,0,0,0),
 (8062,'테스트2',50,3727545,2608852,50,'2021-02-02 16:09:42',4,0,0,0,0),
 (8063,'테스트2',50,3727119,2607634,50,'2021-02-02 16:09:45',5,0,0,0,0),
 (8075,'test_03',10,3544193,4492220,50,'2021-02-03 11:06:39',0,0,31,0,0),
 (8076,'test_03',10,3542457,4491109,50,'2021-02-03 11:06:40',2,0,31,0,0),
 (8077,'test_03',10,3544955,4490506,50,'2021-02-03 11:06:41',3,0,31,0,0),
 (8078,'test_03',10,3546051,4491630,50,'2021-02-03 11:06:42',4,0,31,0,0),
 (8079,'test_03',10,3545378,4493014,50,'2021-02-03 11:06:43',5,0,31,0,0),
 (8080,'test_03',10,3544193,4492220,50,'2021-02-03 11:06:45',6,0,31,0,0),
 (8081,'테스트_04',10,3726606,2604185,50,'2021-02-03 12:10:49',0,0,0,0,0),
 (8082,'테스트_04',10,3727593,2603510,50,'2021-02-03 12:10:53',2,0,0,0,0),
 (8083,'테스트_04',10,3726301,2603146,50,'2021-02-03 12:10:54',3,0,0,0,0),
 (8084,'테스트_04',10,3725785,2603879,50,'2021-02-03 12:10:55',4,0,0,0,0),
 (8085,'테스트_04',10,3726606,2604185,50,'2021-02-03 12:11:03',5,0,0,0,0),
 (8086,'테스트_20',10,3726804,2601683,50,'2021-02-03 12:24:29',0,0,0,0,0),
 (8087,'테스트_20',10,3729394,2601550,50,'2021-02-03 12:24:30',2,0,0,0,0),
 (8088,'테스트_20',10,3727980,2600837,50,'2021-02-03 12:24:32',3,0,0,0,0),
 (8089,'테스트_20',10,3726792,2601343,50,'2021-02-03 12:24:34',4,0,0,0,0),
 (8090,'테스트_20',10,3726524,2601685,50,'2021-02-03 12:24:35',5,0,0,0,0),
 (8091,'테스트_21',10,3722728,2604645,50,'2021-02-03 12:31:51',0,0,0,0,0),
 (8092,'테스트_21',10,3723592,2603580,50,'2021-02-03 12:31:52',2,0,0,0,0),
 (8093,'테스트_21',10,3721745,2604119,50,'2021-02-03 12:31:53',3,0,0,0,0),
 (8094,'테스트_21',10,3722009,2604958,50,'2021-02-03 12:31:54',4,0,0,0,0),
 (8095,'테스트_21',10,3722728,2604645,50,'2021-02-03 12:31:58',5,0,0,0,0),
 (8096,'테스트_22',10,3726861,2605024,50,'2021-02-03 12:40:26',0,0,0,0,0),
 (8097,'테스트_22',10,3728477,2604206,50,'2021-02-03 12:40:27',2,0,0,0,0),
 (8098,'테스트_22',10,3729575,2603600,50,'2021-02-03 12:40:29',3,0,0,0,0),
 (8099,'테스트_22',10,3726861,2605024,50,'2021-02-03 12:40:39',4,0,0,0,0),
 (8100,'테스트_23',10,3723669,2600819,50,'2021-02-03 12:45:35',0,0,0,0,0),
 (8101,'테스트_23',10,3725734,2599708,50,'2021-02-03 12:45:38',2,0,0,0,0),
 (8102,'테스트_23',10,3724511,2599134,50,'2021-02-03 12:45:39',3,0,0,0,0),
 (8103,'테스트_23',10,3722665,2600163,50,'2021-02-03 12:45:40',4,0,0,0,0),
 (8104,'테스트_23',10,3723099,2600901,50,'2021-02-03 12:45:41',5,0,0,0,0),
 (8105,'테스트_23',10,3723669,2600819,50,'2021-02-03 12:45:47',6,0,0,0,0),
 (8106,'테스트_14',10,3724587,2602365,50,'2021-02-03 12:52:40',0,0,0,0,0),
 (8107,'테스트_14',10,3725489,2600799,50,'2021-02-03 12:52:41',2,0,0,0,0),
 (8108,'테스트_14',10,3724000,2601007,50,'2021-02-03 12:52:42',3,0,0,0,0),
 (8109,'테스트_14',10,3724197,2602527,50,'2021-02-03 12:52:43',4,0,0,0,0),
 (8110,'테스트_14',10,3724648,2602614,50,'2021-02-03 12:52:44',5,0,0,0,0),
 (8111,'테스트_14',10,3724587,2602365,50,'2021-02-03 12:52:46',6,0,0,0,0),
 (8112,'테스트_14',50,3724587,2602365,50,'2021-02-03 12:52:46',6,0,0,0,0),
 (8116,'광진구',11,3167938,5477654,50,'2021-05-11 22:58:35',0,0,0,0,0),
 (8117,'광진구',11,3167938,5477654,50,'2021-05-11 22:58:35',1,0,0,0,0),
 (8118,'광진구',11,3183617,5512024,50,'2021-05-11 22:59:31',2,0,0,0,0),
 (8119,'광진구',11,3182419,5512591,50,'2021-05-11 22:59:51',3,0,0,0,0),
 (8122,'광진구',11,3187952,5525806,50,'2021-05-11 23:01:39',4,0,0,0,0),
 (8123,'광진구',11,3194668,5524670,50,'2021-05-11 23:02:14',5,0,0,0,0),
 (8124,'광진구',11,3196488,5524560,50,'2021-05-11 23:02:22',6,0,0,0,0),
 (8125,'광진구',11,3197116,5522136,50,'2021-05-11 23:02:34',7,0,0,0,0),
 (8127,'광진구',11,3214587,5511759,50,'2021-05-11 23:05:45',8,0,0,0,0),
 (8128,'광진구',11,3222718,5509395,50,'2021-05-11 23:06:00',9,0,0,0,0),
 (8129,'광진구',11,3215516,5494468,50,'2021-05-11 23:06:16',10,0,0,0,0),
 (8130,'광진구',11,3193158,5473938,50,'2021-05-11 23:06:26',11,0,0,0,0),
 (8131,'광진구',11,3167938,5477654,50,'2021-05-11 23:06:29',12,0,0,0,0);
/*!40000 ALTER TABLE `waitarea_data` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;