/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 100138
Source Host           : localhost:3306
Source Database       : calendario_pacientes

Target Server Type    : MYSQL
Target Server Version : 100138
File Encoding         : 65001

Date: 2024-03-08 16:55:22
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for citas
-- ----------------------------
DROP TABLE IF EXISTS `citas`;
CREATE TABLE `citas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `hora` time NOT NULL,
  `rut` varchar(12) NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `duracion` int(11) NOT NULL,
  `examen` varchar(255) NOT NULL,
  `estado` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of citas
-- ----------------------------
INSERT INTO `citas` VALUES ('7', '2024-03-08', '08:40:00', '10629933-1', 'Nelson Stuardo', '10', 'KERATOGRAPH', '1');
INSERT INTO `citas` VALUES ('8', '2024-03-08', '09:20:00', '10629933-1', 'Nelson Stuardo', '10', 'KERATOGRAPH', '0');
INSERT INTO `citas` VALUES ('9', '2024-03-08', '10:20:00', '10629933-1', 'Nelson Stuardo', '10', 'KERATOGRAPH', '1');
INSERT INTO `citas` VALUES ('10', '2024-03-08', '11:00:00', '10629933-1', 'Nelson Stuardo', '10', 'KERATOGRAPH', '1');
SET FOREIGN_KEY_CHECKS=1;
