preciazo/db-datos/drizzle/0007_bright_silvermane.sql
Cat /dev/Nulo a55b5b9104 separar migraciones a varios archivos
aparentemente las migraciones de drizzle-kit con bun no soportan varios statement
2023-12-29 19:57:48 -03:00

6 lines
351 B
SQL

-- Custom SQL migration file, put you code below! --
-- https://sqlite.org/fts5.html#external_content_and_contentless_tables
-- Triggers to keep the FTS index up to date.
CREATE TRIGGER precios_fts_ad AFTER DELETE ON precios BEGIN
INSERT INTO precios_fts(precios_fts, rowid, ean, url, name) VALUES('delete', old.id, old.ean, old.url, old.name);
END;