littleskunk

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

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,