-- Use this script to upgrade from BugzillaMetrics version 0.9.8.1 or earlier.

-- Creates an additional table to store metric results.
-- Results will be stored in this table to be available via static links.
-- Results will be only stored for a certain time that can be specified in the file settings.xml, default is 31 days

USE `bugzillametrics`;

--
-- Table structure for table 'saved_results'
--
CREATE TABLE /*!32312 IF NOT EXISTS*/ `saved_results` (
  `identifier` varchar(255) NOT NULL,
  `title` varchar(255) default NULL,
  `description` longtext,
  `metricConfiguration` longtext,
  `chartConfiguration` longtext,
  `metricResult` longtext,
  `runInformation` longtext,
  `user` varchar(255) NOT NULL,
  `creation` datetime NOT NULL,
  `expiration` datetime default NULL,
  PRIMARY KEY  (`identifier`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;