From b0c3e3958220c04cbb4f25f0c24b53b65a34e360 Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Fri, 16 Jun 2006 16:54:51 +0000
Subject: - removed db cache (might re-appear, but for now we do not see the
 need for it) - all changes to styles/subsilver/template are purely cosmetic
 (no functional changes) - cosmetics - bugfixes - add index to modules table -
 use modules ordering code for forums too

git-svn-id: file:///svn/phpbb/trunk@6073 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/install/schemas/mysql_schema.sql | 11 ++---------
 1 file changed, 2 insertions(+), 9 deletions(-)

(limited to 'phpBB/install/schemas/mysql_schema.sql')

diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index f03f704820..88d02429ef 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -132,14 +132,6 @@ CREATE TABLE phpbb_bots (
   KEY bot_active (bot_active)
 );
 
-# Table: 'phpbb_cache'
-CREATE TABLE phpbb_cache (
-  var_name varchar(255) DEFAULT '' NOT NULL,
-  var_expires int(10) UNSIGNED DEFAULT '0' NOT NULL,
-  var_data mediumtext,
-  PRIMARY KEY (var_name)
-);
-
 # Table: 'phpbb_config'
 CREATE TABLE phpbb_config (
   config_name varchar(255) NOT NULL,
@@ -362,7 +354,8 @@ CREATE TABLE phpbb_modules (
   module_auth varchar(255) DEFAULT '' NOT NULL,
   PRIMARY KEY  (module_id),
   KEY left_right_id (left_id, right_id),
-  KEY module_enabled (module_enabled)
+  KEY module_enabled (module_enabled),
+  KEY class_left_id (module_class, left_id)
 );
 
 # Table: 'phpbb_poll_options'
-- 
cgit v1.2.1

