diff options
| author | S7evinK <tfaelligen@gmail.com> | 2020-10-05 12:28:10 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-10-05 11:28:10 +0100 |
| commit | 2bfab5f58b77002b1838b52f6edc369ea280ced7 (patch) | |
| tree | 93dd31920308c0b44ae41f15ce22c79735e8db53 | |
| parent | c4756eee0e59ba730fa7855171e18eda9dba8b5f (diff) | |
Add example goose sqlite3 migration (#1474)
Signed-off-by: Till Faelligen <tfaelligen@gmail.com>
| -rw-r--r-- | cmd/goose/README.md | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/cmd/goose/README.md b/cmd/goose/README.md index c7f085d8..725c6a58 100644 --- a/cmd/goose/README.md +++ b/cmd/goose/README.md @@ -104,4 +104,6 @@ You __must__ import the package in `/cmd/goose/main.go` so `func init()` gets ca #### Database limitations - SQLite3 does NOT support `ALTER TABLE table_name DROP COLUMN` - you would have to rename the column or drop the table - entirely and recreate it. + entirely and recreate it. ([example](https://github.com/matrix-org/dendrite/blob/master/userapi/storage/accounts/sqlite3/deltas/20200929203058_is_active.sql)) + + More information: [sqlite.org](https://www.sqlite.org/lang_altertable.html) |