From dc1252597ace34b5961b94333738b27b657f06de Mon Sep 17 00:00:00 2001 From: Adam Date: Sun, 7 Nov 2010 20:55:30 -0500 Subject: Removed two primary keys on some metadata tables, they should not have them --- data/mysql/tables.sql | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'data') 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; -- -------------------------------------------------------- -- cgit