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/sqlite_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/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 355ee9623d..d8ec345088 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -2,6 +2,7 @@ # SQLite Schema for phpBB 3.x - (c) phpBB Group, 2005 # # $Id$ +# @todo user_last_warning to users table and warnings table # BEGIN TRANSACTION; @@ -156,6 +157,7 @@ CREATE INDEX is_dynamic_phpbb_config on phpbb_config (is_dynamic); CREATE TABLE phpbb_confirm ( confirm_id char(32) NOT NULL DEFAULT '', session_id char(32) NOT NULL DEFAULT '', + confirm_type INTEGER NOT NULL DEFAULT '0', code char(8) NOT NULL DEFAULT '', PRIMARY KEY (session_id, confirm_id) ); @@ -429,7 +431,6 @@ CREATE TABLE phpbb_privmsgs ( icon_id tinyint(4) NOT NULL DEFAULT '1', author_ip varchar(40) NOT NULL DEFAULT '', message_time int(11) NOT NULL DEFAULT '0', - message_reported tinyint(1) NOT NULL DEFAULT '0', enable_bbcode tinyint(1) NOT NULL DEFAULT '1', enable_smilies tinyint(1) NOT NULL DEFAULT '1', enable_magic_url tinyint(1) NOT NULL DEFAULT '1', @@ -555,9 +556,9 @@ CREATE TABLE phpbb_ranks ( # Table: phpbb_reports_reasons CREATE TABLE phpbb_reports_reasons ( reason_id INTEGER PRIMARY KEY NOT NULL, - reason_priority tinyint(4) NOT NULL DEFAULT '0', - reason_name varchar(255) NOT NULL DEFAULT '', - reason_description text(65535) NOT NULL + reason_title varchar(255) NOT NULL DEFAULT '', + reason_description text(65535) NOT NULL, + reason_order tinyint(4) NOT NULL DEFAULT '0' ); # Table: phpbb_reports @@ -565,9 +566,9 @@ CREATE TABLE phpbb_reports ( report_id INTEGER PRIMARY KEY NOT NULL, reason_id smallint(5) NOT NULL DEFAULT '0', post_id mediumint(8) NOT NULL DEFAULT '0', - msg_id mediumint(8) NOT NULL DEFAULT '0', user_id mediumint(8) NOT NULL DEFAULT '0', user_notify tinyint(1) NOT NULL DEFAULT '0', + report_closed tinyint(1) NOT NULL DEFAULT '0', report_time int(10) NOT NULL DEFAULT '0', report_text text(65535) NOT NULL ); @@ -890,6 +891,7 @@ CREATE TABLE phpbb_users ( user_lastpage varchar(100) NOT NULL DEFAULT '', user_last_confirm_key varchar(10) NOT NULL DEFAULT '', user_warnings tinyint(4) NOT NULL DEFAULT '0', + user_login_attempts smallint(4) NOT NULL DEFAULT '0', user_posts mediumint(8) NOT NULL DEFAULT '0', user_lang varchar(30) NOT NULL DEFAULT '', user_timezone decimal(5,2) NOT NULL DEFAULT '0.0', |