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



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


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



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



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


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


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

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


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