[Tikiwiki-users] Error Creating Tables

[Pieter J. v. V. <pi...@ps...>]

Hi,
 
I'm getting the following error when trying to run the tiki.sql
 
Warning: MYSQL error: DB Error: syntax error in query:
create table users_users( userId integer(8) not null auto_increment,
email varchar(200), login varchar(40) not null, password varchar(30) not
null, provpass varchar(30), realname varchar(80), homePage varchar(200),
lastLogin integer(14), currentLogin integer(14), registrationDate
integer(14), challenge char(32), pass_due integer(14), hash char(32),
created integer(14), country varchar(80), avatarName varchar(80),
avatarSize integer(14), avatarFileType varchar(250), avatarData
longblob, avatarLibName varchar(200), avatarType char(1), primary
key(userId) );
in /data/web/themarquee.co.za/data/web/tiki/tiki-install.php on line 24

when I run it with phpMyAdmin it tells me the problem is with 
 
, hash char(32), created integer(14), country varchar(80), 
 
My ISP is running MySQL 3.23.54
 
Cheers
 
Pieter