/*
SQLyog Ultimate v9.63 
MySQL - 5.0.45-community-nt : Database - sisgo
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`sisgo` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `sisgo`;

/*Table structure for table `tejeduria_auditoria_formato` */

DROP TABLE IF EXISTS `tejeduria_auditoria_formato`;

CREATE TABLE `tejeduria_auditoria_formato` (
  `id` int(11) NOT NULL auto_increment,
  `grupo` int(11) default NULL,
  `descripcion` varchar(50) collate latin1_general_ci default NULL,
  `estatus` int(1) default '0',
  `tipo` varchar(20) collate latin1_general_ci default NULL,
  `descripcion_grupo` varchar(50) collate latin1_general_ci default NULL,
  `usuario_creacion` varchar(50) collate latin1_general_ci default NULL,
  `fecha_creacion` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

/*Data for the table `tejeduria_auditoria_formato` */

insert  into `tejeduria_auditoria_formato`(`id`,`grupo`,`descripcion`,`estatus`,`tipo`,`descripcion_grupo`,`usuario_creacion`,`fecha_creacion`) values (1,1,'Mangueras de aire',0,'tejeduria_telar','',NULL,'2022-08-10 11:45:49'),(2,1,'Los reguladores de presion',0,'tejeduria_telar','',NULL,'2022-08-10 11:46:18'),(3,1,'Soplador principal fijo',0,'tejeduria_telar','',NULL,'2022-08-10 11:46:35'),(4,1,'Soplador principal movil',0,'tejeduria_telar','',NULL,'2022-08-10 11:46:53'),(5,1,'Valvulas principal',0,'tejeduria_telar','El MANDO NEUMATICO',NULL,'2022-08-10 11:47:10'),(6,1,'Soplador auxiliares',0,'tejeduria_telar','',NULL,'2022-08-10 11:47:24'),(7,1,'Valvula soplador auxiliares',0,'tejeduria_telar','',NULL,'2022-08-10 11:47:40'),(8,1,'La aspiracion de la trama',0,'tejeduria_telar','',NULL,'2022-08-10 11:47:52'),(9,1,'Ajuste de los canales de aire',0,'tejeduria_telar','',NULL,'2022-08-10 11:48:05'),(10,1,'PFT',0,'tejeduria_telar','',NULL,'2022-08-10 11:48:18'),(11,2,'Leno rotativo',0,'tejeduria_telar','',NULL,'2022-08-10 16:11:03'),(12,2,'estado de la base del Templazo',0,'tejeduria_telar','',NULL,'2022-08-10 16:13:49'),(13,2,'El estante horizontal para bobinas disperdicidos',0,'tejeduria_telar','EL APARATO DE ORILLO',NULL,'2022-08-10 16:14:04'),(14,2,'Estado de las Tijeras',0,'tejeduria_telar','',NULL,'2022-08-10 16:14:24'),(15,2,'El momento del cruce de leno',0,'tejeduria_telar','',NULL,'2022-08-10 16:14:39'),(16,2,'Paraleno',0,'tejeduria_telar','',NULL,'2022-08-10 16:14:52'),(17,3,'Cuadros de lizos',0,'tejeduria_telar','',NULL,'2022-08-10 16:16:50'),(18,3,'El momento del cruce',0,'tejeduria_telar','',NULL,'2022-08-10 16:17:13'),(19,3,'Estado del Peine',0,'tejeduria_telar','LA CALADA',NULL,'2022-08-10 16:17:25'),(20,3,'Estado de los tensores de Trama',0,'tejeduria_telar','',NULL,'2022-08-10 16:17:42'),(21,3,'Nivelacion de los cuadros de lizos',0,'tejeduria_telar','',NULL,'2022-08-10 16:17:56'),(22,4,'El abrir y cerrar del rodamientos del plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:22:57'),(23,4,'El acoplamiento del plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:23:22'),(24,4,'El compensador de tension de la urdimbre',0,'tejeduria_telar','',NULL,'2022-08-10 16:23:43'),(25,4,'Rodillo palpador',0,'tejeduria_telar','',NULL,'2022-08-10 16:24:10'),(26,4,'ubo portahilos',0,'tejeduria_telar','',NULL,'2022-08-10 16:24:28'),(27,4,'Estado de la Pasarela posterior',0,'tejeduria_telar','',NULL,'2022-08-10 16:24:34'),(28,4,'Trinquete del Freno del Plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:24:53'),(29,4,'Orquillas del soporte del guia hilos',0,'tejeduria_telar','',NULL,'2022-08-10 16:25:00'),(30,4,'Estado de los Ganchos',0,'tejeduria_telar','',NULL,'2022-08-10 16:25:19'),(31,4,'Estado de las Platinas',0,'tejeduria_telar','',NULL,'2022-08-10 16:25:27'),(32,4,'Estado de las Varillas',0,'tejeduria_telar','EL DESENROLLADOR DE URDIMBRE',NULL,'2022-08-10 16:25:47'),(33,4,'Estado de los hilos de Desperdicio',0,'tejeduria_telar','',NULL,'2022-08-10 16:25:51'),(34,4,'Estado del forro plastico de hilos de orillo',0,'tejeduria_telar','',NULL,'2022-08-10 16:26:11'),(35,4,'Tapa de Base de cuadros',0,'tejeduria_telar','',NULL,'2022-08-10 16:26:25'),(36,4,'Estado de las Mallas',0,'tejeduria_telar','',NULL,'2022-08-10 16:26:30'),(37,4,'Estado del sensor de Leno',0,'tejeduria_telar','',NULL,'2022-08-10 16:26:42'),(38,4,'Estado de guia hilos de desperdicio',0,'tejeduria_telar','',NULL,'2022-08-10 16:27:03'),(39,4,'Base del portahilos de desperdicio',0,'tejeduria_telar','',NULL,'2022-08-10 16:27:15'),(40,4,'Estado del delantal',0,'tejeduria_telar','',NULL,'2022-08-10 16:27:27'),(41,4,'Rodamientos',0,'tejeduria_telar','',NULL,'2022-08-10 16:27:31'),(42,5,'Rodillos',0,'tejeduria_telar','',NULL,'2022-08-10 16:29:53'),(43,5,'Muelles',0,'tejeduria_telar','EL ENROLLAMIENTO',NULL,'2022-08-10 16:30:03'),(44,5,'Cadenas',0,'tejeduria_telar','',NULL,'2022-08-10 16:30:07'),(45,5,'Ajuste del Sistema de Enrollamiento',0,'tejeduria_telar','',NULL,'2022-08-10 16:30:27'),(46,6,'Alineado de las bobinas',0,'tejeduria_telar','',NULL,'2022-08-10 16:30:44'),(47,6,'Freno de la trama',0,'tejeduria_telar','',NULL,'2022-08-10 16:30:49'),(48,6,'La puesta a la tierra electrica',0,'tejeduria_telar','',NULL,'2022-08-10 16:31:00'),(49,6,'Estado del creeel de trama',0,'tejeduria_telar','EL ESTANTE DE BOBINAS DE LA TRAMA',NULL,'2022-08-10 16:31:02'),(50,6,'Base de los dadores de Trama',0,'tejeduria_telar','',NULL,'2022-08-10 16:31:51'),(51,6,'Ceramicas',0,'tejeduria_telar','',NULL,'2022-08-10 16:32:03'),(52,6,'Prealimentadores',0,'tejeduria_telar','',NULL,'2022-08-10 16:32:27'),(53,7,'Motor principal',0,'tejeduria_telar','',NULL,'2022-08-10 16:32:32'),(54,7,'El embraque',0,'tejeduria_telar','',NULL,'2022-08-10 16:32:46'),(55,7,'Correa',0,'tejeduria_telar','EL MANDO PRINCIPAL',NULL,'2022-08-10 16:32:52'),(56,7,'El freno',0,'tejeduria_telar','',NULL,'2022-08-10 16:33:16'),(57,7,'Angulometro',0,'tejeduria_telar','',NULL,'2022-08-10 16:33:23'),(58,7,'Buscapasadas',0,'tejeduria_telar','',NULL,'2022-08-10 16:33:58'),(59,8,'El armario de mando',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:01'),(60,8,'El ventilador del armario de mando',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:02'),(61,8,'El cuadro de mando  (teclado) / Display',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:02'),(62,8,'Las limparas de senalizacion',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:03'),(63,8,'Los pulsadores de emergencia',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:03'),(64,8,'Lamparas avisoras o Indicacion',0,'tejeduria_telar','ELECTRICA Y ELECTRONICO',NULL,'2022-08-10 16:34:04'),(65,8,'Paraurdimbre',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:04'),(66,8,'Paratrama',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:05'),(67,8,'Limpieza de el armario de mando',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:05'),(68,8,'Iluminacion Led Peine',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:06'),(69,8,'Iluminacion Principal',0,'tejeduria_telar','',NULL,'2022-08-10 16:34:07'),(70,9,'Sistema de lubricacion central',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:48'),(71,9,'Accionamiento de levas',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:48'),(72,9,'Desenrollador de urdimbre',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:48'),(73,9,'Filtro interpuesto para biela excentrica',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:49'),(74,9,'Rodamientos para compensador de tension  urd.',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:49'),(75,9,'Rodamientos del portahilos',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:49'),(76,9,'Discos de garras del acoplamiento del plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:50'),(77,9,'Las bielas de transmision para las cuadros',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:50'),(78,9,'Los pinones del rodillo del tela',0,'tejeduria_telar','LUBRICACION Y LIMPIEZA',NULL,'2022-08-10 16:36:50'),(79,9,'Encerrajamiento del rodamiento de plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:50'),(80,9,'El acoplamiento del plegador',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:51'),(81,9,'Bote de Aceite',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:51'),(82,9,'Fugas de Aire Comprimido',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:51'),(83,9,'Limpieza telar general',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:52'),(84,9,'Sistema de Aspiracion',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:52'),(86,9,'Limpieza ducto superior del telar',0,'tejeduria_telar','',NULL,'2022-08-10 16:36:53');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;