diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2006-03-12 23:19:55 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2006-03-12 23:19:55 +0000 |
| commit | 9988679d567a8bba9bade92dd9524bb012a1fe43 (patch) | |
| tree | 72da21e7465fed3ca99f20bd809a3df9c020530d /phpBB/install/schemas/oracle_schema.sql | |
| parent | f4cfd3665f7cf1ed96ce4c2eca03ac6854aae258 (diff) | |
| download | forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.gz forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.bz2 forums-9988679d567a8bba9bade92dd9524bb012a1fe43.tar.xz forums-9988679d567a8bba9bade92dd9524bb012a1fe43.zip | |
- streamlined reports to consist of the feature set we decided upon (Nils, your turn now)
- use getenv instead of $_ENV (with $_ENV the case could be wrong)
- permission fixes (there was a bug arising with getting permission flags - re-added them and handled roles deletion differently)
- implemented max login attempts
- changed the expected return parameters for logins/sessions
- added acp page for editing report/denial reasons
- other fixes here and there
git-svn-id: file:///svn/phpbb/trunk@5622 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 080393632c..f579cde90d 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -2,6 +2,7 @@ Oracle Schema for phpBB 3.x - (c) phpBB Group, 2005 $Id$ +@todo user_last_warning to users table and warnings table */ /* @@ -325,6 +326,7 @@ CREATE INDEX is_dynamic on phpbb_config (is_dynamic) CREATE TABLE phpbb_confirm ( confirm_id varchar2(32) DEFAULT '', session_id varchar2(32) DEFAULT '', + confirm_type number(3) DEFAULT '0' NOT NULL, code varchar2(8) DEFAULT '', CONSTRAINT pk_phpbb_confirm PRIMARY KEY (session_id, confirm_id) ) @@ -855,7 +857,6 @@ CREATE TABLE phpbb_privmsgs ( icon_id number(4) DEFAULT '1' NOT NULL, author_ip varchar2(40) DEFAULT '', message_time number(11) DEFAULT '0' NOT NULL, - message_reported number(1) DEFAULT '0' NOT NULL, enable_bbcode number(1) DEFAULT '1' NOT NULL, enable_smilies number(1) DEFAULT '1' NOT NULL, enable_magic_url number(1) DEFAULT '1' NOT NULL, @@ -1098,9 +1099,9 @@ END; */ CREATE TABLE phpbb_reports_reasons ( reason_id number(6) NOT NULL, - reason_priority number(4) DEFAULT '0' NOT NULL, - reason_name varchar2(255) DEFAULT '', + reason_title varchar2(255) DEFAULT '', reason_description clob, + reason_order number(4) DEFAULT '0' NOT NULL, CONSTRAINT pk_phpbb_reports_reasons PRIMARY KEY (reason_id) ) / @@ -1127,9 +1128,9 @@ CREATE TABLE phpbb_reports ( report_id number(5) NOT NULL, reason_id number(5) DEFAULT '0' NOT NULL, post_id number(8) DEFAULT '0' NOT NULL, - msg_id number(8) DEFAULT '0' NOT NULL, user_id number(8) DEFAULT '0' NOT NULL, user_notify number(1) DEFAULT '0' NOT NULL, + report_closed number(1) DEFAULT '0' NOT NULL, report_time number(10) DEFAULT '0' NOT NULL, report_text clob, CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id) @@ -1666,6 +1667,7 @@ CREATE TABLE phpbb_users ( user_lastpage varchar2(100) DEFAULT '', user_last_confirm_key varchar2(10) DEFAULT '', user_warnings number(4) DEFAULT '0' NOT NULL, + user_login_attempts number(4) DEFAULT '0' NOT NULL, user_posts number(8) DEFAULT '0' NOT NULL, user_lang varchar2(30) DEFAULT '', user_timezone number(5, 2) DEFAULT '1' NOT NULL, |