Static Page 1.0.3 SQL Hilfe

[oecherjung]

Hallo

bei der Installation bzw. beim ausführen des SQL Scripts

Code: Alles auswählen

CREATE TABLE phpbb_pages (
  page_id int(11) unsigned NOT NULL auto_increment,
  page_title varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  page_desc mediumtext character set utf8 collate utf8_bin NOT NULL,
  page_content mediumtext character set utf8 collate utf8_bin NOT NULL,
  page_url varchar(255) character set utf8 collate utf8_bin NOT NULL,
  bbcode_uid varchar(8) character set utf8 collate utf8_bin NOT NULL,
  bbcode_bitfield varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  page_time int(11) unsigned NOT NULL default '0',
  page_order int(11) unsigned NOT NULL default '0',
  page_display tinyint(1) unsigned NOT NULL default '0',
  page_display_guests tinyint(1) unsigned NOT NULL default '0',
  page_author mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (page_id)
);

bekomme ich den Fehler:


#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 'collate utf8_unicode_ci NOT NULL,
page_desc mediumtext chara

Wie muß das SQL Statement angepaßt werden? Ich benutzte MYSQL 4.0.15

Gruß´

oechi

[oecherjung]

Hallo,

ich habe mal selber Versuche

und so läuft das Script mit MYSQL 4.0.15 durch

Code: Alles auswählen

CREATE TABLE phpbb_pages (
  page_id int(11) unsigned NOT NULL auto_increment,
  page_title varchar(255) NOT NULL,
  page_desc mediumtext NOT NULL,
  page_content mediumtext NOT NULL,
  page_url varchar(255) NOT NULL,
  bbcode_uid varchar(8) NOT NULL,
  bbcode_bitfield varchar(255) NOT NULL default '',
  page_time int(11) unsigned NOT NULL default '0',
  page_order int(11) unsigned NOT NULL default '0',
  page_display tinyint(1) unsigned NOT NULL default '0',
  page_display_guests tinyint(1) unsigned NOT NULL default '0',
  page_author mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (page_id)
) TYPE=MyISAM ;