NcHDs9RF

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
4	
5CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
6USE `mydb` ;
7	
8CREATE TABLE IF NOT EXISTS `mydb`.`CLIENTES` (
9  `C.I.` INT NOT NULL,
10  `NOMBRE` VARCHAR(45) NOT NULL,
11  `FECHA_NACIMIENTO` DATE NOT NULL,
12  `DIRECCION` VARCHAR(45) NULL,
13  `CIUDAD` VARCHAR(45) NULL,
14  `OBSERVACIONES` VARCHAR(45) NULL DEFAULT 'NINGUNA',
15  `ALERGIAS` VARCHAR(45) NULL DEFAULT 'NINGUNA',
16  PRIMARY KEY (`C.I.`))
17ENGINE = InnoDB;
18	
19CREATE TABLE IF NOT EXISTS `mydb`.`RECOMIENDA` (
20  `C.I.` INT NOT NULL,
21  `RECOMIENDA` VARCHAR(45) NOT NULL,
22  `REMCOMENDADO` VARCHAR(45) NOT NULL,
23  PRIMARY KEY (`C.I.`),
24  CONSTRAINT `C.I.`
25    FOREIGN KEY (`C.I.`)
26    REFERENCES `mydb`.`CLIENTES` (`C.I.`)
27    ON DELETE NO ACTION
28    ON UPDATE NO ACTION)
29ENGINE = InnoDB;
30	
31CREATE TABLE IF NOT EXISTS `mydb`.`REALIZADO` (
32  `C.I.` INT NOT NULL,
33  `NOMBRE_CLIENTE` VARCHAR(45) NOT NULL,
34  `REALIZADO` VARCHAR(45) NOT NULL,
35  PRIMARY KEY (`C.I.`),
36  CONSTRAINT `C.I.`
37    FOREIGN KEY (`C.I.`)
38    REFERENCES `mydb`.`CLIENTES` (`C.I.`)
39    ON DELETE NO ACTION
40    ON UPDATE NO ACTION)
41ENGINE = InnoDB;
42	
43CREATE TABLE IF NOT EXISTS `mydb`.`PUNTAJE` (
44  `C.I.` INT NOT NULL,
45  `NOMBRE` VARCHAR(45) NOT NULL,
46  `PUNTIAJE` VARCHAR(45) NOT NULL,
47  PRIMARY KEY (`C.I.`),
48  CONSTRAINT `C.I.`
49    FOREIGN KEY (`C.I.`)
50    REFERENCES `mydb`.`CLIENTES` (`C.I.`)
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54	
55CREATE TABLE IF NOT EXISTS `mydb`.`user` (
56  `username` VARCHAR(16) NOT NULL,
57  `email` VARCHAR(255) NULL,
58  `password` VARCHAR(32) NOT NULL,
59  `create_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP);
60
61SET SQL_MODE=@OLD_SQL_MODE;
62SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
63SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;