added foreign key and timestamp indices