[aur-dev] [PATCH] Add PackagerUID column to Packages table

[Lukas Fleischer]

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 <canyonknight at gmail.com>
> ---
>  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