tur7Q8cM

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 10.3
6-- Dumped by pg_dump version 10.3
7
8SET statement_timeout = 0;
9SET lock_timeout = 0;
10SET idle_in_transaction_session_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16SET row_security = off;
17
18--
19-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
20--
21
22CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
23
24
25--
26-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
27--
28
29COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
30
31
32SET default_tablespace = '';
33
34SET default_with_oids = false;
35
36--
37-- Name: domande; Type: TABLE; Schema: public; Owner: alessioprete
38--
39
40CREATE TABLE public.domande (
41    codice integer NOT NULL,
42    codtest integer,
43    numero integer NOT NULL,
44    domanda text NOT NULL
45);
46
47
48ALTER TABLE public.domande OWNER TO alessioprete;
49
50--
51-- Name: insegnamento; Type: TABLE; Schema: public; Owner: alessioprete
52--
53
54CREATE TABLE public.insegnamento (
55    codprof integer NOT NULL,
56    codmateria integer NOT NULL
57);
58
59
60ALTER TABLE public.insegnamento OWNER TO alessioprete;
61
62--
63-- Name: materie; Type: TABLE; Schema: public; Owner: alessioprete
64--
65
66CREATE TABLE public.materie (
67    codice integer NOT NULL,
68    nome character varying(80) NOT NULL
69);
70
71
72ALTER TABLE public.materie OWNER TO alessioprete;
73
74--
75-- Name: professori; Type: TABLE; Schema: public; Owner: alessioprete
76--
77
78CREATE TABLE public.professori (
79    codice integer NOT NULL,
80    nome character varying(30) NOT NULL,
81    cognome character varying(30) NOT NULL,
82    username character varying(9) NOT NULL,
83    pwd character varying(15) NOT NULL,
84    email character varying(30) NOT NULL
85);
86
87
88ALTER TABLE public.professori OWNER TO alessioprete;
89
90--
91-- Name: risposte; Type: TABLE; Schema: public; Owner: alessioprete
92--
93
94CREATE TABLE public.risposte (
95    coddom integer NOT NULL,
96    numero integer NOT NULL,
97    risposta text NOT NULL,
98    corretta boolean NOT NULL
99);
100
101
102ALTER TABLE public.risposte OWNER TO alessioprete;
103
104--
105-- Name: sessioni; Type: TABLE; Schema: public; Owner: alessioprete
106--
107
108CREATE TABLE public.sessioni (
109    codice integer NOT NULL,
110    codtest integer,
111    codprof integer,
112    spwd character varying(13) NOT NULL,
113    alunni integer NOT NULL,
114    ora time without time zone NOT NULL,
115    classe character varying(20),
116    data date NOT NULL
117);
118
119
120ALTER TABLE public.sessioni OWNER TO alessioprete;
121
122--
123-- Name: test; Type: TABLE; Schema: public; Owner: alessioprete
124--
125
126CREATE TABLE public.test (
127    codice integer NOT NULL,
128    codmat integer,
129    codprof integer,
130    argomento character varying(60) NOT NULL
131);
132
133
134ALTER TABLE public.test OWNER TO alessioprete;
135
136--
137-- Data for Name: domande; Type: TABLE DATA; Schema: public; Owner: alessioprete
138--
139
140INSERT INTO public.domande VALUES (1, 0, 0, 'Si puo vedere il codice PHP di un applicativo su un server,
141utilizzando dal client solo un browser?
142
143
144
145');
146INSERT INTO public.domande VALUES (2, 0, 1, 'Nei passaggi di parametri alle funzioni,
147e valida, in C, la seguente regola 
148
149
150
151');
152INSERT INTO public.domande VALUES (3, 0, 2, 'Date le variabili intere:  a,b,c:
153a = 7; b = 8; c = 9;
154e le condizioni:
155(A > B), (A % C == 0), (A == B-1), (C / 2 == 4)
156Le quattro condizioni sono rispettivamente:
157');
158INSERT INTO public.domande VALUES (4, 0, 3, 'Quanti volte stampa \"ciao\"  il seguente ciclo while:
159unsigned int i=4;
160
161do { printf(\"ciao\\n\");
162i < 0 ? i=0 : i++; } while(i>=0);
163');
164INSERT INTO public.domande VALUES (5, 0, 4, 'void main() 
165{ int a = 3, b = 4, c = 5;
166  b++; c--; a+=b;
167
168// Quanto rimane nelle variabili 
169');
170INSERT INTO public.domande VALUES (6, 0, 5, 'Nella funzione printf(), alcuni formati sono:
171
172
173
174
175');
176INSERT INTO public.domande VALUES (7, 0, 6, 'Se voglio azzerare il vettore: int v[10]
177posso scrivere:
178
179
180
181');
182INSERT INTO public.domande VALUES (8, 0, 7, 'Quanti numeri scrive sullo schermo il seguente codice:
183int k,h, j= 7, i = 9;
184for (k = j+1; k <  i+1; k++ )
185    for (h = j-1; h <= j+1; h++ )   
186             printf(\"%d\\n\", h );
187');
188
189
190--
191-- Data for Name: insegnamento; Type: TABLE DATA; Schema: public; Owner: alessioprete
192--
193
194INSERT INTO public.insegnamento VALUES (0, 4);
195
196
197--
198-- Data for Name: materie; Type: TABLE DATA; Schema: public; Owner: alessioprete
199--
200
201INSERT INTO public.materie VALUES (0, 'Italiano');
202INSERT INTO public.materie VALUES (1, 'Storia');
203INSERT INTO public.materie VALUES (2, 'Informatica');
204INSERT INTO public.materie VALUES (3, 'Sistemi e Reti');
205INSERT INTO public.materie VALUES (4, 'GPO');
206INSERT INTO public.materie VALUES (5, 'TPS');
207INSERT INTO public.materie VALUES (6, 'Matematica');
208INSERT INTO public.materie VALUES (7, 'Inglese');
209
210
211--
212-- Data for Name: professori; Type: TABLE DATA; Schema: public; Owner: alessioprete
213--
214
215INSERT INTO public.professori VALUES (0, 'Pippo', 'Baudo', 'prof_0000', 'Lillo', 'scisc@gmail.com');
216
217
218--
219-- Data for Name: risposte; Type: TABLE DATA; Schema: public; Owner: alessioprete
220--
221
222INSERT INTO public.risposte VALUES (8, 3, '63 numeri
223', false);
224INSERT INTO public.risposte VALUES (8, 4, '
225', false);
226INSERT INTO public.risposte VALUES (1, 0, 'No
227', true);
228INSERT INTO public.risposte VALUES (1, 1, 'Si, con l opzione \"Visualizza/Html\"
229', false);
230INSERT INTO public.risposte VALUES (1, 2, 'Si, se il programma PHP ha il permesso di lettura impostato
231', false);
232INSERT INTO public.risposte VALUES (1, 3, 'Si
233', false);
234INSERT INTO public.risposte VALUES (1, 4, 'Non lo so
235', false);
236INSERT INTO public.risposte VALUES (2, 0, 'I vettori vengono passati per indirizzo, le variabili per valore
237', true);
238INSERT INTO public.risposte VALUES (2, 1, 'I vettori vengono passati per valore, le variabili per indirizzo
239', false);
240INSERT INTO public.risposte VALUES (2, 2, 'Sia i vettori che le variabili vengono sempre passati per valore
241', false);
242INSERT INTO public.risposte VALUES (2, 3, 'Sia i vettori che le variabili vengono sempre passati per indirizzo
243', false);
244INSERT INTO public.risposte VALUES (2, 4, '
245', false);
246INSERT INTO public.risposte VALUES (3, 0, 'Vera, falsa, vera, false
247', false);
248INSERT INTO public.risposte VALUES (3, 1, 'Falsa, falsa, vera, vera
249', true);
250INSERT INTO public.risposte VALUES (3, 2, 'Falsa, falsa, vera, falsa
251', false);
252INSERT INTO public.risposte VALUES (3, 3, '
253', false);
254INSERT INTO public.risposte VALUES (3, 4, '
255', false);
256INSERT INTO public.risposte VALUES (4, 0, 'Infinite volte
257', true);
258INSERT INTO public.risposte VALUES (4, 1, '4 volte
259', false);
260INSERT INTO public.risposte VALUES (4, 2, '3 volte
261', false);
262INSERT INTO public.risposte VALUES (4, 3, '2 volte
263', false);
264INSERT INTO public.risposte VALUES (4, 4, '
265', false);
266INSERT INTO public.risposte VALUES (5, 0, '8 in a, 5 in b, 4 in c
267', true);
268INSERT INTO public.risposte VALUES (5, 1, '3 in a, 5 in b, 4 in c
269', false);
270INSERT INTO public.risposte VALUES (5, 2, '3 in a, 4 in b, 5 in c
271', false);
272INSERT INTO public.risposte VALUES (5, 3, '8 in a, 5 in b, 5 in c
273', false);
274INSERT INTO public.risposte VALUES (5, 4, '
275', false);
276INSERT INTO public.risposte VALUES (6, 0, '%d per gli int, %dl per i long, %db per i long float
277', false);
278INSERT INTO public.risposte VALUES (6, 1, '%d per i double, %l per i long, %i per gli interi
279', false);
280INSERT INTO public.risposte VALUES (6, 2, '%d per gli interi, %ld per i long, %f per i float
281', true);
282INSERT INTO public.risposte VALUES (6, 3, '%c per le stringhe, %n per i numeri
283', false);
284INSERT INTO public.risposte VALUES (6, 4, '
285', false);
286INSERT INTO public.risposte VALUES (7, 0, 'for ( i = 0; i <= 9; i++) v[i] = 0;
287', true);
288INSERT INTO public.risposte VALUES (7, 1, 'for ( i = 0; i <=10; i++) v[i] = 0;
289', false);
290INSERT INTO public.risposte VALUES (7, 2, 'for ( i = 1; i < 10; i++) v[i-1] = 0;
291', false);
292INSERT INTO public.risposte VALUES (7, 3, 'for ( i = 0; i < 9;  i++) v[i] = 0;
293', false);
294INSERT INTO public.risposte VALUES (7, 4, '
295', false);
296INSERT INTO public.risposte VALUES (8, 0, '3 numeri
297', false);
298INSERT INTO public.risposte VALUES (8, 1, '6 numeri
299', true);
300INSERT INTO public.risposte VALUES (8, 2, '9  numeri
301', false);
302
303
304--
305-- Data for Name: sessioni; Type: TABLE DATA; Schema: public; Owner: alessioprete
306--
307
308
309
310--
311-- Data for Name: test; Type: TABLE DATA; Schema: public; Owner: alessioprete
312--
313
314INSERT INTO public.test VALUES (0, 4, 0, 's');
315
316
317--
318-- Name: domande domande_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
319--
320
321ALTER TABLE ONLY public.domande
322    ADD CONSTRAINT domande_pkey PRIMARY KEY (codice);
323
324
325--
326-- Name: insegnamento insegnamento_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
327--
328
329ALTER TABLE ONLY public.insegnamento
330    ADD CONSTRAINT insegnamento_pkey PRIMARY KEY (codprof, codmateria);
331
332
333--
334-- Name: materie materie_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
335--
336
337ALTER TABLE ONLY public.materie
338    ADD CONSTRAINT materie_pkey PRIMARY KEY (codice);
339
340
341--
342-- Name: professori professori_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
343--
344
345ALTER TABLE ONLY public.professori
346    ADD CONSTRAINT professori_pkey PRIMARY KEY (codice);
347
348
349--
350-- Name: risposte risposte_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
351--
352
353ALTER TABLE ONLY public.risposte
354    ADD CONSTRAINT risposte_pkey PRIMARY KEY (coddom, numero);
355
356
357--
358-- Name: sessioni sessioni_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
359--
360
361ALTER TABLE ONLY public.sessioni
362    ADD CONSTRAINT sessioni_pkey PRIMARY KEY (codice);
363
364
365--
366-- Name: test test_pkey; Type: CONSTRAINT; Schema: public; Owner: alessioprete
367--
368
369ALTER TABLE ONLY public.test
370    ADD CONSTRAINT test_pkey PRIMARY KEY (codice);
371
372
373--
374-- Name: domande domande_codtest_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
375--
376
377ALTER TABLE ONLY public.domande
378    ADD CONSTRAINT domande_codtest_fkey FOREIGN KEY (codtest) REFERENCES public.test(codice) ON DELETE CASCADE;
379
380
381--
382-- Name: insegnamento insegnamento_codmateria_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
383--
384
385ALTER TABLE ONLY public.insegnamento
386    ADD CONSTRAINT insegnamento_codmateria_fkey FOREIGN KEY (codmateria) REFERENCES public.materie(codice);
387
388
389--
390-- Name: insegnamento insegnamento_codprof_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
391--
392
393ALTER TABLE ONLY public.insegnamento
394    ADD CONSTRAINT insegnamento_codprof_fkey FOREIGN KEY (codprof) REFERENCES public.professori(codice) ON DELETE CASCADE;
395
396
397--
398-- Name: risposte risposte_coddom_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
399--
400
401ALTER TABLE ONLY public.risposte
402    ADD CONSTRAINT risposte_coddom_fkey FOREIGN KEY (coddom) REFERENCES public.domande(codice) ON DELETE CASCADE;
403
404
405--
406-- Name: sessioni sessioni_codprof_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
407--
408
409ALTER TABLE ONLY public.sessioni
410    ADD CONSTRAINT sessioni_codprof_fkey FOREIGN KEY (codprof) REFERENCES public.professori(codice) ON DELETE CASCADE;
411
412
413--
414-- Name: sessioni sessioni_codtest_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
415--
416
417ALTER TABLE ONLY public.sessioni
418    ADD CONSTRAINT sessioni_codtest_fkey FOREIGN KEY (codtest) REFERENCES public.test(codice) ON DELETE CASCADE;
419
420
421--
422-- Name: test test_codmat_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
423--
424
425ALTER TABLE ONLY public.test
426    ADD CONSTRAINT test_codmat_fkey FOREIGN KEY (codmat) REFERENCES public.materie(codice);
427
428
429--
430-- Name: test test_codprof_fkey; Type: FK CONSTRAINT; Schema: public; Owner: alessioprete
431--
432
433ALTER TABLE ONLY public.test
434    ADD CONSTRAINT test_codprof_fkey FOREIGN KEY (codprof) REFERENCES public.professori(codice) ON DELETE CASCADE;
435
436
437--
438-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
439--
440
441REVOKE ALL ON SCHEMA public FROM PUBLIC;
442GRANT ALL ON SCHEMA public TO alessioprete;
443GRANT ALL ON SCHEMA public TO alessioprete_fermi;
444
445
446--
447-- Name: TABLE domande; Type: ACL; Schema: public; Owner: alessioprete
448--
449
450GRANT ALL ON TABLE public.domande TO alessioprete_fermi;
451
452
453--
454-- Name: TABLE insegnamento; Type: ACL; Schema: public; Owner: alessioprete
455--
456
457GRANT ALL ON TABLE public.insegnamento TO alessioprete_fermi;
458
459
460--
461-- Name: TABLE materie; Type: ACL; Schema: public; Owner: alessioprete
462--
463
464GRANT ALL ON TABLE public.materie TO alessioprete_fermi;
465
466
467--
468-- Name: TABLE professori; Type: ACL; Schema: public; Owner: alessioprete
469--
470
471GRANT ALL ON TABLE public.professori TO alessioprete_fermi;
472
473
474--
475-- Name: TABLE risposte; Type: ACL; Schema: public; Owner: alessioprete
476--
477
478GRANT ALL ON TABLE public.risposte TO alessioprete_fermi;
479
480
481--
482-- Name: TABLE sessioni; Type: ACL; Schema: public; Owner: alessioprete
483--
484
485GRANT ALL ON TABLE public.sessioni TO alessioprete_fermi;
486
487
488--
489-- Name: TABLE test; Type: ACL; Schema: public; Owner: alessioprete
490--
491
492GRANT ALL ON TABLE public.test TO alessioprete_fermi;
493
494
495--
496-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: -; Owner: alessioprete
497--
498
499ALTER DEFAULT PRIVILEGES FOR ROLE alessioprete GRANT ALL ON SEQUENCES  TO alessioprete_fermi;
500
501
502--
503-- Name: DEFAULT PRIVILEGES FOR FUNCTIONS; Type: DEFAULT ACL; Schema: -; Owner: alessioprete
504--
505
506ALTER DEFAULT PRIVILEGES FOR ROLE alessioprete GRANT ALL ON FUNCTIONS  TO alessioprete_fermi;
507
508
509--
510-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: -; Owner: alessioprete
511--
512
513ALTER DEFAULT PRIVILEGES FOR ROLE alessioprete GRANT ALL ON TABLES  TO alessioprete_fermi;
514
515
516--
517-- PostgreSQL database dump complete
518--