diff options
Diffstat (limited to 'dbinit')
| -rw-r--r-- | dbinit/procedures.sql | 11 |
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 ; |