summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAleksander Machniak <machniak@kolabsys.com>2019-05-29 11:44:58 +0200
committerAleksander Machniak <machniak@kolabsys.com>2019-05-29 11:44:58 +0200
commit1bf9df4c94e70e38b629469d540a0d135a2b6a0c (patch)
tree5300cca58d60a7b66f1e3039e49638e9fe198754
parent5615f05304e58acc57924f02f03d115eb03e5bd6 (diff)
downloadpykolab-1bf9df4c94e70e38b629469d540a0d135a2b6a0c.tar.gz
Use UTF8 charset on smtp_access_policy tables (Bifrost#T162941)
On Debian 9's MariaDB default charset is set to utf8mb4, which causes problem with creating the unique indexes. We could probably use ASCII, but to be on safe side we use UTF8 which is the default on other platforms.
-rwxr-xr-xbin/kolab_smtp_access_policy.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/bin/kolab_smtp_access_policy.py b/bin/kolab_smtp_access_policy.py
index d2766de..e03bad0 100755
--- a/bin/kolab_smtp_access_policy.py
+++ b/bin/kolab_smtp_access_policy.py
@@ -95,6 +95,7 @@ policy_result_table = Table(
Column('sasl_sender', String(64)),
Column('created', Integer, nullable=False),
Column('data', PickleType, nullable=True),
+ mysql_charset='utf8',
)
Index(
@@ -139,6 +140,7 @@ statistic_table = Table(
Column('recipient', String(254), nullable=False),
Column('date', Date, nullable=False),
Column('count', Integer, nullable=False),
+ mysql_charset='utf8',
)
Index(