diff options
author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2011-03-13 22:03:22 -0700 |
---|---|---|
committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2011-03-13 22:03:22 -0700 |
commit | 8782cbb1c99e52d25a5157b0d3b794459f2b631a (patch) | |
tree | 7b0df85192b2927a46ef612b5053d8df407d5294 /Bugzilla/DB | |
parent | 317fc6d919da6370863efb76f03cd25d20a9a454 (diff) | |
download | bugs-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar bugs-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar.gz bugs-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar.bz2 bugs-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar.xz bugs-8782cbb1c99e52d25a5157b0d3b794459f2b631a.zip |
Bug 622943: Simple auditing of changes to Bugzilla::Object subclass objects
r=dkl, a=mkanat
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r-- | Bugzilla/DB/Schema.pm | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 106d316a5..c5b16b68e 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -507,6 +507,23 @@ use constant ABSTRACT_SCHEMA => { ], }, + # Auditing + # -------- + + audit_log => { + FIELDS => [ + user_id => {TYPE => 'INT3', + REFERENCES => {TABLE => 'profiles', + COLUMN => 'userid'}}, + class => {TYPE => 'varchar(255)', NOTNULL => 1}, + object_id => {TYPE => 'INT4', NOTNULL => 1}, + field => {TYPE => 'varchar(64)', NOTNULL => 1}, + removed => {TYPE => 'MEDIUMTEXT'}, + added => {TYPE => 'MEDIUMTEXT'}, + at_time => {TYPE => 'DATETIME', NOTNULL => 1}, + ], + }, + # Keywords # -------- |