-- MySQL dump 10.13  Distrib 5.5.52, for Linux (x86_64)
--
-- Host: localhost    Database: antsoftw_ricaurte_unidad
-- ------------------------------------------------------
-- Server version	5.5.52-cll

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `accesos`
--

DROP TABLE IF EXISTS `accesos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accesos` (
  `ap_codpro` int(11) NOT NULL DEFAULT '0',
  `ap_nombre` char(40) NOT NULL DEFAULT '',
  `ap_nivelp` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`ap_codpro`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accesos`
--

LOCK TABLES `accesos` WRITE;
/*!40000 ALTER TABLE `accesos` DISABLE KEYS */;
INSERT INTO `accesos` (`ap_codpro`, `ap_nombre`, `ap_nivelp`) VALUES (100,'Menu Principal','A'),(101,'Configuracion Empresa','Z'),(102,'Configuracion Usuarios','Z'),(103,'Configuracion Accesos','Z'),(104,'Configuracion Modulos','Z'),(201,'Parametros','Z'),(10000,'Unidad de correspondientes','B'),(10001,'Unidad Procesos','B');
/*!40000 ALTER TABLE `accesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `area`
--

DROP TABLE IF EXISTS `area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `area` (
  `ar_codare` int(3) NOT NULL DEFAULT '0',
  `ar_descri` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`ar_codare`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `area`
--

LOCK TABLES `area` WRITE;
/*!40000 ALTER TABLE `area` DISABLE KEYS */;
INSERT INTO `area` (`ar_codare`, `ar_descri`) VALUES (1,'Gerencia'),(3,'Ambiental'),(2,'Control Interno'),(4,'Juridica'),(5,'Talento Humano'),(6,'Financiera y Tesoreria'),(7,'División Comercial y atención al usuario'),(8,'División Técnica Operativa'),(9,'Sistemas'),(10,'Almacen'),(17,'Redes'),(13,'Tecnico Administrativo'),(11,'Gestion Documental'),(14,'Ingeniera Civil');
/*!40000 ALTER TABLE `area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clientes`
--

DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clientes` (
  `cl_codcli` char(12) NOT NULL DEFAULT '',
  `cl_nombre` char(50) NOT NULL,
  `cl_direcc` char(40) NOT NULL DEFAULT '',
  `cl_repres` char(40) NOT NULL,
  `cl_telefo` char(25) NOT NULL,
  `cl_porcen` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cl_codcli`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clientes`
--

LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
INSERT INTO `clientes` (`cl_codcli`, `cl_nombre`, `cl_direcc`, `cl_repres`, `cl_telefo`, `cl_porcen`) VALUES ('1','SUPERINTENDENCIA DE SERVICIOS PUBLICOS','','','',''),('9015111787-9','INVERSIONES PROAL S.A.','CL 52 No 47-42 Piso 32','HERNANDO ANGEL RINCON','5765100','postobanfcentral@postobon.com.co'),('900639486-4',' H M HUGO FERNANDO MARROQUIN','CARRERA 7 No','HUGO FERNANDO MARROQUIN','316358282','licitacionesorekasas@gmail.com'),('890600003-6','ACUAGYR','Calle 16 carrera 1-','YAN MAURICIO ALMANZA','6014414502','www.acuagyr.com'),('1069176320','LUIS CARLOS AVILA ESTRELLA','JOSE MARIA CORDOBA','LUIS CARLOS AVILA ESTRELLA','3219273504','avilaestrellaluiscarlos@gmail.com'),('14248909','LIDES DE JESUS REYES RAMIREZ','JOSE MARIA CORDOBA','','',''),('8906800591','JOSE FERNELLY CHARRY PRADA','Carrera 15 No 6-22','JOSE FERNELLY CHARRY PRADA','8338560','alcaldia@ricaurte-cundinamarca.gov.co'),('830022247-8','CAR','','DIANA PATRICIA RANGEL JIMENEZ','3134715704','drangelj@car.gov.co'),('11304572','GERMAN JOHAN HERRAN MARTINEZ','','GERMAN JOHAN HERRAN MARTINEZ','3224496122','cpr1108@hotmail.com'),('901227165-0','UNION TEMPORAL ARRAYANES','ARRAYANES','HERNAN SANTIAGO NIÑO CALVANO','3144364128',''),('822000897-1','CRISTINA DEL PILAR HERNANDEZ VELASQUEZ','CALLE 10 No 15-88','CRISTINA DEL PILAR HERNANDEZ VELASQUEZ','2131786','servicliente@dihego.com'),('6017428973','LUZ ESTELLA RODRIGUEZ DIAN','','LUZ ESTELLA RODRIGUEZ DIAN','',''),('0','JESYCA GONZALEZ JIMENEZ','CALLE 10 No 7.140','JESYCA GONZALEZ JIMENES','3213814691','www.dpeingenieriasa.com'),('900492453-8','CONDOMINIO PARQUES DE SANTA ANA','CALLE 10 N° 12-260 270','FARID RODRIGUEZ HENNESSEY','312 5340829','condominioparquesdesantaana@gmail.com'),('890680059-1','Municipio de Ricaurte','CRA 15-622','GLORIA RICARDO DONCEL','8333667','alcaldia @ricaurte-cundinamarca.gov.co'),('2','CONSTRUCTORA CONCONCRETO','Cra 6 No 115-65','SONIA MARITZA CASTELBLANCO T.','6202166','tramiteslegales@conconcreto.com'),('3','MAECO','CAMPO ALEGRE','JAVIER F. RADA G.','3115963425','');
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `correo`
--

DROP TABLE IF EXISTS `correo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `correo` (
  `co_email` varchar(100) NOT NULL,
  `co_nombre` varchar(100) NOT NULL,
  PRIMARY KEY (`co_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `correo`
--

LOCK TABLES `correo` WRITE;
/*!40000 ALTER TABLE `correo` DISABLE KEYS */;
/*!40000 ALTER TABLE `correo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empresa`
--

DROP TABLE IF EXISTS `empresa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empresa` (
  `ep_codemp` char(12) NOT NULL DEFAULT '',
  `ep_nombre` char(40) NOT NULL DEFAULT '',
  `ep_direcc` char(60) NOT NULL DEFAULT '',
  `ep_telefo` char(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`ep_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empresa`
--

LOCK TABLES `empresa` WRITE;
/*!40000 ALTER TABLE `empresa` DISABLE KEYS */;
INSERT INTO `empresa` (`ep_codemp`, `ep_nombre`, `ep_direcc`, `ep_telefo`) VALUES ('900639486-4','ALCARI S.A.S. E.S.P.','CL 9 16 84','8366621');
/*!40000 ALTER TABLE `empresa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `festivos`
--

DROP TABLE IF EXISTS `festivos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `festivos` (
  `fecfes` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`fecfes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `festivos`
--

LOCK TABLES `festivos` WRITE;
/*!40000 ALTER TABLE `festivos` DISABLE KEYS */;
INSERT INTO `festivos` (`fecfes`) VALUES ('2011-09-03'),('2011-09-04'),('2011-09-10'),('2011-09-11'),('2011-09-17'),('2011-09-18'),('2011-09-24'),('2011-09-25'),('2011-10-01'),('2011-10-02'),('2011-10-08'),('2011-10-09'),('2011-10-15'),('2011-10-16'),('2011-10-17'),('2011-10-22'),('2011-10-23'),('2011-10-29'),('2011-10-30'),('2011-11-05'),('2011-11-06'),('2011-11-07'),('2011-11-12'),('2011-11-13'),('2011-11-14'),('2011-11-19'),('2011-11-20'),('2011-11-26'),('2011-11-27'),('2011-12-03'),('2011-12-04'),('2011-12-08'),('2011-12-10'),('2011-12-11'),('2011-12-17'),('2011-12-18'),('2011-12-24'),('2011-12-25'),('2011-12-31'),('2012-01-01'),('2012-01-07'),('2012-01-08'),('2012-01-09'),('2012-01-14'),('2012-01-15'),('2012-01-21'),('2012-01-22'),('2012-01-28'),('2012-01-29'),('2012-02-04'),('2012-02-05'),('2012-02-11'),('2012-02-12'),('2012-02-18'),('2012-02-19'),('2012-02-25'),('2012-02-26'),('2012-03-03'),('2012-03-04'),('2012-03-10'),('2012-03-11'),('2012-03-17'),('2012-03-18'),('2012-03-19'),('2012-03-24'),('2012-03-25'),('2012-03-31'),('2012-04-01'),('2012-04-05'),('2012-04-06'),('2012-04-07'),('2012-04-08'),('2012-04-14'),('2012-04-15'),('2012-04-21'),('2012-04-22'),('2012-04-28'),('2012-04-29'),('2012-05-05'),('2012-05-06'),('2012-05-12'),('2012-05-13'),('2012-05-19'),('2012-05-20'),('2012-05-21'),('2012-05-26'),('2012-05-27'),('2012-06-02'),('2012-06-03'),('2012-06-09'),('2012-06-10'),('2012-06-11'),('2012-06-16'),('2012-06-17'),('2012-06-18'),('2012-06-23'),('2012-06-24'),('2012-06-30'),('2012-07-01'),('2012-07-02'),('2012-07-07'),('2012-07-08'),('2012-07-14'),('2012-07-15'),('2012-07-20'),('2012-07-21'),('2012-07-22'),('2012-07-28'),('2012-07-29'),('2012-08-04'),('2012-08-05'),('2012-08-07'),('2012-08-11'),('2012-08-12'),('2012-08-18'),('2012-08-19'),('2012-08-20'),('2012-08-25'),('2012-08-26'),('2012-09-01'),('2012-09-02'),('2012-09-08'),('2012-09-09'),('2012-09-15'),('2012-09-16'),('2012-09-22'),('2012-09-23'),('2012-09-29'),('2012-09-30'),('2012-10-06'),('2012-10-07'),('2012-10-13'),('2012-10-14'),('2012-10-15'),('2012-10-20'),('2012-10-21'),('2012-10-27'),('2012-10-28'),('2012-11-03'),('2012-11-04'),('2012-11-05'),('2012-11-10'),('2012-11-11'),('2012-11-12'),('2012-11-17'),('2012-11-18'),('2012-11-24'),('2012-11-25'),('2012-12-01'),('2012-12-02'),('2012-12-08'),('2012-12-09'),('2012-12-15'),('2012-12-16'),('2012-12-22'),('2012-12-23'),('2012-12-25'),('2012-12-29'),('2012-12-30'),('2013-01-05'),('2013-01-06'),('2013-01-12'),('2013-01-13'),('2013-01-19'),('2013-01-20'),('2013-01-26'),('2013-01-27'),('2013-02-02'),('2013-02-03'),('2013-02-09'),('2013-02-10'),('2013-02-16'),('2013-02-17'),('2013-02-23'),('2013-02-24'),('2013-03-02'),('2013-03-03'),('2013-03-09'),('2013-03-10'),('2013-03-16'),('2013-03-17'),('2013-03-23'),('2013-03-24'),('2013-03-30'),('2013-03-31'),('2013-04-06'),('2013-04-07'),('2013-04-13'),('2013-04-14'),('2013-04-20'),('2013-04-21'),('2013-04-27'),('2013-04-28'),('2013-05-04'),('2013-05-05'),('2013-05-11'),('2013-05-12'),('2013-05-18'),('2013-05-19'),('2013-05-25'),('2013-05-26'),('2013-06-01'),('2013-06-02'),('2013-06-08'),('2013-06-09'),('2013-06-15'),('2013-06-16'),('2013-06-22'),('2013-06-23'),('2013-06-29'),('2013-06-30'),('2013-07-06'),('2013-07-07'),('2013-07-13'),('2013-07-14'),('2013-07-20'),('2013-07-21'),('2013-07-27'),('2013-07-28'),('2013-08-03'),('2013-08-04'),('2013-08-10'),('2013-08-11'),('2013-08-17'),('2013-08-18'),('2013-08-24'),('2013-08-25'),('2013-08-31'),('2013-09-01'),('2013-09-07'),('2013-09-08'),('2013-09-14'),('2013-09-15'),('2013-09-21'),('2013-09-22'),('2013-09-28'),('2013-09-29'),('2013-10-05'),('2013-10-06'),('2013-10-12'),('2013-10-13'),('2013-10-19'),('2013-10-20'),('2013-10-26'),('2013-10-27'),('2013-11-02'),('2013-11-03'),('2013-11-09'),('2013-11-10'),('2013-11-16'),('2013-11-17'),('2013-11-23'),('2013-11-24'),('2013-11-30'),('2013-12-01'),('2013-12-07'),('2013-12-08'),('2013-12-14'),('2013-12-15'),('2013-12-21'),('2013-12-22'),('2013-12-28'),('2013-12-29'),('2014-01-04'),('2014-01-05'),('2014-01-11'),('2014-01-12'),('2014-01-18'),('2014-01-19'),('2014-01-25'),('2014-01-26'),('2014-02-01'),('2014-02-02'),('2014-02-08'),('2014-02-09'),('2014-02-15'),('2014-02-16'),('2014-02-22'),('2014-02-23'),('2014-03-01'),('2014-03-02'),('2014-03-08'),('2014-03-09'),('2014-03-15'),('2014-03-16'),('2014-03-22'),('2014-03-23'),('2014-03-29'),('2014-03-30'),('2014-04-05'),('2014-04-06'),('2014-04-12'),('2014-04-13'),('2014-04-19'),('2014-04-20'),('2014-04-26'),('2014-04-27'),('2014-05-03'),('2014-05-04'),('2014-05-10'),('2014-05-11'),('2014-05-17'),('2014-05-18'),('2014-05-24'),('2014-05-25'),('2014-05-31'),('2014-06-01'),('2014-06-07'),('2014-06-08'),('2014-06-14'),('2014-06-15'),('2014-06-21'),('2014-06-22'),('2014-06-28'),('2014-06-29'),('2014-07-05'),('2014-07-06'),('2014-07-12'),('2014-07-13'),('2014-07-19'),('2014-07-20'),('2014-07-26'),('2014-07-27'),('2014-08-02'),('2014-08-03'),('2014-08-09'),('2014-08-10'),('2014-08-16'),('2014-08-17'),('2014-08-23'),('2014-08-24'),('2014-08-30'),('2014-08-31'),('2014-09-06'),('2014-09-07'),('2014-09-13'),('2014-09-14'),('2014-09-20'),('2014-09-21'),('2014-09-27'),('2014-09-28'),('2014-10-04'),('2014-10-05'),('2014-10-11'),('2014-10-12'),('2014-10-18'),('2014-10-19'),('2014-10-25'),('2014-10-26'),('2014-11-01'),('2014-11-02'),('2014-11-08'),('2014-11-09'),('2014-11-15'),('2014-11-16'),('2014-11-22'),('2014-11-23'),('2014-11-29'),('2014-11-30'),('2014-12-06'),('2014-12-07'),('2014-12-13'),('2014-12-14'),('2014-12-20'),('2014-12-21'),('2014-12-27'),('2014-12-28'),('2015-01-03'),('2015-01-04'),('2015-01-10'),('2015-01-11'),('2015-01-17'),('2015-01-18'),('2015-01-24'),('2015-01-25'),('2015-01-31'),('2015-02-01'),('2015-02-07'),('2015-02-08'),('2015-02-14'),('2015-02-15'),('2015-02-21'),('2015-02-22'),('2015-02-28'),('2015-03-01'),('2015-03-07'),('2015-03-08'),('2015-03-14'),('2015-03-15'),('2015-03-21'),('2015-03-22'),('2015-03-23'),('2015-03-28'),('2015-03-29'),('2015-04-02'),('2015-04-03'),('2015-04-04'),('2015-04-05'),('2015-04-11'),('2015-04-12'),('2015-04-18'),('2015-04-19'),('2015-04-25'),('2015-04-26'),('2015-05-01'),('2015-05-02'),('2015-05-03'),('2015-05-09'),('2015-05-10'),('2015-05-16'),('2015-05-17'),('2015-05-18'),('2015-05-23'),('2015-05-24'),('2015-05-30'),('2015-05-31'),('2015-06-06'),('2015-06-07'),('2015-06-08'),('2015-06-13'),('2015-06-14'),('2015-06-15'),('2015-06-20'),('2015-06-21'),('2015-06-27'),('2015-06-28'),('2015-06-29'),('2015-07-04'),('2015-07-05'),('2015-07-11'),('2015-07-12'),('2015-07-18'),('2015-07-19'),('2015-07-20'),('2015-07-25'),('2015-07-26'),('2015-08-01'),('2015-08-02'),('2015-08-07'),('2015-08-08'),('2015-08-09'),('2015-08-15'),('2015-08-16'),('2015-08-17'),('2015-08-22'),('2015-08-23'),('2015-08-29'),('2015-08-30'),('2015-09-05'),('2015-09-06'),('2015-09-12'),('2015-09-13'),('2015-09-19'),('2015-09-20'),('2015-09-26'),('2015-09-27'),('2015-10-03'),('2015-10-04'),('2015-10-10'),('2015-10-11'),('2015-10-12'),('2015-10-17'),('2015-10-18'),('2015-10-24'),('2015-10-25'),('2015-10-31'),('2015-11-01'),('2015-11-02'),('2015-11-07'),('2015-11-08'),('2015-11-14'),('2015-11-15'),('2015-11-16'),('2015-11-21'),('2015-11-22'),('2015-11-28'),('2015-11-29'),('2015-12-05'),('2015-12-06'),('2015-12-08'),('2015-12-12'),('2015-12-13'),('2015-12-19'),('2015-12-20'),('2015-12-25'),('2015-12-26'),('2015-12-27'),('2016-01-01'),('2016-01-02'),('2016-01-03'),('2016-01-09'),('2016-01-10'),('2016-01-16'),('2016-01-17'),('2016-01-23'),('2016-01-24'),('2016-01-30'),('2016-01-31'),('2016-02-06'),('2016-02-07'),('2016-02-13'),('2016-02-14'),('2016-02-20'),('2016-02-21'),('2016-02-27'),('2016-02-28'),('2016-03-05'),('2016-03-06'),('2016-03-12'),('2016-03-13'),('2016-03-19'),('2016-03-20'),('2016-03-26'),('2016-03-27'),('2016-04-02'),('2016-04-03'),('2016-04-09'),('2016-04-10'),('2016-04-16'),('2016-04-17'),('2016-04-23'),('2016-04-24'),('2016-04-30'),('2016-05-01'),('2016-05-07'),('2016-05-08'),('2016-05-14'),('2016-05-15'),('2016-05-21'),('2016-05-22'),('2016-05-28'),('2016-05-29'),('2016-06-04'),('2016-06-05'),('2016-06-11'),('2016-06-12'),('2016-06-18'),('2016-06-19'),('2016-06-25'),('2016-06-26'),('2016-07-02'),('2016-07-03'),('2016-07-09'),('2016-07-10'),('2016-07-16'),('2016-07-17'),('2016-07-23'),('2016-07-24'),('2016-07-30'),('2016-07-31'),('2016-08-06'),('2016-08-07'),('2016-08-13'),('2016-08-14'),('2016-08-20'),('2016-08-21'),('2016-08-27'),('2016-08-28'),('2016-09-03'),('2016-09-04'),('2016-09-10'),('2016-09-11'),('2016-09-17'),('2016-09-18'),('2016-09-24'),('2016-09-25'),('2016-10-01'),('2016-10-02'),('2016-10-08'),('2016-10-09'),('2016-10-15'),('2016-10-16'),('2016-10-22'),('2016-10-23'),('2016-10-29'),('2016-10-30'),('2016-11-05'),('2016-11-06'),('2016-11-12'),('2016-11-13'),('2016-11-19'),('2016-11-20'),('2016-11-26'),('2016-11-27'),('2016-12-03'),('2016-12-04'),('2016-12-10'),('2016-12-11'),('2016-12-17'),('2016-12-18'),('2016-12-24'),('2016-12-25'),('2016-12-31'),('2017-01-01'),('2017-01-07'),('2017-01-08'),('2017-01-14'),('2017-01-15'),('2017-01-21'),('2017-01-22'),('2017-01-28'),('2017-01-29'),('2017-02-04'),('2017-02-05'),('2017-02-11'),('2017-02-12'),('2017-02-18'),('2017-02-19'),('2017-02-25'),('2017-02-26'),('2017-03-04'),('2017-03-05'),('2017-03-11'),('2017-03-12'),('2017-03-18'),('2017-03-19'),('2017-03-25'),('2017-03-26'),('2017-04-01'),('2017-04-02'),('2017-04-08'),('2017-04-09'),('2017-04-15'),('2017-04-16'),('2017-04-22'),('2017-04-23'),('2017-04-29'),('2017-04-30'),('2017-05-06'),('2017-05-07'),('2017-05-13'),('2017-05-14'),('2017-05-20'),('2017-05-21'),('2017-05-27'),('2017-05-28'),('2017-06-03'),('2017-06-04'),('2017-06-10'),('2017-06-11'),('2017-06-17'),('2017-06-18'),('2017-06-24'),('2017-06-25'),('2017-07-01'),('2017-07-02'),('2017-07-08'),('2017-07-09'),('2017-07-15'),('2017-07-16'),('2017-07-22'),('2017-07-23'),('2017-07-29'),('2017-07-30'),('2017-08-05'),('2017-08-06'),('2017-08-12'),('2017-08-13'),('2017-08-19'),('2017-08-20'),('2017-08-26'),('2017-08-27'),('2017-09-02'),('2017-09-03'),('2017-09-09'),('2017-09-10'),('2017-09-16'),('2017-09-17'),('2017-09-23'),('2017-09-24'),('2017-09-30'),('2017-10-01'),('2017-10-07'),('2017-10-08'),('2017-10-14'),('2017-10-15'),('2017-10-21'),('2017-10-22'),('2017-10-28'),('2017-10-29'),('2017-11-04'),('2017-11-05'),('2017-11-11'),('2017-11-12'),('2017-11-18'),('2017-11-19'),('2017-11-25'),('2017-11-26'),('2017-12-02'),('2017-12-03'),('2017-12-09'),('2017-12-10'),('2017-12-16'),('2017-12-17'),('2017-12-23'),('2017-12-24'),('2017-12-30'),('2017-12-31'),('2018-01-06'),('2018-01-07'),('2018-01-13'),('2018-01-14'),('2018-01-20'),('2018-01-21'),('2018-01-27'),('2018-01-28'),('2018-02-03'),('2018-02-04'),('2018-02-10'),('2018-02-11'),('2018-02-17'),('2018-02-18'),('2018-02-24'),('2018-02-25'),('2018-03-03'),('2018-03-04'),('2018-03-10'),('2018-03-11'),('2018-03-17'),('2018-03-18'),('2018-03-24'),('2018-03-25'),('2018-03-31'),('2018-04-01'),('2018-04-07'),('2018-04-08'),('2018-04-14'),('2018-04-15'),('2018-04-21'),('2018-04-22'),('2018-04-28'),('2018-04-29'),('2018-05-05'),('2018-05-06'),('2018-05-12'),('2018-05-13'),('2018-05-19'),('2018-05-20'),('2018-05-26'),('2018-05-27'),('2018-06-02'),('2018-06-03'),('2018-06-09'),('2018-06-10'),('2018-06-16'),('2018-06-17'),('2018-06-23'),('2018-06-24'),('2018-06-30'),('2018-07-01'),('2018-07-07'),('2018-07-08'),('2018-07-14'),('2018-07-15'),('2018-07-21'),('2018-07-22'),('2018-07-28'),('2018-07-29'),('2018-08-04'),('2018-08-05'),('2018-08-11'),('2018-08-12'),('2018-08-18'),('2018-08-19'),('2018-08-25'),('2018-08-26'),('2018-09-01'),('2018-09-02'),('2018-09-08'),('2018-09-09'),('2018-09-15'),('2018-09-16'),('2018-09-22'),('2018-09-23'),('2018-09-29'),('2018-09-30'),('2018-10-06'),('2018-10-07'),('2018-10-13'),('2018-10-14'),('2018-10-20'),('2018-10-21'),('2018-10-27'),('2018-10-28'),('2018-11-03'),('2018-11-04'),('2018-11-10'),('2018-11-11'),('2018-11-17'),('2018-11-18'),('2018-11-24'),('2018-11-25'),('2018-12-01'),('2018-12-02'),('2018-12-08'),('2018-12-09'),('2018-12-15'),('2018-12-16'),('2018-12-22'),('2018-12-23'),('2018-12-29'),('2018-12-30'),('2019-01-05'),('2019-01-06'),('2019-01-12'),('2019-01-13'),('2019-01-19'),('2019-01-20'),('2019-01-26'),('2019-01-27'),('2019-02-02'),('2019-02-03'),('2019-02-09'),('2019-02-10'),('2019-02-16'),('2019-02-17'),('2019-02-23'),('2019-02-24'),('2019-03-02'),('2019-03-03'),('2019-03-09'),('2019-03-10'),('2019-03-16'),('2019-03-17'),('2019-03-23'),('2019-03-24'),('2019-03-30'),('2019-03-31'),('2019-04-06'),('2019-04-07'),('2019-04-13'),('2019-04-14'),('2019-04-20'),('2019-04-21'),('2019-04-27'),('2019-04-28'),('2019-05-04'),('2019-05-05'),('2019-05-11'),('2019-05-12'),('2019-05-18'),('2019-05-19'),('2019-05-25'),('2019-05-26'),('2019-06-01'),('2019-06-02'),('2019-06-08'),('2019-06-09'),('2019-06-15'),('2019-06-16'),('2019-06-22'),('2019-06-23'),('2019-06-29'),('2019-06-30'),('2019-07-06'),('2019-07-07'),('2019-07-13'),('2019-07-14'),('2019-07-20'),('2019-07-21'),('2019-07-27'),('2019-07-28'),('2019-08-03'),('2019-08-04'),('2019-08-10'),('2019-08-11'),('2019-08-17'),('2019-08-18'),('2019-08-24'),('2019-08-25'),('2019-08-31'),('2019-09-01'),('2019-09-07'),('2019-09-08'),('2019-09-14'),('2019-09-15'),('2019-09-21'),('2019-09-22'),('2019-09-28'),('2019-09-29'),('2019-10-05'),('2019-10-06'),('2019-10-12'),('2019-10-13'),('2019-10-19'),('2019-10-20'),('2019-10-26'),('2019-10-27'),('2019-11-02'),('2019-11-03'),('2019-11-09'),('2019-11-10'),('2019-11-16'),('2019-11-17'),('2019-11-23'),('2019-11-24'),('2019-11-30'),('2019-12-01'),('2019-12-07'),('2019-12-08'),('2019-12-14'),('2019-12-15'),('2019-12-21'),('2019-12-22'),('2019-12-28'),('2019-12-29'),('2020-01-01'),('2020-01-04'),('2020-01-05'),('2020-01-06'),('2020-01-11'),('2020-01-12'),('2020-01-18'),('2020-01-19'),('2020-01-25'),('2020-01-26'),('2020-02-01'),('2020-02-02'),('2020-02-08'),('2020-02-09'),('2020-02-15'),('2020-02-16'),('2020-02-22'),('2020-02-23'),('2020-02-29'),('2020-03-01'),('2020-03-07'),('2020-03-08'),('2020-03-14'),('2020-03-15'),('2020-03-21'),('2020-03-22'),('2020-03-23'),('2020-03-28'),('2020-03-29'),('2020-04-04'),('2020-04-05'),('2020-04-09'),('2020-04-10'),('2020-04-11'),('2020-04-12'),('2020-04-18'),('2020-04-19'),('2020-04-25'),('2020-04-26'),('2020-05-01'),('2020-05-02'),('2020-05-03'),('2020-05-09'),('2020-05-10'),('2020-05-16'),('2020-05-17'),('2020-05-23'),('2020-05-24'),('2020-05-25'),('2020-05-30'),('2020-05-31'),('2020-06-06'),('2020-06-07'),('2020-06-13'),('2020-06-14'),('2020-06-15'),('2020-06-20'),('2020-06-21'),('2020-06-22'),('2020-06-27'),('2020-06-28'),('2020-06-29'),('2020-07-04'),('2020-07-05'),('2020-07-11'),('2020-07-12'),('2020-07-18'),('2020-07-19'),('2020-07-20'),('2020-07-25'),('2020-07-26'),('2020-08-01'),('2020-08-02'),('2020-08-07'),('2020-08-08'),('2020-08-09'),('2020-08-15'),('2020-08-16'),('2020-08-17'),('2020-08-22'),('2020-08-23'),('2020-08-29'),('2020-08-30'),('2020-09-05'),('2020-09-06'),('2020-09-12'),('2020-09-13'),('2020-09-19'),('2020-09-20'),('2020-09-26'),('2020-09-27'),('2020-10-03'),('2020-10-04'),('2020-10-10'),('2020-10-11'),('2020-10-15'),('2020-10-17'),('2020-10-18'),('2020-10-24'),('2020-10-25'),('2020-10-31'),('2020-11-01'),('2020-11-02'),('2020-11-07'),('2020-11-08'),('2020-11-14'),('2020-11-15'),('2020-11-16'),('2020-11-21'),('2020-11-22'),('2020-11-28'),('2020-11-29'),('2020-12-05'),('2020-12-06'),('2020-12-08'),('2020-12-12'),('2020-12-13'),('2020-12-19'),('2020-12-20'),('2020-12-25'),('2020-12-26'),('2020-12-27'),('2021-01-01'),('2021-01-02'),('2021-01-03'),('2021-01-09'),('2021-01-10'),('2021-01-11'),('2021-01-16'),('2021-01-17'),('2021-01-23'),('2021-01-24'),('2021-01-30'),('2021-01-31'),('2021-02-06'),('2021-02-07'),('2021-02-13'),('2021-02-14'),('2021-02-20'),('2021-02-21'),('2021-02-27'),('2021-02-28'),('2021-03-06'),('2021-03-07'),('2021-03-13'),('2021-03-14'),('2021-03-20'),('2021-03-21'),('2021-03-22'),('2021-03-27'),('2021-03-28'),('2021-04-01'),('2021-04-02'),('2021-04-03'),('2021-04-04'),('2021-04-10'),('2021-04-11'),('2021-04-17'),('2021-04-18'),('2021-04-24'),('2021-04-25'),('2021-05-01'),('2021-05-02'),('2021-05-08'),('2021-05-09'),('2021-05-15'),('2021-05-16'),('2021-05-17'),('2021-05-22'),('2021-05-23'),('2021-05-29'),('2021-05-30'),('2021-06-05'),('2021-06-06'),('2021-06-07'),('2021-06-12'),('2021-06-13'),('2021-06-14'),('2021-06-19'),('2021-06-20'),('2021-06-26'),('2021-06-27'),('2021-07-03'),('2021-07-04'),('2021-07-05'),('2021-07-10'),('2021-07-11'),('2021-07-17'),('2021-07-18'),('2021-07-20'),('2021-07-24'),('2021-07-25'),('2021-07-31'),('2021-08-01'),('2021-08-07'),('2021-08-08'),('2021-08-14'),('2021-08-15'),('2021-08-16'),('2021-08-21'),('2021-08-22'),('2021-08-28'),('2021-08-29'),('2021-09-04'),('2021-09-05'),('2021-09-11'),('2021-09-12'),('2021-09-18'),('2021-09-19'),('2021-09-25'),('2021-09-26'),('2021-10-02'),('2021-10-03'),('2021-10-09'),('2021-10-10'),('2021-10-16'),('2021-10-17'),('2021-10-18'),('2021-10-23'),('2021-10-24'),('2021-10-30'),('2021-10-31'),('2021-11-01'),('2021-11-06'),('2021-11-07'),('2021-11-13'),('2021-11-14'),('2021-11-15'),('2021-11-20'),('2021-11-21'),('2021-11-27'),('2021-11-28'),('2021-12-04'),('2021-12-05'),('2021-12-08'),('2021-12-11'),('2021-12-12'),('2021-12-18'),('2021-12-19'),('2021-12-25'),('2021-12-26'),('2022-01-01'),('2022-01-02'),('2022-01-08'),('2022-01-09'),('2022-01-10'),('2022-01-15'),('2022-01-16'),('2022-01-22'),('2022-01-23'),('2022-01-29'),('2022-01-30'),('2022-02-05'),('2022-02-06'),('2022-02-12'),('2022-02-13'),('2022-02-19'),('2022-02-20'),('2022-02-26'),('2022-02-27'),('2022-03-05'),('2022-03-06'),('2022-03-12'),('2022-03-13'),('2022-03-19'),('2022-03-20'),('2022-03-21'),('2022-03-26'),('2022-03-27'),('2022-04-02'),('2022-04-03'),('2022-04-09'),('2022-04-10'),('2022-04-15'),('2022-04-16'),('2022-04-17'),('2022-04-23'),('2022-04-24'),('2022-04-30'),('2022-05-01'),('2022-05-07'),('2022-05-08'),('2022-05-14'),('2022-05-15'),('2022-05-21'),('2022-05-22'),('2022-05-28'),('2022-05-29'),('2022-05-30'),('2022-06-04'),('2022-06-05'),('2022-06-11'),('2022-06-12'),('2022-06-18'),('2022-06-19'),('2022-06-20'),('2022-06-25'),('2022-06-26'),('2022-06-27'),('2022-07-02'),('2022-07-03'),('2022-07-04'),('2022-07-09'),('2022-07-10'),('2022-07-16'),('2022-07-17'),('2022-07-20'),('2022-07-23'),('2022-07-24'),('2022-07-30'),('2022-07-31'),('2022-08-06'),('2022-08-07'),('2022-08-13'),('2022-08-14'),('2022-08-15'),('2022-08-17'),('2022-08-20'),('2022-08-21'),('2022-08-27'),('2022-08-28'),('2022-09-03'),('2022-09-04'),('2022-09-07'),('2022-09-10'),('2022-09-11'),('2022-09-14'),('2022-09-17'),('2022-09-18'),('2022-09-24'),('2022-09-25'),('2022-10-01'),('2022-10-02'),('2022-10-08'),('2022-10-09'),('2022-10-15'),('2022-10-16'),('2022-10-22'),('2022-10-23'),('2022-10-29'),('2022-10-30'),('2022-11-05'),('2022-11-06'),('2022-11-12'),('2022-11-13'),('2022-11-19'),('2022-11-20'),('2022-11-26'),('2022-11-27'),('2022-12-03'),('2022-12-04'),('2022-12-08'),('2022-12-10'),('2022-12-11'),('2022-12-17'),('2022-12-18'),('2022-12-24'),('2022-12-25'),('2022-12-31'),('2023-01-01'),('2023-01-07'),('2023-01-08'),('2023-01-09'),('2023-01-14'),('2023-01-15'),('2023-01-21'),('2023-01-22'),('2023-01-28'),('2023-01-29'),('2023-02-04'),('2023-02-05'),('2023-02-11'),('2023-02-12'),('2023-02-18'),('2023-02-19'),('2023-02-25'),('2023-02-26'),('2023-03-04'),('2023-03-05'),('2023-03-11'),('2023-03-12'),('2023-03-18'),('2023-03-19'),('2023-03-20'),('2023-03-25'),('2023-03-26'),('2023-04-01'),('2023-04-02'),('2023-04-06'),('2023-04-07'),('2023-04-08'),('2023-04-09'),('2023-04-15'),('2023-04-16'),('2023-04-22'),('2023-04-23'),('2023-04-29'),('2023-04-30'),('2023-05-01'),('2023-05-06'),('2023-05-07'),('2023-05-13'),('2023-05-14'),('2023-05-20'),('2023-05-21'),('2023-05-22'),('2023-05-27'),('2023-05-28'),('2023-06-03'),('2023-06-04'),('2023-06-10'),('2023-06-11'),('2023-06-12'),('2023-06-17'),('2023-06-18'),('2023-06-19'),('2023-06-24'),('2023-06-25'),('2023-07-01'),('2023-07-02'),('2023-07-03'),('2023-07-08'),('2023-07-09'),('2023-07-15'),('2023-07-16'),('2023-07-20'),('2023-07-22'),('2023-07-23'),('2023-07-29'),('2023-07-30'),('2023-08-05'),('2023-08-06'),('2023-08-07'),('2023-08-12'),('2023-08-13'),('2023-08-19'),('2023-08-20'),('2023-08-21'),('2023-08-26'),('2023-08-27'),('2023-09-02'),('2023-09-03'),('2023-09-09'),('2023-09-10'),('2023-09-16'),('2023-09-17'),('2023-09-23'),('2023-09-24'),('2023-09-30'),('2023-10-01'),('2023-10-07'),('2023-10-08'),('2023-10-14'),('2023-10-15'),('2023-10-16'),('2023-10-21'),('2023-10-22'),('2023-10-28'),('2023-10-29'),('2023-11-04'),('2023-11-05'),('2023-11-06'),('2023-11-11'),('2023-11-12'),('2023-11-13'),('2023-11-18'),('2023-11-19'),('2023-11-25'),('2023-11-26'),('2023-12-02'),('2023-12-03'),('2023-12-08'),('2023-12-09'),('2023-12-10'),('2023-12-16'),('2023-12-17'),('2023-12-23'),('2023-12-24'),('2023-12-25'),('2023-12-30'),('2023-12-31'),('2024-01-01'),('2024-01-06'),('2024-01-07'),('2024-01-08'),('2024-01-13'),('2024-01-14'),('2024-01-20'),('2024-01-21'),('2024-01-27'),('2024-01-28'),('2024-02-03'),('2024-02-04'),('2024-02-10'),('2024-02-11'),('2024-02-17'),('2024-02-18'),('2024-02-24'),('2024-02-25'),('2024-03-02'),('2024-03-03'),('2024-03-09'),('2024-03-10'),('2024-03-16'),('2024-03-17'),('2024-03-23'),('2024-03-24'),('2024-03-25'),('2024-03-28'),('2024-03-29'),('2024-03-30'),('2024-03-31'),('2024-04-06'),('2024-04-07'),('2024-04-13'),('2024-04-14'),('2024-04-20'),('2024-04-21'),('2024-04-27'),('2024-04-28'),('2024-05-01'),('2024-05-04'),('2024-05-05'),('2024-05-11'),('2024-05-12'),('2024-05-13'),('2024-05-18'),('2024-05-19'),('2024-05-25'),('2024-05-26'),('2024-06-01'),('2024-06-02'),('2024-06-03'),('2024-06-08'),('2024-06-09'),('2024-06-10'),('2024-06-15'),('2024-06-16'),('2024-06-22'),('2024-06-23'),('2024-06-29'),('2024-06-30'),('2024-07-01'),('2024-07-06'),('2024-07-07'),('2024-07-13'),('2024-07-14'),('2024-07-20'),('2024-07-21'),('2024-07-27'),('2024-07-28'),('2024-08-03'),('2024-08-04'),('2024-08-07'),('2024-08-10'),('2024-08-11'),('2024-08-17'),('2024-08-18'),('2024-08-19'),('2024-08-24'),('2024-08-25'),('2024-08-31'),('2024-09-01'),('2024-09-07'),('2024-09-08'),('2024-09-14'),('2024-09-15'),('2024-09-21'),('2024-09-22'),('2024-09-28'),('2024-09-29'),('2024-10-05'),('2024-10-06'),('2024-10-12'),('2024-10-13'),('2024-10-14'),('2024-10-19'),('2024-10-20'),('2024-10-26'),('2024-10-27'),('2024-11-02'),('2024-11-03'),('2024-11-04'),('2024-11-09'),('2024-11-10'),('2024-11-11'),('2024-11-16'),('2024-11-17'),('2024-11-23'),('2024-11-24'),('2024-11-30'),('2024-12-01'),('2024-12-07'),('2024-12-08'),('2024-12-14'),('2024-12-15'),('2024-12-21'),('2024-12-22'),('2024-12-25'),('2024-12-28'),('2024-12-29'),('2025-01-01'),('2025-01-04'),('2025-01-05'),('2025-01-06'),('2025-01-11'),('2025-01-12'),('2025-01-18'),('2025-01-19'),('2025-01-25'),('2025-01-26'),('2025-02-01'),('2025-02-02'),('2025-02-08'),('2025-02-09'),('2025-02-15'),('2025-02-16'),('2025-02-22'),('2025-02-23'),('2025-03-01'),('2025-03-02'),('2025-03-08'),('2025-03-09'),('2025-03-15'),('2025-03-16'),('2025-03-22'),('2025-03-23'),('2025-03-24'),('2025-03-29'),('2025-03-30'),('2025-04-05'),('2025-04-06'),('2025-04-12'),('2025-04-13'),('2025-04-17'),('2025-04-18'),('2025-04-19'),('2025-04-20'),('2025-04-26'),('2025-04-27'),('2025-05-01'),('2025-05-03'),('2025-05-04'),('2025-05-10'),('2025-05-11'),('2025-05-17'),('2025-05-18'),('2025-05-24'),('2025-05-25'),('2025-05-31'),('2025-06-01'),('2025-06-02'),('2025-06-07'),('2025-06-08'),('2025-06-14'),('2025-06-15'),('2025-06-21'),('2025-06-22'),('2025-06-23'),('2025-06-28'),('2025-06-29'),('2025-06-30'),('2025-07-05'),('2025-07-06'),('2025-07-12'),('2025-07-13'),('2025-07-19'),('2025-07-20'),('2025-07-26'),('2025-07-27'),('2025-08-02'),('2025-08-03'),('2025-08-07'),('2025-08-09'),('2025-08-10'),('2025-08-16'),('2025-08-17'),('2025-08-23'),('2025-08-24'),('2025-08-30'),('2025-08-31'),('2025-09-06'),('2025-09-07'),('2025-09-13'),('2025-09-14'),('2025-09-20'),('2025-09-21'),('2025-09-27'),('2025-09-28'),('2025-10-04'),('2025-10-05'),('2025-10-11'),('2025-10-12'),('2025-10-13'),('2025-10-18'),('2025-10-19'),('2025-10-25'),('2025-10-26'),('2025-11-01'),('2025-11-02'),('2025-11-03'),('2025-11-08'),('2025-11-09'),('2025-11-15'),('2025-11-16'),('2025-11-17'),('2025-11-22'),('2025-11-23'),('2025-11-29'),('2025-11-30'),('2025-12-06'),('2025-12-07'),('2025-12-08'),('2025-12-13'),('2025-12-14'),('2025-12-20'),('2025-12-21'),('2025-12-25'),('2025-12-27'),('2025-12-28'),('2026-01-01'),('2026-01-03'),('2026-01-04'),('2026-01-10'),('2026-01-11'),('2026-01-12'),('2026-01-17'),('2026-01-18'),('2026-01-24'),('2026-01-25'),('2026-01-31'),('2026-02-01'),('2026-02-07'),('2026-02-08'),('2026-02-14'),('2026-02-15'),('2026-02-21'),('2026-02-22'),('2026-02-28'),('2026-03-01'),('2026-03-07'),('2026-03-08'),('2026-03-14'),('2026-03-15'),('2026-03-21'),('2026-03-22'),('2026-03-28'),('2026-03-29'),('2026-04-02'),('2026-04-03'),('2026-04-04'),('2026-04-05'),('2026-04-11'),('2026-04-12'),('2026-04-18'),('2026-04-19'),('2026-04-25'),('2026-04-26'),('2026-05-01'),('2026-05-02'),('2026-05-03'),('2026-05-09'),('2026-05-10'),('2026-05-16'),('2026-05-17'),('2026-05-18'),('2026-05-23'),('2026-05-24'),('2026-05-30'),('2026-05-31'),('2026-06-06'),('2026-06-07'),('2026-06-08'),('2026-06-13'),('2026-06-14'),('2026-06-16'),('2026-06-20'),('2026-06-21'),('2026-06-27'),('2026-06-28'),('2026-06-29'),('2026-07-04'),('2026-07-05'),('2026-07-11'),('2026-07-12'),('2026-07-18'),('2026-07-19'),('2026-07-20'),('2026-07-25'),('2026-07-26'),('2026-08-01'),('2026-08-02'),('2026-08-07'),('2026-08-08'),('2026-08-09'),('2026-08-15'),('2026-08-16'),('2026-08-17'),('2026-08-22'),('2026-08-23'),('2026-08-29'),('2026-08-30'),('2026-09-05'),('2026-09-06'),('2026-09-12'),('2026-09-13'),('2026-09-19'),('2026-09-20'),('2026-09-26'),('2026-09-27'),('2026-10-03'),('2026-10-04'),('2026-10-10'),('2026-10-11'),('2026-10-12'),('2026-10-17'),('2026-10-18'),('2026-10-24'),('2026-10-25'),('2026-10-31'),('2026-11-01'),('2026-11-02'),('2026-11-07'),('2026-11-08'),('2026-11-14'),('2026-11-15'),('2026-11-16'),('2026-11-21'),('2026-11-22'),('2026-11-28'),('2026-11-29'),('2026-12-05'),('2026-12-06'),('2026-12-08'),('2026-12-12'),('2026-12-13'),('2026-12-19'),('2026-12-20'),('2026-12-25'),('2026-12-26'),('2026-12-27');
/*!40000 ALTER TABLE `festivos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `observaciones`
--

DROP TABLE IF EXISTS `observaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `observaciones` (
  `ob_numero` int(9) NOT NULL,
  `ob_origen` char(1) NOT NULL,
  `ob_detalle` text,
  PRIMARY KEY (`ob_numero`,`ob_origen`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `observaciones`
--

LOCK TABLES `observaciones` WRITE;
/*!40000 ALTER TABLE `observaciones` DISABLE KEYS */;
INSERT INTO `observaciones` (`ob_numero`, `ob_origen`, `ob_detalle`) VALUES (1,'I',' DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO VEREDA LIMONCITOS VIA MANUELES MUNICIPIO DE RICAURTE LOTE MATRICULA 307-8955'),(1,'E','   DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO VEREDA LIMONCITOS VIA MANUELES MUNICIPIO DE RICAURTE LOTE MATRICULA 307-8955 '),(2,'E',' prueba'),(2,'I','DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO VEREDA LIMONCITOS VIA MANUELES MUNICIPIO DE RICAURTE LOTE MATRICULA 307-8955  '),(3,'I',' INFORME DE CONSULTORIA No 5'),(4,'I',' INFORME DE CONSULTORIA No 5'),(5,'I',' INFORME DE INTERVENTORIA No 04'),(6,'I',' RESPUESTA A COMUNICADO RADICADO EL 12 DE OCTUBRE DE 2022 SANR-2022-000940'),(7,'I',' FACTURAS DE VENTA OCTUBRE'),(8,'I',' '),(9,'I',' CONTESTACION RAD A.S.A.S.E.S.P.319-2022 ENTREGA DE PLANOS'),(10,'I',' respuesta oficio rad No 4256 convenio interadministrativo No 009-2021'),(11,'I',' INFORMACION VISITA TECNICA DE SEGUIMIENTO AL PSMV DEL AREA URBANA EL DIA 21 DE NOVIEMBRE'),(12,'I',' SOLICITUD Y PAGO LIQUIDACION'),(13,'I',' SOLICITUD CERTIFICADO DISPONIBILIDAD'),(14,'I',' SOLICITUD ESTUDIO DE FACTIBILIDAD'),(15,'I',' CUENTAS RECIPROCAS '),(16,'I',' notificacion personal medio electronico auto dram No 01457 de 2022 expediente 38074'),(17,'I',' SOLICITUD ME INFORME CUAL ES EL VALOR DE LOS GASTOS DE REPRESENTACION QUE TENIA COMO GERENTE DE LA EMPRESA Y EL SALARIO A 29 DE AGOSTO DE 2022'),(18,'I',' INVITACION A REUNION ORDINARIA DE COMITE DE SEGUIMIENTO CONTROL CORDINACION Y CUMPLIMIENTO CAR'),(19,'I','  SOLICITUD DE PLAZO PARA EL PAGO QUE TENGO PENDIENTE CON LA EMPRESA'),(20,'I','  SOLCITAN CUALES SON LAS CONDICIONES DE SERVICIO Y EL ESTADO TECNICO DE LAS REDES DE ALCANTARILLADO'),(21,'I',' RADICACION DE DOCUMENTOS PARA LA CONEXION DEL SERVICIO DE ALCANTARILLADO '),(22,'I',' xxx'),(23,'I',' FACTURA FEV887'),(24,'I',' SE HACE CORRESPONDENCIA DE PRUEBA'),(25,'I',' solicitud de actualizacion de disponibilidad'),(26,'I','  informe tecnico de seguimiento a los asuntos ambientales concertados en el EOT municipal'),(27,'I',' DISEÑO DE RED DE DESCOLE COLECTOR AGUAS LLUVIAS'),(28,'I',' ACTAS DE VECINDAD ESPECIFICAS'),(29,'I','  RADICACION DOCUMENTACION REDES GENERALES DE AGUAS LLUVIAS Y AGUAS NEGRAS PROYECTO CAMPO ALEGRE'),(30,'I',' Prueba Prueba Prueba Prueba Prueba Prueba Prueba'),(31,'I','Omision de planos radicados ante ustedes el dia 02/11/2022');
/*!40000 ALTER TABLE `observaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permisos`
--

DROP TABLE IF EXISTS `permisos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permisos` (
  `pe_codpro` int(11) NOT NULL DEFAULT '0',
  `pe_codemp` char(12) NOT NULL DEFAULT '',
  PRIMARY KEY (`pe_codpro`,`pe_codemp`),
  KEY `pe_codpro` (`pe_codpro`),
  KEY `pe_codemp` (`pe_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permisos`
--

LOCK TABLES `permisos` WRITE;
/*!40000 ALTER TABLE `permisos` DISABLE KEYS */;
/*!40000 ALTER TABLE `permisos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `responsable`
--

DROP TABLE IF EXISTS `responsable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsable` (
  `re_codres` char(12) NOT NULL,
  `re_nombre` char(40) DEFAULT NULL,
  `re_cargo` char(40) DEFAULT NULL,
  `re_correo` varchar(100) NOT NULL,
  PRIMARY KEY (`re_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsable`
--

LOCK TABLES `responsable` WRITE;
/*!40000 ALTER TABLE `responsable` DISABLE KEYS */;
INSERT INTO `responsable` (`re_codres`, `re_nombre`, `re_cargo`, `re_correo`) VALUES ('39574392','MARTHA ISABEL CESPEDES CALDERON','TALENTO HUMANO','talentohumano@alcari-ricaurte-cundinamarca.gov.co'),('1069175333','XIMENA HERNANDEZ CUELLAR','AUXILIAR ADMINISTRATIVO','contactenos@alcari-ricaurte-cundinamarca.gov.co'),('1069174879','YEIMI PAULINA ,MENDOZA PERDOMO','GERENTE','alcarisasesp@gmail.com'),('39581254','ANYELA TATIANA ORTIZ SERNA','TECNICO ADMINISTRATIVO','archivo@alcari-ricaurte-cundinamarca.gov.co'),('1069179182','DIEGO ANDRES QUIMBAYO','FINANCIERAY TESORERIA','quimbayod965@gmail.com'),('1069179327','DIEGO ANDRES AVILA PERDOMO','INGENIERO DE SISTEMAS','diegoan1306@hotmail.com'),('11299784','CIRO MURILLO GUZMAN','ALMACEN','ciromurillo06@hotmail.com'),('11224412','RODRIGO ALEXANDER JARAMILLO','CONTROL INTERNO','controlinterno@alcari-ricaurte-cundinamarca.gov.co'),('1069174702','STEFANI CAROLINA OLAYA JIMENEZ','INGENIERA CIVIL','stephanni.olaya@gmail.com'),('65630028','ADRIANA TOVAR','ADM ANTSOFT','ing_adrianatovar@hotmail.com'),('80756968','ALEJANDRO POVEDA','ADM ANTSOFT','luis.povtiz@gmail.com'),('11205476','CLEIBER RODRIGO GARCIA ORTIZ','FINANCIERA Y TESORERIA','financiera@alcari-ricaurte-cundinamarca.gov.co'),('1069179050','CINDY MARCELA SALGUERO DONCEL','TECNICO COMERCIAL','marcela.salguero892@gmail.com '),('1069179321','ANGELA ROCIO AVILA ORTIZ','AD AMBIENTAL','angelaavila635@gmail.com');
/*!40000 ALTER TABLE `responsable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `secuencia`
--

DROP TABLE IF EXISTS `secuencia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `secuencia` (
  `se_tipsec` char(1) NOT NULL,
  `se_descri` char(40) DEFAULT NULL,
  `se_numero` int(9) DEFAULT NULL,
  PRIMARY KEY (`se_tipsec`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `secuencia`
--

LOCK TABLES `secuencia` WRITE;
/*!40000 ALTER TABLE `secuencia` DISABLE KEYS */;
INSERT INTO `secuencia` (`se_tipsec`, `se_descri`, `se_numero`) VALUES ('I','Tramites Ingreso',31),('E','Tramites Envios',0),('T','Tramites Internos',0);
/*!40000 ALTER TABLE `secuencia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sucesos`
--

DROP TABLE IF EXISTS `sucesos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sucesos` (
  `su_numero` int(9) NOT NULL,
  `su_origen` char(1) NOT NULL,
  `su_consec` int(3) NOT NULL,
  `su_fecreg` date NOT NULL DEFAULT '0000-00-00',
  `su_horreg` time NOT NULL DEFAULT '00:00:00',
  `su_codres` char(12) NOT NULL,
  `su_detalle` text,
  `su_usuario` char(12) NOT NULL,
  PRIMARY KEY (`su_numero`,`su_origen`,`su_fecreg`,`su_horreg`),
  KEY `su_numero` (`su_numero`),
  KEY `su_codres` (`su_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sucesos`
--

LOCK TABLES `sucesos` WRITE;
/*!40000 ALTER TABLE `sucesos` DISABLE KEYS */;
INSERT INTO `sucesos` (`su_numero`, `su_origen`, `su_consec`, `su_fecreg`, `su_horreg`, `su_codres`, `su_detalle`, `su_usuario`) VALUES (1,'I',0,'2022-10-24','02:21:43','1069174702','Registro','1069175333'),(1,'E',0,'2022-10-25','09:07:38','1069174702','Registro','asexis'),(1,'I',1,'2022-10-25','09:42:36','asexis','Anulacion de PQR','asexis'),(1,'E',1,'2022-10-25','09:43:45','asexis','Anulacion de PQR','asexis'),(2,'E',0,'2022-10-25','09:44:23','1069174702','Registro','asexis'),(2,'E',1,'2022-10-25','09:48:23','asexis','Anulacion de PQR','asexis'),(2,'I',0,'2022-10-25','10:43:28','1069174702','Registro','asexis'),(3,'I',0,'2022-10-25','02:33:32','1069174702','Registro','1069175333'),(4,'I',0,'2022-10-25','02:33:32','1069174702','Registro','1069175333'),(5,'I',0,'2022-10-26','02:45:31','1069174702','Registro','1069175333'),(6,'I',0,'2022-10-27','05:21:31','1069174702','Registro','1069175333'),(7,'I',0,'2022-10-27','05:41:53','1069174879','Registro','1069175333'),(8,'I',0,'2022-10-31','09:11:47','1069174879','Registro','1069175333'),(9,'I',0,'2022-11-02','04:08:36','1069174702','Registro','1069175333'),(10,'I',0,'2022-11-02','05:14:22','1069174879','Registro','1069175333'),(11,'I',0,'2022-11-03','03:58:07','1069174702','Registro','1069175333'),(12,'I',0,'2022-11-03','04:17:42','1069174879','Registro','1069175333'),(13,'I',0,'2022-11-03','05:02:45','1069174702','Registro','1069175333'),(14,'I',0,'2022-11-03','05:22:37','1069174702','Registro','1069175333'),(15,'I',0,'2022-11-04','04:49:38','1069174879','Registro','1069175333'),(16,'I',0,'2022-11-09','03:54:41','1069174879','Registro','1069175333'),(17,'I',0,'2022-11-09','04:09:48','1069174879','Registro','1069175333'),(18,'I',0,'2022-11-09','04:18:52','1069174702','Registro','1069175333'),(19,'I',0,'2022-11-16','09:23:40','39574392','Registro','1069175333'),(20,'I',0,'2022-11-16','09:43:18','1069174702','Registro','1069175333'),(21,'I',0,'2022-11-16','11:51:52','39581254','Registro','39581254'),(22,'I',0,'2022-11-17','07:26:44','65630028','Registro','asexis'),(22,'I',1,'2022-11-18','12:24:34','asexis','Anulacion de PQR','asexis'),(23,'I',0,'2022-11-18','02:43:18','1069174879','Registro','1069175333'),(24,'I',0,'2022-11-21','09:32:49','1069179327','Registro','1069175333'),(24,'I',1,'2022-11-21','10:06:31','1069179327','se confirma recibido de correspondencia POR EL INGENIERO DIEGO AVILA ','1069179327'),(25,'I',0,'2022-11-24','05:25:02','1069174702','Registro','1069175333'),(26,'I',0,'2022-11-24','05:29:31','1069179321','Registro','1069175333'),(27,'I',0,'2022-11-29','04:11:04','1069174702','Registro','1069175333'),(28,'I',0,'2022-11-29','04:27:27','1069174702','Registro','1069175333'),(29,'I',0,'2022-11-29','04:39:44','1069174702','Registro','1069175333'),(30,'I',0,'2022-12-01','04:41:07','80756968','Registro','asexis'),(30,'I',1,'2022-12-01','04:49:26','80756968','prueba ','asexis'),(30,'I',2,'2022-12-01','05:18:35','65630028','ok','asexis'),(30,'I',3,'2022-12-06','02:49:58','80756968','se calificacorrespondencia de prueba.','asexis'),(2,'I',1,'2022-12-16','08:10:22','1069175333','se le entrega la correspondencia a STEFANI CAROLINA OLAYA JIMENEZ','asexis'),(3,'I',1,'2022-12-16','08:12:48','1069174702','se le entrega correspondencia a STEFANI CAROLINA OLAYA JIMENEZ, INFORME DE CONSULTORIA No 5','asexis'),(5,'I',1,'2022-12-16','08:29:01','1069174702','SE LE HACE ENTREGA DE LA CORRESPONDENCIA A STEFANI CAROLINA OLAYA JIMENES,   INFORME DE INTERVENTORIA No 04 ','asexis'),(4,'I',1,'2022-12-16','08:32:15','1069175333','SE LE HACE ENTREGA DE LA CORRESPONDENCIA A STEFANI CAROLINA OLAYA JIMENES,   INFORME DE INTERVENTORIA No 04 ','asexis'),(5,'I',2,'2022-12-16','08:35:40','1069175333','SE LE HACE ENTREGA DE LA CORRESPONDENCIA A STEFANI CAROLINA OLAYA JIMENES,   INFORME DE INTERVENTORIA No 04 ','asexis'),(31,'I',0,'2022-12-29','10:16:27','1069174702','Registro','1069175333');
/*!40000 ALTER TABLE `sucesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempocar`
--

DROP TABLE IF EXISTS `tempocar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tempocar` (
  `codemp` char(12) NOT NULL DEFAULT '',
  `directorio` char(40) NOT NULL DEFAULT '',
  PRIMARY KEY (`codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tempocar`
--

LOCK TABLES `tempocar` WRITE;
/*!40000 ALTER TABLE `tempocar` DISABLE KEYS */;
INSERT INTO `tempocar` (`codemp`, `directorio`) VALUES ('1069175333','../reportes/I/31/'),('asexis','../reportes/I/30/'),('39581254','../reportes/I/21/'),('1069179327','../reportes/I/24/');
/*!40000 ALTER TABLE `tempocar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tidano`
--

DROP TABLE IF EXISTS `tidano`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tidano` (
  `td_tidano` char(4) NOT NULL,
  `td_descri` char(40) DEFAULT NULL,
  PRIMARY KEY (`td_tidano`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tidano`
--

LOCK TABLES `tidano` WRITE;
/*!40000 ALTER TABLE `tidano` DISABLE KEYS */;
INSERT INTO `tidano` (`td_tidano`, `td_descri`) VALUES ('1','Comunicaciones'),('2','Derechos de Peticiones'),('3','Solicitudes De Disponibilidad'),('4','Recursos'),('5','Facturas'),('6','Citacion'),('7','Circulares'),('8','Tutelas'),('9','Acciones Populares'),('10','Actos Administrativos'),('11','Informes'),('12','Visitas'),('13','Auditorias'),('14','Certificaciones'),('15','Viabilidad del Servicio'),('16','Invitaciones'),('17','Entrega de Documentos'),('18','SOLICITUD');
/*!40000 ALTER TABLE `tidano` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tramites`
--

DROP TABLE IF EXISTS `tramites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tramites` (
  `tm_numero` int(9) NOT NULL,
  `tm_codare` int(3) NOT NULL,
  `tm_tidano` char(4) NOT NULL,
  `tm_fecreg` date DEFAULT NULL,
  `tm_horreg` time NOT NULL DEFAULT '00:00:00',
  `tm_codres` char(12) NOT NULL,
  `tm_codcli` char(12) NOT NULL,
  `tm_asunto` text NOT NULL,
  `tm_refere` text NOT NULL,
  `tm_numdoc` varchar(25) NOT NULL,
  `tm_fecdoc` date DEFAULT NULL,
  `tm_nomsol` char(50) NOT NULL,
  `tm_celsol` char(50) NOT NULL,
  `tm_estado` char(1) NOT NULL,
  `tm_califi` char(1) DEFAULT NULL,
  `tm_feccon` date DEFAULT NULL,
  `tm_horcon` time NOT NULL DEFAULT '00:00:00',
  `tm_origen` char(1) NOT NULL,
  `tm_folios` varchar(5) NOT NULL,
  `tm_codres1` varchar(12) NOT NULL,
  `tm_codres2` varchar(12) NOT NULL,
  `tm_codres3` varchar(12) NOT NULL,
  `tm_codres4` varchar(12) NOT NULL,
  PRIMARY KEY (`tm_numero`,`tm_origen`),
  KEY `tm_tidano` (`tm_tidano`),
  KEY `tm_codcli` (`tm_codcli`),
  KEY `tm_codare` (`tm_codare`),
  KEY `tm_codres` (`tm_codres`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tramites`
--

LOCK TABLES `tramites` WRITE;
/*!40000 ALTER TABLE `tramites` DISABLE KEYS */;
INSERT INTO `tramites` (`tm_numero`, `tm_codare`, `tm_tidano`, `tm_fecreg`, `tm_horreg`, `tm_codres`, `tm_codcli`, `tm_asunto`, `tm_refere`, `tm_numdoc`, `tm_fecdoc`, `tm_nomsol`, `tm_celsol`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_origen`, `tm_folios`, `tm_codres1`, `tm_codres2`, `tm_codres3`, `tm_codres4`) VALUES (1,8,'3','2022-10-24','02:21:43','1069174702','9015111787-9',' DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO',' 9015111787-9','9015111787-9','2022-10-24','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','A','','0000-00-00','00:00:00','I','1','','','',''),(1,8,'3','2022-10-25','09:07:38','1069174702','9015111787-9','   DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO  ',' Ref  9015111787-9','  9015111787-9','2022-10-24','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','A','','0000-00-00','00:00:00','E','1','','','',''),(2,8,'3','2022-10-25','09:44:23','1069174702','9015111787-9',' Prueba',' Ref 9015111787-9','  9015111787-9','2022-10-24','LUIS POVEDA','luis.povtiz@gmail.com','C','1','2022-12-16','08:10:57','E','2','','','',''),(2,8,'3','2022-10-25','10:43:28','1069174702','9015111787-9','DISPONIBILIDAD DE SERVICIOS PUBLICOS DE ALCANTARILLADO  ','ref 9015111787-9','9015111787-9','2022-10-24','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','C','1','2022-12-16','08:10:57','I','2','','','',''),(3,8,'11','2022-10-25','02:33:32','1069174702','900639486-4',' informe de consultoria No 5',' entrega informe No 5','900639486-4','2022-10-25','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','C','1','2022-12-16','08:14:18','I','','','','',''),(4,8,'11','2022-10-25','02:33:32','1069174702','900639486-4',' informe de consultoria No 5',' entrega informe No 5','900639486-4','2022-10-25','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','C','1','2022-12-16','08:32:25','I','','','','',''),(5,8,'11','2022-10-26','02:45:31','1069174702','900639486-4',' informe No 4',' INFORME','','2022-10-26','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','C','1','2022-12-16','08:35:50','I','','','','',''),(6,6,'11','2022-10-27','05:21:31','1069174702','890600003-6',' RESPUESTA A COMUNICADO',' ','890600003-6','2022-10-27','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','1','','','',''),(7,6,'5','2022-10-27','05:41:53','1069174879','890600003-6',' FACTURAS DE VENTA',' FACTURAS','890600003-6','2022-10-27','','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(8,1,'11','2022-10-31','09:11:47','1069174879','1069176320',' CARTA DE RENUNCIA',' CARTA DE RENUNCIA','1069176320','2022-10-31','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(9,8,'17','2022-11-02','04:08:36','1069174702','14248909',' ENTREGA DE PLANOS',' ENTREGA DE PLANOS','14248909','2022-11-02','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(10,1,'11','2022-11-02','05:14:22','1069174879','8906800591',' RESPUESTA OFICIO RAD No 4256 CONVENNIO INTERADMINISTRATIVO No 009-2021',' respuesta oficio','890680059-1','2022-11-02','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(11,3,'12','2022-11-03','03:58:07','1069174702','830022247-8',' VISITA TECNICA PSMV',' VISITA','830022247-8','2022-11-03','XIMENA HERNANDEZ','','P','','0000-00-00','00:00:00','I','','','','',''),(12,1,'11','2022-11-03','04:17:42','1069174879','11304572',' SOLICITUD',' SOLICITUD','11304572','2022-11-03','XIMENA HERNANDEZ','','P','','0000-00-00','00:00:00','I','','','','',''),(13,8,'3','2022-11-03','05:02:45','1069174702','901227165-0',' SOLICITUD CERTIFICADO DE DISPONIBILIDAD',' DISPONIBILIDAD','901227165-0','2022-11-03','XIMENA HERNANDEZ','','P','','0000-00-00','00:00:00','I','','','','',''),(14,8,'3','2022-11-03','05:22:37','1069174702','822000897-1',' SOLICITUD FACTIBILIDAD',' SOLICITUD FACTIBILIDAD','822000897-1','2022-11-03','XIMENA HERNANDEZ','','P','','0000-00-00','00:00:00','I','','','','',''),(15,6,'11','2022-11-04','04:49:38','1069174879','6017428973',' CONCILIAICON CUENTAS RECIPROCAS',' ','6017428973','2022-11-04','XIMENA HERNANDEZ','','P','','0000-00-00','00:00:00','I','','','','',''),(16,1,'11','2022-11-09','03:54:41','1069174879','830022247-8',' notificacion personal',' notificacion personal','830022247-8','2022-11-09','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(17,1,'1','2022-11-09','04:09:48','1069174879','11304572',' SOLICITUD ',' SOLICITUD','11304572','2022-11-09','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(18,8,'6','2022-11-09','04:18:52','1069174702','8906800591',' INVITACION REUNION ORDINARIA ',' INVITACION REUNION ORDINARIA ','890680059-1','2022-11-09','XIMENA HERNANDEZ','ximehkuellar@hotmail.com','P','','0000-00-00','00:00:00','I','','','','',''),(19,19,'18','2022-11-16','09:23:40','39574392','11304572',' SOLICITUD DE PLAZO PARA EL PAGO QUE TENGO PENDIENTE CON LA EMPRESA',' REF: 11304572','11304572','2022-11-16','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(20,8,'3','2022-11-16','09:43:18','1069174702','0',' SOLCITAN CUALES SON LAS CONDICIONES DE SERVICIO Y EL ESTADO TECNICO DE LAS REDES DE ALCANTARILLADO',' REF:0','0','2022-11-16','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(21,8,'3','2022-11-16','11:51:52','39581254','900492453-8',' RADICACION DE REQUISITOS ',' REF:','900.492.455-8','2022-11-16','ANYELA TATIANA ORTIZ SERNA','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(22,5,'7','2022-11-17','07:26:44','65630028','830022247-8',' prueba de correo',' prueba correo','xxx','2022-11-17','xxxx','xxx','A','','0000-00-00','00:00:00','I','','','','',''),(23,6,'5','2022-11-18','02:43:18','1069174879','890600003-6',' FACTURA FEV887',' REF:9','890600003-6','2022-11-18','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(24,9,'11','2022-11-21','09:32:49','1069179327','901227165-0',' prueba',' REF: PRUEBA','901227165-0','2022-11-21','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','C','4','2022-11-21','10:07:28','I','1','','','',''),(25,8,'3','2022-11-24','05:25:02','1069174702','890680059-1',' solicitud de actualizacion de disponibilidad',' ref:1','890680059-1','2022-11-24','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(26,3,'11','2022-11-24','05:29:31','1069179321','830022247-8',' informe tecnico de seguimiento a los asuntos ambientales concertados en el EOT municipal',' ref:8','830022247-8','2022-11-24','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(27,8,'11','2022-11-29','04:11:04','1069174702','2',' DISEÑO DE RED DE DESCOLE COLECTOR AGUAS LLUVIAS','REF:2 ','2','2022-11-29','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(28,8,'11','2022-11-29','04:27:27','1069174702','2','ACTAS DE VECINDAD ESPECIFICAS',' REF:2','2','2022-11-29','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(29,8,'17','2022-11-29','04:39:44','1069174702','3',' RADICACION DOCUMENTACION REDES GENERALES DE AGUAS LLUVIAS Y AGUAS NEGRAS PROYECTO CAMPO ALEGRE',' REF:3','3','2022-11-29','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','',''),(30,13,'3','2022-12-01','04:41:07','80756968','890680059-1',' Prueba ',' Prueba','890680059','2022-12-01','Asexis','luis.povtiz@gmail.com','C','1','2022-12-06','02:51:47','I','','','','',''),(31,8,'18','2022-12-29','10:16:27','1069174702','14248909',' Omision de planos radicados ante ustedes el dia 02/11/2022',' ref:4702','1','2022-12-29','XIMENA HERNANDEZ','contactenos@alcari-ricaurte-cundinamarca.gov.co','P','','0000-00-00','00:00:00','I','','','','','');
/*!40000 ALTER TABLE `tramites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuario`
--

DROP TABLE IF EXISTS `usuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuario` (
  `us_codemp` char(12) NOT NULL DEFAULT '',
  `us_nombre` char(40) NOT NULL DEFAULT '',
  `us_direcc` char(40) NOT NULL DEFAULT '',
  `us_telefo` char(10) NOT NULL DEFAULT '',
  `us_passwd` char(12) NOT NULL DEFAULT '',
  `us_nivelu` char(1) NOT NULL DEFAULT '',
  PRIMARY KEY (`us_codemp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuario`
--

LOCK TABLES `usuario` WRITE;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'antsoftw_ricaurte_unidad'
--

--
-- Dumping routines for database 'antsoftw_ricaurte_unidad'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-06-05  2:30:48
