diff options
| author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2011-03-14 06:03:22 +0100 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2011-03-14 06:03:22 +0100 |
| commit | 8782cbb1c99e52d25a5157b0d3b794459f2b631a (patch) | |
| tree | 7b0df85192b2927a46ef612b5053d8df407d5294 /Bugzilla/DB | |
| parent | 317fc6d919da6370863efb76f03cd25d20a9a454 (diff) | |
| download | bugzilla-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar.gz bugzilla-8782cbb1c99e52d25a5157b0d3b794459f2b631a.tar.xz | |
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 # -------- |