diff options
Diffstat (limited to 'upgrading/5.x.x.txt')
-rw-r--r-- | upgrading/5.x.x.txt | 20 |
1 files changed, 20 insertions, 0 deletions
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; +---- |