--
-- Host: 127.0.0.1    Database: basephp7
-- ------------------------------------------------------


--
-- Table structure for table `ciudades`
--

CREATE TABLE `ciudades` (
  `ciudades_id` int(11) NOT NULL AUTO_INCREMENT,
  `ciudades_nombre` varchar(45) DEFAULT NULL,
  `ciudades_paises_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ciudades_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ciudades`
--

INSERT INTO `ciudades` VALUES (1,'BOGOTA',1),(2,'MEDELLIN',1),(3,'CALI',1),(4,'PEREIRA',1);

--
-- Table structure for table `item_menu`
--

CREATE TABLE `item_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(45) DEFAULT NULL,
  `etiqueta` varchar(45) DEFAULT NULL,
  `id_opcion` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `item_menu`
--

INSERT INTO `item_menu` VALUES (1,'users/index','Usuarios del sistema',1);

--
-- Table structure for table `localidades`
--

CREATE TABLE `localidades` (
  `localidades_id` int(11) NOT NULL AUTO_INCREMENT,
  `localidades_nombre` varchar(45) DEFAULT NULL,
  `localidades_ciudades_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`localidades_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `localidades`
--

INSERT INTO `localidades` VALUES (1,'BOSA',1),(2,'KENNEDY',1),(3,'USME',1),(4,'CIUDAD BOLIVAR',1);

--
-- Table structure for table `menu_perfil`
--

CREATE TABLE `menu_perfil` (
  `idmenu_perfil` int(11) NOT NULL AUTO_INCREMENT,
  `usuario_idusuario` int(11) DEFAULT NULL,
  `opcion` int(11) DEFAULT NULL,
  `item` int(11) DEFAULT NULL,
  `subitem` int(11) DEFAULT NULL,
  PRIMARY KEY (`idmenu_perfil`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `menu_perfil`
--

INSERT INTO `menu_perfil` VALUES (1,13,1,0,0),(2,13,1,1,0),(8,1,1,0,0),(9,1,1,1,0);

--
-- Table structure for table `opcion_menu`
--

CREATE TABLE `opcion_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) DEFAULT NULL,
  `estado` int(11) DEFAULT NULL,
  `orden` int(11) DEFAULT NULL,
  `icono` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `opcion_menu`
--

INSERT INTO `opcion_menu` VALUES (1,'Sistema',1,1,'fas fa-fw fa-cog');

--
-- Table structure for table `paises`
--

