Some DB tables are not created on MySQL 5.5 and above during install

• Error

I created a test environment with the following components:
Apache 2.2.10
PHP 5.2.8
MySQL 6.0.8 alpha

I was not able to get MySQL 5.1 working on my machine,
but I was abe to get 6.0.8alpha runnning smooth.

I checked out the latest code in TRUNK 15953
pointed Apache to the files.

I ran tiki-install.php without problems except the following 3 SQL problems
which I suppose is due to MySQL version 6.0.8alpha

As my SQL skills are not up to date...
Are there any solutions for these bug?

Do not propose, that version 6 of MySQL is not supported 😊

CREATE TABLE tiki_banning ( banId int(12) NOT NULL auto_increment, mode enum('user','ip') default NULL, title varchar(200) default NULL, ip1 char(3) default NULL, ip2 char(3) default NULL, ip3 char(3) default NULL, ip4 char(3) default NULL, user varchar(200) default '', date_from timestamp(14) NOT NULL, date_to timestamp(14) NOT NULL, use_dates char(1) default NULL, created int(14) default NULL, message text, PRIMARY KEY (banId) ) ENGINE=MyISAM AUTO_INCREMENT=1
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 '(14) NOT NULL,
date_to timestamp(14) NOT NULL,
use_dates char(1) default NUL' at line 10

CREATE TABLE tiki_friendship_requests ( userFrom varchar(200) NOT NULL default '', userTo varchar(200) NOT NULL default '', tstamp timestamp(14) NOT NULL, PRIMARY KEY (userFrom(120),userTo(120)) ) ENGINE=MyISAM
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 '(14) NOT NULL,
PRIMARY KEY (userFrom(120),userTo(120))
) ENGINE=MyISAM' at line 4

CREATE TABLE tiki_users_score ( user char(200) NOT NULL default '', event_id char(200) NOT NULL default '', expire int(14) NOT NULL default '0', tstamp timestamp(14) NOT NULL, PRIMARY KEY (user(110),event_id(110)), KEY user (user(110),event_id(110),expire) ) ENGINE=MyISAM
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 '(14) NOT NULL,
PRIMARY KEY 110),event_id(110,
KEY user (user(110),ev' at line 5

This bug has been demonstrated on show2.tiki.org

Please demonstrate your bug on show2.tiki.org

This bug has been demonstrated on show.tikiwiki.org

Please demonstrate your bug on show.tikiwiki.org