From 279d8042e3889402079a4d0eaf10a386fdd4a2a9 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Fri, 27 Mar 2020 08:37:46 -0400 Subject: Add new upgrade instructions Signed-off-by: Lukas Fleischer --- upgrading/4.9.0.txt | 12 ------------ upgrading/5.x.x.txt | 20 ++++++++++++++++++++ 2 files changed, 20 insertions(+), 12 deletions(-) delete mode 100644 upgrading/4.9.0.txt create mode 100644 upgrading/5.x.x.txt diff --git a/upgrading/4.9.0.txt b/upgrading/4.9.0.txt deleted file mode 100644 index 241f24af..00000000 --- a/upgrading/4.9.0.txt +++ /dev/null @@ -1,12 +0,0 @@ -1. Add new columns to store the timestamp and UID when closing requests: - ----- -ALTER TABLE PackageRequests ADD COLUMN ClosedTS BIGINT UNSIGNED NULL DEFAULT NULL; -ALTER TABLE PackageRequests ADD COLUMN ClosedUID INTEGER UNSIGNED NULL DEFAULT NULL; ----- - -2. Add a new column to store backup email addresses: - ----- -ALTER TABLE Users ADD COLUMN BackupEmail VARCHAR(254) NULL DEFAULT NULL; ----- diff --git a/upgrading/5.x.x.txt b/upgrading/5.x.x.txt new file mode 100644 index 00000000..94f91c69 --- /dev/null +++ b/upgrading/5.x.x.txt @@ -0,0 +1,20 @@ +Starting from release 5.0.0, Alembic is used for managing database migrations. + +Run `alembic upgrade head` from the aurweb root directory to upgrade your +database after upgrading the source code to a new release. + +When upgrading from 4.8.0, you also need to execute the following manual SQL +statements before doing so. + +1. Add new columns to store the timestamp and UID when closing requests: + +---- +ALTER TABLE PackageRequests ADD COLUMN ClosedTS BIGINT UNSIGNED NULL DEFAULT NULL; +ALTER TABLE PackageRequests ADD COLUMN ClosedUID INTEGER UNSIGNED NULL DEFAULT NULL; +---- + +2. Add a new column to store backup email addresses: + +---- +ALTER TABLE Users ADD COLUMN BackupEmail VARCHAR(254) NULL DEFAULT NULL; +---- -- cgit v1.2.3-24-g4f1b