-
Notifications
You must be signed in to change notification settings - Fork 0
/
script.sql
48 lines (44 loc) · 1.36 KB
/
script.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
41
42
43
44
45
46
47
48
CREATE TABLE "fantateams" (
"id" SERIAL,
"name" TEXT NOT NULL,
"credits" INTEGER NOT NULL,
"p" INTEGER NOT NULL,
"d" INTEGER NOT NULL,
"c" INTEGER NOT NULL,
"a" INTEGER NOT NULL,
PRIMARY KEY("id")
);
CREATE TABLE "player" (
"id" INTEGER,
"role" TEXT NOT NULL,
"name" TEXT NOT NULL,
"team" TEXT NOT NULL,
"qi" INTEGER,
PRIMARY KEY("id")
);
CREATE TABLE "purchase" (
"id" INTEGER NOT NULL,
"fantateams" INTEGER NOT NULL,
"price" INTEGER NOT NULL,
FOREIGN KEY("id") REFERENCES "player"("id"),
PRIMARY KEY("id"),
FOREIGN KEY("fantateams") REFERENCES "fantateams"("id")
);
CREATE TABLE "users" (
"id" SERIAL,
"username" TEXT NOT NULL,
"hash" TEXT NOT NULL,
"name" TEXT NOT NULL,
PRIMARY KEY("id")
);
insert into fantateams values(1,'luigi',500,0,0,0,0);
insert into fantateams values(2,'niccolo',500,0,0,0,0);
insert into fantateams values(3,'mario',500,0,0,0,0);
insert into fantateams values(4,'checco',500,0,0,0,0);
insert into fantateams values(5,'fabio',500,0,0,0,0);
insert into fantateams values(6,'manuel',500,0,0,0,0);
insert into fantateams values(7,'bruno',500,0,0,0,0);
insert into fantateams values(8,'cri',500,0,0,0,0);
insert into fantateams values(9,'zolfa',500,0,0,0,0);
insert into fantateams values(10,'marco',500,0,0,0,0);
insert into users values(1,'[email protected]','$2a$10$WRTyL4FDbnS3Khe8dAwf.uBQmVYuJHnjD.PzgcQVmdLxJAzWCtfX2','luigi');