diff options
| author | Erich Eckner <git@eckner.net> | 2018-03-28 09:25:31 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-03-28 09:25:31 +0200 |
| commit | e305ab9221b5b65ece6afcd65b1ef825dcbbafd8 (patch) | |
| tree | bc2e84611aa3ec65e6cebff3c31922d3b946fb34 | |
| parent | 596be04ae9c2cff14d39241a6d3046c792423fb2 (diff) | |
| download | builder-e305ab9221b5b65ece6afcd65b1ef825dcbbafd8.tar.xz | |
bin/bootstrap-mysql: add "ON ... CASCADE" to foreign keys
| -rwxr-xr-x | bin/bootstrap-mysql | 2 |
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}" |