X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_watch.sql;h=97982eda6c4bb148ba789d9fc41945114bd46486;hb=e148094ffe431aad50d4ba863bc01f5ad4c3ba93;hp=db1fac8216e1427c1332da2081e802a8fca948b7;hpb=ef8fcfeb4731927a6f63cdbe6f8c3f3b61f52f0c;p=Pman.Core diff --git a/sql/core_watch.sql b/sql/core_watch.sql index db1fac82..97982eda 100644 --- a/sql/core_watch.sql +++ b/sql/core_watch.sql @@ -16,4 +16,6 @@ alter table core_watch ADD COLUMN active int(11) NOT NULL DEFAULT '1'; ALTER TABLE core_watch ADD INDEX qlookup (ontable,onid,person_id,event,medium); +ALTER TABLE core_watch ADD INDEX lookup_person_id (person_id); + \ No newline at end of file