   id INTEGER PRIMARY KEY,
   user_id INTEGER NOT NULL,
   in_reply_to_id INTEGER,
+  in_reply_to_user_id INTEGER,
   retweeted_id INTEGER,
   quoted_id INTEGER,
   full_text TEXT,

CREATE INDEX idx_tweet_in_reply_to_by_time
  ON tweet (in_reply_to_id, time_ms)
  WHERE in_reply_to_id IS NOT NULL;
CREATE INDEX idx_tweet_retweeted_by_time
  ON tweet (retweeted_id, time_ms)
  WHERE retweeted_id IS NOT NULL;

DROP TABLE user;
DROP INDEX idx_tweet_quoted_by_time;
DROP INDEX idx_tweet_retweeted_by_time;
DROP INDEX idx_tweet_in_reply_to_user_by_user_by_time;
DROP INDEX idx_tweet_in_reply_to_by_time;
DROP INDEX idx_tweet_by_user_by_time;
DROP INDEX idx_tweet_by_time;
