Mailinglist Archive: zypp-commit (731 mails)

[dmacvicar@xxxxxxxxxxxxxxxx]

Author: dmacvicar
Date: Wed Aug  1 15:15:44 2007
New Revision: 6364

URL: http://svn.opensuse.org/viewcvs/zypp?rev=6364&view=rev
Log:
add index

Modified:
    trunk/libzypp/zypp/cache/schema/schema.sql

Modified: trunk/libzypp/zypp/cache/schema/schema.sql
URL: http://svn.opensuse.org/viewcvs/zypp/trunk/libzypp/zypp/cache/schema/schema.sql?rev=6364&r1=6363&r2=6364&view=diff
==============================================================================
--- trunk/libzypp/zypp/cache/schema/schema.sql (original)
+++ trunk/libzypp/zypp/cache/schema/schema.sql Wed Aug  1 15:15:44 2007
@@ -267,6 +267,8 @@
   , file_id INTEGER REFERENCES files (id)
   , PRIMARY KEY ( resolvable_id, file_id )
 );
+CREATE INDEX resolvable_files_resolvable_id ON resolvable_files(resolvable_id);
+CREATE INDEX resolvable_files_file_id ON resolvable_files(file_id);
 
 ------------------------------------------------
 -- Disk usage

--
To unsubscribe, e-mail: zypp-commit+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: zypp-commit+help@xxxxxxxxxxxx