/*DROP TABLE IF EXISTS ASIGNATURA;*/
Create table IF NOT EXISTS ASIGNATURA(
COD_ASIGNATURA INT NOT NULL AUTO_INCREMENT,
CODIGO_PENSUM VARCHAR (20) NOT NULL DEFAULT '',
DESCRIPCION_ASIGNATURA VARCHAR (50) NOT NULL DEFAULT '',
UC_ASIGNATURA INT NOT NULL DEFAULT '0',
HT TIME NOT NULL DEFAULT '00:00:00',
HP TIME NOT NULL DEFAULT '00:00:00',
HL TIME NOT NULL DEFAULT '00:00:00',
PERIODO_PENSUM INT NOT NULL,
PRIMARY KEY (COD_ASIGNATURA, CODIGO_PENSUM)
);

INSERT INTO ASIGNATURA (COD_ASIGNATURA, CODIGO_PENSUM,
 DESCRIPCION_ASIGNATURA, UC_ASIGNATURA, HT, HP, HL, PERIODO_PENSUM) VALUES
 (1, 'MAT-21213', 'MATEMATICA I', 5, '03:00:00', '01:30:00', '00:00:00', 1),
 (2, 'MAT-21225', 'MATEMATICA II', 5, '03:00:00','01:30:00','00:00:00', 2),
 (3, 'MAT-21235', 'MATEMATICA III', 5, '03:00:00','01:30:00','00:00:00', 3),
 (4, 'MAT-31214', 'CALCULO NUMERICO', 4, '02:15:00', '02:15:00', '00:00:00',
 4);