Zh1DvvVs

1/*DROP TABLE IF EXISTS ASIGNATURA;*/
2Create table IF NOT EXISTS ASIGNATURA(
3COD_ASIGNATURA INT NOT NULL AUTO_INCREMENT,
4CODIGO_PENSUM VARCHAR (20) NOT NULL DEFAULT '',
5DESCRIPCION_ASIGNATURA VARCHAR (50) NOT NULL DEFAULT '',
6UC_ASIGNATURA INT NOT NULL DEFAULT '0',
7HT TIME NOT NULL DEFAULT '00:00:00',
8HP TIME NOT NULL DEFAULT '00:00:00',
9HL TIME NOT NULL DEFAULT '00:00:00',
10PERIODO_PENSUM INT NOT NULL,
11PRIMARY KEY (COD_ASIGNATURA, CODIGO_PENSUM)
12); 
13     
14INSERT INTO ASIGNATURA (COD_ASIGNATURA, CODIGO_PENSUM, 
15 DESCRIPCION_ASIGNATURA, UC_ASIGNATURA, HT, HP, HL, PERIODO_PENSUM) VALUES
16 (1, 'MAT-21213', 'MATEMATICA I', 5, '03:00:00', '01:30:00', '00:00:00', 1),
17 (2, 'MAT-21225', 'MATEMATICA II', 5, '03:00:00','01:30:00','00:00:00', 2),
18 (3, 'MAT-21235', 'MATEMATICA III', 5, '03:00:00','01:30:00','00:00:00', 3),
19 (4, 'MAT-31214', 'CALCULO NUMERICO', 4, '02:15:00', '02:15:00', '00:00:00', 
20 4);