name                     sql                                                         
-----------------------  ------------------------------------------------------------
idx_events_created_at    CREATE INDEX idx_events_created_at                          
                                     ON events(created_at)                           

idx_jobs_created_at      CREATE INDEX idx_jobs_created_at                            
                                     ON jobs(created_at)                             

idx_jobs_status          CREATE INDEX idx_jobs_status                                
                                     ON jobs(status)                                 

sqlite_autoindex_jobs_1                                                              

events                   CREATE TABLE events (                                       
                                         id INTEGER PRIMARY KEY AUTOINCREMENT,       
                                         level TEXT NOT NULL,                        
                                         event TEXT NOT NULL,                        
                                         detail_json TEXT,                           
                                         created_at TEXT NOT NULL                    
                                     )                                               

jobs                     CREATE TABLE jobs (                                         
                                         id TEXT PRIMARY KEY,                        
                                         capability TEXT NOT NULL,                   
                                         status TEXT NOT NULL,                       
                                         request_json TEXT NOT NULL,                 
                                         result_json TEXT,                           
                                         approval_required INTEGER NOT NULL DEFAULT 0
                         ,                                                           
                                         approved_at TEXT,                           
                                         created_at TEXT NOT NULL,                   
                                         updated_at TEXT NOT NULL                    
                                     )                                               

sqlite_sequence          CREATE TABLE sqlite_sequence(name,seq)