Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs17:/tmp/cvs-serv27384/scripts/pdb
Modified Files:
Tag: redesign_pdb
releases.sql schema.sql
Log Message:
Possibility to mark distributions as unsupported in the db. They then will
be shown in gray in package.php
Index: schema.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/schema.sql,v
retrieving revision 1.8.2.9
retrieving revision 1.8.2.10
diff -u -d -r1.8.2.9 -r1.8.2.10
--- schema.sql 10 Sep 2007 18:02:20 -0000 1.8.2.9
+++ schema.sql 26 Sep 2007 16:52:50 -0000 1.8.2.10
@@ -12,6 +12,7 @@
priority tinyint unsigned not null default '1',
active boolean default 1,
visible boolean default 1,
+ supported boolean default 1,
primary key (dist_id)
) engine = innodb collate ascii_general_ci;
Index: releases.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/releases.sql,v
retrieving revision 1.26.2.5
retrieving revision 1.26.2.6
diff -u -d -r1.26.2.5 -r1.26.2.6
--- releases.sql 10 Sep 2007 18:02:20 -0000 1.26.2.5
+++ releases.sql 26 Sep 2007 16:52:50 -0000 1.26.2.6
@@ -1,41 +1,41 @@
delete from `distribution`;
delete from `release`;
-insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible) values (null, '10.1', '10.1', 'powerpc', 1, 0, 0);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.1', '10.1', 'powerpc',
1, 0, 0, 0);
select @last_dist_id := last_insert_id();
insert into `release` (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, visible) values (null, '10.2-gcc3.3', '10.2\n(gcc3.3 only)',
'powerpc', 2, 1, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.2-gcc3.3',
'10.2\n(gcc3.3 only)', 'powerpc', 2, 1, 1, 0);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into `release` (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, visible) values (null, '10.3', '10.3', 'powerpc', 3, 1, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.3', '10.3', 'powerpc',
3, 1, 1, 1);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into `release` (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, visible) values (null, '10.4', '10.4/powerpc', 'powerpc', 4,
1, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.4', '10.4/powerpc',
'powerpc', 4, 1, 1, 1);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into `release` (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, visible) values (null, '10.4', '10.4/intel', 'i386', 5, 1, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.4', '10.4/intel',
'i386', 5, 1, 1, 1);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into `release` (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, visible) values (null, '10.5', '10.5/powerpc', 'powerpc', 6,
1, 0);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.5', '10.5/powerpc',
'powerpc', 6, 1, 0, 1);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
insert into `release` (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, visible) values (null, '10.5', '10.5/intel', 'i386', 7, 1, 0);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.5', '10.5/intel',
'i386', 7, 1, 0, 1);
select @last_dist_id := last_insert_id();
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'unstable', 'current', 3, 1);
insert into `release` (rel_id, dist_id, type, version, priority, active)
values (null, @last_dist_id, 'stable', 'current', 2, 1);
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Fink-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/fink-commits
