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

[source_changes at macosforge.org]

Revision: 25103
          http://trac.macosforge.org/projects/macports/changeset/25103
Author:   jberry at macports.org
Date:     2007-05-13 18:28:18 -0700 (Sun, 13 May 2007)

Log Message:
-----------
mpwa: add a few key indexes

Modified Paths:
--------------
    users/jberry/mpwa/doc/schema.sql

Modified: users/jberry/mpwa/doc/schema.sql
===================================================================
--- users/jberry/mpwa/doc/schema.sql	2007-05-14 00:52:51 UTC (rev 25102)
+++ users/jberry/mpwa/doc/schema.sql	2007-05-14 01:28:18 UTC (rev 25103)
@@ -56,7 +56,11 @@
     
     -- (note that both pkgs and variants, have dependency relations)
 );
+create index pkg_submit_date on Port_Pkgs(submitted_at);
+create index pkg_submitter on Port_Pkgs(submitter_id);
+create index pkg_port_id on Port_Pkgs(port_id);
 
+
 drop table if exists Port_Pkg_Files;
 create table Port_Pkg_Files (
     id                  bigint not null primary key auto_increment,
@@ -67,7 +71,9 @@
     md5                 varchar(32),
     sha256              varchar(64)
 );
+create index portpkgfile_pkgid on Port_Pkg_Files(port_pkg_id);
 
+
 drop table if exists File_Blobs;
 create table File_Blobs (
     id                  bigint not null primary key auto_increment,
@@ -75,7 +81,9 @@
     sequence            int not null,
     data                blob
 );
+create index fileblog_index on File_Blobs(port_pkg_file_id, sequence);
 
+
 -- A tag which may be attached to various items through Ports_Tags, Port_Pkgs_Tags
 drop table if exists Tags;
 create table Tags (

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macosforge.org/pipermail/macports-changes/attachments/20070513/bf94eada/attachment.html