HEX
Server: Apache/2.4.63 (Unix)
System: Linux Synopilou92 4.4.302+ #72806 SMP Mon Jul 21 23:16:00 CST 2025 x86_64
User: pilou92 (1026)
PHP: 8.0.30
Disabled: NONE
Upload Files
File: /volume1/@appstore/SynologyPhotos/etc/sql/23.sql
CREATE TABLE public.notification(
  id_user integer NOT NULL,
  event text NOT NULL,
  target_id integer NOT NULL,
  CONSTRAINT notification_primary PRIMARY KEY (id_user, event, target_id)
);
ALTER TABLE public.notification ADD CONSTRAINT id_user_fk FOREIGN KEY (id_user)
REFERENCES public.user_info (id) MATCH FULL
ON DELETE CASCADE ON UPDATE CASCADE;
CREATE INDEX notification_idx ON public.notification
  USING btree(event);