summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorMichael Tänzer <neo@nhng.de>2014-03-25 23:23:10 +0100
committerMichael Tänzer <neo@nhng.de>2014-03-25 23:23:10 +0100
commitf9391896167751a18329c51c24836850e8d4ffbb (patch)
tree2b9d4ae6ac8b26ddf55278c6b227f2b0504fa30e /scripts
parent5bc099c45abbee927d850594e93fe82cc18fe6f3 (diff)
downloadcacert-devel-f9391896167751a18329c51c24836850e8d4ffbb.tar.gz
cacert-devel-f9391896167751a18329c51c24836850e8d4ffbb.tar.xz
cacert-devel-f9391896167751a18329c51c24836850e8d4ffbb.zip
bug 1172: MySQL doesn't have echo
Signed-off-by: Michael Tänzer <neo@nhng.de>
Diffstat (limited to 'scripts')
-rwxr-xr-xscripts/db_migrations/version5.sh132
1 files changed, 44 insertions, 88 deletions
diff --git a/scripts/db_migrations/version5.sh b/scripts/db_migrations/version5.sh
index dc5828d..07fd354 100755
--- a/scripts/db_migrations/version5.sh
+++ b/scripts/db_migrations/version5.sh
@@ -59,223 +59,179 @@ mysql $mysql_opt <<- 'SQL'
-- Move myISAM to InnoDB bug #1172
ALTER TABLE schema_version ENGINE=INNODB;
-
-echo "table schema_version altered to InnoDB"
+system echo "table schema_version altered to InnoDB"
ALTER TABLE abuserreports ENGINE=INNODB;
-
-echo "table abusereports altered to InnoDB"
+system echo "table abusereports altered to InnoDB"
ALTER TABLE addlang ENGINE=INNODB;
-
-echo "table addlang altered to InnoDB"
+system echo "table addlang altered to InnoDB"
ALTER TABLE adminlog ENGINE=INNODB;
-
-echo "table adminlog altered to InnoDB"
+system echo "table adminlog altered to InnoDB"
ALTER TABLE advertising ENGINE=INNODB;
-
-echo "table advertising altered to InnoDB"
+system echo "table advertising altered to InnoDB"
ALTER TABLE alerts ENGINE=INNODB;
-
-echo "table alerts altered to InnoDB"
+system echo "table alerts altered to InnoDB"
ALTER TABLE baddomains ENGINE=INNODB;
-
-echo "table baddomains altered to InnoDB"
+system echo "table baddomains altered to InnoDB"
ALTER TABLE cats_passed ENGINE=INNODB;
-
-echo "table cats_passed altered to InnoDB"
+system echo "table cats_passed altered to InnoDB"
ALTER TABLE cats_type ENGINE=INNODB;
-
-echo "table cats_type altered to InnoDB"
+system echo "table cats_type altered to InnoDB"
ALTER TABLE cats_variant ENGINE=INNODB;
-
-echo "table cats_variant altered to InnoDB"
+system echo "table cats_variant altered to InnoDB"
ALTER TABLE countries ENGINE=INNODB;
-
-echo "table countries altered to InnoDB"
+system echo "table countries altered to InnoDB"
ALTER TABLE disputedomain ENGINE=INNODB;
-
-echo "table disputedomain altered to InnoDB"
+system echo "table disputedomain altered to InnoDB"
ALTER TABLE disputeemail ENGINE=INNODB;
-
-echo "table disputeemail altered to InnoDB"
+system echo "table disputeemail altered to InnoDB"
ALTER TABLE gpg ENGINE=INNODB;
-
-echo "table gpg altered to InnoDB"
+system echo "table gpg altered to InnoDB"
ALTER TABLE localias ENGINE=INNODB;
-
-echo "table localias altered to InnoDB"
+system echo "table localias altered to InnoDB"
ALTER TABLE news ENGINE=INNODB;
-
-echo "table news altered to InnoDB"
+system echo "table news altered to InnoDB"
ALTER TABLE otphashes ENGINE=INNODB;
-
-echo "table otphashes altered to InnoDB"
+system echo "table otphashes altered to InnoDB"
ALTER TABLE pinglog ENGINE=INNODB;
-
-echo "table pinglog altered to InnoDB"
+system echo "table pinglog altered to InnoDB"
ALTER TABLE root_certs ENGINE=INNODB;
-
-echo "table root_certs altered to InnoDB"
+system echo "table root_certs altered to InnoDB"
ALTER TABLE stampcache ENGINE=INNODB;
-
-echo "table stampcache altered to InnoDB"
+system echo "table stampcache altered to InnoDB"
ALTER TABLE tickets ENGINE=INNODB;
-
-echo "table tickets altered to InnoDB"
+system echo "table tickets altered to InnoDB"
ALTER TABLE languages ENGINE=INNODB;
-
-echo "table languages altered to InnoDB"
+system echo "table languages altered to InnoDB"
ALTER TABLE locations ENGINE=INNODB;
-
-echo "table locations altered to InnoDB"
+system echo "table locations altered to InnoDB"
ALTER TABLE regions ENGINE=INNODB;
-
-echo "table regions altered to InnoDB"
+system echo "table regions altered to InnoDB"
ALTER TABLE domaincerts ENGINE=INNODB;
-
-echo "table domainderts altered to InnoDB"
+system echo "table domainderts altered to InnoDB"
ALTER TABLE domains ENGINE=INNODB;
-
-echo "table domains altered to InnoDB"
+system echo "table domains altered to InnoDB"
ALTER TABLE domLink ENGINE=INNODB;
-
-echo "table domLink altered to InnoDB"
+system echo "table domLink altered to InnoDB"
ALTER TABLE emailcerts ENGINE=INNODB;
-
-echo "table emailcerts altered to InnoDB"
+system echo "table emailcerts altered to InnoDB"
ALTER TABLE emaillink ENGINE=INNODB;
-
-echo "table emaillink altered to InnoDB"
+system echo "table emaillink altered to InnoDB"
ALTER TABLE email ENGINE=INNODB;
-
-echo "table email altered to InnoDB"
+system echo "table email altered to InnoDB"
ALTER TABLE notary ENGINE=INNODB;
-
-echo "table notary altered to InnoDB"
+system echo "table notary altered to InnoDB"
ALTER TABLE tverify ENGINE=INNODB;
-
-echo "table tverify altered to InnoDB"
+system echo "table tverify altered to InnoDB"
ALTER TABLE tverify-vote ENGINE=INNODB;
-
-echo "table tverify-vote altered to InnoDB"
+system echo "table tverify-vote altered to InnoDB"
ALTER TABLE userlocations ENGINE=INNODB;
-
-echo "table userlocations altered to InnoDB"
+system echo "table userlocations altered to InnoDB"
ALTER TABLE users ENGINE=INNODB;
-
-echo "table users altered to InnoDB"
+system echo "table users altered to InnoDB"
ALTER TABLE user_agreements ENGINE=INNODB;
-
-echo "table user_agreements altered to InnoDB"
+system echo "table user_agreements altered to InnoDB"
ALTER TABLE orgdomaincerts ENGINE=INNODB;
-
-echo "table orgdomaincerts altered to InnoDB"
+system echo "table orgdomaincerts altered to InnoDB"
ALTER TABLE orgdomains ENGINE=INNODB;
-
-echo "table orgdomains altered to InnoDB"
+system echo "table orgdomains altered to InnoDB"
ALTER TABLE orgdomlink ENGINE=INNODB;
-
-echo "table orgdomlink altered to InnoDB"
+system echo "table orgdomlink altered to InnoDB"
ALTER TABLE orgemailcerts ENGINE=INNODB;
-
-echo "table orgemailcerts altered to InnoDB"
+system echo "table orgemailcerts altered to InnoDB"
ALTER TABLE orgemaillink ENGINE=INNODB;
-
-echo "table orgemaillink altered to InnoDB"
+system echo "table orgemaillink altered to InnoDB"
ALTER TABLE orginfo ENGINE=INNODB;
-
-echo "table orginfo altered to InnoDB"
+system echo "table orginfo altered to InnoDB"
ALTER TABLE org ENGINE=INNODB;
-
-echo "table org altered to InnoDB"
+system echo "table org altered to InnoDB"
ALTER TABLE statscache ENGINE=INNODB;
-
-echo "table statscache altered to InnoDB"
+system echo "table statscache altered to InnoDB"
-- Update schema version number