All pastes #2099703 Raw Edit

Unnamed

public sql v1 · immutable
#2099703 ·published 2012-01-05 18:46 UTC
rendered paste body
CREATE TRIGGER insert_integer INSTEAD OF INSERT ON fields                      WHEN NEW.type='INTEGER'                                                BEGIN                                                                          INSERT INTO integers(value) VALUES(NEW.value);                             INSERT INTO fields(object, type, name, value) VALUES(                          NEW.object,                                                                NEW.type,                                                                  NEW.name,                                                                  last_insert_rowid()                                                    );                                                                     END;