wdgfhjkasd

REATE DATABASE IF NOT EXISTS `clinica` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `clinica`;
-- MySQL dump 10.13 Distrib 5.6.13, for Win32 (x86)
--
-- Host: localhost Database: clinica
-- ------------------------------------------------------
-- Server version 5.6.14

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

DROP TABLE IF EXISTS `empleados`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleados` (
`Cedula_profesional` smallint(6) NOT NULL COMMENT 'Eduardo Jimenez',`Nombre` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Direccion` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Telefono` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Ciudad` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Estado` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Codigo_postal` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',`numero_de_seguro_social` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Turno` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Sueldo` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Fecha_de_inicio` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Fecha_de_termino` varchar(45) DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Profesion` varchar(45)DEFAULT NULL COMMENT 'Eduardo Jimenez',
`Fecha_de_vacaciones` varchar(45) DEFAULT NULL,
PRIMARY KEY (`Cedula_profesional`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eduardo David Jimenez Cisneros';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleados`
--

LOCK TABLES `empleados` WRITE;
/*!40000 ALTER TABLE `empleados` DISABLE KEYS*/;
INSERT INTO `empleados` VALUES (12333,'Martin Rodriguez','everman #2342','3218765','Colima','Colima','00890','1234567890','matutino','$2300','23/04/1976','2/9/2009','enfermeria','25/06/05'),(12334,'Kevin Rosales','flores #34 B','3213404','Guzman','Jalisco','49840','3562153271','nocturno','$600','01/03/2000','','administrativo','30/07/2009'),(12335,'Jonatan Sanchez','carranza #8C','3114568','Morelia','Michoacan','11230','3478492378','matutino','$1900','22/10/1999','','seguridad','15/4/2011'),(12336,'Alejandro Ortiz','madero #130','3012274','Puerto Vallarta','Jalisco','12345','5231561747','vespertino','$3000','9/12/1986','','seguridad','12/12/2012'),(12337,'Rubi Jimenez','villa#2','3175967','Manzanillo','Colima','09876','4234171532','vespertino','$600','9/11/1997','','administrativo','10/7/2009'),(12338,'Abdiel Gutierrez','alfaro #243','3217476','Tonila','Jalisco','49840','2315624164','vespertino','$2300','7/1/1975','9/2/2013','enfermeria','8/6/2003'),(12339,'Israel Lopez','juarez #48','3245089','Cuahutemoc','Colima','00958','2562315745','matutino','$3000','6/3/2006',NULL,'enfemeria','5/5/2010'),(12340,'Alberto Medina','calderon#23','3134745','Comala','Colima','56745','6216444217','vespertino','$600','9/10/2011',NULL,'administrativo','6/30/2001'),(12341,'Omar Bravo','hidalgo #56','3124346','San marcos','Jalisco','45678','1234523154','nocturno','$2300','23/3/2003',NULL,'enfermeria','10/7/2010'),(12342,'Marcos Gudino','carranza #34','3217645','Coquimatlan','Colima','09873','6476347657','matutino','$40000','16/9/2002',NULL,'seguridad','4/9/2004'),(12343,'Eduardo...