Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs17:/tmp/cvs-serv24906/scripts/pdb
Modified Files:
Tag: redesign_pdb
schema.sql releases.sql
Log Message:
Don't show 10.5 by default (set in the distribution table of the db)
Add a hidden flag 'showall' that shows 10.5 packages as well if 'showall'
is set to 'on'
Index: schema.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/schema.sql,v
retrieving revision 1.8.2.7
retrieving revision 1.8.2.8
diff -u -d -r1.8.2.7 -r1.8.2.8
--- schema.sql 17 Feb 2007 19:07:28 -0000 1.8.2.7
+++ schema.sql 31 Aug 2007 19:39:56 -0000 1.8.2.8
@@ -34,6 +34,7 @@
architecture enum('powerpc', 'i386') not null default 'powerpc',
priority tinyint unsigned not null default '1',
active boolean default 1,
+ visible boolean default 1,
primary key (dist_id)
) collate ascii_general_ci;
Index: releases.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/releases.sql,v
retrieving revision 1.26.2.3
retrieving revision 1.26.2.4
diff -u -d -r1.26.2.3 -r1.26.2.4
--- releases.sql 21 Feb 2007 19:15:34 -0000 1.26.2.3
+++ releases.sql 31 Aug 2007 19:39:56 -0000 1.26.2.4
@@ -1,41 +1,41 @@
delete from distribution;
delete from distribution_releases;
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.1', '10.1', 'powerpc', 1, 0);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.1', '10.1', 'powerpc', 1, 0, 0);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.4.1', 1, 0);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.2-gcc3.3', '10.2\n(gcc3.3 only)',
'powerpc', 2, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.2-gcc3.3', '10.2\n(gcc3.3 only)',
'powerpc', 2, 1, 1);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.6.4', 1, 1);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.3', '10.3', 'powerpc', 3, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.3', '10.3', 'powerpc', 3, 1, 1);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.7.2', 1, 1);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.4', '10.4/powerpc', 'powerpc', 4, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.4', '10.4/powerpc', 'powerpc', 4,
1, 1);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.8.1', 1, 1);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.4', '10.4/intel', 'i386', 5, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.4', '10.4/intel', 'i386', 5, 1, 1);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.8.1', 1, 1);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.5', '10.5/powerpc', 'powerpc', 6, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.5', '10.5/powerpc', 'powerpc', 6,
1, 0);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'bindist', '0.9.0', 1, 1);
-insert into distribution (dist_id, identifier, description, architecture,
priority, active) values (null, '10.5', '10.5/intel', 'i386', 7, 1);
+insert into distribution (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.5', '10.5/intel', 'i386', 7, 1, 0);
select @last_dist_id := last_insert_id();
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into distribution_releases (rel_id, dist_id, type, version, priority,
active) values (null, @last_dist_id, 'stable', 'current', 2, 1);
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
