diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:26:04 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-10-04 21:26:04 +0000 |
| commit | 95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd (patch) | |
| tree | f620dc91729ec604947f1a5e8223a1aab36a1b7d /phpBB/install/schemas/oracle_schema.sql | |
| parent | 5082f5eb7303ad52c5d440f1cf1466d886e9feef (diff) | |
| download | forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.gz forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.bz2 forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.tar.xz forums-95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd.zip | |
- the schema/data changes needed for the new module class
git-svn-id: file:///svn/phpbb/trunk@5253 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 18 |
1 files changed, 11 insertions, 7 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 84e8befa2c..8add2daeb1 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -699,13 +699,15 @@ CREATE INDEX forum_id03 on phpbb_moderator_cache (forum_id) */ CREATE TABLE phpbb_modules ( module_id number(8) NOT NULL, - module_type varchar2(3) DEFAULT '', - module_title varchar2(50) DEFAULT '', - module_filename varchar2(50) DEFAULT '', - module_order number(4) DEFAULT '0' NOT NULL, module_enabled number(1) DEFAULT '1' NOT NULL, - module_subs clob, - module_acl varchar2(255) DEFAULT '', + module_name varchar2(20) DEFAULT '' NOT NULL, + module_class varchar2(4) DEFAULT '' NOT NULL, + parent_id number(5) DEFAULT '0' NOT NULL, + left_id number(5) DEFAULT '0' NOT NULL, + right_id number(5) DEFAULT '0' NOT NULL, + module_langname varchar2(50) DEFAULT '' NOT NULL, + module_mode varchar2(255) DEFAULT '' NOT NULL, + module_auth varchar2(255) DEFAULT '' NOT NULL, CONSTRAINT pk_phpbb_modules PRIMARY KEY (module_id) ) / @@ -725,7 +727,9 @@ BEGIN END; / -CREATE INDEX module_type on phpbb_modules (module_type, module_enabled) +CREATE INDEX module_enabled on phpbb_modules (module_enabled) +/ +CREATE INDEX module_left_id on phpbb_modules (left_id) / /* |