aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGraham Eames <grahamje@users.sourceforge.net>2005-12-11 21:10:41 +0000
committerGraham Eames <grahamje@users.sourceforge.net>2005-12-11 21:10:41 +0000
commit85b55fa7015a191de910cfd235503219adb3bd07 (patch)
tree0fdf1dd8dcb162e60d871316690d22933d6c7e69
parentb41525229be3e754f288e48e184626e53b211171 (diff)
downloadforums-85b55fa7015a191de910cfd235503219adb3bd07.tar
forums-85b55fa7015a191de910cfd235503219adb3bd07.tar.gz
forums-85b55fa7015a191de910cfd235503219adb3bd07.tar.bz2
forums-85b55fa7015a191de910cfd235503219adb3bd07.tar.xz
forums-85b55fa7015a191de910cfd235503219adb3bd07.zip
Schema changes for the warning code committed last night
Note: MySQL only at this point in time until the code is finalised git-svn-id: file:///svn/phpbb/trunk@5327 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/install/schemas/mysql_schema.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index fa8702dbf7..feb5bf1c66 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -876,6 +876,7 @@ CREATE TABLE phpbb_users (
user_lastpage varchar(100) DEFAULT '' NOT NULL,
user_last_confirm_key varchar(10) DEFAULT '' NOT NULL,
user_warnings tinyint(4) DEFAULT '0' NOT NULL,
+ user_last_warning int(11) DEFAULT '0' NOT NULL,
user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
user_lang varchar(30) DEFAULT '' NOT NULL,
user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,
@@ -939,6 +940,16 @@ CREATE TABLE phpbb_users_passwd (
KEY passwd_time (passwd_time)
);
+# Table: 'phpbb_warnings'
+CREATE TABLE phpbb_warnings (
+ warning_id mediumint(8) unsigned NOT NULL auto_increment,
+ user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ log_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+ warning_time int(11) DEFAULT '0' NOT NULL,
+ PRIMARY KEY (`warning_id`)
+);
+
# Table: 'phpbb_words'
CREATE TABLE phpbb_words (
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,