diff options
| -rw-r--r-- | engine/schema/mysql.sql | 2 | ||||
| -rw-r--r-- | engine/schema/upgrades/2008111901.sql | 2 |
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 |