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

12 lines
320 B
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 '';