-- Name: IDX_asset_exif_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_asset_exif_update_id" ON public.exif USING btree ("updateId"); -- -- Name: IDX_asset_faces_assetId_personId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_asset_faces_assetId_personId" ON public.asset_faces USING btree ("assetId", "personId"); -- -- Name: IDX_asset_files_assetId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_asset_files_assetId" ON public.asset_files USING btree ("assetId"); -- -- Name: IDX_asset_files_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_asset_files_update_id" ON public.asset_files USING btree ("updateId"); -- -- Name: IDX_asset_id_stackId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_asset_id_stackId" ON public.assets USING btree (id, "stackId"); -- -- Name: IDX_assets_audit_asset_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_assets_audit_asset_id" ON public.assets_audit USING btree ("assetId"); -- -- Name: IDX_assets_audit_deleted_at; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_assets_audit_deleted_at" ON public.assets_audit USING btree ("deletedAt"); -- -- Name: IDX_assets_audit_owner_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_assets_audit_owner_id" ON public.assets_audit USING btree ("ownerId"); -- -- Name: IDX_assets_duplicateId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_assets_duplicateId" ON public.assets USING btree ("duplicateId"); -- -- Name: IDX_assets_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_assets_update_id" ON public.assets USING btree ("updateId"); -- -- Name: IDX_auto_stack_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_auto_stack_id" ON public.exif USING btree ("autoStackId"); -- -- Name: IDX_b1a2a7ed45c29179b5ad51548a; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_b1a2a7ed45c29179b5ad51548a" ON public.tags_closure USING btree (id_descendant); -- -- Name: IDX_b22c53f35ef20c28c21637c85f; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_b22c53f35ef20c28c21637c85f" ON public.albums USING btree ("ownerId"); -- -- Name: IDX_bf339a24070dac7e71304ec530; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_bf339a24070dac7e71304ec530" ON public.asset_faces USING btree ("personId", "assetId"); -- -- Name: IDX_c05079e542fd74de3b5ecb5c1c; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_c05079e542fd74de3b5ecb5c1c" ON public.asset_stack USING btree ("ownerId"); -- -- Name: IDX_c9fab4aa97ffd1b034f3d6581a; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_c9fab4aa97ffd1b034f3d6581a" ON public.shared_link__asset USING btree ("sharedLinksId"); -- -- Name: IDX_d7e875c6c60e661723dbf372fd; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_d7e875c6c60e661723dbf372fd" ON public.partners USING btree ("sharedWithId"); -- -- Name: IDX_d8ddd9d687816cc490432b3d4b; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_d8ddd9d687816cc490432b3d4b" ON public.session_sync_checkpoints USING btree ("sessionId"); -- -- Name: IDX_e590fa396c6898fcd4a50e4092; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_e590fa396c6898fcd4a50e4092" ON public.albums_assets_assets USING btree ("albumsId"); -- -- Name: IDX_e99f31ea4cdf3a2c35c7287eb4; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_e99f31ea4cdf3a2c35c7287eb4" ON public.tag_asset USING btree ("tagsId"); -- -- Name: IDX_f15d48fa3ea5e4bda05ca8ab20; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_f15d48fa3ea5e4bda05ca8ab20" ON public.assets USING btree ("stackId"); -- -- Name: IDX_f48513bf9bccefd6ff3ad30bd0; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_f48513bf9bccefd6ff3ad30bd0" ON public.albums_shared_users_users USING btree ("usersId"); -- -- Name: IDX_f8e8a9e893cb5c54907f1b798e; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_f8e8a9e893cb5c54907f1b798e" ON public.tag_asset USING btree ("assetsId"); -- -- Name: IDX_libraries_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_libraries_update_id" ON public.libraries USING btree ("updateId"); -- -- Name: IDX_live_photo_cid; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_live_photo_cid" ON public.exif USING btree ("livePhotoCID"); -- -- Name: IDX_memories_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_memories_update_id" ON public.memories USING btree ("updateId"); -- -- Name: IDX_notifications_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_notifications_update_id" ON public.notifications USING btree ("updateId"); -- -- Name: IDX_originalPath_libraryId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_originalPath_libraryId" ON public.assets USING btree ("originalPath", "libraryId"); -- -- Name: IDX_ownerId_createdAt; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_ownerId_createdAt" ON public.audit USING btree ("ownerId", "createdAt"); -- -- Name: IDX_partners_audit_deleted_at; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_partners_audit_deleted_at" ON public.partners_audit USING btree ("deletedAt"); -- -- Name: IDX_partners_audit_shared_by_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_partners_audit_shared_by_id" ON public.partners_audit USING btree ("sharedById"); -- -- Name: IDX_partners_audit_shared_with_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_partners_audit_shared_with_id" ON public.partners_audit USING btree ("sharedWithId"); -- -- Name: IDX_partners_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_partners_update_id" ON public.partners USING btree ("updateId"); -- -- Name: IDX_person_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_person_update_id" ON public.person USING btree ("updateId"); -- -- Name: IDX_session_sync_checkpoints_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_session_sync_checkpoints_update_id" ON public.session_sync_checkpoints USING btree ("updateId"); -- -- Name: IDX_sessions_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_sessions_update_id" ON public.sessions USING btree ("updateId"); -- -- Name: IDX_sharedlink_albumId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_sharedlink_albumId" ON public.shared_links USING btree ("albumId"); -- -- Name: IDX_sharedlink_key; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_sharedlink_key" ON public.shared_links USING btree (key); -- -- Name: IDX_tag_asset_assetsId_tagsId; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_tag_asset_assetsId_tagsId" ON public.tag_asset USING btree ("assetsId", "tagsId"); -- -- Name: IDX_tags_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_tags_update_id" ON public.tags USING btree ("updateId"); -- -- Name: IDX_users_audit_deleted_at; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_users_audit_deleted_at" ON public.users_audit USING btree ("deletedAt"); -- -- Name: IDX_users_update_id; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_users_update_id" ON public.users USING btree ("updateId"); -- -- Name: IDX_users_updated_at_asc_id_asc; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX "IDX_users_updated_at_asc_id_asc" ON public.users USING btree ("updatedAt", id); -- -- Name: UQ_assets_owner_checksum; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX "UQ_assets_owner_checksum" ON public.assets USING btree ("ownerId", checksum) WHERE ("libraryId" IS NULL); -- -- Name: UQ_assets_owner_library_checksum; Type: INDEX; Schema: public; Owner: postgres -- CREATE UNIQUE INDEX "UQ_assets_owner_library_checksum" ON public.assets USING btree ("ownerId", "libraryId", checksum) WHERE ("libraryId" IS NOT NULL); -- -- Name: clip_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX clip_index ON public.smart_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options=' residual_quantization = false [build.internal] lists = [1] spherical_centroids = true build_threads = 4 sampling_factor = 1024  '); -- -- Name: exif_city; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX exif_city ON public.exif USING btree (city); -- -- Name: face_index; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX face_index ON public.face_search USING vchordrq (embedding public.vector_cosine_ops) WITH (options=' residual_quantization = false [build.internal] lists = [1] spherical_centroids = true build_threads = 4 sampling_factor = 1024  '); -- -- Name: idx_asset_file_created_at; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_asset_file_created_at ON public.assets USING btree ("fileCreatedAt"); -- -- Name: idx_geodata_gist_earthcoord; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_geodata_gist_earthcoord ON public.geodata_places USING gist (public.ll_to_earth_public(latitude, longitude)) WITH (fillfactor='100'); -- -- Name: idx_geodata_places_admin1_name; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_geodata_places_admin1_name ON public.geodata_places USING gin (public.f_unaccent(("admin1Name")::text) public.gin_trgm_ops); -- -- Name: idx_geodata_places_admin2_name; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_geodata_places_admin2_name ON public.geodata_places USING gin (public.f_unaccent(("admin2Name")::text) public.gin_trgm_ops); -- -- Name: idx_geodata_places_alternate_names; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_geodata_places_alternate_names ON public.geodata_places USING gin (public.f_unaccent(("alternateNames")::text) public.gin_trgm_ops); -- -- Name: idx_geodata_places_name; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_geodata_places_name ON public.geodata_places USING gin (public.f_unaccent((name)::text) public.gin_trgm_ops); -- -- Name: idx_local_date_time; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_local_date_time ON public.assets USING btree (((("localDateTime" AT TIME ZONE 'UTC'::text))::date)); -- -- Name: idx_local_date_time_month; Type: INDEX; Schema: public; Owner: postgres -- 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)); -- -- Name: idx_originalfilename_trigram; Type: INDEX; Schema: public; Owner: postgres -- CREATE INDEX idx_originalfilename_trigram ON public.assets USING gin (public.f_unaccent(("originalFileName")::text) public.gin_trgm_ops); -- -- Name: activity activity_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER activity_updated_at BEFORE UPDATE ON public.activity FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: albums_shared_users_users album_user_after_insert; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER album_user_after_insert AFTER INSERT ON public.albums_shared_users_users REFERENCING NEW TABLE AS inserted_rows FOR EACH STATEMENT EXECUTE FUNCTION public.album_user_after_insert(); -- -- Name: albums_shared_users_users album_users_delete_audit; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER album_users_delete_audit AFTER DELETE ON public.albums_shared_users_users REFERENCING OLD TABLE AS old FOR EACH STATEMENT WHEN ((pg_trigger_depth() <= 1)) EXECUTE FUNCTION public.album_users_delete_audit(); -- -- Name: albums_shared_users_users album_users_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER album_users_updated_at BEFORE UPDATE ON public.albums_shared_users_users FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: albums albums_delete_audit; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER albums_delete_audit AFTER DELETE ON public.albums REFERENCING OLD TABLE AS old FOR EACH STATEMENT WHEN ((pg_trigger_depth() = 0)) EXECUTE FUNCTION public.albums_delete_audit(); -- -- Name: albums albums_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER albums_updated_at BEFORE UPDATE ON public.albums FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: api_keys api_keys_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER api_keys_updated_at BEFORE UPDATE ON public.api_keys FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: exif asset_exif_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER asset_exif_updated_at BEFORE UPDATE ON public.exif FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: asset_files asset_files_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER asset_files_updated_at BEFORE UPDATE ON public.asset_files FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: assets assets_delete_audit; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER assets_delete_audit AFTER DELETE ON public.assets REFERENCING OLD TABLE AS old FOR EACH STATEMENT WHEN ((pg_trigger_depth() = 0)) EXECUTE FUNCTION public.assets_delete_audit(); -- -- Name: assets assets_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER assets_updated_at BEFORE UPDATE ON public.assets FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: libraries libraries_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER libraries_updated_at BEFORE UPDATE ON public.libraries FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: memories memories_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER memories_updated_at BEFORE UPDATE ON public.memories FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: notifications notifications_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER notifications_updated_at BEFORE UPDATE ON public.notifications FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: partners partners_delete_audit; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER partners_delete_audit AFTER DELETE ON public.partners REFERENCING OLD TABLE AS old FOR EACH STATEMENT WHEN ((pg_trigger_depth() = 0)) EXECUTE FUNCTION public.partners_delete_audit(); -- -- Name: partners partners_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER partners_updated_at BEFORE UPDATE ON public.partners FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: person person_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER person_updated_at BEFORE UPDATE ON public.person FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: session_sync_checkpoints session_sync_checkpoints_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER session_sync_checkpoints_updated_at BEFORE UPDATE ON public.session_sync_checkpoints FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: sessions sessions_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER sessions_updated_at BEFORE UPDATE ON public.sessions FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: tags tags_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER tags_updated_at BEFORE UPDATE ON public.tags FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: users users_delete_audit; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER users_delete_audit AFTER DELETE ON public.users REFERENCING OLD TABLE AS old FOR EACH STATEMENT WHEN ((pg_trigger_depth() = 0)) EXECUTE FUNCTION public.users_delete_audit(); -- -- Name: users users_updated_at; Type: TRIGGER; Schema: public; Owner: postgres -- CREATE TRIGGER users_updated_at BEFORE UPDATE ON public.users FOR EACH ROW EXECUTE FUNCTION public.updated_at(); -- -- Name: asset_faces FK_02a43fd0b3c50fb6d7f0cb7282c; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_faces ADD CONSTRAINT "FK_02a43fd0b3c50fb6d7f0cb7282c" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: albums FK_05895aa505a670300d4816debce; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums ADD CONSTRAINT "FK_05895aa505a670300d4816debce" FOREIGN KEY ("albumThumbnailAssetId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: shared_links FK_0c6ce9058c29f07cdf7014eac66; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.shared_links ADD CONSTRAINT "FK_0c6ce9058c29f07cdf7014eac66" FOREIGN KEY ("albumId") REFERENCES public.albums(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: libraries FK_0f6fc2fb195f24d19b0fb0d57c1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.libraries ADD CONSTRAINT "FK_0f6fc2fb195f24d19b0fb0d57c1" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: tags_closure FK_15fbcbc67663c6bfc07b354c22c; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tags_closure ADD CONSTRAINT "FK_15fbcbc67663c6bfc07b354c22c" FOREIGN KEY (id_ancestor) REFERENCES public.tags(id) ON DELETE CASCADE; -- -- Name: assets FK_16294b83fa8c0149719a1f631ef; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.assets ADD CONSTRAINT "FK_16294b83fa8c0149719a1f631ef" FOREIGN KEY ("livePhotoVideoId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: activity FK_1af8519996fbfb3684b58df280b; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.activity ADD CONSTRAINT "FK_1af8519996fbfb3684b58df280b" FOREIGN KEY ("albumId") REFERENCES public.albums(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: person FK_2bbabe31656b6778c6b87b61023; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.person ADD CONSTRAINT "FK_2bbabe31656b6778c6b87b61023" FOREIGN KEY ("faceAssetId") REFERENCES public.asset_faces(id) ON DELETE SET NULL; -- -- Name: assets FK_2c5ac0d6fb58b238fd2068de67d; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.assets ADD CONSTRAINT "FK_2c5ac0d6fb58b238fd2068de67d" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: activity FK_3571467bcbe021f66e2bdce96ea; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.activity ADD CONSTRAINT "FK_3571467bcbe021f66e2bdce96ea" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: asset_job_status FK_420bec36fc02813bddf5c8b73d4; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_job_status ADD CONSTRAINT "FK_420bec36fc02813bddf5c8b73d4" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: albums_shared_users_users FK_427c350ad49bd3935a50baab737; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums_shared_users_users ADD CONSTRAINT "FK_427c350ad49bd3935a50baab737" FOREIGN KEY ("albumsId") REFERENCES public.albums(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: albums_assets_assets FK_4bd1303d199f4e72ccdf998c621; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums_assets_assets ADD CONSTRAINT "FK_4bd1303d199f4e72ccdf998c621" FOREIGN KEY ("assetsId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: person FK_5527cc99f530a547093f9e577b6; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.person ADD CONSTRAINT "FK_5527cc99f530a547093f9e577b6" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: memories FK_575842846f0c28fa5da46c99b19; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.memories ADD CONSTRAINT "FK_575842846f0c28fa5da46c99b19" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: sessions FK_57de40bc620f456c7311aa3a1e6; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessions ADD CONSTRAINT "FK_57de40bc620f456c7311aa3a1e6" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: shared_link__asset FK_5b7decce6c8d3db9593d6111a66; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.shared_link__asset ADD CONSTRAINT "FK_5b7decce6c8d3db9593d6111a66" FOREIGN KEY ("assetsId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: shared_links FK_66fe3837414c5a9f1c33ca49340; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.shared_links ADD CONSTRAINT "FK_66fe3837414c5a9f1c33ca49340" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: notifications FK_692a909ee0fa9383e7859f9b406; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.notifications ADD CONSTRAINT "FK_692a909ee0fa9383e7859f9b406" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: memories_assets_assets FK_6942ecf52d75d4273de19d2c16f; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.memories_assets_assets ADD CONSTRAINT "FK_6942ecf52d75d4273de19d2c16f" FOREIGN KEY ("assetsId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: user_metadata FK_6afb43681a21cf7815932bc38ac; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.user_metadata ADD CONSTRAINT "FK_6afb43681a21cf7815932bc38ac" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: api_keys FK_6c2e267ae764a9413b863a29342; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.api_keys ADD CONSTRAINT "FK_6c2e267ae764a9413b863a29342" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partners FK_7e077a8b70b3530138610ff5e04; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partners ADD CONSTRAINT "FK_7e077a8b70b3530138610ff5e04" FOREIGN KEY ("sharedById") REFERENCES public.users(id) ON DELETE CASCADE; -- -- Name: activity FK_8091ea76b12338cb4428d33d782; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.activity ADD CONSTRAINT "FK_8091ea76b12338cb4428d33d782" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: asset_stack FK_91704e101438fd0653f582426dc; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_stack ADD CONSTRAINT "FK_91704e101438fd0653f582426dc" FOREIGN KEY ("primaryAssetId") REFERENCES public.assets(id); -- -- Name: tags FK_92e67dc508c705dd66c94615576; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tags ADD CONSTRAINT "FK_92e67dc508c705dd66c94615576" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: asset_faces FK_95ad7106dd7b484275443f580f9; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_faces ADD CONSTRAINT "FK_95ad7106dd7b484275443f580f9" FOREIGN KEY ("personId") REFERENCES public.person(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: memories_assets_assets FK_984e5c9ab1f04d34538cd32334e; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.memories_assets_assets ADD CONSTRAINT "FK_984e5c9ab1f04d34538cd32334e" FOREIGN KEY ("memoriesId") REFERENCES public.memories(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: assets FK_9977c3c1de01c3d848039a6b90c; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.assets ADD CONSTRAINT "FK_9977c3c1de01c3d848039a6b90c" FOREIGN KEY ("libraryId") REFERENCES public.libraries(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: tags FK_9f9590cc11561f1f48ff034ef99; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tags ADD CONSTRAINT "FK_9f9590cc11561f1f48ff034ef99" FOREIGN KEY ("parentId") REFERENCES public.tags(id) ON DELETE CASCADE; -- -- Name: sessions FK_afbbabbd7daf5b91de4dca84de8; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.sessions ADD CONSTRAINT "FK_afbbabbd7daf5b91de4dca84de8" FOREIGN KEY ("parentId") REFERENCES public.sessions(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: tags_closure FK_b1a2a7ed45c29179b5ad51548a1; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tags_closure ADD CONSTRAINT "FK_b1a2a7ed45c29179b5ad51548a1" FOREIGN KEY (id_descendant) REFERENCES public.tags(id) ON DELETE CASCADE; -- -- Name: albums FK_b22c53f35ef20c28c21637c85f4; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums ADD CONSTRAINT "FK_b22c53f35ef20c28c21637c85f4" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: exif FK_c0117fdbc50b917ef9067740c44; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.exif ADD CONSTRAINT "FK_c0117fdbc50b917ef9067740c44" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON DELETE CASCADE; -- -- Name: asset_stack FK_c05079e542fd74de3b5ecb5c1c8; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_stack ADD CONSTRAINT "FK_c05079e542fd74de3b5ecb5c1c8" FOREIGN KEY ("ownerId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: shared_link__asset FK_c9fab4aa97ffd1b034f3d6581ab; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.shared_link__asset ADD CONSTRAINT "FK_c9fab4aa97ffd1b034f3d6581ab" FOREIGN KEY ("sharedLinksId") REFERENCES public.shared_links(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: partners FK_d7e875c6c60e661723dbf372fd3; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.partners ADD CONSTRAINT "FK_d7e875c6c60e661723dbf372fd3" FOREIGN KEY ("sharedWithId") REFERENCES public.users(id) ON DELETE CASCADE; -- -- Name: session_sync_checkpoints FK_d8ddd9d687816cc490432b3d4bc; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.session_sync_checkpoints ADD CONSTRAINT "FK_d8ddd9d687816cc490432b3d4bc" FOREIGN KEY ("sessionId") REFERENCES public.sessions(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: asset_files FK_e3e103a5f1d8bc8402999286040; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.asset_files ADD CONSTRAINT "FK_e3e103a5f1d8bc8402999286040" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: albums_assets_assets FK_e590fa396c6898fcd4a50e40927; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums_assets_assets ADD CONSTRAINT "FK_e590fa396c6898fcd4a50e40927" FOREIGN KEY ("albumsId") REFERENCES public.albums(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: tag_asset FK_e99f31ea4cdf3a2c35c7287eb42; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tag_asset ADD CONSTRAINT "FK_e99f31ea4cdf3a2c35c7287eb42" FOREIGN KEY ("tagsId") REFERENCES public.tags(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: assets FK_f15d48fa3ea5e4bda05ca8ab207; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.assets ADD CONSTRAINT "FK_f15d48fa3ea5e4bda05ca8ab207" FOREIGN KEY ("stackId") REFERENCES public.asset_stack(id) ON UPDATE CASCADE ON DELETE SET NULL; -- -- Name: albums_shared_users_users FK_f48513bf9bccefd6ff3ad30bd06; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.albums_shared_users_users ADD CONSTRAINT "FK_f48513bf9bccefd6ff3ad30bd06" FOREIGN KEY ("usersId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: tag_asset FK_f8e8a9e893cb5c54907f1b798e9; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.tag_asset ADD CONSTRAINT "FK_f8e8a9e893cb5c54907f1b798e9" FOREIGN KEY ("assetsId") REFERENCES public.assets(id) ON UPDATE CASCADE ON DELETE CASCADE; -- -- Name: face_search face_search_faceId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.face_search ADD CONSTRAINT "face_search_faceId_fkey" FOREIGN KEY ("faceId") REFERENCES public.asset_faces(id) ON DELETE CASCADE; -- -- Name: smart_search smart_search_assetId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY public.smart_search ADD CONSTRAINT "smart_search_assetId_fkey" FOREIGN KEY ("assetId") REFERENCES public.assets(id) ON DELETE CASCADE; -- -- PostgreSQL database dump complete -- -- -- Database "postgres" dump -- -- -- PostgreSQL database dump -- -- Dumped from database version 14.17 (Debian 14.17-1.pgdg120+1) -- Dumped by pg_dump version 14.17 (Debian 14.17-1.pgdg120+1) SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; DROP DATABASE postgres; -- -- Name: postgres; Type: DATABASE; Schema: -; Owner: postgres -- CREATE DATABASE postgres WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8'; ALTER DATABASE postgres OWNER TO postgres; \connect postgres SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- Name: DATABASE postgres; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON DATABASE postgres IS 'default administrative connection database'; -- -- PostgreSQL database dump complete -- -- -- PostgreSQL database cluster dump complete --