[cvs] scripts/pdb schema.sql, 1.8.2.7, 1.8.2.8 releases.sql, 1.26.2.3, 1.26.2.4

[Christian S. <ch...@us...>]

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);