-- <?php die('This is not a program file.'); exit; ?>


--
-- Table structure for table `#TABLE_PREFIX#__reports_list`
--

DROP TABLE IF EXISTS `#TABLE_PREFIX#__reports_list`;

CREATE TABLE `#TABLE_PREFIX#__reports_list` (
  `num` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `createdDate` datetime NOT NULL,
  `createdByUserNum` int(10) unsigned NOT NULL,
  `updatedDate` datetime NOT NULL,
  `updatedByUserNum` int(10) unsigned NOT NULL,
  `dragSortOrder` int(10) unsigned NOT NULL,
  `name` mediumtext,
  `mysql` mediumtext,
  PRIMARY KEY (`num`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;


--
-- Dumping data for table `#TABLE_PREFIX#__reports_list`
--

INSERT INTO `#TABLE_PREFIX#__reports_list` VALUES("2","2011-03-09 21:08:49","118","2011-03-09 21:46:32","118","1299733729","Sales By Month","  SELECT DATE_FORMAT(orderDate, \'%M %Y\') as Date,\n         SUM(quantity)                   as \'Total Units\',\n         FORMAT(SUM(totalPrice),2)       as \'Total Sales\'\n    FROM <?php echo $TABLE_PREFIX ?>_reports_sample_orders\nGROUP BY Date\nORDER BY YEAR(orderDate) DESC, MONTH(orderDate) DESC");
INSERT INTO `#TABLE_PREFIX#__reports_list` VALUES("3","2011-03-09 21:10:15","118","2011-03-09 21:48:58","118","1299733815","Sales By Product","  SELECT name                            as \'Name\',\n         SUM(quantity)                   as \'Total Units\',\n         FORMAT(SUM(totalPrice),2)       as \'Total Sales\'\n    FROM <?php echo $TABLE_PREFIX ?>_reports_sample_orders\nGROUP BY name\nORDER BY SUM(totalPrice) DESC\n");

-- Dump completed on 2011-03-09 21:54:11 -0800
