/* Disable foreign keys */
PRAGMA foreign_keys = 'off';

/* Begin transaction */
BEGIN;

/* Database properties */
PRAGMA auto_vacuum = 0;
PRAGMA encoding = 'UTF-8';
PRAGMA page_size = 4096;

/* Drop table [obj] */
DROP TABLE IF EXISTS [main].[obj];

/* Table structure [obj] */
CREATE TABLE [main].[obj](
  [id] INTEGER PRIMARY KEY AUTOINCREMENT, 
  [name] TEXT);

/* Drop table [measurement] */
DROP TABLE IF EXISTS [main].[measurement];

/* Table structure [measurement] */
CREATE TABLE [main].[measurement](
  [id_obj] INTEGER REFERENCES [obj]([id]), 
  [date] DATE);

/* Table data [obj] Record count: 3 */
INSERT INTO [obj]([rowid], [id], [name]) VALUES(1, 1, 'a');
INSERT INTO [obj]([rowid], [id], [name]) VALUES(2, 2, 'b');
INSERT INTO [obj]([rowid], [id], [name]) VALUES(3, 3, 'c');

/* Table data [measurement] Record count: 9 */
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(1, 1, '2019-04-01');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(2, 2, '2019-04-01');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(3, 3, '2019-04-01');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(4, 1, '2019-04-05');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(5, 1, '2019-04-03');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(6, 2, '2019-04-07');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(7, 2, '2019-04-02');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(8, 3, '2019-04-10');
INSERT INTO [measurement]([rowid], [id_obj], [date]) VALUES(9, 3, '2019-04-04');

/* Commit transaction */
COMMIT;

/* Enable foreign keys */
PRAGMA foreign_keys = 'on';