# ************************************************************
# Sequel Ace SQL dump
# Versión 20046
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Equipo: localhost (MySQL 8.0.32)
# Base de datos: admin_rh
# Tiempo de generación: 2023-05-23 19:31:41 +0000
# ************************************************************


/*!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 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Volcado de tabla offices
# ------------------------------------------------------------

DROP TABLE IF EXISTS `offices`;

CREATE TABLE `offices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state_id` int DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `suburb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outside_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inside_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `municipality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `offices` WRITE;
/*!40000 ALTER TABLE `offices` DISABLE KEYS */;

INSERT INTO `offices` (`id`, `created_at`, `updated_at`, `name`, `state_id`, `street`, `suburb`, `outside_number`, `inside_number`, `municipality`, `city`, `zip_code`, `company_id`, `deleted_at`)
VALUES
	(1,NULL,'2023-02-15 15:40:20','Vallejos',14,'Infonavit 909 E.N 45. Pte 134 num 631, Colonia Industrial Vallejo Azcapotzalco C.P. 02300','Colonia Industrial','6135','34','34','Azcapotzalco','02300',1,NULL),
	(2,NULL,NULL,'Cuautitlan',14,'Autopista México-Qro, Plaza San Marcos num. E','Jardines de la Hacienda Sur','E','',NULL,'Cuautitlan Izcalli','54726',1,NULL),
	(3,NULL,NULL,'Ermita',14,'Calz. Ermita Iztapalapa','Sta Isabel Industrial','927','',NULL,'Iztapalapa','09820',1,NULL),
	(4,NULL,NULL,'CTM',14,'Ignacio L. Vallarta','Tabacalera','8','',NULL,'Cuahutemoc','06030',1,NULL),
	(5,NULL,NULL,'Ermita',14,'Calz. Ermita Iztapalapa','Sta Isabel Industrial','927','',NULL,'Iztapalapa','09820',1,NULL),
	(6,NULL,NULL,'Tlalnepantla',14,'Av. Presidente Juárez','Industrial Puente de Vigas','2034','',NULL,'Tlalnepantla','54070',1,NULL),
	(7,NULL,NULL,'Barranca de Muerto',14,'Av. Barranca del Muerto','Guadalupe Inn','280','',NULL,'Alvaro Obregon','01029',1,NULL),
	(8,NULL,NULL,'La Viga',14,'Calz. de la Viga','Jamaica','398','',NULL,'Venustiano Carranza','15800',1,NULL),
	(9,NULL,NULL,'Tepic',17,'Av. Insurgentes Pte. Plaza Fiesta Tepic','Fracc Las Brisas Tepic Nayarit','S/N','',NULL,'Tepic','63117',1,NULL),
	(10,NULL,NULL,'Nuevo Vallarta',17,'Av. Los Tules Plaza Local 14-17','Fracc Los Tules Puerto Valalrta','179','14-17',NULL,'Puerto Vallarta','48310',1,NULL),
	(11,NULL,NULL,'Celaya',10,'Eje Norponiente (Avenida Araucarias)','Fracc Villas de la Hacienda','1013','',NULL,'Celaya','38088',1,NULL),
	(12,NULL,NULL,'Irapuato',10,'Av. Murano num. 151','Ejido','151','',NULL,'Irapuato','37200',1,NULL),
	(13,NULL,NULL,'Leon',10,'Blvd. Juan Alonso de Torres','San José del Consuelo','1315','',NULL,'León','37200',1,NULL),
	(14,NULL,NULL,'Salamanca',10,'Av. Faja de Oro','Guadalupe','1502','',NULL,'Salamanca','36740',1,NULL),
	(15,NULL,NULL,'Tapachula',6,'Central Norte num. 11','5 de Febrero','11','',NULL,'Tapachula','30710',1,NULL),
	(16,NULL,NULL,'Tuxtla Gutierrez',6,'Blvd. Belisario Domínguez','Fracc Plaza Platino','2775','',NULL,'Tuxtla Gutierrez','29020',1,NULL),
	(17,NULL,NULL,'Ciudad Juaréz',7,'Av. Teófilo Borunda','Las Acequias','7387','',NULL,'Ciudad Juarez','32617',1,NULL),
	(18,NULL,NULL,'Chihuahua',7,'Allende num. 1500','Centro','1500','',NULL,'Chihuahua','31000',1,NULL),
	(19,NULL,NULL,'Parral',7,'Av. Independencia','Primavera Hidalgo','399','',NULL,'Parral','33800',1,NULL),
	(20,NULL,NULL,'Lazaro Cardenas',15,'Av. Melchor Ocampo','Segundo Sector de FIDELAC','31','1',NULL,'Lazaro Cardenas','60953',1,NULL),
	(21,NULL,NULL,'Morelia',15,'Siervo de la Nación num. 2000','Libertad','2000','',NULL,'Morelia','58170',1,NULL),
	(22,NULL,NULL,'Uruapan',15,'Paseo Lázaro Cárdenas','Morelos','10','',NULL,'Uruapan','60050',1,NULL),
	(23,NULL,NULL,'Campeche',4,'Av. Miguel Alemán','Área ah-Kim-pech','8','',NULL,'Campeche','24010',1,NULL),
	(24,NULL,NULL,'Ciudad del Carmen',4,'Av. Aviacion','Petrolera','245','',NULL,'Ciudad del Carmen','24179',1,NULL),
	(25,NULL,NULL,'Zamora',15,'Av. Prolongación Ferrocarril','Fracc La Sandovaleña','211','',NULL,'Zamora','59660',1,NULL),
	(26,NULL,NULL,'San Juan del Río',21,'Blvd. Miguel Hidalgo','Centro','229','',NULL,'San Juan del Río','76800',1,NULL),
	(27,NULL,NULL,'Querétaro',21,'Blvd. Bernardo Quintana','Balcón Campestre','4038','',NULL,'Querétaro','76159',1,NULL),
	(28,NULL,NULL,'Toluca',14,'Blvd. Miguel Alemán Valdés num. 4530','San Pedro Totoltepec','4530','',NULL,'Toluca','50226',1,NULL),
	(29,NULL,NULL,'Tlaxcala',28,'Blvd. Revolución','Atempan','56','',NULL,'Tlaxcala','90010',1,NULL),
	(30,NULL,NULL,'Fresnillo',31,'Av. Fco García Salinas','Centro','498','',NULL,'Fresnillo','99000',1,NULL),
	(31,NULL,NULL,'Tuxtepec',19,'Blvd. Benito Juárez','Los Ángeles San Juan Bautista','795','4142',NULL,'Tuxtepec','68301',1,NULL),
	(32,NULL,NULL,'Juchitan',19,'2 de Abril Esq. con Álvaro Obregón','Segunda Sección','s/n','',NULL,'Juchitan Zaragoza','7000',1,NULL),
	(33,NULL,NULL,'Huatulco',19,'Carrizal Sector H','La crucecita Santa María','603','',NULL,'Huatulco','70989',1,NULL),
	(34,NULL,NULL,'Oaxaca',19,'Mártires de Tacubaya','Santa María Icotel Santa Lucía del Camino','400','',NULL,'Oaxaca','68100',1,NULL),
	(35,NULL,NULL,'Playa del Carmen',22,'Av. Chemuyil','Toscana Solidaridad','Mza 9','',NULL,'Playa del Carmen','77725',1,NULL),
	(36,NULL,NULL,'Chetumal',22,'Calz. Veracruz','Barrio Bravo','63','',NULL,'Chetumal','77098',1,NULL),
	(37,NULL,NULL,'Cancun',22,'Av. Tulum Sur Mz. 4,5 Y 9','Super Manzana 7','217','',NULL,'Cancun','77500',1,NULL),
	(38,NULL,NULL,'Manzanillo',33,'Av. Manzanillo','Arboledas','133','',NULL,'Manzanillo','28869',1,NULL),
	(39,NULL,NULL,'Colima',33,'Av. 20 de Noviembre','Fracc. San Pablo','695','',NULL,'Colima','28063',1,NULL),
	(40,NULL,NULL,'RMVM',14,'-','-','-','-',NULL,'-','0',1,NULL),
	(41,NULL,NULL,'Jalisco',13,'Av Juan Palomar y Arias','Col. Vallarta San Jorge','37','-',NULL,'Guadalajra','44590',1,NULL);

/*!40000 ALTER TABLE `offices` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_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 */;
