From a1678e1193a888d7c42b9657d69acf444345e80a Mon Sep 17 00:00:00 2001 From: Adam Mathes Date: Sat, 16 Jun 2018 12:23:12 -0700 Subject: fix sqlite init --- sqlite.init.sql | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/sqlite.init.sql b/sqlite.init.sql index 411d152..8992483 100644 --- a/sqlite.init.sql +++ b/sqlite.init.sql @@ -35,13 +35,12 @@ INSERT INTO fts_item(fts_item) VALUES('rebuild'); CREATE TRIGGER item_bu BEFORE UPDATE ON item BEGIN DELETE FROM fts_item WHERE docid=old.rowid; END; -CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN - DELETE FROM t3 WHERE docid=old.rowid; +CREATE TRIGGER item_bd BEFORE DELETE ON item BEGIN + DELETE FROM fts_item WHERE docid=old.rowid; END; - -CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN - INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); +CREATE TRIGGER item_au AFTER UPDATE ON item BEGIN + INSERT INTO fts_item(docid, title, url, description) VALUES(new.rowid, new.title, new.url, new.description); END; -CREATE TRIGGER t2_ai AFTER INSERT ON t2 BEGIN - INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); +CREATE TRIGGER item_ai AFTER INSERT ON item BEGIN + INSERT INTO fts_item(docid, title, url, description) VALUES(new.rowid, new.title, new.url, new.description); END; -- cgit v1.2.3