Skip to content

Instantly share code, notes, and snippets.

@littleskunk
Forked from JessicaGreben/metainfoschema.sql
Created January 20, 2020 16:05
Show Gist options
  • Save littleskunk/b3ccea7577970084ef956e217257df32 to your computer and use it in GitHub Desktop.
Save littleskunk/b3ccea7577970084ef956e217257df32 to your computer and use it in GitHub Desktop.
CREATE TABLE buckets (
bucketname BYTES PRIMARY KEY,
delim INT8 NOT NULL
);
CREATE TABLE pathdata (
bucket BYTEA,
fullpath BYTEA PRIMARY KEY,
metadata BYTEA NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment