V4yL2EpW

1CREATE TABLE IF NOT EXISTS deps (
2    target TEXT NOT NULL,
3    user TEXT NOT NULL,
4    dependency TEXT NOT NULL);
5
6CREATE INDEX IF NOT EXISTS targetUser ON deps (target, user);
7	
8CREATE TRIGGER IF NOT EXISTS clearOldDeps BEFORE INSERT ON deps
9    BEGIN
10        DELETE FROM deps WHERE target = NEW.target AND user = NEW.user;
11    END
12	
13sqlite> INSERT INTO deps VALUES ("t1", "u2", "e1"), ("t1", "u2", "e2"),("t1", "u2", "e3");
14sqlite> select * from deps;
15t1|u2|e3