On Fri, Apr 19, 2013 at 07:12:54PM -0400, canyonknight wrote: > The last packager is not currently saved despite there being many > instances of the last packager being different than either the > submitter or the maintainer.
I am going to leave this untouched until there is some backend code that actually sets this field :) Applied the other patches. Thanks! > > Signed-off-by: canyonknight <[email protected]> > --- > UPGRADING | 10 ++++++++++ > support/schema/aur-schema.sql | 4 +++- > 2 files changed, 13 insertions(+), 1 deletion(-) > > diff --git a/UPGRADING b/UPGRADING > index a04471f..a003e9b 100644 > --- a/UPGRADING > +++ b/UPGRADING > @@ -1,6 +1,16 @@ > Upgrading > ========= > > +From 2.2.0 to 2.3.0 > +------------------- > + > +1. Add new last packager column to "Packages" table: > + > +---- > +ALTER TABLE Packages ADD COLUMN PackagerUID INT(10) UNSIGNED NULL DEFAULT > NULL; > +ALTER TABLE Packages ADD FOREIGN KEY (PackagerUID) REFERENCES Users(ID) ON > DELETE SET NULL; > +---- > + > From 2.1.0 to 2.2.0 > ------------------- > > diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql > index 0d04f12..c797970 100644 > --- a/support/schema/aur-schema.sql > +++ b/support/schema/aur-schema.sql > @@ -106,6 +106,7 @@ CREATE TABLE Packages ( > ModifiedTS BIGINT UNSIGNED NOT NULL, > SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL, -- who submitted > it? > MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- User > + PackagerUID INTEGER UNSIGNED NULL DEFAULT NULL, > PRIMARY KEY (ID), > UNIQUE (Name), > INDEX (CategoryID), > @@ -115,7 +116,8 @@ CREATE TABLE Packages ( > FOREIGN KEY (CategoryID) REFERENCES PackageCategories(ID) ON DELETE NO > ACTION, > -- deleting a user will cause packages to be orphaned, not deleted > FOREIGN KEY (SubmitterUID) REFERENCES Users(ID) ON DELETE SET NULL, > - FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE SET NULL > + FOREIGN KEY (MaintainerUID) REFERENCES Users(ID) ON DELETE SET NULL, > + FOREIGN KEY (PackagerUID) REFERENCES Users(ID) ON DELETE SET NULL > ) ENGINE = InnoDB; > > > -- > 1.8.2.1
