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

source_changes at macosforge.org source_changes at macosforge.org
Mon Apr 9 06:10:17 PDT 2007


Revision: 23771
          http://trac.macosforge.org/projects/macports/changeset/23771
Author:   jberry at macports.org
Date:     2007-04-09 06:10:17 -0700 (Mon, 09 Apr 2007)

Log Message:
-----------
Move blob data into its own table

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-09 07:53:16 UTC (rev 23770)
+++ users/jberry/mpwa/doc/schema-thoughts.sql	2007-04-09 13:10:17 UTC (rev 23771)
@@ -60,10 +60,17 @@
 create table Port_Pkg_Files (
     id              bigint not null primary key auto_increment,
     port_pkg_id     bigint not null,
-    name            varchar(255),
-    data            blob
+    name            varchar(1023),
+    mimetype        varchar(63)
 );
     
+drop table if exists File_Blobs
+create table File_Blobs (
+    id                  bigint not null primary key auto_increment,
+    port_pkg_file_id    bigint not null,
+    data                blob
+);
+    
 -- 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/20070409/1af08f04/attachment.html


More information about the macports-changes mailing list