summaryrefslogtreecommitdiff
path: root/bin
diff options
context:
space:
mode:
Diffstat (limited to 'bin')
-rwxr-xr-xbin/build-master-status14
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 '('