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@opensuse.org For additional commands, e-mail: zypp-commit+help@opensuse.org