[l-ubuntu-ve] Error de sintáxis en SQL generado por MySQL Workbench

[Asdrúbal Iván Suárez Rivera]

El 22 de agosto de 2012 07:24, javier gallucci
<fjaviergallucci en gmail.com>escribió:

> Subelo a un sevidor gratuito y coloca el link.
>

Pensé que se habría adjuntado.

Es este:

*SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

DROP SCHEMA IF EXISTS `trackstar_dev` ;
CREATE SCHEMA IF NOT EXISTS `trackstar_dev` DEFAULT CHARACTER SET utf8
COLLATE utf8_bin ;
SHOW WARNINGS;
USE `trackstar_dev` ;

-- -----------------------------------------------------
-- Table `trackstar_dev`.`tbl_project`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `trackstar_dev`.`tbl_project` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `trackstar_dev`.`tbl_project` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(128) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NOT NULL ,
`description` TEXT CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL ,
`create_time` DATETIME NOT NULL ,
`create_user` INT NOT NULL ,
`update_time` DATETIME NOT NULL ,
`update_user_id` INT NOT NULL ,
PRIMARY KEY (`id`) )
ENGINE = InnoDB
AUTO_INCREMENT = 8
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_bin;

SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `trackstar_dev`.`tbl_user`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `trackstar_dev`.`tbl_user` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `trackstar_dev`.`tbl_user` (
`id` INT NOT NULL AUTO_INCREMENT ,
`email` VARCHAR(256) NOT NULL ,
`username` VARCHAR(256) NOT NULL ,
`password` VARCHAR(256) NOT NULL ,
`last_login_time` DATETIME NULL ,
`create_time` VARCHAR(45) NULL ,
`create_user_id` INT NULL ,
`update_time` DATETIME NULL ,
`update_user_id` INT NULL ,
PRIMARY KEY (`id`) )
ENGINE = InnoDB;

SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `trackstar_dev`.`tbl_issue`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `trackstar_dev`.`tbl_issue` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `trackstar_dev`.`tbl_issue` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(256) NOT NULL ,
`description` VARCHAR(2000) NULL ,
`type_id` INT NULL ,
`status_id` INT NULL ,
`owner_id` INT NULL ,
`requester_id` INT NULL ,
`create_time` DATETIME NULL ,
`create_user_id` INT NULL ,
`update_time` DATETIME NULL ,
`update_user_id` INT NULL ,
`project_id` INT NULL ,
PRIMARY KEY (`id`) ,
CONSTRAINT `fk_issue_project`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_project` ()
ON DELETE CASCADE
ON UPDATE RESTRICT,
CONSTRAINT `fk_issue_owner`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_user` ()
ON DELETE CASCADE
ON UPDATE RESTRICT,
CONSTRAINT `fk_issue_requester`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_user` ()
ON DELETE CASCADE
ON UPDATE RESTRICT)
ENGINE = InnoDB;

SHOW WARNINGS;
CREATE INDEX `fk_issue_project` ON `trackstar_dev`.`tbl_issue` () ;

SHOW WARNINGS;
CREATE INDEX `fk_issue_owner` ON `trackstar_dev`.`tbl_issue` () ;

SHOW WARNINGS;
CREATE INDEX `fk_issue_requester` ON `trackstar_dev`.`tbl_issue` () ;

SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `trackstar_dev`.`tbl_project_user_assignment`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `trackstar_dev`.`tbl_project_user_assignment` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `trackstar_dev`.`tbl_project_user_assignment` (
`project_id` INT NOT NULL ,
`user_id` INT(11) NOT NULL ,
`create_time` DATETIME NULL ,
`create_user_id` INT(11) NULL ,
`update_time` DATETIME NULL ,
`update_user_id` INT NULL ,
PRIMARY KEY (`project_id`, `user_id`) ,
CONSTRAINT `fk_user_project`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_user` ()
ON DELETE CASCADE
ON UPDATE RESTRICT,
CONSTRAINT `fk_project_user`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_project` ()
ON DELETE CASCADE
ON UPDATE RESTRICT)
ENGINE = InnoDB;

SHOW WARNINGS;
CREATE INDEX `fk_user_project` ON
`trackstar_dev`.`tbl_project_user_assignment` () ;

SHOW WARNINGS;
CREATE INDEX `fk_project_user` ON
`trackstar_dev`.`tbl_project_user_assignment` () ;

SHOW WARNINGS;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; *

El error que sale es el siguiente

*Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near ')
REFERENCES `trackstar_dev`.`tbl_project` ()
ON DELETE CASCADE
ON U' at line 16

CREATE TABLE IF NOT EXISTS `trackstar_dev`.`tbl_issue` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(256) NOT NULL ,
`description` VARCHAR(2000) NULL ,
`type_id` INT NULL ,
`status_id` INT NULL ,
`owner_id` INT NULL ,
`requester_id` INT NULL ,
`create_time` DATETIME NULL ,
`create_user_id` INT NULL ,
`update_time` DATETIME NULL ,
`update_user_id` INT NULL ,
`project_id` INT NULL ,
PRIMARY KEY (`id`) ,
CONSTRAINT `fk_issue_project`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_project` ()
ON DELETE CASCADE
ON UPDATE RESTRICT,
CONSTRAINT `fk_issue_owner`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_user` ()
ON DELETE CASCADE
ON UPDATE RESTRICT,
CONSTRAINT `fk_issue_requester`
FOREIGN KEY ()
REFERENCES `trackstar_dev`.`tbl_user` ()
ON DELETE CASCADE
ON UPDATE RESTRICT)
ENGINE = InnoDB

**SQL script execution finished: statements: 17 succeeded, 1 failed *

Gracias por la ayuda =)

_______________________________________________
> Lista de correo (ubuntu-ve)
> Fraternidad Ubuntu Linux de Venezuela
> (Official VenezuelanTeam)
> _______________________________________________
> ubuntu-ve mailing list
> ubuntu-ve en lists.ubuntu.com
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-ve
> www.ubuntu-ve.org | www.ubuntu.org.ve
> _______________________________________________
> Modifica tus opciones de suscripción o  desuscribete en:
> https://lists.ubuntu.com/mailman/listinfo/% (_internal_name)s
>



-- 
Asdrúbal Iván Suárez Rivera

*Si quieres aprender, enseña. *Marco Tulio Cicerón.
*
*
*¿Tienes twitter?*
*Sígueme: @asdrubalivan*