transcribe_wavs/ddl.pg.sql

CREATE TABLE IF NOT EXISTS 
rlarp.thirtysec (
    filename    text
    ,mdate      date
    ,message    jsonb
);

ALTER TABLE rlarp.thirtysec ADD PRIMARY KEY (filename);

GRANT ALL ON TABLE rlarp.thirtysec TO report;