SHARE
TWEET

Untitled

a guest Jun 16th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*DROP TABLE IF EXISTS ASIGNATURA;*/
  2. Create table IF NOT EXISTS ASIGNATURA(
  3. COD_ASIGNATURA INT NOT NULL AUTO_INCREMENT,
  4. CODIGO_PENSUM VARCHAR (20) NOT NULL DEFAULT '',
  5. DESCRIPCION_ASIGNATURA VARCHAR (50) NOT NULL DEFAULT '',
  6. UC_ASIGNATURA INT NOT NULL DEFAULT '0',
  7. HT TIME NOT NULL DEFAULT '00:00:00',
  8. HP TIME NOT NULL DEFAULT '00:00:00',
  9. HL TIME NOT NULL DEFAULT '00:00:00',
  10. PERIODO_PENSUM INT NOT NULL,
  11. PRIMARY KEY (COD_ASIGNATURA, CODIGO_PENSUM)
  12. );
  13.      
  14. INSERT 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);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top