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/58.sql
CREATE TABLE IF NOT EXISTS public.udc_statistic (
  id_user integer NOT NULL,
  key text NOT NULL,
  value text NOT NULL,
  PRIMARY KEY (key, id_user)
);
CREATE TABLE IF NOT EXISTS public.udc_event (
  id_user integer NOT NULL,
  timestamp bigint NOT NULL,
  type text NOT NULL,
  payload text
);
CREATE INDEX id_user_type_timestamp_idx ON public.udc_event (id_user, type, timestamp);