From 95ff1f3b64fdbf7d72fa86a94cf606a0369aa6bd Mon Sep 17 00:00:00 2001 From: Meik Sievertsen <acydburn@phpbb.com> Date: Tue, 4 Oct 2005 21:26:04 +0000 Subject: - the schema/data changes needed for the new module class git-svn-id: file:///svn/phpbb/trunk@5253 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/oracle_schema.sql | 18 +++++++++++------- 1 file changed, 11 insertions(+), 7 deletions(-) (limited to 'phpBB/install/schemas/oracle_schema.sql') 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) / /* -- cgit v1.2.1