diff options
| author | Adam <Adam@anope.org> | 2010-11-07 20:55:30 -0500 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2010-11-07 20:55:30 -0500 |
| commit | dc1252597ace34b5961b94333738b27b657f06de (patch) | |
| tree | dd89859c296ef300abb65953f418927303789a0f | |
| parent | 721ef7d34550f67dde8a56bb2131571436f03802 (diff) | |
Removed two primary keys on some metadata tables, they should not have them
| -rw-r--r-- | data/mysql/tables.sql | 4 |
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; -- -------------------------------------------------------- |