add indexes, validate unique urls to block reposts