Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| SHA1 Hash: | 851c7d53b753d8e92380867539b10de2017dbe00 |
|---|---|
| Date: | 2012-08-22 22:50:55 |
| User: | drh |
| Comment: | Improved names for triggers in the FTS documentation. |
Tags And Properties
- branch=trunk inherited from [b2e03e19ab]
- sym-trunk inherited from [b2e03e19ab]
Changes
Changes to pages/fts3.in
1619 CREATE TRIGGER t2_bu BEFORE UPDATE ON t2 BEGIN 1619 CREATE TRIGGER t2_bu BEFORE UPDATE ON t2 BEGIN 1620 DELETE FROM t3 WHERE docid=old.rowid; 1620 DELETE FROM t3 WHERE docid=old.rowid; 1621 END; 1621 END; 1622 CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN 1622 CREATE TRIGGER t2_bd BEFORE DELETE ON t2 BEGIN 1623 DELETE FROM t3 WHERE docid=old.rowid; 1623 DELETE FROM t3 WHERE docid=old.rowid; 1624 END; 1624 END; 1625 1625 1626 CREATE TRIGGER t2_bu AFTER UPDATE ON t2 BEGIN | 1626 CREATE TRIGGER t2_au AFTER UPDATE ON t2 BEGIN 1627 INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); 1627 INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); 1628 END; 1628 END; 1629 CREATE TRIGGER t2_bd AFTER INSERT ON t2 BEGIN | 1629 CREATE TRIGGER t2_ai AFTER INSERT ON t2 BEGIN 1630 INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); 1630 INSERT INTO t3(docid, b, c) VALUES(new.rowid, new.b, new.c); 1631 END; 1631 END; 1632 </codeblock> 1632 </codeblock> 1633 1633 1634 <p> 1634 <p> 1635 The DELETE trigger must be fired before the actual delete takes place 1635 The DELETE trigger must be fired before the actual delete takes place 1636 on the content table. This is so that FTS4 can still retrieve the original 1636 on the content table. This is so that FTS4 can still retrieve the original