[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