[icinga-checkins] icinga.org: icingaweb2-module-director/master: schema/mysql: case insensitive datalist entry names

git at icinga.org git at icinga.org
Wed Oct 5 22:13:57 CEST 2016


Module: icingaweb2-module-director
Branch: master
Commit: c4c5706a629880bfbe6d62957e7dabe9d615656d
URL:    https://git.icinga.org/?p=icingaweb2-module-director.git;a=commit;h=c4c5706a629880bfbe6d62957e7dabe9d615656d

Author: Thomas Gelf <thomas at gelf.net>
Date:   Wed Oct  5 17:49:24 2016 +0000

schema/mysql: case insensitive datalist entry names

---

 schema/mysql-migrations/upgrade_112.sql |    6 ++++++
 schema/mysql.sql                        |    4 ++--
 2 files changed, 8 insertions(+), 2 deletions(-)

diff --git a/schema/mysql-migrations/upgrade_112.sql b/schema/mysql-migrations/upgrade_112.sql
new file mode 100644
index 0000000..5336d35
--- /dev/null
+++ b/schema/mysql-migrations/upgrade_112.sql
@@ -0,0 +1,6 @@
+ALTER TABLE director_datalist_entry
+  MODIFY COLUMN entry_name VARCHAR(255) COLLATE utf8_bin NOT NULL;
+
+INSERT INTO director_schema_migration
+  (schema_version, migration_time)
+  VALUES (112, NOW());
diff --git a/schema/mysql.sql b/schema/mysql.sql
index 0829d78..e0f08de 100644
--- a/schema/mysql.sql
+++ b/schema/mysql.sql
@@ -105,7 +105,7 @@ CREATE TABLE director_datalist (
 
 CREATE TABLE director_datalist_entry (
   list_id INT(10) UNSIGNED NOT NULL,
-  entry_name VARCHAR(255) NOT NULL,
+  entry_name VARCHAR(255) COLLATE utf8_bin NOT NULL;
   entry_value TEXT DEFAULT NULL,
   format enum ('string', 'expression', 'json'),
   PRIMARY KEY (list_id, entry_name),
@@ -1326,4 +1326,4 @@ CREATE TABLE sync_run (
 
 INSERT INTO director_schema_migration
   SET migration_time = NOW(),
-      schema_version = 110;
+      schema_version = 112;



More information about the icinga-checkins mailing list