/
egor-andreev
/
12-reactive-web-intro-java
Обзор
Документация
Войти
/
egor-andreev
/
12-reactive-web-intro-java
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
db.sql
36 строк
1 KB
Egor Andreev
initial commit
13 май 2025, 12:23
13 май 2025, 12:23
5e17ad7
Код
Авторство
О чём код?
DROP DATABASE IF EXISTS students; CREATE DATABASE students; USE students; CREATE TABLE `courses` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `coursename` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `coursename` (`coursename`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `students` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `registered_on` bigint(20) NOT NULL, `status` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; CREATE TABLE `coursework` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `student_id` int(10) unsigned NOT NULL, `course_id` int(10) unsigned NOT NULL, `marks` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `student_id` (`student_id`), KEY `course_id` (`course_id`), CONSTRAINT `coursework_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`), CONSTRAINT `coursework_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; insert into `students`(`id`,`name`,`registered_on`,`status`) values (1,'George Gatheca Updated',1234,1), (2,'Jonh Doe',5678,1);