[25851] users/jberry/mpwa/doc/schema.sql
source_changes at macosforge.org
source_changes at macosforge.org
Sun Jun 3 11:07:56 PDT 2007
Revision: 25851
http://trac.macosforge.org/projects/macports/changeset/25851
Author: jberry at macports.org
Date: 2007-06-03 11:07:56 -0700 (Sun, 03 Jun 2007)
Log Message:
-----------
mpwa: add some additional indexes
Modified Paths:
--------------
users/jberry/mpwa/doc/schema.sql
Modified: users/jberry/mpwa/doc/schema.sql
===================================================================
--- users/jberry/mpwa/doc/schema.sql 2007-06-03 18:01:44 UTC (rev 25850)
+++ users/jberry/mpwa/doc/schema.sql 2007-06-03 18:07:56 UTC (rev 25851)
@@ -38,7 +38,10 @@
drop table if exists maintainers_ports;
create table maintainers_ports (
person_id bigint not null,
- port_id bigint not null
+ port_id bigint not null,
+
+ index port_index(port_id),
+ index person_index(person_id)
);
@@ -132,17 +135,20 @@
port_pkg_id bigint not null,
tag_id bigint not null,
- primary key (port_pkg_id, tag_id)
+ primary key (port_pkg_id, tag_id),
+ index tag_index(tag_id)
);
+
-- many-many relationship between Port and Tag
drop table if exists ports_tags;
create table ports_tags (
port_id bigint not null,
tag_id bigint not null,
- primary key (port_id, tag_id)
+ primary key (port_id, tag_id),
+ index tag_index(tag_id)
);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macosforge.org/pipermail/macports-changes/attachments/20070603/fe6a3476/attachment.html
More information about the macports-changes
mailing list