Hi i installed moodle and everything worked fine but making tables in the mysql didnt went right.
(mysql): CREATE TABLE `mdl_assignment` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `description` text NOT NULL, `format` tinyint(4) unsigned NOT NULL default '0', `assignmenttype` varchar(50) NOT NULL default '', `resubmit` tinyint(2) unsigned NOT NULL default '0', `preventlate` tinyint(2) unsigned NOT NULL default '0', `emailteachers` tinyint(2) unsigned NOT NULL default '0', `var1` int(10) default '0', `var2` int(10) default '0', `var3` int(10) default '0', `var4` int(10) default '0', `var5` int(10) default '0', `maxbytes` int(10) unsigned NOT NULL default '100000', `timedue` int(10) unsigned NOT NULL default '0', `timeavailable` int(10) unsigned NOT NULL default '0', `grade` int(10) NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `course` (`course`)) COMMENT='Defines assignments'
1050: Table 'mdl_assignment' already exists
Fout
(mysql): CREATE TABLE `mdl_assignment_submissions` ( `id` int(10) unsigned NOT NULL auto_increment, `assignment` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `timecreated` int(10) unsigned NOT NULL default '0', `timemodified` int(10) unsigned NOT NULL default '0', `numfiles` int(10) unsigned NOT NULL default '0', `data1` text NOT NULL, `data2` text NOT NULL, `grade` int(11) NOT NULL default '0', `comment` text NOT NULL, `format` tinyint(4) unsigned NOT NULL default '0', `teacher` int(10) unsigned NOT NULL default '0', `timemarked` int(10) unsigned NOT NULL default '0', `mailed` tinyint(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `assignment` (`assignment`), KEY `userid` (`userid`), KEY `mailed` (`mailed`), KEY `timemarked` (`timemarked`)) COMMENT='Info about submitted assignments'
1050: Table 'mdl_assignment_submissions' already exists
Fout
Could someone help me with this bug pls, because i dont understand what is wrong