[ تمت الإجابة ] التحويل من Access To Mysql

mysql> CREATE TABLE `admin` (

`id` int(11) NOT NULL default '0',

`name` varchar(50) default NULL,

`password` varchar(50) default NULL,

PRIMARY KEY (`id`),

KEY `id` (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

mysql> CREATE TABLE `students` (

`id` int(11) NOT NULL default '0',

`name` varchar(50) default NULL,

`password` varchar(50) default NULL,

PRIMARY KEY (`id`)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

mysql> CREATE TABLE `exam` (

`id` int(11) NOT NULL default '0',

`question` varchar(250) default NULL,

`correctAnswer` varchar(50) default NULL,

`answerB` varchar(50) default NULL,

`answerC` varchar(50) default NULL,

`answerD` varchar(50) default NULL,

`answerE` varchar(50) default NULL,

`answerF` varchar(50) default NULL,

PRIMARY KEY (`id`)

)ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

mysql> CREATE TABLE `answers` (

`ID` int(11) NOT NULL default '0',

`question` int(11) NOT NULL default '0',

`choice` varchar(50) default NULL,

PRIMARY KEY (`ID`,`question`),

KEY `examanswers` (`question`),

CONSTRAINT `examanswers` FOREIGN KEY (`question`) REFERENCES `exam` (`id`) ON

DELETE CASCADE ON UPDATE CASCADE,

CONSTRAINT `studentsanswers` FOREIGN KEY (`ID`) REFERENCES `students` (`id`) ON

DELETE CASCADE ON UPDATE CASCADE

)ENGINE=InnoDB DEFAULT CHARSET=utf8 ;