diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2003-07-06 18:48:33 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-07-06 18:48:33 +0000 |
| commit | 1b320bbb006a685d33032a6d1a39de44b4e858a7 (patch) | |
| tree | 79959cc9ae9d93be18ecf5b56eb991b5511ec8bd /phpBB/install | |
| parent | f31b471ee12c96eb1a61484c684202f4d3a8b8bd (diff) | |
| download | forums-1b320bbb006a685d33032a6d1a39de44b4e858a7.tar forums-1b320bbb006a685d33032a6d1a39de44b4e858a7.tar.gz forums-1b320bbb006a685d33032a6d1a39de44b4e858a7.tar.bz2 forums-1b320bbb006a685d33032a6d1a39de44b4e858a7.tar.xz forums-1b320bbb006a685d33032a6d1a39de44b4e858a7.zip | |
merged log tables, added new log_type (critical).
changed email class a little bit.
bug fixed the queue a little bit.
git-svn-id: file:///svn/phpbb/trunk@4210 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 18 |
1 files changed, 4 insertions, 14 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 036804439c..bb1a1d02ca 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -243,9 +243,10 @@ CREATE TABLE phpbb_lang ( PRIMARY KEY (lang_id) ); -# Table: 'phpbb_log_moderator' -CREATE TABLE phpbb_log_moderator ( +# Table: 'phpbb_log' +CREATE TABLE phpbb_log ( log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0' auto_increment, + log_type tinyint(4) UNSIGNED NOT NULL DEFAULT '0', user_id mediumint(8) NOT NULL DEFAULT '0', forum_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', topic_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0', @@ -254,23 +255,12 @@ CREATE TABLE phpbb_log_moderator ( log_operation text, log_data text, PRIMARY KEY (log_id), + KEY log_type (log_type), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY user_id (user_id) ); -# Table: 'phpbb_log_admin' -CREATE TABLE phpbb_log_admin ( - log_id mediumint(5) UNSIGNED NOT NULL DEFAULT '0' auto_increment, - user_id mediumint(8) NOT NULL DEFAULT '0', - log_ip varchar(40) NOT NULL, - log_time int(11) NOT NULL, - log_operation text, - log_data text, - PRIMARY KEY (log_id), - KEY user_id (user_id) -); - # Table: 'phpbb_moderator_cache' CREATE TABLE phpbb_moderator_cache ( forum_id mediumint(8) unsigned NOT NULL, |