summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
authorMichael Tänzer <neo@nhng.de>2014-03-25 23:35:27 +0100
committerMichael Tänzer <neo@nhng.de>2014-03-25 23:35:27 +0100
commitd5520ccb753d2c6cc0074e311c60611949e47772 (patch)
tree4b2e7b30ab39076965355df7fe2122a78a15ac71 /scripts
parentf9391896167751a18329c51c24836850e8d4ffbb (diff)
downloadcacert-devel-d5520ccb753d2c6cc0074e311c60611949e47772.tar.gz
cacert-devel-d5520ccb753d2c6cc0074e311c60611949e47772.tar.xz
cacert-devel-d5520ccb753d2c6cc0074e311c60611949e47772.zip
bug 1172: sort alphabetically
Signed-off-by: Michael Tänzer <neo@nhng.de>
Diffstat (limited to 'scripts')
-rwxr-xr-xscripts/db_migrations/version5.sh121
1 files changed, 60 insertions, 61 deletions
diff --git a/scripts/db_migrations/version5.sh b/scripts/db_migrations/version5.sh
index 07fd354..f5ac851 100755
--- a/scripts/db_migrations/version5.sh
+++ b/scripts/db_migrations/version5.sh
@@ -109,51 +109,6 @@ system echo "table disputedomain altered to InnoDB"
ALTER TABLE disputeemail ENGINE=INNODB;
system echo "table disputeemail altered to InnoDB"
-
-ALTER TABLE gpg ENGINE=INNODB;
-system echo "table gpg altered to InnoDB"
-
-
-ALTER TABLE localias ENGINE=INNODB;
-system echo "table localias altered to InnoDB"
-
-
-ALTER TABLE news ENGINE=INNODB;
-system echo "table news altered to InnoDB"
-
-
-ALTER TABLE otphashes ENGINE=INNODB;
-system echo "table otphashes altered to InnoDB"
-
-
-ALTER TABLE pinglog ENGINE=INNODB;
-system echo "table pinglog altered to InnoDB"
-
-
-ALTER TABLE root_certs ENGINE=INNODB;
-system echo "table root_certs altered to InnoDB"
-
-
-ALTER TABLE stampcache ENGINE=INNODB;
-system echo "table stampcache altered to InnoDB"
-
-
-ALTER TABLE tickets ENGINE=INNODB;
-system echo "table tickets altered to InnoDB"
-
-
-ALTER TABLE languages ENGINE=INNODB;
-system echo "table languages altered to InnoDB"
-
-
-ALTER TABLE locations ENGINE=INNODB;
-system echo "table locations altered to InnoDB"
-
-
-ALTER TABLE regions ENGINE=INNODB;
-system echo "table regions altered to InnoDB"
-
-
ALTER TABLE domaincerts ENGINE=INNODB;
system echo "table domainderts altered to InnoDB"
@@ -166,6 +121,10 @@ ALTER TABLE domLink ENGINE=INNODB;
system echo "table domLink altered to InnoDB"
+ALTER TABLE email ENGINE=INNODB;
+system echo "table email altered to InnoDB"
+
+
ALTER TABLE emailcerts ENGINE=INNODB;
system echo "table emailcerts altered to InnoDB"
@@ -174,32 +133,32 @@ ALTER TABLE emaillink ENGINE=INNODB;
system echo "table emaillink altered to InnoDB"
-ALTER TABLE email ENGINE=INNODB;
-system echo "table email altered to InnoDB"
+ALTER TABLE gpg ENGINE=INNODB;
+system echo "table gpg altered to InnoDB"
-ALTER TABLE notary ENGINE=INNODB;
-system echo "table notary altered to InnoDB"
+ALTER TABLE languages ENGINE=INNODB;
+system echo "table languages altered to InnoDB"
-ALTER TABLE tverify ENGINE=INNODB;
-system echo "table tverify altered to InnoDB"
+ALTER TABLE localias ENGINE=INNODB;
+system echo "table localias altered to InnoDB"
-ALTER TABLE tverify-vote ENGINE=INNODB;
-system echo "table tverify-vote altered to InnoDB"
+ALTER TABLE locations ENGINE=INNODB;
+system echo "table locations altered to InnoDB"
-ALTER TABLE userlocations ENGINE=INNODB;
-system echo "table userlocations altered to InnoDB"
+ALTER TABLE news ENGINE=INNODB;
+system echo "table news altered to InnoDB"
-ALTER TABLE users ENGINE=INNODB;
-system echo "table users altered to InnoDB"
+ALTER TABLE notary ENGINE=INNODB;
+system echo "table notary altered to InnoDB"
-ALTER TABLE user_agreements ENGINE=INNODB;
-system echo "table user_agreements altered to InnoDB"
+ALTER TABLE org ENGINE=INNODB;
+system echo "table org altered to InnoDB"
ALTER TABLE orgdomaincerts ENGINE=INNODB;
@@ -226,14 +185,54 @@ ALTER TABLE orginfo ENGINE=INNODB;
system echo "table orginfo altered to InnoDB"
-ALTER TABLE org ENGINE=INNODB;
-system echo "table org altered to InnoDB"
+ALTER TABLE otphashes ENGINE=INNODB;
+system echo "table otphashes altered to InnoDB"
+
+
+ALTER TABLE pinglog ENGINE=INNODB;
+system echo "table pinglog altered to InnoDB"
+
+
+ALTER TABLE regions ENGINE=INNODB;
+system echo "table regions altered to InnoDB"
+
+
+ALTER TABLE root_certs ENGINE=INNODB;
+system echo "table root_certs altered to InnoDB"
+
+
+ALTER TABLE stampcache ENGINE=INNODB;
+system echo "table stampcache altered to InnoDB"
ALTER TABLE statscache ENGINE=INNODB;
system echo "table statscache altered to InnoDB"
+ALTER TABLE tickets ENGINE=INNODB;
+system echo "table tickets altered to InnoDB"
+
+
+ALTER TABLE tverify ENGINE=INNODB;
+system echo "table tverify altered to InnoDB"
+
+
+ALTER TABLE tverify-vote ENGINE=INNODB;
+system echo "table tverify-vote altered to InnoDB"
+
+
+ALTER TABLE user_agreements ENGINE=INNODB;
+system echo "table user_agreements altered to InnoDB"
+
+
+ALTER TABLE userlocations ENGINE=INNODB;
+system echo "table userlocations altered to InnoDB"
+
+
+ALTER TABLE users ENGINE=INNODB;
+system echo "table users altered to InnoDB"
+
+
-- Update schema version number
INSERT INTO `schema_version`
(`version`, `when`) VALUES