sql problem

admin

Administrator
Staff member
I have problem in finding out the error in this create table command
The error is in the line BG_color.
Can any one pls find out the problem

CREATE TABLE channels (
Id int(11) DEFAULT '0' NOT NULL auto_increment,
Name varchar(20) DEFAULT 'ENTER_CHANNELNAME' NOT NULL,
PASSWORD varchar(30) DEFAULT '' NOT NULL,
User_Channel char(1) DEFAULT '0' NOT NULL,
These text NOT NULL,
Teilnehmerzahl int(11) DEFAULT '0' NOT NULL,
BG_Color varchar(7) DEFAULT '#111111' NOT NULL,
Logo varchar(255) DEFAULT 'images/exit_logo.gif' NOT NULL,
ExitURL varchar(255) DEFAULT '\/' NOT NULL,
Allow varchar(254) DEFAULT '' NOT NULL,
moderiert tinyint(4) DEFAULT '0' NOT NULL,
starts_at datetime DEFAULT '1999-01-01 00:00:00' NOT NULL,
stops_at datetime DEFAULT '9999-12-31 23:59:59' NOT NULL,
zeile int(11) DEFAULT '0' NOT NULL,
zeile_0 text NOT NULL DEFAULT '',
zeile_1 text,
zeile_2 text,
zeile_3 text,
zeile_4 text,
zeile_5 text,
zeile_6 text,
zeile_7 text,
zeile_8 text,
zeile_9 text,
zeile_10 text,
zeile_11 text,
zeile_12 text,
zeile_13 text,
zeile_14 text,
zeile_15 text,
zeile_16 text,
zeile_17 text,
zeile_18 text,
zeile_19 text,
zeile_20 text,
zeile_21 text,
zeile_22 text,
zeile_23 text,
zeile_24 text,
zeile_25 text,
zeile_26 text,
zeile_27 text,
zeile_28 text,
zeile_29 text,
zeile_30 text,
zeile_31 text,
zeile_32 text,
zeile_33 text,
zeile_34 text,
zeile_35 text,
zeile_36 text,
zeile_37 text,
zeile_38 text,
zeile_39 text,
PRIMARY KEY (Id),
KEY Name (Name)
);
thanks
__________________
rajensama
 
Back
Top