import kotlin.Int;
import kotlin.String;
import kotlin.collections.List;
import kotlin.Boolean;

CREATE TABLE IF NOT EXISTS CachedRemotePost(
  shortId TEXT NOT NULL PRIMARY KEY,
  title TEXT NOT NULL,
  url TEXT NOT NULL,
  createdAt TEXT NOT NULL,
  commentCount INTEGER AS Int,
  commentsUrl TEXT NOT NULL,
  submitterName TEXT NOT NULL,
  tags TEXT AS List<String> NOT NULL,
  description TEXT NOT NULL DEFAULT "",
  userIsAuthor INTEGER AS Boolean NOT NULL DEFAULT 0,
  insertionOrder INTEGER AS Int NOT NULL DEFAULT 0
);
