ALTER TABLE tablename ADD UNIQUE INDEX indexname (column1, column2, ...);
ALTER TABLE pure ADD UNIQUE INDEX unique_full_path full_path;
ALTER TABLE tablename DROP INDEX indexname;
ALTER TABLE pure DROP INDEX unique_full_path;