summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--designate/storage/impl_sqlalchemy/tables.py2
1 files changed, 2 insertions, 0 deletions
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',
)