diff options
| author | Graham Eames <grahamje@users.sourceforge.net> | 2006-03-17 21:02:32 +0000 |
|---|---|---|
| committer | Graham Eames <grahamje@users.sourceforge.net> | 2006-03-17 21:02:32 +0000 |
| commit | f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88 (patch) | |
| tree | f148686041cdd5ceed8d022fa3302258837c8d79 /phpBB/install/schemas/sqlite_schema.sql | |
| parent | fb999487bc62da5499def80e5a17a03210e985d3 (diff) | |
| download | forums-f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88.tar forums-f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88.tar.gz forums-f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88.tar.bz2 forums-f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88.tar.xz forums-f2cc5c093dd6a040d7a6ef6a4358dbfe0b70ff88.zip | |
Warning changes for the other schema files
git-svn-id: file:///svn/phpbb/trunk@5646 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 66dc04924c..9679f061ef 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -2,7 +2,6 @@ # SQLite Schema for phpBB 3.x - (c) phpBB Group, 2005 # # $Id$ -# @todo user_last_warning to users table and warnings table # BEGIN TRANSACTION; @@ -889,6 +888,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_last_warning int(11) 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 '', @@ -943,6 +943,15 @@ CREATE INDEX user_birthday_phpbb_users on phpbb_users (user_birthday); CREATE INDEX user_email_hash_phpbb_users on phpbb_users (user_email_hash); CREATE INDEX username_phpbb_users on phpbb_users (username); +# Table: phpbb_warnings +CREATE TABLE phpbb_warnings ( + warning_id INTEGER PRIMARY KEY NOT NULL, + user_id mediumint(8) NOT NULL DEFAULT '0', + post_id mediumint(8) NOT NULL DEFAULT '0', + log_id mediumint(8) NOT NULL DEFAULT '0', + warning_time int(11) NOT NULL DEFAULT '0' +); + # Table: phpbb_words CREATE TABLE phpbb_words ( word_id INTEGER PRIMARY KEY NOT NULL, |