/
githubmirror
/
tldraw
Обзор
Документация
Войти
/
githubmirror
/
tldraw
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
apps/dotcom/zero-cache/migrations/005_update_file_trigger.sql
18 строк
560 B
Steve Ruiz
[botcom] Add pinned files (#5119)
16 дек 2024, 13:18
Не верифицирован
16 дек 2024, 13:18
f59352b
Код
Авторство
О чём код?
-- Purpose: Add a trigger to update the updatedAt column in the file table. CREATE OR REPLACE FUNCTION update_file_updated_at() RETURNS TRIGGER AS $$ BEGIN -- updatedAt is a unix timestamp in milliseconds NEW."updatedAt" := CAST(EXTRACT(EPOCH FROM now()) * 1000 AS BIGINT); RETURN NEW; END; $$ LANGUAGE plpgsql; -- When a file is inserted or updated, update the updatedAt column in the file table CREATE TRIGGER update_file_updatedAt BEFORE UPDATE ON "file" FOR EACH ROW WHEN (OLD.* IS DISTINCT FROM NEW.*) EXECUTE FUNCTION update_file_updated_at();