sql/mtrack_change.sql

diff --git a/sql/mtrack_change.sql b/sql/mtrack_change.sql
index e131bc8..2c78a73 100644 (file)
--- a/sql/mtrack_change.sql
+++ b/sql/mtrack_change.sql
@@ -13,3 +13,4 @@ CREATE TABLE mtrack_change (
 ALTER TABLE mtrack_change ADD COLUMN rev varchar(64) NOT NULL DEFAULT '';
 ALTER TABLE mtrack_change ADD COLUMN branch varchar(128) NOT NULL DEFAULT '';
 ALTER TABLE mtrack_change CHANGE COLUMN branch branch varchar(128) NOT NULL DEFAULT '';
+alter table mtrack_change add index lookupcd(changedate,onid, ontable);