C0t080dF

1DROP DATABASE IF EXISTS `hospital2`;
2CREATE DATABASE IF NOT EXISTS `hospital2` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci */;
3USE `hospital2`;
4
5DROP TABLE IF EXISTS `admin`;
6CREATE TABLE IF NOT EXISTS `admin` (
7    `usuario` varchar(9) NOT NULL,
8    `apellidos` varchar(50) NOT NULL,
9    `passw` varchar(9) NOT NULL,
10    `nombre` varchar(50) NOT NULL,
11    `foto` longblob
12) ENGINE=InnoDB DEFAULT CHARSET=latin1;
13
14DROP TABLE IF EXISTS `area`;
15CREATE TABLE IF NOT EXISTS `area` (
16    `id` int(11) NOT NULL DEFAULT '0',
17    `tipo` varchar(50) DEFAULT NULL,
18    `color` varchar(50) DEFAULT NULL,
19    `orientacion` varchar(50) DEFAULT NULL,
20    PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23DROP TABLE IF EXISTS `asignado`;
24CREATE TABLE IF NOT EXISTS `asignado` (
25    `idTrabajador` varchar(9) NOT NULL DEFAULT '',
26    `idTurno` int(11) NOT NULL DEFAULT '0',
27    PRIMARY KEY (`idTrabajador`,`idTurno`),
28    KEY `idTurno` (`idTurno`),
29    CONSTRAINT `asignado_ibfk_1` FOREIGN KEY (`idTrabajador`) REFERENCES `trabajador` (`colegiado`) ON DELETE CASCADE,
30    CONSTRAINT `asignado_ibfk_2` FOREIGN KEY (`idTurno`) REFERENCES `turno` (`id`)
31) ENGINE=InnoDB DEFAULT CHARSET=latin1;