Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TRIGGER update_appInfo_updatetime BEFORE update ON appInfo
begin
update appinfo set updatedatetime = strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime') where bundle_id = old.bundle_id;
end
CREATE TABLE "appInfo" (bundle_id INTEGER PRIMARY KEY,title text, updatedatetime text DEFAULT (strftime('%Y-%m-%d %H:%M:%S:%s','now', 'localtime')))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment