From 3199b9ebfa707068fd2c901276e663b660d1a050 Mon Sep 17 00:00:00 2001 From: Sean Date: Fri, 24 Mar 2023 14:07:58 +0100 Subject: Update procedures.sql --- dbinit/procedures.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'dbinit') diff --git a/dbinit/procedures.sql b/dbinit/procedures.sql index b6b0042..73627c2 100644 --- a/dbinit/procedures.sql +++ b/dbinit/procedures.sql @@ -10,3 +10,14 @@ create procedure spUpdateFlags(imgPath varchar(255)) where `B`.`ID` = `A`.`ID`); end$$ delimiter ; + +drop procedure if exists spDeleteFlags; + +delimiter $$ +create procedure spDeleteFlags() + begin + update `nationality` + set `nationality`.`flag` = NULL + where `nationality`.`flag` is not NULL + end$$ +delimiter ; -- cgit v1.2.3