[25851] users/jberry/mpwa/doc/schema.sql

[source_changes at macosforge.org]

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