MySQL Forums
Forum List  »  MySQL Workbench

Re: mysql tools and mysql version
Posted by: Michael Dietrich
Date: February 12, 2008 03:27AM

workbench 5.0.13 created this sql script:

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';

CREATE SCHEMA IF NOT EXISTS `runnersproject` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

USE `runnersproject`;

CREATE TABLE IF NOT EXISTS `runnersproject`.`t_userrechte` (
`ID_USERRECHTE` INT(11) NOT NULL AUTO_INCREMENT ,
`ID_USER` INT(11) NOT NULL,
PRIMARY KEY (`ID_USERRECHTE`) ,
INDEX FK_REFERENCE_2 (`ID_USER` ASC) ,
INDEX id_user (`ID_USER` ASC) ,
CONSTRAINT `id_user`
FOREIGN KEY (`ID_USER` )
REFERENCES `runnersproject`.`t_user` (`ID_USER` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_general_ci;

CREATE TABLE IF NOT EXISTS `runnersproject`.`t_userdaten` (
`ID_USERDATEN` INT(11) NOT NULL AUTO_INCREMENT ,
`id_user` INT(11) NOT NULL,
`NACHNAME` VARCHAR(50) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NULL DEFAULT NULL ,
`VORNAME` VARCHAR(50) CHARACTER SET 'latin1' COLLATE 'latin1_general_ci' NULL DEFAULT NULL ,
PRIMARY KEY (`ID_USERDATEN`) ,
INDEX FK_REFERENCE_1 (`id_user` ASC) ,
INDEX id_user (`id_user` ASC) ,
CONSTRAINT `id_user`
FOREIGN KEY (`id_user` )
REFERENCES `runnersproject`.`t_user` (`ID_USER` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = MyISAM
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_general_ci;

CREATE TABLE IF NOT EXISTS `runnersproject`.`t_user` (
`ID_USER` INT(11) NOT NULL AUTO_INCREMENT ,
`key_user` CHAR(10) NOT NULL ,
`loginname` VARCHAR(50) NOT NULL ,
`username` VARCHAR(50) NOT NULL ,
`passwort` CHAR(32) NOT NULL ,
`email` VARCHAR(50) NOT NULL ,
`registrierungsdatum` DATETIME NOT NULL ,
`kz_aktiviert` CHAR(1) NOT NULL DEFAULT N ,
`kz_gesperrt` CHAR(1) NOT NULL DEFAULT N ,
`sperrzeitpunkt` DATETIME NULL DEFAULT NULL ,
`sperrgrund` TEXT NULL ,
`letzter_login` DATETIME NULL DEFAULT NULL ,
`aktueller_login` DATETIME NULL DEFAULT NULL ,
`IP` NULL ,
PRIMARY KEY (`ID_USER`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_swedish_ci;


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

and the error was:

Script line: 41 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 'N ,
`kz_gesperrt` CHAR(1) NOT NULL DEFAULT N ,
`sperrzeitpunkt` DATETIME N' at line 9

when i look into mySQL Administrator i can see the following versions:

mySQL Server version: 5.0.27-community-nt via TCP/IP
mySQL Client version 5.1.11

Options: ReplyQuote


Subject
Views
Written By
Posted
3368
February 11, 2008 04:18AM
2318
February 11, 2008 06:40AM
Re: mysql tools and mysql version
2797
February 12, 2008 03:27AM
2325
February 12, 2008 04:10AM
2288
February 12, 2008 04:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.