text: DROP TABLE IF EXISTS `USDCHF_W1`;
  CREATE TABLE IF NOT EXISTS `USDCHF_W1`(
  `id` int(5) NOT NULL,
  `bull` varchar(2) NOT NULL,
  `bear` varchar(2) NOT NULL,
  `time` varchar(30) NOT NULL);
  ALTER TABLE `USDCHF_W1` ADD PRIMARY KEY (`id`);
  ALTER TABLE `USDCHF_W1` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT;
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.10.25 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.10.18 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2015.10.11 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.10.04 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.09.27 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.09.20 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.09.13 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.09.06 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.08.30 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.08.23 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.08.16 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.08.09 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.08.02 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.07.26 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.07.19 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.07.12 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.07.05 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.06.28 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.06.21 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2015.06.14 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2015.06.07 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2015.05.31 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.05.24 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2015.05.17 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2015.05.10 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2015.05.03 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2015.04.26 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.04.19 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.04.12 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.04.05 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.03.29 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.03.22 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.03.15 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.03.08 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2015.03.01 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.02.22 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.02.15 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.02.08 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.02.01 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.01.25 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.01.18 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2015.01.11 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2015.01.04 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.12.28 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.12.21 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.12.14 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2014.12.07 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.11.30 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.11.23 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.11.16 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.11.09 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.11.02 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.10.26 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.10.19 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.10.12 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.10.05 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.09.28 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.09.21 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.09.14 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.09.07 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('4','0','2014.08.31 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.08.24 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.08.17 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.08.10 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.08.03 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.07.27 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.07.20 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.07.13 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.07.06 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.06.29 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2014.06.22 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.06.15 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.06.08 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.06.01 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.05.25 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.05.18 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('3','0','2014.05.11 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.05.04 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2014.04.27 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2014.04.20 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.04.13 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2014.04.06 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2014.03.30 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.03.23 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2014.03.16 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2014.03.09 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2014.03.02 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2014.02.23 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2014.02.16 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2014.02.09 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.02.02 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2014.01.26 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2014.01.19 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('2','0','2014.01.12 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('1','0','2014.01.05 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-1','2013.12.29 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2013.12.22 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-2','2013.12.15 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2013.12.08 00:00');
  INSERT INTO `USDCHF_W1`(bull,bear,time) VALUES('0','-3','2013.12.01 00:00');
  
  