Re: mysql tools and mysql version

[Michael Dietrich]

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