9aDJcu55

1
2CREATE TABLE IF NOT EXISTS users (
3  email text PRIMARY KEY ,
4  password text,
5  firstname text,
6  familyname text,
7  gender text,
8  city text,
9  country text
10);
11
12CREATE TABLE IF NOT EXISTS login_users(
13  email text PRIMARY KEY,
14  token text
15);
16
17CREATE TABLE IF NOT EXISTS messages(
18  id integer PRIMARY KEY AUTOINCREMENT ,
19  Fromemail text,
20  Toemail text,
21  content text,
22  FOREIGN KEY(Fromemail) REFERENCES users(email),
23  FOREIGN KEY(Toemail) REFERENCES users(email)
24);