gistfile1.txt

      CREATE TABLE "content" (
        "sha1" blob(20) PRIMARY KEY NOT NULL,
        "title" text,
        "description" text,
        "type" varchar(20),
        "user_id" integer
      );

      CREATE TABLE "users" (
        "id" blob(16) PRIMARY KEY NOT NULL,
        "username" varchar(20) UNIQUE
      );