CREATE TRIGGER insert_videostream  AFTER update ON Videostream 
begin
update Videostream set datecreated= strftime('%Y-%m-%d %H:%M','now', 'localtime') where id = old.id;
end;

CREATE TRIGGER update_videostream  AFTER insert ON Videostream 
begin
update Videostream set datecreated= strftime('%Y-%m-%d %H:%M','now', 'localtime') where id = new.id;
end;