From 5f112e7d0464d98282443b78870cdccabe42aae9 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sun, 28 Apr 2024 14:47:35 +0200
Subject: Adding upstream version 1:1.1.2.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 etc/schema/mysql-upgrade/v1.1.0.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 etc/schema/mysql-upgrade/v1.1.0.sql

(limited to 'etc/schema/mysql-upgrade/v1.1.0.sql')

diff --git a/etc/schema/mysql-upgrade/v1.1.0.sql b/etc/schema/mysql-upgrade/v1.1.0.sql
new file mode 100644
index 0000000..055d783
--- /dev/null
+++ b/etc/schema/mysql-upgrade/v1.1.0.sql
@@ -0,0 +1,4 @@
+ALTER TABLE x509_target DROP INDEX x509_idx_target_ip_port_hostname;
+ALTER TABLE x509_target ADD INDEX x509_idx_target_ip_port (ip, port);
+ALTER TABLE x509_certificate MODIFY COLUMN valid_from bigint(20) NOT NULL;
+ALTER TABLE x509_certificate MODIFY COLUMN valid_to bigint(20) NOT NULL;
-- 
cgit v1.2.3

