forked from valeriapontillo/Progetto_GPS_IS
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSQL_INSERT_INTO.sql
84 lines (79 loc) · 3.09 KB
/
SQL_INSERT_INTO.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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
USE englishvalidation;
INSERT INTO user
VALUES('[email protected]','Segreteria','Studenti','M','4bb47fd2a6c598d2a52ef7de3473fd3ea8401a9b','1');
INSERT INTO user
VALUES('[email protected]','Filomena','Ferrucci','M','4bb47fd2a6c598d2a52ef7de3473fd3ea8401a9b','2');
INSERT INTO STATE
VALUES (1,'Parzialmente Completata');
INSERT INTO STATE
VALUES (2,'In elaborazione dalla Segreteria');
INSERT INTO STATE
VALUES (3,'In elaborazione dall" Amministratore');
INSERT INTO STATE
VALUES (4,'Accettata e In elaborazione dal Consiglio Didattico');
INSERT INTO STATE
VALUES (5,'Rifiutata e In elaborazione dal Consiglio Didattico');
INSERT INTO STATE
VALUES (6,'Conclusa e Accettata');
INSERT INTO STATE
VALUES (7,'Conclusa e Rifiutata');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-partially-completed', '1','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-working-secretary', '2','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-working-admin', '3','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-working-educational-advice-1', '4','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-working-educational-advice-2', '5','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-accepted', '6','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-refused', '7','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-number-max-upload', '2','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-allowed-extension-upload', '.pdf','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-matriculation-year-range', '5','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-min-cfu', '1','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-max-cfu', '12','[email protected]');
INSERT INTO SYSTEM_ATTRIBUTE
VALUES('request-upload-path', '//home//vale//newWorkspace//EV_EnglishValidation//uploads//','[email protected]');
INSERT INTO ENTE
VALUES ('1', '','Cambridge Assessment English','', 1);
INSERT INTO ENTE
VALUES ('2', '','City and Guilds (Pitman)','', 1);
INSERT INTO ENTE
VALUES ('3', '','Edexcel /Pearson Ltd','', 1);
INSERT INTO ENTE
VALUES ('4', '','Educational Testing Service (ETS)','', 1);
INSERT INTO ENTE
VALUES ('5', '','English Speaking Board (ESB)','', 1);
INSERT INTO ENTE
VALUES ('6', '','International English Language Testing System (IELTS)','', 1);
INSERT INTO ENTE
VALUES ('7', '','Pearson - LCCI','', 1);
INSERT INTO ENTE
VALUES ('8', '','Pearson - EDI','', 1);
INSERT INTO ENTE
VALUES ('9', '','Trinity College London (TCL)','', 1);
INSERT INTO ENTE
VALUES ('10', '','Department of English, Faculty of Arts - University of Malta','', 1);
INSERT INTO ENTE
VALUES ('11', '','NQAI - ACELS','', 1);
INSERT INTO ENTE
VALUES ('12', '','Ascentis','', 1);
INSERT INTO ENTE
VALUES ('13', '','AIM Awards','', 1);
INSERT INTO ENTE
VALUES ('14', '','Learning Resource Network (LRN)','', 1);
INSERT INTO ENTE
VALUES ('15', '','British Institutes','', 1);
INSERT INTO ENTE
VALUES ('16', '','Gatehouse Awards Ltd','', 1);
INSERT INTO ENTE
VALUES ('17', '','LanguageCert','', 1);