appdb/tables appdb_tables.sql
WineHQ
wineowner at wine.codeweavers.com
Mon Jul 10 11:32:05 CDT 2006
ChangeSet ID: 26394
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner at winehq.org 2006/07/10 11:32:05
Modified files:
tables : appdb_tables.sql
Log message:
Chris Morgan <cmorgan at alum.wpi.edu>
appVersion table should have an index on appId field as we frequently query this table
using appId
Patch: http://cvs.winehq.org/patch.py?id=26394
Old revision New revision Changes Path
1.25 1.26 +2 -1 appdb/tables/appdb_tables.sql
Index: appdb/tables/appdb_tables.sql
diff -u -p appdb/tables/appdb_tables.sql:1.25 appdb/tables/appdb_tables.sql:1.26
--- appdb/tables/appdb_tables.sql:1.25 10 Jul 2006 16:32: 5 -0000
+++ appdb/tables/appdb_tables.sql 10 Jul 2006 16:32: 5 -0000
@@ -58,7 +58,8 @@ create table appVersion (
submitTime timestamp(14) NOT NULL,
submitterId int(11) NOT NULL default '0',
queued enum('true','false','rejected') NOT NULL default 'false',
- key(versionId)
+ key(versionId),
+ index(appId)
);
More information about the wine-cvs
mailing list