-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64) -- -- Host: localhost Database: antsoftw_ricaurte_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 Acueducto'),(2,'Division Operativa Alcantarillado'),(3,'Division Operativa Aseo'),(4,'Acueducto Cortes y Suspensiones'),(5,'Comercial'),(6,'Division Tecnica Operartiva Energia'); /*!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 (3,'EL PESEBRE RCTE'),(4,'COND. GUAYACANES RCTE'),(5,'URB. LA HACIENDA RCTE'),(7,'COND. CASA DE CAMPO RCTE'),(10,'CONJ. BOSQUES DE PENALISA'),(11,'URB. TOGORAMA RCTE'),(12,'VIA LOS MANUELES RCTE'),(21,'VEREDA EL PASO RCTE'),(25,'SOL ARDIENTE RCTE'),(28,'URB. LOS OCOBOS RCTE'),(34,'COND. CAMPESTRE SAN ESTEBAN'),(35,'COND. LOS ALMENDROS RCTE'),(37,'VDA. SAN MARTIN'),(38,'VILLA DIANA CAROLINA'),(53,'CONJUNTO MIRARRIOS'),(70,'COND.CLARO DE LUNA'),(76,'CONDOMINIO PORTAL DE PE?ALISA'),(77,'CONDOMINIO LA PRADERA'),(78,'CONJ RESIDENCIAL VILLA DIANA'),(81,'CONDOMINIO LAS HELICONIAS'),(83,'PUERTO TRANQUILO'),(85,'LAS PALMAS HACIENDA PE?ALISA'),(86,'CONJ. VALKINA RESIDENCE CLUB'),(89,'CONJ. RES. OCOBO HDA PE?ALISA'),(90,'CONJ. RES. BAMBU HDA PE?ALISA'),(93,'CONDOMINIO CABO VERDE'),(94,'CONDOMINIO CABO VERDE PRAIA'),(95,'CONDOMINIO CABO VERDE RIVEIRA'),(96,'CONJUNTO CARANDAY LAS PALMAS'),(97,'CONJ. RES. ALMENDRO HDA PE?ALI'),(98,'CONJ. RES. CEIBA HDA PE?ALISA'),(100,'CONJ. RES. TAGUA HDA PE?ALISA'),(101,'CONJ. RES. BALSO HDA PE?ALISA'),(102,'CONJUNTO ROSARIO - LAS PALMAS'),(109,'COND. BAHIA SOLERO MALAGA'),(110,'COND. BAHIA SOLERO - TORROSA'),(111,'CONJUNTO CARIOTA LAS PALMAS'),(112,'CONJ.RES. PENAZUL LA VILLA'),(113,'CONJ.RES. PENAZUL LA MORADA'),(1023,'CONJ. PUERTO AZUL CLUB HOUSE'),(1051,'CONJ. RES. BRISAS DE ABRIL'),(1052,'CONJ. RES. MANGO HDA PE?ALISA'),(1082,'CENTRO COMERCIAL PENALISA MALL'),(1095,'CONJUNTO CANARIA - LAS PALMAS'),(1112,'RICAURTE'),(1157,'HACIENDA PENALISA - GUADUA'),(1158,'CONJ. RES. PENAZUL LA ALDEA'),(1159,'CONDOMINIO ALAMEDA DEL SOL'),(1160,'CONDONIMIO CABO VERDE PORTONOVO'),(1161,'CONJ. RES. LIMONAR HDA PE?ALISA'),(1165,'AQUALINA SUN'); /*!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 */; INSERT INTO `cierres` (`ci_suspen`, `ci_numero`, `ci_codsec`, `ci_tipsus`, `ci_fecini`, `ci_horini`, `ci_fecfin`, `ci_horfin`, `ci_tiempo`) VALUES (1,2,1,1,'2021-03-09','06:05:00','2021-03-09','07:05:00','01:00:00'); /*!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 */; /*!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); /*!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'),('4',' Energia Redes de baja tension'),('5','Redes de alta tension'); /*!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 ('xxxx','xxxxx','xxxx','ccc',19); /*!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 ('900639486-4','ALCARI S.A.S. E.S.P.','CL 9 16 84','8366621'); /*!40000 ALTER TABLE `empresa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `festivos` -- DROP TABLE IF EXISTS `festivos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `festivos` ( `fecfes` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`fecfes`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `festivos` -- LOCK TABLES `festivos` WRITE; /*!40000 ALTER TABLE `festivos` DISABLE KEYS */; INSERT INTO `festivos` (`fecfes`) VALUES ('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,'Revision y reposicion de la red de alcantarillado sanitario del sector'),(2,' HACER VISITA TECNICA AL HOTEL PENALISA COLSUBSIDIO '); /*!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 */; /*!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,'FONTANERO',3106.00,3882.00),(2,'AUXILIAR ADMINISTRATIVOS',3106.00,3882.00),(3,'LABORATORISTA',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,'OPERARIO DE ALCANTARILLADO',3000.00,2500.00),(13,'Monitor de Redes',4063.00,5078.00),(14,'ALBAÑIL',3106.00,3882.00),(15,'TECNICO ELECTRICISTA',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),(19,'OPERARIOS',0.00,0.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 (1,143,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 ('asexis','Asexis Soporte','Asexis'),('1069175333','HERNANDEZ XIMENA','AUX 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',2),('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 */; /*!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-09-29','11:12:26','asexis','Registro'),(2,0,'2022-10-24','03:09:30','1069175333','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 */; /*!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 ('2001','AL -ACOMETIDA NUEVA ALCANTARILLADO'),('2002','AL -ARREGLO DE POZO DE INSPECCION DE ALC'),('2003','AL -BRIGADA LIMPIEZA RED PPAL ALCAN. DET'),('2004','AL -CAJA DE INSPECCION DOMICILIARIA COLA'),('2005','AL -CONSTRUCCION POZO DE INSPECCION'),('2006','AL -DANO RED MATRIZ ALCANTARILLADO'),('2007','AL -DANO RED MATRIZ ALCANTARILLADO'),('2008','AL -FUGA DOMICILIARIA ALCANTARILLADO'),('2009','AL- FUNDIR TAPA EN CONCRETO'),('2010','AL -HUNDIMIENTO DE VIA ALCANTARILLADO'),('2011','AL -INST.ARO TAPA TRAFICO PESADO'),('2012','AL -INSTALACION REJILLA'),('2013','AL -INSTALACION TAPA POZO'),('2014','AL -LAVADO RED MATRIZ'),('2015','AL -LIMPIEZA DE POZO'),('2016','AL -LIMPIEZA Y SONDEO POZOS DE INSPECCIO'),('2017','AL -MANTENIMIENTO DE ALCANTARILLADO'),('2018','AL -POZO COLAPSADO'),('2019','AL -POZO REBOSADO'),('2020','AL -POZO TAPADO'),('2021','AL -REALIZAR APIQUE'),('2022','AL -RECONSTRUCCION POZO DE INSPECCION'),('2023','AL -RECUPERACION DE ANDEN ALCANTARILLADO'),('2024','AL -RECUPERACION EN ASFALTO ALCANTARILLA'),('2025','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('2026','AL -RECUPERACION EN RECEBO ALCANTARILLAD'),('2027','AL -RED COLAPSADA'),('2028','AL -REPARACION RED DE ALCANTARILLADO'),('2029','AL -REPOSICION RED DOMICILIARIA'),('2030','AL -RETIRO ESCOMBROS ALCANTARILLADO'),('2031','AL -REVISION TECNICA DE ALCANTARILLADO'),('2032','AL -ROTURA TAPA POZO DE INSPECCION ALCAN'),('2033','AL -SONDEO Y LIMPIEZA RED MATRIZ ALCANTA'),('2034','AL -TAPONAMIENTO DOMICILIARIA ALCANTARIL'),('2035','AL -VISITA TECNICA ALCANTARILLADO'),('2036','AL- INSTALACION TUBERIA SANITARIA'),('2037','AL -ARREGLO DOMICILIARIO'),('3001','AS - REALIZAR AFORO ASEO'),('3002','AS -BRIGADAS MANUALES'),('3003','AS -FALLA EN LA PRESTACION DE SERVICIO A'),('3004','AS -FALLA EN LA RECOLECCION DEL BARRIDO'),('3005','AS -FALLA EN LA RECOLECCION DEL SERVICIO'),('3006','AS -NO SE REALIZO SERVICIO DE RECOLECCIO'),('3007','AS -RECOLECCION DE PODAS Y ESCOMBROS'),('3008','AS -REVISAR SI AL PREDIO T.EL SERVICIO A'),('3009','AS -VISITA VERIFICACION DESHABITADO'),('5001','OT -ADECUACIONES LOCATIVAS'),('5002','OT -INSTALACION PASACALLE'),('5003','OT- MANTENIMIENTO DE VEHÍCULOS'),('5004','OT -MANTENIMIENTO INFRAESTRUCTURA'),('5005','OT -MANTENIMIENTO INFRAESTRUCTURA PLANTA'),('5006','OT -MANTENIMIENTO Y REPARACION'),('5007','OT -RECUPERACION EN ASFALTO ACUEDUCTO'),('5008','OT -RECUPERACION EN CONCRETO'),('5009','OT -RECUPERACION EN CONCRETO ACUEDUCTO'),('5010','OT -RECUPERACION EN RECEBO ACUEDUCTO'),('5011','OT -REPOSICION VIA PAVIMENTO FLEXIBLE'),('5012','OT -REPOSICION VIAA PAVIMENTO RIGIDO'),('5013','OT -SUMINISTROS'),('5014','OT-RECEPCION Y CORDINACION'),('4001','EN - AHOYADA PARA POSTES'),('4002','EN - APLOMADA DE POSTES'),('4003','EN - BALANCEO DE CARGA EN TRANSFORMADORE'),('4004','EN - CAMBIO DE AISLADORES DE CARRETO'),('4005','EN - CAMBIO DE AISLADORES DE ESPIGO'),('4006','EN - CAMBIO DE AISLADORES DE SUSPENSI?N'),('4007','EN - CAMBIO DE AISLADORES DE TENSI?N'),('4008','EN - CAMBIO DE CAJILLA TIPO LONCHERA'),('4009','EN - CAMBIO DE CA?UELAS'),('4010','EN - CAMBIO DE CORTACIRCUITOS'),('4011','EN - CAMBIO DE CRUCETAS'),('4012','EN - CAMBIO DE CRUCETAS'),('4013','EN - CAMBIO DE FUSIBLES'),('4014','EN - CAMBIO DE PARARRAYOS'),('4015','EN - CAMBIO O INSTALACI?N DE CONECTORES'),('4016','EN - CONEXIONES'),('4017','EN - CONSTRUCCICON DE RETENIDAS'),('4018','EN - CONSTRUCCION DE REDES DE BAJA TENSI'),('4019','EN - CONSTRUCCION DE REDES DE MEDIA TENS'),('4020','EN - CONTROL DE VEGETACION'),('4021','EN - CORTES'),('4022','EN - DESMONTAR TRANSFORMADORES'),('4023','EN - ENTREGA DE FACTURACI?N'),('4024','EN - HINCADA DE POSTES DE 12 METROS'),('4025','EN - HINCADA DE POSTES DE 8 METROS'),('4026','EN - INSTALACI?N DE PUESTAS A TIERRA'),('4027','EN - IZAR TRANSFORMADOR'),('4028','EN - MANTENIMIENTO A LA SUBESTACION'),('4029','EN - OTROS'),('4030','EN - RECONEXIONES'),('4031','EN - RETENCIONAMIENTO DE REDES DE BAJA'),('4032','EN - RETENCIONAMIENTO DE REDES DE MEDIA'),('4033','EN - RETIEMPLA DE RETENIDAS'),('4034','EN - RETOMAS DE LECTURA'),('4035','EN - REVISIONES DE ENERGIA FRAUDE'),('4036','EN - REVISIONES POR FALLA DE ENERG?A'),('4037','EN - SUSPENSIONES'),('4038','EN - TOMA DE LECTURAS'),('4039','EN - VESTIDA DE POSTES'),('4040','EN - VISITA PARA REVISI?N FRAUDE'),('4041','EN - VISITAS POR ALTO CONSUMO'),('4042','EN - VISITA DE NUEVA CONEXIÓN'),('4043','EN - MANTENIMIENTO REDES DE MEDIA'); /*!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,'2027','2022-09-29','11:12:26','CC','0','ALCARI','0','0','CLL 9 ENTRE CRA 16-17','V','P','','0000-00-00','00:00:00',1112,'M','P',0,0,''),(2,2,'2010','2022-10-24','03:09:30','CC','80367370','WILLIAM ALBERTO RAMIREZ ALVAREZ','3167807666','WILLIAM.RAMIREZAL@COLSUBSIDIO.','HOTEL PENALISA COLSUBSIDIO','E','P','','0000-00-00','00:00:00',1112,'P','Q',2,2,''); /*!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 */; /*!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','CAMIONETA',0.00,0.00); /*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'antsoftw_ricaurte_operativo' -- -- -- Dumping routines for database 'antsoftw_ricaurte_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:40:37