summaryrefslogtreecommitdiff
path: root/scripts/db_migrations/version4.sh
diff options
context:
space:
mode:
authorMichael Tänzer <neo@nhng.de>2013-11-27 00:20:09 +0100
committerMichael Tänzer <neo@nhng.de>2013-11-27 00:20:09 +0100
commitd769eb50a3b878d0828679728a623985536df3eb (patch)
tree8cecae8946fc25cb7bda73310e2c805125b41243 /scripts/db_migrations/version4.sh
parent8a800f629e9d685d7c454d8fb16737f4cb8d9368 (diff)
downloadcacert-devel-d769eb50a3b878d0828679728a623985536df3eb.tar.gz
cacert-devel-d769eb50a3b878d0828679728a623985536df3eb.tar.xz
cacert-devel-d769eb50a3b878d0828679728a623985536df3eb.zip
Bug 1135: Fix SQL queries in many ways:
- Add semicolons - uniform definition of `information` column - capitalisation of table names - name the output file for adminlog backup Signed-off-by: Michael Tänzer <neo@nhng.de>
Diffstat (limited to 'scripts/db_migrations/version4.sh')
-rw-r--r--scripts/db_migrations/version4.sh8
1 files changed, 4 insertions, 4 deletions
diff --git a/scripts/db_migrations/version4.sh b/scripts/db_migrations/version4.sh
index 155a72e..9a8aded 100644
--- a/scripts/db_migrations/version4.sh
+++ b/scripts/db_migrations/version4.sh
@@ -62,22 +62,22 @@ mysql $mysql_opt <<- 'SQL'
-- dump table AdminLog
SELECT *
- INTO OUTFILE "???"
+ INTO OUTFILE "adminlog_table_backup_1135"
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
- FROM `adminlog`
+ FROM `adminlog`;
SQL
-echo "Dump table create in ???"
+echo "Dump table create in adminlog_table_backup_1135"
mysql $mysql_opt <<- 'SQL'
-- update table admin log
UPDATE `adminlog` SET `type` = 'old name or dob change',
-`information` = 'see dump ???'
+`information` = 'see adminlog_table_backup_1135';
-- alter table admin log