From 1d89455f5546d5fc6507fdd7319ac2387bc59615 Mon Sep 17 00:00:00 2001
From: marcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 20 Nov 2008 11:51:36 +0000
Subject: Refs #569, #570, #571: Minor database schema errors corrected

git-svn-id: https://code.elgg.org/elgg/trunk@2474 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 0bdd93d1b..3f22a6fb1 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -298,7 +298,7 @@ CREATE TABLE  IF NOT EXISTS `prefix_private_settings` (
 	`name` VARCHAR( 32 ) NOT NULL ,
 	`value` TEXT NOT NULL ,
 	PRIMARY KEY ( `id` ) ,
-	INDEX ( `entity_guid` , `name` )
+	UNIQUE KEY ( `entity_guid` , `name` )
 ) ENGINE = MYISAM  DEFAULT CHARSET=utf8;
 
 -- System log
-- 
cgit v1.2.3

