From 68e12cdd7ca90594089327e00cf0b7c50e4d0807 Mon Sep 17 00:00:00 2001 From: Dave Lawrence Date: Mon, 23 Jul 2012 17:51:44 -0400 Subject: Bug 764466 - Add a primary key to the profiles_activity table r=glob, a=LpSolit --- Bugzilla/DB/Schema.pm | 2 ++ Bugzilla/Install/DB.pm | 4 ++++ 2 files changed, 6 insertions(+) (limited to 'Bugzilla') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index f8469e66e..09475807c 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -918,6 +918,8 @@ use constant ABSTRACT_SCHEMA => { profiles_activity => { FIELDS => [ + id => {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, + PRIMARYKEY => 1}, userid => {TYPE => 'INT3', NOTNULL => 1, REFERENCES => {TABLE => 'profiles', COLUMN => 'userid', diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 39bfca602..b2cf1194f 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -678,6 +678,10 @@ sub update_table_definitions { $dbh->bz_add_column('bugs_activity', 'id', {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + # 2012-06-13 dkl@mozilla.com - Bug 764466 + $dbh->bz_add_column('profiles_activity', 'id', + {TYPE => 'MEDIUMSERIAL', NOTNULL => 1, PRIMARYKEY => 1}); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ -- cgit v1.2.3-24-g4f1b