 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;

  id INTEGER PRIMARY KEY,
  user_id INTEGER NOT NULL,
  in_reply_to_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_in_reply_to_user_by_user_by_time
  ON tweet (in_reply_to_user_id, user_id, time_ms DESC)
  WHERE in_reply_to_user_id IS NOT NULL;
CREATE INDEX idx_tweet_retweeted_by_time
  ON tweet (retweeted_id, time_ms)
  WHERE retweeted_id IS NOT NULL;
