tweet map table

diff --git a/tweet_map.sql b/tweet_map.sql
new file mode 100644 (file)
index 0000000..1065ece
--- /dev/null
+++ b/tweet_map.sql
@@ -0,0 +1,10 @@
+CREATE TABLE tweet_map (
+       id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
+       key_id BIGINT UNSIGNED UNIQUE NOT NULL,
+       tweet_id BIGINT UNSIGNED UNIQUE NOT NULL,
+       user_id BIGINT UNSIGNED NOT NULL,
+       screen_name VARCHAR(64) NOT NULL
+) ENGINE = innodb DEFAULT CHARSET utf8;
+
+create index key_idx on tweet_map(key_id);
+create index tweet_idx on tweet_map(tweet_id);