diff options
| author | Dylan Hardison <dylan@mozilla.com> | 2015-10-14 00:24:04 +0200 |
|---|---|---|
| committer | Dylan William Hardison <dylan@hardison.net> | 2015-10-14 00:24:04 +0200 |
| commit | d0acb64fc0f07433fef802df6e8d16b709777e44 (patch) | |
| tree | 1f2c4a34cb59f4764d79d82382375ee8de16d1e6 | |
| parent | d69cebd8c703f0a1f6839944f1c949bce350b02e (diff) | |
| download | bugzilla-d0acb64fc0f07433fef802df6e8d16b709777e44.tar.gz bugzilla-d0acb64fc0f07433fef802df6e8d16b709777e44.tar.xz | |
Bug 1196626 - log all authenticated requests (schema only)
r=glob
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 20 |
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 |