FcXNQ1es

1CREATE TABLE IF NOT EXISTS 'Materie'
2(
3	'ID_Materia' int(11) NOT NULL AUTO_INCREMENT,
4	'Denominazione' varchar(20) NOT NULL,
5	PRIMARY KEY('ID_Materia')
6)
7
8CREATE TABLE IF NOT EXISTS 'Studenti'
9(
10	'ID_Studente' int(11) NOT NULL AUTO_INCREMENT,
11	'Cognome' varchar(40) NOT NULL,
12	'Nome' varchar(40) NOT NULL,
13	'Telefono' varchar(10) NOT NULL,
14	'Email' varchar(50) NOT NULL,
15	'Password' varchar(16) NOT NULL,
16	'ID_Classe' int(11) NOT NULL,
17	PRIMARY KEY('ID_Studente')
18)
19
20CREATE TABLE IF NOT EXISTS 'Classi'
21(
22	'ID_Classe' int(11) NOT NULL AUTO_INCREMENT,
23	'Note' text NOT NULL,
24	'Sort' int(11) NOT NULL,
25	PRIMARY KEY('ID_Classe')
26)
27
28CREATE TABLE IF NOT EXISTS 'StudentiMaterie'
29(
30	'ID_Studente' int(11) NOT NULL,
31	'ID_Materia' int(11) NOT NULL,
32	'Validazione' boolean NOT NULL,
33	PRIMARY KEY('ID_Studente', 'ID_Materia')
34)
35
36CREATE TABLE IF NOT EXISTS 'Docenti'
37(
38	'ID_Docente' int(11) NOT NULL AUTO_INCREMENT,
39    'Cognome' varchar(40) NOT NULL,
40	'Nome' varchar(40) NOT NULL,
41	'Telefono' varchar(10) NOT NULL,
42	'Email' varchar(50) NOT NULL,
43	'Password' varchar(16) NOT NULL,
44	PRIMARY KEY('ID_Docente')
45)
46ENGINE = MyISCAM DEFAULT
47CHARSET = latin1
48AUTO_INCREMENT = 1;