Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs17:/tmp/cvs-serv12101
Modified Files:
schema.sql
Log Message:
add some indexes
Index: schema.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/schema.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- schema.sql 27 Sep 2007 19:55:05 -0000 1.10
+++ schema.sql 28 Sep 2007 18:55:07 -0000 1.11
@@ -23,7 +23,10 @@
version varchar(16) not null,
priority tinyint unsigned not null default '1',
active boolean default 1,
- primary key (rel_id)
+ primary key (rel_id),
+ index (dist_id),
+ index (rel_id, dist_id),
+ index (priority),
) engine = innodb collate ascii_general_ci;
create table if not exists `package` (
@@ -47,4 +50,5 @@
index (name),
index (section),
index (rel_id)
+ index (name, rel_id),
) engine = innodb collate ascii_general_ci;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
