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

