-
I have searched the existing issues, both open and closed, to make sure this is not a duplicate report.
The bugThe .env file now contains a specific version of Immich in order for it to work (1.135.3). So this was a typical update for me. I believe I wasn't affected by the recent changes, since I don't use a custom IMMICH_MEDIA_LOCATION. However, version v1.136.0 causes the immich_server container to remain permanently in a starting state. In the meantime, I also tried deleting everything and restoring from scratch using the official guide: The OS that Immich Server is running onUbuntu 24.04.2 LTS Version of Immich Serverv1.136.0 Version of Immich Mobile Appv.1.135.1 Platform with the issue
Your docker-compose.yml contentservices:
immich-server:
container_name: immich_server
image: ghcr.io/immich-app/immich-server:${IMMICH_VERSION:-release}
volumes:
- ${UPLOAD_LOCATION}:/usr/src/app/upload
- /etc/localtime:/etc/localtime:ro
env_file:
- .env
ports:
- 2283:2283
depends_on:
- redis
- database
restart: unless-stopped
healthcheck:
disable: false
immich-machine-learning:
container_name: immich_machine_learning
# For hardware acceleration, add one of -[armnn, cuda, openvino] to the image tag.
# Example tag: ${IMMICH_VERSION:-release}-cuda
image: ghcr.io/immich-app/immich-machine-learning:${IMMICH_VERSION:-release}
# extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
# file: hwaccel.ml.yml
# service: cpu # set to one of [armnn, cuda, openvino, openvino-wsl] for accelerated inference - use the `-wsl` version for WSL2 where applicable
volumes:
- model-cache:/cache
env_file:
- .env
restart: unless-stopped
healthcheck:
disable: false
redis:
container_name: immich_redis
image: docker.io/valkey/valkey:8-bookworm@sha256:facc1d2c3462975c34e10fccb167bfa92b0e0dbd992fc282c29a61c3243afb11
healthcheck:
test: redis-cli ping || exit 1
restart: unless-stopped
database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:5f6a838e4e44c8e0e019d0ebfe3ee8952b69afc2809b2c25f7b0119641978e91
env_file:
- .env
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
POSTGRES_INITDB_ARGS: '--data-checksums'
volumes:
# Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
- ${DB_DATA_LOCATION}:/var/lib/postgresql/data
restart: unless-stopped
volumes:
model-cache:
immich_pgdata:
external: trueYour .env content# The location where your uploaded files are stored
UPLOAD_LOCATION=/mnt/data/immich-library
# The location where your database files are stored
DB_DATA_LOCATION=immich_pgdata
# The Immich version to use. You can pin this to a specific version like "v1.71.0"
IMMICH_VERSION=v1.135.3
# Connection secret for postgres. You should change it to a random password
DB_PASSWORD=XXXXXXXXX
# The values below this line do not need to be changed
###################################################################################
DB_HOSTNAME=immich_postgres
DB_USERNAME=user
DB_DATABASE_NAME=user
REDIS_HOSTNAME=immich_redisReproduction steps
Relevant log outputStarting api worker
Starting microservices worker
[Nest] 7 - 07/26/2025, 4:56:23 PM LOG [Microservices:EventRepository] Initialized websocket server
[Nest] 7 - 07/26/2025, 4:56:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for clip_index of 24373 rows
[Nest] 7 - 07/26/2025, 4:56:23 PM LOG [Microservices:DatabaseRepository] targetLists=1, current=1 for face_index of 27807 rows
[Nest] 7 - 07/26/2025, 4:56:23 PM LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
[Nest] 18 - 07/26/2025, 4:56:24 PM LOG [Api:EventRepository] Initialized websocket server
Query failed : {
durationMs: 4.304889000000912,
error: PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not exist
at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '42704',
file: 'pg_constraint.c',
line: '872',
routine: 'get_relation_constraint_oid'
},
sql: 'ALTER TABLE "asset_job_status" RENAME CONSTRAINT "FK_420bec36fc02813bddf5c8b73d4" TO "asset_job_status_assetId_fkey";',
params: []
}
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1750676477029-AlbumAssetUpdateId" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM ERROR [Microservices:DatabaseRepository] Kysely migrations failed: PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not exist
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1750694237564-AlbumAssetAuditTable" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1750780093818-AddAlbumToAssetDeleteTrigger" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1751035357937-MemorySyncChanges" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1751304834247-StackSyncChanges" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1751924596408-AddOverrides" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752004072340-UpdateIndexOverrides" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752152941084-PeopleAuditTable" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752161055253-RenameGeodataPKConstraint" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752161055254-AddActivityAssetFk" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752169992364-AddIsPendingSyncReset" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM LOG [Microservices:DatabaseRepository] Migration "1752250924342-UserMetadataSync" succeeded
[Nest] 7 - 07/26/2025, 4:56:26 PM WARN [Microservices:DatabaseRepository] Migration "1752267649968-StandardizeNames" failed
PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not exist
at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: '42704',
file: 'pg_constraint.c',
line: '872',
routine: 'get_relation_constraint_oid'
}
microservices worker error: PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not exist, stack: PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not exist
at ErrorResponse (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
microservices worker exited with code 1
Killing api process
Initializing Immich v1.136.0
Detected CPU Cores: 4Additional informationNo response |
Beta Was this translation helpful? Give feedback.
Answered by
chamdim
Aug 6, 2025
Replies: 22 comments 19 replies
-
|
Did you modify the database manually somehow? |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Nope, didn’t touch the DB manually — don’t even know how to. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
I have a nearly identical setup and have the same issue. I have also never done any manual intervention to the database. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
I had the issue yesterday. I wanted to do some more testing today but the upgrade did not error anymore. I started by rolling back to a zfs snapshot that I took before starting to upgrade yesterday so I know the system is in exactly the same state as before when it was failing. Can't explain it but I have an error free 1.36.0 system now so nothing to see here. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Originally reported in #20152 |
Beta Was this translation helpful? Give feedback.
0 replies
-
I intentionally chose a clear and simple title (“Immich server stuck at starting state”) so that less experienced users — like myself — can actually find it when searching. |
Beta Was this translation helpful? Give feedback.
0 replies
-
Ya just wanted to try to help by showing the other incidents as well! Cheers mate |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
i also have the same root problem, i guess. but slightly different. i updated from 1.135.3 oto 1.136.0 on my proxmox-lxc. never touched the database manually. the update itself went trough without any issues (at least no error message during the actual update). when the server restartet after update the error occured. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
I use the I mount these volumes in via the docker compose file: These have always been referenced via full paths in the admin section: 
|
Beta Was this translation helpful? Give feedback.
0 replies
-
|
both the server and the mobile app are updated to v1.136.0 ? Version of Immich Mobile App |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Any steps to update successfully immich to 1.136.0 on truenas? |
Beta Was this translation helpful? Give feedback.
0 replies
-
I’m not sure how it will work on TrueNAS, but in my setup I’d try the jobs for Storage Template Migration first, then the Migration from the web admin panel, and finally attempt the update again using the usual CLI commands. |
Beta Was this translation helpful? Give feedback.
0 replies
-
And successfully updated? |
Beta Was this translation helpful? Give feedback.
0 replies
-
Meh, just did it with zero luck |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
@chamdim @deThommy Could you post your Immich DB schema from the current working Immich version, e.g. v1.135.3 is fine. We'd like to see if there is any lingering schema drift/discrepancies. Docker command (assuming default user and DB): docker exec -ti --user postgres immich_postgres pg_dump --schema-only -d immichIt seems in @auberginepop's case there was no drift; perhaps something else if the update succeeded eventually.
|
Beta Was this translation helpful? Give feedback.
0 replies
-
Here is the dump as requested: BTW, just tested with v1.137.1 — unfortunately, it didn't fix the issue on my end. |
Beta Was this translation helpful? Give feedback.
0 replies
-
Looks partial/cropped. It begins with CREATE INDEX and has no CREATE TABLE entries. Could you check and re-upload? |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
What should I check? I ran the following command: The strange part is that my instance works just fine. Any idea what could be causing this? |
Beta Was this translation helpful? Give feedback.
1 reply
-
Maybe it is truncated somehow in terminal. Could you try redirecting output into a file? docker exec -ti immich_postgres pg_dump --username=user --schema-only -d user > schema.sql(Assuming |
Beta Was this translation helpful? Give feedback.
-
|
To all having
You can check the schema drift and generate the fixing SQL statementsMore info in #20530 (comment) docker exec immich_server sh -c 'DB_URL=postgres://$DB_USERNAME:$DB_PASSWORD@database:5432/$DB_DATABASE_NAME npm run migrations:debug && cat migrations.sql'Output looks like this: > immich@1.135.3 migrations:debug
> node ./dist/bin/migrations.js debug
Wrote migrations.sql
-- UP
ALTER TABLE "albums_assets_assets" ADD CONSTRAINT "FK_4bd1303d199f4e72ccdf998c621" FOREIGN KEY ("assetsId") REFERENCES "assets" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "asset_files" ADD CONSTRAINT "FK_e3e103a5f1d8bc8402999286040" FOREIGN KEY ("assetId") REFERENCES "assets" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in targetGenerated SQL commands (after Applying the SQL/schema fixBefore applying you can post/share generated SQL commands for review. Have DB backup before applying. When applying: Which means an extra cleanup step is needed for dangling records, similar to #20530 (comment). |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
@skatsubo you also asked for my schema, youll find it attached. i also tried updating to the latest version without success, so i rolled back to 1.135.3. im running immich on proxmox and installed it using the ve helper-script (so no docker). |
Beta Was this translation helpful? Give feedback.
4 replies
-
|
Upon comparing your schema with a fresh v1.135.3 these entries are missing. Could you apply them and see if it helps? CREATE INDEX idx_geodata_places_alternate_names ON public.geodata_places USING gin (public.f_unaccent(("alternateNames")::text) public.gin_trgm_ops);
CREATE INDEX idx_geodata_places_name ON public.geodata_places USING gin (public.f_unaccent((name)::text) public.gin_trgm_ops);
CREATE INDEX idx_local_date_time ON public.assets USING btree (((("localDateTime" AT TIME ZONE 'UTC'::text))::date));
CREATE INDEX idx_local_date_time_month ON public.assets USING btree ((date_trunc('MONTH'::text, ("localDateTime" AT TIME ZONE 'UTC'::text)) AT TIME ZONE 'UTC'::text));
CREATE INDEX idx_originalfilename_trigram ON public.assets USING gin (public.f_unaccent(("originalFileName")::text) public.gin_trgm_ops); |
Beta Was this translation helpful? Give feedback.
-
|
not quite sure why or how they were missing, but I never changed anything and only ever used the now I successfully updated to 0.136.0. thank you very much for helping @skatsubo. using the |
Beta Was this translation helpful? Give feedback.
-
Missing indexes
That's an open question still for many affected setups. The DB migration Version historyCould you post your upgrade history? select version, "createdAt" from version_history;Helper script
This one I guess https://github.com/community-scripts/ProxmoxVE/blob/main/install/immich-install.sh. |
Beta Was this translation helpful? Give feedback.
-
Pretty new to the amazing immich 🥲 version | createdAt
Ah, thx. Gave it a try right away. 1.137.3 is up and Running! |
Beta Was this translation helpful? Give feedback.
-
|
I also have an issue after upgrades. Deployment: on proxmox, as LXC, upgraded with the update script I have Specifically, the A quick google search led me to this webpack issue. Not sure if it's related, but I thought I might link it. Though it doesn't look like a DB issue, I have also followed the DB diagnostics posted above and discovered a minor schema drift with one geo index. I've fixed it. My current migration history is this: As you can see, this is a fairly fresh installation. The only caveat is that I have migrated it from a docker-compose setup a few months ago. But it didn't have the Any help would be appreciated here :) Also, great work on immich so far, guys! I really love what you've done, you're rockstars! 🤘 EDIT Ehh, how is it, that as soon as one publishes an issue, they immediately find a solution to it? |
Beta Was this translation helpful? Give feedback.
4 replies
-
|
Hey @michalkurzeja, thanks for the detailed report! From yours and @rk295's posts it looks like As it does not fit under the title of current issue "immich_server stuck in starting state", could you start new Q&A discussion to keep it focused? Could you also provide more information there: your configuration, env vars, paths/mounts? Also would be nice if you can run Immich with |
Beta Was this translation helpful? Give feedback.
-
|
Hey, sorry, as you were replying to my issue, I have just found the cause and the solution. I've edited my post to include it. Do you still want me to post it as another discussion, in hopes that it helps others? |
Beta Was this translation helpful? Give feedback.
-
|
Amazing! I think it's fine to keep the solution here. It is discoverable by the error (pretty unique in Immich realm) |
Beta Was this translation helpful? Give feedback.
-
|
It looks like the "Migration" job does the same thing. |
Beta Was this translation helpful? Give feedback.
-
|
I ll post my full fault finding and procedure if this help anyone else. Thanks to @skatsubo i only saw the error and the missing constraint. the log error: then i gave: and the output: then i docker exec into the immich_postgres: inside immich_postgres: inside immich_postgres: inside immich_postgres: exit the immich_postgres container with DONE! |
Beta Was this translation helpful? Give feedback.
10 replies
-
|
Thanks. There was the same case recently about FK_c0117fdbc50b917ef9067740c44 #20738, you can check the steps and outputs there as well. Condensed version below:
docker exec -ti --user postgres immich_postgres psql -Ppager=no -d immich
ALTER TABLE "exif" ADD CONSTRAINT "FK_c0117fdbc50b917ef9067740c44" FOREIGN KEY ("assetId") REFERENCES "assets" ("id") ON UPDATE NO ACTION ON DELETE CASCADE;It may fail with
DELETE FROM exif ee WHERE NOT EXISTS ( SELECT 1 FROM public.assets a WHERE a.id = ee."assetId" );
|
Beta Was this translation helpful? Give feedback.
-
|
docker exec --user root immich_server sh -c 'DB_URL=postgres://$DB_USERNAME:$DB_PASSWORD@database:5432/$DB_DATABASE_NAME node ./server/dist/bin/migrations.js debug && cat migrations.sql' Wrote migrations.sql
-- UP
CREATE OR REPLACE FUNCTION immich_uuid_v7(p_timestamp timestamp with time zone default clock_timestamp())
RETURNS uuid
VOLATILE LANGUAGE SQL
AS $$
SELECT encode(
set_bit(
set_bit(
overlay(uuid_send(gen_random_uuid())
placing substring(int8send(floor(extract(epoch from p_timestamp) * 1000)::bigint) from 3)
from 1 for 6
),
52, 1
),
53, 1
),
'hex')::uuid;
$$; -- function expression has changed (CREATE OR REPLACE FUNCTION immich_uuid_v7(p_timestamp timestamp with time zone default clock_timestamp())
RETURNS uuid
VOLATILE LANGUAGE SQL
AS $$
SELECT encode(
set_bit(
set_bit(
overlay(uuid_send(gen_random_uuid())
placing substring(int8send(floor(extract(epoch from p_timestamp) * 1000)::bigint) from 3)
from 1 for 6
),
52, 1
),
53, 1
),
'hex')::uuid;
$$; vs CREATE OR REPLACE FUNCTION public.immich_uuid_v7(p_timestamp timestamp with time zone DEFAULT clock_timestamp())
RETURNS uuid
LANGUAGE sql
AS $function$
select encode(
set_bit(
set_bit(
overlay(uuid_send(gen_random_uuid())
placing substring(int8send(floor(extract(epoch from p_timestamp) * 1000)::bigint) from 3)
from 1 for 6
),
52, 1
),
53, 1
),
'hex')::uuid;
$function$
)
CREATE OR REPLACE FUNCTION album_user_after_insert()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
UPDATE album SET "updatedAt" = clock_timestamp(), "updateId" = immich_uuid_v7(clock_timestamp())
WHERE "id" IN (SELECT DISTINCT "albumsId" FROM inserted_rows);
RETURN NULL;
END
$$; -- function expression has changed (CREATE OR REPLACE FUNCTION album_user_after_insert()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
UPDATE album SET "updatedAt" = clock_timestamp(), "updateId" = immich_uuid_v7(clock_timestamp())
WHERE "id" IN (SELECT DISTINCT "albumsId" FROM inserted_rows);
RETURN NULL;
END
$$; vs CREATE OR REPLACE FUNCTION public.album_user_after_insert()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
BEGIN
UPDATE albums SET "updatedAt" = clock_timestamp(), "updateId" = immich_uuid_v7(clock_timestamp())
WHERE "id" IN (SELECT DISTINCT "albumsId" FROM inserted_rows);
RETURN NULL;
END
$function$
)
CREATE OR REPLACE FUNCTION updated_at()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
DECLARE
clock_timestamp TIMESTAMP := clock_timestamp();
BEGIN
new."updatedAt" = clock_timestamp;
new."updateId" = immich_uuid_v7(clock_timestamp);
return new;
END;
$$; -- function expression has changed (CREATE OR REPLACE FUNCTION updated_at()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
DECLARE
clock_timestamp TIMESTAMP := clock_timestamp();
BEGIN
new."updatedAt" = clock_timestamp;
new."updateId" = immich_uuid_v7(clock_timestamp);
return new;
END;
$$; vs CREATE OR REPLACE FUNCTION public.updated_at()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
DECLARE
clock_timestamp TIMESTAMP := clock_timestamp();
BEGIN
new."updatedAt" = clock_timestamp;
new."updateId" = immich_uuid_v7(clock_timestamp);
return new;
END;
$function$
)
CREATE OR REPLACE FUNCTION f_concat_ws(text, text[])
RETURNS text
PARALLEL SAFE IMMUTABLE LANGUAGE SQL
AS $$SELECT array_to_string($2, $1)$$; -- function expression has changed (CREATE OR REPLACE FUNCTION f_concat_ws(text, text[])
RETURNS text
PARALLEL SAFE IMMUTABLE LANGUAGE SQL
AS $$SELECT array_to_string($2, $1)$$; vs CREATE OR REPLACE FUNCTION public.f_concat_ws(text, text[])
RETURNS text
LANGUAGE sql
IMMUTABLE PARALLEL SAFE
AS $function$SELECT array_to_string($2, $1)$function$
)
CREATE OR REPLACE FUNCTION f_unaccent(text)
RETURNS text
PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL
RETURN unaccent('unaccent', $1) -- function expression has changed (CREATE OR REPLACE FUNCTION f_unaccent(text)
RETURNS text
PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL
RETURN unaccent('unaccent', $1) vs CREATE OR REPLACE FUNCTION public.f_unaccent(text)
RETURNS text
LANGUAGE sql
IMMUTABLE PARALLEL SAFE STRICT
RETURN unaccent('unaccent'::regdictionary, $1)
)
CREATE OR REPLACE FUNCTION ll_to_earth_public(latitude double precision, longitude double precision)
RETURNS public.earth
PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL
AS $$SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians(latitude))*cos(radians(longitude))),public.earth()*cos(radians(latitude))*sin(radians(longitude))),public.earth()*sin(radians(latitude)))::public.earth$$; -- function expression has changed (CREATE OR REPLACE FUNCTION ll_to_earth_public(latitude double precision, longitude double precision)
RETURNS public.earth
PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL
AS $$SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians(latitude))*cos(radians(longitude))),public.earth()*cos(radians(latitude))*sin(radians(longitude))),public.earth()*sin(radians(latitude)))::public.earth$$; vs CREATE OR REPLACE FUNCTION public.ll_to_earth_public(latitude double precision, longitude double precision)
RETURNS earth
LANGUAGE sql
IMMUTABLE PARALLEL SAFE STRICT
AS $function$
SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians(latitude))*cos(radians(longitude))),public.earth()*cos(radians(latitude))*sin(radians(longitude))),public.earth()*sin(radians(latitude)))::public.earth
$function$
)
CREATE OR REPLACE FUNCTION user_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO user_audit ("userId")
SELECT "id"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION partner_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO partner_audit ("sharedById", "sharedWithId")
SELECT "sharedById", "sharedWithId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION asset_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO asset_audit ("assetId", "ownerId")
SELECT "id", "ownerId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION album_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO album_audit ("albumId", "userId")
SELECT "id", "ownerId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION album_asset_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO album_asset_audit ("albumId", "assetId")
SELECT "albumsId", "assetsId" FROM OLD
WHERE "albumsId" IN (SELECT "id" FROM album WHERE "id" IN (SELECT "albumsId" FROM OLD));
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION album_user_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO album_audit ("albumId", "userId")
SELECT "albumsId", "usersId"
FROM OLD;
IF pg_trigger_depth() = 1 THEN
INSERT INTO album_user_audit ("albumId", "userId")
SELECT "albumsId", "usersId"
FROM OLD;
END IF;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION memory_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO memory_audit ("memoryId", "userId")
SELECT "id", "ownerId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION memory_asset_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO memory_asset_audit ("memoryId", "assetId")
SELECT "memoriesId", "assetsId" FROM OLD
WHERE "memoriesId" IN (SELECT "id" FROM memory WHERE "id" IN (SELECT "memoriesId" FROM OLD));
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION stack_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO stack_audit ("stackId", "userId")
SELECT "id", "ownerId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION person_delete_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO person_audit ("personId", "ownerId")
SELECT "id", "ownerId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION user_metadata_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO user_metadata_audit ("userId", "key")
SELECT "userId", "key"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
CREATE OR REPLACE FUNCTION asset_face_audit()
RETURNS TRIGGER
LANGUAGE PLPGSQL
AS $$
BEGIN
INSERT INTO asset_face_audit ("assetFaceId", "assetId")
SELECT "id", "assetId"
FROM OLD;
RETURN NULL;
END
$$; -- missing in target
DROP TRIGGER "activity_updated_at" ON "activity"; -- missing in source
DROP TRIGGER "person_updated_at" ON "person"; -- missing in source
DROP INDEX "IDX_activity_like"; -- missing in source
DROP INDEX "face_index"; -- columns are different (undefined vs embedding)
DROP INDEX "idx_geodata_places_name"; -- expression is different (f_unaccent("name") gin_trgm_ops vs f_unaccent((name)::text))
DROP INDEX "idx_geodata_places_admin2_name"; -- expression is different (f_unaccent("admin2Name") gin_trgm_ops vs f_unaccent(("admin2Name")::text))
DROP INDEX "idx_geodata_places_admin1_name"; -- expression is different (f_unaccent("admin1Name") gin_trgm_ops vs f_unaccent(("admin1Name")::text))
DROP INDEX "idx_geodata_places_alternate_names"; -- expression is different (f_unaccent("alternateNames") gin_trgm_ops vs f_unaccent(("alternateNames")::text))
DROP INDEX "idx_geodata_gist_earthcoord"; -- missing in source
ALTER TABLE "activity" DROP CONSTRAINT "FK_8091ea76b12338cb4428d33d782"; -- missing in source
ALTER TABLE "activity" DROP CONSTRAINT "FK_3571467bcbe021f66e2bdce96ea"; -- missing in source
ALTER TABLE "activity" DROP CONSTRAINT "FK_1af8519996fbfb3684b58df280b"; -- missing in source
ALTER TABLE "person" DROP CONSTRAINT "FK_5527cc99f530a547093f9e577b6"; -- missing in source
ALTER TABLE "person" DROP CONSTRAINT "FK_2bbabe31656b6778c6b87b61023"; -- missing in source
ALTER TABLE "face_search" DROP CONSTRAINT "face_search_faceId_fkey"; -- reference table is different (asset_face vs asset_faces)
ALTER TABLE "tag_asset" DROP CONSTRAINT "FK_e99f31ea4cdf3a2c35c7287eb42"; -- missing in source
ALTER TABLE "user_metadata" DROP CONSTRAINT "FK_6afb43681a21cf7815932bc38ac"; -- missing in source
CREATE TABLE "user" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"email" character varying NOT NULL,
"password" character varying NOT NULL DEFAULT '',
"pinCode" character varying,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"profileImagePath" character varying NOT NULL DEFAULT '',
"isAdmin" boolean NOT NULL DEFAULT false,
"shouldChangePassword" boolean NOT NULL DEFAULT true,
"avatarColor" character varying,
"deletedAt" timestamp with time zone,
"oauthId" character varying NOT NULL DEFAULT '',
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"storageLabel" character varying,
"name" character varying NOT NULL DEFAULT '',
"quotaSizeInBytes" bigint,
"quotaUsageInBytes" bigint NOT NULL DEFAULT 0,
"status" character varying NOT NULL DEFAULT 'active',
"profileChangedAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "user_email_uq" UNIQUE ("email"),
CONSTRAINT "user_storageLabel_uq" UNIQUE ("storageLabel"),
CONSTRAINT "user_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "user_updatedAt_id_idx" ON "user" ("updatedAt", "id"); -- missing in target
CREATE INDEX "user_updateId_idx" ON "user" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "user_delete_audit"
AFTER DELETE ON "user"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION user_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "user_updatedAt"
BEFORE UPDATE ON "user"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "library" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"name" character varying NOT NULL,
"ownerId" uuid NOT NULL,
"importPaths" text[] NOT NULL,
"exclusionPatterns" text[] NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"deletedAt" timestamp with time zone,
"refreshedAt" timestamp with time zone,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "library_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "library_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "library_ownerId_idx" ON "library" ("ownerId"); -- missing in target
CREATE INDEX "library_updateId_idx" ON "library" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "library_updatedAt"
BEFORE UPDATE ON "library"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "stack" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"primaryAssetId" uuid NOT NULL,
"ownerId" uuid NOT NULL,
CONSTRAINT "stack_primaryAssetId_fkey" FOREIGN KEY ("primaryAssetId") REFERENCES "asset" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT "stack_primaryAssetId_uq" UNIQUE ("primaryAssetId"),
CONSTRAINT "stack_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "stack_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "stack_primaryAssetId_idx" ON "stack" ("primaryAssetId"); -- missing in target
CREATE INDEX "stack_ownerId_idx" ON "stack" ("ownerId"); -- missing in target
CREATE OR REPLACE TRIGGER "stack_delete_audit"
AFTER DELETE ON "stack"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION stack_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "stack_updatedAt"
BEFORE UPDATE ON "stack"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "asset" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"deviceAssetId" character varying NOT NULL,
"ownerId" uuid NOT NULL,
"deviceId" character varying NOT NULL,
"type" character varying NOT NULL,
"originalPath" character varying NOT NULL,
"fileCreatedAt" timestamp with time zone NOT NULL,
"fileModifiedAt" timestamp with time zone NOT NULL,
"isFavorite" boolean NOT NULL DEFAULT false,
"duration" character varying,
"encodedVideoPath" character varying DEFAULT '',
"checksum" bytea NOT NULL,
"livePhotoVideoId" uuid,
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"originalFileName" character varying NOT NULL,
"sidecarPath" character varying,
"thumbhash" bytea,
"isOffline" boolean NOT NULL DEFAULT false,
"libraryId" uuid,
"isExternal" boolean NOT NULL DEFAULT false,
"deletedAt" timestamp with time zone,
"localDateTime" timestamp with time zone NOT NULL,
"stackId" uuid,
"duplicateId" uuid,
"status" assets_status_enum NOT NULL DEFAULT 'active',
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"visibility" asset_visibility_enum NOT NULL DEFAULT 'timeline',
CONSTRAINT "asset_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "asset_livePhotoVideoId_fkey" FOREIGN KEY ("livePhotoVideoId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE SET NULL,
CONSTRAINT "asset_libraryId_fkey" FOREIGN KEY ("libraryId") REFERENCES "library" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "asset_stackId_fkey" FOREIGN KEY ("stackId") REFERENCES "stack" ("id") ON UPDATE CASCADE ON DELETE SET NULL,
CONSTRAINT "asset_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "asset_originalFilename_trigram_idx" ON "asset" USING gin (f_unaccent("originalFileName") gin_trgm_ops); -- missing in target
CREATE INDEX "asset_id_stackId_idx" ON "asset" ("id", "stackId"); -- missing in target
CREATE INDEX "asset_originalPath_libraryId_idx" ON "asset" ("originalPath", "libraryId"); -- missing in target
CREATE INDEX "asset_localDateTime_month_idx" ON "asset" ((date_trunc('MONTH'::text, ("localDateTime" AT TIME ZONE 'UTC'::text)) AT TIME ZONE 'UTC'::text)); -- missing in target
CREATE INDEX "asset_localDateTime_idx" ON "asset" ((("localDateTime" at time zone 'UTC')::date)); -- missing in target
CREATE UNIQUE INDEX "asset_ownerId_libraryId_checksum_idx" ON "asset" ("ownerId", "libraryId", "checksum") WHERE ("libraryId" IS NOT NULL); -- missing in target
CREATE UNIQUE INDEX "UQ_assets_owner_checksum" ON "asset" ("ownerId", "checksum") WHERE ("libraryId" IS NULL); -- missing in target
CREATE INDEX "asset_ownerId_idx" ON "asset" ("ownerId"); -- missing in target
CREATE INDEX "asset_fileCreatedAt_idx" ON "asset" ("fileCreatedAt"); -- missing in target
CREATE INDEX "asset_checksum_idx" ON "asset" ("checksum"); -- missing in target
CREATE INDEX "asset_livePhotoVideoId_idx" ON "asset" ("livePhotoVideoId"); -- missing in target
CREATE INDEX "asset_originalFileName_idx" ON "asset" ("originalFileName"); -- missing in target
CREATE INDEX "asset_libraryId_idx" ON "asset" ("libraryId"); -- missing in target
CREATE INDEX "asset_stackId_idx" ON "asset" ("stackId"); -- missing in target
CREATE INDEX "asset_duplicateId_idx" ON "asset" ("duplicateId"); -- missing in target
CREATE INDEX "asset_updateId_idx" ON "asset" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "asset_delete_audit"
AFTER DELETE ON "asset"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION asset_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "asset_updatedAt"
BEFORE UPDATE ON "asset"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "album" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"ownerId" uuid NOT NULL,
"albumName" character varying NOT NULL DEFAULT 'Untitled Album',
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"albumThumbnailAssetId" uuid,
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"description" text NOT NULL DEFAULT '',
"deletedAt" timestamp with time zone,
"isActivityEnabled" boolean NOT NULL DEFAULT true,
"order" character varying NOT NULL DEFAULT 'desc',
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "album_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_albumThumbnailAssetId_fkey" FOREIGN KEY ("albumThumbnailAssetId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE SET NULL,
CONSTRAINT "album_pkey" PRIMARY KEY ("id")
); -- missing in target
COMMENT ON COLUMN "album"."albumThumbnailAssetId" IS 'Asset ID to be used as thumbnail'; -- missing in target
CREATE INDEX "album_ownerId_idx" ON "album" ("ownerId"); -- missing in target
CREATE INDEX "album_albumThumbnailAssetId_idx" ON "album" ("albumThumbnailAssetId"); -- missing in target
CREATE INDEX "album_updateId_idx" ON "album" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "album_delete_audit"
AFTER DELETE ON "album"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION album_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "album_updatedAt"
BEFORE UPDATE ON "album"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "album_asset" (
"albumsId" uuid NOT NULL,
"assetsId" uuid NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "album_asset_albumsId_fkey" FOREIGN KEY ("albumsId") REFERENCES "album" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_asset_assetsId_fkey" FOREIGN KEY ("assetsId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_asset_pkey" PRIMARY KEY ("albumsId", "assetsId")
); -- missing in target
CREATE INDEX "album_asset_albumsId_idx" ON "album_asset" ("albumsId"); -- missing in target
CREATE INDEX "album_asset_assetsId_idx" ON "album_asset" ("assetsId"); -- missing in target
CREATE INDEX "album_asset_updateId_idx" ON "album_asset" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "album_asset_delete_audit"
AFTER DELETE ON "album_asset"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() <= 1)
EXECUTE FUNCTION album_asset_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "album_asset_updatedAt"
BEFORE UPDATE ON "album_asset"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "album_asset_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"albumId" uuid NOT NULL,
"assetId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "album_asset_audit_albumId_fkey" FOREIGN KEY ("albumId") REFERENCES "album" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_asset_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "album_asset_audit_albumId_idx" ON "album_asset_audit" ("albumId"); -- missing in target
CREATE INDEX "album_asset_audit_assetId_idx" ON "album_asset_audit" ("assetId"); -- missing in target
CREATE INDEX "album_asset_audit_deletedAt_idx" ON "album_asset_audit" ("deletedAt"); -- missing in target
CREATE TABLE "album_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"albumId" uuid NOT NULL,
"userId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "album_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "album_audit_albumId_idx" ON "album_audit" ("albumId"); -- missing in target
CREATE INDEX "album_audit_userId_idx" ON "album_audit" ("userId"); -- missing in target
CREATE INDEX "album_audit_deletedAt_idx" ON "album_audit" ("deletedAt"); -- missing in target
CREATE TABLE "album_user_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"albumId" uuid NOT NULL,
"userId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "album_user_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "album_user_audit_albumId_idx" ON "album_user_audit" ("albumId"); -- missing in target
CREATE INDEX "album_user_audit_userId_idx" ON "album_user_audit" ("userId"); -- missing in target
CREATE INDEX "album_user_audit_deletedAt_idx" ON "album_user_audit" ("deletedAt"); -- missing in target
CREATE TABLE "album_user" (
"albumsId" uuid NOT NULL,
"usersId" uuid NOT NULL,
"role" character varying NOT NULL DEFAULT 'editor',
"createId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
CONSTRAINT "album_user_albumsId_fkey" FOREIGN KEY ("albumsId") REFERENCES "album" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_user_usersId_fkey" FOREIGN KEY ("usersId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "album_user_pkey" PRIMARY KEY ("albumsId", "usersId")
); -- missing in target
CREATE INDEX "album_user_albumsId_idx" ON "album_user" ("albumsId"); -- missing in target
CREATE INDEX "album_user_usersId_idx" ON "album_user" ("usersId"); -- missing in target
CREATE INDEX "album_user_createId_idx" ON "album_user" ("createId"); -- missing in target
CREATE INDEX "album_user_updateId_idx" ON "album_user" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "album_user_delete_audit"
AFTER DELETE ON "album_user"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() <= 1)
EXECUTE FUNCTION album_user_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "album_user_after_insert"
AFTER INSERT ON "album_user"
REFERENCING NEW TABLE AS "inserted_rows"
FOR EACH STATEMENT
EXECUTE FUNCTION album_user_after_insert(); -- missing in target
CREATE OR REPLACE TRIGGER "album_user_updatedAt"
BEFORE UPDATE ON "album_user"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "api_key" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"name" character varying NOT NULL,
"key" character varying NOT NULL,
"userId" uuid NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"permissions" character varying[] NOT NULL,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "api_key_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "api_key_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "api_key_userId_idx" ON "api_key" ("userId"); -- missing in target
CREATE INDEX "api_key_updateId_idx" ON "api_key" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "api_key_updatedAt"
BEFORE UPDATE ON "api_key"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "asset_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"assetId" uuid NOT NULL,
"ownerId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "asset_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "asset_audit_assetId_idx" ON "asset_audit" ("assetId"); -- missing in target
CREATE INDEX "asset_audit_ownerId_idx" ON "asset_audit" ("ownerId"); -- missing in target
CREATE INDEX "asset_audit_deletedAt_idx" ON "asset_audit" ("deletedAt"); -- missing in target
CREATE TABLE "asset_exif" (
"assetId" uuid NOT NULL,
"make" character varying,
"model" character varying,
"exifImageWidth" integer,
"exifImageHeight" integer,
"fileSizeInByte" bigint,
"orientation" character varying,
"dateTimeOriginal" timestamp with time zone,
"modifyDate" timestamp with time zone,
"lensModel" character varying,
"fNumber" double precision,
"focalLength" double precision,
"iso" integer,
"latitude" double precision,
"longitude" double precision,
"city" character varying,
"state" character varying,
"country" character varying,
"description" text NOT NULL DEFAULT '',
"fps" double precision,
"exposureTime" character varying,
"livePhotoCID" character varying,
"timeZone" character varying,
"projectionType" character varying,
"profileDescription" character varying,
"colorspace" character varying,
"bitsPerSample" integer,
"autoStackId" character varying,
"rating" integer,
"updatedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "asset_exif_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "asset_exif_pkey" PRIMARY KEY ("assetId")
); -- missing in target
CREATE INDEX "asset_exif_city_idx" ON "asset_exif" ("city"); -- missing in target
CREATE INDEX "asset_exif_livePhotoCID_idx" ON "asset_exif" ("livePhotoCID"); -- missing in target
CREATE INDEX "asset_exif_autoStackId_idx" ON "asset_exif" ("autoStackId"); -- missing in target
CREATE INDEX "asset_exif_updateId_idx" ON "asset_exif" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "asset_exif_updatedAt"
BEFORE UPDATE ON "asset_exif"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "asset_face_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"assetFaceId" uuid NOT NULL,
"assetId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "asset_face_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "asset_face_audit_assetFaceId_idx" ON "asset_face_audit" ("assetFaceId"); -- missing in target
CREATE INDEX "asset_face_audit_assetId_idx" ON "asset_face_audit" ("assetId"); -- missing in target
CREATE INDEX "asset_face_audit_deletedAt_idx" ON "asset_face_audit" ("deletedAt"); -- missing in target
CREATE TABLE "asset_face" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"assetId" uuid NOT NULL,
"personId" uuid,
"imageWidth" integer NOT NULL DEFAULT 0,
"imageHeight" integer NOT NULL DEFAULT 0,
"boundingBoxX1" integer NOT NULL DEFAULT 0,
"boundingBoxY1" integer NOT NULL DEFAULT 0,
"boundingBoxX2" integer NOT NULL DEFAULT 0,
"boundingBoxY2" integer NOT NULL DEFAULT 0,
"sourceType" sourcetype NOT NULL DEFAULT 'machine-learning',
"deletedAt" timestamp with time zone,
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "asset_face_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "asset_face_personId_fkey" FOREIGN KEY ("personId") REFERENCES "person" ("id") ON UPDATE CASCADE ON DELETE SET NULL,
CONSTRAINT "asset_face_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "asset_face_personId_assetId_idx" ON "asset_face" ("personId", "assetId"); -- missing in target
CREATE INDEX "asset_face_assetId_personId_idx" ON "asset_face" ("assetId", "personId"); -- missing in target
CREATE OR REPLACE TRIGGER "asset_face_audit"
AFTER DELETE ON "asset_face"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION asset_face_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "asset_face_updatedAt"
BEFORE UPDATE ON "asset_face"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "asset_file" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"assetId" uuid NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"type" character varying NOT NULL,
"path" character varying NOT NULL,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "asset_file_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "asset_file_assetId_type_uq" UNIQUE ("assetId", "type"),
CONSTRAINT "asset_file_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "asset_file_assetId_idx" ON "asset_file" ("assetId"); -- missing in target
CREATE INDEX "asset_file_updateId_idx" ON "asset_file" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "asset_file_updatedAt"
BEFORE UPDATE ON "asset_file"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "memory" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"deletedAt" timestamp with time zone,
"ownerId" uuid NOT NULL,
"type" character varying NOT NULL,
"data" jsonb NOT NULL,
"isSaved" boolean NOT NULL DEFAULT false,
"memoryAt" timestamp with time zone NOT NULL,
"seenAt" timestamp with time zone,
"showAt" timestamp with time zone,
"hideAt" timestamp with time zone,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "memory_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "memory_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "memory_ownerId_idx" ON "memory" ("ownerId"); -- missing in target
CREATE INDEX "memory_updateId_idx" ON "memory" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "memory_delete_audit"
AFTER DELETE ON "memory"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION memory_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "memory_updatedAt"
BEFORE UPDATE ON "memory"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "memory_asset_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"memoryId" uuid NOT NULL,
"assetId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "memory_asset_audit_memoryId_fkey" FOREIGN KEY ("memoryId") REFERENCES "memory" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "memory_asset_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "memory_asset_audit_memoryId_idx" ON "memory_asset_audit" ("memoryId"); -- missing in target
CREATE INDEX "memory_asset_audit_assetId_idx" ON "memory_asset_audit" ("assetId"); -- missing in target
CREATE INDEX "memory_asset_audit_deletedAt_idx" ON "memory_asset_audit" ("deletedAt"); -- missing in target
CREATE TABLE "memory_asset" (
"memoriesId" uuid NOT NULL,
"assetsId" uuid NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "memory_asset_memoriesId_fkey" FOREIGN KEY ("memoriesId") REFERENCES "memory" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "memory_asset_assetsId_fkey" FOREIGN KEY ("assetsId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "memory_asset_pkey" PRIMARY KEY ("memoriesId", "assetsId")
); -- missing in target
CREATE INDEX "memory_asset_memoriesId_idx" ON "memory_asset" ("memoriesId"); -- missing in target
CREATE INDEX "memory_asset_assetsId_idx" ON "memory_asset" ("assetsId"); -- missing in target
CREATE INDEX "memory_asset_updateId_idx" ON "memory_asset" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "memory_asset_delete_audit"
AFTER DELETE ON "memory_asset"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() <= 1)
EXECUTE FUNCTION memory_asset_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "memory_asset_updatedAt"
BEFORE UPDATE ON "memory_asset"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "memory_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"memoryId" uuid NOT NULL,
"userId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "memory_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "memory_audit_memoryId_idx" ON "memory_audit" ("memoryId"); -- missing in target
CREATE INDEX "memory_audit_userId_idx" ON "memory_audit" ("userId"); -- missing in target
CREATE INDEX "memory_audit_deletedAt_idx" ON "memory_audit" ("deletedAt"); -- missing in target
CREATE TABLE "notification" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"deletedAt" timestamp with time zone,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"userId" uuid,
"level" character varying NOT NULL DEFAULT 'info',
"type" character varying NOT NULL DEFAULT 'info',
"data" jsonb,
"title" character varying NOT NULL,
"description" text,
"readAt" timestamp with time zone,
CONSTRAINT "notification_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "notification_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "notification_updateId_idx" ON "notification" ("updateId"); -- missing in target
CREATE INDEX "notification_userId_idx" ON "notification" ("userId"); -- missing in target
CREATE OR REPLACE TRIGGER "notification_updatedAt"
BEFORE UPDATE ON "notification"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "partner_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"sharedById" uuid NOT NULL,
"sharedWithId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "partner_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "partner_audit_sharedById_idx" ON "partner_audit" ("sharedById"); -- missing in target
CREATE INDEX "partner_audit_sharedWithId_idx" ON "partner_audit" ("sharedWithId"); -- missing in target
CREATE INDEX "partner_audit_deletedAt_idx" ON "partner_audit" ("deletedAt"); -- missing in target
CREATE TABLE "partner" (
"sharedById" uuid NOT NULL,
"sharedWithId" uuid NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"createId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"inTimeline" boolean NOT NULL DEFAULT false,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "partner_sharedById_fkey" FOREIGN KEY ("sharedById") REFERENCES "user" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "partner_sharedWithId_fkey" FOREIGN KEY ("sharedWithId") REFERENCES "user" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "partner_pkey" PRIMARY KEY ("sharedById", "sharedWithId")
); -- missing in target
CREATE INDEX "partner_sharedWithId_idx" ON "partner" ("sharedWithId"); -- missing in target
CREATE INDEX "partner_createId_idx" ON "partner" ("createId"); -- missing in target
CREATE INDEX "partner_updateId_idx" ON "partner" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "partner_delete_audit"
AFTER DELETE ON "partner"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION partner_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "partner_updatedAt"
BEFORE UPDATE ON "partner"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "person_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"personId" uuid NOT NULL,
"ownerId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "person_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "person_audit_personId_idx" ON "person_audit" ("personId"); -- missing in target
CREATE INDEX "person_audit_ownerId_idx" ON "person_audit" ("ownerId"); -- missing in target
CREATE INDEX "person_audit_deletedAt_idx" ON "person_audit" ("deletedAt"); -- missing in target
CREATE TABLE "session" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"token" character varying NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"expiresAt" timestamp with time zone,
"userId" uuid NOT NULL,
"parentId" uuid,
"deviceType" character varying NOT NULL DEFAULT '',
"deviceOS" character varying NOT NULL DEFAULT '',
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
"isPendingSyncReset" boolean NOT NULL DEFAULT false,
"pinExpiresAt" timestamp with time zone,
CONSTRAINT "session_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "session_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "session" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "session_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "session_userId_idx" ON "session" ("userId"); -- missing in target
CREATE INDEX "session_parentId_idx" ON "session" ("parentId"); -- missing in target
CREATE INDEX "session_updateId_idx" ON "session" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "session_updatedAt"
BEFORE UPDATE ON "session"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "shared_link" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"description" character varying,
"userId" uuid NOT NULL,
"key" bytea NOT NULL,
"type" character varying NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"expiresAt" timestamp with time zone,
"allowUpload" boolean NOT NULL DEFAULT false,
"albumId" uuid,
"allowDownload" boolean NOT NULL DEFAULT true,
"showExif" boolean NOT NULL DEFAULT true,
"password" character varying,
"slug" character varying,
CONSTRAINT "shared_link_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "shared_link_albumId_fkey" FOREIGN KEY ("albumId") REFERENCES "album" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "shared_link_key_uq" UNIQUE ("key"),
CONSTRAINT "shared_link_slug_uq" UNIQUE ("slug"),
CONSTRAINT "shared_link_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "shared_link_userId_idx" ON "shared_link" ("userId"); -- missing in target
CREATE INDEX "shared_link_key_idx" ON "shared_link" ("key"); -- missing in target
CREATE INDEX "shared_link_albumId_idx" ON "shared_link" ("albumId"); -- missing in target
CREATE TABLE "shared_link_asset" (
"assetsId" uuid NOT NULL,
"sharedLinksId" uuid NOT NULL,
CONSTRAINT "shared_link_asset_assetsId_fkey" FOREIGN KEY ("assetsId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "shared_link_asset_sharedLinksId_fkey" FOREIGN KEY ("sharedLinksId") REFERENCES "shared_link" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "shared_link_asset_pkey" PRIMARY KEY ("assetsId", "sharedLinksId")
); -- missing in target
CREATE INDEX "shared_link_asset_assetsId_idx" ON "shared_link_asset" ("assetsId"); -- missing in target
CREATE INDEX "shared_link_asset_sharedLinksId_idx" ON "shared_link_asset" ("sharedLinksId"); -- missing in target
CREATE TABLE "stack_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"stackId" uuid NOT NULL,
"userId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "stack_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "stack_audit_deletedAt_idx" ON "stack_audit" ("deletedAt"); -- missing in target
CREATE TABLE "session_sync_checkpoint" (
"sessionId" uuid NOT NULL,
"type" character varying NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"ack" character varying NOT NULL,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "session_sync_checkpoint_sessionId_fkey" FOREIGN KEY ("sessionId") REFERENCES "session" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "session_sync_checkpoint_pkey" PRIMARY KEY ("sessionId", "type")
); -- missing in target
CREATE INDEX "session_sync_checkpoint_sessionId_idx" ON "session_sync_checkpoint" ("sessionId"); -- missing in target
CREATE INDEX "session_sync_checkpoint_updateId_idx" ON "session_sync_checkpoint" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "session_sync_checkpoint_updatedAt"
BEFORE UPDATE ON "session_sync_checkpoint"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "tag" (
"id" uuid NOT NULL DEFAULT uuid_generate_v4(),
"userId" uuid NOT NULL,
"value" character varying NOT NULL,
"createdAt" timestamp with time zone NOT NULL DEFAULT now(),
"updatedAt" timestamp with time zone NOT NULL DEFAULT now(),
"color" character varying,
"parentId" uuid,
"updateId" uuid NOT NULL DEFAULT immich_uuid_v7(),
CONSTRAINT "tag_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "tag_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "tag" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "tag_userId_value_uq" UNIQUE ("userId", "value"),
CONSTRAINT "tag_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "tag_parentId_idx" ON "tag" ("parentId"); -- missing in target
CREATE INDEX "tag_updateId_idx" ON "tag" ("updateId"); -- missing in target
CREATE OR REPLACE TRIGGER "tag_updatedAt"
BEFORE UPDATE ON "tag"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE TABLE "tag_closure" (
"id_ancestor" uuid NOT NULL,
"id_descendant" uuid NOT NULL,
CONSTRAINT "tag_closure_id_ancestor_fkey" FOREIGN KEY ("id_ancestor") REFERENCES "tag" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "tag_closure_id_descendant_fkey" FOREIGN KEY ("id_descendant") REFERENCES "tag" ("id") ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT "tag_closure_pkey" PRIMARY KEY ("id_ancestor", "id_descendant")
); -- missing in target
CREATE INDEX "tag_closure_id_ancestor_idx" ON "tag_closure" ("id_ancestor"); -- missing in target
CREATE INDEX "tag_closure_id_descendant_idx" ON "tag_closure" ("id_descendant"); -- missing in target
CREATE TABLE "user_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"userId" uuid NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "user_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "user_audit_deletedAt_idx" ON "user_audit" ("deletedAt"); -- missing in target
CREATE TABLE "user_metadata_audit" (
"id" uuid NOT NULL DEFAULT immich_uuid_v7(),
"userId" uuid NOT NULL,
"key" character varying NOT NULL,
"deletedAt" timestamp with time zone NOT NULL DEFAULT clock_timestamp(),
CONSTRAINT "user_metadata_audit_pkey" PRIMARY KEY ("id")
); -- missing in target
CREATE INDEX "IDX_user_metadata_audit_user_id" ON "user_metadata_audit" ("userId"); -- missing in target
CREATE INDEX "IDX_user_metadata_audit_key" ON "user_metadata_audit" ("key"); -- missing in target
CREATE INDEX "IDX_user_metadata_audit_deleted_at" ON "user_metadata_audit" ("deletedAt"); -- missing in target
CREATE TABLE "migration_overrides" (
"name" character varying NOT NULL,
"value" jsonb NOT NULL,
CONSTRAINT "migration_overrides_pkey" PRIMARY KEY ("name")
); -- missing in target
ALTER TABLE "user_metadata" ADD "updateId" uuid NOT NULL DEFAULT immich_uuid_v7(); -- missing in target
ALTER TABLE "user_metadata" ADD "updatedAt" timestamp with time zone NOT NULL DEFAULT now(); -- missing in target
ALTER TABLE "face_search" ADD CONSTRAINT "face_search_pkey" PRIMARY KEY ("faceId"); -- missing in target
ALTER TABLE "activity" ADD CONSTRAINT "activity_albumId_fkey" FOREIGN KEY ("albumId") REFERENCES "album" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "activity" ADD CONSTRAINT "activity_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "activity" ADD CONSTRAINT "activity_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "activity" ADD CONSTRAINT "activity_albumId_assetId_fkey" FOREIGN KEY ("albumId", "assetId") REFERENCES "album_asset" ("albumsId", "assetsId") ON UPDATE NO ACTION ON DELETE CASCADE; -- missing in target
ALTER TABLE "person" ADD CONSTRAINT "person_ownerId_fkey" FOREIGN KEY ("ownerId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "person" ADD CONSTRAINT "person_faceAssetId_fkey" FOREIGN KEY ("faceAssetId") REFERENCES "asset_face" ("id") ON UPDATE NO ACTION ON DELETE SET NULL; -- missing in target
ALTER TABLE "asset_job_status" ADD CONSTRAINT "asset_job_status_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "face_search" ADD CONSTRAINT "face_search_faceId_fkey" FOREIGN KEY ("faceId") REFERENCES "asset_face" ("id") ON UPDATE NO ACTION ON DELETE CASCADE; -- reference table is different (asset_face vs asset_faces)
ALTER TABLE "smart_search" ADD CONSTRAINT "smart_search_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES "asset" ("id") ON UPDATE NO ACTION ON DELETE CASCADE; -- missing in target
ALTER TABLE "tag_asset" ADD CONSTRAINT "tag_asset_assetsId_fkey" FOREIGN KEY ("assetsId") REFERENCES "asset" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "tag_asset" ADD CONSTRAINT "tag_asset_tagsId_fkey" FOREIGN KEY ("tagsId") REFERENCES "tag" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "user_metadata" ADD CONSTRAINT "user_metadata_userId_fkey" FOREIGN KEY ("userId") REFERENCES "user" ("id") ON UPDATE CASCADE ON DELETE CASCADE; -- missing in target
ALTER TABLE "activity" RENAME CONSTRAINT "PK_24625a1d6b1b089c8ae206fe467" TO "activity_pkey"; -- name has changed
ALTER TABLE "activity" RENAME CONSTRAINT "CHK_2ab1e70f113f450eb40c1e3ec8" TO "activity_like_check"; -- name has changed
ALTER TABLE "person" RENAME CONSTRAINT "PK_5fdaf670315c4b7e70cce85daa3" TO "person_pkey"; -- name has changed
ALTER TABLE "person" RENAME CONSTRAINT "CHK_b0f82b0ed662bfc24fbb58bb45" TO "person_birthDate_chk"; -- name has changed
ALTER TABLE "asset_job_status" RENAME CONSTRAINT "PK_420bec36fc02813bddf5c8b73d4" TO "asset_job_status_pkey"; -- name has changed
ALTER TABLE "audit" RENAME CONSTRAINT "PK_1d3d120ddaf7bc9b1ed68ed463a" TO "audit_pkey"; -- name has changed
ALTER TABLE "move_history" RENAME CONSTRAINT "PK_af608f132233acf123f2949678d" TO "move_history_pkey"; -- name has changed
ALTER TABLE "system_metadata" RENAME CONSTRAINT "PK_fa94f6857470fb5b81ec6084465" TO "system_metadata_pkey"; -- name has changed
ALTER TABLE "tag_asset" RENAME CONSTRAINT "PK_ef5346fe522b5fb3bc96454747e" TO "tag_asset_pkey"; -- name has changed
ALTER TABLE "user_metadata" RENAME CONSTRAINT "PK_5931462150b3438cbc83277fe5a" TO "user_metadata_pkey"; -- name has changed
ALTER TABLE "version_history" RENAME CONSTRAINT "PK_5db259cbb09ce82c0d13cfd1b23" TO "version_history_pkey"; -- name has changed
CREATE INDEX "activity_albumId_assetId_idx" ON "activity" ("albumId", "assetId"); -- missing in target
CREATE UNIQUE INDEX "activity_like_idx" ON "activity" ("assetId", "userId", "albumId") WHERE ("isLiked" = true); -- missing in target
CREATE INDEX "face_index" ON "face_search" USING hnsw (embedding vector_cosine_ops) WITH (ef_construction = 300, m = 16); -- columns are different (undefined vs embedding)
CREATE INDEX "idx_geodata_places_name" ON "geodata_places" USING gin (f_unaccent("name") gin_trgm_ops); -- expression is different (f_unaccent("name") gin_trgm_ops vs f_unaccent((name)::text))
CREATE INDEX "idx_geodata_places_admin2_name" ON "geodata_places" USING gin (f_unaccent("admin2Name") gin_trgm_ops); -- expression is different (f_unaccent("admin2Name") gin_trgm_ops vs f_unaccent(("admin2Name")::text))
CREATE INDEX "idx_geodata_places_admin1_name" ON "geodata_places" USING gin (f_unaccent("admin1Name") gin_trgm_ops); -- expression is different (f_unaccent("admin1Name") gin_trgm_ops vs f_unaccent(("admin1Name")::text))
CREATE INDEX "idx_geodata_places_alternate_names" ON "geodata_places" USING gin (f_unaccent("alternateNames") gin_trgm_ops); -- expression is different (f_unaccent("alternateNames") gin_trgm_ops vs f_unaccent(("alternateNames")::text))
CREATE INDEX "IDX_geodata_gist_earthcoord" ON "geodata_places" (ll_to_earth_public(latitude, longitude)); -- missing in target
CREATE INDEX "IDX_user_metadata_update_id" ON "user_metadata" ("updateId"); -- missing in target
CREATE INDEX "IDX_user_metadata_updated_at" ON "user_metadata" ("updatedAt"); -- missing in target
ALTER INDEX "IDX_activity_update_id" RENAME TO "activity_updateId_idx"; -- name has changed
ALTER INDEX "IDX_1af8519996fbfb3684b58df280" RENAME TO "activity_albumId_idx"; -- name has changed
ALTER INDEX "IDX_3571467bcbe021f66e2bdce96e" RENAME TO "activity_userId_idx"; -- name has changed
ALTER INDEX "IDX_8091ea76b12338cb4428d33d78" RENAME TO "activity_assetId_idx"; -- name has changed
ALTER INDEX "IDX_person_update_id" RENAME TO "person_updateId_idx"; -- name has changed
ALTER INDEX "IDX_2bbabe31656b6778c6b87b6102" RENAME TO "person_faceAssetId_idx"; -- name has changed
ALTER INDEX "IDX_5527cc99f530a547093f9e577b" RENAME TO "person_ownerId_idx"; -- name has changed
ALTER INDEX "IDX_ownerId_createdAt" RENAME TO "audit_ownerId_createdAt_idx"; -- name has changed
ALTER INDEX "IDX_tag_asset_assetsId_tagsId" RENAME TO "tag_asset_assetsId_tagsId_idx"; -- name has changed
ALTER INDEX "IDX_f8e8a9e893cb5c54907f1b798e" RENAME TO "tag_asset_assetsId_idx"; -- name has changed
ALTER INDEX "IDX_e99f31ea4cdf3a2c35c7287eb4" RENAME TO "tag_asset_tagsId_idx"; -- name has changed
CREATE OR REPLACE TRIGGER "activity_updatedAt"
BEFORE UPDATE ON "activity"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE OR REPLACE TRIGGER "person_delete_audit"
AFTER DELETE ON "person"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION person_delete_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "person_updatedAt"
BEFORE UPDATE ON "person"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
CREATE OR REPLACE TRIGGER "user_metadata_audit"
AFTER DELETE ON "user_metadata"
REFERENCING OLD TABLE AS "old"
FOR EACH STATEMENT
WHEN (pg_trigger_depth() = 0)
EXECUTE FUNCTION user_metadata_audit(); -- missing in target
CREATE OR REPLACE TRIGGER "user_metadata_updated_at"
BEFORE UPDATE ON "user_metadata"
FOR EACH ROW
EXECUTE FUNCTION updated_at(); -- missing in target
DROP FUNCTION users_delete_audit; -- missing in source
DROP FUNCTION partners_delete_audit; -- missing in source
DROP FUNCTION assets_delete_audit; -- missing in source
DROP FUNCTION albums_delete_audit; -- missing in source
DROP FUNCTION album_users_delete_audit; -- missing in source
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_immich_uuid_v7', '{"type":"function","name":"immich_uuid_v7","sql":"CREATE OR REPLACE FUNCTION immich_uuid_v7(p_timestamp timestamp with time zone default clock_timestamp())\\n RETURNS uuid\\n VOLATILE LANGUAGE SQL\\n AS $$\\n SELECT encode(\\n set_bit(\\n set_bit(\\n overlay(uuid_send(gen_random_uuid())\\n placing substring(int8send(floor(extract(epoch from p_timestamp) * 1000)::bigint) from 3)\\n from 1 for 6\\n ),\\n 52, 1\\n ),\\n 53, 1\\n ),\\n ''hex'')::uuid;\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_album_user_after_insert', '{"type":"function","name":"album_user_after_insert","sql":"CREATE OR REPLACE FUNCTION album_user_after_insert()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n UPDATE album SET \\"updatedAt\\" = clock_timestamp(), \\"updateId\\" = immich_uuid_v7(clock_timestamp())\\n WHERE \\"id\\" IN (SELECT DISTINCT \\"albumsId\\" FROM inserted_rows);\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_updated_at', '{"type":"function","name":"updated_at","sql":"CREATE OR REPLACE FUNCTION updated_at()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n DECLARE\\n clock_timestamp TIMESTAMP := clock_timestamp();\\n BEGIN\\n new.\\"updatedAt\\" = clock_timestamp;\\n new.\\"updateId\\" = immich_uuid_v7(clock_timestamp);\\n return new;\\n END;\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_f_concat_ws', '{"type":"function","name":"f_concat_ws","sql":"CREATE OR REPLACE FUNCTION f_concat_ws(text, text[])\\n RETURNS text\\n PARALLEL SAFE IMMUTABLE LANGUAGE SQL\\n AS $$SELECT array_to_string($2, $1)$$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_f_unaccent', '{"type":"function","name":"f_unaccent","sql":"CREATE OR REPLACE FUNCTION f_unaccent(text)\\n RETURNS text\\n PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL\\n RETURN unaccent(''unaccent'', $1)"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_ll_to_earth_public', '{"type":"function","name":"ll_to_earth_public","sql":"CREATE OR REPLACE FUNCTION ll_to_earth_public(latitude double precision, longitude double precision)\\n RETURNS public.earth\\n PARALLEL SAFE STRICT IMMUTABLE LANGUAGE SQL\\n AS $$SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians(latitude))*cos(radians(longitude))),public.earth()*cos(radians(latitude))*sin(radians(longitude))),public.earth()*sin(radians(latitude)))::public.earth$$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_user_delete_audit', '{"type":"function","name":"user_delete_audit","sql":"CREATE OR REPLACE FUNCTION user_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO user_audit (\\"userId\\")\\n SELECT \\"id\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_partner_delete_audit', '{"type":"function","name":"partner_delete_audit","sql":"CREATE OR REPLACE FUNCTION partner_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO partner_audit (\\"sharedById\\", \\"sharedWithId\\")\\n SELECT \\"sharedById\\", \\"sharedWithId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_asset_delete_audit', '{"type":"function","name":"asset_delete_audit","sql":"CREATE OR REPLACE FUNCTION asset_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO asset_audit (\\"assetId\\", \\"ownerId\\")\\n SELECT \\"id\\", \\"ownerId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_album_delete_audit', '{"type":"function","name":"album_delete_audit","sql":"CREATE OR REPLACE FUNCTION album_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO album_audit (\\"albumId\\", \\"userId\\")\\n SELECT \\"id\\", \\"ownerId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_album_asset_delete_audit', '{"type":"function","name":"album_asset_delete_audit","sql":"CREATE OR REPLACE FUNCTION album_asset_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO album_asset_audit (\\"albumId\\", \\"assetId\\")\\n SELECT \\"albumsId\\", \\"assetsId\\" FROM OLD\\n WHERE \\"albumsId\\" IN (SELECT \\"id\\" FROM album WHERE \\"id\\" IN (SELECT \\"albumsId\\" FROM OLD));\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_album_user_delete_audit', '{"type":"function","name":"album_user_delete_audit","sql":"CREATE OR REPLACE FUNCTION album_user_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO album_audit (\\"albumId\\", \\"userId\\")\\n SELECT \\"albumsId\\", \\"usersId\\"\\n FROM OLD;\\n\\n IF pg_trigger_depth() = 1 THEN\\n INSERT INTO album_user_audit (\\"albumId\\", \\"userId\\")\\n SELECT \\"albumsId\\", \\"usersId\\"\\n FROM OLD;\\n END IF;\\n\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_memory_delete_audit', '{"type":"function","name":"memory_delete_audit","sql":"CREATE OR REPLACE FUNCTION memory_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO memory_audit (\\"memoryId\\", \\"userId\\")\\n SELECT \\"id\\", \\"ownerId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_memory_asset_delete_audit', '{"type":"function","name":"memory_asset_delete_audit","sql":"CREATE OR REPLACE FUNCTION memory_asset_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO memory_asset_audit (\\"memoryId\\", \\"assetId\\")\\n SELECT \\"memoriesId\\", \\"assetsId\\" FROM OLD\\n WHERE \\"memoriesId\\" IN (SELECT \\"id\\" FROM memory WHERE \\"id\\" IN (SELECT \\"memoriesId\\" FROM OLD));\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_stack_delete_audit', '{"type":"function","name":"stack_delete_audit","sql":"CREATE OR REPLACE FUNCTION stack_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO stack_audit (\\"stackId\\", \\"userId\\")\\n SELECT \\"id\\", \\"ownerId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_person_delete_audit', '{"type":"function","name":"person_delete_audit","sql":"CREATE OR REPLACE FUNCTION person_delete_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO person_audit (\\"personId\\", \\"ownerId\\")\\n SELECT \\"id\\", \\"ownerId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_user_metadata_audit', '{"type":"function","name":"user_metadata_audit","sql":"CREATE OR REPLACE FUNCTION user_metadata_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO user_metadata_audit (\\"userId\\", \\"key\\")\\n SELECT \\"userId\\", \\"key\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('function_asset_face_audit', '{"type":"function","name":"asset_face_audit","sql":"CREATE OR REPLACE FUNCTION asset_face_audit()\\n RETURNS TRIGGER\\n LANGUAGE PLPGSQL\\n AS $$\\n BEGIN\\n INSERT INTO asset_face_audit (\\"assetFaceId\\", \\"assetId\\")\\n SELECT \\"id\\", \\"assetId\\"\\n FROM OLD;\\n RETURN NULL;\\n END\\n $$;"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_user_delete_audit', '{"type":"trigger","name":"user_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"user_delete_audit\\"\\n AFTER DELETE ON \\"user\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION user_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_user_updatedAt', '{"type":"trigger","name":"user_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"user_updatedAt\\"\\n BEFORE UPDATE ON \\"user\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_library_updatedAt', '{"type":"trigger","name":"library_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"library_updatedAt\\"\\n BEFORE UPDATE ON \\"library\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_stack_delete_audit', '{"type":"trigger","name":"stack_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"stack_delete_audit\\"\\n AFTER DELETE ON \\"stack\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION stack_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_stack_updatedAt', '{"type":"trigger","name":"stack_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"stack_updatedAt\\"\\n BEFORE UPDATE ON \\"stack\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_delete_audit', '{"type":"trigger","name":"asset_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"asset_delete_audit\\"\\n AFTER DELETE ON \\"asset\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION asset_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_updatedAt', '{"type":"trigger","name":"asset_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"asset_updatedAt\\"\\n BEFORE UPDATE ON \\"asset\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_asset_originalFilename_trigram_idx', '{"type":"index","name":"asset_originalFilename_trigram_idx","sql":"CREATE INDEX \\"asset_originalFilename_trigram_idx\\" ON \\"asset\\" USING gin (f_unaccent(\\"originalFileName\\") gin_trgm_ops);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_asset_localDateTime_month_idx', '{"type":"index","name":"asset_localDateTime_month_idx","sql":"CREATE INDEX \\"asset_localDateTime_month_idx\\" ON \\"asset\\" ((date_trunc(''MONTH''::text, (\\"localDateTime\\" AT TIME ZONE ''UTC''::text)) AT TIME ZONE ''UTC''::text));"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_asset_localDateTime_idx', '{"type":"index","name":"asset_localDateTime_idx","sql":"CREATE INDEX \\"asset_localDateTime_idx\\" ON \\"asset\\" (((\\"localDateTime\\" at time zone ''UTC'')::date));"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_asset_ownerId_libraryId_checksum_idx', '{"type":"index","name":"asset_ownerId_libraryId_checksum_idx","sql":"CREATE UNIQUE INDEX \\"asset_ownerId_libraryId_checksum_idx\\" ON \\"asset\\" (\\"ownerId\\", \\"libraryId\\", \\"checksum\\") WHERE (\\"libraryId\\" IS NOT NULL);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_UQ_assets_owner_checksum', '{"type":"index","name":"UQ_assets_owner_checksum","sql":"CREATE UNIQUE INDEX \\"UQ_assets_owner_checksum\\" ON \\"asset\\" (\\"ownerId\\", \\"checksum\\") WHERE (\\"libraryId\\" IS NULL);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_delete_audit', '{"type":"trigger","name":"album_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"album_delete_audit\\"\\n AFTER DELETE ON \\"album\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION album_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_updatedAt', '{"type":"trigger","name":"album_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"album_updatedAt\\"\\n BEFORE UPDATE ON \\"album\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_asset_delete_audit', '{"type":"trigger","name":"album_asset_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"album_asset_delete_audit\\"\\n AFTER DELETE ON \\"album_asset\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() <= 1)\\n EXECUTE FUNCTION album_asset_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_asset_updatedAt', '{"type":"trigger","name":"album_asset_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"album_asset_updatedAt\\"\\n BEFORE UPDATE ON \\"album_asset\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_activity_updatedAt', '{"type":"trigger","name":"activity_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"activity_updatedAt\\"\\n BEFORE UPDATE ON \\"activity\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_activity_like_idx', '{"type":"index","name":"activity_like_idx","sql":"CREATE UNIQUE INDEX \\"activity_like_idx\\" ON \\"activity\\" (\\"assetId\\", \\"userId\\", \\"albumId\\") WHERE (\\"isLiked\\" = true);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_user_delete_audit', '{"type":"trigger","name":"album_user_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"album_user_delete_audit\\"\\n AFTER DELETE ON \\"album_user\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() <= 1)\\n EXECUTE FUNCTION album_user_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_user_after_insert', '{"type":"trigger","name":"album_user_after_insert","sql":"CREATE OR REPLACE TRIGGER \\"album_user_after_insert\\"\\n AFTER INSERT ON \\"album_user\\"\\n REFERENCING NEW TABLE AS \\"inserted_rows\\"\\n FOR EACH STATEMENT\\n EXECUTE FUNCTION album_user_after_insert();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_album_user_updatedAt', '{"type":"trigger","name":"album_user_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"album_user_updatedAt\\"\\n BEFORE UPDATE ON \\"album_user\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_api_key_updatedAt', '{"type":"trigger","name":"api_key_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"api_key_updatedAt\\"\\n BEFORE UPDATE ON \\"api_key\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_exif_updatedAt', '{"type":"trigger","name":"asset_exif_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"asset_exif_updatedAt\\"\\n BEFORE UPDATE ON \\"asset_exif\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_person_delete_audit', '{"type":"trigger","name":"person_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"person_delete_audit\\"\\n AFTER DELETE ON \\"person\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION person_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_person_updatedAt', '{"type":"trigger","name":"person_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"person_updatedAt\\"\\n BEFORE UPDATE ON \\"person\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_face_audit', '{"type":"trigger","name":"asset_face_audit","sql":"CREATE OR REPLACE TRIGGER \\"asset_face_audit\\"\\n AFTER DELETE ON \\"asset_face\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION asset_face_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_face_updatedAt', '{"type":"trigger","name":"asset_face_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"asset_face_updatedAt\\"\\n BEFORE UPDATE ON \\"asset_face\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_asset_file_updatedAt', '{"type":"trigger","name":"asset_file_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"asset_file_updatedAt\\"\\n BEFORE UPDATE ON \\"asset_file\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_face_index', '{"type":"index","name":"face_index","sql":"CREATE INDEX \\"face_index\\" ON \\"face_search\\" USING hnsw (embedding vector_cosine_ops) WITH (ef_construction = 300, m = 16);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_IDX_geodata_gist_earthcoord', '{"type":"index","name":"IDX_geodata_gist_earthcoord","sql":"CREATE INDEX \\"IDX_geodata_gist_earthcoord\\" ON \\"geodata_places\\" (ll_to_earth_public(latitude, longitude));"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_idx_geodata_places_name', '{"type":"index","name":"idx_geodata_places_name","sql":"CREATE INDEX \\"idx_geodata_places_name\\" ON \\"geodata_places\\" USING gin (f_unaccent(\\"name\\") gin_trgm_ops);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_idx_geodata_places_admin2_name', '{"type":"index","name":"idx_geodata_places_admin2_name","sql":"CREATE INDEX \\"idx_geodata_places_admin2_name\\" ON \\"geodata_places\\" USING gin (f_unaccent(\\"admin2Name\\") gin_trgm_ops);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_idx_geodata_places_admin1_name', '{"type":"index","name":"idx_geodata_places_admin1_name","sql":"CREATE INDEX \\"idx_geodata_places_admin1_name\\" ON \\"geodata_places\\" USING gin (f_unaccent(\\"admin1Name\\") gin_trgm_ops);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('index_idx_geodata_places_alternate_names', '{"type":"index","name":"idx_geodata_places_alternate_names","sql":"CREATE INDEX \\"idx_geodata_places_alternate_names\\" ON \\"geodata_places\\" USING gin (f_unaccent(\\"alternateNames\\") gin_trgm_ops);"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_memory_delete_audit', '{"type":"trigger","name":"memory_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"memory_delete_audit\\"\\n AFTER DELETE ON \\"memory\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION memory_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_memory_updatedAt', '{"type":"trigger","name":"memory_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"memory_updatedAt\\"\\n BEFORE UPDATE ON \\"memory\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_memory_asset_delete_audit', '{"type":"trigger","name":"memory_asset_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"memory_asset_delete_audit\\"\\n AFTER DELETE ON \\"memory_asset\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() <= 1)\\n EXECUTE FUNCTION memory_asset_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_memory_asset_updatedAt', '{"type":"trigger","name":"memory_asset_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"memory_asset_updatedAt\\"\\n BEFORE UPDATE ON \\"memory_asset\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_notification_updatedAt', '{"type":"trigger","name":"notification_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"notification_updatedAt\\"\\n BEFORE UPDATE ON \\"notification\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_partner_delete_audit', '{"type":"trigger","name":"partner_delete_audit","sql":"CREATE OR REPLACE TRIGGER \\"partner_delete_audit\\"\\n AFTER DELETE ON \\"partner\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION partner_delete_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_partner_updatedAt', '{"type":"trigger","name":"partner_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"partner_updatedAt\\"\\n BEFORE UPDATE ON \\"partner\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_session_updatedAt', '{"type":"trigger","name":"session_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"session_updatedAt\\"\\n BEFORE UPDATE ON \\"session\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_session_sync_checkpoint_updatedAt', '{"type":"trigger","name":"session_sync_checkpoint_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"session_sync_checkpoint_updatedAt\\"\\n BEFORE UPDATE ON \\"session_sync_checkpoint\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_tag_updatedAt', '{"type":"trigger","name":"tag_updatedAt","sql":"CREATE OR REPLACE TRIGGER \\"tag_updatedAt\\"\\n BEFORE UPDATE ON \\"tag\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_user_metadata_audit', '{"type":"trigger","name":"user_metadata_audit","sql":"CREATE OR REPLACE TRIGGER \\"user_metadata_audit\\"\\n AFTER DELETE ON \\"user_metadata\\"\\n REFERENCING OLD TABLE AS \\"old\\"\\n FOR EACH STATEMENT\\n WHEN (pg_trigger_depth() = 0)\\n EXECUTE FUNCTION user_metadata_audit();"}'::jsonb); -- missing in target
INSERT INTO "migration_overrides" ("name", "value") VALUES ('trigger_user_metadata_updated_at', '{"type":"trigger","name":"user_metadata_updated_at","sql":"CREATE OR REPLACE TRIGGER \\"user_metadata_updated_at\\"\\n BEFORE UPDATE ON \\"user_metadata\\"\\n FOR EACH ROW\\n EXECUTE FUNCTION updated_at();"}'::jsonb); -- missing in targetdocker exec -ti --user postgres immich_postgres psql -Ppager=no -d immich psql (14.10 (Debian 14.10-1.pgdg120+1)) |
Beta Was this translation helpful? Give feedback.
-
|
Thanks a lot! DB schemaThere seems to be a huge drift / differences in the database schema. Most likely your issue is different from what is discussed in this topic. Dangling exif records
This is also quite massive amount of dangling exif records without matching assets. A couple of questions
|
Beta Was this translation helpful? Give feedback.
-
|
I don't have discord account |
Beta Was this translation helpful? Give feedback.
-
FKsI suggest to fix remaining missing foreign keys one by one. I prepared SQL statements based on the schema you posted in #20531 (reply in thread). Let know if you encounter unexpected errors, there might by typos. Go through the missing FKs below and fix them one by one:
ALTER TABLE asset_faces ADD CONSTRAINT "FK_02a43fd0b3c50fb6d7f0cb7282c" FOREIGN KEY ("assetId") REFERENCES assets(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM asset_faces WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");
DELETE FROM asset_faces WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");
ALTER TABLE asset_job_status ADD CONSTRAINT "FK_420bec36fc02813bddf5c8b73d4" FOREIGN KEY ("assetId") REFERENCES assets(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM asset_job_status WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");
DELETE FROM asset_job_status WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");
ALTER TABLE memories_assets_assets ADD CONSTRAINT "FK_6942ecf52d75d4273de19d2c16f" FOREIGN KEY ("assetsId") REFERENCES assets(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM memories_assets_assets WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetsId");
DELETE FROM memories_assets_assets WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetsId");
ALTER TABLE memories_assets_assets ADD CONSTRAINT "FK_984e5c9ab1f04d34538cd32334e" FOREIGN KEY ("memoriesId") REFERENCES memories(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM memories_assets_assets WHERE NOT EXISTS (SELECT 1 FROM memories WHERE id = "memoriesId");
DELETE FROM memories_assets_assets WHERE NOT EXISTS (SELECT 1 FROM memories WHERE id = "memoriesId");
ALTER TABLE shared_link__asset ADD CONSTRAINT "FK_c9fab4aa97ffd1b034f3d6581ab" FOREIGN KEY ("sharedLinksId") REFERENCES shared_links(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM shared_link__asset WHERE NOT EXISTS (SELECT 1 FROM shared_links WHERE id = "sharedLinksId");
DELETE FROM shared_link__asset WHERE NOT EXISTS (SELECT 1 FROM shared_links WHERE id = "sharedLinksId");
ALTER TABLE tag_asset ADD CONSTRAINT "FK_f8e8a9e893cb5c54907f1b798e9" FOREIGN KEY ("assetsId") REFERENCES assets(id) ON UPDATE CASCADE ON DELETE CASCADE;
SELECT COUNT(*) FROM tag_asset WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetsId");
DELETE FROM tag_asset WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetsId");
ALTER TABLE smart_search ADD CONSTRAINT "smart_search_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES assets(id) ON DELETE CASCADE;
SELECT COUNT(*) FROM smart_search WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");
DELETE FROM smart_search WHERE NOT EXISTS (SELECT 1 FROM assets WHERE id = "assetId");IndexCreate a missing index: CREATE INDEX idx_originalfilename_trigram ON assets USING gin (public.f_unaccent(("originalFileName")::text) gin_trgm_ops);Update to 136Please post Immich update logs and DB schema once more if update to v1.136.0 fails again. |
Beta Was this translation helpful? Give feedback.
Answer selected by
chamdim
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I ll post my full fault finding and procedure if this help anyone else. Thanks to @skatsubo i only saw the error and the missing constraint.
the log error:
[Nest] 7 - 07/26/2025, 4:56:26 PM ERROR [Microservices:DatabaseRepository] Kysely migrations failed: PostgresError: constraint "FK_420bec36fc02813bddf5c8b73d4" for table "asset_job_status" does not existthen i gave:
docker exec immich_server sh -c 'DB_URL=postgres://user:password@immich_postgres:5432/user npm run migrations:generate | sed -En "s/Wrote (.*)/\1/p" | xargs sed -n "/function up/,/^}/ s/.*await sql.\(.*\).\.execute.*/\1/p"and the output:
ALTER TABLE "asset_job_status" ADD CONSTRAINT "FK_420bec36fc02813bddf5c8b73d4" FOREIG…