Update of /cvsroot/fink/scripts/pdb
In directory sc8-pr-cvs17:/tmp/cvs-serv2962/scripts/pdb
Modified Files:
Tag: redesign_pdb
releases.sql schema.sql
Log Message:
Change supported field in db to unsupported, to have the correct default
if field is unavailable
Index: schema.sql
===================================================================
RCS file: /cvsroot/fink/scripts/pdb/schema.sql,v
retrieving revision 1.8.2.10
retrieving revision 1.8.2.11
diff -u -d -r1.8.2.10 -r1.8.2.11
--- schema.sql 26 Sep 2007 16:52:50 -0000 1.8.2.10
+++ schema.sql 26 Sep 2007 17:12:44 -0000 1.8.2.11
@@ -12,7 +12,7 @@
priority tinyint unsigned not null default '1',
active boolean default 1,
visible boolean default 1,
- supported boolean default 1,
+ unsupported boolean default 0,
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.6
retrieving revision 1.26.2.7
diff -u -d -r1.26.2.6 -r1.26.2.7
--- releases.sql 26 Sep 2007 16:52:50 -0000 1.26.2.6
+++ releases.sql 26 Sep 2007 17:12:44 -0000 1.26.2.7
@@ -1,41 +1,41 @@
delete from `distribution`;
delete from `release`;
-insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.1', '10.1', 'powerpc',
1, 0, 0, 0);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.1', '10.1',
'powerpc', 1, 0, 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, 'bindist', '0.4.1', 1, 0);
-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);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.2-gcc3.3',
'10.2\n(gcc3.3 only)', 'powerpc', 2, 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.6.4', 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);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.3', '10.3',
'powerpc', 3, 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.7.2', 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);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.4', '10.4/powerpc',
'powerpc', 4, 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.8.1', 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);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.4', '10.4/intel',
'i386', 5, 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.8.1', 1, 1);
-insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, supported) values (null, '10.5', '10.5/powerpc',
'powerpc', 6, 1, 0, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.5', '10.5/powerpc',
'powerpc', 6, 1, 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, '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, supported) values (null, '10.5', '10.5/intel',
'i386', 7, 1, 0, 1);
+insert into `distribution` (dist_id, identifier, description, architecture,
priority, active, visible, unsupported) values (null, '10.5', '10.5/intel',
'i386', 7, 1, 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, '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
