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


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