From 1d89455f5546d5fc6507fdd7319ac2387bc59615 Mon Sep 17 00:00:00 2001 From: marcus 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 +- engine/schema/upgrades/2008111901.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'engine/schema') 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 diff --git a/engine/schema/upgrades/2008111901.sql b/engine/schema/upgrades/2008111901.sql index af1f0182f..8ff20c626 100644 --- a/engine/schema/upgrades/2008111901.sql +++ b/engine/schema/upgrades/2008111901.sql @@ -4,5 +4,5 @@ `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; \ No newline at end of file -- cgit v1.2.3