aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-20 11:51:36 +0000
committermarcus <marcus@36083f99-b078-4883-b0ff-0f9b5a30f544>2008-11-20 11:51:36 +0000
commit1d89455f5546d5fc6507fdd7319ac2387bc59615 (patch)
tree81c0a6d178b083eca80687965b451949afed6f0d
parent4157e3ccf1a5b6cffc3d58cbf661cd528340b5fa (diff)
downloadelgg-1d89455f5546d5fc6507fdd7319ac2387bc59615.tar.gz
elgg-1d89455f5546d5fc6507fdd7319ac2387bc59615.tar.bz2
Refs #569, #570, #571: Minor database schema errors corrected
git-svn-id: https://code.elgg.org/elgg/trunk@2474 36083f99-b078-4883-b0ff-0f9b5a30f544
-rw-r--r--engine/schema/mysql.sql2
-rw-r--r--engine/schema/upgrades/2008111901.sql2
2 files changed, 2 insertions, 2 deletions
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