aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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 9caa2a81e..fb979d3a9 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -39,7 +39,8 @@ CREATE TABLE `prefix_entity_subtypes` (
`subtype` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
- UNIQUE KEY (`guid`)
+ UNIQUE KEY (`guid`),
+ UNIQUE KEY (`subtype`)
) ENGINE=MyISAM;
-- Describe relationships between entities, can describe friendships but also site membership, depending on context