Update procedures.sql

1 files changed, 11 insertions, 0 deletions

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 ;