X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_watch.sql;h=97982eda6c4bb148ba789d9fc41945114bd46486;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=db1fac8216e1427c1332da2081e802a8fca948b7;hpb=c7a3e29bde0e9721a91b77d4a55e668f8ec78b92;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