aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2006-06-16 16:54:51 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2006-06-16 16:54:51 +0000
commitb0c3e3958220c04cbb4f25f0c24b53b65a34e360 (patch)
tree6c23cb4352a297b4dade2b3a1aa6706b89a53c82 /phpBB/install/schemas
parenta3c9182e0f9efeb193f5ef682d1945382f234eb3 (diff)
downloadforums-b0c3e3958220c04cbb4f25f0c24b53b65a34e360.tar
forums-b0c3e3958220c04cbb4f25f0c24b53b65a34e360.tar.gz
forums-b0c3e3958220c04cbb4f25f0c24b53b65a34e360.tar.bz2
forums-b0c3e3958220c04cbb4f25f0c24b53b65a34e360.tar.xz
forums-b0c3e3958220c04cbb4f25f0c24b53b65a34e360.zip
- 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
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql11
-rw-r--r--phpBB/install/schemas/mssql_schema.sql26
-rw-r--r--phpBB/install/schemas/mysql_schema.sql11
-rw-r--r--phpBB/install/schemas/oracle_schema.sql14
-rw-r--r--phpBB/install/schemas/postgres_schema.sql14
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql10
6 files changed, 10 insertions, 76 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index e74dff0f22..a505ed9578 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -204,16 +204,6 @@ BEGIN
END;;
-# phpbb_cache
-CREATE TABLE phpbb_cache (
- var_name VARCHAR(252) NOT NULL,
- var_expires INTEGER DEFAULT 0 NOT NULL,
- var_data BLOB SUB_TYPE TEXT
-);;
-
-ALTER TABLE phpbb_cache ADD PRIMARY KEY (var_name);;
-
-
# phpbb_config
CREATE TABLE phpbb_config (
config_name VARCHAR(252) NOT NULL,
@@ -565,6 +555,7 @@ ALTER TABLE phpbb_modules ADD PRIMARY KEY (module_id);;
CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules(module_enabled);;
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules(left_id, right_id);;
+CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules(module_class, left_id);;
CREATE GENERATOR phpbb_modules_gen;;
SET GENERATOR phpbb_modules_gen TO 0;;
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 937c9bf77b..72db08a523 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -330,29 +330,6 @@ GO
/*
- Table: phpbb_cache
-*/
-CREATE TABLE [phpbb_cache] (
- [var_name] [varchar] (255) NOT NULL ,
- [var_expires] [int] NOT NULL ,
- [var_data] [text]
-) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
-GO
-
-ALTER TABLE [phpbb_cache] WITH NOCHECK ADD
- CONSTRAINT [PK_phpbb_cache] PRIMARY KEY CLUSTERED
- (
- [var_name]
- ) ON [PRIMARY]
-GO
-
-ALTER TABLE [phpbb_cache] WITH NOCHECK ADD
- CONSTRAINT [DF_phpbb_cache__var_expires] DEFAULT (0) FOR [var_expires],
- CONSTRAINT [DF_phpbb_cache__var_name] DEFAULT ('') FOR [var_name]
-GO
-
-
-/*
Table: phpbb_config
*/
CREATE TABLE [phpbb_config] (
@@ -895,6 +872,9 @@ GO
CREATE INDEX [module_left_right_id] ON [phpbb_modules]([left_id], [right_id]) ON [PRIMARY]
GO
+CREATE INDEX [module_class_left_id] ON [phpbb_modules]([module_class], [left_id]) ON [PRIMARY]
+GO
+
/*
Table: phpbb_poll_options
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'
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 0137f98f5a..900232b79a 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -308,18 +308,6 @@ CREATE INDEX phpbb_bots_bot_active on phpbb_bots (bot_active)
/*
- Table: phpbb_cache
-*/
-CREATE TABLE phpbb_cache (
- var_name varchar2(255) DEFAULT '',
- var_expires number(10) DEFAULT '0' NOT NULL,
- var_data clob,
- CONSTRAINT pk_phpbb_cache PRIMARY KEY (var_name)
-)
-/
-
-
-/*
Table: phpbb_config
*/
CREATE TABLE phpbb_config (
@@ -781,6 +769,8 @@ CREATE INDEX phpbb_modules_module_enabled on phpbb_modules (module_enabled)
/
CREATE INDEX phpbb_modules_left_right_id on phpbb_modules (left_id, right_id)
/
+CREATE INDEX phpbb_modules_class_left_id on phpbb_modules (module_class, left_id)
+/
/*
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index d24cefacc7..f52d6fe278 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -254,18 +254,6 @@ CREATE TABLE phpbb_bots (
CREATE INDEX phpbb_bots_bot_active ON phpbb_bots (bot_active);
-
-
-/* Table: phpbb_cache */
-CREATE TABLE phpbb_cache (
- var_name varchar(255) DEFAULT '' NOT NULL,
- var_expires INT4 DEFAULT '0' NOT NULL,
- var_data TEXT,
- PRIMARY KEY (var_name),
- CHECK (var_expires>=0)
-);
-
-
/* Table: phpbb_config */
CREATE TABLE phpbb_config (
config_name varchar(255) NOT NULL,
@@ -590,7 +578,7 @@ CREATE TABLE phpbb_modules (
CREATE INDEX phpbb_modules_module_enabled ON phpbb_modules (module_enabled);
CREATE INDEX phpbb_modules_left_right_id ON phpbb_modules (left_id, right_id);
-
+CREATE INDEX phpbb_modules_class_left_id ON phpbb_modules (module_class, left_id);
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index c989bbd1ef..04394f2d4a 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -146,15 +146,6 @@ CREATE TABLE phpbb_bots (
CREATE INDEX phpbb_bots_bot_active on phpbb_bots (bot_active);
-# Table: phpbb_cache
-CREATE TABLE phpbb_cache (
- var_name varchar(255) NOT NULL DEFAULT '',
- var_expires int(10) NOT NULL DEFAULT '0',
- var_data mediumtext(16777215),
- PRIMARY KEY (var_name)
-);
-
-
# Table: phpbb_config
CREATE TABLE phpbb_config (
config_name varchar(255) NOT NULL,
@@ -392,6 +383,7 @@ CREATE TABLE phpbb_modules (
CREATE INDEX phpbb_modules_module_enabled on phpbb_modules (module_enabled);
CREATE INDEX phpbb_modules_left_right_id on phpbb_modules (left_id, right_id);
+CREATE INDEX phpbb_modules_class_left_id on phpbb_modules (module_class, left_id);
# Table: phpbb_poll_options
generated by cgit v1.2.1 (git 2.21.0) at 2026-02-06 23:52:20 +0000