CREATE TABLE IF NOT EXISTS [users] ( [id] INTEGER PRIMARY KEY, [name] TEXT, [tel] CHAR(15)); CREATE TRIGGER IF NOT EXISTS oldtel BEFORE UPDATE OF tel ON users begin INSERT INTO users_log SELECT * FROM users WHERE id=old.id; end; CREATE TABLE IF NOT EXISTS [users_log] ( [id] INTEGER, [name] TEXT, [tel] CHAR(15));