init.sql

CREATE TABLE follow (
  follow_from INT(11) NOT NULL,
  follow_to   INT(11) NOT NULL,
);

CREATE INDEX follow_from_to_idx ON follow (follow_from, follow_to);

CREATE TABLE tweet (
  id      INT(11)  NOT NULL AUTO_INCREMENT,
  user_id INT(11)  NOT NULL,
  tweet   CHAR(30) NOT NULL DEFAULT '',
  PRIMARY KEY (id)
);

CREATE INDEX user_id_idx ON tweet (user_id);