Anstelle von
Code: Select all
CREATE TABLE phpbb3_shoutbox (
shout_id int(11) unsigned NOT NULL auto_increment,
shout_user_id mediumint(8) NOT NULL,
shout_time int(11) NOT NULL,
shout_ip varchar(32) character set latin1 NOT NULL,
shout_text text collate utf8_bin NOT NULL,
shout_bbcode_bitfield varchar(255) character set latin1 NOT NULL,
shout_bbcode_uid varchar(8) character set latin1 NOT NULL,
shout_bbcode_flags int(11) unsigned NOT NULL default '7',
PRIMARY KEY (shout_id)
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Code: Select all
DROP TABLE IF EXISTS `phpbb3_shoutbox`;
CREATE TABLE IF NOT EXISTS `phpbb3_shoutbox` (
`shout_id` int(11) unsigned NOT NULL auto_increment,
`shout_user_id` mediumint(8) NOT NULL,
`shout_time` int(11) NOT NULL,
`shout_ip` varchar(32) character set latin1 NOT NULL,
`shout_text` longblob NOT NULL,
`shout_bbcode_bitfield` blob NOT NULL,
`shout_bbcode_uid` blob NOT NULL,
`shout_bbcode_flags` int(11) unsigned NOT NULL default '7',
PRIMARY KEY (`shout_id`)
);
angewendet, so hat es dann funktioniert. Dieses SQL ist übrigens für MySQL 4!!!
"phpbb3_" ist mein Präfix, ggf. unbedingt anpassen!