5 id TEXT NOT NULL PRIMARY KEY,
6 url
TEXT NOT NULL UNIQUE,
7 created
TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now(),
8 last_access
TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT '-infinity'::timestamptz,
9 accesses
INTEGER NOT NULL DEFAULT 0,
10 expires
TIMESTAMP WITH TIME ZONE,
14 -- send notices to invalidate cacheable link data
15 CREATE OR REPLACE FUNCTION cache_invalidation_link()
22 IF NEW.url
!= OLD.url
OR NEW.expires
!= OLD.expires
24 payload
= 'link|' ||
CAST(NEW.
id AS text);
25 PERFORM
pg_notify('cache_invalidation', payload
);
31 CREATE TRIGGER cache_invalidation_link
35 EXECUTE PROCEDURE cache_invalidation();
39 id TEXT NOT NULL PRIMARY KEY,
45 INSERT INTO _meta_schema_version (major
, minor
, patch
) VALUES (1, 0, 0);