-- Datetime format : https://www.sqlite.org/lang_datefunc.html
-- %Y-%m-%d %H:%M:%S
-- https://www.tutorialspoint.com/sqlite/sqlite_data_types.htm

insert into tablechild( propstr) values("child lib 1");
insert into tablechild( propstr) values("child lib 2");
insert into tablechild( propstr) values("child lib 3");

insert into tablemaster( propstr, propint, propdate, propstrnotnull, tablechild_id) values( "master lib 1" , 1, "01/01/1971", "lib not null 1", 1 );
insert into tablemaster( propstr, propint, propdate, propstrnotnull, tablechild_id) values( "master lib 2" , 1, "02/02/1972", "lib not null 2", 2 );