blob: 024af7a7004471c8505add1bdb10310eb7ec806d (
plain) (
blame)
1
2
3
4
|
CREATE TABLE users (username text primary key not null, argon2 text, cookietime real, cookie text, lastname text, firstname text, middlename text, subjects text, year TEXT);
CREATE TABLE meetings (mid integer primary key, mentor text, mentee text, time_start integer, time_end integer, notes text);
CREATE TABLE subjects (subjectid text primary key not null, subjectname text not null);
CREATE TABLE subject_associations (username text, subjectid text);
|
