-- MySQL dump 10.13 Distrib 5.5.52, for Linux (x86_64) -- -- Host: localhost Database: antsoftw_sanangel_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,'SABANAS DE SAN ANGEL'),(2,'7 DE AGOSTO'),(3,'8 DE DICIEMBRE'),(4,'ALTO PRADO'),(5,'BRISAS DE JERICO'),(6,'CASA DE TABLA'),(7,'CENTRO'),(8,'COREA'),(9,'EL CAMPITO'),(10,'EL TAMARINDO'),(11,'FLORES DE MARIA'),(12,'LA FLORIDA'),(13,'LOS NOGALES'),(14,'LOS OLIVOS'),(15,'MANANTIAL'),(16,'MINUTO DE DIOS'),(17,'MONTERUBIO'),(18,'POZO LLORAO'),(19,'PUERTO AMOR'),(20,'SAN NICOLAS'),(21,'VILLA CARMELA'),(22,'VILLA CLAUDIA'),(23,'VILLA DANIELA'),(24,'VILLA SONIA'); /*!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 ('47660','SABANAS DE SAN ANGEL'); /*!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'); /*!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','SABANAS DE SAN ANGEL','','',5); /*!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 ('901764329-4','SERVISANANGEL ESP S.A.S.','CL 6 No. 5-55 B. 7 de Agosto','3106620864'); /*!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 (3,' SE EVIDENCIO DOS FUGAS EN SANITARIOS Y PERIODICAMENTE OFRECE SERVICIO DE HOSPEDAJE '),(4,' SE EVIDENCIO DOS FUGAS EN SANITARIOS Y PERIODICAMENTE OFRECE SERVICIO DE HOSPEDAJE '); /*!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,'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); /*!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 */; /*!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'),('1063948211','RAFAEL AUGUSTO ESCOBAR DE LA CERDA','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',4),('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 ('058','ARIGUANI - MAGDALENA','47058','47058'); /*!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 (3,0,'2025-10-15','02:58:54','1063948211','Registro'),(4,0,'2025-10-15','03:12:45','1063948211','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 ('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 (3,1,'3007','2025-10-15','02:58:54','CC','42492234','Silvana Ballestero','3104321536','servisangelsp@gmail.com','KA 3 N? 1B-56','V','P','','0000-00-00','00:00:00',20,'P','R',10,1060,''),(2,1,'0094','2021-08-12','11:50:56','CC','19586947','WILMAN GOERING FONTALVO','3117939194','','CARRERA 2 # 9-57','V','C','1','2021-08-26','10:27:44',8,'P','R',3,1002050,'N'),(1,1,'0094','2021-03-11','09:57:05','CC','1082240023','GUSTAVO RAFAEL ORTIZ POLO','3203182853','','CL. 11 No. 3-20','V','C','1','2021-03-15','03:36:04',13,'P','R',2,10084002,'N'),(4,1,'3007','2025-10-15','03:12:45','CC','42492234','Silvana Ballestero','3104321536','servisangelsp@gmail.com','KA 3 N? 1B-56','V','P','','0000-00-00','00:00:00',20,'P','R',10,1060,''); /*!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','EQUPO VACTOR',100000.00,20.00),('101','RETROESCABADORA CASE 210',0.00,0.00); /*!40000 ALTER TABLE `vehiculo` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'antsoftw_sanangel_operativo' -- -- -- Dumping routines for database 'antsoftw_sanangel_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:39:57