G1tkspLN

1CREATE TABLE IF NOT EXISTS `daniel`.`profesionales` (
2  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
3  `idUsuario` INT(10) UNSIGNED NOT NULL,
4  `idOficio` INT(10) UNSIGNED NOT NULL,
5  `habilitado` TINYINT(4) NOT NULL DEFAULT 1,
6  PRIMARY KEY (`id`))
7ENGINE = InnoDB
8DEFAULT CHARACTER SET = utf8;
9
10CREATE TABLE IF NOT EXISTS `daniel`.`estadosP` (
11  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
12  `estadoP` VARCHAR(45) NOT NULL,
13  PRIMARY KEY (`id`))
14ENGINE = InnoDB
15DEFAULT CHARACTER SET = utf8
16COMMENT = '		';
17
18CREATE TABLE IF NOT EXISTS `daniel`.`estadosProfesionales` (
19  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
20  `fechaSistema` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
21  `idProfesional` INT(10) UNSIGNED NOT NULL,
22  `idEstadoP` INT(10) UNSIGNED NOT NULL,
23  PRIMARY KEY (`id`),
24  INDEX `fk_estadosProfesionales_profesionales_idx` (`idProfesional` ASC) VISIBLE,
25  INDEX `fk_estadosProfesionales_estadosP1_idx` (`idEstadoP` ASC) VISIBLE,
26  CONSTRAINT `fk_estadosProfesionales_profesionales`
27    FOREIGN KEY (`idProfesional`)
28    REFERENCES `daniel`.`profesionales` (`id`)
29    ON DELETE NO ACTION
30    ON UPDATE NO ACTION,
31  CONSTRAINT `fk_estadosProfesionales_estadosP1`
32    FOREIGN KEY (`idEstadoP`)
33    REFERENCES `daniel`.`estadosP` (`id`)
34    ON DELETE NO ACTION
35    ON UPDATE NO ACTION)
36ENGINE = InnoDB
37DEFAULT CHARACTER SET = utf8;