mirror of
https://github.com/catdevnull/preciazo.git
synced 2024-11-26 03:26:19 +00:00
6 lines
351 B
MySQL
6 lines
351 B
MySQL
|
-- 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;
|