summaryrefslogtreecommitdiffstats
path: root/upgrading/5.x.x.txt
blob: 94f91c69139ac63a6ba627e1b8e901df3644b6e9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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;
----