diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-08-30 16:24:13 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-08-30 16:44:12 +0200 |
| commit | e1a258bd832c3ba76b5f898cbd068c5bdf4eb4dc (patch) | |
| tree | f24bf8f305d6493b23ad654ea0534ad4b851be9b /upgrading | |
| parent | 57250a164172672f26c763e8453855f74d72c191 (diff) | |
| download | aurweb-e1a258bd832c3ba76b5f898cbd068c5bdf4eb4dc.tar.xz | |
Remember user ID when flagging package bases
Add a new FlaggerUID field to the database and use it to store the user
ID of the account who recently flagged a package out-of-date.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
| -rw-r--r-- | upgrading/4.1.0.txt | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt index 7862030..c0bf573 100644 --- a/upgrading/4.1.0.txt +++ b/upgrading/4.1.0.txt @@ -7,3 +7,11 @@ ALTER TABLE PackageComments ADD COLUMN EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL, ADD FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL; ---- + +2. Add a field to store the ID of the last user who flagged a package +out-of-date: + +---- +ALTER TABLE PackageBases + ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL; +---- |