summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--data/mysql/tables.sql4
1 files changed, 1 insertions, 3 deletions
diff --git a/data/mysql/tables.sql b/data/mysql/tables.sql
index d1f83f730..fb9b7335a 100644
--- a/data/mysql/tables.sql
+++ b/data/mysql/tables.sql
@@ -255,7 +255,6 @@ CREATE TABLE IF NOT EXISTS `anope_ns_alias_metadata` (
`nick` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`value` text NOT NULL,
- PRIMARY KEY (`name`),
KEY `FK_anope_ns_alias_metadata_nick` (`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -286,8 +285,7 @@ CREATE TABLE IF NOT EXISTS `anope_ns_core` (
CREATE TABLE IF NOT EXISTS `anope_ns_core_metadata` (
`nick` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
- `value` text NOT NULL,
- PRIMARY KEY (`name`)
+ `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------