From ba867942a6ff84d9623baf24a07af945a9e49948 Mon Sep 17 00:00:00 2001 From: icewing Date: Thu, 13 Mar 2008 16:07:10 +0000 Subject: Marcus Povey * Made URL unique git-svn-id: https://code.elgg.org/elgg/trunk@202 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/schema/mysql.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'engine') diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql index 4526da43d..adb33318b 100644 --- a/engine/schema/mysql.sql +++ b/engine/schema/mysql.sql @@ -96,7 +96,8 @@ CREATE TABLE `prefix_sites_entity` ( `description` text NOT NULL, `url` text NOT NULL, - PRIMARY KEY (`guid`) + PRIMARY KEY (`guid`), + UNIQUE KEY (`url`) ) ENGINE=MyISAM ; -- Extra information relating to "users" -- cgit v1.2.3