aboutsummaryrefslogtreecommitdiff
path: root/engine/schema
diff options
context:
space:
mode:
authoricewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-13 16:07:10 +0000
committericewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-03-13 16:07:10 +0000
commitba867942a6ff84d9623baf24a07af945a9e49948 (patch)
tree9c41cd650d8063313e5483c15e9cacf861853b58 /engine/schema
parent722f5f5469c30aeb76a42996f016c2e8a0ec9073 (diff)
downloadelgg-ba867942a6ff84d9623baf24a07af945a9e49948.tar.gz
elgg-ba867942a6ff84d9623baf24a07af945a9e49948.tar.bz2
Marcus Povey <marcus@dushka.co.uk>
* Made URL unique git-svn-id: https://code.elgg.org/elgg/trunk@202 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine/schema')
-rw-r--r--engine/schema/mysql.sql3
1 files changed, 2 insertions, 1 deletions
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"