13 lines
377 B
SQL
13 lines
377 B
SQL
DELIMITER $$
|
|
|
|
-- Vorstellung-Package
|
|
|
|
DROP PROCEDURE IF EXISTS `vrst_pub_add_vorstellung`$$
|
|
CREATE PROCEDURE `vrst_pub_add_vorstellung` (p_saalname VARCHAR(50), p_filmname VARCHAR(255), p_beginn DATETIME)
|
|
BEGIN
|
|
INSERT INTO Vorstellung (Beginn, fk_Film_ID, fk_Saal_ID) VALUES (p_beginn, film_pub_search_film(p_filmname), saal_pub_search_saal(p_saalname));
|
|
END$$
|
|
|
|
|
|
|
|
DELIMITER ; |