Anonymous - 2001-12-27

Can't create the first table in the schema - all others can be created just fine.  Using phpMyAdmin. 

Reports the error:  MySQL said: You have an error in your SQL syntax near 'Logo varchar(255) DEFAULT 'images/exit_logo.gif' NOT NULL, ExitURL varchar(25' at line 8

When attempting to execute the query [code]DROP TABLE IF EXISTS channels;
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 '#284628' NOT NULL,
  NICK_COLOR varchar(7) DEFAULT '#88DEDE' 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)
);
INSERT INTO channels (Name,PASSWORD,These,Allow,zeile_0) VALUES ('Channel_1','','','','Remember, you have to define the variable $ENTRYCHANNELNAME in defaults_inc.php! The value must be one of an existing channel!<BR>');
[/code]