1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

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 

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:

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:  

#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