-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64) -- -- Host: localhost Database: antsoftw_chivolo_operativo -- ------------------------------------------------------ -- 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 `abastecimiento` -- DROP TABLE IF EXISTS `abastecimiento`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `abastecimiento` ( `ab_numero` int(9) NOT NULL DEFAULT '0', `ab_codsis` varchar(20) NOT NULL DEFAULT '', `ab_detsis` varchar(20) NOT NULL DEFAULT '', `ab_fecini` date NOT NULL DEFAULT '0000-00-00', `ab_horini` time NOT NULL DEFAULT '00:00:00', `ab_fecfin` date NOT NULL DEFAULT '0000-00-00', `ab_horfin` time NOT NULL DEFAULT '00:00:00', `ab_lectura` double(12,3) DEFAULT NULL, `ab_observa` text, `ab_fecreg` date NOT NULL, `ab_horreg` time NOT NULL, `ab_usuario` varchar(20) NOT NULL, `ab_tipofte` varchar(20) NOT NULL, `ab_usures` int(9) NOT NULL, `ab_volres` int(9) NOT NULL, `ab_usunres` int(9) NOT NULL, `ab_volnres` int(9) NOT NULL, `ab_valorm3` double(15,2) NOT NULL, PRIMARY KEY (`ab_numero`), KEY `ab_codsis` (`ab_codsis`), KEY `ab_detsis` (`ab_detsis`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `abastecimiento` -- LOCK TABLES `abastecimiento` WRITE; /*!40000 ALTER TABLE `abastecimiento` DISABLE KEYS */; /*!40000 ALTER TABLE `abastecimiento` ENABLE KEYS */; UNLOCK TABLES; -- -- 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 */; /*!40000 ALTER TABLE `accesos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `actividad` -- DROP TABLE IF EXISTS `actividad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actividad` ( `ac_codact` int(11) NOT NULL DEFAULT '0', `ac_descri` char(60) NOT NULL, `ac_tiempo` float(3,2) NOT NULL DEFAULT '0.00', `ac_nroeje` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`ac_codact`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `actividad` -- LOCK TABLES `actividad` WRITE; /*!40000 ALTER TABLE `actividad` DISABLE KEYS */; INSERT INTO `actividad` (`ac_codact`, `ac_descri`, `ac_tiempo`, `ac_nroeje`) VALUES (1,'ACUEDUCTO-CAMBIO DE VENTOSA',1.00,1),(2,'ACUEDUCTO-INSTALACION DOMICILIARIAS',1.00,1),(3,'ACUEDUCTO-INSTALACION MICROMEDIDORES',1.00,1),(4,'ACUEDUCTO-LAVADA DE PLANTA DE TRATAMIENTO',1.00,1),(5,'ACUEDUCTO-LAVADA DE RED DE CONDUCCION',1.00,1),(6,'ACUEDUCTO-LAVADO DE DESAIRADORES',1.00,1),(7,'ACUEDUCTO-LAVADO DE POZOS PROFUNDOS',1.00,1),(8,'ACUEDUCTO-LAVADO Y DESAIRADO RED ADUCCION',1.00,1),(9,'ACUEDUCTO-LECTURA DE MACROS',1.00,1),(10,'ACUEDUCTO-MANTENIMIENTO ESTACIONES DE MACROS',1.00,1),(11,'ACUEDUCTO-MANTENIMIENTO MACRO POZOS',1.00,1),(12,'ACUEDUCTO-MANTENIMIENTO RED DE ADUCCION',1.00,1),(13,'ACUEDUCTO-MANTENIMIENTO TABLERO POZOS',1.00,1),(14,'ACUEDUCTO-REPARACION DE FUGA DOMICILIARIA',1.00,1),(15,'ACUEDUCTO-REPARACION DE FUGA RED MENOR',1.00,1),(16,'ACUEDUCTO-REPOSICION DE MEDIDOR',1.00,1),(17,'ACUEDUCTO-REVISION CONSUMOS ALTOS',1.00,1),(18,'ACUEDUCTO-REVISION INTRADOMICILIARIA',1.00,1),(19,'ACUEDUCTO-REVISION MICROMEDIDORES',1.00,1),(40,'ALCANTARILLADO-CAMBIO TUBERIA ALCANTARILLADO',1.00,1),(41,'ALCANTARILLADO-DESTAPONAMIENTO RED DOMICILIARIO',1.00,1),(42,'ALCANTARILLADO-DESTAPONAMIENTO RED PRINCIPAL',1.00,1),(43,'ALCANTARILLADO-LAVADO RED PRINCIPAL',1.00,1),(50,'ASEO-BARRIDO Y LIMPIEZA',1.00,1),(51,'ASEO-BRIGADAS DE ASEO LOCALIDAD',1.00,1),(52,'ASEO-BRIGADAS ESPECIALES ESCENARIOS DEPORTIVOS',1.00,1),(53,'ASEO-PODA DE ZONAS VERDES',1.00,1),(54,'ASEO-RECOLECCION DE RESIDUOS SOLIDOS',1.00,1),(20,'SUSPENSION O CORTE',1.00,2),(55,'DISPONIBILIDAD DE SERVICIO',1.00,1),(44,'ALCANTARILLADO - REVISION TECNICA',1.00,1),(21,'ACUEDUCTO - REVISION DISPONIBILIDAD SERV',1.00,1),(56,'ACUEDUCTO-INSTALACION DE CHEQUES',1.00,1),(57,'TRASLADO DE ACOMETIDA',1.00,1),(58,'REPARACION DE TAPA POZO DE INSPECCION',1.00,1),(59,'REPOSICION DE PAVIMENTO RIGIDO',1.00,1),(60,'UBICACION DEL MEDIDOR',1.00,1),(63,'INSTALACION DE TUBERIA PARA ACUEDUCTO',9.99,0),(62,'INSTALACION TUBERIA PARA ACUEDUCTO',9.99,1),(64,'ASEO',9.99,0),(65,'Acueducto Reconexion',1.00,1),(66,'fuga de agua potable acomt domic acueduc',1.00,1); /*!40000 ALTER TABLE `actividad` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `actmetraje` -- DROP TABLE IF EXISTS `actmetraje`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actmetraje` ( `am_codres` char(2) NOT NULL, `am_descri` char(40) DEFAULT NULL, `am_valor` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`am_codres`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `actmetraje` -- LOCK TABLES `actmetraje` WRITE; /*!40000 ALTER TABLE `actmetraje` DISABLE KEYS */; INSERT INTO `actmetraje` (`am_codres`, `am_descri`, `am_valor`) VALUES ('1','EXCAVACION EN M3',15899.00),('2','RELLENO DE MATERIAL DE SITIO EN M3',10753.00),('3','RELLENO DE MATERIAL IMPORTADO EN M3',53870.00),('4','DEMOLICION DE ANDEN EN CONCRETO E=10',7050.00),('5','DEMOLICION DE LOZA E=20',16107.00),('6','ANDEN EN CONCRETO 2500 PSI',25350.00),('7','LOZA DE PAVIMENTO E=15',60673.00),('8','RETIRO DE MATERIAL SOBRANTE Y DISPOSICIO',17398.00),('9','CORTADORA CON DISCO',8097.00); /*!40000 ALTER TABLE `actmetraje` 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,'Division Tecnica Operativa'),(2,'Division Operativa Alcantarillado'),(3,'Division Operativa Aseo'),(4,'Acueducto Cortes y Suspensiones'),(5,'Comercial'); /*!40000 ALTER TABLE `area` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `arepre` -- DROP TABLE IF EXISTS `arepre`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `arepre` ( `ap_codare` int(4) NOT NULL, `ap_descri` char(40) DEFAULT NULL, PRIMARY KEY (`ap_codare`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `arepre` -- LOCK TABLES `arepre` WRITE; /*!40000 ALTER TABLE `arepre` DISABLE KEYS */; /*!40000 ALTER TABLE `arepre` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `barrio` -- DROP TABLE IF EXISTS `barrio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `barrio` ( `ba_codbar` int(4) NOT NULL, `ba_descri` char(40) NOT NULL, PRIMARY KEY (`ba_codbar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `barrio` -- LOCK TABLES `barrio` WRITE; /*!40000 ALTER TABLE `barrio` DISABLE KEYS */; INSERT INTO `barrio` (`ba_codbar`, `ba_descri`) VALUES (1,'CHIVOLO'),(2,'CHIBOLON'),(3,'SANTA CATALINA'),(4,'CALLE CENTRAL'),(5,'RINCON'),(6,'20 DE JULIO'),(7,'SAN JUAN BOSCO'),(8,'ALTOPRADO'),(9,'LA FRANCISCANA'),(10,'VILLA LILI'),(11,'EL PROGRESO'),(12,'VILLA ESPERANZA'),(13,'VILLA MAFE'),(14,'CON DIOS Y EL PUEBLO'),(15,'23 DE ABRIL'),(16,'LOS MANGOS'),(17,'EL TIBURON'),(18,'JUAQUIN ANAYA'),(21,'LA ESTRELLA CALLE CENTRAL'),(31,'LA CHINA - CALLE LA PINIUELA'),(32,'LA CHINA - CALLE CENTRAL'),(33,'LA CHINA - CALLE EL CASCARON'),(34,'LA CHINA - VILLA GARCIA'),(35,'LA CHINA - AVENIDA LOS ESTUDIANTES'),(36,'LA CHINA - CALLE LOS OLIVOS'),(22,'LA ESTRELLA BARRIO CHINO'),(23,'LA ESTRELLA CALLE LA AVENIDA'),(24,'LA ESTRELLA BARRIO SION'); /*!40000 ALTER TABLE `barrio` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calidadagua` -- DROP TABLE IF EXISTS `calidadagua`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calidadagua` ( `cag_numero` int(9) NOT NULL, `cag_fecini` date DEFAULT NULL, `cag_horini` time DEFAULT NULL, `cag_fecfin` date DEFAULT NULL, `cag_horfin` time DEFAULT NULL, `cag_punto` varchar(20) NOT NULL, `cag_laboratorio` varchar(10) NOT NULL, `cag_tipmue` char(10) NOT NULL, `cag_clamue` char(30) NOT NULL, `cag_color` varchar(15) NOT NULL, `cag_turbiedad` varchar(15) NOT NULL, `cag_ph` varchar(15) NOT NULL, `cag_clores` varchar(15) NOT NULL, `cag_dureza` varchar(15) NOT NULL, `cag_cloruros` varchar(15) NOT NULL, `cag_alcalinidad` varchar(15) NOT NULL, `cag_coliformes` varchar(15) NOT NULL, `cag_tecnica` char(30) NOT NULL, `cag_escher` varchar(15) NOT NULL, `cag_tecnicae` char(30) NOT NULL, `cag_irca` varchar(15) NOT NULL, `cag_muestra` varchar(12) NOT NULL, `cag_hierro` varchar(15) NOT NULL, PRIMARY KEY (`cag_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calidadagua` -- LOCK TABLES `calidadagua` WRITE; /*!40000 ALTER TABLE `calidadagua` DISABLE KEYS */; /*!40000 ALTER TABLE `calidadagua` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calidadaguaes` -- DROP TABLE IF EXISTS `calidadaguaes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calidadaguaes` ( `cag_numero` int(9) NOT NULL, `cag_fecini` date DEFAULT NULL, `cag_horini` time DEFAULT NULL, `cag_fecfin` date DEFAULT NULL, `cag_horfin` time DEFAULT NULL, `cag_punto` varchar(20) NOT NULL, `cag_laboratorio` varchar(10) NOT NULL, `cag_tipmue` char(10) NOT NULL, `cag_clamue` char(30) NOT NULL, `cag_residual` varchar(15) NOT NULL, `cag_cot` varchar(15) NOT NULL, `cag_nitritos` varchar(15) NOT NULL, `cag_fluoruros` varchar(15) NOT NULL, `cag_giardia` varchar(15) NOT NULL, `cag_crypsto` varchar(15) NOT NULL, `cag_muestra` varchar(12) NOT NULL, PRIMARY KEY (`cag_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calidadaguaes` -- LOCK TABLES `calidadaguaes` WRITE; /*!40000 ALTER TABLE `calidadaguaes` DISABLE KEYS */; /*!40000 ALTER TABLE `calidadaguaes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calidadaguafs` -- DROP TABLE IF EXISTS `calidadaguafs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calidadaguafs` ( `cag_numero` int(9) NOT NULL, `cag_fecini` date DEFAULT NULL, `cag_horini` time DEFAULT NULL, `cag_punto` varchar(15) NOT NULL, `cag_laboratorio` varchar(10) NOT NULL, `cag_tipmue` char(10) NOT NULL, `cag_ph` varchar(15) NOT NULL, `cag_grados` varchar(15) NOT NULL, `cag_solidos` varchar(15) NOT NULL, `cag_micros` varchar(15) NOT NULL, `cag_turbiedad` varchar(15) NOT NULL, `cag_color` varchar(15) NOT NULL, `cag_coliformes` varchar(15) NOT NULL, `cag_escher` varchar(15) NOT NULL, `cag_dbo` varchar(15) NOT NULL, `cag_dqo` varchar(15) NOT NULL, `cag_od` varchar(15) NOT NULL, `cag_sodio` varchar(15) NOT NULL, `cag_cloruros` varchar(15) NOT NULL, `cag_fluoruros` varchar(15) NOT NULL, `cag_hierro` varchar(15) NOT NULL, `cag_manganeso` varchar(15) NOT NULL, `cag_fenoles` varchar(15) NOT NULL, `cag_amoniaco` varchar(15) NOT NULL, `cag_nitritos` varchar(15) NOT NULL, `cag_nitratos` varchar(15) NOT NULL, `cag_dureza` varchar(15) NOT NULL, `cag_cianuros` varchar(15) NOT NULL, `cag_sulfatos` varchar(15) NOT NULL, `cag_fosforos` varchar(15) NOT NULL, `cag_muestra` varchar(12) NOT NULL, PRIMARY KEY (`cag_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calidadaguafs` -- LOCK TABLES `calidadaguafs` WRITE; /*!40000 ALTER TABLE `calidadaguafs` DISABLE KEYS */; /*!40000 ALTER TABLE `calidadaguafs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calidadaguafsb` -- DROP TABLE IF EXISTS `calidadaguafsb`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calidadaguafsb` ( `cag_numero` int(9) NOT NULL, `cag_fecini` date DEFAULT NULL, `cag_horini` time DEFAULT NULL, `cag_punto` varchar(15) NOT NULL, `cag_laboratorio` varchar(10) NOT NULL, `cag_tipmue` char(10) NOT NULL, `cag_ph` varchar(15) NOT NULL, `cag_grados` varchar(15) NOT NULL, `cag_solidos` varchar(15) NOT NULL, `cag_micros` varchar(15) NOT NULL, `cag_turbiedad` varchar(15) NOT NULL, `cag_color` varchar(15) NOT NULL, `cag_coliformes` varchar(15) NOT NULL, `cag_escher` varchar(15) NOT NULL, `cag_dbo` varchar(15) NOT NULL, `cag_dqo` varchar(15) NOT NULL, `cag_od` varchar(15) NOT NULL, `cag_sodio` varchar(15) NOT NULL, `cag_cloruros` varchar(15) NOT NULL, `cag_fluoruros` varchar(15) NOT NULL, `cag_hierro` varchar(15) NOT NULL, `cag_manganeso` varchar(15) NOT NULL, `cag_fenoles` varchar(15) NOT NULL, `cag_amoniaco` varchar(15) NOT NULL, `cag_nitritos` varchar(15) NOT NULL, `cag_nitratos` varchar(15) NOT NULL, `cag_dureza` varchar(15) NOT NULL, `cag_cianuros` varchar(15) NOT NULL, `cag_sulfatos` varchar(15) NOT NULL, `cag_fosforos` varchar(15) NOT NULL, `cag_muestra` varchar(12) NOT NULL, PRIMARY KEY (`cag_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calidadaguafsb` -- LOCK TABLES `calidadaguafsb` WRITE; /*!40000 ALTER TABLE `calidadaguafsb` DISABLE KEYS */; /*!40000 ALTER TABLE `calidadaguafsb` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calidadaguano` -- DROP TABLE IF EXISTS `calidadaguano`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calidadaguano` ( `cag_numero` int(9) NOT NULL, `cag_fecini` date DEFAULT NULL, `cag_horini` time DEFAULT NULL, `cag_fecfin` date DEFAULT NULL, `cag_horfin` time DEFAULT NULL, `cag_punto` varchar(20) NOT NULL, `cag_laboratorio` varchar(10) NOT NULL, `cag_tipmue` char(10) NOT NULL, `cag_clamue` char(30) NOT NULL, `cag_analiz` char(30) NOT NULL, `cag_caracter` char(6) NOT NULL, `cag_valor` varchar(15) NOT NULL, `cag_muestra` varchar(12) NOT NULL, PRIMARY KEY (`cag_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calidadaguano` -- LOCK TABLES `calidadaguano` WRITE; /*!40000 ALTER TABLE `calidadaguano` DISABLE KEYS */; /*!40000 ALTER TABLE `calidadaguano` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `caracter` -- DROP TABLE IF EXISTS `caracter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caracter` ( `cr_codcar` char(6) NOT NULL, `cr_descri` char(60) DEFAULT NULL, PRIMARY KEY (`cr_codcar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `caracter` -- LOCK TABLES `caracter` WRITE; /*!40000 ALTER TABLE `caracter` DISABLE KEYS */; INSERT INTO `caracter` (`cr_codcar`, `cr_descri`) VALUES ('15','Nitritos NO2 -'),('16','Nitratos NO3 -'),('19','Alcalinidad total CaCO3'),('20','Cloruros Cl-'),('21','Aluminio Al'),('23','Manganeso Mn'),('25','Sulfatos SO4 -2'),('51','Oxigeno Disuelto'),('50','Conductividad'),('28','Residual del coagulante *'),('29','Dureza total CaCO3'),('30','Hierro total Fe'),('31','Giardia Quistes'),('32','Cryptosporidium Ooquistes'),('33','Plaguicidas'); /*!40000 ALTER TABLE `caracter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `caracterca` -- DROP TABLE IF EXISTS `caracterca`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `caracterca` ( `cr_codcar` char(6) NOT NULL, `cr_descri` char(60) DEFAULT NULL, PRIMARY KEY (`cr_codcar`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `caracterca` -- LOCK TABLES `caracterca` WRITE; /*!40000 ALTER TABLE `caracterca` DISABLE KEYS */; INSERT INTO `caracterca` (`cr_codcar`, `cr_descri`) VALUES ('1','Antimonio Sb'),('2','Arsenico As'),('3','Bario Ba'),('4','Cadmio Cd'),('5','Cianuro libre y disociable CN-'),('6','Cobre Cu'),('7','Cromo total Cr'),('8','Mercurio Hg'),('9','Niquel Ni'),('10','Plomo Pb'),('11','Selenio Se'),('12','Trihalometanos totales THMs'),('13','Hidrocarburos arom?ticos HAP'),('14','Carbono org?nico total COT'),('15','Nitritos NO2 -'),('16','Nitratos NO3 -'),('17','Fluoruros F-'),('18','Calcio Ca'),('19','Alcalinidad total CaCO3'),('20','Cloruros Cl-'),('21','Aluminio Al'),('22','Magnesio Mg'),('23','Manganeso Mn'),('24','Molibdeno Mo'),('25','Sulfatos SO4 -2'),('26','Zinc Zn'),('27','Fosfatos PO4 -3'),('28','Residual del coagulante *'),('29','Dureza total CaCO3'),('30','Hierro total Fe'),('31','Giardia Quistes'),('32','Cryptosporidium Ooquistes'),('33','Plaguicidas'),('50','Conductividad'),('51','Oxigeno disuelto'); /*!40000 ALTER TABLE `caracterca` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cierres` -- DROP TABLE IF EXISTS `cierres`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cierres` ( `ci_suspen` int(9) NOT NULL, `ci_numero` int(9) DEFAULT NULL, `ci_codsec` int(3) NOT NULL, `ci_tipsus` int(3) NOT NULL, `ci_fecini` date DEFAULT NULL, `ci_horini` time DEFAULT NULL, `ci_fecfin` date DEFAULT NULL, `ci_horfin` time DEFAULT NULL, `ci_tiempo` time NOT NULL DEFAULT '00:00:00', PRIMARY KEY (`ci_suspen`), KEY `ci_numero` (`ci_numero`), KEY `ci_codsec` (`ci_codsec`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cierres` -- LOCK TABLES `cierres` WRITE; /*!40000 ALTER TABLE `cierres` DISABLE KEYS */; /*!40000 ALTER TABLE `cierres` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ciudad` -- DROP TABLE IF EXISTS `ciudad`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ciudad` ( `ci_codciu` varchar(10) NOT NULL DEFAULT '0', `ci_descri` char(40) NOT NULL DEFAULT '', PRIMARY KEY (`ci_codciu`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ciudad` -- LOCK TABLES `ciudad` WRITE; /*!40000 ALTER TABLE `ciudad` DISABLE KEYS */; INSERT INTO `ciudad` (`ci_codciu`, `ci_descri`) VALUES ('47170','CHIBOLO MAGADALENA'); /*!40000 ALTER TABLE `ciudad` 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(40) NOT NULL DEFAULT '', `cl_direcc` char(40) NOT NULL DEFAULT '', `cl_repres` char(40) NOT NULL, `cl_telefo` char(10) NOT NULL DEFAULT '', `cl_porcen` int(2) 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 */; /*!40000 ALTER TABLE `clientes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `compras` -- DROP TABLE IF EXISTS `compras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `compras` ( `co_numero` int(9) NOT NULL, `co_codcli` char(12) NOT NULL DEFAULT '', `co_fecreg` date DEFAULT NULL, `co_horreg` time NOT NULL DEFAULT '00:00:00', `co_vlrtot` int(9) DEFAULT NULL, `co_vlriva` int(9) DEFAULT NULL, `co_apagar` int(9) DEFAULT NULL, `co_estado` char(1) NOT NULL, PRIMARY KEY (`co_numero`), KEY `co_codcli` (`co_codcli`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `compras` -- LOCK TABLES `compras` WRITE; /*!40000 ALTER TABLE `compras` DISABLE KEYS */; /*!40000 ALTER TABLE `compras` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conceptos` -- DROP TABLE IF EXISTS `conceptos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conceptos` ( `cp_codcon` int(4) NOT NULL, `cp_detalle` char(120) NOT NULL, `cp_grupo` int(3) NOT NULL, `cp_tiptari` char(1) NOT NULL, `cp_referen` int(4) NOT NULL, `cp_unidad` char(10) NOT NULL, `cp_vlrcomp` float(9,2) DEFAULT NULL, `cp_vlrvent` float(9,2) DEFAULT NULL, `cp_existen` float(9,2) DEFAULT NULL, `cp_poriva` int(2) DEFAULT NULL, PRIMARY KEY (`cp_codcon`), KEY `cp_grupo` (`cp_grupo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conceptos` -- LOCK TABLES `conceptos` WRITE; /*!40000 ALTER TABLE `conceptos` DISABLE KEYS */; INSERT INTO `conceptos` (`cp_codcon`, `cp_detalle`, `cp_grupo`, `cp_tiptari`, `cp_referen`, `cp_unidad`, `cp_vlrcomp`, `cp_vlrvent`, `cp_existen`, `cp_poriva`) VALUES (100,'CEMENTO',108,'',0,'Valdes',0.00,0.00,0.00,0),(101,'TUBERIA PVC ALCANTARILLADO 10\"',115,'',0,'M.L',0.00,0.00,0.00,0),(102,'TUBERIA PVC ACUEDUCTO 6\"',115,'',0,'M.L',0.00,0.00,0.00,0),(103,'UNION 2 DE REPARACION (MANGON)',115,'',0,'UN',0.00,0.00,0.00,0),(104,'SEMI CURVAS 2\"',0,'',0,'UN',0.00,0.00,0.00,0),(105,'PINTURA ALUMON',0,'',0,'GL',0.00,0.00,0.00,0),(106,'CURVAS 90°',115,'',0,'UN',0.00,0.00,0.00,0),(107,'CONTADOR 1/2',201,'',0,'UN',0.00,0.00,0.00,0),(108,'REGISTRO DE CORTE 1/2',201,'',0,'UN',0.00,0.00,0.00,0),(109,'CODOS 1/2',214,'',0,'UN',0.00,0.00,0.00,0),(110,'MACHOS 1/2',0,'',0,'UN',0.00,0.00,0.00,0),(111,'UNION GIOT HR 3\" HF',201,'',0,'',0.00,0.00,0.00,0),(112,'TUBO PVC 3\" TP',201,'',0,'',0.00,0.00,0.00,0),(113,'UNION GIOT HR 4\" HF',201,'',0,'UN',0.00,0.00,0.00,0),(114,'VALVULA HF 4\"',201,'',0,'UN',0.00,0.00,0.00,0),(115,'UNION REPARACION PVC 4\"',201,'',0,'UN',0.00,0.00,0.00,0),(116,'GEL LUBRICANTE PVC',201,'',0,'LIBRAS',0.00,0.00,0.00,0),(117,'TUBO PVC 4\" TP',201,'',0,'ML',0.00,0.00,0.00,0),(118,'UNION LISA PVC 4\" TP',201,'',0,'UN',0.00,0.00,0.00,0),(119,'SOLDADURA PVC',201,'',0,'ML',0.00,0.00,0.00,0),(120,'LIMPIADOR PVC',201,'',0,'ML',0.00,0.00,0.00,0),(121,'TANQUE PLASTICO 250LT',114,'I',0,'UN',0.00,0.00,0.00,0),(122,'TANQUE 1000 LT',114,'I',0,'UN',0.00,0.00,0.00,0),(123,'TUBO PVC 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(124,'ADAPTADOR MACHO 1\"',201,'',0,'UN',0.00,0.00,0.00,0),(125,'LLAVE DE PASO 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(126,'TUBO PVC 1/2\"',201,'I',0,'',0.00,0.00,0.00,0),(127,'ADAPTADOR MACHO 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(128,'LLAVE DE PASO 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(129,'TEFLON',201,'I',0,'CRR',0.00,0.00,0.00,0),(130,'ALAMBRON GALBANIZADO CALIB 12',201,'',0,'KL',0.00,0.00,0.00,0),(131,'TUBOS PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(132,'CODOS PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(133,'T PVC 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(134,'VALVULA DE PIE 1\"',104,'',0,'UN',0.00,0.00,0.00,0),(135,'Llave Cheque 1\"',201,'',0,'un',0.00,0.00,0.00,0),(136,'Union Universal 1\"',103,'',0,'UN',0.00,0.00,0.00,0),(137,'Union Universal 1/2\"',103,'',0,'UN',0.00,0.00,0.00,0),(138,'T 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(139,'Reduccion 1\"',201,'',0,'',0.00,0.00,0.00,0),(140,'Reduccion 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(141,'Union 1/2\"',201,'',0,'UN',0.00,0.00,0.00,0),(142,'Union PVC 1\"',201,'',0,'UN',0.00,0.00,0.00,0),(143,'ARENA',0,'',0,'CARRETADA',0.00,0.00,0.00,0),(144,'LADRILLO TOLETE',201,'',0,'GRIS',0.00,0.00,0.00,0),(145,'VARILLA CORRUGADA 1/2\"',104,'',0,'UN',0.00,0.00,0.00,0),(146,'VARILLA 9MM',104,'',0,'UN',0.00,0.00,0.00,0),(147,'TRITURADO',104,'',0,'Valdes',0.00,0.00,0.00,0),(148,'ARENA NEGRA',104,'',0,'Valdes',0.00,0.00,0.00,0),(149,'UNION GIBOUT H.F 6\"',104,'I',0,'UN',0.00,0.00,0.00,0),(150,'UNION LISA PVC 6\" PRESION',201,'',0,'UN',0.00,0.00,0.00,0),(151,'TANQUE PLASTICO 2000 LT',201,'I',0,'UN',0.00,0.00,0.00,0),(152,'TACOS AUTAMATICOS 20 AMP',201,'I',0,'UN',0.00,0.00,0.00,0),(153,'CHEQUE TOBULA 1/2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(154,'CHEQUE CORTINA 1/2\"',201,'I',0,'',0.00,0.00,0.00,0),(155,'BUGA PVC 1\" X 1/2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(156,'Tubos sanitarios 4\"',201,'I',0,'TUBO',0.00,0.00,0.00,0),(157,'Uniones Sanitarias 4\"',0,'',0,'UN',0.00,0.00,0.00,0),(158,'Semicodos sanitario 4\"',201,'I',0,'',0.00,0.00,0.00,0),(159,'Tubo Sanitario 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(160,'Codo sanitario 3\"',201,'',0,'UN',0.00,0.00,0.00,0),(161,'semicodo sanitario 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(162,'CONGLOMERADO SECO',104,'I',0,'',0.00,0.00,0.00,0),(163,'SIKASET ( ACELERANTE PARA CONCRETO)',104,'I',0,'KL',0.00,0.00,0.00,0),(164,'Collarin pvc 2\" x 1/2',201,'I',0,'',0.00,0.00,0.00,0),(165,'T PVC 3\" PRESIÓN',104,'',0,'UN',0.00,0.00,0.00,0),(166,'CODO PVC 3\" PRESIÓN',104,'',0,'',0.00,0.00,0.00,0),(167,'UNION REPARACION PVC 3\"',104,'',0,'UN',0.00,0.00,0.00,0),(168,'TUBOS PVC 2\"',104,'I',0,'UN',0.00,0.00,0.00,0),(169,'COLLARIN PVC 2 3/4\"',104,'I',0,'UN',0.00,0.00,0.00,0),(170,'ADAPTADOR MACHO 3/4',104,'I',0,'UN',0.00,0.00,0.00,0),(171,'TAPON LISO PVC 2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(172,'REDUCCION BUJE 3/4 X 1/2',201,'I',0,'UN',0.00,0.00,0.00,0),(173,'TAPON LISO 1/2\" PVC',201,'',0,'UN',0.00,0.00,0.00,0),(174,'TUBO PVC 3/4 PRESIÓN',0,'I',0,'UN',0.00,0.00,0.00,0),(175,'TEFLON INDUSTRIAL 3/4',201,'I',0,'CARRETA',0.00,0.00,0.00,0),(176,'GUANTES NITRILO',201,'I',0,'PAR',0.00,0.00,0.00,0),(177,'SEMICODO 3/4',201,'I',0,'UN',0.00,0.00,0.00,0),(178,'REDUCCION BUJE 3/4 X 1/2 HG',201,'I',0,'UN',0.00,0.00,0.00,0),(179,'UNION GIBOUT H.F 2\"',201,'I',0,'UN',0.00,0.00,0.00,0),(180,'UNION LISA PVC 2\" PRESIÓN',201,'I',0,'UN',0.00,0.00,0.00,0),(181,'MANGUERA PFU DE 1/2',201,'I',0,'MT',0.00,0.00,0.00,0),(182,'PUNTERAS MACHO MANGUERA 1/2',201,'I',0,'UN',0.00,0.00,0.00,0),(183,'UNION PVC 3/4',201,'I',0,'UN',0.00,0.00,0.00,0),(184,'LLAVE DE PALANCA 3/4 GRIVAL',201,'I',0,'UN',0.00,0.00,0.00,0),(185,'UNION LISA 3\"',201,'I',0,'UN',0.00,0.00,0.00,0),(186,'TUBO NOVAFORD 6\"',201,'I',0,'UN',0.00,0.00,0.00,0),(187,'ALAMBRE GALVANIZADO #14',201,'I',0,'UN',0.00,0.00,0.00,0),(188,'UNION LISA X 1\"',201,'I',0,'UN',0.00,0.00,0.00,0),(189,'ADAPTADOR MACHO 2\" PRESION',201,'I',0,'UN',0.00,0.00,0.00,0),(190,'SEMICODO 2\" PRESION',201,'I',0,'UN',0.00,0.00,0.00,0),(191,'LLAVE PALANCA 2\" FERMETAL',201,'I',0,'UN',0.00,0.00,0.00,0),(192,'COLLARIN PVC 2\"',201,'',0,'UN',0.00,0.00,0.00,0),(193,'ADAPTADOR HEMBRA 1/2 PRESION',201,'I',0,'0',0.00,0.00,0.00,0),(194,'ADAPTADOR HEMBRA 3/4 PRESIÓN',201,'I',0,'0',0.00,0.00,0.00,0),(195,'COLLARIN PRESION 3\"',201,'I',0,'0',0.00,0.00,0.00,0),(196,'COLLARIN PRESION 4\"',201,'I',0,'0',0.00,0.00,0.00,0); /*!40000 ALTER TABLE `conceptos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `detcom` -- DROP TABLE IF EXISTS `detcom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `detcom` ( `dc_numero` int(9) NOT NULL, `dc_codcon` int(4) NOT NULL, `dc_cantid` float(9,2) DEFAULT NULL, `dc_vlruni` int(9) DEFAULT NULL, `dc_vlriva` int(9) DEFAULT NULL, `dc_vlrtot` int(9) DEFAULT NULL, PRIMARY KEY (`dc_numero`,`dc_codcon`), KEY `dc_codcon` (`dc_codcon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `detcom` -- LOCK TABLES `detcom` WRITE; /*!40000 ALTER TABLE `detcom` DISABLE KEYS */; /*!40000 ALTER TABLE `detcom` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `detpedcom` -- DROP TABLE IF EXISTS `detpedcom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `detpedcom` ( `dpc_numero` int(9) NOT NULL, `dpc_codcon` int(4) NOT NULL, `dpc_cantid` float(9,2) DEFAULT NULL, `dpc_vlruni` int(9) DEFAULT NULL, `dpc_vlrtot` int(9) DEFAULT NULL, PRIMARY KEY (`dpc_numero`,`dpc_codcon`), KEY `dpc_codcon` (`dpc_codcon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `detpedcom` -- LOCK TABLES `detpedcom` WRITE; /*!40000 ALTER TABLE `detpedcom` DISABLE KEYS */; /*!40000 ALTER TABLE `detpedcom` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `detpedsal` -- DROP TABLE IF EXISTS `detpedsal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `detpedsal` ( `dps_numero` int(9) NOT NULL, `dps_codcon` int(4) NOT NULL, `dps_cantid` float(9,2) DEFAULT NULL, `dps_vlruni` int(9) DEFAULT NULL, `dps_vlrtot` int(9) DEFAULT NULL, PRIMARY KEY (`dps_numero`,`dps_codcon`), KEY `dps_codcon` (`dps_codcon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `detpedsal` -- LOCK TABLES `detpedsal` WRITE; /*!40000 ALTER TABLE `detpedsal` DISABLE KEYS */; /*!40000 ALTER TABLE `detpedsal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `detsalidas` -- DROP TABLE IF EXISTS `detsalidas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `detsalidas` ( `ds_numero` int(9) NOT NULL, `ds_codcon` int(4) NOT NULL, `ds_cantid` float(9,2) DEFAULT NULL, `ds_vlruni` int(9) DEFAULT NULL, `ds_vlriva` int(9) DEFAULT NULL, `ds_vlrtot` int(9) DEFAULT NULL, PRIMARY KEY (`ds_numero`,`ds_codcon`), KEY `ds_codcon` (`ds_codcon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `detsalidas` -- LOCK TABLES `detsalidas` WRITE; /*!40000 ALTER TABLE `detsalidas` DISABLE KEYS */; /*!40000 ALTER TABLE `detsalidas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ducto` -- DROP TABLE IF EXISTS `ducto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ducto` ( `du_codduc` char(2) NOT NULL, `du_descri` char(40) DEFAULT NULL, PRIMARY KEY (`du_codduc`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ducto` -- LOCK TABLES `ducto` WRITE; /*!40000 ALTER TABLE `ducto` DISABLE KEYS */; INSERT INTO `ducto` (`du_codduc`, `du_descri`) VALUES ('1','Acueducto - Canal'),('11','Alcantarillado - Box Culvert'),('12','Alcantarillado - Tuberia'),('13','Alcantarillado - Canal abierto'),('2','Acueducto - Tunel'),('3','Acueducto - Tuberia'); /*!40000 ALTER TABLE `ducto` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `empleado` -- DROP TABLE IF EXISTS `empleado`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `empleado` ( `em_codemp` char(12) NOT NULL DEFAULT '', `em_nombre` char(40) NOT NULL DEFAULT '', `em_direcc` char(40) NOT NULL DEFAULT '', `em_telefo` char(10) NOT NULL DEFAULT '', `em_profes` int(3) DEFAULT NULL, PRIMARY KEY (`em_codemp`), KEY `em_profes` (`em_profes`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `empleado` -- LOCK TABLES `empleado` WRITE; /*!40000 ALTER TABLE `empleado` DISABLE KEYS */; INSERT INTO `empleado` (`em_codemp`, `em_nombre`, `em_direcc`, `em_telefo`, `em_profes`) VALUES ('1','CHIVOLO','','',5),('72050865','JAROL ENRIQUE OROZCO OROZCO ','CARRERA 1B SUR 7B - 17 ','3205430324',8),('1128165500','YONATHAN CALANCHE VILLA ','CORR MOLER ','3145359762',8),('8571303','ARCADIO ANTONIO OROZCO OBREDOR ','PIEDRAS DE MOLER ','3145977358',8),('19516505','MANUEL FRANCISCO BARRIOS DIAZ ','BARRIO CHIBOLON ','3147046950',9),('19516503','ANTONIO MARÍA HERRERA VERGARA ','CALLE 10 N. 15 - 42 ','3216284798',9),('19518867','LUIS ENRIQUE BOLAÑO OROZCO ','BARRIO CHIBOLON ','3113716556',9),('1079657627','JAVIER JOSE NAVARRO ARRIETA ','CARRERA 1B N. 2 - 20 ','3205260093',9),('19518008','ANTONIO MARIA ESCORCIA ALMANZA','CARRERA 11 N. 16 - 23','3215984806',7),('19516490','PEDRO RAMÓN MATIU CONTRERAS ','CALLE 5 N. 14 - 30 ','3233155039',12),('12685597','JOSE HIGINIO DIAZ BENJUMEA ','BARRIO LA FRANCISCANA ','3016904852',12),('19517047','JORGE MARÍA SIMANCA ANDRADE','BARRIO 23 DE ABRIL','3008343640',12); /*!40000 ALTER TABLE `empleado` 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(60) NOT NULL DEFAULT '', `ep_direcc` char(40) NOT NULL DEFAULT '', `ep_telefo` char(20) 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 ('830503264-8','ADMINISTRACION PUBLICA COOPERATIVA SE SERVICIOS PUBLICOS DE','CL 5 8 - 6 LC 1','3233873300'); /*!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 ('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 `grupo` -- DROP TABLE IF EXISTS `grupo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `grupo` ( `gr_codgru` int(3) NOT NULL DEFAULT '0', `gr_descri` char(40) NOT NULL DEFAULT '', PRIMARY KEY (`gr_codgru`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grupo` -- LOCK TABLES `grupo` WRITE; /*!40000 ALTER TABLE `grupo` DISABLE KEYS */; INSERT INTO `grupo` (`gr_codgru`, `gr_descri`) VALUES (101,'ACEITES, GRASAS Y LUBRICANTES '),(102,'COMBUSTIBLE '),(103,'DROGAS, ELEMENTOS, LABORATORIO'),(104,'ELEM.MATERIA PRIMA CONSTRUCCION'),(105,'EXPLOSIVOS'),(106,'FORRAJES Y ELEME PARA ANIMALES'),(107,'INSECTICIDAS HERVISCIDAS FUNGICIDAS'),(108,'OTROS ELEMENTOS CONSTRUCCION'),(109,'SEMILLAS Y ABONOS'),(110,'UTILES ESCRITORIO, DIBUJO ETC'),(111,'VIVERES RANCHO Y LICORES'),(112,'REPUESTO MAQUINARIA Y EQUIPO'),(113,'UTENCILIOS DE USO DOMESTICO'),(114,'ELEMENTOS Y MATERIALES TALLER '),(115,'OTROS ELEMENTOS DE CONSUMO'),(116,'EQUIPOS Y ELEMENTOS DE DOTACION'),(201,'ACCESORIOS Y REPUESTOS'),(206,'EQUIPOS MAQUINAS PARA COMEDOR'),(207,'EQUIPO Y MAQ COMUNICACION'),(208,'EQUIPO Y MAQ CONSTRUCCION'),(209,'EQUIPO Y MAQ PARA DEPORTE'),(210,'EQUIPO Y MAQ LABORATORIO'),(211,'EQUIPO Y MAQ PARA MEDICINA'),(212,'EQUIPO Y MAQ OFICINA'),(213,'EQUIPO Y MAQ TRANSPORTE'),(214,'HERRAMIENTA Y ACCESORIOS'),(216,'LIBRO DE BIBLIOTECA'),(217,'LLANTAS Y NEUMATICOS'),(218,'MOBILIARIOS Y ENSERES'),(219,'SEMOVIENTES'),(220,'VESTUARIO, ROPA Y EQUIPO'),(226,'OTROS DEVOLUTIVOS'),(230,'BIENES RAICES'); /*!40000 ALTER TABLE `grupo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kardex` -- DROP TABLE IF EXISTS `kardex`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `kardex` ( `kd_numero` int(9) NOT NULL, `kd_tipo` int(1) NOT NULL, `kd_fecreg` date DEFAULT NULL, `kd_cantid` float(9,2) DEFAULT NULL, `kd_vlrtot` int(9) DEFAULT NULL, PRIMARY KEY (`kd_numero`,`kd_tipo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `kardex` -- LOCK TABLES `kardex` WRITE; /*!40000 ALTER TABLE `kardex` DISABLE KEYS */; /*!40000 ALTER TABLE `kardex` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `laboratorio` -- DROP TABLE IF EXISTS `laboratorio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `laboratorio` ( `la_codlab` varchar(10) NOT NULL, `la_descri` char(60) DEFAULT NULL, PRIMARY KEY (`la_codlab`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `laboratorio` -- LOCK TABLES `laboratorio` WRITE; /*!40000 ALTER TABLE `laboratorio` DISABLE KEYS */; INSERT INTO `laboratorio` (`la_codlab`, `la_descri`) VALUES ('0','Sin Definir Laboratorio'),('21','QC S.A.S'),('27','LABORATORIO ACUAZUL'); /*!40000 ALTER TABLE `laboratorio` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `macroruta` -- DROP TABLE IF EXISTS `macroruta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `macroruta` ( `mr_codmac` int(4) NOT NULL, `mr_descri` char(40) DEFAULT NULL, PRIMARY KEY (`mr_codmac`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `macroruta` -- LOCK TABLES `macroruta` WRITE; /*!40000 ALTER TABLE `macroruta` DISABLE KEYS */; /*!40000 ALTER TABLE `macroruta` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `material` -- DROP TABLE IF EXISTS `material`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `material` ( `ma_codmat` char(2) NOT NULL, `ma_descri` char(40) DEFAULT NULL, PRIMARY KEY (`ma_codmat`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `material` -- LOCK TABLES `material` WRITE; /*!40000 ALTER TABLE `material` DISABLE KEYS */; INSERT INTO `material` (`ma_codmat`, `ma_descri`) VALUES ('1','PVC Cloruro de Polivinilo'),('10','PAD (Polietileno de Alta Densidad)'),('11','CCP'),('12','GRES'),('13','Otros'),('2','AC Asbeto Cemento'),('3','Acero'),('4','HF (Hierro Fundido)'),('5','HG (Hierro galvanizado)'),('6','HD (Hierro Ductil)'),('7','PE (Polietileno)'),('8','Fibra de Vidrio'),('9','Concreto Reforzado'),('14','TUBERIA SANITARIA PERFILADA'); /*!40000 ALTER TABLE `material` 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_detalle` text, PRIMARY KEY (`ob_numero`) ) 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_detalle`) VALUES (1,' SE ENVIA VISITA TECNICA PARA REVISION '),(2,' SE ENVIA VISITA TECNICA PARA REVISION '),(3,' SE ENVIARA VISITA TECNICA PARA LA RESPECTIVA REVISION. '),(4,' '),(5,' SE ENVIARA AL TECNICO PARA LA RESPECTIVA REVISION '),(6,' SE ENVIA VISITA TECNICA '),(7,' SE PROGRAMA VISITA TECNICA '),(8,' SE ENVIARA VISITA TECNICA PARA LA RESPECTIVA REVISION. '),(9,' SE ENVIA VISITA TECNICA '),(10,' SE ENVIARA AL TECNICO PARA QUE REALICE LA VISITA Y LA RESPECTIVA REVISION. '),(11,' SE ENVIA AL TECNICO PARA LA RESPECTIVA REVISIO '),(12,' SE ENVIA VISITA TECNICA PARA LA RESPECTIVA REVISION '),(13,' SE ENVIA VISITA TECNICA '),(14,' '),(15,' LA USUARIA SOLICITA CAMBIO DE ACOMETIDA '),(16,' SE LE INFORMA AL USUARIO QUE SE ENVIARA AL AUX DE FONTANERIA A REALIZAR LA INSPECCION Y VERIFICACION A VER A QUIEN LE PERTENECE LA INSTALACION. Y SE LE ACLARA QUE SI ES DEL VECINO ESTE DEBE REALIZAR LA CONECCIO. '),(17,' SE LE INFORMA AL USUARIO QUE SE ENVIARA AL AUX DE FONTANERIA A REALIZAR LA INSPECCION Y VERIFICACION A VER A QUIEN LE PERTENECE LA INSTALACION. Y SE LE ACLARA QUE SI ES DEL VECINO ESTE DEBE REALIZAR LA CONECCIO. '),(18,' SE LE INFORMA AL USUARIO QUE SE ENVIARA AL AUX DE FONTANERIA A REALIZAR LA INSPECCION Y VERIFICACION A VER A QUIEN LE PERTENECE LA INSTALACION. Y SE LE ACLARA QUE SI ES DEL VECINO ESTE DEBE REALIZAR LA CONECCIO. '),(19,' SE LE INFORMA SE LE INVIARA A LOS AUX DE FONTANERIA PARA REALIZAR LA RESPECTIVA REVISION. '),(20,' SE LE INFORMA AL USARIO QUE SE REALIZARA LA VISITA Y CAMBIO DE TAPA. '),(21,' SE REALIZO LA VISITA A LOS USUARIOS PARA VERIFICAR QUE ESTAN RECIBIENDO EL SERVICIO, ADEMAS SE REALIZO CAMBIO DE MANGUERA Y EXCAVACION DE LA MISMA UNION DE MANGERA (2) MTS DE MANQUERA (6)'),(22,' SE REALIZO LA VISITA A LOS USUARIOS PARA VERIFICAR QUE ESTAN RECIBIENDO EL SERVICIO, ADEMAS SE REALIZO CAMBIO DE MANGUERA Y EXCAVACION DE LA MISMA UNION DE MANGERA (2) MTS DE MANQUERA (6)'),(23,' SE LE INFORMA AL USUARIO QUE SE ENVIARA A LOS AUX DE ALCANTARILLADO PARA QUE REALICEN LA RESPECTIVA LIMPIEZA. '),(24,' SE LE INFORMA A LA USURIA QUE SE LE REALIZARA LA VISTA Y CAMBIO DE LA TAPA. '),(25,' SE LE INFORMA AL USUARIO QUE SE ENVIARA A LOS FONTANEROS PARA LA RESPECTIVA REVISION. '),(26,' SE LE INFORMA AL USUARIO QUE SE LE REALIZARA LA RESPECTIVA VISITA. '),(27,' EL USUARIO SOLICITA UNA REVISION YA QUE MANIFIESTA QUE AL LOCAL NO LE ESTA LLEGANDO EL AGUA '),(28,' SE LE INFORMA AL USUARIO QUE SE REALIZARA VISITA '),(29,' SE LE INFORMA ALA USUARIA QUE SE LE REALIZA LA RESPECTIVA VISITA. '),(30,' SE LE INFORMA LA USUARIO QUE SE REALIZARA VISITA. '),(31,' SE LE INFORMA AL USUARIO QUE SE REALIZARA LA VISITA TECNICA. '),(32,' SE LE INFORMA A LA USUARIA QUEEL AGUA ESTAEN EL SECTOR QUE SE ENVIARA A LOS FONTANEROS PARA LA RESPECTIVA REVISION. '),(33,' SE LE INFORMO A LA USURARIA QUE SE INFORMARA A LA EMPRESA AIRE Y SE REALIZARA LA RESPECTIVA VISITA '),(34,' SE LE INFORMA QUE EL AGUA ESTA PARA EL SECTOR QUE SE VA A REALIZAR LA VISITA. '),(35,'SE LE INFORMA AL USUARIO QUE SE REALIZA VISITA '),(36,' SE LE INFORMA AL USUARIO QUE SE REALIZARA LA VISITA '),(37,' SE LE INFORMA A LA USUARIA QUE SE REALIZARA LA VISITA '),(38,' SE LE INFORMA A LA USUARIA QUE SE ENVIARA LA VISITA TECNICA '),(39,' SE LE INFORMA AL USUARIO QUE SE ENVIARA LA VISITA '),(40,' SE LE INFORMA A LA USUARIA QUE SE ENVIARA ALOS FONTANEROS '),(41,' SE LE INFORMA AL USUARIO QUE SE ENVIARA AL FONTANERO. '),(42,' SE LE INFORMA QUE SE ENVIARA LA VISITA '),(43,' SE LE INFORMA QUE SE REALIZA VISITA '),(44,' SE LE INFORMA A LA USUARIA QUE SE REALIZARA LA VISTA '),(45,' SE LE INFORMA A LA USUARIA QUE SE REALIZARA LA VISITA '),(46,' SE LE INFORMA A LA USUARIA QUE SE ENVIARA A LOS FONTANERO PARA LA RESAPECTIVA VISITA '),(47,' se le informa ala usuaria que se enviara a los fontaneros. '),(48,' SE L INFORMA AL USUARIO QUE SE ENVIARA A LOS FONTANEROS '),(49,' SE LE INFORMA A LA USUARIA QUE SE REALIZARA LA VISITA PARA LA RESPECTIVA CONECCION '),(50,' SE LE INFORMA A LA USUARIA QUE SE ENVIARA LA VISITA '),(51,' SE LE INFORMA AL USUARIO QUE SE REALIZARA LA VISITA '); /*!40000 ALTER TABLE `observaciones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pavimento` -- DROP TABLE IF EXISTS `pavimento`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pavimento` ( `pv_numero` int(9) NOT NULL, `pv_tramo` char(2) NOT NULL, `pv_tipo` char(2) NOT NULL, `pv_codres` char(2) NOT NULL, `pv_largo` float(9,2) NOT NULL DEFAULT '0.00', `pv_ancho` float(9,2) NOT NULL DEFAULT '0.00', `pv_profun` float(9,2) NOT NULL DEFAULT '0.00', `pv_metros` float(9,2) NOT NULL DEFAULT '0.00', `pv_valor` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`pv_numero`,`pv_tramo`), KEY `pv_codres` (`pv_codres`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pavimento` -- LOCK TABLES `pavimento` WRITE; /*!40000 ALTER TABLE `pavimento` DISABLE KEYS */; /*!40000 ALTER TABLE `pavimento` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pedcom` -- DROP TABLE IF EXISTS `pedcom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pedcom` ( `pec_numero` int(9) NOT NULL, `pec_mesa` int(4) NOT NULL, `pec_observ` char(40) DEFAULT NULL, PRIMARY KEY (`pec_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pedcom` -- LOCK TABLES `pedcom` WRITE; /*!40000 ALTER TABLE `pedcom` DISABLE KEYS */; /*!40000 ALTER TABLE `pedcom` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pedsal` -- DROP TABLE IF EXISTS `pedsal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pedsal` ( `pes_numero` int(9) NOT NULL, `pes_mesa` int(4) NOT NULL, `pes_observ` char(40) DEFAULT NULL, PRIMARY KEY (`pes_numero`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pedsal` -- LOCK TABLES `pedsal` WRITE; /*!40000 ALTER TABLE `pedsal` DISABLE KEYS */; /*!40000 ALTER TABLE `pedsal` 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(8) 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 `personal` -- DROP TABLE IF EXISTS `personal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal` ( `pe_numero` int(9) NOT NULL DEFAULT '0', `pe_codemp` char(12) NOT NULL DEFAULT '', PRIMARY KEY (`pe_numero`,`pe_codemp`), KEY `pe_numero` (`pe_numero`), KEY `pe_codemp` (`pe_codemp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal` -- LOCK TABLES `personal` WRITE; /*!40000 ALTER TABLE `personal` DISABLE KEYS */; INSERT INTO `personal` (`pe_numero`, `pe_codemp`) VALUES (1,'12685597'),(2,'12685597'),(3,'12685597'),(4,'19516490'),(4,'19518008'),(5,'12685597'),(6,'19516490'),(6,'19518008'),(7,'1'),(8,'19516490'),(8,'19518008'),(9,'1'),(9,'12685597'),(9,'xx'),(10,'12685597'),(12,'19516490'),(12,'19518008'),(13,'12685597'),(14,'8571303'),(16,'19518008'),(17,'19518008'),(18,'19518008'),(19,'19516490'),(19,'19518008'),(20,'12685597'),(21,'19516490'),(21,'19518008'),(22,'19516490'),(22,'19518008'),(22,'xx'),(23,'12685597'),(24,'12685597'),(24,'19516490'),(24,'19517047'),(25,'19516490'),(25,'19518008'),(26,'19516490'),(26,'19518008'),(27,'19518008'),(28,'19516490'),(28,'19518008'),(29,'19516490'),(29,'19518008'),(30,'12685597'),(30,'19517047'),(31,'12685597'),(32,'19516490'),(32,'19518008'),(33,'19516490'),(33,'19518008'),(34,'19516490'),(34,'19518008'),(37,'12685597'),(38,'12685597'),(39,'19516490'),(39,'19518008'),(41,'19516490'),(41,'19518008'),(42,'12685597'),(43,'19516490'),(43,'19518008'),(44,'19516490'),(44,'19518008'); /*!40000 ALTER TABLE `personal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pesajes` -- DROP TABLE IF EXISTS `pesajes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pesajes` ( `ps_numero` int(9) NOT NULL, `ps_codveh` char(6) NOT NULL, `ps_fecini` date DEFAULT NULL, `ps_horini` time DEFAULT NULL, `ps_fecfin` date DEFAULT NULL, `ps_horfin` time DEFAULT NULL, `ps_arepre` int(4) NOT NULL, `ps_macror` int(4) NOT NULL, `ps_tipdis` char(2) NOT NULL, `ps_trsu` float(9,2) NOT NULL DEFAULT '0.00', `ps_trsr` float(9,2) NOT NULL DEFAULT '0.00', `ps_tdsu` float(9,2) NOT NULL DEFAULT '0.00', `ps_tdsr` float(9,2) NOT NULL DEFAULT '0.00', `ps_tdso` float(9,2) NOT NULL DEFAULT '0.00', `ps_sitio` int(4) NOT NULL, PRIMARY KEY (`ps_numero`), KEY `ps_tipdis` (`ps_tipdis`), KEY `ps_arepre` (`ps_arepre`), KEY `ps_macror` (`ps_macror`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pesajes` -- LOCK TABLES `pesajes` WRITE; /*!40000 ALTER TABLE `pesajes` DISABLE KEYS */; /*!40000 ALTER TABLE `pesajes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pormetraje` -- DROP TABLE IF EXISTS `pormetraje`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pormetraje` ( `pm_numero` int(9) NOT NULL, `pm_tramo` char(2) NOT NULL, `pm_codres` char(2) NOT NULL, `pm_largo` decimal(9,7) NOT NULL DEFAULT '0.0000000', `pm_ancho` decimal(9,7) NOT NULL DEFAULT '0.0000000', `pm_profun` decimal(9,7) NOT NULL DEFAULT '0.0000000', `pm_metros` decimal(9,2) NOT NULL DEFAULT '0.00', `pm_valor` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`pm_numero`,`pm_tramo`), KEY `pm_codres` (`pm_codres`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pormetraje` -- LOCK TABLES `pormetraje` WRITE; /*!40000 ALTER TABLE `pormetraje` DISABLE KEYS */; /*!40000 ALTER TABLE `pormetraje` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `presionespm` -- DROP TABLE IF EXISTS `presionespm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `presionespm` ( `pr_numero` int(9) NOT NULL DEFAULT '0', `pr_codsis` varchar(20) NOT NULL DEFAULT '', `pr_detsis` varchar(20) NOT NULL DEFAULT '', `pr_fecini` date NOT NULL DEFAULT '0000-00-00', `pr_horini` time NOT NULL DEFAULT '00:00:00', `pr_fecfin` date NOT NULL DEFAULT '0000-00-00', `pr_horfin` time NOT NULL DEFAULT '00:00:00', `pr_lectura` double(12,3) DEFAULT NULL, `pr_observa` text, `pr_fecreg` date NOT NULL, `pr_horreg` time NOT NULL, `pr_usuario` varchar(20) NOT NULL, PRIMARY KEY (`pr_numero`), KEY `pr_codsis` (`pr_codsis`), KEY `pr_detsis` (`pr_detsis`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `presionespm` -- LOCK TABLES `presionespm` WRITE; /*!40000 ALTER TABLE `presionespm` DISABLE KEYS */; /*!40000 ALTER TABLE `presionespm` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `proceso` -- DROP TABLE IF EXISTS `proceso`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `proceso` ( `pr_codpro` char(2) NOT NULL, `pr_descri` char(40) DEFAULT NULL, PRIMARY KEY (`pr_codpro`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `proceso` -- LOCK TABLES `proceso` WRITE; /*!40000 ALTER TABLE `proceso` DISABLE KEYS */; INSERT INTO `proceso` (`pr_codpro`, `pr_descri`) VALUES ('11','Alcantarillado - Interceptores'),('12','Alcantarillado - Colectores Matrices'),('13','Alcantarillado - acometida domiciliria'),('2','Acueducto - Conduccion'),('3','Acueducto - Distrubucion'),('4','Acueducto - acometida domiciliria'); /*!40000 ALTER TABLE `proceso` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `profesion` -- DROP TABLE IF EXISTS `profesion`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profesion` ( `pr_codpro` int(3) NOT NULL DEFAULT '0', `pr_descri` char(40) NOT NULL DEFAULT '', `pr_vlrhor` decimal(9,2) NOT NULL DEFAULT '0.00', `pr_vlrrec` decimal(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`pr_codpro`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `profesion` -- LOCK TABLES `profesion` WRITE; /*!40000 ALTER TABLE `profesion` DISABLE KEYS */; INSERT INTO `profesion` (`pr_codpro`, `pr_descri`, `pr_vlrhor`, `pr_vlrrec`) VALUES (1,'OPERARIO',3106.00,3882.00),(2,'AUXILIAR ADMINISTRATIVOS',3106.00,3882.00),(3,'BOCATOMERO',3106.00,3882.00),(4,'CONDUCTOR',4063.00,5078.00),(5,'COORDINADOR',4063.00,5078.00),(6,'OPERARIO CORTES',3106.00,3882.00),(7,'FONTANERO',4063.00,5078.00),(9,'OPERARIO PLANTA DE TRATAMIENTO',3563.00,4453.00),(10,'INGENIERO',8750.00,10938.00),(11,'PLOMERO',3106.00,3882.00),(12,'AUXILIAR OPERATIVA ACUEDUCTO Y ALCANTAR',3000.00,2500.00),(13,'MONITOR DE REDES',4063.00,5078.00),(14,'ALBAÑIL',3106.00,3882.00),(15,'TECNICO ELECTRONICO',4063.00,5078.00),(16,'TECNICO DE LABORATORIO',4063.00,5078.00),(17,'INSPECTOR DE REDES',4063.00,5078.00),(18,'OFICIAL OPERT ACUEDUCTO ALCANTARILLADO',4500.00,5000.00),(8,'OPERARIO PLANTA DE CAPTACIÓN',3563.00,4453.00); /*!40000 ALTER TABLE `profesion` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `punto` -- DROP TABLE IF EXISTS `punto`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `punto` ( `pu_codpun` varchar(20) NOT NULL, `pu_municipio` varchar(20) NOT NULL, `pu_descri` char(60) DEFAULT NULL, `pu_codsui` varchar(10) NOT NULL, `pu_tippun` char(1) NOT NULL, `pu_fuente` char(1) NOT NULL, `pu_ubica` char(1) NOT NULL, `pu_aguablo` char(2) NOT NULL, `pu_localiza` char(1) NOT NULL, `pu_barrio` varchar(40) NOT NULL, `pu_direccion` varchar(50) NOT NULL, `pu_latgra` varchar(10) NOT NULL, `pu_latmin` varchar(10) NOT NULL, `pu_latseg` varchar(10) NOT NULL, `pu_longra` varchar(10) NOT NULL, `pu_lonmin` varchar(10) NOT NULL, `pu_lonseg` varchar(10) NOT NULL, `pu_altitud` varchar(10) NOT NULL, `pu_codsis` varchar(10) NOT NULL, `pu_local` int(9) NOT NULL, PRIMARY KEY (`pu_codpun`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `punto` -- LOCK TABLES `punto` WRITE; /*!40000 ALTER TABLE `punto` DISABLE KEYS */; /*!40000 ALTER TABLE `punto` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rastreo` -- DROP TABLE IF EXISTS `rastreo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rastreo` ( `rt_codpro` int(11) NOT NULL DEFAULT '0', `rt_codemp` char(8) NOT NULL DEFAULT '', `rt_fecreg` date NOT NULL DEFAULT '0000-00-00', `rt_horreg` time NOT NULL DEFAULT '00:00:00', PRIMARY KEY (`rt_codpro`,`rt_codemp`,`rt_fecreg`,`rt_horreg`), KEY `rt_codpro` (`rt_codpro`), KEY `rt_codemp` (`rt_codemp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rastreo` -- LOCK TABLES `rastreo` WRITE; /*!40000 ALTER TABLE `rastreo` DISABLE KEYS */; /*!40000 ALTER TABLE `rastreo` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `repuestos` -- DROP TABLE IF EXISTS `repuestos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `repuestos` ( `rp_numero` int(9) NOT NULL, `rp_codcon` int(4) NOT NULL, `rp_cantid` float(9,2) NOT NULL DEFAULT '0.00', `rp_vlrtot` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`rp_numero`,`rp_codcon`), KEY `rp_nroord` (`rp_numero`), KEY `rp_codcon` (`rp_codcon`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `repuestos` -- LOCK TABLES `repuestos` WRITE; /*!40000 ALTER TABLE `repuestos` DISABLE KEYS */; INSERT INTO `repuestos` (`rp_numero`, `rp_codcon`, `rp_cantid`, `rp_vlrtot`) VALUES (9,138,3.00,0.00),(9,168,3.00,0.00),(3,138,3.00,0.00),(10,138,1.00,0.00),(2,138,3.00,0.00),(4,181,4.00,0.00),(4,193,2.00,0.00),(5,138,3.00,0.00),(13,126,3.00,0.00),(22,181,6.00,0.00),(22,179,2.00,0.00),(26,181,10.00,0.00),(26,141,4.00,0.00),(25,138,1.00,0.00),(25,141,2.00,0.00),(30,138,18.00,0.00),(31,143,5.00,0.00),(31,100,5.00,0.00),(33,193,1.00,0.00),(33,127,1.00,0.00),(33,181,1.00,0.00),(21,181,6.00,0.00),(21,141,2.00,0.00),(23,138,6.00,0.00),(29,195,1.00,0.00),(29,181,4.00,0.00),(20,143,1.00,0.00),(20,100,1.00,0.00),(32,168,1.00,0.00),(32,180,1.00,0.00),(34,181,10.00,0.00),(34,141,2.00,0.00),(37,126,6.00,0.00),(38,138,6.00,0.00),(42,126,6.00,0.00),(44,168,2.00,0.00),(44,180,2.00,0.00),(44,193,5.00,0.00),(44,127,5.00,0.00),(44,192,4.00,0.00),(41,141,2.00,0.00),(43,112,2.00,0.00),(43,167,1.00,0.00),(43,165,1.00,0.00); /*!40000 ALTER TABLE `repuestos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `resistencia` -- DROP TABLE IF EXISTS `resistencia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `resistencia` ( `rs_codres` char(2) NOT NULL, `rs_descri` char(40) DEFAULT NULL, `rs_valor` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`rs_codres`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `resistencia` -- LOCK TABLES `resistencia` WRITE; /*!40000 ALTER TABLE `resistencia` DISABLE KEYS */; INSERT INTO `resistencia` (`rs_codres`, `rs_descri`, `rs_valor`) VALUES ('1','2500 - 3000',30000.00); /*!40000 ALTER TABLE `resistencia` 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, 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`) VALUES ('jmorales','John Jairo Morales','PQR'),('asexis','Asexis Soporte','Asexis'),('39095242','ROCIO OROZCO OROZCO','PQR'); /*!40000 ALTER TABLE `responsable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `salidas` -- DROP TABLE IF EXISTS `salidas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `salidas` ( `sa_numero` int(9) NOT NULL, `sa_codcli` char(12) NOT NULL DEFAULT '', `sa_fecreg` date DEFAULT NULL, `sa_horreg` time NOT NULL DEFAULT '00:00:00', `sa_vlrtot` int(9) DEFAULT NULL, `sa_vlriva` int(9) DEFAULT NULL, `sa_apagar` int(9) DEFAULT NULL, `sa_estado` char(1) NOT NULL, `sa_tramite` int(9) NOT NULL, `sa_tisalida` char(2) NOT NULL, PRIMARY KEY (`sa_numero`), KEY `sa_codcli` (`sa_codcli`), KEY `sa_tisalida` (`sa_tisalida`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `salidas` -- LOCK TABLES `salidas` WRITE; /*!40000 ALTER TABLE `salidas` DISABLE KEYS */; /*!40000 ALTER TABLE `salidas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sector` -- DROP TABLE IF EXISTS `sector`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sector` ( `se_codsec` int(3) NOT NULL DEFAULT '0', `se_descri` text, PRIMARY KEY (`se_codsec`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sector` -- LOCK TABLES `sector` WRITE; /*!40000 ALTER TABLE `sector` DISABLE KEYS */; INSERT INTO `sector` (`se_codsec`, `se_descri`) VALUES (1,'SECTOR NORTE '),(2,'SECTOR SUR '),(3,'PARTE ALTA'); /*!40000 ALTER TABLE `sector` 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(2) 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 ('C','Compras',0),('D','Descargas por Salidas',0),('P','Registro Pesaje',0),('S','Suspensiones',0),('T','Tramites',51),('CA','Calidad de Agua',0),('CN','Calidad de Agua no obligatoria',0),('CE','Calidad de Agua Especiales',0),('CF','Calidad de Agua fuentes superficiales',0),('CB','Calidad de agua subterraneas',0),('PR','Presiones',0),('AB','Abastecimiento Por Carrotanques',0),('PM','Presiones Puntos Muestreo',0); /*!40000 ALTER TABLE `secuencia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sistema` -- DROP TABLE IF EXISTS `sistema`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sistema` ( `si_codsis` varchar(20) NOT NULL DEFAULT '0', `si_descri` varchar(60) DEFAULT NULL, `si_municipio` varchar(10) NOT NULL, `si_adicional` varchar(20) NOT NULL, PRIMARY KEY (`si_codsis`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sistema` -- LOCK TABLES `sistema` WRITE; /*!40000 ALTER TABLE `sistema` DISABLE KEYS */; INSERT INTO `sistema` (`si_codsis`, `si_descri`, `si_municipio`, `si_adicional`) VALUES ('170','CHIBOLO - MAGDALENA','47170','47170'); /*!40000 ALTER TABLE `sistema` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sitio` -- DROP TABLE IF EXISTS `sitio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sitio` ( `si_codsit` int(4) NOT NULL DEFAULT '0', `si_descri` char(40) NOT NULL DEFAULT '', PRIMARY KEY (`si_codsit`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sitio` -- LOCK TABLES `sitio` WRITE; /*!40000 ALTER TABLE `sitio` DISABLE KEYS */; /*!40000 ALTER TABLE `sitio` 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_consec` int(3) NOT NULL, `su_fecreg` date DEFAULT NULL, `su_horreg` time NOT NULL DEFAULT '00:00:00', `su_codres` char(12) NOT NULL, `su_detalle` text, PRIMARY KEY (`su_numero`,`su_consec`), 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_consec`, `su_fecreg`, `su_horreg`, `su_codres`, `su_detalle`) VALUES (1,0,'2022-04-28','11:38:55','39095242','Registro'),(2,0,'2022-04-28','03:26:43','39095242','Registro'),(1,1,'2022-04-29','10:42:50','39095242','Entregado->1 - CHIVOLO'),(2,1,'2022-04-29','10:42:50','39095242','Entregado->1 - CHIVOLO'),(3,0,'2022-05-05','08:41:27','39095242','Registro'),(4,0,'2022-05-05','08:50:08','39095242','Registro'),(5,0,'2022-05-19','03:10:53','39095242','Registro'),(6,0,'2022-05-26','10:11:33','39095242','Registro'),(7,0,'2022-05-26','11:32:07','39095242','Registro'),(8,0,'2022-05-27','03:33:08','39095242','Registro'),(9,0,'2022-05-27','03:54:44','39095242','Registro'),(7,1,'2022-05-27','04:08:33','39095242','SE REALIZO LA RESPECTIVA LIMPIEZA AL ALCANTARILLADO DEJANDOLO EN FUNCIONAMIENTO. '),(7,2,'2022-05-27','04:08:33','39095242','SE REALIZO LA RESPECTIVA LIMPIEZA AL ALCANTARILLADO DEJANDOLO EN FUNCIONAMIENTO. '),(7,3,'2022-05-27','04:08:33','39095242','SE REALIZO LA RESPECTIVA LIMPIEZA AL ALCANTARILLADO DEJANDOLO EN FUNCIONAMIENTO. '),(9,1,'2022-05-27','04:59:34','39095242','SE REALIZO LA LIMPIEZA DEJANDOLO EN FUNCIONAMIENTO '),(1,2,'2022-06-01','11:01:57','asexis','Entregado->1 - CHIVOLO'),(2,2,'2022-06-01','11:01:57','asexis','Entregado->1 - CHIVOLO'),(3,1,'2022-06-01','11:01:57','asexis','Entregado->1 - CHIVOLO'),(4,1,'2022-06-01','11:01:57','asexis','Entregado->1 - CHIVOLO'),(5,1,'2022-06-01','11:01:57','asexis','Entregado->1 - CHIVOLO'),(6,1,'2022-06-06','10:29:49','39095242','SE LE HACE MANTENIMIENTO AL GALAPAGO '),(3,2,'2022-06-06','10:31:46','39095242','SE REALIZA LA RESPECTIVA LIMPIEZA DEJANDO TODO EN FUNCIONAMIENTO '),(10,0,'2022-06-14','10:03:31','39095242','Registro'),(1,3,'2022-06-30','02:45:46','39095242','se realiza la respectiva limpieza dejando en funcionamiento '),(9,2,'2022-06-30','03:07:46','39095242','se realiza la limpieza dejando en funcionamiento '),(2,3,'2022-06-30','03:37:19','39095242','se realiza la respectiva limpieza dejándolo en funcionamiento '),(10,1,'2022-06-30','03:39:46','39095242','no se encuentra daño en el servicio de alcantarilla se le informa que el problema es interno'),(4,2,'2022-06-30','03:45:08','39095242','se realiza la vista y se deja en funcionamiento '),(5,2,'2022-06-30','04:04:52','39095242','se realiza la visita donde se pudo constar el taponamiento se requiere un carro para dicho procedimiento '),(8,1,'2022-06-30','04:08:09','39095242','se realizo la visita y mantenimiento al galápago dejándolo en funcionamiento '),(11,0,'2022-07-05','09:03:41','39095242','Registro'),(12,0,'2022-07-21','09:26:15','39095242','Registro'),(12,1,'2022-07-25','03:40:16','39095242','Entregado->1 - CHIVOLO'),(13,0,'2022-07-27','09:12:27','39095242','Registro'),(13,1,'2022-08-01','09:14:06','39095242','se realizó la visita donde se pudo constatar que la alcantarilla estaba rebosada se procedió a hacer la respectiva limpieza dejándolo en funcionamiento '),(12,2,'2022-08-01','09:22:19','39095242','se realiza la visita donde se constata que había fallas en el medidor instalado y se realiza las correcciones dejando en funcionamiento.'),(14,0,'2022-11-08','09:55:30','39095242','Registro'),(15,0,'2022-11-09','09:55:30','39095242','Registro'),(1,4,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(2,4,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(3,3,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(4,3,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(5,3,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(6,2,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(7,4,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(8,2,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(9,3,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(10,2,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(11,1,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(12,3,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(13,2,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(14,1,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(15,1,'2023-09-11','05:45:50','39095242','Entregado->19518008 - ANTONIO MARIA ESCORCIA ALMANZA'),(16,0,'2024-02-22','11:03:49','39095242','Registro'),(17,0,'2024-02-23','10:33:36','39095242','Registro'),(18,0,'2024-02-23','11:04:15','39095242','Registro'),(19,0,'2024-02-26','09:45:59','39095242','Registro'),(20,0,'2024-02-26','11:43:59','39095242','Registro'),(20,1,'2024-02-26','05:11:54','39095242','SE REALIZA EL CAMBIO DE TAPA DEL REGISTRO DEJANDOLO COMPETAMENTE SELLADO'),(21,0,'2024-02-19','05:14:18','39095242','Registro'),(22,0,'2024-02-19','05:24:35','39095242','Registro'),(23,0,'2024-02-27','08:43:18','39095242','Registro'),(24,0,'2024-02-27','09:20:25','39095242','Registro'),(25,0,'2024-02-27','09:43:44','39095242','Registro'),(26,0,'2024-02-28','10:05:14','39095242','Registro'),(27,0,'2024-03-06','05:14:40','39095242','Registro'),(28,0,'2024-03-13','09:03:12','39095242','Registro'),(29,0,'2024-04-04','09:52:08','39095242','Registro'),(30,0,'2024-04-05','08:24:52','39095242','Registro'),(31,0,'2024-04-05','08:39:41','39095242','Registro'),(32,0,'2024-04-22','10:30:50','39095242','Registro'),(33,0,'2024-04-23','11:56:05','39095242','Registro'),(34,0,'2024-04-23','02:44:32','39095242','Registro'),(35,0,'2024-04-25','10:31:03','39095242','Registro'),(36,0,'2024-04-25','10:36:25','39095242','Registro'),(24,1,'2024-04-25','11:01:59','39095242','SE REALIZA EL CAMBIO DE TAPA DEL REGISTRO DE BALBULA'),(22,1,'2024-04-25','11:16:23','39095242','SE REALIZO EXCAVACION Y CANBIO DE MANGUERA'),(25,1,'2024-04-25','02:42:19','39095242','SE REALIZA ARREGLO DE FUGA DE ACOMETIDA EN TUBO DE PVC 1/2 SE UTILIZARON 2 UNIONES 1MT DE TUBO'),(27,1,'2024-04-25','02:47:18','39095242','SE REALIZO LA REVISION SE PUDO CONSTATAR QUE LA USUARIA SI CUENTA CON EL SDERVCIO DE AGUA SOLO QUE TIENE LA LLAVE CERRADA POR QUE TIENE FUGA EN LA INSTALACION INTERNA SE LE INFORMA AL USUARIO.'),(30,1,'2024-04-25','03:01:41','39095242','SONDEO EN REGISTRO DE ALCANTARILLADO SE UTILIZO 18 MTS DE TUBO DE1/2'),(31,1,'2024-04-25','03:07:27','39095242','SE SELLO LA TAPA DEL REGISTRO DE ALCANTARILLADO '),(33,1,'2024-04-25','03:29:23','39095242','EXCAVACION SE CAMBIO 1MT DE MANGUERAS Y 2 ADAPTADORES'),(16,1,'2024-04-25','05:09:50','39095242','SE REALIZA LA VISITA Y SE PUDO COMPROBAR QUE LA CONEXION QUE EXISTE PERTENECE AL PREDIO DEL VECINO, SE PROCEDE A INFORMAR AL USUARIO.'),(17,1,'2024-04-25','05:12:36','39095242','SE LE INFORMA AL USUARIO QUE LA CONEXION DE SERVICIO PERTENECE AL PREDIO DEL VECINO, SE LE INFORMA AL USUARIO.'),(18,1,'2024-04-26','09:16:11','39095242','SE LE INFORMA AL USUARIO QUE LA INSTALACION QUE SE ENCUENTRA LE PERTENECE ES AL VECINO.'),(19,1,'2024-04-26','09:27:19','39095242','SE REALIZO LIMPIEZA DE LA MANGUERA'),(21,1,'2024-04-26','09:44:20','39095242','SE REALIZA VISITA A LOS USUARIOS VERIFICANDO QUE ESTAN RECIBIENDO EL SERVICIO, SE REALIZO CAMBIO DE MANGUERA Y EXCAVACION, SE UTILIZARON 6 MTS DE MANGURA Y DOS UNIONES'),(23,1,'2024-04-26','09:49:55','39095242','SE REALIZA MANTENIMIENTO Y LIMPIEZA DE MANJOL'),(26,1,'2024-04-26','09:55:59','39095242','SE REALIZO CAMBIO DE MANGUERA Y EXCAVACION SE UTILIZARON 10MTS MANGUERA Y 4 UNIONES'),(29,1,'2024-04-26','10:10:27','39095242','SE INSTALO UN GALAPAGO Y 4 MTS DE MANGUERA'),(37,0,'2024-05-02','10:53:23','39095242','Registro'),(38,0,'2024-05-03','10:56:19','39095242','Registro'),(39,0,'2024-05-06','10:26:16','39095242','Registro'),(20,2,'2024-05-08','08:35:35','39095242','SE REALIZO CAMBIO DE TAPA DEJANDOLA SELLADA '),(32,1,'2024-05-08','02:39:56','39095242','SE REALIZO EL CAMBIO DE UN (1) TUBO DE 2\" Y UNA UNION DE REPARACION DE 2\"'),(34,1,'2024-05-08','02:54:08','39095242','SE REALIZA CAMBIO DE ACOMETIDA'),(37,1,'2024-05-08','03:01:13','39095242','SE REALIZA SONDEO Y SE DEJA EN FUNCIONAMIENTO'),(38,1,'2024-05-08','03:02:50','39095242','SE REALIZA SONDEO DEL REGISTRO DEJANDOLO EN FUNCIONAMIENTO'),(40,0,'2024-05-08','03:19:38','39095242','Registro'),(28,1,'2024-05-09','08:20:34','39095242','se realiza la visita y se le informa al usuario que la acometida quedo bajo la placa del pavimento y que el Ing. de la obra le conecto la nueva acometida por el otro lado '),(41,0,'2024-05-15','10:55:09','39095242','Registro'),(42,0,'2024-05-20','08:52:00','39095242','Registro'),(43,0,'2024-05-23','10:40:22','39095242','Registro'),(44,0,'2024-05-23','10:53:47','39095242','Registro'),(45,0,'2024-05-24','02:50:29','39095242','Registro'),(46,0,'2024-05-24','03:57:22','39095242','Registro'),(47,0,'2024-05-27','09:41:08','39095242','Registro'),(48,0,'2024-05-27','09:49:51','39095242','Registro'),(39,1,'2024-05-27','09:53:50','39095242','SE REALIZA LA RESPECTIVA CORRECCION '),(42,1,'2024-05-27','10:27:43','39095242','se realiza soneo'),(44,1,'2024-05-29','09:48:15','39095242','SE REALIZO EL CAMBIO DE 2 TUBO DE 2\", 2 UNIONES SENCILLAS DE 2\" 10 ADAPTADORES DE 1/2 5 HEMBRAS, 5 MACHOS, 4 GALAPAGOS 2\" '),(44,2,'2024-05-29','09:48:15','39095242','SE REALIZO EL CAMBIO DE 2 TUBO DE 2\", 2 UNIONES SENCILLAS DE 2\" 10 ADAPTADORES DE 1/2 5 HEMBRAS, 5 MACHOS, 4 GALAPAGOS 2\" '),(35,1,'2024-05-29','09:59:05','39095242','SE REALIZA LA VISITA SE CONSTATA QUE YA EL USUARIO ESTA CONECTADO SE LE INFORMA QUE DEBE CANCELAR LA INSTALACION Y FACTURAS MENSUALES'),(36,1,'2024-05-29','10:00:28','39095242','SE REALIZA LA VISITA SE CONSTATA QUE EL USURIO YA ESTA CONECTADO SE LE INFORMA QUE DEBE CANCELAR LA INSTALACION Y PAGO MENSUAL '),(41,1,'2024-05-29','10:11:52','39095242','SE REALIZA LA VISITA SE INSTALAN DOS UNIONES DE MANGUERA '),(43,1,'2024-05-29','10:19:26','39095242','SE INSTALARON\r\n2 TUBOS Y MEDIO DE 3\"\r\n1UNION DE REPARACION DE 3\"\r\nUNA T DE 3\"'),(49,0,'2024-05-31','10:23:13','39095242','Registro'),(50,0,'2024-06-14','10:36:39','39095242','Registro'),(51,0,'2024-06-17','11:06:41','39095242','Registro'); /*!40000 ALTER TABLE `sucesos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tactividades` -- DROP TABLE IF EXISTS `tactividades`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tactividades` ( `ta_numero` int(9) NOT NULL, `ta_codact` int(11) NOT NULL, `ta_codemp` char(12) NOT NULL, `ta_fecini` date DEFAULT NULL, `ta_horini` time DEFAULT NULL, `ta_fecfin` date DEFAULT NULL, `ta_horfin` time DEFAULT NULL, `ta_vlract` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`ta_numero`,`ta_codact`,`ta_codemp`), KEY `ta_nroord` (`ta_numero`), KEY `ta_codact` (`ta_codact`), KEY `ta_codemp` (`ta_codemp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tactividades` -- LOCK TABLES `tactividades` WRITE; /*!40000 ALTER TABLE `tactividades` DISABLE KEYS */; INSERT INTO `tactividades` (`ta_numero`, `ta_codact`, `ta_codemp`, `ta_fecini`, `ta_horini`, `ta_fecfin`, `ta_horfin`, `ta_vlract`) VALUES (9,42,'1','2022-05-27','08:30:00','2022-05-27','10:00:00',6094.50),(1,42,'12685597','2022-05-25','09:06:00','2022-05-25','10:30:00',4200.00),(6,21,'19516490','2022-05-25','03:00:00','2022-05-25','03:40:00',0.00),(3,42,'xx','2022-05-26','10:21:00','2022-05-26','11:15:00',0.00),(10,0,'12685597','2022-06-14','09:30:00','2022-06-14','09:40:00',500.00),(10,44,'12685597','2022-06-23','10:21:00','2022-06-23','10:40:00',950.00),(2,44,'12685597','2022-06-20','10:00:00','2022-06-20','10:40:00',2000.00),(5,0,'xx','2022-06-30','02:00:00','2022-06-30','04:04:00',0.00),(13,41,'xx','2022-07-30','09:10:00','2022-07-30','11:00:00',0.00),(13,0,'xx','2022-08-01','09:11:00','2022-08-01','11:00:00',0.00),(12,0,'xx','2022-07-31','09:21:00','2022-07-31','10:30:00',0.00),(24,58,'xx','2024-02-28','06:00:00','2024-02-28','06:40:00',0.00),(22,15,'19516490','2024-02-19','02:00:00','2024-02-19','03:10:00',0.00),(25,14,'xx','2024-02-27','06:30:00','2024-02-27','07:05:00',0.00),(30,0,'xx','2024-04-06','08:35:00','2024-04-06','10:11:00',0.00),(33,15,'xx','2024-04-24','11:00:00','2024-04-24','00:00:12',0.00),(25,15,'19516490','2024-02-27','06:30:00','2024-02-27','00:00:08',5300.00),(27,21,'xx','2024-02-27','08:35:00','2024-02-27','08:40:00',0.00),(30,41,'12685597','2024-04-06','08:35:00','2024-04-06','10:11:00',4800.00),(31,58,'12685597','2024-04-06','07:35:00','2024-04-06','08:11:00',0.00),(16,21,'19518008','2024-07-01','00:00:08','2024-07-01','00:00:08',677.17),(17,21,'19518008','2024-01-07','08:30:00','2024-07-01','00:00:08',3408789.25),(18,21,'19518008','2024-01-07','08:30:00','2024-07-01','00:00:08',3408789.25),(19,21,'19516490','2024-02-19','10:30:00','2024-02-19','11:10:00',2000.00),(20,58,'12685597','2024-02-23','00:00:02','2024-04-26','09:35:00',2516950.00),(21,15,'19516490','2024-02-20','02:00:00','2024-02-20','03:10:00',3500.00),(26,15,'19516490','2024-02-29','10:20:00','2024-02-29','11:30:00',3500.00),(29,14,'19516490','2024-04-05','07:18:00','2024-04-05','09:20:00',6100.00),(32,15,'19516490','2024-04-24','09:40:00','2024-04-24','10:38:00',2900.00),(34,57,'19516490','2024-04-24','09:18:00','2024-04-24','11:40:00',7100.00),(37,42,'12685597','2024-01-06','08:00:00','2024-01-06','08:30:00',1500.00),(42,41,'12685597','2024-05-24','09:30:00','2024-05-24','10:00:00',1500.00),(41,14,'xx','2024-05-08','08:30:00','2024-05-08','09:00:00',0.00),(43,62,'19518008','2024-05-23','08:15:00','2024-05-23','03:40:00',-13881.92); /*!40000 ALTER TABLE `tactividades` 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 ('0001','AC - DANO EN RED MATRIZ ACUEDUCTO'),('0002','AC - FUGA DOMICILIARIA ACUEDUCTO'),('0003','AC - ROBO DE MEDIDOR'),('0004','AC - MEDIDOR FRENADO'),('0005','AC - FUGA DE MEDIDOR'),('0006','AC - GEOFONO INTERNO'),('0007','AC - GEOFONO EXTERNO'),('0008','AC - INSTALACION DE HIDRANTE'),('0009','AC - MANTENIMIENTO HIDRANTE'),('0010','AC - RETIRO DE HIDRANTE'),('0011','AC - INSTALACION DE VALVULA'),('0012','AC - MANTENIMIENTO DE VALVULA'),('0013','AC - RETIRO DE VALVULA'),('0014','AC - RETIRO DE ESCOMBROS'),('0015','OT -RECUPERACION EN RECEBO ACUEDUCTO'),('0016','OT -RECUPERACION EN ASFALTO ACUEDUCTO'),('0017','OT -RECUPERACION EN CONCRETO ACUEDUCTO'),('0018','AC - DANO EN LLAVE DE PASO'),('0019','AC - INSTALACION DE TAPA VALVULA'),('0020','AL -SONDEO Y LIMPIEZA RED MATRIZ ALCANTA'),('0021','AL -DANO RED MATRIZ ALCANTARILLADO'),('0022','AL -LAVADO RED MATRIZ'),('0023','AL -LIMPIEZA Y SONDEO POZOS DE INSPECCIO'),('0024','AL -POZO COLAPSADO'),('0025','AL -CAJA DE INSPECCION DOMICILIARIA COLA'),('0026','AL -REPOSICION RED DOMICILIARIA'),('0027','AL -CONSTRUCCION POZO DE INSPECCION'),('0028','AL -RECONSTRUCCION POZO DE INSPECCION'),('0029','AL -INSTALACION REJILLA'),('0030','AL -INSTALACION TAPA POZO'),('0031','OT -REPOSICION VIA PAVIMENTO FLEXIBLE'),('0032','OT -REPOSICION VIAA PAVIMENTO RIGIDO'),('0033','AL -REALIZAR APIQUE'),('0034','AC - DANO RED MATRIZ 2\" ACUEDUCTO'),('0035','AC - DANO RED MATRIZ 3\" ACUEDUCTO'),('0036','AC - DANO RED MATRIZ 4\" ACUEDUCTO'),('0037','AC - DANO RED MATRIZ 6\" ACUEDUCTO'),('0038','AC - DANO RED MATRIZ 8\" ACUEDUCTO'),('0039','AC - DANO RED MATRIZ 10\" ACUEDUCTO'),('0040','AC - DANO RED MATRIZ 12\" ACUEDUCTO'),('0041','AC - DANO RED MATRIZ 14\" ACUEDUCTO'),('0042','AL -HUNDIMIENTO DE VIA ALCANTARILLADO'),('0043','AC - FUGA EN LA CALLE ACUEDUCTO'),('0044','AC - FRAUDE ACUEDUCTO'),('0045','AC - INSTALACION LLAVES DE PASO'),('0046','AC - REPOSICION DOMICILIARIA ACUEDUCTO'),('0047','AC - REVISION DE MEDIDOR'),('0048','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('0049','AC - EXCAVASION DE ACUEDUCTO'),('0050','AC - RECUPERACION DE ANDEN ACUEDUCTO'),('0051','AL -RED COLAPSADA'),('0052','AL -FUGA DOMICILIARIA ALCANTARILLADO'),('0053','AL -POZO REBOSADO'),('0054','AC - INSTALACION HIDRANTE INSP REDES'),('0055','AC - TOMA DE PRESION INSP. REDES'),('0056','AC - EMPALMES EN RED MATRIZ INSP. REDES'),('0057','AC - INSTALACION DE VENTOSAS INSP. REDES'),('0058','AC - INSTALACION DE VALVULAS INSP. REDES'),('0059','AC - INST. TUBERIA 2\" INSP. REDES'),('0060','AC - INST. TUBERIA 3\" INSP. REDES'),('0061','AC - INST. TUBERIA 4\" INSP. REDES'),('0062','AC - INST. TUBERIA 6\" INSP. REDES'),('0063','AL -DANO RED MATRIZ ALCANTARILLADO'),('0064','AL -POZO TAPADO'),('0065','AC - RECONEXION (Cartera)'),('0066','AC - FUGA POR CORTE DEL SERVICIO (Carter'),('0067','AL -BRIGADA LIMPIEZA RED PPAL ALCAN. DET'),('0068','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('0069','AL -RECUPERACION EN ASFALTO ALCANTARILLA'),('0070','OT -RECUPERACION EN CONCRETO'),('0071','AL -RECUPERACION DE ANDEN ALCANTARILLADO'),('0072','AC - INSTALACION DE MEDIDOR'),('0073','AC - LEVANTAMIENTO MEDIDOR'),('0074','AC - INSTALACION DOMICILIARIA'),('0075','AC - TAPONAMIENTO DOMICILIARIA'),('0076','AC - SONDEO DE RED PRINCIPAL'),('0077','AC - SONDEO DE RED MATRIZ DE ACUEDUCTO'),('0078','AL -LIMPIEZA DE POZO'),('0079','AL -VISITA TECNICA ALCANTARILLADO'),('0080','AS -BRIGADAS MANUALES'),('0081','AL -INST.ARO TAPA TRAFICO PESADO'),('0082','AC - SIN SERVICIO ACUEDUCTO'),('0083','AL -TAPONAMIENTO DOMICILIARIA ALCANTARIL'),('0084','AC - INSTALACION CAJA DE ANDEN'),('0085','AL -ACOMETIDA NUEVA ALCANTARILLADO'),('0086','AC - FRAUDE CONTROL PERDIDAS'),('0087','AC - FUGA DE MEDIDOR CONTROL PERDIDAS'),('0088','AC - ACOMETIDA NUEVA ACUEDUCTO'),('0089','AC - LAVADO DE RED ACUEDUCTO'),('0090','AL -RETIRO ESCOMBROS ALCANTARILLADO'),('0091','AC - GEOFONO MARCADO'),('0092','AC - GEOFONO FUERA DE LA CIUDAD'),('0093','AC - REVISION TECNICA ACUEDUCTO'),('0094','AC - VISITA TECNICA ACUEDUCTO'),('0095','AC - PROFUNDIZACION ACOMETIDA ACUEDUCTO'),('0096','OT -INSTALACION PASACALLE'),('0097','AC - INSTALACION VENTOSA'),('0098','AC - CAMBIO DE ACOMETIDA ACUEDUCTO'),('0099','AC - RENIVELACION RECEBO ACUEDUCTO'),('0100','AC - INDEPENDIZACION DOMICILIARIA'),('0101','AC - DISPONIBILIDAD ACUEDUCTO Y ALCANTAR'),('0102','AC - RED ACUEDUCTO NUEVA'),('0103','AL -REPARACION RED DE ALCANTARILLADO'),('0104','AC - INSTALACION DE TUBO MADRE PARA ACUE'),('0105','AS -VISITA VERIFICACION DESHABITADO'),('0106','AS -FALLA EN LA PRESTACION DE SERVICIO A'),('0107','AS -REVISAR SI AL PREDIO T.EL SERVICIO A'),('0108','AC - CONEXION DE ACUEDUCTO'),('0112','AL -ROTURA TAPA POZO DE INSPECCION ALCAN'),('0116','AC - INSTALAR TAPA PARA REGISTRO DE ACUE'),('0119','AL -REVISION TECNICA DE ALCANTARILLADO'),('0120','AC - ARREGLO DE TUBO MADRE DE 3\" PVC'),('0122','AL -ARREGLO DE POZO DE INSPECCION DE ALC'),('0124','AC - REPOSICION DE MICROMEDIDOR'),('0123','AC - INSTALACION DE SISTEMA ACCUCTAB'),('0125','AC - VERIFICAR SERVICIO Y USO'),('0127','AL -MANTENIMIENTO DE ALCANTARILLADO'),('0109','AC - IDENTIFICACION FRAUDULENTOS'),('0126','AC - VIABILIDAD DE SERVICIOS'),('0128','OT -MANTENIMIENTO INFRAESTRUCTURA'),('0130','OT -MANTENIMIENTO INFRAESTRUCTURA PLANTA'),('2001','OT -ADECUACIONES LOCATIVAS'),('2002','OT -MANTENIMIENTO Y REPARACION'),('2003','OT -SUMINISTROS'),('2004','AL- FUNDIR TAPA EN CONCRETO'),('3001','AS -FALLA EN LA RECOLECCION DEL SERVICIO'),('3002','AS -FALLA EN LA RECOLECCION DEL BARRIDO'),('3003','AS -NO SE REALIZO SERVICIO DE RECOLECCIO'),('3004','AS -RECOLECCION DE PODAS Y ESCOMBROS'),('0110','AS - REALIZAR AFORO ASEO'),('0111','AC - RETIRAR ACOMETIDA'),('0129','AC - SUSPENSION DEL SERVICIO'),('3005','CAMBIO MEDIDOR'),('3006','ARREGLO DOMICILIARIO'),('3007','OTROS'),('0117','AC- DESTAPONAMIENTO RED DOMICILIARIA'),('0131','AC- MANTENIMIENTO SUMIDERAS'),('0118','AC- REVISION MANTENIMIENTO VALVULAS CIRC'),('3008','AC- REPARACIÓN RED PRINCIPAL 3\"'),('0113','AC- INSTALACION SISTEMAS ASPERSORES'),('3009','AC- -DISTRIBUCIÓN CARROTANQUE'),('2005','AC- PROYECCIÓN NUEVA RED'),('2006','OT- MANTENIMIENTO DE VEHÍCULOS'),('3010','PRESUPUESTAR TRABAJOS'),('3011','INSPECCIÓN A LA LINEA DE CONDUCCION'),('3012','AC- MUESTREO'),('3013','OT-RECEPCION Y CORDINACION'),('3014','DESMONTE DE ASPERSORES'),('3015','AC - MANTENIMIENTO DE VÁLVULAS'),('3016','ALC- INSTALACION TUBERIA SANITARIA'),('3017','AC- CAMBIO VALVULA DE PURGA'),('3018','AC- REVISION RED PRINCIPAL'),('3019','AC- REPARACION FUGA DE AGUA EN PURGA'),('3020','AC- RELLENO CUBRIMIENTO'); /*!40000 ALTER TABLE `tidano` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tidocu` -- DROP TABLE IF EXISTS `tidocu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tidocu` ( `td_tidocu` char(2) NOT NULL, `td_descri` char(40) DEFAULT NULL, PRIMARY KEY (`td_tidocu`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tidocu` -- LOCK TABLES `tidocu` WRITE; /*!40000 ALTER TABLE `tidocu` DISABLE KEYS */; INSERT INTO `tidocu` (`td_tidocu`, `td_descri`) VALUES ('CC','Cedula de Ciudadania'),('CE','Cedula de Extranjeria'),('NI','NIT'); /*!40000 ALTER TABLE `tidocu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tipdis` -- DROP TABLE IF EXISTS `tipdis`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tipdis` ( `td_tipdis` char(2) NOT NULL, `td_descri` char(40) DEFAULT NULL, PRIMARY KEY (`td_tipdis`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tipdis` -- LOCK TABLES `tipdis` WRITE; /*!40000 ALTER TABLE `tipdis` DISABLE KEYS */; INSERT INTO `tipdis` (`td_tipdis`, `td_descri`) VALUES ('SO','SERVICIO ORDINARIO'); /*!40000 ALTER TABLE `tipdis` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tisalida` -- DROP TABLE IF EXISTS `tisalida`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tisalida` ( `ts_tisalida` char(2) NOT NULL, `ts_descri` char(40) DEFAULT NULL, PRIMARY KEY (`ts_tisalida`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tisalida` -- LOCK TABLES `tisalida` WRITE; /*!40000 ALTER TABLE `tisalida` DISABLE KEYS */; INSERT INTO `tisalida` (`ts_tisalida`, `ts_descri`) VALUES ('PP','PROCESO DE POTABILIZACION'),('PQ','SOLUCION PQR'),('SG','SALIDA GENERAL'),('CS','CORTE Y SUSPENSIONES'),('AS','ASEO, RECOLECCION Y BARRIDO'),('FN','FONTANERO'),('AD','ADMINISTRACION'),('DT','DOTACION'),('AL','ALCANTARILLADO'); /*!40000 ALTER TABLE `tisalida` 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_tidocu` char(2) NOT NULL, `tm_numdoc` char(12) NOT NULL, `tm_nomsol` char(40) NOT NULL, `tm_telsol` char(12) NOT NULL, `tm_celsol` char(30) NOT NULL, `tm_dirsol` char(40) NOT NULL, `tm_medio` char(1) 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_codbar` int(4) NOT NULL, `tm_origen` char(1) NOT NULL, `tm_tippqr` char(1) NOT NULL, `tm_numpqr` int(9) NOT NULL, `tm_nromat` int(10) NOT NULL, `tm_cobrar` char(1) NOT NULL, PRIMARY KEY (`tm_numero`), KEY `tm_tidano` (`tm_tidano`), KEY `tm_tidocu` (`tm_tidocu`), KEY `tm_codare` (`tm_codare`), KEY `tm_codbar` (`tm_codbar`) ) 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_tidocu`, `tm_numdoc`, `tm_nomsol`, `tm_telsol`, `tm_celsol`, `tm_dirsol`, `tm_medio`, `tm_estado`, `tm_califi`, `tm_feccon`, `tm_horcon`, `tm_codbar`, `tm_origen`, `tm_tippqr`, `tm_numpqr`, `tm_nromat`, `tm_cobrar`) VALUES (1,2,'0053','2022-04-28','11:38:55','CC','19516006','OMAR NORIEGA MEJIA','3145956763','','CALLE 1','V','C','1','2022-06-30','02:47:50',1,'P','Q',3,2013300,''),(2,2,'0053','2022-04-28','03:26:43','CC','19516006','OMAR NORIEGA MEJIA','3145956763','','CALLE 1','V','C','1','2022-06-30','03:38:15',1,'P','Q',3,2013300,'N'),(3,1,'0125','2022-05-05','08:41:27','CC','3769003','TEOFILO MENDINUETA','3205393725','','CLL 7 23 DE ABRIL','V','C','1','2022-06-06','10:32:22',1,'P','P',1,8066600,''),(4,1,'0094','2022-05-05','08:50:08','CC','3769003','TEOFILO MENDINUETA','3205393725','','CLL 7 23 DE ABRIL','V','C','1','2022-06-30','03:45:50',1,'P','P',0,0,'N'),(5,2,'0067','2022-05-19','03:10:53','CC','5123910','SIMON GARCIA','3012214726','','CAMINO A MOLER','V','C','1','2022-06-30','04:06:22',2,'P','Q',5,0,''),(6,1,'0043','2022-05-26','10:11:33','CC','57115775','ROSMIRI OROZCO','3223929926','','CLL 4.4','E','C','1','2022-06-06','10:30:26',15,'P','Q',6,6048650,''),(7,2,'0078','2022-05-26','11:32:07','CC','18053873','ASTRID RANGEL','3116819571','','CON DIOS Y EL PUEBLO','V','C','1','2022-05-27','04:12:21',14,'P','Q',8,0,''),(8,1,'0125','2022-05-27','03:33:08','CC','0000000','HUGO CASTILLO GOMEZ','000000','','CLL 6 # 11-12','E','C','1','2022-06-30','04:09:38',9,'P','Q',9,6043451,''),(9,2,'0023','2022-05-27','03:54:44','CC','0000','TOMAS ESCOBAR','00000','','CALLE 5#10.02','V','C','1','2022-06-30','03:08:28',4,'P','Q',11,3016700,''),(10,2,'0064','2022-06-14','10:03:31','CC','','MORE MOLINA REYES','3116966986','','CALLE 5 # 8-121','T','C','3','2022-06-30','03:41:52',4,'P','Q',14,3017500,'N'),(11,2,'0053','2022-07-05','09:03:41','CC','57115177','MARIA PERSI PUA','','','CLL 1 # 14 -25','V','A','','0000-00-00','00:00:00',6,'P','Q',15,5034850,''),(12,1,'0094','2022-07-21','09:26:15','CC','19515266','NAYID JARABA','3007355885','','KR 12 4-05 CLL.','V','C','1','2022-08-01','09:24:02',6,'P','Q',16,5029200,''),(13,2,'0053','2022-07-27','09:12:27','CC','','ALBARO MONTECINO','','','23 DE ABRIL','V','C','1','2022-08-01','09:15:53',15,'P','Q',17,0,'N'),(14,1,'0082','2022-11-08','09:55:30','CC','','JOSE VARELA CERVANTES','','','C..E 1 CLL 6-6','V','P','','0000-00-00','00:00:00',6,'P','Q',18,5038022,''),(15,1,'0098','2022-11-09','09:55:30','CC','49771030','BALDOMERO ANAYA CORDOBA','3046097109','','CALLE 7-7','V','P','','0000-00-00','00:00:00',15,'P','Q',19,8063650,''),(16,1,'0093','2024-02-22','11:03:49','CC','1079656208','YOLANDA BUELVA','','','BARRIO 20 DE JULIO','V','C','3','2024-04-25','05:10:50',6,'P','P',2,0,''),(17,3,'0093','2024-02-23','10:33:36','CC','1079656208','YOLANDA BUELVA','','','BARRIO 20 DE JULIO','V','C','3','2024-04-25','05:13:52',6,'P','P',2,0,''),(18,3,'0093','2024-02-23','11:04:15','CC','1079656208','YOLANDA BUELVA','','','BARRIO 20 DE JULIO','V','C','3','2024-04-26','09:18:10',6,'P','P',2,0,''),(19,4,'0093','2024-02-26','09:45:59','CC','57116477','EMILIA GARCIA','3148003576','','20 DE JULIO','T','C','1','2024-04-26','09:27:51',6,'P','Q',22,0,''),(20,2,'0030','2024-02-26','11:43:59','CC','1067726112','JUAN MANUEL SIERRA','3145390452','','JUAQUIN ANAYA','T','C','1','2024-05-08','08:36:12',18,'P','Q',24,0,''),(21,4,'0049','2024-02-19','05:14:18','CC','19518329','ADAN TORE','3023047243','','20 DE JULIO','V','C','1','2024-04-26','09:46:28',6,'P','Q',0,0,''),(22,4,'0049','2024-02-19','05:24:35','CC','19518329','ADAN TORE','3023047243','','20 DE JULIO','V','C','1','2024-04-25','11:17:37',6,'P','Q',0,0,''),(23,2,'0053','2024-02-27','08:43:18','CC','19516273','LUIS ALBERTO ARIAS BERMUDEZ','','','Kr 18No 905','V','C','1','2024-04-26','09:50:41',4,'P','Q',25,0,''),(24,2,'0030','2024-02-27','09:20:25','CC','1079660622','DISNEY NORIEGA TORRIJOS','3106120829','','ALTO PRADO','V','C','1','2024-04-25','11:02:50',8,'P','Q',26,0,''),(25,4,'0002','2024-02-27','09:43:44','CC','5068194','LUIS MARRIAGA CANO','3116843671','','CALLE CENTRAL','V','C','1','2024-04-25','02:43:51',4,'P','Q',27,0,''),(26,4,'0043','2024-02-28','10:05:14','CC','1079654531','lLINETH IBARRA VARELA','3215429299','','calle 12#10-69','V','C','1','2024-04-26','09:56:52',15,'P','Q',28,0,''),(27,4,'0093','2024-03-06','05:14:40','CC','7595610','DANIEL BELTRAN','','','calle central','V','C','3','2024-04-25','02:48:43',4,'P','Q',30,0,''),(28,4,'0093','2024-03-13','09:03:12','CC','57290870','luz mila castillo','','','20 de julio','V','C','3','2024-05-09','08:21:52',6,'P','Q',31,0,''),(29,4,'0098','2024-04-04','09:52:08','CC','1079654967','ELIZABETH SUAREZ SUAREZ','','','20 DE JULIO','V','C','1','2024-04-26','10:11:12',6,'P','Q',33,0,''),(30,2,'0023','2024-04-05','08:24:52','CC','5122230','HUGO HERRERA NAVARRO','3226786868','','ALTO PRADO','V','C','1','2024-04-25','03:03:10',8,'P','Q',35,0,''),(31,2,'0030','2024-04-05','08:39:41','CC','45501372','ISABEL PIMIENTA','3178827279','','CALLE CENTRAL','V','C','1','2024-04-25','03:08:22',4,'P','Q',36,0,'N'),(32,1,'0043','2024-04-22','10:30:50','CC','1079659654','KELLYS VARELA CARRANZA','324475710','','DIOS Y EL PUEBLO','V','C','1','2024-05-08','02:41:18',14,'P','Q',41,0,''),(33,1,'0002','2024-04-23','11:56:05','CC','57117043','LISSIE LLAMAS MORALES','','','FRANCISCANA','V','C','1','2024-04-25','03:30:33',9,'P','Q',42,0,''),(34,1,'0098','2024-04-23','02:44:32','CC','57299535','KATTERINE PEZANO','3217876595','','el progreso','T','C','1','2024-05-08','02:54:40',11,'P','Q',43,0,''),(35,1,'0088','2024-04-25','10:31:03','CC','1079662162','MARTIN ANDRADE CASTRO','3003251002','','CALLE 5 kRA 5 No 16','V','C','1','2024-05-29','10:00:09',9,'P','P',4,0,''),(36,1,'0088','2024-04-25','10:36:25','CC','1079662162','MARTIN ANDRADE CASTRO','3003251002','','CALLE 5 kRA 5 No 16','V','C','1','2024-05-29','10:01:42',6,'P','P',5,0,''),(37,2,'0053','2024-05-02','10:53:23','CC','57117646','MNARITZA MELENDEZ','3104059921','','SANTA CATALINA','T','C','1','2024-05-08','03:01:39',3,'P','Q',45,0,''),(38,2,'0023','2024-05-03','10:56:19','CC','57116923','ANA PEREZ RAMOS','3128981854','','VILLA LILI','V','C','1','2024-05-08','03:03:33',10,'P','Q',68,0,''),(39,1,'0088','2024-05-06','10:26:16','CC','1079657185','JORGE LUIS GUTIERREZ','3023801203','','PROGRESO','V','C','1','2024-05-27','09:54:11',11,'P','Q',69,0,''),(40,1,'0043','2024-05-08','03:19:38','CC','57115628','CASTA MARIA CONTRERAS MEJIA','','','23 DE ABRIL','V','P','','0000-00-00','00:00:00',15,'P','Q',70,0,''),(41,1,'0002','2024-05-15','10:55:09','CC','19519044','DEIVIS GAMARRA','3205158504','','ALTO PRADO','V','C','1','2024-05-29','10:12:22',8,'P','Q',72,0,''),(42,1,'0076','2024-05-20','08:52:00','CC','19515324','HUGO DE AVILA ANDRADE','3042819276','','STA CATALINA','V','C','1','2024-05-27','10:30:10',3,'P','Q',73,0,''),(43,1,'0102','2024-05-23','10:40:22','CC','57116237','DAMARIS DE ORO OSPINO','3023219113','','CON DIOS Y EL PUEBLO','V','C','1','2024-05-29','10:20:39',14,'P','Q',75,0,''),(44,1,'0043','2024-05-23','10:53:47','CC','39100361','MILADYS CERPA ALMEIRA','','','','V','C','1','2024-05-29','09:55:12',17,'P','Q',77,0,''),(45,1,'0117','2024-05-24','02:50:29','CC','57116358','JOSEFA BRIEVA','','','fransiscana','T','P','','0000-00-00','00:00:00',9,'P','Q',78,0,''),(46,1,'0002','2024-05-24','03:57:22','CC','1079661130','MELISSA ARRAZOLA RAMOS','3045468345','','23 DE ABRIL','V','P','','0000-00-00','00:00:00',15,'P','Q',79,0,''),(47,1,'0002','2024-05-27','09:41:08','CC','1079661130','MELISSA ARRAZOLA RAMOS','3045468345','','23 DE ABRIL','V','P','','0000-00-00','00:00:00',15,'P','Q',80,0,''),(48,1,'0002','2024-05-27','09:49:51','CC','19512250','ANTONIO SIMANCA VILLALBA','','','23 DE ABRIL','V','P','','0000-00-00','00:00:00',15,'P','Q',81,0,''),(49,1,'0088','2024-05-31','10:23:13','CC','26696760','NURYS ESTHER BLANCO MARTINEZ','','','20 DE JULIO','V','P','','0000-00-00','00:00:00',6,'P','P',6,0,''),(50,2,'0030','2024-06-14','10:36:39','CC','1079658300','MARIA HURTADO TORRIJO','','','20 de julio','T','P','','0000-00-00','00:00:00',6,'P','Q',84,0,''),(51,1,'0002','2024-06-17','11:06:41','CC','','CARLOS ANAYA','3108347851','','23 de abril','T','P','','0000-00-00','00:00:00',15,'P','Q',85,0,''); /*!40000 ALTER TABLE `tramites` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tuberias` -- DROP TABLE IF EXISTS `tuberias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tuberias` ( `tb_numero` int(9) NOT NULL, `tb_codpro` char(2) NOT NULL, `tb_codduc` char(2) NOT NULL, `tb_codmat` char(2) NOT NULL, `tb_seccion` char(2) NOT NULL, `tb_cantid` float(9,2) NOT NULL DEFAULT '0.00', `tb_diamet` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`tb_numero`,`tb_codpro`,`tb_codduc`,`tb_codmat`), KEY `tb_numero` (`tb_numero`), KEY `tb_codpro` (`tb_codpro`), KEY `tb_codduc` (`tb_codduc`), KEY `tb_codmat` (`tb_codmat`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tuberias` -- LOCK TABLES `tuberias` WRITE; /*!40000 ALTER TABLE `tuberias` DISABLE KEYS */; /*!40000 ALTER TABLE `tuberias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tvehiculos` -- DROP TABLE IF EXISTS `tvehiculos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tvehiculos` ( `tv_numero` int(9) NOT NULL, `tv_codveh` char(6) NOT NULL, `tv_fecini` date DEFAULT NULL, `tv_horini` time DEFAULT NULL, `tv_fecfin` date DEFAULT NULL, `tv_horfin` time DEFAULT NULL, `tv_vlract` float(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`tv_numero`,`tv_codveh`), KEY `tv_numero` (`tv_numero`), KEY `tv_codveh` (`tv_codveh`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tvehiculos` -- LOCK TABLES `tvehiculos` WRITE; /*!40000 ALTER TABLE `tvehiculos` DISABLE KEYS */; INSERT INTO `tvehiculos` (`tv_numero`, `tv_codveh`, `tv_fecini`, `tv_horini`, `tv_fecfin`, `tv_horfin`, `tv_vlract`) VALUES (13,'CARM','2022-07-30','00:00:11','2022-07-30','11:15:00',0.00); /*!40000 ALTER TABLE `tvehiculos` 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(8) 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(8) 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; -- -- Table structure for table `vehiculo` -- DROP TABLE IF EXISTS `vehiculo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehiculo` ( `vh_codveh` char(6) NOT NULL, `vh_descri` char(40) NOT NULL DEFAULT '', `vh_vlrhor` decimal(9,2) NOT NULL DEFAULT '0.00', `vh_vlrrec` decimal(9,2) NOT NULL DEFAULT '0.00', PRIMARY KEY (`vh_codveh`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vehiculo` -- LOCK TABLES `vehiculo` WRITE; /*!40000 ALTER TABLE `vehiculo` DISABLE KEYS */; INSERT INTO `vehiculo` (`vh_codveh`, `vh_descri`, `vh_vlrhor`, `vh_vlrrec`) VALUES ('100','EQUPO VACTOR',100000.00,20.00),('101','RETROESCABADORA CASE 210',0.00,0.00),('CARM','CARROMOTO',0.00,0.00),('105','PULIDORA PEQUEÑA',0.00,0.00),('103','BOMBA SUMERGIBLE',0.00,0.00),('104','PULIDORA GRANDE',0.00,0.00),('102','TALADRO',0.00,0.00); /*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'antsoftw_chivolo_operativo' -- -- -- Dumping routines for database 'antsoftw_chivolo_operativo' -- /*!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:32:50