toys/simulation-py-ui/scripts/config.sql

create table GlobalConfig
(
    id integer primary key,
    version varchar(127) not null,
    config text not null,
    date_updated integer default (strftime('%s', 'now')) not null
);

create table Scenario
(
    id varchar(127) primary key,
    common text not null, -- InsFrequency, EnableLocalizer, Description
    map text not null, -- Gaussian settings and VTD/HD map settings
    error_injection text not null, -- ErrorModel
    sensor_error_injection text not null, -- SensorErrorModel
    channels text not null, -- ChannelNames
    verbose text not null, -- Verbose
    others text,
    date_updated integer default (strftime('%s', 'now')) not null
);

create table Template
(
    name varchar(127) not null,
    template text not null
);

-- For other modules, just hard code in the UI tool