summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDylan Hardison <dylan@mozilla.com>2015-10-14 00:24:04 +0200
committerDylan William Hardison <dylan@hardison.net>2015-10-14 00:24:04 +0200
commitd0acb64fc0f07433fef802df6e8d16b709777e44 (patch)
tree1f2c4a34cb59f4764d79d82382375ee8de16d1e6
parentd69cebd8c703f0a1f6839944f1c949bce350b02e (diff)
downloadbugzilla-d0acb64fc0f07433fef802df6e8d16b709777e44.tar.gz
bugzilla-d0acb64fc0f07433fef802df6e8d16b709777e44.tar.xz
Bug 1196626 - log all authenticated requests (schema only)
r=glob
-rw-r--r--Bugzilla/DB/Schema.pm20
1 files changed, 20 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 1e7b04e28..3f49d5026 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1808,6 +1808,26 @@ use constant ABSTRACT_SCHEMA => {
user_api_keys_user_id_app_id_idx => ['user_id', 'app_id'],
],
},
+
+ user_request_log => {
+ FIELDS => [
+ id => {TYPE => 'INTSERIAL', NOTNULL => 1,
+ PRIMARYKEY => 1},
+ user_id => {TYPE => 'INT3', NOTNULL => 1 },
+ ip_address => {TYPE => 'varchar(40)', NOTNULL => 1},
+ user_agent => {TYPE => 'TINYTEXT', NOTNULL => 1},
+ timestamp => {TYPE => 'DATETIME', NOTNULL => 1},
+ bug_id => {TYPE => 'INT3', NOTNULL => 0},
+ attach_id => {TYPE => 'INT4', NOTNULL => 0},
+ request_url => {TYPE => 'TINYTEXT', NOTNULL => 1},
+ method => {TYPE => 'TINYTEXT', NOTNULL => 1},
+ action => {TYPE => 'varchar(20)', NOTNULL => 1},
+ server => {TYPE => 'varchar(7)', NOTNULL => 1},
+ ],
+ INDEXES => [
+ user_user_request_log_user_id_idx => ['user_id'],
+ ],
+ },
};
# Foreign Keys are added in Bugzilla::DB::bz_add_field_tables