Artifact 900d02e32d138f444b797b293120b10ecdafb232:

• File sql/forum.sql — part of check-in [490dadcad9] at 2021-02-08 07:44:03 on branch trunk — Brought core SQL schemas up to date wrt fossil(1). (user: stephan size: 385)

CREATE TABLE repo.forumpost(
  fpid INTEGER PRIMARY KEY,  -- BLOB.rid for the artifact
  froot INT,                 -- fpid of the thread root
  fprev INT,                 -- Previous version of this same post
  firt INT,                  -- This post is in-reply-to
  fmtime REAL                -- When posted.  Julian day
);
CREATE INDEX repo.forumthread ON forumpost(froot,fmtime);