CREATE TRIGGER insert_videostream  AFTER insert ON Videostream 
begin

update media set datecreated = now
where id = new.id;

end;

CREATE TRIGGER insert_videostream  AFTER update ON Videostream 
begin

update media set datecreated = now
where id = new.id;

end;