[23730] users/jberry/mpwa/doc/schema-thoughts.sql

[source_changes at macosforge.org]

Revision: 23730
          http://trac.macosforge.org/projects/macports/changeset/23730
Author:   jberry at macports.org
Date:     2007-04-07 16:51:43 -0700 (Sat, 07 Apr 2007)

Log Message:
-----------
Clarify relationship between dependencies and portpkgs, variants

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

Modified: users/jberry/mpwa/doc/schema-thoughts.sql
===================================================================
--- users/jberry/mpwa/doc/schema-thoughts.sql	2007-04-07 23:43:09 UTC (rev 23729)
+++ users/jberry/mpwa/doc/schema-thoughts.sql	2007-04-07 23:51:43 UTC (rev 23730)
@@ -59,7 +59,7 @@
     -- (note that both pkgs and variants, have dependency relations)
 );
 
--- A tag which may be attached to various items through PkgTagAssoc, PortTagAssoc
+-- A tag which may be attached to various items through Ports_Tags, Port_Pkgs_Tags
 drop table if exists Tags;
 create table Tags (
     id              bigint not null primary key auto_increment,
@@ -91,7 +91,7 @@
     -- maybe we have nullable fields for port, portpkg, porturl, version, revision, etc...
 );
 
--- many-many relationship between PortPkg and Dependency
+-- many-one relationship from Dependency to PortPkg
 drop table if exists Dependencies_Port_Pkgs;
 create table Dependencies_Port_Pkgs (
     package_id      bigint not null,
@@ -112,7 +112,7 @@
     -- conflicts expr?
 );
 
--- many-many relationship between a Variant and Dependency
+-- many-one relationship from Variant to Dependency
 drop table if exists Dependencies_Variants;
 create table Dependencies_Variants (
     variant_id      bigint not null,

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