[Lsb-infrastructure] [Bug 2300] specdb needs CmdStd

[bugzilla-daemon at linux-foundation.org]

http://bugs.linuxbase.org/show_bug.cgi?id=2300


Denis Silakov <silakov at ispras.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |silakov at ispras.ru




--- Comment #1 from Denis Silakov <silakov at ispras.ru>  2008-09-11 01:02:26 ---
Yes, this looks reasonable. One little correction - s/iid/cid/ in primary key:

CREATE TABLE `CmdStd` (
  `CScid` int(10) unsigned NOT NULL default '0',
  `CSsid` int(10) unsigned NOT NULL default '0',
  `CSrefspec` int(10) unsigned NOT NULL default '0',
  `CSappearedin` varchar(5) NOT NULL,
  `CSwithdrawnin` varchar(5) default NULL,
  `CSurl` varchar(255) default NULL,
  PRIMARY KEY  (`CScid`,`CSsid`,`CSappearedin`),
  KEY `k_appearedin` (`CSappearedin`,`CSwithdrawnin`),
  KEY `k_withdrawnin` (`CSwithdrawnin`),
  KEY `k_CSsid` (`CSsid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

To mmigrate data to the new table:

INSERT INTO CmdStd (
 SELECT Cid, Cstandard, Crefspec, MCappearedin, MCwithdrawnin, Curl FROM
Command
 JOIN ModCmd ON MCcid=Cid
);

(Note: this query will add records for included commands only; to add records
for all entries from the Command table, replace 'JOIN' with 'LEFT JOIN').

I suggest not to change Command table until the next Navigator update, when it
will support CmdStd table.

As for scripts, only mkcmdlist and mkcmdtable from lsbspec require
modifications, we'll prepare necessary patches soon.


-- 
Configure bugmail: http://bugs.linuxbase.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.