Mam takovyto problem, importuji do sve databaze kod vygenerovany wwwSQLdesignerem() a hazi me to chybu 1064:
mysql> CREATE TABLE `CveCriterions` (
-> `id` INTEGER NOT NULL AUTO_INCREMENT ,
-> `operator` CHAR(2) NOT NULL ,
-> `version` VARCHAR NOT NULL ,
-> `pkg_id` INTEGER NOT NULL ,
-> `cve_id` INTEGER NOT NULL ,
-> `osGroup_id` INTEGER NOT NULL ,
-> `archGroup_id` INTEGER NOT NULL ,
-> `cveCriterion_id` INTEGER NOT NULL ,
-> PRIMARY KEY (`id`)
-> );
ERROR 1064 (42000): 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 'NOT NULL ,
`pkg_id` INTEGER NOT NULL ,
`cve_id` INTEGER NOT NULL ,
`osGroup_id` ' at line 4
mysql>
Mam verzi mysql serveru: 5.0.51a-3ubuntu5.4 (Ubuntu)
Zkousel jsem googlit, podobne problemy jsem nasel u lidi, kteri meli starou 4 verzi mysql...Nevite, co s tim? Mozna je to jen mou nezkousenosti, ze nevidim tu chybu v syntaxi...