diff options
| author | Byron Jones <glob@mozilla.com> | 2014-06-09 16:26:00 +0200 |
|---|---|---|
| committer | Byron Jones <glob@mozilla.com> | 2014-06-09 16:26:00 +0200 |
| commit | f0cab2479e25ab0ed36a8bf256406d80b21ddb19 (patch) | |
| tree | 11a26f7d8cc40e9940f8ecc8e18e8561c222266a | |
| parent | e33a04dd4ef4399d00c32a0059aed2e210b3f1a6 (diff) | |
| download | bugzilla-f0cab2479e25ab0ed36a8bf256406d80b21ddb19.tar.gz bugzilla-f0cab2479e25ab0ed36a8bf256406d80b21ddb19.tar.xz | |
Bug 720832: Add the ability to watch component starting with a string
(schema only)
| -rw-r--r-- | extensions/ComponentWatching/Extension.pm | 32 |
1 files changed, 29 insertions, 3 deletions
diff --git a/extensions/ComponentWatching/Extension.pm b/extensions/ComponentWatching/Extension.pm index c4951d877..addbaba70 100644 --- a/extensions/ComponentWatching/Extension.pm +++ b/extensions/ComponentWatching/Extension.pm @@ -28,8 +28,13 @@ sub db_schema_abstract_schema { my ($self, $args) = @_; $args->{'schema'}->{'component_watch'} = { FIELDS => [ + id => { + TYPE => 'MEDIUMSERIAL', + NOTNULL => 1, + PRIMARYKEY => 1, + }, user_id => { - TYPE => 'INT3', + TYPE => 'INT3', NOTNULL => 1, REFERENCES => { TABLE => 'profiles', @@ -38,7 +43,7 @@ sub db_schema_abstract_schema { } }, component_id => { - TYPE => 'INT2', + TYPE => 'INT2', NOTNULL => 0, REFERENCES => { TABLE => 'components', @@ -47,7 +52,7 @@ sub db_schema_abstract_schema { } }, product_id => { - TYPE => 'INT2', + TYPE => 'INT2', NOTNULL => 0, REFERENCES => { TABLE => 'products', @@ -55,6 +60,10 @@ sub db_schema_abstract_schema { DELETE => 'CASCADE', } }, + component_prefix => { + TYPE => 'VARCHAR(64)', + NOTNULL => 0, + }, ], }; } @@ -73,6 +82,23 @@ sub install_update_db { } } ); + $dbh->bz_add_column( + 'component_watch', + 'id', + { + TYPE => 'MEDIUMSERIAL', + NOTNULL => 1, + PRIMARYKEY => 1, + }, + ); + $dbh->bz_add_column( + 'component_watch', + 'component_prefix', + { + TYPE => 'VARCHAR(64)', + NOTNULL => 0, + } + ); } # |