Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment