· 4 years ago · May 27, 2021, 11:22 AM
1drop table if exists utenti cascade;
2drop table if exists accessi cascade;
3
4create table utenti(
5username varchar(20) primary key,
6password varchar(255) not null,
7codice char(10) unique not null
8);
9
10CREATE TABLE accessi
11(
12codiceutente character(10),
13codiceinserito character(10),
14dataaccesso date,
15orarioaccesso time without time zone,
16CONSTRAINT accessi_codiceinserito_fkey FOREIGN KEY (codiceinserito)
17REFERENCES public.utenti (codice) MATCH SIMPLE
18ON UPDATE cascade
19ON DELETE cascade,
20CONSTRAINT accessi_codiceutente_fkey FOREIGN KEY (codiceutente)
21REFERENCES public.utenti (codice) MATCH SIMPLE
22ON UPDATE cascade
23ON DELETE cascade
24);
25
26INSERT INTO utenti(username,password,codice) values
27('Agata ','Baronti!','1000000001'),
28('Éadaoin','Lanzoni<','1000000002'),
29('Preecha','Mincuzzi<','1000000003'),
30('Otello ','fiAdone <','1000000004'),
31('Gasparo ','lYcchi<','1000000005'),
32('Vespasiano','Ricciolino<','1000000006'),
33('Ernesta ','Ricci<','1000000007'),
34('Carmela','Sorrentino<','1000000008'),
35('Dania ','fabiani<','1000000010'),
36('Mirta ','Hossain<','1000000011'),
37('Jacopo','bartolini<','1000000012'),
38('Olujimi','Ceraldi<','1000000013'),
39('Riccarda ','sementilli<','1000000014'),
40('Norberto ','tabane<','1000000015'),
41('Quirino ','Lombardo<','1000000016'),
42('Gregoria ','lucchesini<','1000000017'),
43('Atanasio','sposato<','1000000018'),
44('Natanaele','zaratti<','1000000019'),
45('Beppe','alpi<','1000000020');
46
47INSERT INTO accessi(orarioaccesso,dataAccesso,codiceinserito,codiceUtente) values
48('174742','20211114','1000000020','1000000020'),
49('200750','20210528','1000000005','1000000010'),
50('170453','20210731','1000000011','1000000011'),
51('051802','20210928','1000000012','1000000002'),
52('044637','20210806','1000000018','1000000018'),
53('183543','20210414','1000000012','1000000020'),
54('144957','20210510','1000000010','1000000010'),
55('110635','20210209','1000000011','1000000011'),
56('174735','20210716','1000000018','1000000013'),
57('122031','20210608','1000000018','1000000018'),
58('150939','20210724','1000000006','1000000006'),
59('074612','20210122','1000000007','1000000007'),
60('003844','20210505','1000000007','1000000010'),
61('190552','20210618','1000000007','1000000007'),
62('191005','20211231','1000000006','1000000006'),
63('170032','20210421','1000000008','1000000016'),
64('040828','20210511','1000000013','1000000013'),
65('134844','20210423','1000000002','1000000002'),
66('103033','20210821','1000000006','1000000006'),
67('071435','20211207','1000000006','1000000006'),
68('190735','20210227','1000000020','1000000002'),
69('113418','20210619','1000000015','1000000017'),
70('183456','20210522','1000000004','1000000004'),
71('223548','20210822','1000000013','1000000013'),
72('170558','20210304','1000000020','1000000020'),
73('113239','20210423','1000000002','1000000002'),
74('165721','20210717','1000000003','1000000003'),
75('005848','20210114','1000000013','1000000003'),
76('124311','20210203','1000000016','1000000018'),
77('140530','20210214','1000000003','1000000003'),
78('211844','20210723','1000000017','1000000018'),
79('041044','20211117','1000000016','1000000019'),
80('063855','20211015','1000000013','1000000010'),
81('191614','20210928','1000000005','1000000020'),
82('162536','20210223','1000000002','1000000002'),
83('052030','20210225','1000000013','1000000016'),
84('130651','20211109','1000000004','1000000013'),
85('213256','20211130','1000000008','1000000008'),
86('010419','20211106','1000000019','1000000003'),
87('094009','20210420','1000000004','1000000001'),
88('200939','20210201','1000000008','1000000003'),
89('052536','20211011','1000000003','1000000003'),
90('092140','20210713','1000000006','1000000006'),
91('151815','20210208','1000000008','1000000008'),
92('053004','20210526','1000000011','1000000011'),
93('192716','20210120','1000000013','1000000012'),
94('093916','20210703','1000000011','1000000011'),
95('224525','20211210','1000000014','1000000014'),
96('014412','20210224','1000000007','1000000007'),
97('031824','20211118','1000000018','1000000018');