diff options
| -rw-r--r-- | sqlite.init.sql | 13 |
1 files 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; |