AQvYAxqN

1BEGIN TRANSACTION;
2CREATE TABLE IF NOT EXISTS "nutzer" (
3	"uid"	bigint NOT NULL,
4	"email"	varchar(50) DEFAULT NULL,
5	"name"	varchar(100) DEFAULT NULL,
6	PRIMARY KEY("uid")
7);
8CREATE TABLE IF NOT EXISTS "freundschaft" (
9	"uid1"	bigint NOT NULL,
10	"uid2"	bigint NOT NULL,
11	"Fgrad"	varchar(100) DEFAULT NULL,
12	CONSTRAINT "freundschaft_ibfk_2" FOREIGN KEY("uid2") REFERENCES "nutzer"("uid"),
13	PRIMARY KEY("uid1","uid2"),
14	CONSTRAINT "freundschaft_ibfk_1" FOREIGN KEY("uid1") REFERENCES "nutzer"("uid")
15);
16INSERT INTO "nutzer" VALUES (94,'Jun94@gmx.com','Jun Hu');
17INSERT INTO "nutzer" VALUES (96,NULL,'Anson Chen');
18INSERT INTO "nutzer" VALUES (1099511627782,'Baby1099511627782@gmail.com','Baby Yang');
19INSERT INTO "nutzer" VALUES (1099511627861,'Hao1099511627861@gmail.com','Hao Li');
20INSERT INTO "nutzer" VALUES (2199023255565,'Mehmet2199023255565@gmail.com','Mehmet Koksal');
21INSERT INTO "nutzer" VALUES (2199023255593,'Yang2199023255593@gmail.com','Yang Wang');
22INSERT INTO "nutzer" VALUES (2199023255602,'Alec2199023255602@gmail.com','Alec Lin');
23INSERT INTO "nutzer" VALUES (2199023255611,'Chen2199023255611@gmail.com','Chen Yang');
24INSERT INTO "nutzer" VALUES (2199023255625,'Cheng2199023255625@gmail.com','Cheng Chen');
25INSERT INTO "nutzer" VALUES (2199023255628,'Jae-Jin2199023255628@gmail.com','Jae-Jin Park');
26INSERT INTO "nutzer" VALUES (3298534883365,'Wei3298534883365@gmail.com','Wei Wei');
27INSERT INTO "nutzer" VALUES (3298534883405,'Karl3298534883405@gmail.com','Karl Fischer');
28INSERT INTO "nutzer" VALUES (7696581394474,'Ali7696581394474@gmx.com','Ali Achiou');
29INSERT INTO "nutzer" VALUES (7696581394490,NULL,'Amy Chen');
30INSERT INTO "nutzer" VALUES (7696581394520,'Chong7696581394520@gmail.com','Chong Zhang');
31INSERT INTO "nutzer" VALUES (8796093022217,'Alim8796093022217@gmail.com','Alim Guliyev');
32INSERT INTO "nutzer" VALUES (8796093022251,'Chen8796093022251@gmail.com','Chen Li');
33INSERT INTO "nutzer" VALUES (10995116277851,'Chong10995116277851@gmail.com','Chong Liu');
34INSERT INTO "nutzer" VALUES (13194139533352,'Celso13194139533352@gmail.com','Celso Oliveira');
35INSERT INTO "nutzer" VALUES (16492674416674,'Roberto16492674416674@gmail.com','Roberto Diaz');
36INSERT INTO "freundschaft" VALUES (94,96,'guter Freund');
37INSERT INTO "freundschaft" VALUES (94,2199023255625,'guter Freund');
38INSERT INTO "freundschaft" VALUES (94,3298534883365,'guter Freund');
39INSERT INTO "freundschaft" VALUES (94,8796093022217,'guter Freund');
40INSERT INTO "freundschaft" VALUES (94,8796093022251,'guter Freund');
41INSERT INTO "freundschaft" VALUES (94,10995116277851,'guter Freund');
42INSERT INTO "freundschaft" VALUES (96,7696581394474,'guter Freund');
43INSERT INTO "freundschaft" VALUES (96,7696581394490,'guter Freund');
44INSERT INTO "freundschaft" VALUES (1099511627782,3298534883405,'guter Freund');
45INSERT INTO "freundschaft" VALUES (1099511627861,7696581394474,'guter Freund');
46COMMIT;