text: DROP TABLE IF EXISTS `AUDCAD_MN1`;
  CREATE TABLE IF NOT EXISTS `AUDCAD_MN1`(
  `id` int(5) NOT NULL,
  `buy` varchar(15) NOT NULL,
  `sell` varchar(15) NOT NULL,
  `bg` varchar(10) NOT NULL,
  `time` varchar(30) NOT NULL);
  ALTER TABLE `AUDCAD_MN1` ADD PRIMARY KEY (`id`);
  ALTER TABLE `AUDCAD_MN1` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','0.00000000','2015.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2015.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2015.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2014.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2014.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2014.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2014.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2014.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2014.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2014.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2014.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2014.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('1.00000000','0.00000000','1.00000000','2014.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2014.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2014.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2013.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2013.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2013.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('1.00000000','0.00000000','-1.00000000','2013.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2013.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2012.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2012.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2012.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2012.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2012.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2012.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('1.00000000','0.00000000','1.00000000','2011.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2011.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('1.00000000','0.00000000','1.00000000','2010.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2010.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2010.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2010.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2010.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2009.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2009.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2009.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2008.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2008.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2008.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','-1.00000000','-1.00000000','2008.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.07.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.06.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.05.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.04.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.03.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('1.00000000','0.00000000','1.00000000','2008.02.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2008.01.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2007.12.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2007.11.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2007.10.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2007.09.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','-1.00000000','2007.08.01 00:00');
  INSERT INTO `AUDCAD_MN1` (`buy`,`sell`,`bg`,`time`) VALUES('0.00000000','0.00000000','1.00000000','2007.07.01 00:00');
  
  