[HaBo]

SQL-Befehl:

CREATE TABLE bb1_acpmenuitemgroups(
itemgroupid smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
title varchar( 255 ) NOT NULL ,
condition text NOT NULL ,
conditiontype enum( 'OR', 'AND' ) NOT NULL DEFAULT 'OR',
showorder smallint( 5 ) unsigned NOT NULL DEFAULT '0',
acpmode tinyint( 3 ) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY ( itemgroupid )
);

MySQL meldet: Dokumentation
#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 'condition text NOT NULL,
    conditiontype enum('OR','AND') NOT NULL DEFAULT 'OR',' at line 4

CREATE TABLE `bla` (
`itemgroupid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 255 ) NOT NULL ,
`condition` TEXT NOT NULL ,
`conditiontype` ENUM( 'OR', 'AND' ) NOT NULL DEFAULT 'OR',
`showorder` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
`acpmode` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0'
)