https://wiki.finkproject.org/index.php?action=history&feed=atom&title=Fink%3APackageDatabase%3ANewSchema 2026-05-14T03:30:36Z Revision history for this page on the wiki MediaWiki 1.35.13 https://wiki.finkproject.org/index.php?title=Fink:PackageDatabase:NewSchema&diff=71&oldid=prev 2007-02-20T19:49:52Z

<p>collate ascii_general_ci</p> <p><b>New page</b></p><div>{{Fink_Header}}<br /> <br /> Possible new layout for a distribution/release db. It should replace the existing release table and also the [http://fink.cvs.sourceforge.net/fink/web/pdb/releases.inc?view=markup&amp;pathrev=redesign_pdb releases.inc] file. The code below will go into the [http://fink.cvs.sourceforge.net/fink/scripts/pdb/schema.sql?view=markup&amp;pathrev=redesign_pdb schema.sql] and [http://fink.cvs.sourceforge.net/fink/scripts/pdb/releases.sql?view=markup&amp;pathrev=redesign_pdb releases.sql]<br /> <br /> &lt;pre&gt;<br /> create table if not exists distribution (<br /> dist_id int unsigned not null auto_increment,<br /> identifier varchar(16) not null,<br /> description varchar(64) not null default '',<br /> architecture enum('powerpc', 'i386') not null default 'powerpc',<br /> priority tinyint unsigned not null default '1',<br /> active boolean default 1,<br /> primary key (dist_id)<br /> ) collate ascii_general_ci;<br /> <br /> create table if not exists distribution_releases (<br /> rel_id int unsigned not null auto_increment,<br /> dist_id int unsigned not null references distribution(dist_id),<br /> type enum('bindist', 'stable', 'unstable') not null,<br /> version varchar(16) not null,<br /> priority tinyint unsigned not null default '1',<br /> active boolean default 1,<br /> primary key (rel_id)<br /> ) collate ascii_general_ci;<br /> <br /> <br /> insert into distribution (dist_id, identifier, description, architecture, priority, active) values (null, '10.1', '10.1', 'powerpc', 1, 1);<br /> select @last_dist_id := last_insert_id();<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'bindist', '0.4.1', 1, 1);<br /> <br /> 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);<br /> select @last_dist_id := last_insert_id();<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'stable', 'current', 2, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'bindist', '0.6.4', 1, 1);<br /> <br /> insert into distribution (dist_id, identifier, description, architecture, priority, active) values (null, '10.3', '10.3', 'powerpc', 3, 1);<br /> select @last_dist_id := last_insert_id();<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'stable', 'current', 2, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'bindist', '0.7.2', 1, 1);<br /> <br /> insert into distribution (dist_id, identifier, description, architecture, priority, active) values (null, '10.4', '10.4/powerpc', 'powerpc', 4, 1);<br /> select @last_dist_id := last_insert_id();<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'stable', 'current', 2, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'bindist', '0.8.1', 1, 1);<br /> <br /> insert into distribution (dist_id, identifier, description, architecture, priority, active) values (null, '10.4', '10.4/intel', 'i386', 5, 1);<br /> select @last_dist_id := last_insert_id();<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'unstable', 'current', 3, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'stable', 'current', 2, 1);<br /> insert into distribution_releases (rel_id, dist_id, type, version, priority, active) values (null, @last_dist_id, 'bindist', '0.8.1', 1, 1);<br /> &lt;/pre&gt;<br /> <br /> And the corresponding package schema:<br /> &lt;pre&gt;<br /> create table if not exists package (<br /> pkg_id int unsigned not null auto_increment,<br /> rel_id int unsigned not null references distribution_releases(rel_id),<br /> name varchar(64) not null,<br /> parentname varchar(64),<br /> version varchar(64) not null,<br /> revision varchar (16) not null,<br /> epoch tinyint not null default '0',<br /> descshort varchar(80) not null default '',<br /> desclong text,<br /> descusage text,<br /> maintainer varchar(255),<br /> license varchar(64),<br /> homepage varchar(255),<br /> section varchar(32) not null,<br /> infofile varchar(255) not null default '',<br /> infofilechanged datetime,<br /> primary key (pkg_id),<br /> index (name),<br /> index (section),<br /> index (rel_id)<br /> ) collate ascii_general_ci;<br /> &lt;/pre&gt;<br /> <br /> <br /> {{Fink_Header}}<br /> <br /> [[Category: Fink|Package Database New Schema]]<br /> [[Category: Fink Structure|Package Database New Schema]]</div>

Chris01