CREATE TABLE posts (
  ID TEXT PRIMARY KEY,
  USERNAME TEXT NOT NULL,
  TIMESTAMP INT NOT NULL,
  FOREIGN KEY(username) references users(username)
);
CREATE TABLE pics (
  ID TEXT PRIMARY KEY,
  POST_ID TEXT NOT NULL,
  MIME_TYPE TEXT NOT NULL,
  PIC_B64 TEXT NOT NULL,
  FOREIGN KEY(POST_ID) references posts(id)
);
CREATE TABLE comments (
  ID TEXT PRIMARY KEY,
  POST_ID TEXT NOT NULL,
  BODY TEXT NOT NULL,
  FOREIGN KEY(POST_ID) references posts(id)
);
