From 9988679d567a8bba9bade92dd9524bb012a1fe43 Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
Date: Sun, 12 Mar 2006 23:19:55 +0000
Subject: - 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
---
 phpBB/install/schemas/sqlite_schema.sql | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

(limited to 'phpBB/install/schemas/sqlite_schema.sql')

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',
-- 
cgit v1.2.1

