sql: create follower-following

gistfile1.txt

CREATE TABLE user (
    user_id INT Primary Key,
    userXXXXX
    updated datetime
) DEFAULT CHARSET=utf8;

CREATE TABLE follower (
    user_id INT, -- References user.
    follower_id INT,  -- References user.
    PRIMARY KEY (user_id, follower_id),
    UNIQUE INDEX (follower_id, user_id)
    updated datetime
) DEFAULT CHARSET=utf8;