littleskunk

littleskunk / metainfoschema.sql

Created January 20, 2020 16:05 — forked from JessicaGreben/metainfoschema.sql

	CREATE TABLE buckets (
	bucketname BYTES PRIMARY KEY,
	delim INT8 NOT NULL
	);
	CREATE TABLE pathdata (
	bucket BYTEA,
	fullpath BYTEA PRIMARY KEY,
	metadata BYTEA NOT NULL
	);

littleskunk / schema.sql

Last active January 20, 2020 13:55 — forked from JessicaGreben/schema.sql

Schema for satellite.DB up to version 73, ref: https://github.com/storj/storj/blob/master/satellite/satellitedb/migrate.go#L93

	CREATE TABLE accounting_rollups (
	id bigserial NOT NULL,
	node_id bytea NOT NULL,
	start_time timestamp with time zone NOT NULL,
	put_total bigint NOT NULL,
	get_total bigint NOT NULL,
	get_audit_total bigint NOT NULL,
	get_repair_total bigint NOT NULL,
	put_repair_total bigint NOT NULL,
	at_rest_total double precision NOT NULL,