Gecko [ www.utparral.edu.mx ]

Name	Size	Permission
administrador	[ DIR ]	drwxrwxr-x
componentes	[ DIR ]	drwxrwxr-x
conexion	[ DIR ]	drwxrwxr-x
css	[ DIR ]	drwxrwxr-x
imagenes	[ DIR ]	drwxrwxr-x
js	[ DIR ]	drwxrwxr-x
librerias	[ DIR ]	drwxrwxr-x
reportes	[ DIR ]	drwxrwxr-x
servicios	[ DIR ]	drwxrwxr-x
sesiones	[ DIR ]	drwxrwxr-x
index.php	869 B	-rwxrwxr-x
str.sql	7.87 KB	-rwxrwxr-x

Code Editor : str.sql

-- MySQL dump 10.13  Distrib 5.7.28, for Linux (i686)
--
-- Host: localhost    Database: str
-- ------------------------------------------------------
-- Server version	5.7.28-0ubuntu0.16.04.2

/*!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 `cotizaciones`
--

DROP TABLE IF EXISTS `cotizaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cotizaciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cliente` varchar(500) NOT NULL,
  `proyecto` varchar(500) NOT NULL,
  `descripcion` varchar(500) NOT NULL,
  `tiempo_entrega` date NOT NULL,
  `version_padre` int(10) unsigned NOT NULL,
  `total` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cotizaciones`
--

LOCK TABLES `cotizaciones` WRITE;
/*!40000 ALTER TABLE `cotizaciones` DISABLE KEYS */;
INSERT INTO `cotizaciones` VALUES (1,'2020-01-24 07:20:12','kk','sksk','kks','2020-01-23',0,5444),(2,'2020-01-24 07:20:48','kk','sksk','kk','2020-01-15',0,5444),(3,'2020-01-24 07:21:48','kk','sksk','kk','2020-01-15',0,5444),(4,'2020-01-24 07:43:47','ppp','pppp','ppp','2020-01-31',0,5444),(5,'2020-01-24 07:46:22','dd','ss`','dd','2020-01-08',0,5444),(6,'2020-01-24 17:40:00','o','','oo','2020-01-15',0,5444),(7,'2020-01-24 17:54:33','o','','oo','2020-01-15',0,5444),(8,'2020-01-24 17:56:47','jj','jjj','jj','2020-01-22',0,5444),(9,'2020-01-24 17:59:15','boston dynamics','prueba','mi prueba','2020-01-30',0,5444),(10,'2020-01-24 18:03:58','boston dynamics','prueba','mi prueba','2020-01-30',0,5444),(11,'2020-01-24 18:50:12','taco bell','maquina automatica de tacos','maquina con actuadores de carne','2020-01-22',0,5444),(12,'2020-01-24 18:59:11','automation','nuevo','prueba automatizacion','2020-01-15',0,5444),(13,'2020-01-24 19:02:04','wwww','www','wwww','2020-01-22',0,5444),(14,'2020-01-24 19:04:02','o','ooo','oo','2020-01-23',0,5444),(15,'2020-01-24 19:05:23','j','jjj','jj','2020-01-30',0,5444),(16,'2020-01-24 19:06:26','o','oo','oo','2020-01-23',0,5444);
/*!40000 ALTER TABLE `cotizaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `materiales`
--

DROP TABLE IF EXISTS `materiales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `materiales` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) NOT NULL,
  `descripcion` varchar(300) NOT NULL,
  `medida` varchar(100) NOT NULL,
  `precio` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `materiales`
--

LOCK TABLES `materiales` WRITE;
/*!40000 ALTER TABLE `materiales` DISABLE KEYS */;
INSERT INTO `materiales` VALUES (1,'plc','plc siemens','pieza',1500),(2,'plc siemens','plc siemens negro','pieza',17000),(3,'cable 8 pulgadas','negro','metro',567),(4,'cable 5\"','rojo','metro',34);
/*!40000 ALTER TABLE `materiales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `materiales_cotizaciones`
--

DROP TABLE IF EXISTS `materiales_cotizaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `materiales_cotizaciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cotizacion` int(10) unsigned NOT NULL,
  `id_material` int(10) unsigned NOT NULL,
  `cantidad` int(10) unsigned NOT NULL,
  `monto` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `materiales_cotizaciones`
--

LOCK TABLES `materiales_cotizaciones` WRITE;
/*!40000 ALTER TABLE `materiales_cotizaciones` DISABLE KEYS */;
INSERT INTO `materiales_cotizaciones` VALUES (1,9,1,2,3000),(2,9,2,3,51000),(3,10,1,2,3000),(4,10,2,3,51000),(5,11,1,1,1500),(6,11,2,1,17000),(7,11,3,1,567),(8,12,1,2,3000),(9,12,4,3,102),(10,13,2,1,17000),(11,14,1,1,1500),(12,15,1,1,1500),(13,16,2,2,34000),(14,16,1,2,3000);
/*!40000 ALTER TABLE `materiales_cotizaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicios`
--

DROP TABLE IF EXISTS `servicios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `servicios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) NOT NULL,
  `descripcion` varchar(300) NOT NULL,
  `periodo` varchar(200) NOT NULL,
  `precio` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicios`
--

LOCK TABLES `servicios` WRITE;
/*!40000 ALTER TABLE `servicios` DISABLE KEYS */;
INSERT INTO `servicios` VALUES (1,'diseno de maquina','disenar maquina','semana',30000),(2,'soldadura','soldadura industrial','dia',1200);
/*!40000 ALTER TABLE `servicios` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicios_cotizaciones`
--

DROP TABLE IF EXISTS `servicios_cotizaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `servicios_cotizaciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cotizacion` int(10) unsigned NOT NULL,
  `id_servicio` int(10) unsigned NOT NULL,
  `periodos` int(10) unsigned NOT NULL,
  `monto` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicios_cotizaciones`
--

LOCK TABLES `servicios_cotizaciones` WRITE;
/*!40000 ALTER TABLE `servicios_cotizaciones` DISABLE KEYS */;
INSERT INTO `servicios_cotizaciones` VALUES (1,11,1,1,30000),(2,11,2,2,2400),(3,12,1,3,90000),(4,12,2,3,3600),(5,13,2,2,2400),(6,14,1,3,90000),(7,15,1,2,60000),(8,16,1,2,60000);
/*!40000 ALTER TABLE `servicios_cotizaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuarios`
--

DROP TABLE IF EXISTS `usuarios`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuarios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(400) NOT NULL,
  `usuario` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuarios`
--

LOCK TABLES `usuarios` WRITE;
/*!40000 ALTER TABLE `usuarios` DISABLE KEYS */;
INSERT INTO `usuarios` VALUES (1,'omar alfredo garcia soto','omarg','09f67d669f4f57ce976e2730463ddce3bd038e0b');
/*!40000 ALTER TABLE `usuarios` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2020-01-24 12:34:32

${this.title}

Code Editor : str.sql