bin/build-master-status: be more flexible when creating the temporary todos-table

1 files changed, 7 insertions, 7 deletions

diff --git a/bin/build-master-status b/bin/build-master-status
index 0e80bd6..d74ff8a 100755
--- a/bin/build-master-status
+++ b/bin/build-master-status
@@ -561,13 +561,13 @@ if ${web}; then
     # insert unfound todos
     # shellcheck disable=SC2016
     {
-      printf 'CREATE TEMPORARY TABLE `td` ('
-      printf '`file` VARCHAR(64), '
-      printf '`line` MEDIUMINT, '
-      printf '`description` VARCHAR(128), '
-      printf 'UNIQUE KEY `position` (`file`,`line`), '
-      printf 'UNIQUE KEY `content` (`file`,`description`)'
-      printf ');'
+      printf 'SHOW CREATE TABLE `todos`' | \
+        ${mysql_command} --raw --batch | \
+        sed '
+          1d
+          2s/^\S\+\s\+CREATE TABLE `todos` /CREATE TEMPORARY TABLE `td` /
+        '
+      printf ';\n'
       printf 'INSERT INTO `td` (`file`,`line`,`description`) VALUES '
       while read -r file line desc; do
         printf '('