mirror of
https://codeberg.org/forgejo/forgejo.git
synced 2026-03-26 06:03:04 -04:00
d1cef852ee
This change is motivated by 5e300a2a87
- Drop the `updated_by` and `commit_id` column, they are unused and have a index for no reason.
- Drop the index on `status` and `created_unix` and make a index on `(user_id, status)`.
## Test
1. Run migration.
2. Confirm the migration succeeds.
3. Check that `notification` table has the correct indexes.
Reviewed-on: https://codeberg.org/forgejo/forgejo/pulls/9926
Reviewed-by: Mathieu Fenniak <mfenniak@noreply.codeberg.org>
Co-authored-by: Gusted <postmaster@gusted.xyz>
Co-committed-by: Gusted <postmaster@gusted.xyz>
49 lines
717 B
YAML
49 lines
717 B
YAML
-
|
|
id: 1
|
|
user_id: 1
|
|
repo_id: 1
|
|
status: 1 # unread
|
|
source: 1 # issue
|
|
issue_id: 1
|
|
created_unix: 946684800
|
|
updated_unix: 946684820
|
|
|
|
-
|
|
id: 2
|
|
user_id: 2
|
|
repo_id: 1
|
|
status: 2 # read
|
|
source: 1 # issue
|
|
issue_id: 2
|
|
created_unix: 946685800
|
|
updated_unix: 946685820
|
|
|
|
-
|
|
id: 3
|
|
user_id: 2
|
|
repo_id: 1
|
|
status: 3 # pinned
|
|
source: 1 # issue
|
|
issue_id: 3
|
|
created_unix: 946686800
|
|
updated_unix: 946686800
|
|
|
|
-
|
|
id: 4
|
|
user_id: 2
|
|
repo_id: 1
|
|
status: 1 # unread
|
|
source: 1 # issue
|
|
issue_id: 5
|
|
created_unix: 946687800
|
|
updated_unix: 946687800
|
|
|
|
-
|
|
id: 5
|
|
user_id: 2
|
|
repo_id: 2
|
|
status: 1 # unread
|
|
source: 1 # issue
|
|
issue_id: 4
|
|
created_unix: 946688800
|
|
updated_unix: 946688820
|