CREATE TABLE IF NOT EXISTS `#__artiofusioncharts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `category` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `checked_out` tinyint(1) NOT NULL,
  `checked_out_time` datetime NOT NULL,
  `params` text NOT NULL,
  `categoryParams` text NOT NULL,
  `alias` varchar(150) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `category` (`category`),
  KEY `type` (`type`),
  KEY `created` (`created`),
  KEY `created_by` (`created_by`),
  KEY `modified` (`modified`),
  KEY `modified_by` (`modified_by`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

INSERT INTO `#__artiofusioncharts` (`id`, `title`, `category`, `type`, `created`, `created_by`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `params`, `categoryParams`, `alias`, `width`, `height`) VALUES
(3, 'Sales', 'multi_series_charts', 'column2D', '2009-04-14 14:09:40', 62, '2010-02-01 15:36:20', 62, 0, '0000-00-00 00:00:00', 'bgColor=9399BF\nshownames=1\nshowValues=1\nshowLimits=1\nrotateNames=0\nanimation=0\nshowColumnShadow=1\nnumberSuffix=k\nformatNumber=0\nformatNumberScale=0\nzeroPlaneColor=9399BF\nshowDivLineValue=0\nshowAlternateHGridColor=0\nalternateHGridColor=9399BF\nshowAlternateVGridColor=0\nshowhovercap=1\nhoverCapBgColor=9399BF', '', 'sales', 500, 300),
(4, 'Weekly Profit', 'single_series_charts', 'column2D', '2009-04-28 04:48:03', 62, '2010-02-01 10:41:40', 62, 0, '0000-00-00 00:00:00', 'bgColor=F0FEFF\ncanvasBorderColor=5454FF\ncaption=Weekly Profit\nsubCaption=Last Week\nxAxisName=Day\nyAxisName=Profit\nshownames=1\nshowValues=1\nshowLimits=1\nrotateNames=0\nanimation=0\nshowColumnShadow=0\nformatNumber=0\nformatNumberScale=0\nshowDivLineValue=0\nshowAlternateHGridColor=0\nshowAlternateVGridColor=0\nshowhovercap=1\nhoverCapBgColor=EBF2EF\nhoverCapBorderColor=1F1F1F', '', 'weekly-profit', 500, 300),
(5, 'Attendance', 'multi_series_charts', 'column2D', '2009-04-28 04:49:54', 62, '2010-02-01 10:41:47', 62, 0, '0000-00-00 00:00:00', 'bgColor=87EBFF\ncaption=1.6.2009\nsubCaption=attendance\nshownames=1\nshowValues=1\nshowLimits=0\nrotateNames=0\nanimation=0\nshowColumnShadow=1\nbaseFontSize=12\nformatNumber=0\nformatNumberScale=0\nshowDivLineValue=0\nshowAlternateHGridColor=0\nshowAlternateVGridColor=0\nshowhovercap=1\nhoverCapBorderColor=26FF3C', '', 'attendance', 150, 500),
(6, 'Average Temperature', 'single_series_charts', 'column2D', '2009-04-28 10:03:20', 62, '2010-02-01 11:07:30', 62, 62, '2010-02-01 12:50:06', 'bgColor=4133FF\ncanvasBgColor=FF1CB3\ncaption=Average Temperature\nsubCaption=2008\nshownames=1\nshowValues=1\nshowLimits=1\nrotateNames=0\nanimation=0\nshowColumnShadow=1\nbaseFontSize=12\nbaseFontColor=FAFFF5\nnumberSuffix=°C\nformatNumber=0\nformatNumberScale=1\nzeroPlaneThickness=text\nzeroPlaneColor=445566\nshowDivLineValue=1\nshowAlternateHGridColor=0\nshowAlternateVGridColor=0\nshowhovercap=1\nhoverCapBgColor=FF8FAD', '', 'average-temperature', 500, 300),
(7, 'Monthly Revenue', 'single_series_charts', 'bar2D', '2009-06-23 09:07:27', 62, '2010-02-01 10:41:58', 62, 0, '0000-00-00 00:00:00', 'bgColor=A6FFA6\ncanvasBgColor=F2FFE8\ncanvasBorderColor=F7FAFF\ncaption=Monthly Revenue\nsubCaption=2008\nxAxisName=Month\nyAxisName=Revenue\nshownames=1\nshowValues=1\nshowLimits=1\nrotateNames=1\nanimation=1\nshowBarShadow=1\nbaseFontSize=12\nnumberSuffix=k\nformatNumber=0\nformatNumberScale=0\nzeroPlaneThickness=5\nzeroPlaneColor=8578FF\nshowAlternateHGridColor=0\nshowDivLineValue=0\nshowAlternateVGridColor=0\nshowhovercap=1\nhoverCapBgColor=96FF69\nchartLeftMargin=20', '', 'monthly-revenue', 600, 300);

