From: Alan Knowles Date: Sun, 13 Feb 2011 13:46:00 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a00263724842e18ce3ff836bb91d446077d92f84 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 7d668af7..b0191a06 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -251,8 +251,8 @@ CREATE TABLE core_locking ( `person_id` int(11) NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`int`), - INDEX `lookup`(`on_table`, `on_id`, `person_id`, `created`) ); +alter table core_locking ADD INDEX `lookup`(`on_table`, `on_id`, `person_id`, `created`)