SQLize | PHPize | SQLtest

DROP DATABASE IF EXISTS aerolinea; CREATE DATABASE aerolinea; USE aerolinea; CREATE TABLE destinos ( id_destino CHAR(1) NOT NULL, pais VARCHAR(10) NOT NULL, estado VARCHAR(10) NOT NULL, nombre VARCHAR(20) NOT NULL, PRIMARY KEY (id_destino) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE vuelos ( id_vuelo VARCHAR(4) NOT NULL, origen CHAR(1) NOT NULL, destino CHAR(1) NOT NULL, salida TIME NOT NULL, arribo TIME NOT NULL, PRIMARY KEY (id_vuelo), CONSTRAINT `fk_destino` FOREIGN KEY (origen) REFERENCES destinos (id_destino) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `fk_origen` FOREIGN KEY (destino) REFERENCES destinos (id_destino) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE pasajeros ( id_pasajero VARCHAR(4) NOT NULL, id_vuelo VARCHAR(4) NOT NULL, nombre VARCHAR(20) NOT NULL, edad SMALLINT UNSIGNED, sexo CHAR(1) NOT NULL, PRIMARY KEY (id_pasajero, id_vuelo), CONSTRAINT `fk_id_vuelo` FOREIGN KEY (id_vuelo) REFERENCES vuelos (id_vuelo) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;