Signed-off-by: Marcel Korpel <[email protected]>
---
schema/aur-schema.sql | 2 +-
upgrading/4.1.0.txt | 5 +++--
2 files changed, 4 insertions(+), 3 deletions(-)
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index ff137dc..2c45a97 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -85,7 +85,7 @@ CREATE TABLE PackageBases (
FlaggerComment VARCHAR(255) NOT NULL,
SubmittedTS BIGINT UNSIGNED NOT NULL,
ModifiedTS BIGINT UNSIGNED NOT NULL,
- FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL, -- who flagged the
package out-of-date?
+ FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- who flagged the
package out-of-date?
SubmitterUID INTEGER UNSIGNED NULL DEFAULT NULL, -- who submitted
it?
MaintainerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- User
PackagerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- Last packager
diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt
index e9545ff..439562f 100644
--- a/upgrading/4.1.0.txt
+++ b/upgrading/4.1.0.txt
@@ -13,6 +13,7 @@ package out-of-date:
----
ALTER TABLE PackageBases
- ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL,
- ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL;
+ ADD COLUMN FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL,
+ ADD COLUMN FlaggerComment VARCHAR(255) NOT NULL,
+ ADD FOREIGN KEY (FlaggerUID) REFERENCES Users(ID) ON DELETE SET NULL;
----
--
2.5.2
