appdb/tables appdb_tables.sql

[WineHQ]

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)
 );