CREATE TABLE activities (
    id          TEXT  PRIMARY KEY,
    actor       TEXT  NOT NULL,
    object      TEXT  NOT NULL,
    audienceTo  BLOB  NOT NULL,
    audienceCc  BLOB  NOT NULL,
    type        TEXT  NOT NULL,
    time        INTEGER,
    FOREIGN KEY (actor) REFERENCES actors (id)
);

CREATE TABLE follows (
    follower    TEXT  NOT NULL,
    followee    TEXT  NOT NULL,
    acceptTime  INTEGER,
    rejectTime  INTEGER,
    PRIMARY KEY (follower, followee),
    FOREIGN KEY (follower) REFERENCES actors (id),
    FOREIGN KEY (followee) REFERENCES actors (id)
);