diff options
| author | David M <davidmj@users.sourceforge.net> | 2008-01-08 06:44:05 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2008-01-08 06:44:05 +0000 |
| commit | 370e189f156730f3ea602052737fb6995c85c23c (patch) | |
| tree | dac369961ff10f5a31f6ad40318afb8702b31e4d /phpBB/install/schemas/db2_schema.sql | |
| parent | b4e64655afc6279d7c64a952ee5f43fe65751c19 (diff) | |
| download | forums-370e189f156730f3ea602052737fb6995c85c23c.tar forums-370e189f156730f3ea602052737fb6995c85c23c.tar.gz forums-370e189f156730f3ea602052737fb6995c85c23c.tar.bz2 forums-370e189f156730f3ea602052737fb6995c85c23c.tar.xz forums-370e189f156730f3ea602052737fb6995c85c23c.zip | |
- make viewforum work again
- remove the lower case functions, they were stupid anyway
- added some indexes
- added a group_name_clean column
git-svn-id: file:///svn/phpbb/trunk@8315 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/db2_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/db2_schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/phpBB/install/schemas/db2_schema.sql b/phpBB/install/schemas/db2_schema.sql index 3e1482be47..247551ceb7 100644 --- a/phpBB/install/schemas/db2_schema.sql +++ b/phpBB/install/schemas/db2_schema.sql @@ -179,6 +179,7 @@ CREATE TABLE phpbb_config ( ); CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC COLLECT SAMPLED DETAILED STATISTICS; +CREATE INDEX phpbb_config_config_name ON phpbb_config (config_name) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC COLLECT SAMPLED DETAILED STATISTICS; /* Table: 'phpbb_confirm' @@ -341,6 +342,7 @@ CREATE TABLE phpbb_groups ( group_type smallint NOT NULL DEFAULT 1, group_founder_manage smallint NOT NULL DEFAULT 0, group_name varchar(255) NOT NULL DEFAULT '', + group_name_clean varchar(255) NOT NULL DEFAULT '', group_desc clob(65K) NOT NULL DEFAULT '', group_desc_bitfield varchar(255) NOT NULL DEFAULT '', group_desc_options integer NOT NULL DEFAULT 7, @@ -1119,4 +1121,5 @@ CREATE TABLE phpbb_zebra ( PRIMARY KEY (user_id, zebra_id) ); +CREATE INDEX phpbb_zebra_zebra_user ON phpbb_zebra (zebra_id, user_id) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS PAGE SPLIT SYMMETRIC COLLECT SAMPLED DETAILED STATISTICS; |