X0kHwQBh

1[john@gallifrey ~ ]$ cd develop/mates-college-projects/web-register/
2[john@gallifrey web-register (master)]$ cd src/main/resources/
3[john@gallifrey resources (master)]$ sqlite3 database.db
4SQLite version 3.29.0 2019-07-10 17:32:03
5Enter ".help" for usage hints.
6sqlite> .schema
7CREATE TABLE IF NOT EXISTS "subjects"
8(
9	subject_id INTEGER
10		primary key autoincrement,
11	name TEXT not null
12);
13CREATE TABLE sqlite_sequence(name,seq);
14CREATE UNIQUE INDEX subjects_subject_id_uindex
15	on subjects (subject_id);
16CREATE TABLE IF NOT EXISTS "students"
17(
18	student_id INTEGER
19		primary key autoincrement,
20	name TEXT not null,
21	group_id INTEGER
22		references groups
23);
24CREATE UNIQUE INDEX students_student_id_uindex
25	on students (student_id);
26CREATE TABLE IF NOT EXISTS "groups"
27(
28	group_id INTEGER
29		primary key autoincrement,
30	code TEXT not null
31);
32CREATE UNIQUE INDEX groups_code_uindex
33	on groups (code);
34CREATE UNIQUE INDEX groups_group_id_uindex
35	on groups (group_id);
36CREATE TABLE groups_subjects (
37group_id INTEGER,
38subject_id INTEGER,
39PRIMARY KEY (group_id, subject_id),
40FOREIGN KEY (group_id)
41 REFERENCES groups (group_id)
42  ON DELETE NO ACTION
43  ON UPDATE NO ACTION
44,
45FOREIGN KEY (subject_id)
46 REFERENCES subjects (subject_id)
47  ON DELETE NO ACTION
48  ON UPDATE NO ACTION
49);
50sqlite> ^C
51sqlite> .exit
52[john@gallifrey resources (master)]$