mirror of
https://github.com/idanoo/nzart-exam-generator.git
synced 2024-12-04 14:23:10 +00:00
40 lines
1.5 KiB
SQL
Executable File
40 lines
1.5 KiB
SQL
Executable File
-- Creates an empty DB for your own questions/etc.
|
|
CREATE TABLE IF NOT EXISTS `user` (
|
|
`user_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`user_time` INT(11) NOT NULL,
|
|
`userdata_username` varchar(256) NOT NULL,
|
|
`userdata_password` varchar(256) NOT NULL,
|
|
PRIMARY KEY (`user_id`),
|
|
UNIQUE KEY `user_id_UNIQUE` (`user_id`),
|
|
UNIQUE KEY `userdata_username_UNIQUE` (`userdata_username`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE IF NOT EXISTS `question` (
|
|
`question_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`question_time` INT(11) NOT NULL,
|
|
`questiondata_number` VARCHAR(10) DEFAULT NULL,
|
|
`questiondata_content` TEXT DEFAULT NULL,
|
|
`questiondata_image` TEXT DEFAULT NULL,
|
|
PRIMARY KEY (`question_id`),
|
|
UNIQUE KEY `question_id_UNIQUE` (`question_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE IF NOT EXISTS `answer` (
|
|
`answer_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`answer_time` INT(11) NOT NULL,
|
|
`answerdata_question` INT(11) NOT NULL,
|
|
`answerdata_content` MEDIUMTEXT DEFAULT NULL,
|
|
`answerdata_correct` INT(1) DEFAULT 0,
|
|
PRIMARY KEY (`answer_id`),
|
|
UNIQUE KEY `answer_id_UNIQUE` (`answer_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
CREATE TABLE IF NOT EXISTS `result` (
|
|
`result_id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
`result_time` INT(11) NOT NULL,
|
|
`resultdata_user` INT(11) NOT NULL,
|
|
`resultdata_result` MEDIUMTEXT DEFAULT NULL,
|
|
`resultdata_score` VARCHAR(255) DEFAULT NULL,
|
|
PRIMARY KEY (`result_id`),
|
|
UNIQUE KEY `result_id_UNIQUE` (`result_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |