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

[canyonknight]

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.

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