1 CREATE TABLE tweet_map (
2 id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
3 key_id BIGINT UNSIGNED UNIQUE NOT NULL,
4 tweet_id BIGINT UNSIGNED UNIQUE NOT NULL,
5 user_id BIGINT UNSIGNED NOT NULL,
6 screen_name VARCHAR(64) NOT NULL
7 ) ENGINE = innodb DEFAULT CHARSET utf8;
9 create index key_idx on tweet_map(key_id);
10 create index tweet_idx on tweet_map(tweet_id);