CREATE TABLE IF NOT EXISTS `#__artiofusioncharts_category` (
  `chart` int(11) NOT NULL,
  `value` varchar(100) NOT NULL,
  `params` text NOT NULL,
  `order` int(11) NOT NULL,
  KEY `chart` (`chart`),
  KEY `order` (`order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `#__artiofusioncharts_category` (`chart`, `value`, `params`, `order`) VALUES
(3, 'Others', '', 2),
(3, 'Computers', '', 1),
(5, '', '', 0),
(3, 'Cars', '', 0);

CREATE TABLE IF NOT EXISTS `#__artiofusioncharts_dataset` (
  `id` int(11) NOT NULL auto_increment,
  `chart` int(11) NOT NULL,
  `value` varchar(255) NOT NULL,
  `params` text NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `order` (`order`),
  KEY `chart` (`chart`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=232 ;

INSERT INTO `#__artiofusioncharts_dataset` (`id`, `chart`, `value`, `params`, `order`) VALUES
(224, 5, 'Children', '', 3),
(223, 5, 'Women', '', 2),
(222, 5, 'Men', '', 1),
(229, 3, '2006', '', 1),
(230, 3, '2007', '', 2),
(231, 3, '2008', '', 3);

CREATE TABLE IF NOT EXISTS `#__artiofusioncharts_set` (
  `dataset` int(11) NOT NULL,
  `value` varchar(100) NOT NULL,
  `params` text NOT NULL,
  `order` int(11) NOT NULL,
  KEY `dataset` (`dataset`),
  KEY `order` (`order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `#__artiofusioncharts_set` (`dataset`, `value`, `params`, `order`) VALUES
(224, '15', '', 0),
(231, '15', '', 2),
(231, '25', '', 1),
(231, '13', '', 0),
(230, '12', '', 2),
(230, '19', '', 1),
(230, '15', '', 0),
(229, '8', '', 2),
(229, '23', '', 1),
(229, '10', '', 0),
(223, '80', '', 0),
(222, '150', '', 0);

CREATE TABLE IF NOT EXISTS `#__artiofusioncharts_single` (
  `chart` int(11) NOT NULL,
  `label` varchar(100) NOT NULL,
  `value` varchar(100) NOT NULL,
  `color` varchar(6) NOT NULL,
  `htext` text NOT NULL,
  `link` varchar(100) NOT NULL,
  `alpha` varchar(3) NOT NULL default '',
  `show` tinyint(1) NOT NULL default '1',
  `order` int(11) NOT NULL,
  `isSliced` tinyint(11) NOT NULL default '1',
  KEY `chart` (`chart`),
  KEY `order` (`order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `#__artiofusioncharts_single` (`chart`, `label`, `value`, `color`, `htext`, `link`, `alpha`, `show`, `order`, `isSliced`) VALUES
(4, 'Saturday', '200', 'FF2937', 'Profit', '', '100', 1, 6, 0),
(4, 'Friday', '700', 'DC2EFF', 'Profit', '', '100', 1, 5, 0),
(7, 'December', '50', 'EEB5FF', 'December', '', '100', 1, 11, 0),
(7, 'November', '70', 'A8F1FF', 'November', '', '100', 1, 10, 0),
(7, 'October', '110', 'BDFFB3', 'October', '', '100', 1, 9, 0),
(7, 'September', '-30', 'F5FF9C', 'September', '', '100', 1, 8, 0),
(7, 'August', '70', 'FFA387', 'August', '', '100', 1, 7, 0),
(7, 'July', '120', 'FFCE6B', 'July', '', '100', 1, 6, 0),
(7, 'June', '90', 'E924FF', 'June', '', '100', 1, 5, 0),
(7, 'May', '60', '4F0FFF', 'May', '', '100', 1, 4, 0),
(7, 'April', '-40', '38F8FF', 'April', '', '100', 1, 3, 0),
(7, 'March', '80', '45FF29', 'March', '', '100', 1, 2, 0),
(7, 'February', '50', 'FFFF26', 'February', '', '100', 1, 1, 0),
(6, 'Winter', '3', '38E4FF', 'Average temperature', '', '100', 1, 3, 0),
(7, 'January', '100', 'FF4D17', 'January', '', '100', 1, 0, 0),
(6, 'Fall', '11', 'FFB45E', 'Average temperature', '', '100', 1, 2, 0),
(6, 'Summer', '25', 'FFF82B', 'Average temperature', '', '100', 1, 1, 0),
(6, 'Spring', '18', '21FF5C', 'Average temperature', '', '100', 1, 0, 0),
(4, 'Thursday', '400', '2432FF', 'Profit', '', '100', 1, 4, 0),
(4, 'Wednesday', '600', '33FFF8', 'Profit', '', '100', 1, 3, 0),
(4, 'Tuesday', '300', '5BFF42', 'Profit', '', '100', 1, 2, 0),
(4, 'Monday', '500', 'F2FF40', 'Profit', '', '100', 1, 1, 0),
(4, 'Sunday', '100', 'FFD54A', 'Profit', '', '100', 1, 0, 0);

CREATE TABLE IF NOT EXISTS `#__artiofusioncharts_trendlines` (
  `chart` int(11) NOT NULL,
  `start_value` varchar(11) NOT NULL default '',
  `end_value` varchar(11) NOT NULL default '',
  `color` varchar(6) NOT NULL,
  `display` varchar(100) NOT NULL,
  `thickness` varchar(11) NOT NULL default '',
  `zone` tinyint(1) NOT NULL,
  `top` tinyint(1) NOT NULL,
  `alpha` varchar(3) NOT NULL default '',
  KEY `chart` (`chart`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `#__artiofusioncharts_trendlines` (`chart`, `start_value`, `end_value`, `color`, `display`, `thickness`, `zone`, `top`, `alpha`) VALUES
(4, '400', '500', 'FCA8FF', '', '0', 1, 0, '50'),
(3, '10', '21', '2D219C', 'trend ', '3', 0, 1, '20'),
(12, '45', '54', '', '', '', 0, 0, '100');
