Files

20 lines
446 B
SQL
Raw Permalink Normal View History

CREATE TABLE db_wave_file (
zoneid varchar(36) NOT NULL,
2024-05-12 09:52:12 -07:00
name varchar(200) NOT NULL,
size bigint NOT NULL,
createdts bigint NOT NULL,
modts bigint NOT NULL,
2024-05-13 00:02:32 -07:00
opts json NOT NULL,
2024-05-12 09:52:12 -07:00
meta json NOT NULL,
PRIMARY KEY (zoneid, name)
2024-05-12 09:52:12 -07:00
);
CREATE TABLE db_file_data (
zoneid varchar(36) NOT NULL,
2024-05-12 09:52:12 -07:00
name varchar(200) NOT NULL,
partidx int NOT NULL,
data blob NOT NULL,
PRIMARY KEY(zoneid, name, partidx)
2024-05-12 09:52:12 -07:00
);