diff options
| author | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-13 16:07:10 +0000 |
|---|---|---|
| committer | icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2008-03-13 16:07:10 +0000 |
| commit | ba867942a6ff84d9623baf24a07af945a9e49948 (patch) | |
| tree | 9c41cd650d8063313e5483c15e9cacf861853b58 /engine/schema | |
| parent | 722f5f5469c30aeb76a42996f016c2e8a0ec9073 (diff) | |
| download | elgg-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.sql | 3 |
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"
|