CREATE TABLE `paises` (
  `paises_id` int(11) NOT NULL AUTO_INCREMENT,
  `paises_nombre` varchar(45) DEFAULT NULL,
  `paises_poblacion` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`paises_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `paises`
--

INSERT INTO `paises` VALUES (1,'COLOMBIA','12887474'),(2,'VENEZUELA','388477'),(3,'ESPAÑA','21384748'),(4,'RUSIA','47738277'),(5,'CHINA','764653531');

--
-- Table structure for table `rol`
--

CREATE TABLE `rol` (
  `rol_id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`rol_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rol`
--

INSERT INTO `rol` VALUES (1,'Administrador'),(2,'Secretaria');

--
-- Table structure for table `subitem_menu`
--

CREATE TABLE `subitem_menu` (
  `ind` int(11) NOT NULL,
  `action` varchar(45) DEFAULT NULL,
  `etiqueta` varchar(45) DEFAULT NULL,
  `id_item` int(11) DEFAULT NULL,
  PRIMARY KEY (`ind`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subitem_menu`
--


--
-- Table structure for table `ubicaciones`
--

CREATE TABLE `ubicaciones` (
  `ubicaciones_id` int(11) NOT NULL AUTO_INCREMENT,
  `paises_id` int(11) DEFAULT NULL,
  `ciudades_id` int(11) DEFAULT NULL,
  `localidades_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ubicaciones_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ubicaciones`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `passwordview` varchar(250) DEFAULT NULL,
  `password` varchar(250) NOT NULL,
  `email` varchar(80) NOT NULL,
  `authKey` varchar(250) NOT NULL,
  `accessToken` varchar(250) NOT NULL,
  `activate` tinyint(1) NOT NULL DEFAULT 1,
  `role` int(11) DEFAULT NULL,
  `nombres` varchar(60) DEFAULT NULL,
  `apellidos` varchar(60) DEFAULT NULL,
  `foto` varchar(250) DEFAULT 'default.png',
  `tipoIdentificacion` int(11) DEFAULT NULL,
  `numeroIdentificacion` int(11) DEFAULT NULL,
  `direccion` varchar(150) DEFAULT NULL,
  `telefono` double DEFAULT NULL,
  `tipoContrato` int(11) DEFAULT NULL,
  `fechaInicioContrato` date DEFAULT NULL,
  `fechaFinContrato` date DEFAULT NULL,
  `cargo` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'admin','Temporal123','JiJSkWV2NCOq2','asdf@asdf.asdf','cf11061916902f8ee555a61f171d667949930c87469453e5dadb176fb11405c2a80ce8ca6b7e7d22b4366f9641e19af2fe5aabe3664e6d4465689cb2b794f508197f43f247e4423dfb8fafa4032d45f31b89c1d7fe60fe1c687d998c259c6cc5f27a2593','9bc290d0ca50683a3ee1696dc03060441e0a087bf3191dcf2c1c5cfb64ec80cb772756fc02a9a849f02d156eed6f8638a62b9952f62e1a999a14c3b84dd7637bcb05a39fd17a61cf2af048e882262594c6c5a3b281bb9eeb90a3b3fdbe4acda4976b79aa',1,1,'Super usuario','aaa','default.png',1,19901987,'aaa',4444,NULL,'1900-12-15','1900-12-14',NULL),(2,'secretaria','Holaaa','Ji0fuPD2M9bRQ','','ded5dbf65c3000a256de0da1bfe5013b89511fb2e9bb74fcd165713fa48708532507fe849d522526d4d08bc5e6960543af0ed860943b06b9394418d041f494d66a7bce9ccb46586b1b7a3cbce655d3254660fea6359cfc80f8907ff9335f65e16fec3c57','0a3f08a1fba36a3a0dfe3509607bff6ec2fd75d866ecf960c91d8004ade9a8a881871752717d39b17ca0b0b9a6c66c62c4657d5a5321e5e686914ce2c125489526c32bea62981624413357c14489c5c219101ace7c20f49de5c4da3bd77b9234a87ee15b',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(3,'secretaria1','Temporal123','JiJSkWV2NCOq2','','02bcc18001030ed579359c45f6574b96a46148240c004d8f8788199eba1a6ea840702e377760b146b6af1e3a3bf3e6624556c16af8c058f62e82d66c1a72dcf1b0e4506486fa7d479c0057f1bd909273877a4d28a2dae2bfa42fb7cff6789f810dbdfefe','b6deb50d8a1cf970c61b2e48547a354acb309c43c3f41489cd70e62d73c1ccd608f683550d7f010c08ca77375db1f6dd32018b5ada5be4732c396fd762ae44c4ebdc2aa324b91f8914fb0311b7a90790bfdb0a97a183ee1f2020da247cf1c44ab6c7ad87',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(4,'secretaria2','Temporal123','JiJSkWV2NCOq2','','8210d79ac0c5023e776bbf233b07b5a4125b376789468affcdaff9391dac8ec156dd08650fe22a9e8dc61b844a614b63fb46281045b76fec12ad3b311aec03df0be0c010e4af11acee8f10fc45bda3fbf796aca0fcc7d309411d336c586b2269c39cb25c','e8e3d5dc78fce3f9271939b31f99cc10d65fd62cee55aed1339cce8b49df2f6b1cacb13fbd24c7b2d4d92082eb23d5ea223f9a3c8ca221b6f40c497b552b6184ffb285c43cf0724f4e4a8eb80b37cdc37311a44dda8728a948d646d0e7c4a1364c9512cb',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(5,'secretaria4','Temporal123','JiJSkWV2NCOq2','','854995223f2cebc3b544be50c2a4d5af97e30db79822363563354abee811b73e5bd16fce1562936a4917276f9d51a94d8bd4759294474c75cdf172ffc96093b4f41baf76aeee6c6ca3519e33d67b53a396d553d45bc3a429f4892cfac2870833ffc6da43','afd9a2b9cec5661c4c7603d46b6647a578508f21ba7bc9a2947e63645c73dbde4d8c77520fd4fc2fa5aae2bff917c97abf5e7f6b7ee089db262370eb22f60d8c1629b4abc330e0827e0a426ea090e417c3202b45bc499f726b9fb9abea82eec90ff9f591',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(6,'secretaria5','Temporal123','JiJSkWV2NCOq2','','586a8fed78da5f55a973082c5869a969bd2cd26db44bd150da46b2c6aecddc4cc05200d018b5c0f6db1ab732ca959c7d83c63d5602dcdb2a11de62bf3dc25b344e12d0dc3d331765338926cbeb4cb25d186e8d328b007cc16ae45011e31cf2b720f3e634','8a428453957025851f30a3174125ec54490afc5b3f5e8fb5c4b1f31c53c719a8aaa496773e0e130756a67f40d0efbca1f4d56f0594ba006bf0c926764821087b3e675260cc4e3e8333a22c28ec5ff29f21957a2816906548aae73a823e1b59a76efff0b8',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(7,'secretaria6','Temporal123','JiJSkWV2NCOq2','','2dcf1117bbb331a326ff3267ae2e2eb6fdaae1291f006b89342e741538ee47b271d053ad3cad7e7d214827ea93e6d3dc2e5ed4e3b0b83b1d4e66a4e8d3cf8c4081220d73a7c7b3c0729ec7101f6c3b73dc94747e78923badd54567dcbb44fd8c813539a0','dc7fd5e7747543ec2b838448c839a11c47ea014a53203d641f10f2999fb850ffee125aec0400a672577852f12c5b00bfb4a614520a02cd835c0ddfdf085f14464e23cd2ee7c0791c769d174ca13aaeaa22373c02582951045374d3771aeb8190481e9cf6',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(8,'secretaria7','Temporal123','JiJSkWV2NCOq2','','dd1efe58c0cb7f6c127083746bcbe98221332005a2ec9f105cdf015c5ac35e0ca4d240d811ea73a2c650765791a5a0ede2cfb48cb28689beada7d7a16bd086a55d5f59f4ed211b8659cbfc06c796388d41fc44b7a9412be11a3c4c62b304d75f168bae58','8e57b12cd1c30e6a35b407001d663124284f9e9d495c9f85a96a526a0801d89f01e0613a82467ebf0cc9d7dce92acfc222e91654dcadc93f29bc732027e3c085a478c394a79df977b1304ab9ee15ab4206d31638ffdc63b2e9c335e4f25a7c60ad976e4d',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(9,'secretaria8','Temporal123','JiJSkWV2NCOq2','','72cdb544ac260d097523f2de0d40ee0115f54dbdf86a227160f07281b165e91b225223a76631202ca8c8aa52e203bf71ec93e944c3dc20beb6466b6d3ee9a198d7b3affb7129310c96ad5df499096a268abc10e9527f98106fb634b9058e487dab9372f8','55af9243bc5bc2e3499e718ebba1989d3ca9be246a2b4b63018ef505848d8cf8dde9314c5c5583b357174378cca5ddd724eacdeb85ab02728583b0a1a225032b1a4acada3e431406444712b98497ba2c78d6c06a8b8b8737ad3f7b85277f29b218051aae',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(10,'secretaria9','Temporal123','JiJSkWV2NCOq2','','4e825ba258fe2c82ffea4ce3662fd78a3ada127d3d7af451fb86981f8f01671efa7866f8061fa6491f34f680a56dc135e8698e7c12bc87b482dc7ccc69cf9754cd70890f60259d655828f3af07c4c298e664b8f17234acaf58e4e0a21f1a87af5751c9b4','6e16e81caeae5459de286645d9d3794f51152370b8e05b5010d411de2134dc46455bb70fe856bb879628ccf9d71310f538df4d0864b2c2f1d379bb60850b1b7fd7df400c4e8da8d74d3d03d528e7eecdb47c0ffbb557118ceb01dbd2d7ec4e2f32350345',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(11,'secretaria10','Temporal123','JiJSkWV2NCOq2','','c4c319b449be4eea9e143480c2d0046083d6a1618aa19acf7965d6e9e31e2b9229ca6f18531a08ffbafd2454ae1d14e05092fadfadf9e7f150d5bd281fa786ec177e51faa264cfb2de91dfa5acf67bd36141ba36f7c13637324983f11bf0a566e25260b8','01034a450995235e893e67eb21722095d435d1408bbc34bc95de9c77178689f19959176d493038ae81a52c0f14dccffcd5fc3e054251a017a73b3dd74d3431bbb3f089dfb010038959275aa433cba1dca12c86beb24b4fee8189b3858212cab086c5c25c',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(12,'secretaria11','Temporal123','JiJSkWV2NCOq2','','05a826a9474bd44deb1ca942985519768b24de74ccdc0bbb5e6f7ffc0ee3bc8fac17add39e31488919cd94811aa491374413c2175961b02acfb9fb8195145996aa1e4d7f03fe37cd2096e17b6b6f53300374b19f86fee564b03d0ddd053c7d87cdae9cb3','f62184b2fd3daf865d0695a99b02ced5f2cc980669bf734bbc26bb5f6f8256ed7656cfff8db740a4e6b7f4d2a2e8333b61da3c62298a0ea5bd0b4af69b651fffab18062b67478e802969aca51a342f3bcbbf303fedaa8085915d29d776c39bbd9546848f',1,2,'secretaria','','default.png',NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),(13,'cbautista','Temporal123','JiJSkWV2NCOq2','asf@sf.asdf','1e0ad0264ae44c8838963fb10220aa65e2e297c13bf2908ca91368916fdb043a2e33f632447f3d2ac9425b6aca87485979928f4c84cd6e65b771c17256bbcc604dbcc22bb76b525d5da03065ee681d01920104f07a1a4214e351cbad351ef181bf4870d0','67e2a272be4065969dae8bcd86726c69d3e64124334bb06a79a3f8f2c5d62e364b97f6a2c151983362981ea0e950654a08423da5ee775962335613563ab33eb1c0bf249872e51675b96482ca37baf7e74b02c8047c48dde468012ba2b76e951579885d8b',1,1,'cristian camilo','bautista bautista','default.png',NULL,NULL,'adfa',999,NULL,NULL,NULL,NULL);


