1CREATE TABLE taggings (pid, tag, tagger, PRIMARY KEY(pid, tag, tagger));
2CREATE INDEX idx_pid ON taggings(pid);
3