/*
Navicat MySQL Data Transfer

Source Server         : Mercadic
Source Server Version : 50633
Source Host           : mercadictos.com:3306
Source Database       : mercadic_restorder

Target Server Type    : MYSQL
Target Server Version : 50633
File Encoding         : 65001

Date: 2016-10-07 16:32:58
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for administradores
-- ----------------------------
DROP TABLE IF EXISTS `administradores`;
CREATE TABLE `administradores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(48) NOT NULL,
  `nombre` varchar(48) NOT NULL,
  `apellido` varchar(48) NOT NULL,
  `clave` varchar(48) NOT NULL,
  `correo_electronico` varchar(48) NOT NULL,
  `fecha_registro` datetime NOT NULL,
  `id_propietario` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of administradores
-- ----------------------------
INSERT INTO `administradores` VALUES ('1', 'alz', 'Alexis', 'Aldana', '20725281', 'alz7xj@gmail.com', '2016-09-08 09:47:53', '1');
INSERT INTO `administradores` VALUES ('2', 'marceardila', 'Marcela', 'Ardils', 'Malu_2015', 'marceardila@gmail.com', '2016-09-26 18:26:05', '1');
INSERT INTO `administradores` VALUES ('3', 'cami', 'camilo', 'gomez', '12345', 'adggc@fgv.com', '2016-10-06 02:20:46', '1');

-- ----------------------------
-- Table structure for articulos
-- ----------------------------
DROP TABLE IF EXISTS `articulos`;
CREATE TABLE `articulos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(32) NOT NULL,
  `foto` varchar(64) NOT NULL,
  `descripcion` text NOT NULL,
  `precio` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of articulos
-- ----------------------------
INSERT INTO `articulos` VALUES ('16', 'Articulo 1', 'art-4-16-1475000748000.jpg', 'Articulo 1', '100');
INSERT INTO `articulos` VALUES ('17', 'Artículo 2', 'art-4-17-1474738643000.jpg', 'Artículo 2', '133');
INSERT INTO `articulos` VALUES ('18', 'Artículo 3', 'art-4-18-1474738683000.jpg', 'Artículo 3', '23');
INSERT INTO `articulos` VALUES ('19', 'Artículo 1', 'art-6-19-1474738904000.jpg', 'Artículo 1', '49');
INSERT INTO `articulos` VALUES ('20', 'Artículo 1', 'art-5-20-1474739018000.jpg', 'Artículo 1', '67');
INSERT INTO `articulos` VALUES ('21', 'Artículo 1', 'art-7-21-1475242728000.jpg', 'Artículo 1', '5900');
INSERT INTO `articulos` VALUES ('22', 'Articulo 4', 'art-4-22-1475000840000.jpg', 'Articulo 4', '230');
INSERT INTO `articulos` VALUES ('23', '2', 'art-10-23-1475059666000.png', '2', '2');
INSERT INTO `articulos` VALUES ('24', 'sopa de verdura', 'art-11-24-1475073013000.jpg', 'fgfhgg', '30');
INSERT INTO `articulos` VALUES ('27', 'Art SM 1', 'art-4-27-1475164742000.jpg', 'Art SM 1', '233');
INSERT INTO `articulos` VALUES ('28', '7', 'art-4-28-1475263968000.jpg', 'Hh', '9');
INSERT INTO `articulos` VALUES ('29', 'carne Asada', 'art-23-29-1475721243000.jpg', 'carne bien asada.de ternera', '100');
INSERT INTO `articulos` VALUES ('30', 'termino medio', 'art-26-30-1475751321000.jpg', 'termino medio', '150');
INSERT INTO `articulos` VALUES ('31', 'sm3', 'art-32-31-1475762791000.jpg', 's4', '900');
INSERT INTO `articulos` VALUES ('32', 'Pescado Salmón', 'art-38-32-1475784807000.jpg', 'delicioso salmón en salsa de la casa', '50000');
INSERT INTO `articulos` VALUES ('33', 'salsa de camarones', 'art-38-33-1475784940000.jpg', 'delicioso adereso de salsa de camarones', '10');
INSERT INTO `articulos` VALUES ('34', 'Robalo', 'art-38-34-1475785147000.jpg', 'deli', '30');
INSERT INTO `articulos` VALUES ('35', 'pescado frito', 'art-38-35-1475837143000.jpg', 'fresco pescado', '25000');
INSERT INTO `articulos` VALUES ('36', 'sopas dr nabos', 'art-46-36-1475860101000.jpg', 'deliciosa sopa de nabos con papa', '50');
INSERT INTO `articulos` VALUES ('38', 'sopa de espinaca', 'art-46-38-1475860374000.jpg', 'deliciosa sopa de espinaca', '30');

-- ----------------------------
-- Table structure for clientes
-- ----------------------------
DROP TABLE IF EXISTS `clientes`;
CREATE TABLE `clientes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_administrador` int(11) NOT NULL,
  `nombre` varchar(48) NOT NULL,
  `apellido` varchar(48) NOT NULL,
  `usuario` varchar(48) NOT NULL,
  `clave` varchar(48) NOT NULL,
  `correo_electronico` varchar(48) NOT NULL,
  `foto` varchar(64) DEFAULT NULL,
  `telefono` varchar(32) NOT NULL,
  `pais` varchar(32) NOT NULL,
  `ciudad` varchar(48) NOT NULL,
  `codigo_recuperacion_clave` varchar(4) DEFAULT NULL,
  `fecha_codigo_recuperacion_clave` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of clientes
-- ----------------------------
INSERT INTO `clientes` VALUES ('3', '1', 'demo', 'demo', 'demo', 'demo', 'ulisesrn01@gmail.com', 'cli-3.jpg', 'demo', '52', 'demo', '9603', '2016-09-28 08:02:01');
INSERT INTO `clientes` VALUES ('4', '0', 'Marcela', 'Ardila', 'marceardila', '12345', 'marceardila@gmail.com', null, '3165386375', '52', 'Bogotá', null, null);
INSERT INTO `clientes` VALUES ('7', '0', 'demoo', 'demoo', 'demoo', 'demoo', 'demoo@demoo.com', 'cli-3.jpg', 'demoo', '1', 'demoo', null, null);
INSERT INTO `clientes` VALUES ('8', '0', 'luli', 'cool', 'luli', '12345', 'luli@luli.com', 'cli-8.jpg', '3165386375', '49', 'Bogota', null, null);

-- ----------------------------
-- Table structure for clientes_pedidos
-- ----------------------------
DROP TABLE IF EXISTS `clientes_pedidos`;
CREATE TABLE `clientes_pedidos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cliente` int(11) NOT NULL,
  `id_sucursal` int(11) NOT NULL,
  `codigo` varchar(12) NOT NULL,
  `json_pedidos` text NOT NULL,
  `numero_orden` bigint(20) NOT NULL,
  `confirmado` tinyint(1) NOT NULL,
  `espera` tinyint(1) NOT NULL,
  `fecha` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of clientes_pedidos
-- ----------------------------
INSERT INTO `clientes_pedidos` VALUES ('5', '3', '14', '2DB6G2', '[{\"id_art\":\"18\",\"cant\":\"2\"},{\"id_art\":\"21\",\"cant\":\"3\"}]', '2', '1', '2', '2016-09-25 16:25:03');
INSERT INTO `clientes_pedidos` VALUES ('6', '3', '14', 'UNB6GH', '[{\"id_art\":\"17\",\"cant\":\"1\"},{\"id_art\":\"18\",\"cant\":\"2\"}]', '3', '0', '0', '2016-09-25 16:33:00');
INSERT INTO `clientes_pedidos` VALUES ('7', '3', '17', '5SZTTF', '[{\"id_art\":\"17\",\"cant\":\"4\"}]', '4', '0', '0', '2016-09-25 16:33:35');
INSERT INTO `clientes_pedidos` VALUES ('8', '3', '16', 'PA8WY8', '[{\"id_art\":\"16\",\"cant\":\"6\"},{\"id_art\":\"18\",\"cant\":\"4\"}]', '5', '0', '0', '2016-09-26 08:46:57');
INSERT INTO `clientes_pedidos` VALUES ('9', '3', '14', '27955330', '[{\"id_art\":\"17\",\"cant\":\"6\"}]', '6', '1', '2', '2016-09-26 08:48:52');
INSERT INTO `clientes_pedidos` VALUES ('14', '3', '14', '205216', '[{\"id_art\":\"16\",\"cant\":\"3\"}]', '7', '0', '0', '2016-09-26 19:16:31');
INSERT INTO `clientes_pedidos` VALUES ('15', '3', '14', '292579', '[{\"id_art\":\"17\",\"cant\":\"3\"}]', '8', '0', '0', '2016-09-28 06:18:26');
INSERT INTO `clientes_pedidos` VALUES ('16', '3', '14', '078441', '[{\"id_art\":\"16\",\"cant\":\"4\"},{\"id_art\":\"17\",\"cant\":\"3\"},{\"id_art\":\"18\",\"cant\":\"3\"}]', '9', '0', '0', '2016-09-28 06:50:44');
INSERT INTO `clientes_pedidos` VALUES ('17', '3', '14', '290752', '[{\"id_art\":\"16\",\"cant\":\"1\"},{\"id_art\":\"18\",\"cant\":\"4\"}]', '10', '0', '0', '2016-10-01 02:12:02');
INSERT INTO `clientes_pedidos` VALUES ('18', '3', '14', '155236', '[{\"id_art\":\"16\",\"cant\":\"1\"},{\"id_art\":\"17\",\"cant\":\"4\"}]', '11', '0', '0', '2016-10-01 02:22:36');
INSERT INTO `clientes_pedidos` VALUES ('19', '3', '14', '022908', '[{\"id_art\":\"16\",\"cant\":\"1\"},{\"id_art\":\"21\",\"cant\":\"3\"}]', '12', '0', '0', '2016-10-05 14:43:45');
INSERT INTO `clientes_pedidos` VALUES ('20', '3', '22', '848884', '[{\"id_art\":\"29\",\"cant\":\"1\",\"total_cost\":0}]', '13', '1', '2', '2016-10-06 02:40:47');
INSERT INTO `clientes_pedidos` VALUES ('21', '3', '14', '407705', '[{\"id_art\":\"17\",\"cant\":\"2\",\"total_cost\":266}]', '14', '1', '2', '2016-10-06 10:31:22');
INSERT INTO `clientes_pedidos` VALUES ('22', '3', '14', '959969', '[{\"id_art\":\"28\",\"cant\":\"1\",\"total_cost\":9}]', '15', '0', '0', '2016-10-06 11:44:38');
INSERT INTO `clientes_pedidos` VALUES ('23', '3', '22', '718162', '[{\"id_art\":\"29\",\"cant\":\"1\",\"total_cost\":100}]', '16', '1', '2', '2016-10-06 11:45:07');
INSERT INTO `clientes_pedidos` VALUES ('24', '3', '14', '470158', '[{\"id_art\":\"17\",\"cant\":\"1\",\"total_cost\":133}]', '17', '0', '0', '2016-10-06 19:55:00');
INSERT INTO `clientes_pedidos` VALUES ('25', '3', '25', '491888', '[{\"id_art\":\"32\",\"cant\":\"1\",\"total_cost\":50000},{\"id_art\":\"34\",\"cant\":\"1\",\"total_cost\":30}]', '18', '1', '0', '2016-10-06 20:23:46');
INSERT INTO `clientes_pedidos` VALUES ('26', '8', '22', '348676', '[{\"id_art\":\"29\",\"cant\":\"1\",\"total_cost\":100}]', '19', '1', '0', '2016-10-06 21:31:57');
INSERT INTO `clientes_pedidos` VALUES ('27', '8', '25', '489290', '[{\"id_art\":\"32\",\"cant\":\"1\",\"total_cost\":50000}]', '20', '1', '0', '2016-10-06 21:36:43');
INSERT INTO `clientes_pedidos` VALUES ('28', '8', '14', '650835', '[{\"id_art\":\"16\",\"cant\":\"2\",\"total_cost\":200},{\"id_art\":\"17\",\"cant\":\"3\",\"total_cost\":399}]', '21', '1', '0', '2016-10-07 11:14:03');
INSERT INTO `clientes_pedidos` VALUES ('29', '4', '22', '158610', '[{\"id_art\":\"29\",\"cant\":\"1\",\"total_cost\":100}]', '22', '1', '0', '2016-10-07 11:28:48');
INSERT INTO `clientes_pedidos` VALUES ('30', '3', '22', '547357', '[{\"id_art\":\"36\",\"cant\":\"1\",\"total_cost\":50},{\"id_art\":\"38\",\"cant\":\"1\",\"total_cost\":30}]', '23', '0', '0', '2016-10-07 17:20:33');
INSERT INTO `clientes_pedidos` VALUES ('31', '3', '25', '213680', '[{\"id_art\":\"32\",\"cant\":\"1\",\"total_cost\":50000},{\"id_art\":\"34\",\"cant\":\"1\",\"total_cost\":30}]', '24', '1', '2', '2016-10-07 17:24:30');
INSERT INTO `clientes_pedidos` VALUES ('32', '3', '25', '448935', '[{\"id_art\":\"32\",\"cant\":\"1\",\"total_cost\":50000}]', '25', '1', '2', '2016-10-07 17:36:45');

-- ----------------------------
-- Table structure for clientes_sucursales
-- ----------------------------
DROP TABLE IF EXISTS `clientes_sucursales`;
CREATE TABLE `clientes_sucursales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cliente` int(11) NOT NULL,
  `id_sucursal` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

-- ----------------------------
-- Records of clientes_sucursales
-- ----------------------------

-- ----------------------------
-- Table structure for cocina
-- ----------------------------
DROP TABLE IF EXISTS `cocina`;
CREATE TABLE `cocina` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(48) NOT NULL DEFAULT '',
  `nombre` varchar(48) NOT NULL,
  `apellido` varchar(48) NOT NULL,
  `correo_electronico` varchar(64) NOT NULL,
  `clave` varchar(48) NOT NULL,
  `fecha_registro` datetime NOT NULL,
  `id_administrador` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cocina
-- ----------------------------
INSERT INTO `cocina` VALUES ('1', 'sofy', 'sofy', 'sofy', 'sofy@sofy.com', '12345', '2016-10-06 20:08:40', '1');
INSERT INTO `cocina` VALUES ('2', 'juan', 'juan', 'cal', 'fyyhvf@fgvh.com', '12345', '2016-10-06 02:30:50', '1');
INSERT INTO `cocina` VALUES ('3', 'carol', 'carol', 'cel', 'carol@carol.com', '12345', '2016-10-06 20:08:40', '2');

-- ----------------------------
-- Table structure for menus
-- ----------------------------
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titulo` varchar(48) NOT NULL,
  `descripcion` varchar(64) NOT NULL,
  `es_submenu` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES ('4', 'Menu 1', '', '0');
INSERT INTO `menus` VALUES ('5', 'Menu 1', '', '0');
INSERT INTO `menus` VALUES ('6', 'Menu 2', '', '0');
INSERT INTO `menus` VALUES ('7', 'Sub Menu 1', '', '1');
INSERT INTO `menus` VALUES ('8', 'Menú 3', '', '0');
INSERT INTO `menus` VALUES ('10', 'Menub1', '', '0');
INSERT INTO `menus` VALUES ('11', 'sopas', '', '0');
INSERT INTO `menus` VALUES ('12', '1', '', '0');
INSERT INTO `menus` VALUES ('15', 'grande', '', '1');
INSERT INTO `menus` VALUES ('16', 'mediano', '', '1');
INSERT INTO `menus` VALUES ('17', 'pequeño', '', '1');
INSERT INTO `menus` VALUES ('18', 'carnes', '', '0');
INSERT INTO `menus` VALUES ('19', 'carne asada', '', '1');
INSERT INTO `menus` VALUES ('20', 'baby beef', '', '1');
INSERT INTO `menus` VALUES ('21', 'Su menu 3', '', '1');
INSERT INTO `menus` VALUES ('22', 'Sub menu 4', '', '1');
INSERT INTO `menus` VALUES ('23', 'carnes', '', '0');
INSERT INTO `menus` VALUES ('24', '3/4', '', '1');
INSERT INTO `menus` VALUES ('25', 'bien asada', '', '1');
INSERT INTO `menus` VALUES ('26', 'carnes', '', '0');
INSERT INTO `menus` VALUES ('27', 'carnes asadas', '', '1');
INSERT INTO `menus` VALUES ('28', 'pollos', '', '1');
INSERT INTO `menus` VALUES ('30', 'pollos', '', '0');
INSERT INTO `menus` VALUES ('31', 'fritos', '', '1');
INSERT INTO `menus` VALUES ('32', '111', '', '0');
INSERT INTO `menus` VALUES ('36', 'sm1', '', '1');
INSERT INTO `menus` VALUES ('37', 'sm2', '', '1');
INSERT INTO `menus` VALUES ('38', 'pescados', '', '0');
INSERT INTO `menus` VALUES ('39', 'asado', '', '1');
INSERT INTO `menus` VALUES ('40', 'crudo', '', '1');
INSERT INTO `menus` VALUES ('41', 'cocido', '', '1');
INSERT INTO `menus` VALUES ('42', 'licuado', '', '1');
INSERT INTO `menus` VALUES ('43', 'frito', '', '1');
INSERT INTO `menus` VALUES ('44', 'cocido', '', '1');
INSERT INTO `menus` VALUES ('45', 'espeso', '', '1');
INSERT INTO `menus` VALUES ('46', 'sopas', '', '0');
INSERT INTO `menus` VALUES ('47', 'jugos', '', '0');
INSERT INTO `menus` VALUES ('48', 'pequeña', '', '1');
INSERT INTO `menus` VALUES ('49', 'grande', '', '1');
INSERT INTO `menus` VALUES ('50', 'mediana', '', '1');
INSERT INTO `menus` VALUES ('51', 'con cubios', '', '1');

-- ----------------------------
-- Table structure for menus_articulos
-- ----------------------------
DROP TABLE IF EXISTS `menus_articulos`;
CREATE TABLE `menus_articulos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_menu` int(11) NOT NULL,
  `id_articulo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menus_articulos
-- ----------------------------
INSERT INTO `menus_articulos` VALUES ('16', '4', '16');
INSERT INTO `menus_articulos` VALUES ('17', '4', '17');
INSERT INTO `menus_articulos` VALUES ('18', '4', '18');
INSERT INTO `menus_articulos` VALUES ('19', '6', '19');
INSERT INTO `menus_articulos` VALUES ('20', '5', '20');
INSERT INTO `menus_articulos` VALUES ('21', '7', '21');
INSERT INTO `menus_articulos` VALUES ('22', '14', '22');
INSERT INTO `menus_articulos` VALUES ('23', '10', '23');
INSERT INTO `menus_articulos` VALUES ('24', '11', '24');
INSERT INTO `menus_articulos` VALUES ('27', '7', '27');
INSERT INTO `menus_articulos` VALUES ('28', '21', '28');
INSERT INTO `menus_articulos` VALUES ('29', '23', '29');
INSERT INTO `menus_articulos` VALUES ('30', '27', '30');
INSERT INTO `menus_articulos` VALUES ('31', '36', '31');
INSERT INTO `menus_articulos` VALUES ('32', '38', '32');
INSERT INTO `menus_articulos` VALUES ('33', '39', '33');
INSERT INTO `menus_articulos` VALUES ('34', '38', '34');
INSERT INTO `menus_articulos` VALUES ('35', '43', '35');
INSERT INTO `menus_articulos` VALUES ('36', '46', '36');
INSERT INTO `menus_articulos` VALUES ('38', '46', '38');

-- ----------------------------
-- Table structure for menus_submenus
-- ----------------------------
DROP TABLE IF EXISTS `menus_submenus`;
CREATE TABLE `menus_submenus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_menu1` int(11) DEFAULT NULL,
  `id_menu2` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of menus_submenus
-- ----------------------------
INSERT INTO `menus_submenus` VALUES ('1', '4', '7');
INSERT INTO `menus_submenus` VALUES ('3', '5', '15');
INSERT INTO `menus_submenus` VALUES ('4', '5', '16');
INSERT INTO `menus_submenus` VALUES ('5', '5', '17');
INSERT INTO `menus_submenus` VALUES ('6', '18', '19');
INSERT INTO `menus_submenus` VALUES ('7', '18', '20');
INSERT INTO `menus_submenus` VALUES ('8', '4', '21');
INSERT INTO `menus_submenus` VALUES ('9', '4', '22');
INSERT INTO `menus_submenus` VALUES ('10', '23', '24');
INSERT INTO `menus_submenus` VALUES ('11', '23', '25');
INSERT INTO `menus_submenus` VALUES ('12', '26', '27');
INSERT INTO `menus_submenus` VALUES ('13', '26', '28');
INSERT INTO `menus_submenus` VALUES ('14', '26', '29');
INSERT INTO `menus_submenus` VALUES ('15', '30', '31');
INSERT INTO `menus_submenus` VALUES ('16', '32', '33');
INSERT INTO `menus_submenus` VALUES ('17', '32', '34');
INSERT INTO `menus_submenus` VALUES ('18', '32', '35');
INSERT INTO `menus_submenus` VALUES ('19', '32', '36');
INSERT INTO `menus_submenus` VALUES ('20', '32', '37');
INSERT INTO `menus_submenus` VALUES ('21', '38', '39');
INSERT INTO `menus_submenus` VALUES ('22', '38', '40');
INSERT INTO `menus_submenus` VALUES ('23', '38', '41');
INSERT INTO `menus_submenus` VALUES ('24', '38', '42');
INSERT INTO `menus_submenus` VALUES ('25', '38', '43');
INSERT INTO `menus_submenus` VALUES ('26', '38', '44');
INSERT INTO `menus_submenus` VALUES ('27', '38', '45');
INSERT INTO `menus_submenus` VALUES ('28', '46', '48');
INSERT INTO `menus_submenus` VALUES ('29', '46', '49');
INSERT INTO `menus_submenus` VALUES ('30', '46', '50');
INSERT INTO `menus_submenus` VALUES ('31', '46', '51');

-- ----------------------------
-- Table structure for meseros
-- ----------------------------
DROP TABLE IF EXISTS `meseros`;
CREATE TABLE `meseros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` varchar(48) NOT NULL DEFAULT '',
  `nombre` varchar(48) NOT NULL,
  `apellido` varchar(48) NOT NULL,
  `correo_electronico` varchar(64) NOT NULL,
  `clave` varchar(48) NOT NULL,
  `fecha_registro` datetime NOT NULL,
  `id_administrador` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of meseros
-- ----------------------------
INSERT INTO `meseros` VALUES ('1', 'alz', 'alz', 'alz', 'alz@alz.com', '12345', '2016-10-06 02:31:51', '1');
INSERT INTO `meseros` VALUES ('3', 'lucy', 'lucy', 'cal', 'fyugf@tgcd.com', '12345', '2016-10-06 02:31:51', '1');
INSERT INTO `meseros` VALUES ('4', 'luis', 'luis', 'cool', 'luis@luis.com', '12345', '2016-10-06 20:09:36', '2');

-- ----------------------------
-- Table structure for paises
-- ----------------------------
DROP TABLE IF EXISTS `paises`;
CREATE TABLE `paises` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) NOT NULL DEFAULT '',
  `moneda` char(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=251 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of paises
-- ----------------------------
INSERT INTO `paises` VALUES ('1', 'Andorra', 'EUR');
INSERT INTO `paises` VALUES ('2', 'United Arab Emirates', 'AED');
INSERT INTO `paises` VALUES ('3', 'Afghanistan', 'AFN');
INSERT INTO `paises` VALUES ('4', 'Antigua and Barbuda', 'XCD');
INSERT INTO `paises` VALUES ('5', 'Anguilla', 'XCD');
INSERT INTO `paises` VALUES ('6', 'Albania', 'ALL');
INSERT INTO `paises` VALUES ('7', 'Armenia', 'AMD');
INSERT INTO `paises` VALUES ('8', 'Angola', 'AOA');
INSERT INTO `paises` VALUES ('10', 'Argentina', 'ARS');
INSERT INTO `paises` VALUES ('11', 'American Samoa', 'USD');
INSERT INTO `paises` VALUES ('12', 'Austria', 'EUR');
INSERT INTO `paises` VALUES ('13', 'Australia', 'AUD');
INSERT INTO `paises` VALUES ('14', 'Aruba', 'AWG');
INSERT INTO `paises` VALUES ('15', 'Åland', 'EUR');
INSERT INTO `paises` VALUES ('16', 'Azerbaijan', 'AZN');
INSERT INTO `paises` VALUES ('17', 'Bosnia and Herzegovina', 'BAM');
INSERT INTO `paises` VALUES ('18', 'Barbados', 'BBD');
INSERT INTO `paises` VALUES ('19', 'Bangladesh', 'BDT');
INSERT INTO `paises` VALUES ('20', 'Belgium', 'EUR');
INSERT INTO `paises` VALUES ('21', 'Burkina Faso', 'XOF');
INSERT INTO `paises` VALUES ('22', 'Bulgaria', 'BGN');
INSERT INTO `paises` VALUES ('23', 'Bahrain', 'BHD');
INSERT INTO `paises` VALUES ('24', 'Burundi', 'BIF');
INSERT INTO `paises` VALUES ('25', 'Benin', 'XOF');
INSERT INTO `paises` VALUES ('26', 'Saint Barthélemy', 'EUR');
INSERT INTO `paises` VALUES ('27', 'Bermuda', 'BMD');
INSERT INTO `paises` VALUES ('28', 'Brunei', 'BND');
INSERT INTO `paises` VALUES ('29', 'Bolivia', 'BOB');
INSERT INTO `paises` VALUES ('30', 'Bonaire', 'USD');
INSERT INTO `paises` VALUES ('31', 'Brazil', 'BRL');
INSERT INTO `paises` VALUES ('32', 'Bahamas', 'BSD');
INSERT INTO `paises` VALUES ('33', 'Bhutan', 'BTN');
INSERT INTO `paises` VALUES ('34', 'Bouvet Island', 'NOK');
INSERT INTO `paises` VALUES ('35', 'Botswana', 'BWP');
INSERT INTO `paises` VALUES ('36', 'Belarus', 'BYR');
INSERT INTO `paises` VALUES ('37', 'Belize', 'BZD');
INSERT INTO `paises` VALUES ('38', 'Canada', 'CAD');
INSERT INTO `paises` VALUES ('39', 'Cocos [Keeling] Islands', 'AUD');
INSERT INTO `paises` VALUES ('40', 'Democratic Republic of the Congo', 'CDF');
INSERT INTO `paises` VALUES ('41', 'Central African Republic', 'XAF');
INSERT INTO `paises` VALUES ('42', 'Republic of the Congo', 'XAF');
INSERT INTO `paises` VALUES ('43', 'Switzerland', 'CHF');
INSERT INTO `paises` VALUES ('44', 'Ivory Coast', 'XOF');
INSERT INTO `paises` VALUES ('45', 'Cook Islands', 'NZD');
INSERT INTO `paises` VALUES ('46', 'Chile', 'CLP');
INSERT INTO `paises` VALUES ('47', 'Cameroon', 'XAF');
INSERT INTO `paises` VALUES ('48', 'China', 'CNY');
INSERT INTO `paises` VALUES ('49', 'Colombia', 'COP');
INSERT INTO `paises` VALUES ('50', 'Costa Rica', 'CRC');
INSERT INTO `paises` VALUES ('51', 'Cuba', 'CUP');
INSERT INTO `paises` VALUES ('52', 'Cape Verde', 'CVE');
INSERT INTO `paises` VALUES ('53', 'Curacao', 'ANG');
INSERT INTO `paises` VALUES ('54', 'Christmas Island', 'AUD');
INSERT INTO `paises` VALUES ('55', 'Cyprus', 'EUR');
INSERT INTO `paises` VALUES ('56', 'Czechia', 'CZK');
INSERT INTO `paises` VALUES ('57', 'Germany', 'EUR');
INSERT INTO `paises` VALUES ('58', 'Djibouti', 'DJF');
INSERT INTO `paises` VALUES ('59', 'Denmark', 'DKK');
INSERT INTO `paises` VALUES ('60', 'Dominica', 'XCD');
INSERT INTO `paises` VALUES ('61', 'Dominican Republic', 'DOP');
INSERT INTO `paises` VALUES ('62', 'Algeria', 'DZD');
INSERT INTO `paises` VALUES ('63', 'Ecuador', 'USD');
INSERT INTO `paises` VALUES ('64', 'Estonia', 'EUR');
INSERT INTO `paises` VALUES ('65', 'Egypt', 'EGP');
INSERT INTO `paises` VALUES ('66', 'Western Sahara', 'MAD');
INSERT INTO `paises` VALUES ('67', 'Eritrea', 'ERN');
INSERT INTO `paises` VALUES ('68', 'Spain', 'EUR');
INSERT INTO `paises` VALUES ('69', 'Ethiopia', 'ETB');
INSERT INTO `paises` VALUES ('70', 'Finland', 'EUR');
INSERT INTO `paises` VALUES ('71', 'Fiji', 'FJD');
INSERT INTO `paises` VALUES ('72', 'Falkland Islands', 'FKP');
INSERT INTO `paises` VALUES ('73', 'Micronesia', 'USD');
INSERT INTO `paises` VALUES ('74', 'Faroe Islands', 'DKK');
INSERT INTO `paises` VALUES ('75', 'France', 'EUR');
INSERT INTO `paises` VALUES ('76', 'Gabon', 'XAF');
INSERT INTO `paises` VALUES ('77', 'United Kingdom', 'GBP');
INSERT INTO `paises` VALUES ('78', 'Grenada', 'XCD');
INSERT INTO `paises` VALUES ('79', 'Georgia', 'GEL');
INSERT INTO `paises` VALUES ('80', 'French Guiana', 'EUR');
INSERT INTO `paises` VALUES ('81', 'Guernsey', 'GBP');
INSERT INTO `paises` VALUES ('82', 'Ghana', 'GHS');
INSERT INTO `paises` VALUES ('83', 'Gibraltar', 'GIP');
INSERT INTO `paises` VALUES ('84', 'Greenland', 'DKK');
INSERT INTO `paises` VALUES ('85', 'Gambia', 'GMD');
INSERT INTO `paises` VALUES ('86', 'Guinea', 'GNF');
INSERT INTO `paises` VALUES ('87', 'Guadeloupe', 'EUR');
INSERT INTO `paises` VALUES ('88', 'Equatorial Guinea', 'XAF');
INSERT INTO `paises` VALUES ('89', 'Greece', 'EUR');
INSERT INTO `paises` VALUES ('90', 'South Georgia and the South Sandwich Islands', 'GBP');
INSERT INTO `paises` VALUES ('91', 'Guatemala', 'GTQ');
INSERT INTO `paises` VALUES ('92', 'Guam', 'USD');
INSERT INTO `paises` VALUES ('93', 'Guinea-Bissau', 'XOF');
INSERT INTO `paises` VALUES ('94', 'Guyana', 'GYD');
INSERT INTO `paises` VALUES ('95', 'Hong Kong', 'HKD');
INSERT INTO `paises` VALUES ('96', 'Heard Island and McDonald Islands', 'AUD');
INSERT INTO `paises` VALUES ('97', 'Honduras', 'HNL');
INSERT INTO `paises` VALUES ('98', 'Croatia', 'HRK');
INSERT INTO `paises` VALUES ('99', 'Haiti', 'HTG');
INSERT INTO `paises` VALUES ('100', 'Hungary', 'HUF');
INSERT INTO `paises` VALUES ('101', 'Indonesia', 'IDR');
INSERT INTO `paises` VALUES ('102', 'Ireland', 'EUR');
INSERT INTO `paises` VALUES ('103', 'Israel', 'ILS');
INSERT INTO `paises` VALUES ('104', 'Isle of Man', 'GBP');
INSERT INTO `paises` VALUES ('105', 'India', 'INR');
INSERT INTO `paises` VALUES ('106', 'British Indian Ocean Territory', 'USD');
INSERT INTO `paises` VALUES ('107', 'Iraq', 'IQD');
INSERT INTO `paises` VALUES ('108', 'Iran', 'IRR');
INSERT INTO `paises` VALUES ('109', 'Iceland', 'ISK');
INSERT INTO `paises` VALUES ('110', 'Italy', 'EUR');
INSERT INTO `paises` VALUES ('111', 'Jersey', 'GBP');
INSERT INTO `paises` VALUES ('112', 'Jamaica', 'JMD');
INSERT INTO `paises` VALUES ('113', 'Jordan', 'JOD');
INSERT INTO `paises` VALUES ('114', 'Japan', 'JPY');
INSERT INTO `paises` VALUES ('115', 'Kenya', 'KES');
INSERT INTO `paises` VALUES ('116', 'Kyrgyzstan', 'KGS');
INSERT INTO `paises` VALUES ('117', 'Cambodia', 'KHR');
INSERT INTO `paises` VALUES ('118', 'Kiribati', 'AUD');
INSERT INTO `paises` VALUES ('119', 'Comoros', 'KMF');
INSERT INTO `paises` VALUES ('120', 'Saint Kitts and Nevis', 'XCD');
INSERT INTO `paises` VALUES ('121', 'North Korea', 'KPW');
INSERT INTO `paises` VALUES ('122', 'South Korea', 'KRW');
INSERT INTO `paises` VALUES ('123', 'Kuwait', 'KWD');
INSERT INTO `paises` VALUES ('124', 'Cayman Islands', 'KYD');
INSERT INTO `paises` VALUES ('125', 'Kazakhstan', 'KZT');
INSERT INTO `paises` VALUES ('126', 'Laos', 'LAK');
INSERT INTO `paises` VALUES ('127', 'Lebanon', 'LBP');
INSERT INTO `paises` VALUES ('128', 'Saint Lucia', 'XCD');
INSERT INTO `paises` VALUES ('129', 'Liechtenstein', 'CHF');
INSERT INTO `paises` VALUES ('130', 'Sri Lanka', 'LKR');
INSERT INTO `paises` VALUES ('131', 'Liberia', 'LRD');
INSERT INTO `paises` VALUES ('132', 'Lesotho', 'LSL');
INSERT INTO `paises` VALUES ('133', 'Lithuania', 'EUR');
INSERT INTO `paises` VALUES ('134', 'Luxembourg', 'EUR');
INSERT INTO `paises` VALUES ('135', 'Latvia', 'EUR');
INSERT INTO `paises` VALUES ('136', 'Libya', 'LYD');
INSERT INTO `paises` VALUES ('137', 'Morocco', 'MAD');
INSERT INTO `paises` VALUES ('138', 'Monaco', 'EUR');
INSERT INTO `paises` VALUES ('139', 'Moldova', 'MDL');
INSERT INTO `paises` VALUES ('140', 'Montenegro', 'EUR');
INSERT INTO `paises` VALUES ('141', 'Saint Martin', 'EUR');
INSERT INTO `paises` VALUES ('142', 'Madagascar', 'MGA');
INSERT INTO `paises` VALUES ('143', 'Marshall Islands', 'USD');
INSERT INTO `paises` VALUES ('144', 'Macedonia', 'MKD');
INSERT INTO `paises` VALUES ('145', 'Mali', 'XOF');
INSERT INTO `paises` VALUES ('146', 'Myanmar [Burma]', 'MMK');
INSERT INTO `paises` VALUES ('147', 'Mongolia', 'MNT');
INSERT INTO `paises` VALUES ('148', 'Macao', 'MOP');
INSERT INTO `paises` VALUES ('149', 'Northern Mariana Islands', 'USD');
INSERT INTO `paises` VALUES ('150', 'Martinique', 'EUR');
INSERT INTO `paises` VALUES ('151', 'Mauritania', 'MRO');
INSERT INTO `paises` VALUES ('152', 'Montserrat', 'XCD');
INSERT INTO `paises` VALUES ('153', 'Malta', 'EUR');
INSERT INTO `paises` VALUES ('154', 'Mauritius', 'MUR');
INSERT INTO `paises` VALUES ('155', 'Maldives', 'MVR');
INSERT INTO `paises` VALUES ('156', 'Malawi', 'MWK');
INSERT INTO `paises` VALUES ('157', 'Mexico', 'MXN');
INSERT INTO `paises` VALUES ('158', 'Malaysia', 'MYR');
INSERT INTO `paises` VALUES ('159', 'Mozambique', 'MZN');
INSERT INTO `paises` VALUES ('160', 'Namibia', 'NAD');
INSERT INTO `paises` VALUES ('161', 'New Caledonia', 'XPF');
INSERT INTO `paises` VALUES ('162', 'Niger', 'XOF');
INSERT INTO `paises` VALUES ('163', 'Norfolk Island', 'AUD');
INSERT INTO `paises` VALUES ('164', 'Nigeria', 'NGN');
INSERT INTO `paises` VALUES ('165', 'Nicaragua', 'NIO');
INSERT INTO `paises` VALUES ('166', 'Netherlands', 'EUR');
INSERT INTO `paises` VALUES ('167', 'Norway', 'NOK');
INSERT INTO `paises` VALUES ('168', 'Nepal', 'NPR');
INSERT INTO `paises` VALUES ('169', 'Nauru', 'AUD');
INSERT INTO `paises` VALUES ('170', 'Niue', 'NZD');
INSERT INTO `paises` VALUES ('171', 'New Zealand', 'NZD');
INSERT INTO `paises` VALUES ('172', 'Oman', 'OMR');
INSERT INTO `paises` VALUES ('173', 'Panama', 'PAB');
INSERT INTO `paises` VALUES ('174', 'Peru', 'PEN');
INSERT INTO `paises` VALUES ('175', 'French Polynesia', 'XPF');
INSERT INTO `paises` VALUES ('176', 'Papua New Guinea', 'PGK');
INSERT INTO `paises` VALUES ('177', 'Philippines', 'PHP');
INSERT INTO `paises` VALUES ('178', 'Pakistan', 'PKR');
INSERT INTO `paises` VALUES ('179', 'Poland', 'PLN');
INSERT INTO `paises` VALUES ('180', 'Saint Pierre and Miquelon', 'EUR');
INSERT INTO `paises` VALUES ('181', 'Pitcairn Islands', 'NZD');
INSERT INTO `paises` VALUES ('182', 'Puerto Rico', 'USD');
INSERT INTO `paises` VALUES ('183', 'Palestine', 'ILS');
INSERT INTO `paises` VALUES ('184', 'Portugal', 'EUR');
INSERT INTO `paises` VALUES ('185', 'Palau', 'USD');
INSERT INTO `paises` VALUES ('186', 'Paraguay', 'PYG');
INSERT INTO `paises` VALUES ('187', 'Qatar', 'QAR');
INSERT INTO `paises` VALUES ('188', 'Réunion', 'EUR');
INSERT INTO `paises` VALUES ('189', 'Romania', 'RON');
INSERT INTO `paises` VALUES ('190', 'Serbia', 'RSD');
INSERT INTO `paises` VALUES ('191', 'Russia', 'RUB');
INSERT INTO `paises` VALUES ('192', 'Rwanda', 'RWF');
INSERT INTO `paises` VALUES ('193', 'Saudi Arabia', 'SAR');
INSERT INTO `paises` VALUES ('194', 'Solomon Islands', 'SBD');
INSERT INTO `paises` VALUES ('195', 'Seychelles', 'SCR');
INSERT INTO `paises` VALUES ('196', 'Sudan', 'SDG');
INSERT INTO `paises` VALUES ('197', 'Sweden', 'SEK');
INSERT INTO `paises` VALUES ('198', 'Singapore', 'SGD');
INSERT INTO `paises` VALUES ('199', 'Saint Helena', 'SHP');
INSERT INTO `paises` VALUES ('200', 'Slovenia', 'EUR');
INSERT INTO `paises` VALUES ('201', 'Svalbard and Jan Mayen', 'NOK');
INSERT INTO `paises` VALUES ('202', 'Slovakia', 'EUR');
INSERT INTO `paises` VALUES ('203', 'Sierra Leone', 'SLL');
INSERT INTO `paises` VALUES ('204', 'San Marino', 'EUR');
INSERT INTO `paises` VALUES ('205', 'Senegal', 'XOF');
INSERT INTO `paises` VALUES ('206', 'Somalia', 'SOS');
INSERT INTO `paises` VALUES ('207', 'Suriname', 'SRD');
INSERT INTO `paises` VALUES ('208', 'South Sudan', 'SSP');
INSERT INTO `paises` VALUES ('209', 'São Tomé and Príncipe', 'STD');
INSERT INTO `paises` VALUES ('210', 'El Salvador', 'USD');
INSERT INTO `paises` VALUES ('211', 'Sint Maarten', 'ANG');
INSERT INTO `paises` VALUES ('212', 'Syria', 'SYP');
INSERT INTO `paises` VALUES ('213', 'Swaziland', 'SZL');
INSERT INTO `paises` VALUES ('214', 'Turks and Caicos Islands', 'USD');
INSERT INTO `paises` VALUES ('215', 'Chad', 'XAF');
INSERT INTO `paises` VALUES ('216', 'French Southern Territories', 'EUR');
INSERT INTO `paises` VALUES ('217', 'Togo', 'XOF');
INSERT INTO `paises` VALUES ('218', 'Thailand', 'THB');
INSERT INTO `paises` VALUES ('219', 'Tajikistan', 'TJS');
INSERT INTO `paises` VALUES ('220', 'Tokelau', 'NZD');
INSERT INTO `paises` VALUES ('221', 'East Timor', 'USD');
INSERT INTO `paises` VALUES ('222', 'Turkmenistan', 'TMT');
INSERT INTO `paises` VALUES ('223', 'Tunisia', 'TND');
INSERT INTO `paises` VALUES ('224', 'Tonga', 'TOP');
INSERT INTO `paises` VALUES ('225', 'Turkey', 'TRY');
INSERT INTO `paises` VALUES ('226', 'Trinidad and Tobago', 'TTD');
INSERT INTO `paises` VALUES ('227', 'Tuvalu', 'AUD');
INSERT INTO `paises` VALUES ('228', 'Taiwan', 'TWD');
INSERT INTO `paises` VALUES ('229', 'Tanzania', 'TZS');
INSERT INTO `paises` VALUES ('230', 'Ukraine', 'UAH');
INSERT INTO `paises` VALUES ('231', 'Uganda', 'UGX');
INSERT INTO `paises` VALUES ('232', 'U.S. Minor Outlying Islands', 'USD');
INSERT INTO `paises` VALUES ('233', 'United States', 'USD');
INSERT INTO `paises` VALUES ('234', 'Uruguay', 'UYU');
INSERT INTO `paises` VALUES ('235', 'Uzbekistan', 'UZS');
INSERT INTO `paises` VALUES ('236', 'Vatican City', 'EUR');
INSERT INTO `paises` VALUES ('237', 'Saint Vincent and the Grenadines', 'XCD');
INSERT INTO `paises` VALUES ('238', 'Venezuela', 'VEF');
INSERT INTO `paises` VALUES ('239', 'British Virgin Islands', 'USD');
INSERT INTO `paises` VALUES ('240', 'U.S. Virgin Islands', 'USD');
INSERT INTO `paises` VALUES ('241', 'Vietnam', 'VND');
INSERT INTO `paises` VALUES ('242', 'Vanuatu', 'VUV');
INSERT INTO `paises` VALUES ('243', 'Wallis and Futuna', 'XPF');
INSERT INTO `paises` VALUES ('244', 'Samoa', 'WST');
INSERT INTO `paises` VALUES ('245', 'Kosovo', 'EUR');
INSERT INTO `paises` VALUES ('246', 'Yemen', 'YER');
INSERT INTO `paises` VALUES ('247', 'Mayotte', 'EUR');
INSERT INTO `paises` VALUES ('248', 'South Africa', 'ZAR');
INSERT INTO `paises` VALUES ('249', 'Zambia', 'ZMW');
INSERT INTO `paises` VALUES ('250', 'Zimbabwe', 'ZWL');

-- ----------------------------
-- Table structure for paises_ciudades
-- ----------------------------
DROP TABLE IF EXISTS `paises_ciudades`;
CREATE TABLE `paises_ciudades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_pais` int(11) NOT NULL,
  `ciudad` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=262 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of paises_ciudades
-- ----------------------------
INSERT INTO `paises_ciudades` VALUES ('1', '52', 'Barranquilla');
INSERT INTO `paises_ciudades` VALUES ('2', '52', 'Bello');
INSERT INTO `paises_ciudades` VALUES ('3', '52', 'Bogotá');
INSERT INTO `paises_ciudades` VALUES ('4', '52', 'Bucaramanga');
INSERT INTO `paises_ciudades` VALUES ('5', '52', 'Buenaventura');
INSERT INTO `paises_ciudades` VALUES ('6', '52', 'Cali');
INSERT INTO `paises_ciudades` VALUES ('7', '52', 'Cartagena de Indias');
INSERT INTO `paises_ciudades` VALUES ('8', '52', 'Cúcuta');
INSERT INTO `paises_ciudades` VALUES ('9', '52', 'Ibagué');
INSERT INTO `paises_ciudades` VALUES ('10', '52', 'Manizales');
INSERT INTO `paises_ciudades` VALUES ('11', '52', 'Medellín');
INSERT INTO `paises_ciudades` VALUES ('12', '52', 'Montería');
INSERT INTO `paises_ciudades` VALUES ('13', '52', 'Neiva');
INSERT INTO `paises_ciudades` VALUES ('14', '52', 'Pasto');
INSERT INTO `paises_ciudades` VALUES ('15', '52', 'Pereira');
INSERT INTO `paises_ciudades` VALUES ('16', '52', 'Santa Martha');
INSERT INTO `paises_ciudades` VALUES ('17', '52', 'Soacha');
INSERT INTO `paises_ciudades` VALUES ('18', '52', 'Soledad');
INSERT INTO `paises_ciudades` VALUES ('19', '52', 'Valledupar');
INSERT INTO `paises_ciudades` VALUES ('20', '52', 'Villavicencio');
INSERT INTO `paises_ciudades` VALUES ('21', '13', 'Bariloche');
INSERT INTO `paises_ciudades` VALUES ('22', '13', 'Bariloche');
INSERT INTO `paises_ciudades` VALUES ('23', '13', 'Bariloche');
INSERT INTO `paises_ciudades` VALUES ('24', '13', 'Buenos Aires');
INSERT INTO `paises_ciudades` VALUES ('25', '13', 'Catamarca');
INSERT INTO `paises_ciudades` VALUES ('26', '13', 'Cordoba');
INSERT INTO `paises_ciudades` VALUES ('27', '13', 'Corrientes');
INSERT INTO `paises_ciudades` VALUES ('28', '13', 'Esquel');
INSERT INTO `paises_ciudades` VALUES ('29', '13', 'Formosa');
INSERT INTO `paises_ciudades` VALUES ('30', '13', 'Jujuy');
INSERT INTO `paises_ciudades` VALUES ('31', '13', 'La Plata');
INSERT INTO `paises_ciudades` VALUES ('32', '13', 'La Rioja');
INSERT INTO `paises_ciudades` VALUES ('33', '13', 'Las Junturas');
INSERT INTO `paises_ciudades` VALUES ('34', '13', 'Mar del Plata');
INSERT INTO `paises_ciudades` VALUES ('35', '13', 'Navarro');
INSERT INTO `paises_ciudades` VALUES ('36', '13', 'Neuquen');
INSERT INTO `paises_ciudades` VALUES ('37', '13', 'Parana');
INSERT INTO `paises_ciudades` VALUES ('38', '13', 'Pigue');
INSERT INTO `paises_ciudades` VALUES ('39', '13', 'Pinamar');
INSERT INTO `paises_ciudades` VALUES ('40', '13', 'Posadas');
INSERT INTO `paises_ciudades` VALUES ('41', '13', 'Puerto Argentino');
INSERT INTO `paises_ciudades` VALUES ('42', '13', 'Rawson');
INSERT INTO `paises_ciudades` VALUES ('43', '13', 'Resistencia');
INSERT INTO `paises_ciudades` VALUES ('44', '13', 'Rio Gallegos');
INSERT INTO `paises_ciudades` VALUES ('45', '13', 'Salta');
INSERT INTO `paises_ciudades` VALUES ('46', '13', 'San Juan');
INSERT INTO `paises_ciudades` VALUES ('47', '13', 'San Luis');
INSERT INTO `paises_ciudades` VALUES ('48', '13', 'San Rafael');
INSERT INTO `paises_ciudades` VALUES ('49', '13', 'Santa Fe');
INSERT INTO `paises_ciudades` VALUES ('50', '13', 'Santa Rosa');
INSERT INTO `paises_ciudades` VALUES ('51', '13', 'Santiago del Estero');
INSERT INTO `paises_ciudades` VALUES ('52', '13', 'Tucuman');
INSERT INTO `paises_ciudades` VALUES ('53', '13', 'Ushuaia');
INSERT INTO `paises_ciudades` VALUES ('54', '13', 'Viedma');
INSERT INTO `paises_ciudades` VALUES ('55', '13', 'Villegas');
INSERT INTO `paises_ciudades` VALUES ('56', '46', 'Ancud');
INSERT INTO `paises_ciudades` VALUES ('57', '46', 'Angol');
INSERT INTO `paises_ciudades` VALUES ('58', '46', 'Antofagasta');
INSERT INTO `paises_ciudades` VALUES ('59', '46', 'Arauco');
INSERT INTO `paises_ciudades` VALUES ('60', '46', 'Arica');
INSERT INTO `paises_ciudades` VALUES ('61', '46', 'Buin');
INSERT INTO `paises_ciudades` VALUES ('62', '46', 'Bulnes');
INSERT INTO `paises_ciudades` VALUES ('63', '46', 'Cabrero');
INSERT INTO `paises_ciudades` VALUES ('64', '46', 'Calama');
INSERT INTO `paises_ciudades` VALUES ('65', '46', 'Calbuco');
INSERT INTO `paises_ciudades` VALUES ('66', '46', 'Caleta Condor');
INSERT INTO `paises_ciudades` VALUES ('67', '46', 'Cañete');
INSERT INTO `paises_ciudades` VALUES ('68', '46', 'Carahue');
INSERT INTO `paises_ciudades` VALUES ('69', '46', 'Castro');
INSERT INTO `paises_ciudades` VALUES ('70', '46', 'Cauquenes');
INSERT INTO `paises_ciudades` VALUES ('71', '46', 'Chaihuin');
INSERT INTO `paises_ciudades` VALUES ('72', '46', 'Chiguayante');
INSERT INTO `paises_ciudades` VALUES ('73', '46', 'Chillán');
INSERT INTO `paises_ciudades` VALUES ('74', '46', 'Chimbarongo');
INSERT INTO `paises_ciudades` VALUES ('75', '46', 'Coihaique');
INSERT INTO `paises_ciudades` VALUES ('76', '46', 'Coihueco');
INSERT INTO `paises_ciudades` VALUES ('77', '46', 'Collipulli');
INSERT INTO `paises_ciudades` VALUES ('78', '46', 'Concepción');
INSERT INTO `paises_ciudades` VALUES ('79', '46', 'Constitución');
INSERT INTO `paises_ciudades` VALUES ('80', '46', 'Copiapó');
INSERT INTO `paises_ciudades` VALUES ('81', '46', 'Coquimbo');
INSERT INTO `paises_ciudades` VALUES ('82', '46', 'Coronel');
INSERT INTO `paises_ciudades` VALUES ('83', '46', 'Corral');
INSERT INTO `paises_ciudades` VALUES ('84', '46', 'Curanilahue');
INSERT INTO `paises_ciudades` VALUES ('85', '46', 'Curicó');
INSERT INTO `paises_ciudades` VALUES ('86', '46', 'Diego de Almagro');
INSERT INTO `paises_ciudades` VALUES ('87', '46', 'El Arenal');
INSERT INTO `paises_ciudades` VALUES ('88', '46', 'El Cadillal');
INSERT INTO `paises_ciudades` VALUES ('89', '46', 'El Monte');
INSERT INTO `paises_ciudades` VALUES ('90', '46', 'Freire');
INSERT INTO `paises_ciudades` VALUES ('91', '46', 'Graneros');
INSERT INTO `paises_ciudades` VALUES ('92', '46', 'Hacienda');
INSERT INTO `paises_ciudades` VALUES ('93', '46', 'Hanga Roa');
INSERT INTO `paises_ciudades` VALUES ('94', '46', 'llapel');
INSERT INTO `paises_ciudades` VALUES ('95', '46', 'Iquique');
INSERT INTO `paises_ciudades` VALUES ('96', '46', 'La Amistad');
INSERT INTO `paises_ciudades` VALUES ('97', '46', 'La Laja');
INSERT INTO `paises_ciudades` VALUES ('98', '46', 'La Ligua');
INSERT INTO `paises_ciudades` VALUES ('99', '46', 'La Serena');
INSERT INTO `paises_ciudades` VALUES ('100', '46', 'La Unión');
INSERT INTO `paises_ciudades` VALUES ('101', '46', 'Lampa');
INSERT INTO `paises_ciudades` VALUES ('102', '46', 'Las Animas');
INSERT INTO `paises_ciudades` VALUES ('103', '46', 'Las Fanegas');
INSERT INTO `paises_ciudades` VALUES ('104', '46', 'Lautaro');
INSERT INTO `paises_ciudades` VALUES ('105', '46', 'Lebu');
INSERT INTO `paises_ciudades` VALUES ('106', '46', 'Limache');
INSERT INTO `paises_ciudades` VALUES ('107', '46', 'Linares');
INSERT INTO `paises_ciudades` VALUES ('108', '46', 'Llaillay');
INSERT INTO `paises_ciudades` VALUES ('109', '46', 'Loncoche');
INSERT INTO `paises_ciudades` VALUES ('110', '46', 'Longaví');
INSERT INTO `paises_ciudades` VALUES ('111', '46', 'Los Andes');
INSERT INTO `paises_ciudades` VALUES ('112', '46', 'Los Ángeles');
INSERT INTO `paises_ciudades` VALUES ('113', '46', 'Lota');
INSERT INTO `paises_ciudades` VALUES ('114', '46', 'Machalí');
INSERT INTO `paises_ciudades` VALUES ('115', '46', 'Melipilla');
INSERT INTO `paises_ciudades` VALUES ('116', '46', 'Molina');
INSERT INTO `paises_ciudades` VALUES ('117', '46', 'Monte Patria');
INSERT INTO `paises_ciudades` VALUES ('118', '46', 'Mulchén');
INSERT INTO `paises_ciudades` VALUES ('119', '46', 'Nacimiento');
INSERT INTO `paises_ciudades` VALUES ('120', '46', 'Nueva Imperial');
INSERT INTO `paises_ciudades` VALUES ('121', '46', 'Osorno');
INSERT INTO `paises_ciudades` VALUES ('122', '46', 'Ovalle');
INSERT INTO `paises_ciudades` VALUES ('123', '46', 'Paine');
INSERT INTO `paises_ciudades` VALUES ('124', '46', 'Panguipulli');
INSERT INTO `paises_ciudades` VALUES ('125', '46', 'Parral');
INSERT INTO `paises_ciudades` VALUES ('126', '46', 'Peñaflor');
INSERT INTO `paises_ciudades` VALUES ('127', '46', 'Penco');
INSERT INTO `paises_ciudades` VALUES ('128', '46', 'Pitrufquén');
INSERT INTO `paises_ciudades` VALUES ('129', '46', 'Puerto Montt');
INSERT INTO `paises_ciudades` VALUES ('130', '46', 'Puerto Natales');
INSERT INTO `paises_ciudades` VALUES ('131', '46', 'Puerto Varas');
INSERT INTO `paises_ciudades` VALUES ('132', '46', 'Punta Arenas');
INSERT INTO `paises_ciudades` VALUES ('133', '46', 'Purranque');
INSERT INTO `paises_ciudades` VALUES ('134', '46', 'Quillota');
INSERT INTO `paises_ciudades` VALUES ('135', '46', 'Quilpué');
INSERT INTO `paises_ciudades` VALUES ('136', '46', 'Rancagua');
INSERT INTO `paises_ciudades` VALUES ('137', '46', 'Rengo');
INSERT INTO `paises_ciudades` VALUES ('138', '46', 'Río Bueno');
INSERT INTO `paises_ciudades` VALUES ('139', '46', 'Salamanca');
INSERT INTO `paises_ciudades` VALUES ('140', '46', 'San Antonio');
INSERT INTO `paises_ciudades` VALUES ('141', '46', 'San Bernardo');
INSERT INTO `paises_ciudades` VALUES ('142', '46', 'San Carlos');
INSERT INTO `paises_ciudades` VALUES ('143', '46', 'San Clemente');
INSERT INTO `paises_ciudades` VALUES ('144', '46', 'San Felipe');
INSERT INTO `paises_ciudades` VALUES ('145', '46', 'San Javier');
INSERT INTO `paises_ciudades` VALUES ('146', '46', 'San Pedro de Atacama');
INSERT INTO `paises_ciudades` VALUES ('147', '46', 'San Vicente');
INSERT INTO `paises_ciudades` VALUES ('148', '46', 'Santa Cruz');
INSERT INTO `paises_ciudades` VALUES ('149', '46', 'Santa Rosa');
INSERT INTO `paises_ciudades` VALUES ('150', '46', 'Santiago de Chile');
INSERT INTO `paises_ciudades` VALUES ('151', '46', 'Talagante');
INSERT INTO `paises_ciudades` VALUES ('152', '46', 'Talca');
INSERT INTO `paises_ciudades` VALUES ('153', '46', 'Talcahuano');
INSERT INTO `paises_ciudades` VALUES ('154', '46', 'Taltal');
INSERT INTO `paises_ciudades` VALUES ('155', '46', 'Temuco');
INSERT INTO `paises_ciudades` VALUES ('156', '46', 'Teno');
INSERT INTO `paises_ciudades` VALUES ('157', '46', 'Tocopilla');
INSERT INTO `paises_ciudades` VALUES ('158', '46', 'Tomé');
INSERT INTO `paises_ciudades` VALUES ('159', '46', 'Torres Del Paine');
INSERT INTO `paises_ciudades` VALUES ('160', '46', 'Traiguén');
INSERT INTO `paises_ciudades` VALUES ('161', '46', 'Valdivia');
INSERT INTO `paises_ciudades` VALUES ('162', '46', 'Vallenar');
INSERT INTO `paises_ciudades` VALUES ('163', '46', 'Valparaíso');
INSERT INTO `paises_ciudades` VALUES ('164', '46', 'Victoria');
INSERT INTO `paises_ciudades` VALUES ('165', '46', 'Vicuña');
INSERT INTO `paises_ciudades` VALUES ('166', '46', 'Vilcún');
INSERT INTO `paises_ciudades` VALUES ('167', '46', 'Villa Alemana');
INSERT INTO `paises_ciudades` VALUES ('168', '46', 'Villa Europa');
INSERT INTO `paises_ciudades` VALUES ('169', '46', 'Villarrica');
INSERT INTO `paises_ciudades` VALUES ('170', '46', 'viña causiño');
INSERT INTO `paises_ciudades` VALUES ('171', '46', 'Viña del Mar');
INSERT INTO `paises_ciudades` VALUES ('172', '46', 'Vuelta de la Zorra');
INSERT INTO `paises_ciudades` VALUES ('173', '46', 'Yumbel');
INSERT INTO `paises_ciudades` VALUES ('174', '170', 'Ciudad de Panamá');
INSERT INTO `paises_ciudades` VALUES ('175', '170', 'Veraguas');
INSERT INTO `paises_ciudades` VALUES ('176', '170', 'Colón');
INSERT INTO `paises_ciudades` VALUES ('177', '170', 'Chiriqui');
INSERT INTO `paises_ciudades` VALUES ('178', '170', 'Cocle');
INSERT INTO `paises_ciudades` VALUES ('179', '146', 'Aguascalientes');
INSERT INTO `paises_ciudades` VALUES ('180', '146', 'Campeche');
INSERT INTO `paises_ciudades` VALUES ('181', '146', 'Chihuahua');
INSERT INTO `paises_ciudades` VALUES ('182', '146', 'Chilpancingo');
INSERT INTO `paises_ciudades` VALUES ('183', '146', 'Ciudad de México');
INSERT INTO `paises_ciudades` VALUES ('184', '146', 'Colima');
INSERT INTO `paises_ciudades` VALUES ('185', '146', 'Cuernavaca');
INSERT INTO `paises_ciudades` VALUES ('186', '146', 'Durango');
INSERT INTO `paises_ciudades` VALUES ('187', '146', 'Guadalajara');
INSERT INTO `paises_ciudades` VALUES ('188', '146', 'Guanajuato');
INSERT INTO `paises_ciudades` VALUES ('189', '146', 'La Paz');
INSERT INTO `paises_ciudades` VALUES ('190', '146', 'Mexicali');
INSERT INTO `paises_ciudades` VALUES ('191', '146', 'Monterrey');
INSERT INTO `paises_ciudades` VALUES ('192', '146', 'Morelía');
INSERT INTO `paises_ciudades` VALUES ('193', '146', 'Oaxaca');
INSERT INTO `paises_ciudades` VALUES ('194', '146', 'Pachuca');
INSERT INTO `paises_ciudades` VALUES ('195', '146', 'Saltillo');
INSERT INTO `paises_ciudades` VALUES ('196', '146', 'Tepic');
INSERT INTO `paises_ciudades` VALUES ('197', '146', 'Toluca');
INSERT INTO `paises_ciudades` VALUES ('198', '146', 'Tuxtla Gutiérrez');
INSERT INTO `paises_ciudades` VALUES ('199', '42', 'Alberta');
INSERT INTO `paises_ciudades` VALUES ('200', '42', 'Columbia Británica');
INSERT INTO `paises_ciudades` VALUES ('201', '42', 'Manitoba');
INSERT INTO `paises_ciudades` VALUES ('202', '42', 'Nuevo Brunswick');
INSERT INTO `paises_ciudades` VALUES ('203', '42', 'Terranova y Labrador');
INSERT INTO `paises_ciudades` VALUES ('204', '42', 'Nueva Escocia');
INSERT INTO `paises_ciudades` VALUES ('205', '42', 'Ontario');
INSERT INTO `paises_ciudades` VALUES ('206', '42', 'Isla del Príncipe Eduardo');
INSERT INTO `paises_ciudades` VALUES ('207', '42', 'Quebec');
INSERT INTO `paises_ciudades` VALUES ('208', '42', 'Saskatchewan');
INSERT INTO `paises_ciudades` VALUES ('209', '42', 'Territorios del Noroeste');
INSERT INTO `paises_ciudades` VALUES ('210', '42', 'Nunavut');
INSERT INTO `paises_ciudades` VALUES ('211', '42', 'Yukón');
INSERT INTO `paises_ciudades` VALUES ('212', '75', 'Alabama');
INSERT INTO `paises_ciudades` VALUES ('213', '75', 'Alaska');
INSERT INTO `paises_ciudades` VALUES ('214', '75', 'Arizona');
INSERT INTO `paises_ciudades` VALUES ('215', '75', 'Arkansas');
INSERT INTO `paises_ciudades` VALUES ('216', '75', 'California');
INSERT INTO `paises_ciudades` VALUES ('217', '75', 'Carolina del Norte');
INSERT INTO `paises_ciudades` VALUES ('218', '75', 'Carolina del Sur');
INSERT INTO `paises_ciudades` VALUES ('219', '75', 'Colorado');
INSERT INTO `paises_ciudades` VALUES ('220', '75', 'Connecticut');
INSERT INTO `paises_ciudades` VALUES ('221', '75', 'Dakota del Norte');
INSERT INTO `paises_ciudades` VALUES ('222', '75', 'Dakota del Sur');
INSERT INTO `paises_ciudades` VALUES ('223', '75', 'Delaware');
INSERT INTO `paises_ciudades` VALUES ('224', '75', 'Florida');
INSERT INTO `paises_ciudades` VALUES ('225', '75', 'Georgia');
INSERT INTO `paises_ciudades` VALUES ('226', '75', 'Hawái9');
INSERT INTO `paises_ciudades` VALUES ('227', '75', 'Idaho');
INSERT INTO `paises_ciudades` VALUES ('228', '75', 'Illinois');
INSERT INTO `paises_ciudades` VALUES ('229', '75', 'Indiana');
INSERT INTO `paises_ciudades` VALUES ('230', '75', 'Iowa');
INSERT INTO `paises_ciudades` VALUES ('231', '75', 'Kansas');
INSERT INTO `paises_ciudades` VALUES ('232', '75', 'Kentucky');
INSERT INTO `paises_ciudades` VALUES ('233', '75', 'Luisiana');
INSERT INTO `paises_ciudades` VALUES ('234', '75', 'Maine');
INSERT INTO `paises_ciudades` VALUES ('235', '75', 'Maryland');
INSERT INTO `paises_ciudades` VALUES ('236', '75', 'Massachusetts');
INSERT INTO `paises_ciudades` VALUES ('237', '75', 'Míchigan');
INSERT INTO `paises_ciudades` VALUES ('238', '75', 'Minnesota');
INSERT INTO `paises_ciudades` VALUES ('239', '75', 'Misisipi');
INSERT INTO `paises_ciudades` VALUES ('240', '75', 'Misuri');
INSERT INTO `paises_ciudades` VALUES ('241', '75', 'Montana');
INSERT INTO `paises_ciudades` VALUES ('242', '75', 'Nebraska');
INSERT INTO `paises_ciudades` VALUES ('243', '75', 'Nevada');
INSERT INTO `paises_ciudades` VALUES ('244', '75', 'Nueva Jersey');
INSERT INTO `paises_ciudades` VALUES ('245', '75', 'Nueva York');
INSERT INTO `paises_ciudades` VALUES ('246', '75', 'Nuevo Hampshire');
INSERT INTO `paises_ciudades` VALUES ('247', '75', 'Nuevo México');
INSERT INTO `paises_ciudades` VALUES ('248', '75', 'Ohio');
INSERT INTO `paises_ciudades` VALUES ('249', '75', 'Oklahoma');
INSERT INTO `paises_ciudades` VALUES ('250', '75', 'Oregón');
INSERT INTO `paises_ciudades` VALUES ('251', '75', 'Pensilvania');
INSERT INTO `paises_ciudades` VALUES ('252', '75', 'Rhode Island');
INSERT INTO `paises_ciudades` VALUES ('253', '75', 'Tennessee');
INSERT INTO `paises_ciudades` VALUES ('254', '75', 'Texas');
INSERT INTO `paises_ciudades` VALUES ('255', '75', 'Utah');
INSERT INTO `paises_ciudades` VALUES ('256', '75', 'Vermont');
INSERT INTO `paises_ciudades` VALUES ('257', '75', 'Virginia');
INSERT INTO `paises_ciudades` VALUES ('258', '75', 'Virginia Occidental');
INSERT INTO `paises_ciudades` VALUES ('259', '75', 'Washington');
INSERT INTO `paises_ciudades` VALUES ('260', '75', 'Wisconsin');
INSERT INTO `paises_ciudades` VALUES ('261', '75', 'Wyoming');

-- ----------------------------
-- Table structure for propietarios
-- ----------------------------
DROP TABLE IF EXISTS `propietarios`;
CREATE TABLE `propietarios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `propietario` varchar(64) NOT NULL,
  `moneda` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of propietarios
-- ----------------------------
INSERT INTO `propietarios` VALUES ('1', 'main', 'COP');

-- ----------------------------
-- Table structure for restaurantes
-- ----------------------------
DROP TABLE IF EXISTS `restaurantes`;
CREATE TABLE `restaurantes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_administrador` int(11) DEFAULT NULL,
  `nombre` varchar(64) DEFAULT NULL,
  `logo` varchar(64) DEFAULT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `fecha_registro` datetime DEFAULT NULL,
  `moneda` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of restaurantes
-- ----------------------------
INSERT INTO `restaurantes` VALUES ('8', '1', 'Restaurante 1', '8.jpg', 'Direccion principal 1', '2016-09-24 18:00:08', 'COP');
INSERT INTO `restaurantes` VALUES ('9', '1', 'Restaurante 2', '9.jpg', 'Dirección principal 2', '2016-09-24 18:15:26', 'COP');
INSERT INTO `restaurantes` VALUES ('12', '1', 'cucu', '12.jpg', 'carre 17', '2016-09-28 09:20:08', 'COP');
INSERT INTO `restaurantes` VALUES ('14', '1', '11', '14.jpg', '11', '2016-10-03 20:19:48', 'COP');
INSERT INTO `restaurantes` VALUES ('15', '2', 'las 3 esquinas', '15.jpg', 'carrera 13 85 16', '2016-10-06 02:22:28', 'COP');

-- ----------------------------
-- Table structure for restaurantes_clientes
-- ----------------------------
DROP TABLE IF EXISTS `restaurantes_clientes`;
CREATE TABLE `restaurantes_clientes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_restaurante` int(11) NOT NULL,
  `id_cliente` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of restaurantes_clientes
-- ----------------------------

-- ----------------------------
-- Table structure for restaurantes_sucursales
-- ----------------------------
DROP TABLE IF EXISTS `restaurantes_sucursales`;
CREATE TABLE `restaurantes_sucursales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_restaurante` int(11) DEFAULT NULL,
  `id_administrador` int(11) DEFAULT NULL,
  `direccion` varchar(255) DEFAULT NULL,
  `fecha_registro` datetime DEFAULT NULL,
  `latitud` float DEFAULT NULL,
  `longitud` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of restaurantes_sucursales
-- ----------------------------
INSERT INTO `restaurantes_sucursales` VALUES ('14', '8', '1', 'Sucursal 1', '2016-09-24 18:03:35', '4.60929', '-74.0737');
INSERT INTO `restaurantes_sucursales` VALUES ('15', '8', '1', 'Sucursal 2', '2016-09-24 18:13:33', '4.54016', '-74.5393');
INSERT INTO `restaurantes_sucursales` VALUES ('16', '8', '1', 'Sucursal 3', '2016-09-24 18:14:45', '4.80166', '-73.877');
INSERT INTO `restaurantes_sucursales` VALUES ('17', '9', '1', 'Sucursal 1 R2', '2016-09-24 19:19:42', '7.18367', '-73.1745');
INSERT INTO `restaurantes_sucursales` VALUES ('18', '9', '1', 'Sucursal 2 R2', '2016-09-24 19:20:51', '4.799', '-74.2104');
INSERT INTO `restaurantes_sucursales` VALUES ('21', '12', '1', 'cici', '2016-09-28 09:28:52', '4.779', '-73.9874');
INSERT INTO `restaurantes_sucursales` VALUES ('22', '15', '2', 'carrera 58 no 80 81', '2016-10-06 02:28:28', '4.75449', '-74.4081');
INSERT INTO `restaurantes_sucursales` VALUES ('23', '14', '1', '1', '2016-10-06 10:26:04', '4.18344', '-73.3176');
INSERT INTO `restaurantes_sucursales` VALUES ('24', '8', '1', '1111', '2016-10-06 14:00:35', '4.99245', '-72.8009');
INSERT INTO `restaurantes_sucursales` VALUES ('25', '15', '2', 'carrera 109a # 83 50', '2016-10-06 20:06:30', '2.76748', '-75.2124');

-- ----------------------------
-- Table structure for sucursales_cocina
-- ----------------------------
DROP TABLE IF EXISTS `sucursales_cocina`;
CREATE TABLE `sucursales_cocina` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sucursal` int(11) NOT NULL,
  `id_cocina` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sucursales_cocina
-- ----------------------------
INSERT INTO `sucursales_cocina` VALUES ('1', '14', '1');
INSERT INTO `sucursales_cocina` VALUES ('3', '22', '2');
INSERT INTO `sucursales_cocina` VALUES ('4', '25', '3');

-- ----------------------------
-- Table structure for sucursales_menus
-- ----------------------------
DROP TABLE IF EXISTS `sucursales_menus`;
CREATE TABLE `sucursales_menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sucursal` int(11) NOT NULL,
  `id_menu` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sucursales_menus
-- ----------------------------
INSERT INTO `sucursales_menus` VALUES ('9', '14', '4');
INSERT INTO `sucursales_menus` VALUES ('10', '15', '5');
INSERT INTO `sucursales_menus` VALUES ('11', '14', '6');
INSERT INTO `sucursales_menus` VALUES ('12', '14', '7');
INSERT INTO `sucursales_menus` VALUES ('13', '14', '8');
INSERT INTO `sucursales_menus` VALUES ('15', '19', '10');
INSERT INTO `sucursales_menus` VALUES ('16', '21', '11');
INSERT INTO `sucursales_menus` VALUES ('17', '20', '12');
INSERT INTO `sucursales_menus` VALUES ('18', '14', '13');
INSERT INTO `sucursales_menus` VALUES ('19', '14', '14');
INSERT INTO `sucursales_menus` VALUES ('20', '15', '15');
INSERT INTO `sucursales_menus` VALUES ('21', '15', '16');
INSERT INTO `sucursales_menus` VALUES ('22', '15', '17');
INSERT INTO `sucursales_menus` VALUES ('23', '16', '18');
INSERT INTO `sucursales_menus` VALUES ('24', '16', '19');
INSERT INTO `sucursales_menus` VALUES ('25', '16', '20');
INSERT INTO `sucursales_menus` VALUES ('26', '14', '21');
INSERT INTO `sucursales_menus` VALUES ('27', '14', '22');
INSERT INTO `sucursales_menus` VALUES ('28', '22', '23');
INSERT INTO `sucursales_menus` VALUES ('29', '22', '24');
INSERT INTO `sucursales_menus` VALUES ('30', '22', '25');
INSERT INTO `sucursales_menus` VALUES ('31', '23', '26');
INSERT INTO `sucursales_menus` VALUES ('32', '23', '27');
INSERT INTO `sucursales_menus` VALUES ('33', '23', '28');
INSERT INTO `sucursales_menus` VALUES ('34', '23', '29');
INSERT INTO `sucursales_menus` VALUES ('35', '23', '30');
INSERT INTO `sucursales_menus` VALUES ('36', '23', '31');
INSERT INTO `sucursales_menus` VALUES ('37', '24', '32');
INSERT INTO `sucursales_menus` VALUES ('38', '24', '33');
INSERT INTO `sucursales_menus` VALUES ('39', '24', '34');
INSERT INTO `sucursales_menus` VALUES ('40', '24', '35');
INSERT INTO `sucursales_menus` VALUES ('41', '24', '36');
INSERT INTO `sucursales_menus` VALUES ('42', '24', '37');
INSERT INTO `sucursales_menus` VALUES ('43', '25', '38');
INSERT INTO `sucursales_menus` VALUES ('44', '25', '39');
INSERT INTO `sucursales_menus` VALUES ('45', '25', '40');
INSERT INTO `sucursales_menus` VALUES ('46', '25', '41');
INSERT INTO `sucursales_menus` VALUES ('47', '25', '42');
INSERT INTO `sucursales_menus` VALUES ('48', '25', '43');
INSERT INTO `sucursales_menus` VALUES ('49', '25', '44');
INSERT INTO `sucursales_menus` VALUES ('50', '25', '45');
INSERT INTO `sucursales_menus` VALUES ('51', '22', '46');
INSERT INTO `sucursales_menus` VALUES ('52', '22', '47');
INSERT INTO `sucursales_menus` VALUES ('53', '22', '48');
INSERT INTO `sucursales_menus` VALUES ('54', '22', '49');
INSERT INTO `sucursales_menus` VALUES ('55', '22', '50');
INSERT INTO `sucursales_menus` VALUES ('56', '22', '51');

-- ----------------------------
-- Table structure for sucursales_meseros
-- ----------------------------
DROP TABLE IF EXISTS `sucursales_meseros`;
CREATE TABLE `sucursales_meseros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sucursal` int(11) NOT NULL,
  `id_mesero` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sucursales_meseros
-- ----------------------------
INSERT INTO `sucursales_meseros` VALUES ('1', '14', '1');
INSERT INTO `sucursales_meseros` VALUES ('3', '21', '2');
INSERT INTO `sucursales_meseros` VALUES ('11', '22', '3');
INSERT INTO `sucursales_meseros` VALUES ('12', '25', '4');