bin/bootstrap-mysql: add "ON ... CASCADE" to foreign keys

1 files changed, 1 insertions, 1 deletions

diff --git a/bin/bootstrap-mysql b/bin/bootstrap-mysql
index b2277e9..eb37900 100755
--- a/bin/bootstrap-mysql
+++ b/bin/bootstrap-mysql
@@ -234,7 +234,7 @@ if [ ! "$1" = 'slim' ]; then
                           tr ' ' '\n' | \
                           sed -n 's/^://;T;p' | \
                           while read -r link; do
-                            printf 'ALTER TABLE `%s` ADD FOREIGN KEY (`%s`) REFERENCES `%s` (`id`);\n' \
+                            printf 'ALTER TABLE `%s` ADD FOREIGN KEY (`%s`) REFERENCES `%s` (`id`) ON UPDATE CASCADE ON DELETE CASCADE;\n' \
                               "${table}" \
                               "${column}" \
                               "${link}"