PXsNX6u2

1#1064 - You have an error in your SQL syntax; check the manual that 
2
3corresponds to your MySQL server version for the right syntax to use near
4	
5ALTER TABLE apertura_taller
6
7    DROP FOREIGN KEY `PAR_ESTADO`,
8    DROP FOREIGN KEY `PAR_MUNICIPIO`,
9    DROP FOREIGN KEY `PAR_CODIGO`,
10
11    DROP `direccion`,
12
13    ADD FOREIGN KEY direccion_id_dir REFERENCES comunitario.direccion(id_dir);
14
15CREATE TABLE IF NOT EXISTS `comunitario`.`apertura_taller` (
16  `id_apertura_taller` INT(11) NOT NULL AUTO_INCREMENT,
17  `fecha_ini` DATE NOT NULL,
18  `fecha_fin` DATE NOT NULL,
19  `cap_min` INT(11) NOT NULL,
20  `cap_max` INT(11) NOT NULL,
21  `fecha_inicio_inscr` DATE NOT NULL,
22  `fecha_fin_inscr` DATE NOT NULL,
23  `direccion` VARCHAR(500) NOT NULL,
24  `PAR_ESTADO` INT(11) NOT NULL,
25  `PAR_MUNICIPIO` INT(11) NOT NULL,
26  `PAR_CODIGO` INT(11) NOT NULL,
27  `id_taller` INT(11) NOT NULL,
28  PRIMARY KEY (`id_apertura_taller`),
29  INDEX `foreign_taller_idx` (`id_taller` ASC),
30  INDEX `foreing_parroquia_idx` (`PAR_CODIGO` ASC),
31  INDEX `foreing_municipio_idx` (`PAR_MUNICIPIO` ASC),
32  INDEX `foreing_estado_idx` (`PAR_ESTADO` ASC),
33  CONSTRAINT `foreign_taller`
34    FOREIGN KEY (`id_taller`)
35    REFERENCES `comunitario`.`talleres` (`id_taller`)
36    ON DELETE NO ACTION
37    ON UPDATE NO ACTION,
38  CONSTRAINT `foreing_estado`
39    FOREIGN KEY (`PAR_ESTADO`)
40    REFERENCES `comunitario`.`ESTADO` (`EST_COD`)
41    ON DELETE NO ACTION
42    ON UPDATE NO ACTION,
43  CONSTRAINT `foreing_municipio`
44    FOREIGN KEY (`PAR_MUNICIPIO`)
45    REFERENCES `comunitario`.`MUNICIPIO` (`MUN_CODIGO`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION,
48  CONSTRAINT `foreing_parroquia`
49    FOREIGN KEY (`PAR_CODIGO`)
50    REFERENCES `comunitario`.`PARROQUIA` (`PAR_CODIGO`)
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION)
53ENGINE = InnoDB
54AUTO_INCREMENT = 2
55DEFAULT CHARACTER SET = latin1