diff options
| author | Simon Green <sgreen@redhat.com> | 2014-08-14 01:40:47 +0200 |
|---|---|---|
| committer | Simon Green <sgreen@redhat.com> | 2014-08-14 01:40:47 +0200 |
| commit | 424b21e37cd9aeac01588ce0defd3ee665944b1d (patch) | |
| tree | 594aa91a4fafc7c30d26e0ee9a160f62bf4d063f /Bugzilla/DB | |
| parent | 6dbcec07eba4b0910c883141a85b0b9928b85f32 (diff) | |
| download | bugzilla-424b21e37cd9aeac01588ce0defd3ee665944b1d.tar.gz bugzilla-424b21e37cd9aeac01588ce0defd3ee665944b1d.tar.xz | |
Bug 1012506 - Allow a bug to have multiple aliases
r=dkl, a=sgreen
Diffstat (limited to 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 18 |
1 files changed, 15 insertions, 3 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 8c81f7a59..d1c1dc7e9 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -278,11 +278,8 @@ use constant ABSTRACT_SCHEMA => { remaining_time => {TYPE => 'decimal(7,2)', NOTNULL => 1, DEFAULT => '0'}, deadline => {TYPE => 'DATETIME'}, - alias => {TYPE => 'varchar(20)'}, ], INDEXES => [ - bugs_alias_idx => {FIELDS => ['alias'], - TYPE => 'UNIQUE'}, bugs_assigned_to_idx => ['assigned_to'], bugs_creation_ts_idx => ['creation_ts'], bugs_delta_ts_idx => ['delta_ts'], @@ -359,6 +356,21 @@ use constant ABSTRACT_SCHEMA => { ], }, + bugs_aliases => { + FIELDS => [ + alias => {TYPE => 'varchar(40)', NOTNULL => 1}, + bug_id => {TYPE => 'INT3', + REFERENCES => {TABLE => 'bugs', + COLUMN => 'bug_id', + DELETE => 'CASCADE'}}, + ], + INDEXES => [ + bugs_aliases_bug_id_idx => ['bug_id'], + bugs_aliases_alias_idx => {FIELDS => ['alias'], + TYPE => 'UNIQUE'}, + ], + }, + cc => { FIELDS => [ bug_id => {TYPE => 'INT3', NOTNULL => 1, |