-
Notifications
You must be signed in to change notification settings - Fork 0
/
serverDB.db.sql
40 lines (40 loc) · 1.07 KB
/
serverDB.db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "user" (
"username" varchar(32) NOT NULL,
"password" varchar(32) NOT NULL,
"email" varchar(32),
"first_name" varchar(32) NOT NULL,
"last_name" varchar(32) NOT NULL,
"gender" varchar(1),
"person_id" varchar(32) NOT NULL,
PRIMARY KEY("username")
);
CREATE TABLE IF NOT EXISTS "person" (
"person_id" varchar(32) NOT NULL,
"username" varchar(32) NOT NULL,
"first_name" varchar(32) NOT NULL,
"last_name" varchar(32) NOT NULL,
"gender" varchar(1),
"father_id" varchar(32) NOT NULL,
"mother_id" varchar(32) NOT NULL,
"spouse_id" varchar(32) NOT NULL,
PRIMARY KEY("username")
);
CREATE TABLE IF NOT EXISTS "event" (
"event_id" varchar(32) NOT NULL,
"username" varchar(32) NOT NULL,
"person_id" varchar(32) NOT NULL,
"latitude" float,
"longitude" float,
"country" varchar(32) NOT NULL,
"city" varchar(32) NOT NULL,
"event_type" varchar(32) NOT NULL,
"year" int,
PRIMARY KEY("username")
);
CREATE TABLE IF NOT EXISTS "authtoken" (
"token" varchar(32) NOT NULL,
"username" varchar(32) NOT NULL,
PRIMARY KEY("username")
);
COMMIT;