X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=sql%2Fcore_domain.sql;h=4dbf039dba7deb29b6ffaa44632528140136a484;hp=f991b9984dfee931be39e595499859a66c2cb496;hb=297e960d0379cec716021747514b7c3eec972ab0;hpb=879d540ddbd7a408f85f8ebfab74624d0191d7f9

diff --git a/sql/core_domain.sql b/sql/core_domain.sql
index f991b998..4dbf039d 100644
--- a/sql/core_domain.sql
+++ b/sql/core_domain.sql
@@ -5,4 +5,6 @@ CREATE TABLE core_domain (
 );
 
 
-ALTER TABLE core_domain ADD COLUMN domain VARCHAR(256) NOT NULL DEFAULT '';
\ No newline at end of file
+ALTER TABLE core_domain ADD COLUMN domain VARCHAR(256) NOT NULL DEFAULT '';
+
+CREATE UNIQUE INDEX ui_domain ON core_domain (domain)
\ No newline at end of file