mirror of
https://github.com/wavetermdev/backup.git
synced 2026-08-05 13:57:07 -07:00
21 lines
607 B
SQL
21 lines
607 B
SQL
CREATE TABLE schema_migrations (version uint64,dirty bool);
|
|||
|
|
CREATE UNIQUE INDEX version_unique ON schema_migrations (version);
|
||
|
|
CREATE TABLE block_file (
|
||
|
|
blockid varchar(36) NOT NULL,
|
||
|
|
name varchar(200) NOT NULL,
|
||
|
|
maxsize bigint NOT NULL,
|
||
|
|
circular boolean NOT NULL,
|
||
|
|
size bigint NOT NULL,
|
||
|
|
createdts bigint NOT NULL,
|
||
|
|
modts bigint NOT NULL,
|
||
|
|
meta json NOT NULL,
|
||
|
|
PRIMARY KEY (blockid, name)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE block_data (
|
||
|
|
blockid varchar(36) NOT NULL,
|
||
|
|
name varchar(200) NOT NULL,
|
||
|
|
partidx int NOT NULL,
|
||
|
|
data blob NOT NULL,
|
||
|
|
PRIMARY KEY(blockid, name, partidx)
|
||
|
|
);
|