Article Figure 1 Listing 1 Listing 2 Listing 3 mar2004.tar

Listing 1 nbperf.sql

--
-- Table structure for table 'backperf'
--

CREATE TABLE backperf (
  backupid varchar(50) NOT NULL default '',
  seconds int(11) NOT NULL default '0',
  client varchar(30) NOT NULL default '',
  schedtype varchar(30) NOT NULL default '',
  kbytes bigint(20) NOT NULL default '0',
  numfiles bigint(20) NOT NULL default '0',
  kbpersec int(11) NOT NULL default '0',
  policy varchar(40) NOT NULL default '',
  backdate datetime NOT NULL default '0000-00-00 00:00:00',
  backserver varchar(40) default NULL,
  drive_index int(11) default NULL,
  PRIMARY KEY  (backupid)
) TYPE=MyISAM;