From c6eb3fa7bffb5c5c2d296dee9de796d7a81af0fd Mon Sep 17 00:00:00 2001 From: Erik Olof Gunnar Andersson Date: Wed, 27 Mar 2019 21:42:53 -0700 Subject: Added missing service_statuses metadata This is a follow up to I307a8f7dd8b8a83effa447a846db3288efa32dba Adding the same constraint to the sql metadata. Change-Id: Iadb2660d306c8920c2202ae6bffec2ef621af36c --- designate/storage/impl_sqlalchemy/tables.py | 2 ++ 1 file changed, 2 insertions(+) diff --git a/designate/storage/impl_sqlalchemy/tables.py b/designate/storage/impl_sqlalchemy/tables.py index 8549cfc5..8adb14d2 100644 --- a/designate/storage/impl_sqlalchemy/tables.py +++ b/designate/storage/impl_sqlalchemy/tables.py @@ -70,6 +70,8 @@ service_status = Table("service_statuses", metadata, Column('stats', types.JsonEncodedDict, nullable=False), Column('capabilities', types.JsonEncodedDict, nullable=False), + UniqueConstraint('service_name', 'hostname', name="unique_service_status"), + mysql_engine='InnoDB', mysql_charset='utf8', ) -- cgit v1.2.1