9 files changed, 2 insertions, 14 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php
index 9f2015f38e..bc1e28572d 100644
--- a/phpBB/develop/create_schema_files.php
+++ b/phpBB/develop/create_schema_files.php
@@ -1038,7 +1038,6 @@ function get_schema_struct()
 		),
 		'KEYS'			=> array(
 			'ext_name'				=> array('UNIQUE', 'ext_name'),
-			'ext_active'			=> array('INDEX', 'ext_active'),
 		),
 	);
 
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php
index 64dea37ef8..45de19c918 100644
--- a/phpBB/install/database_update.php
+++ b/phpBB/install/database_update.php
@@ -1063,7 +1063,6 @@ function database_update_info()
 					),
 					'KEYS'				=> array(
 						'ext_name'		=> array('UNIQUE', 'ext_name'),
-						'ext_active'	=> array('INDEX', 'ext_active'),
 					),
 				),
 			),
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 5f5aaaaa45..4952b6bbdf 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -288,7 +288,6 @@ CREATE TABLE phpbb_ext (
 );;
 
 CREATE UNIQUE INDEX phpbb_ext_ext_name ON phpbb_ext(ext_name);;
-CREATE INDEX phpbb_ext_ext_active ON phpbb_ext(ext_active);;
 
 # Table: 'phpbb_extensions'
 CREATE TABLE phpbb_extensions (
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 052531993f..76f3fc6491 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -370,9 +370,6 @@ GO
 CREATE  UNIQUE  INDEX [ext_name] ON [phpbb_ext]([ext_name]) ON [PRIMARY]
 GO
 
-CREATE  INDEX [ext_active] ON [phpbb_ext]([ext_active]) ON [PRIMARY]
-GO
-
 
 /*
 	Table: 'phpbb_extensions'
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql
index 03402d7ed1..a1b282418d 100644
--- a/phpBB/install/schemas/mysql_40_schema.sql
+++ b/phpBB/install/schemas/mysql_40_schema.sql
@@ -195,8 +195,7 @@ CREATE TABLE phpbb_drafts (
 CREATE TABLE phpbb_ext (
 	ext_name varbinary(255) DEFAULT '' NOT NULL,
 	ext_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	UNIQUE ext_name (ext_name),
-	KEY ext_active (ext_active)
+	UNIQUE ext_name (ext_name)
 );
 
 
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index 8876b52a30..2f2de17dcb 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -195,8 +195,7 @@ CREATE TABLE phpbb_drafts (
 CREATE TABLE phpbb_ext (
 	ext_name varchar(255) DEFAULT '' NOT NULL,
 	ext_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
-	UNIQUE ext_name (ext_name),
-	KEY ext_active (ext_active)
+	UNIQUE ext_name (ext_name)
 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
 
 
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index df31f6d3d6..f0a958d2f6 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -417,8 +417,6 @@ CREATE TABLE phpbb_ext (
 )
 /
 
-CREATE INDEX phpbb_ext_ext_active ON phpbb_ext (ext_active)
-/
 
 /*
 	Table: 'phpbb_extensions'
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index dbe891a3ac..956167ff39 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -321,7 +321,6 @@ CREATE TABLE phpbb_ext (
 );
 
 CREATE UNIQUE INDEX phpbb_ext_ext_name ON phpbb_ext (ext_name);
-CREATE INDEX phpbb_ext_ext_active ON phpbb_ext (ext_active);
 
 /*
 	Table: 'phpbb_extensions'
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index 3c1d476daa..223dbc3c02 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -193,7 +193,6 @@ CREATE TABLE phpbb_ext (
 );
 
 CREATE UNIQUE INDEX phpbb_ext_ext_name ON phpbb_ext (ext_name);
-CREATE INDEX phpbb_ext_ext_active ON phpbb_ext (ext_active);
 
 # Table: 'phpbb_extensions'
 CREATE TABLE phpbb_extensions (