Installing and upgrading help

Hi All

Just discovered Moodle after reading the recent Linux Journal article. Looks interesting so thought I'd give it a try.

Just tried my first install - have installed via CVS from 1.4 Stable branch. Everything going well - until I got to the database creation part... everything created successfully apart from one:

(mysql): CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) unsigned NOT NULL default '0', `course` int(10) unsigned NOT NULL default '0', `authority` int(10) NOT NULL default '3', `role` varchar(40) NOT NULL default '', `editall` int(1) unsigned NOT NULL default '1', `timestart` int(10) unsigned NOT NULL default '0', `timeend` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `timeaccess` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), KEY UNIQUE `courseuserid` (course, userid), KEY `userid` (userid)) TYPE=MyISAM COMMENT='One record per teacher per course'

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 'UNIQUE `courseuserid` (course,userid), KEY `userid` (userid))

adodb_mysql._execute(CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NU..., false) % line 804, file: adodb.inc.php

adodb_mysql.execute(CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NU...) % line 30, file: datalib.php

execute_sql() % line 152, file: datalib.php

modify_database(CREATE TABLE `mdl_user_teachers` ( `id` int(10) unsigned NOT NU...) % line 111, file: index.php

Error

Any help much appreciated!

Steve