Advertisement
Guest User

Untitled

a guest
Nov 17th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. sqlite> .schema
  2. CREATE TABLE words(user TEXT, word TEXT, messageId INT);
  3. CREATE INDEX idx_words_word ON words (word);
  4. CREATE INDEX idx_words_user ON words (user);
  5. CREATE INDEX idx_words_worduser ON words(word,user);
  6. sqlite>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement