waveterm/wavesrv/db/migrations/000002_activity.up.sql

CREATE TABLE activity (
    day varchar(20) PRIMARY KEY,
    uploaded boolean NOT NULL,
    tdata json NOT NULL,
    tzname varchar(50) NOT NULL,
    tzoffset int NOT NULL,
    clientversion varchar(20) NOT NULL,
    clientarch varchar(20) NOT NULL
);

ALTER TABLE client ADD COLUMN clientopts json NOT NULL DEFAULT '';