[25103] users/jberry/mpwa/doc/schema.sql
source_changes at macosforge.org
source_changes at macosforge.org
Sun May 13 18:28:19 PDT 2007
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
More information about the macports-changes
mailing list