geo_simulator.sql

-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 26-09-2016 a las 23:08:36
-- Versión del servidor: 10.1.17-MariaDB-1~trusty
-- Versión de PHP: 5.5.9-1ubuntu4.19

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

--
-- Base de datos: `geo-simulator`
--

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

--
-- Estructura de tabla para la tabla `aa_app`
--

CREATE TABLE IF NOT EXISTS `aa_app` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `state` tinyint(4) NOT NULL COMMENT '0: resume; 1: pause',
  `max_clients` tinyint(4) NOT NULL DEFAULT '5' COMMENT 'This mini app just support 5 clients',
  `max_users` tinyint(4) NOT NULL DEFAULT '5' COMMENT 'This mini app just support 5 users',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Volcado de datos para la tabla `aa_app`
--

INSERT INTO `aa_app` (`id`, `state`, `max_clients`, `max_users`) VALUES
(1, 0, 3, 3);

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

--
-- Estructura de tabla para la tabla `aa_entities`
--

CREATE TABLE IF NOT EXISTS `aa_entities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(120) NOT NULL,
  `lat` double NOT NULL,
  `lng` double NOT NULL,
  `entity_type` tinyint(4) NOT NULL COMMENT '0: Client; 1: User',
  `route_id` int(11) DEFAULT NULL,
  `last_point_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `route_id` (`route_id`),
  KEY `last_point_id` (`last_point_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Volcado de datos para la tabla `aa_entities`
--

INSERT INTO `aa_entities` (`id`, `name`, `lat`, `lng`, `entity_type`, `route_id`, `last_point_id`) VALUES
(1, 'Usuario 1', 19.424723, -99.133143, 0, NULL, NULL),
(3, 'Conductor 1', 19.434723, -99.133143, 1, 3, 72),
(4, 'Conductor 2', 19.425141, -99.133034, 1, 4, 105),
(5, 'Conductor 3', 19.434723, -99.131789, 1, 1, 1),
(6, 'Conductor 4', 19.434723, -99.133143, 1, 1, 21),
(7, 'Conductor 5', 19.425692, -99.131789, 1, 5, 236),
(8, 'Usuario 2', 19.425421, -99.133203, 0, NULL, NULL),
(9, 'Usuario 3', 19.407829, -99.187349, 0, NULL, NULL),
(10, 'Usuario 4', 19.424723, -99.133143, 0, NULL, NULL),
(11, 'Usuario 5', 19.3853, -99.15422, 0, NULL, NULL);

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

--
-- Estructura de tabla para la tabla `bb_points`
--

CREATE TABLE IF NOT EXISTS `bb_points` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `route_id` int(11) NOT NULL,
  `lat` double NOT NULL,
  `lng` double NOT NULL,
  `ordinal` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `route_id` (`route_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=327 ;

--
-- Volcado de datos para la tabla `bb_points`
--

INSERT INTO `bb_points` (`id`, `route_id`, `lat`, `lng`, `ordinal`) VALUES
(1, 1, 19.409159, -99.121828, 1),
(2, 1, 19.410141, -99.121899, 2),
(3, 1, 19.410821, -99.121928, 3),
(4, 1, 19.412252, -99.121956, 4),
(5, 1, 19.412719, -99.121933, 5),
(6, 1, 19.41301, -99.121913, 6),
(7, 1, 19.413539, -99.12186, 7),
(8, 1, 19.413861, -99.121802, 8),
(9, 1, 19.414121, -99.121769, 9),
(10, 1, 19.414322, -99.121728, 10),
(11, 1, 19.414524, -99.121697, 11),
(12, 1, 19.414702, -99.121724, 12),
(13, 1, 19.415046, -99.121655, 13),
(14, 1, 19.41537, -99.121612, 14),
(15, 1, 19.415734, -99.121566, 15),
(16, 1, 19.416215, -99.121496, 16),
(17, 1, 19.416752, -99.121432, 17),
(18, 1, 19.41683, -99.121699, 18),
(19, 1, 19.41689, -99.121565, 19),
(20, 1, 19.416893, -99.121415, 20),
(21, 1, 19.417134, -99.121332, 21),
(22, 1, 19.417492, -99.121289, 22),
(23, 1, 19.417647, -99.121266, 23),
(24, 1, 19.418068, -99.121214, 24),
(25, 1, 19.41843, -99.121162, 25),
(26, 1, 19.418748, -99.121117, 26),
(27, 1, 19.418876, -99.121226, 27),
(28, 2, 19.407839, -99.186405, 1),
(33, 3, 19.40789, -99.18602, 0),
(34, 3, 19.40784, -99.18601, 0),
(35, 3, 19.40777, -99.18601, 0),
(36, 3, 19.40781, -99.18455, 0),
(37, 3, 19.40779, -99.18433, 0),
(38, 3, 19.4077, -99.18417, 0),
(39, 3, 19.40766, -99.18406, 0),
(40, 3, 19.40771, -99.18405, 0),
(41, 3, 19.40777, -99.18404, 0),
(42, 3, 19.40785, -99.18403, 0),
(43, 3, 19.40795, -99.18402, 0),
(44, 3, 19.40809, -99.184, 0),
(45, 3, 19.40934, -99.18334, 0),
(46, 3, 19.40939, -99.18331, 0),
(47, 3, 19.41029, -99.18283, 0),
(48, 3, 19.41045, -99.18274, 0),
(49, 3, 19.41104, -99.18238, 0),
(50, 3, 19.4114, -99.18213, 0),
(51, 3, 19.41176, -99.1819, 0),
(52, 3, 19.4119, -99.18182, 0),
(53, 3, 19.41244, -99.18149, 0),
(54, 3, 19.41272, -99.1813, 0),
(55, 3, 19.41283, -99.18123, 0),
(56, 3, 19.41292, -99.18104, 0),
(57, 3, 19.41301, -99.18099, 0),
(58, 3, 19.41408, -99.18037, 0),
(59, 3, 19.41414, -99.18034, 0),
(60, 3, 19.41419, -99.18032, 0),
(61, 3, 19.41549, -99.1796, 0),
(62, 3, 19.41619, -99.17922, 0),
(63, 3, 19.41684, -99.17886, 0),
(64, 3, 19.41679, -99.17874, 0),
(65, 3, 19.41648, -99.17805, 0),
(66, 3, 19.41607, -99.17724, 0),
(67, 3, 19.41568, -99.17644, 0),
(68, 3, 19.41559, -99.17627, 0),
(69, 3, 19.41613, -99.17592, 0),
(70, 3, 19.41668, -99.17559, 0),
(71, 3, 19.41783, -99.17494, 0),
(72, 3, 19.41791, -99.1749, 0),
(73, 3, 19.41802, -99.1748, 0),
(74, 3, 19.41805, -99.17468, 0),
(75, 3, 19.41823, -99.17388, 0),
(76, 3, 19.41854, -99.17239, 0),
(77, 3, 19.41859, -99.17219, 0),
(78, 3, 19.41736, -99.17126, 0),
(79, 3, 19.41717, -99.1711, 0),
(80, 4, 19.38594, -99.15723, 0),
(81, 4, 19.38517, -99.15741, 0),
(82, 4, 19.38535, -99.15822, 0),
(83, 4, 19.38554, -99.15896, 0),
(84, 4, 19.3857, -99.15969, 0),
(85, 4, 19.38571, -99.15974, 0),
(86, 4, 19.38584, -99.16043, 0),
(87, 4, 19.38586, -99.16053, 0),
(88, 4, 19.38597, -99.16112, 0),
(89, 4, 19.38597, -99.16115, 0),
(90, 4, 19.38599, -99.16124, 0),
(91, 4, 19.386, -99.16128, 0),
(92, 4, 19.38635, -99.16275, 0),
(93, 4, 19.38643, -99.16312, 0),
(94, 4, 19.38654, -99.16359, 0),
(95, 4, 19.38667, -99.16411, 0),
(96, 4, 19.38686, -99.16492, 0),
(97, 4, 19.38703, -99.16562, 0),
(98, 4, 19.3872, -99.16636, 0),
(99, 4, 19.38737, -99.16712, 0),
(100, 4, 19.38745, -99.16747, 0),
(101, 4, 19.38767, -99.16862, 0),
(102, 4, 19.38768, -99.16866, 0),
(103, 4, 19.38786, -99.16936, 0),
(104, 4, 19.38788, -99.16965, 0),
(105, 4, 19.38792, -99.16983, 0),
(106, 4, 19.3878, -99.17002, 0),
(107, 4, 19.38699, -99.17138, 0),
(108, 4, 19.38659, -99.17218, 0),
(109, 4, 19.38653, -99.17235, 0),
(110, 4, 19.38644, -99.17288, 0),
(111, 4, 19.38635, -99.17357, 0),
(112, 4, 19.38634, -99.17368, 0),
(113, 4, 19.38622, -99.17444, 0),
(114, 4, 19.38615, -99.17486, 0),
(115, 4, 19.38608, -99.17507, 0),
(116, 4, 19.38595, -99.176, 0),
(117, 4, 19.38584, -99.17672, 0),
(118, 4, 19.38575, -99.17733, 0),
(119, 4, 19.38568, -99.17772, 0),
(120, 4, 19.38566, -99.17786, 0),
(121, 4, 19.38559, -99.17839, 0),
(122, 4, 19.38553, -99.17846, 0),
(123, 4, 19.38541, -99.17914, 0),
(124, 4, 19.38444, -99.17872, 0),
(125, 4, 19.38427, -99.17892, 0),
(126, 4, 19.38399, -99.17914, 0),
(127, 4, 19.38357, -99.1792, 0),
(128, 4, 19.38317, -99.1791, 0),
(129, 4, 19.41298, -99.18192, 0),
(130, 4, 19.41355, -99.18169, 0),
(131, 4, 19.4134, -99.18128, 0),
(132, 4, 19.41243, -99.18184, 0),
(133, 4, 19.41235, -99.18189, 0),
(134, 4, 19.412, -99.182, 0),
(135, 4, 19.41192, -99.18206, 0),
(136, 4, 19.41175, -99.18217, 0),
(137, 4, 19.41146, -99.18235, 0),
(138, 4, 19.41137, -99.1824, 0),
(139, 4, 19.41048, -99.18291, 0),
(140, 4, 19.41033, -99.183, 0),
(141, 4, 19.40941, -99.18351, 0),
(142, 4, 19.40937, -99.18354, 0),
(143, 4, 19.40921, -99.18367, 0),
(144, 4, 19.40915, -99.18371, 0),
(145, 4, 19.40828, -99.18419, 0),
(146, 4, 19.40793, -99.18432, 0),
(147, 4, 19.40796, -99.18455, 0),
(148, 4, 19.40792, -99.18545, 0),
(149, 4, 19.40789, -99.18602, 0),
(150, 4, 19.40783, -99.18794, 0),
(151, 4, 19.4078, -99.18953, 0),
(152, 4, 19.40779, -99.18972, 0),
(153, 4, 19.40762, -99.18964, 0),
(154, 4, 19.40509, -99.18835, 0),
(155, 4, 19.40417, -99.18795, 0),
(156, 4, 19.40406, -99.1879, 0),
(157, 4, 19.403, -99.1873, 0),
(158, 4, 19.40211, -99.18681, 0),
(159, 4, 19.40193, -99.1867, 0),
(160, 4, 19.40183, -99.18663, 0),
(161, 4, 19.40164, -99.18653, 0),
(162, 4, 19.40145, -99.18648, 0),
(163, 4, 19.40135, -99.18646, 0),
(164, 4, 19.4012, -99.1865, 0),
(165, 4, 19.40081, -99.18651, 0),
(166, 4, 19.4001, -99.18653, 0),
(167, 4, 19.40009, -99.18654, 0),
(168, 4, 19.40007, -99.18655, 0),
(169, 4, 19.40004, -99.18675, 0),
(170, 4, 19.39997, -99.18684, 0),
(171, 4, 19.39992, -99.18699, 0),
(172, 4, 19.39985, -99.18713, 0),
(173, 4, 19.39982, -99.1874, 0),
(174, 4, 19.39973, -99.18836, 0),
(175, 4, 19.39968, -99.18922, 0),
(176, 4, 19.39967, -99.18946, 0),
(177, 4, 19.39968, -99.19006, 0),
(178, 4, 19.39978, -99.19125, 0),
(179, 4, 19.3999, -99.19177, 0),
(180, 4, 19.4, -99.1924, 0),
(181, 4, 19.40003, -99.1927, 0),
(182, 4, 19.39993, -99.19309, 0),
(183, 4, 19.39989, -99.19326, 0),
(184, 4, 19.39923, -99.19503, 0),
(185, 4, 19.39916, -99.1952, 0),
(186, 4, 19.39906, -99.19554, 0),
(187, 4, 19.39908, -99.19573, 0),
(188, 4, 19.39912, -99.19593, 0),
(189, 4, 19.39925, -99.19621, 0),
(190, 4, 19.3993, -99.19629, 0),
(191, 4, 19.3993, -99.19652, 0),
(192, 4, 19.39911, -99.19702, 0),
(193, 4, 19.39905, -99.19728, 0),
(194, 4, 19.39908, -99.19782, 0),
(195, 4, 19.3991, -99.19815, 0),
(196, 4, 19.39892, -99.19899, 0),
(197, 4, 19.3989, -99.19911, 0),
(198, 4, 19.39888, -99.19926, 0),
(199, 4, 19.39887, -99.1994, 0),
(200, 4, 19.39881, -99.19965, 0),
(201, 4, 19.39865, -99.20026, 0),
(202, 4, 19.3986, -99.20057, 0),
(203, 4, 19.39846, -99.20117, 0),
(204, 4, 19.39832, -99.20183, 0),
(205, 4, 19.39812, -99.20229, 0),
(206, 4, 19.39786, -99.20285, 0),
(207, 4, 19.39782, -99.20294, 0),
(208, 4, 19.39774, -99.2031, 0),
(209, 4, 19.39763, -99.20368, 0),
(210, 4, 19.39754, -99.20405, 0),
(211, 4, 19.39745, -99.20412, 0),
(212, 4, 19.39735, -99.20414, 0),
(213, 4, 19.39723, -99.20412, 0),
(214, 4, 19.39673, -99.2039, 0),
(215, 4, 19.39664, -99.20378, 0),
(216, 4, 19.3966, -99.20368, 0),
(217, 4, 19.39673, -99.20335, 0),
(218, 4, 19.39679, -99.20308, 0),
(219, 4, 19.39682, -99.20282, 0),
(220, 4, 19.39684, -99.2019, 0),
(221, 4, 19.39687, -99.20183, 0),
(222, 4, 19.39694, -99.20177, 0),
(223, 4, 19.39704, -99.20165, 0),
(224, 4, 19.39724, -99.20161, 0),
(225, 4, 19.3974, -99.20153, 0),
(226, 4, 19.39759, -99.20138, 0),
(227, 4, 19.39771, -99.20113, 0),
(228, 5, 19.41298, -99.18192, 0),
(229, 5, 19.41355, -99.18169, 0),
(230, 5, 19.4134, -99.18128, 0),
(231, 5, 19.41243, -99.18184, 0),
(232, 5, 19.41235, -99.18189, 0),
(233, 5, 19.412, -99.182, 0),
(234, 5, 19.41192, -99.18206, 0),
(235, 5, 19.41175, -99.18217, 0),
(236, 5, 19.41146, -99.18235, 0),
(237, 5, 19.41137, -99.1824, 0),
(238, 5, 19.41048, -99.18291, 0),
(239, 5, 19.41033, -99.183, 0),
(240, 5, 19.40941, -99.18351, 0),
(241, 5, 19.40937, -99.18354, 0),
(242, 5, 19.40921, -99.18367, 0),
(243, 5, 19.40915, -99.18371, 0),
(244, 5, 19.40828, -99.18419, 0),
(245, 5, 19.40793, -99.18432, 0),
(246, 5, 19.40796, -99.18455, 0),
(247, 5, 19.40792, -99.18545, 0),
(248, 5, 19.40789, -99.18602, 0),
(249, 5, 19.40783, -99.18794, 0),
(250, 5, 19.4078, -99.18953, 0),
(251, 5, 19.40779, -99.18972, 0),
(252, 5, 19.40762, -99.18964, 0),
(253, 5, 19.40509, -99.18835, 0),
(254, 5, 19.40417, -99.18795, 0),
(255, 5, 19.40406, -99.1879, 0),
(256, 5, 19.403, -99.1873, 0),
(257, 5, 19.40211, -99.18681, 0),
(258, 5, 19.40193, -99.1867, 0),
(259, 5, 19.40183, -99.18663, 0),
(260, 5, 19.40164, -99.18653, 0),
(261, 5, 19.40145, -99.18648, 0),
(262, 5, 19.40135, -99.18646, 0),
(263, 5, 19.4012, -99.1865, 0),
(264, 5, 19.40081, -99.18651, 0),
(265, 5, 19.4001, -99.18653, 0),
(266, 5, 19.40009, -99.18654, 0),
(267, 5, 19.40007, -99.18655, 0),
(268, 5, 19.40004, -99.18675, 0),
(269, 5, 19.39997, -99.18684, 0),
(270, 5, 19.39992, -99.18699, 0),
(271, 5, 19.39985, -99.18713, 0),
(272, 5, 19.39982, -99.1874, 0),
(273, 5, 19.39973, -99.18836, 0),
(274, 5, 19.39968, -99.18922, 0),
(275, 5, 19.39967, -99.18946, 0),
(276, 5, 19.39968, -99.19006, 0),
(277, 5, 19.39978, -99.19125, 0),
(278, 5, 19.3999, -99.19177, 0),
(279, 5, 19.4, -99.1924, 0),
(280, 5, 19.40003, -99.1927, 0),
(281, 5, 19.39993, -99.19309, 0),
(282, 5, 19.39989, -99.19326, 0),
(283, 5, 19.39923, -99.19503, 0),
(284, 5, 19.39916, -99.1952, 0),
(285, 5, 19.39906, -99.19554, 0),
(286, 5, 19.39908, -99.19573, 0),
(287, 5, 19.39912, -99.19593, 0),
(288, 5, 19.39925, -99.19621, 0),
(289, 5, 19.3993, -99.19629, 0),
(290, 5, 19.3993, -99.19652, 0),
(291, 5, 19.39911, -99.19702, 0),
(292, 5, 19.39905, -99.19728, 0),
(293, 5, 19.39908, -99.19782, 0),
(294, 5, 19.3991, -99.19815, 0),
(295, 5, 19.39892, -99.19899, 0),
(296, 5, 19.3989, -99.19911, 0),
(297, 5, 19.39888, -99.19926, 0),
(298, 5, 19.39887, -99.1994, 0),
(299, 5, 19.39881, -99.19965, 0),
(300, 5, 19.39865, -99.20026, 0),
(301, 5, 19.3986, -99.20057, 0),
(302, 5, 19.39846, -99.20117, 0),
(303, 5, 19.39832, -99.20183, 0),
(304, 5, 19.39812, -99.20229, 0),
(305, 5, 19.39786, -99.20285, 0),
(306, 5, 19.39782, -99.20294, 0),
(307, 5, 19.39774, -99.2031, 0),
(308, 5, 19.39763, -99.20368, 0),
(309, 5, 19.39754, -99.20405, 0),
(310, 5, 19.39745, -99.20412, 0),
(311, 5, 19.39735, -99.20414, 0),
(312, 5, 19.39723, -99.20412, 0),
(313, 5, 19.39673, -99.2039, 0),
(314, 5, 19.39664, -99.20378, 0),
(315, 5, 19.3966, -99.20368, 0),
(316, 5, 19.39673, -99.20335, 0),
(317, 5, 19.39679, -99.20308, 0),
(318, 5, 19.39682, -99.20282, 0),
(319, 5, 19.39684, -99.2019, 0),
(320, 5, 19.39687, -99.20183, 0),
(321, 5, 19.39694, -99.20177, 0),
(322, 5, 19.39704, -99.20165, 0),
(323, 5, 19.39724, -99.20161, 0),
(324, 5, 19.3974, -99.20153, 0),
(325, 5, 19.39759, -99.20138, 0),
(326, 5, 19.39771, -99.20113, 0);

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

--
-- Estructura de tabla para la tabla `bb_routes`
--

CREATE TABLE IF NOT EXISTS `bb_routes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origin` varchar(120) NOT NULL,
  `destination` varchar(120) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Volcado de datos para la tabla `bb_routes`
--

INSERT INTO `bb_routes` (`id`, `origin`, `destination`) VALUES
(1, 'Metro Jamaica', 'Oriente 32'),
(2, 'Vicente Agustín Eguía', 'Metro Patriotismo'),
(3, 'Gob. Agustín Vicente Eguía, Tacubaya, Chapultepec', 'Colima, Roma Norte, Ciudad de México'),
(4, 'Pastelerias Esperanza - Narvarte, 907, Cuauhtémoc', 'Estadio Azul, Carolina, Ampliación Nápoles, Benito Juarez'),
(5, 'Metro Juanacatlán, 73', 'Metro Línea 1, Río de Tacubaya');

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

--
-- Estructura de tabla para la tabla `cc_active`
--

CREATE TABLE IF NOT EXISTS `cc_active` (
  `entity_id` int(11) NOT NULL,
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Volcado de datos para la tabla `cc_active`
--

INSERT INTO `cc_active` (`entity_id`) VALUES
(1),
(3),
(4),
(5),
(8),
(9);

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `aa_entities`
--
ALTER TABLE `aa_entities`
  ADD CONSTRAINT `aa_entities_ibfk_1` FOREIGN KEY (`route_id`) REFERENCES `bb_routes` (`id`),
  ADD CONSTRAINT `aa_entities_ibfk_2` FOREIGN KEY (`last_point_id`) REFERENCES `bb_points` (`id`);

--
-- Filtros para la tabla `bb_points`
--
ALTER TABLE `bb_points`
  ADD CONSTRAINT `bb_points_ibfk_1` FOREIGN KEY (`route_id`) REFERENCES `bb_routes` (`id`);

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