Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
manage20180528.sql 348.49 KB
Copy Edit Web IDE Raw Blame History
邓云溪 authored 2018-05-28 16:39 . no commit message
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50547
Source Host : localhost:3306
Source Database : manage
Target Server Type : MYSQL
Target Server Version : 50547
File Encoding : 65001
Date: 2018-05-28 10:42:15
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for ma_admin
-- ----------------------------
DROP TABLE IF EXISTS `ma_admin`;
CREATE TABLE `ma_admin` (
`admin_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员id',
`user_name` varchar(20) NOT NULL COMMENT '用户名',
`password` varchar(128) NOT NULL COMMENT '用户密码',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`ip` varchar(40) NOT NULL COMMENT 'ip地址',
`loginip` varchar(40) DEFAULT NULL COMMENT '登录IP',
`ipadress` varchar(40) DEFAULT NULL COMMENT 'ip地址',
`logintime` datetime DEFAULT NULL COMMENT '登录时间',
`loginnum` int(10) unsigned DEFAULT NULL COMMENT '登录次数',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
`group_id` smallint(5) unsigned NOT NULL DEFAULT '0',
`session_id` varchar(30) DEFAULT NULL,
PRIMARY KEY (`admin_id`),
UNIQUE KEY `user_name` (`user_name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='后台管理用户信息表';
-- ----------------------------
-- Records of ma_admin
-- ----------------------------
INSERT INTO `ma_admin` VALUES ('1', 'admin123', '0c909a141f1f2c0a1cb602b0b2d7d050', '2018-04-21 11:36:22', '2018-04-27 17:09:13', '127.0.0.1', '119.123.33.107', '广东省深圳市龙岗区', '2018-05-23 12:31:14', '19', '0', '1', 'nt1u4h7aag88vgbg3e9qihukc4');
INSERT INTO `ma_admin` VALUES ('19', 'hm888888', 'acb2106fbc143aa04de951d6860a045f', '2018-05-14 14:37:26', null, '183.238.28.94', '183.238.28.94', '广东省深圳市', '2018-05-17 15:24:37', '4', '0', '1', '89f3o8d2uatp7shd8370riib15');
INSERT INTO `ma_admin` VALUES ('20', 'gjtz888', '9f5466fcd5723be378d4b7fed8993108', '2018-05-17 15:50:04', null, '183.238.28.94', '117.61.18.79', '江苏省泰州市', '2018-05-24 12:04:27', '12', '0', '1', 'sboshg9tl2tvr9kthuohlhp6u7');
-- ----------------------------
-- Table structure for ma_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `ma_admin_log`;
CREATE TABLE `ma_admin_log` (
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '日志id',
`admin_id` int(10) unsigned NOT NULL COMMENT '管理员操作id',
`log_time` datetime NOT NULL COMMENT '日志操作时间',
`loginfo` varchar(255) NOT NULL DEFAULT '' COMMENT '日志信息',
`ip` varchar(40) NOT NULL DEFAULT '' COMMENT '操作IP',
`ipadress` varchar(40) NOT NULL DEFAULT '' COMMENT 'IP地址',
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 COMMENT='管理员操作日志表';
-- ----------------------------
-- Records of ma_admin_log
-- ----------------------------
INSERT INTO `ma_admin_log` VALUES ('81', '1', '2018-05-08 18:13:03', 'admin123删除开奖记录', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('82', '1', '2018-05-09 09:35:07', 'admin123添加了开奖期数', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('83', '1', '2018-05-09 18:10:49', 'admin123修改了系统设置', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('84', '1', '2018-05-09 18:26:34', 'admin123修改了系统设置', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('85', '1', '2018-05-09 18:28:53', 'admin123修改了系统设置', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('86', '1', '2018-05-09 18:34:34', 'admin123修改了系统设置', '127.0.0.1', '本机地址');
INSERT INTO `ma_admin_log` VALUES ('87', '1', '2018-05-10 15:15:40', 'admin123金额充值', '119.123.35.240', '广东省深圳市龙岗区');
INSERT INTO `ma_admin_log` VALUES ('88', '1', '2018-05-10 15:45:30', 'admin123金额充值', '119.123.35.253', '广东省深圳市龙岗区');
INSERT INTO `ma_admin_log` VALUES ('89', '1', '2018-05-10 21:45:23', 'admin123金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('90', '1', '2018-05-11 09:42:29', 'admin123金额充值', '119.123.35.95', '广东省深圳市龙岗区');
INSERT INTO `ma_admin_log` VALUES ('91', '1', '2018-05-14 14:15:16', 'admin123金额充值', '219.134.115.172', '广东省深圳市南山区');
INSERT INTO `ma_admin_log` VALUES ('92', '1', '2018-05-14 14:37:26', 'admin123添加管理员', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('93', '19', '2018-05-14 14:47:32', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('94', '1', '2018-05-14 14:57:16', 'admin123金额充值', '219.134.115.172', '广东省深圳市南山区');
INSERT INTO `ma_admin_log` VALUES ('95', '19', '2018-05-14 15:24:04', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('96', '1', '2018-05-14 16:45:42', 'admin123修改用户管理信息', '219.134.115.161', '广东省深圳市南山区');
INSERT INTO `ma_admin_log` VALUES ('97', '1', '2018-05-14 17:13:22', 'admin123金额充值', '219.134.115.161', '广东省深圳市南山区');
INSERT INTO `ma_admin_log` VALUES ('98', '1', '2018-05-15 10:37:30', 'admin123金额充值', '113.91.41.190', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('99', '1', '2018-05-15 11:37:49', 'admin123金额充值', '113.91.41.190', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('100', '1', '2018-05-15 13:44:29', 'admin123金额充值', '113.91.41.190', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('101', '1', '2018-05-15 13:49:31', 'admin123修改用户管理信息', '113.91.41.190', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('102', '1', '2018-05-15 14:36:09', 'admin123添加了开奖期数', '113.91.41.190', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('103', '19', '2018-05-15 17:17:31', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('104', '19', '2018-05-16 14:03:19', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('105', '19', '2018-05-16 14:03:49', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('106', '19', '2018-05-16 14:09:13', 'hm888888金额充值', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('107', '19', '2018-05-17 15:50:04', 'hm888888添加管理员', '183.238.28.94', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('108', '20', '2018-05-21 16:03:39', 'gjtz888编辑公告', '183.12.222.66', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('109', '1', '2018-05-21 16:50:00', 'admin123修改用户管理信息', '119.123.33.70', '广东省深圳市龙岗区');
INSERT INTO `ma_admin_log` VALUES ('110', '20', '2018-05-22 18:06:08', 'gjtz888金额充值', '183.12.222.66', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('111', '20', '2018-05-22 18:06:56', 'gjtz888金额充值', '183.12.222.66', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('112', '20', '2018-05-22 18:09:11', 'gjtz888金额充值', '183.12.222.66', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('113', '20', '2018-05-22 18:09:55', 'gjtz888金额充值', '183.12.222.66', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('114', '20', '2018-05-23 11:39:40', 'gjtz888金额充值', '183.12.223.152', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('115', '20', '2018-05-23 12:22:40', 'gjtz888添加了开奖期数', '183.12.223.152', '广东省深圳市');
INSERT INTO `ma_admin_log` VALUES ('116', '20', '2018-05-24 12:16:23', 'gjtz888删除会员列表', '117.61.18.79', '江苏省泰州市');
INSERT INTO `ma_admin_log` VALUES ('117', '20', '2018-05-24 12:16:56', 'gjtz888删除会员列表', '117.61.18.79', '江苏省泰州市');
-- ----------------------------
-- Table structure for ma_kaipan
-- ----------------------------
DROP TABLE IF EXISTS `ma_kaipan`;
CREATE TABLE `ma_kaipan` (
`m_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '开封盘ID',
`qishu` int(10) unsigned DEFAULT NULL COMMENT '期数',
`opendate` datetime DEFAULT NULL COMMENT '开盘时间',
`closedate` datetime DEFAULT NULL COMMENT '封盘时间',
`g_lock` int(2) unsigned DEFAULT '1' COMMENT '標示',
PRIMARY KEY (`m_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='开盘期数表';
-- ----------------------------
-- Records of ma_kaipan
-- ----------------------------
-- ----------------------------
-- Table structure for ma_money_log
-- ----------------------------
DROP TABLE IF EXISTS `ma_money_log`;
CREATE TABLE `ma_money_log` (
`log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`user_id` int(10) unsigned NOT NULL COMMENT '用户ID',
`user_money` decimal(10,2) NOT NULL COMMENT '下单金额 上级用户所得金额',
`change_time` datetime NOT NULL COMMENT '下单时间和金额到账时间',
`change_desc` varchar(100) NOT NULL COMMENT '下注描述',
PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='金额操作表';
-- ----------------------------
-- Records of ma_money_log
-- ----------------------------
-- ----------------------------
-- Table structure for ma_notice
-- ----------------------------
DROP TABLE IF EXISTS `ma_notice`;
CREATE TABLE `ma_notice` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`content` text NOT NULL COMMENT '公告信息内容',
`create_time` datetime NOT NULL COMMENT '发布时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '默认1显示,0不显示',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='公告信息表';
-- ----------------------------
-- Records of ma_notice
-- ----------------------------
INSERT INTO `ma_notice` VALUES ('1', '<p>冠军投资欢迎您。&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>', '2018-05-08 17:18:19', '2018-05-21 16:03:39', '1');
-- ----------------------------
-- Table structure for ma_order
-- ----------------------------
DROP TABLE IF EXISTS `ma_order`;
CREATE TABLE `ma_order` (
`oid` int(10) NOT NULL AUTO_INCREMENT COMMENT '订单id',
`uid` int(10) unsigned NOT NULL COMMENT '订单人id号',
`codeifd` bigint(20) unsigned NOT NULL COMMENT '订单号',
`qishu` int(10) NOT NULL COMMENT '开奖期数',
`money` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额',
`updown` tinyint(1) unsigned DEFAULT NULL COMMENT '1买涨,0买跌',
`ordertime` datetime NOT NULL COMMENT '下单时间',
`status` tinyint(3) unsigned NOT NULL DEFAULT '3' COMMENT '是否中奖',
`winmoney` varchar(20) DEFAULT NULL COMMENT '中奖',
`wintime` datetime DEFAULT NULL COMMENT '中奖时间',
PRIMARY KEY (`oid`)
) ENGINE=MyISAM AUTO_INCREMENT=568 DEFAULT CHARSET=utf8 COMMENT='用户下注表';
-- ----------------------------
-- Records of ma_order
-- ----------------------------
INSERT INTO `ma_order` VALUES ('463', '70', '2018051525465960', '681988', '10.00', '1', '2018-05-15 11:38:06', '1', '19.5', '2018-05-15 11:43:01');
INSERT INTO `ma_order` VALUES ('464', '70', '2018051597727865', '681988', '10.00', '0', '2018-05-15 11:38:11', '0', '0', '2018-05-15 11:43:01');
INSERT INTO `ma_order` VALUES ('465', '83', '2018051542599414', '681988', '10.00', '1', '2018-05-15 11:38:17', '1', '19.5', '2018-05-15 11:43:01');
INSERT INTO `ma_order` VALUES ('466', '83', '2018051553913047', '681988', '10.00', '0', '2018-05-15 11:38:24', '0', '0', '2018-05-15 11:43:01');
INSERT INTO `ma_order` VALUES ('467', '83', '2018051598635178', '681989', '10.00', '1', '2018-05-15 11:43:35', '0', '0', '2018-05-15 11:48:04');
INSERT INTO `ma_order` VALUES ('468', '83', '2018051598417213', '681990', '10.00', '1', '2018-05-15 11:48:23', '1', '19.5', '2018-05-15 11:53:04');
INSERT INTO `ma_order` VALUES ('469', '83', '2018051551553110', '681990', '10.00', '0', '2018-05-15 11:48:31', '0', '0', '2018-05-15 11:53:04');
INSERT INTO `ma_order` VALUES ('470', '83', '2018051522779020', '681991', '10.00', '1', '2018-05-15 11:53:44', '1', '19.5', '2018-05-15 11:57:56');
INSERT INTO `ma_order` VALUES ('471', '70', '2018051563587732', '681992', '10.00', '1', '2018-05-15 11:59:17', '0', '0', '2018-05-15 12:02:59');
INSERT INTO `ma_order` VALUES ('472', '83', '2018051533860226', '681992', '10.00', '0', '2018-05-15 11:59:23', '1', '19.5', '2018-05-15 12:02:59');
INSERT INTO `ma_order` VALUES ('473', '70', '2018051532801224', '682011', '10.00', '1', '2018-05-15 13:35:01', '1', '19.5', '2018-05-15 13:37:49');
INSERT INTO `ma_order` VALUES ('474', '70', '2018051554864574', '682011', '10.00', '0', '2018-05-15 13:35:06', '0', '0', '2018-05-15 13:37:49');
INSERT INTO `ma_order` VALUES ('475', '83', '2018051569141265', '682011', '10.00', '1', '2018-05-15 13:35:32', '1', '19.5', '2018-05-15 13:37:49');
INSERT INTO `ma_order` VALUES ('476', '83', '2018051535681852', '682011', '10.00', '0', '2018-05-15 13:35:40', '0', '0', '2018-05-15 13:37:49');
INSERT INTO `ma_order` VALUES ('477', '87', '2018051579979699', '682014', '1000.00', '1', '2018-05-15 13:48:39', '0', '0', '2018-05-15 13:52:53');
INSERT INTO `ma_order` VALUES ('478', '87', '2018051533886219', '682015', '1000.00', '0', '2018-05-15 13:52:58', '0', '0', '2018-05-15 13:58:00');
INSERT INTO `ma_order` VALUES ('479', '87', '2018051534389702', '682018', '1000.00', '1', '2018-05-15 14:08:08', '0', '0', '2018-05-15 14:36:09');
INSERT INTO `ma_order` VALUES ('480', '85', '2018051562990999', '682018', '1000.00', '0', '2018-05-15 14:08:36', '1', '1950', '2018-05-15 14:12:37');
INSERT INTO `ma_order` VALUES ('481', '87', '2018051540760794', '682022', '1000.00', '0', '2018-05-15 14:30:32', '0', '0', '2018-05-15 14:32:50');
INSERT INTO `ma_order` VALUES ('482', '87', '2018051569946975', '682025', '1000.00', '0', '2018-05-15 14:44:47', '1', '1950', '2018-05-15 14:48:13');
INSERT INTO `ma_order` VALUES ('483', '85', '2018051519253769', '682025', '1000.00', '1', '2018-05-15 14:44:54', '0', '0', '2018-05-15 14:48:13');
INSERT INTO `ma_order` VALUES ('484', '87', '2018051540675366', '682027', '100.00', '1', '2018-05-15 14:54:42', '1', '195', '2018-05-15 14:58:02');
INSERT INTO `ma_order` VALUES ('485', '85', '2018051556711426', '682027', '5000.00', '0', '2018-05-15 14:54:58', '0', '0', '2018-05-15 14:58:02');
INSERT INTO `ma_order` VALUES ('486', '87', '2018051516666634', '682030', '500.00', '0', '2018-05-15 15:10:05', '1', '975', '2018-05-15 15:13:07');
INSERT INTO `ma_order` VALUES ('487', '85', '201805155909370', '682030', '500.00', '1', '2018-05-15 15:10:15', '0', '0', '2018-05-15 15:13:07');
INSERT INTO `ma_order` VALUES ('488', '85', '2018051515710715', '682034', '500.00', '0', '2018-05-15 15:30:12', '0', '0', '2018-05-15 15:33:05');
INSERT INTO `ma_order` VALUES ('489', '87', '2018051540906706', '682035', '500.00', '1', '2018-05-15 15:34:41', '1', '975', '2018-05-15 15:37:58');
INSERT INTO `ma_order` VALUES ('490', '85', '2018051569597006', '682035', '1000.00', '0', '2018-05-15 15:35:07', '0', '0', '2018-05-15 15:37:58');
INSERT INTO `ma_order` VALUES ('491', '84', '2018051525014681', '682044', '50.00', '1', '2018-05-15 16:19:14', '1', '97.5', '2018-05-15 16:23:04');
INSERT INTO `ma_order` VALUES ('492', '84', '2018051591599623', '682044', '50.00', '0', '2018-05-15 16:19:19', '0', '0', '2018-05-15 16:23:04');
INSERT INTO `ma_order` VALUES ('493', '84', '2018051586755663', '682044', '150.00', '0', '2018-05-15 16:19:27', '0', '0', '2018-05-15 16:23:04');
INSERT INTO `ma_order` VALUES ('494', '84', '2018051597008516', '682049', '100.00', '1', '2018-05-15 16:43:17', '0', '0', '2018-05-15 16:48:08');
INSERT INTO `ma_order` VALUES ('495', '84', '2018051546990940', '682049', '150.00', '0', '2018-05-15 16:43:26', '1', '292.5', '2018-05-15 16:48:08');
INSERT INTO `ma_order` VALUES ('496', '84', '2018051527222554', '682050', '300.00', '0', '2018-05-15 16:49:41', '1', '585', '2018-05-15 16:52:50');
INSERT INTO `ma_order` VALUES ('497', '84', '2018051576770431', '682050', '100.00', '1', '2018-05-15 16:49:47', '0', '0', '2018-05-15 16:52:50');
INSERT INTO `ma_order` VALUES ('498', '84', '2018051571278896', '682051', '50.00', '1', '2018-05-15 16:55:30', '1', '97.5', '2018-05-15 16:57:57');
INSERT INTO `ma_order` VALUES ('499', '84', '2018051560516450', '682051', '100.00', '0', '2018-05-15 16:55:38', '0', '0', '2018-05-15 16:57:57');
INSERT INTO `ma_order` VALUES ('500', '84', '201805156101145', '682052', '50.00', '1', '2018-05-15 16:58:22', '0', '0', '2018-05-15 17:02:52');
INSERT INTO `ma_order` VALUES ('501', '84', '2018051586301705', '682052', '100.00', '0', '2018-05-15 16:58:27', '1', '195', '2018-05-15 17:02:52');
INSERT INTO `ma_order` VALUES ('502', '84', '20180515337110', '682052', '50.00', '1', '2018-05-15 16:59:07', '0', '0', '2018-05-15 17:02:52');
INSERT INTO `ma_order` VALUES ('503', '84', '2018051516795634', '682052', '30.00', '0', '2018-05-15 16:59:12', '1', '58.5', '2018-05-15 17:02:52');
INSERT INTO `ma_order` VALUES ('504', '84', '2018051521219133', '682053', '100.00', '1', '2018-05-15 17:05:49', '1', '195', '2018-05-15 17:07:52');
INSERT INTO `ma_order` VALUES ('505', '84', '2018051592836931', '682053', '110.00', '0', '2018-05-15 17:05:54', '0', '0', '2018-05-15 17:07:52');
INSERT INTO `ma_order` VALUES ('506', '84', '2018051533524576', '682054', '120.00', '1', '2018-05-15 17:08:23', '1', '234', '2018-05-15 17:13:06');
INSERT INTO `ma_order` VALUES ('507', '84', '2018051530920796', '682054', '180.00', '0', '2018-05-15 17:08:29', '0', '0', '2018-05-15 17:13:06');
INSERT INTO `ma_order` VALUES ('508', '88', '2018051512123937', '682056', '100.00', '1', '2018-05-15 17:18:01', '0', '0', '2018-05-15 17:22:49');
INSERT INTO `ma_order` VALUES ('509', '84', '2018051596734894', '682056', '200.00', '0', '2018-05-15 17:18:18', '1', '390', '2018-05-15 17:22:49');
INSERT INTO `ma_order` VALUES ('510', '84', '2018051617747099', '682194', '100.00', '0', '2018-05-16 13:54:06', '1', '195', '2018-05-16 13:57:50');
INSERT INTO `ma_order` VALUES ('511', '88', '2018051662067742', '682194', '200.00', '1', '2018-05-16 13:54:53', '0', '0', '2018-05-16 13:57:50');
INSERT INTO `ma_order` VALUES ('512', '84', '2018051635976839', '682195', '100.00', '0', '2018-05-16 13:59:33', '0', '0', '2018-05-16 14:03:05');
INSERT INTO `ma_order` VALUES ('513', '88', '2018051668440309', '682195', '200.00', '1', '2018-05-16 14:00:19', '1', '390', '2018-05-16 14:03:05');
INSERT INTO `ma_order` VALUES ('514', '88', '2018051623178829', '682196', '490.00', '0', '2018-05-16 14:04:15', '0', '0', '2018-05-16 14:07:50');
INSERT INTO `ma_order` VALUES ('515', '84', '2018051646577574', '682197', '100.00', '1', '2018-05-16 14:09:36', '0', '0', '2018-05-16 14:13:11');
INSERT INTO `ma_order` VALUES ('516', '88', '2018051657142310', '682197', '200.00', '0', '2018-05-16 14:10:05', '1', '390', '2018-05-16 14:13:11');
INSERT INTO `ma_order` VALUES ('517', '88', '2018051624367811', '682200', '200.00', '0', '2018-05-16 14:23:10', '0', '0', '2018-05-16 14:27:52');
INSERT INTO `ma_order` VALUES ('518', '84', '2018051665890566', '682200', '100.00', '1', '2018-05-16 14:23:38', '1', '195', '2018-05-16 14:27:52');
INSERT INTO `ma_order` VALUES ('519', '88', '2018051631588953', '682218', '200.00', '0', '2018-05-16 15:54:58', '1', '390', '2018-05-16 15:58:03');
INSERT INTO `ma_order` VALUES ('520', '84', '2018051667274860', '682218', '100.00', '1', '2018-05-16 15:55:11', '0', '0', '2018-05-16 15:58:03');
INSERT INTO `ma_order` VALUES ('521', '82', '2018051654246003', '682295', '100.00', '0', '2018-05-16 22:19:33', '3', null, null);
INSERT INTO `ma_order` VALUES ('522', '82', '2018051680635930', '682296', '500.00', '1', '2018-05-16 22:25:28', '0', '0', '2018-05-16 22:27:52');
INSERT INTO `ma_order` VALUES ('523', '82', '2018051623256369', '682297', '500.00', '1', '2018-05-16 22:30:25', '3', null, null);
INSERT INTO `ma_order` VALUES ('524', '82', '2018051613664590', '682299', '100.00', '0', '2018-05-16 22:39:23', '0', '0', '2018-05-16 22:46:14');
INSERT INTO `ma_order` VALUES ('525', '70', '2018051787222225', '682318', '10.00', '0', '2018-05-17 09:19:25', '1', '19.5', '2018-05-17 09:27:49');
INSERT INTO `ma_order` VALUES ('526', '82', '2018051770057227', '682323', '100.00', '1', '2018-05-17 09:45:07', '0', '0', '2018-05-17 09:47:53');
INSERT INTO `ma_order` VALUES ('527', '82', '2018051781913657', '682324', '200.00', '1', '2018-05-17 09:50:18', '1', '390', '2018-05-17 09:57:45');
INSERT INTO `ma_order` VALUES ('528', '82', '2018051756970999', '682335', '100.00', '0', '2018-05-17 10:43:31', '3', null, null);
INSERT INTO `ma_order` VALUES ('529', '82', '2018051762495450', '682371', '100.00', '1', '2018-05-17 13:43:55', '3', null, null);
INSERT INTO `ma_order` VALUES ('530', '82', '2018051757481666', '682372', '200.00', '1', '2018-05-17 13:49:23', '0', '0', '2018-05-18 14:10:05');
INSERT INTO `ma_order` VALUES ('531', '69', '2018051892588897', '682495', '10.00', '1', '2018-05-18 09:12:40', '1', '19.5', '2018-05-18 14:09:45');
INSERT INTO `ma_order` VALUES ('532', '70', '2018051865251633', '682500', '10.00', '1', '2018-05-18 09:33:03', '0', '0', '2018-05-18 09:37:46');
INSERT INTO `ma_order` VALUES ('533', '70', '201805186324249', '682501', '10.00', '0', '2018-05-18 09:38:16', '1', '19.5', '2018-05-18 09:42:49');
INSERT INTO `ma_order` VALUES ('534', '70', '2018051898357545', '682502', '10.00', '1', '2018-05-18 09:44:31', '1', '19.5', '2018-05-18 09:47:46');
INSERT INTO `ma_order` VALUES ('535', '70', '2018051816001211', '682502', '10.00', '0', '2018-05-18 09:44:37', '0', '0', '2018-05-18 09:47:46');
INSERT INTO `ma_order` VALUES ('536', '86', '201805186387532', '682503', '10.00', '1', '2018-05-18 09:48:10', '0', '0', '2018-05-18 09:52:53');
INSERT INTO `ma_order` VALUES ('537', '70', '2018051834929382', '682503', '10.00', '0', '2018-05-18 09:48:19', '1', '19.5', '2018-05-18 09:52:52');
INSERT INTO `ma_order` VALUES ('538', '82', '201805181883758', '682505', '100.00', '1', '2018-05-18 09:59:10', '0', '0', '2018-05-18 10:02:47');
INSERT INTO `ma_order` VALUES ('539', '82', '2018051869181573', '682505', '200.00', '0', '2018-05-18 09:59:33', '1', '390', '2018-05-18 10:02:47');
INSERT INTO `ma_order` VALUES ('540', '82', '2018051897865461', '682508', '100.00', '1', '2018-05-18 10:14:20', '0', '0', '2018-05-18 10:17:46');
INSERT INTO `ma_order` VALUES ('541', '82', '2018051832972382', '682509', '100.00', '1', '2018-05-18 10:19:26', '1', '195', '2018-05-18 10:22:46');
INSERT INTO `ma_order` VALUES ('542', '70', '201805183990656', '682510', '10.00', '1', '2018-05-18 10:25:22', '0', '0', '2018-05-18 10:27:49');
INSERT INTO `ma_order` VALUES ('543', '70', '2018051892092306', '682510', '10.00', '0', '2018-05-18 10:25:27', '1', '19.5', '2018-05-18 10:27:49');
INSERT INTO `ma_order` VALUES ('544', '82', '201805182048805', '682521', '100.00', '0', '2018-05-18 11:18:04', '0', '0', '2018-05-18 11:22:48');
INSERT INTO `ma_order` VALUES ('545', '82', '2018051860712460', '682589', '1000.00', '1', '2018-05-18 16:58:01', '0', '0', '2018-05-18 17:02:42');
INSERT INTO `ma_order` VALUES ('546', '82', '2018051814825241', '682590', '2000.00', '1', '2018-05-18 17:03:03', '1', '3900', '2018-05-18 17:07:45');
INSERT INTO `ma_order` VALUES ('547', '82', '201805181180956', '682596', '3000.00', '1', '2018-05-18 17:35:26', '1', '5850', '2018-05-21 16:48:38');
INSERT INTO `ma_order` VALUES ('548', '88', '2018052196607221', '683120', '100.00', '0', '2018-05-21 16:30:24', '0', '0', '2018-05-21 16:33:10');
INSERT INTO `ma_order` VALUES ('549', '88', '2018052194914568', '683122', '100.00', '0', '2018-05-21 16:38:20', '0', '0', '2018-05-21 16:43:08');
INSERT INTO `ma_order` VALUES ('550', '88', '2018052141388406', '683124', '100.00', '0', '2018-05-21 16:49:29', '1', '195', '2018-05-21 16:53:24');
INSERT INTO `ma_order` VALUES ('551', '88', '2018052147810304', '683125', '200.00', '0', '2018-05-21 16:55:24', '0', '0', '2018-05-21 16:58:03');
INSERT INTO `ma_order` VALUES ('552', '88', '2018052151225839', '683125', '100.00', '1', '2018-05-21 16:55:31', '1', '195', '2018-05-21 16:58:03');
INSERT INTO `ma_order` VALUES ('553', '70', '2018052192582178', '683127', '100.00', '1', '2018-05-21 17:03:06', '1', '195', '2018-05-21 17:07:53');
INSERT INTO `ma_order` VALUES ('554', '83', '2018052199340464', '683134', '10.00', '1', '2018-05-21 17:40:28', '1', '19.5', '2018-05-21 17:42:50');
INSERT INTO `ma_order` VALUES ('555', '83', '2018052177267056', '683134', '10.00', '0', '2018-05-21 17:40:45', '0', '0', '2018-05-21 17:42:50');
INSERT INTO `ma_order` VALUES ('556', '82', '2018052110586234', '683185', '10000.00', '0', '2018-05-21 21:54:03', '1', '19500', '2018-05-21 22:03:03');
INSERT INTO `ma_order` VALUES ('557', '82', '2018052111530142', '683188', '20000.00', '0', '2018-05-21 22:08:13', '0', '0', '2018-05-21 22:50:54');
INSERT INTO `ma_order` VALUES ('558', '82', '201805225834719', '683238', '1000.00', '1', '2018-05-22 11:25:28', '1', '1950', '2018-05-22 11:34:49');
INSERT INTO `ma_order` VALUES ('559', '82', '2018052294444245', '683243', '100.00', '1', '2018-05-22 11:48:45', '0', '0', '2018-05-22 11:57:29');
INSERT INTO `ma_order` VALUES ('560', '70', '2018052219177051', '683306', '10.00', '1', '2018-05-22 17:05:37', '1', '19.5', '2018-05-22 17:08:30');
INSERT INTO `ma_order` VALUES ('561', '91', '201805232271747', '683421', '20.00', '0', '2018-05-23 11:43:19', '0', '0', '2018-05-23 11:47:56');
INSERT INTO `ma_order` VALUES ('562', '91', '201805232610533', '683422', '20.00', '0', '2018-05-23 11:48:18', '0', '0', '2018-05-23 11:52:56');
INSERT INTO `ma_order` VALUES ('563', '82', '2018052371411698', '683422', '300.00', '1', '2018-05-23 11:49:42', '1', '585', '2018-05-23 11:52:56');
INSERT INTO `ma_order` VALUES ('564', '91', '2018052333610664', '683423', '20.00', '1', '2018-05-23 11:53:12', '1', '39', '2018-05-23 11:57:50');
INSERT INTO `ma_order` VALUES ('565', '91', '2018052329346460', '683424', '20.00', '1', '2018-05-23 11:58:24', '1', '39', '2018-05-23 12:15:32');
INSERT INTO `ma_order` VALUES ('566', '84', '2018052380162167', '683424', '2000.00', '1', '2018-05-23 11:59:19', '1', '3900', '2018-05-23 12:15:32');
INSERT INTO `ma_order` VALUES ('567', '82', '2018052450675484', '683603', '100.00', '0', '2018-05-24 11:59:46', '1', '195', '2018-05-24 12:10:36');
-- ----------------------------
-- Table structure for ma_pay
-- ----------------------------
DROP TABLE IF EXISTS `ma_pay`;
CREATE TABLE `ma_pay` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`user_name` varchar(20) NOT NULL COMMENT '操作用户',
`username` varchar(16) NOT NULL COMMENT '充值用户',
`money` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '充值金额',
`createtime` datetime NOT NULL COMMENT '充值时间',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '默认1充值,0未充值',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='用户充值表';
-- ----------------------------
-- Records of ma_pay
-- ----------------------------
INSERT INTO `ma_pay` VALUES ('7', 'admin123', 'aa1234', '40.00', '2018-04-28 17:58:37', '1');
INSERT INTO `ma_pay` VALUES ('6', 'admin', 'uik11dgf', '54.00', '2018-04-27 17:25:14', '1');
INSERT INTO `ma_pay` VALUES ('8', 'admin123', 'aa1234', '20.00', '2018-05-03 15:55:47', '1');
INSERT INTO `ma_pay` VALUES ('9', 'admin123', 'aa1111', '600.00', '2018-05-04 18:33:37', '1');
INSERT INTO `ma_pay` VALUES ('10', 'admin123', 'ss11111', '500.00', '2018-05-05 09:45:03', '1');
INSERT INTO `ma_pay` VALUES ('11', 'admin123', 'bb1111', '100.00', '2018-05-07 17:01:27', '1');
INSERT INTO `ma_pay` VALUES ('12', 'admin123', 'hm888888', '5000.00', '2018-05-10 15:15:40', '1');
INSERT INTO `ma_pay` VALUES ('13', 'admin123', '258963', '50000.00', '2018-05-10 15:45:30', '1');
INSERT INTO `ma_pay` VALUES ('14', 'admin123', 'hm1235', '10000.00', '2018-05-10 21:45:23', '1');
INSERT INTO `ma_pay` VALUES ('15', 'admin123', 'admig', '50000.00', '2018-05-11 09:42:29', '1');
INSERT INTO `ma_pay` VALUES ('16', 'admin123', 'bb1111', '45.00', '2018-05-14 14:15:16', '1');
INSERT INTO `ma_pay` VALUES ('17', 'hm888888', 'aa888999', '10000.00', '2018-05-14 14:47:32', '1');
INSERT INTO `ma_pay` VALUES ('18', 'admin123', 'bbb111', '500.00', '2018-05-14 14:57:16', '1');
INSERT INTO `ma_pay` VALUES ('19', 'hm888888', 'bb888999', '10000.00', '2018-05-14 15:24:04', '1');
INSERT INTO `ma_pay` VALUES ('20', 'admin123', 'admin', '50000.00', '2018-05-14 17:13:22', '1');
INSERT INTO `ma_pay` VALUES ('21', 'admin123', 'bbb111', '8.00', '2018-05-15 10:37:30', '1');
INSERT INTO `ma_pay` VALUES ('22', 'admin123', 'bbbb11', '500.00', '2018-05-15 11:37:49', '1');
INSERT INTO `ma_pay` VALUES ('23', 'admin123', 'admif', '50000.00', '2018-05-15 13:44:29', '1');
INSERT INTO `ma_pay` VALUES ('24', 'hm888888', 'cc888999', '10000.00', '2018-05-15 17:17:31', '1');
INSERT INTO `ma_pay` VALUES ('25', 'hm888888', 'cc888999', '428.00', '2018-05-16 14:03:19', '1');
INSERT INTO `ma_pay` VALUES ('26', 'hm888888', 'cc888999', '100.00', '2018-05-16 14:03:49', '1');
INSERT INTO `ma_pay` VALUES ('27', 'hm888888', 'bb888999', '704.00', '2018-05-16 14:09:13', '1');
INSERT INTO `ma_pay` VALUES ('28', 'gjtz888', 'cc888999', '-500.00', '2018-05-22 18:06:08', '1');
INSERT INTO `ma_pay` VALUES ('29', 'gjtz888', 'cc888999', '-500.00', '2018-05-22 18:06:56', '1');
INSERT INTO `ma_pay` VALUES ('30', 'gjtz888', 'root11', '10000.00', '2018-05-22 18:09:11', '1');
INSERT INTO `ma_pay` VALUES ('31', 'gjtz888', 'aa1111', '-618.00', '2018-05-22 18:09:55', '1');
INSERT INTO `ma_pay` VALUES ('32', 'gjtz888', 'syp199012', '200.00', '2018-05-23 11:39:40', '1');
-- ----------------------------
-- Table structure for ma_result
-- ----------------------------
DROP TABLE IF EXISTS `ma_result`;
CREATE TABLE `ma_result` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
`qishu` int(10) unsigned NOT NULL COMMENT '开奖期数',
`time` datetime NOT NULL COMMENT '开奖时间',
`ball1` smallint(4) unsigned DEFAULT NULL COMMENT '号码1',
`ball2` smallint(4) unsigned DEFAULT NULL COMMENT '号码2',
`ball3` smallint(4) unsigned DEFAULT NULL COMMENT '号码3',
`ball4` smallint(4) unsigned DEFAULT NULL COMMENT '号码4',
`ball5` smallint(4) unsigned DEFAULT NULL COMMENT '号码5',
`ball6` smallint(4) unsigned DEFAULT NULL COMMENT '号码6',
`ball7` smallint(4) unsigned DEFAULT NULL COMMENT '号码7',
`ball8` smallint(4) unsigned DEFAULT NULL COMMENT '号码8',
`ball9` smallint(4) unsigned DEFAULT NULL COMMENT '号码9',
`ball10` smallint(4) unsigned DEFAULT NULL COMMENT '号码10',
`page` varchar(4) DEFAULT NULL COMMENT '涨和跌',
`status` tinyint(1) unsigned DEFAULT NULL COMMENT '1代表涨,0代表跌',
PRIMARY KEY (`id`),
KEY `qishu` (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=2069 DEFAULT CHARSET=utf8 COMMENT='开奖结果表';
-- ----------------------------
-- Records of ma_result
-- ----------------------------
INSERT INTO `ma_result` VALUES ('75', '677484', '2018-04-20 09:17:00', '7', '8', '2', '10', '4', '5', '3', '9', '1', '6', '涨', '1');
INSERT INTO `ma_result` VALUES ('76', '677486', '2018-04-20 09:27:20', '5', '3', '1', '9', '10', '6', '2', '4', '7', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('77', '677491', '2018-04-20 09:52:20', '5', '6', '2', '4', '1', '10', '8', '9', '3', '7', '跌', '0');
INSERT INTO `ma_result` VALUES ('78', '677545', '2018-04-20 14:22:20', '4', '10', '5', '7', '6', '3', '9', '1', '2', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('79', '677556', '2018-04-20 15:17:20', '5', '6', '10', '9', '7', '3', '2', '8', '1', '4', '跌', '0');
INSERT INTO `ma_result` VALUES ('80', '677663', '2018-04-21 09:17:20', '9', '4', '2', '7', '10', '6', '1', '3', '5', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('81', '677664', '2018-04-21 09:22:20', '9', '1', '10', '2', '5', '3', '6', '7', '4', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('82', '677665', '2018-04-21 09:27:20', '1', '7', '9', '3', '5', '6', '10', '4', '8', '2', '跌', '0');
INSERT INTO `ma_result` VALUES ('83', '677666', '2018-04-21 09:32:20', '10', '9', '6', '7', '4', '2', '8', '1', '3', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('84', '677667', '2018-04-21 09:37:20', '4', '3', '1', '5', '8', '7', '6', '9', '10', '2', '跌', '0');
INSERT INTO `ma_result` VALUES ('85', '677668', '2018-04-21 09:42:20', '3', '9', '2', '1', '10', '4', '8', '5', '6', '7', '跌', '0');
INSERT INTO `ma_result` VALUES ('86', '677669', '2018-04-21 09:47:20', '3', '5', '10', '6', '4', '2', '1', '8', '9', '7', '跌', '0');
INSERT INTO `ma_result` VALUES ('87', '677670', '2018-04-21 09:52:20', '6', '7', '3', '8', '1', '5', '4', '10', '9', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('88', '677671', '2018-04-21 09:57:20', '1', '7', '6', '10', '3', '4', '8', '2', '9', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('89', '677672', '2018-04-21 10:02:20', '2', '1', '4', '5', '9', '10', '8', '3', '6', '7', '跌', '0');
INSERT INTO `ma_result` VALUES ('90', '677673', '2018-04-21 10:07:20', '6', '9', '4', '5', '10', '2', '8', '1', '3', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('91', '677674', '2018-04-21 10:12:20', '7', '5', '2', '6', '3', '8', '1', '4', '9', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('92', '677675', '2018-04-21 10:17:20', '9', '1', '5', '6', '2', '7', '3', '10', '8', '4', '涨', '1');
INSERT INTO `ma_result` VALUES ('93', '677676', '2018-04-21 10:22:20', '6', '4', '9', '10', '7', '3', '2', '5', '8', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('94', '677677', '2018-04-21 10:27:20', '3', '6', '5', '8', '10', '2', '7', '9', '1', '4', '跌', '0');
INSERT INTO `ma_result` VALUES ('95', '677678', '2018-04-21 10:32:20', '2', '3', '8', '9', '4', '10', '7', '6', '5', '1', '跌', '0');
INSERT INTO `ma_result` VALUES ('96', '677679', '2018-04-21 10:37:20', '4', '8', '1', '10', '7', '6', '9', '2', '5', '3', '跌', '0');
INSERT INTO `ma_result` VALUES ('97', '677680', '2018-04-21 10:42:20', '10', '2', '1', '3', '5', '9', '8', '6', '4', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('98', '677681', '2018-04-21 10:47:20', '8', '7', '1', '9', '6', '3', '4', '5', '2', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('99', '677682', '2018-04-21 10:52:20', '9', '7', '3', '10', '4', '8', '6', '1', '2', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('100', '677683', '2018-04-21 10:57:20', '10', '8', '2', '1', '7', '4', '9', '6', '3', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('101', '677684', '2018-04-21 11:02:20', '1', '10', '3', '8', '4', '9', '2', '7', '5', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('102', '677685', '2018-04-21 11:07:20', '7', '8', '5', '2', '10', '4', '6', '1', '3', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('103', '677686', '2018-04-21 11:12:20', '7', '3', '5', '2', '4', '1', '10', '6', '9', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('104', '677687', '2018-04-21 11:17:20', '9', '4', '1', '8', '6', '10', '2', '5', '3', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('105', '677688', '2018-04-21 11:22:20', '7', '8', '1', '6', '9', '5', '4', '2', '10', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('106', '677689', '2018-04-21 11:27:20', '3', '1', '9', '2', '4', '5', '7', '8', '10', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('107', '677690', '2018-04-21 11:32:20', '7', '6', '10', '2', '5', '3', '4', '8', '1', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('108', '677691', '2018-04-21 11:37:20', '10', '6', '8', '1', '5', '3', '4', '2', '9', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('109', '677692', '2018-04-21 11:42:20', '3', '6', '10', '4', '2', '1', '7', '9', '8', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('110', '677693', '2018-04-21 11:47:20', '10', '4', '5', '1', '3', '8', '7', '6', '2', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('111', '677694', '2018-04-21 11:52:20', '3', '7', '1', '4', '6', '2', '9', '10', '8', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('112', '677695', '2018-04-21 11:57:20', '8', '7', '1', '4', '5', '10', '2', '6', '3', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('113', '677696', '2018-04-21 12:02:20', '4', '6', '1', '5', '9', '8', '3', '2', '7', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('114', '677697', '2018-04-21 12:07:20', '2', '5', '4', '7', '9', '10', '6', '8', '1', '3', '跌', '0');
INSERT INTO `ma_result` VALUES ('115', '677698', '2018-04-21 12:12:20', '3', '9', '1', '7', '2', '6', '10', '4', '5', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('116', '677699', '2018-04-21 12:17:20', '4', '7', '5', '8', '2', '10', '1', '9', '3', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('117', '677700', '2018-04-21 12:22:20', '9', '8', '2', '5', '3', '6', '4', '10', '1', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('118', '677701', '2018-04-21 12:27:20', '9', '5', '8', '4', '7', '6', '2', '10', '3', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('119', '677702', '2018-04-21 12:32:20', '2', '1', '6', '9', '4', '10', '5', '7', '3', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('120', '677703', '2018-04-21 12:37:20', '10', '5', '9', '8', '4', '1', '7', '6', '2', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('121', '677704', '2018-04-21 12:42:20', '3', '2', '7', '4', '5', '9', '6', '10', '8', '1', '跌', '0');
INSERT INTO `ma_result` VALUES ('122', '677705', '2018-04-21 12:47:20', '3', '6', '4', '1', '7', '2', '5', '10', '8', '9', '跌', '0');
INSERT INTO `ma_result` VALUES ('123', '677706', '2018-04-21 12:52:20', '6', '7', '8', '1', '9', '10', '5', '2', '4', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('124', '677707', '2018-04-21 12:57:20', '4', '1', '9', '8', '10', '3', '6', '7', '2', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('125', '677708', '2018-04-21 13:02:20', '9', '8', '4', '3', '1', '5', '6', '2', '10', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('126', '677709', '2018-04-21 13:07:20', '7', '10', '4', '1', '9', '2', '6', '5', '3', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('127', '677710', '2018-04-21 13:12:20', '4', '3', '9', '2', '1', '6', '7', '5', '10', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('128', '677711', '2018-04-21 13:17:20', '3', '8', '1', '7', '9', '4', '5', '10', '2', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('129', '677712', '2018-04-21 13:22:20', '6', '9', '5', '7', '3', '8', '2', '1', '10', '4', '涨', '1');
INSERT INTO `ma_result` VALUES ('130', '677713', '2018-04-21 13:27:20', '9', '4', '2', '1', '3', '8', '10', '7', '6', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('131', '677714', '2018-04-21 13:32:20', '6', '2', '4', '1', '10', '9', '3', '7', '8', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('132', '677715', '2018-04-21 13:37:20', '3', '4', '8', '10', '9', '2', '6', '7', '1', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('133', '677716', '2018-04-21 13:42:20', '8', '4', '6', '3', '7', '10', '1', '9', '5', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('134', '677717', '2018-04-21 13:47:20', '1', '7', '9', '10', '8', '2', '6', '4', '5', '3', '跌', '0');
INSERT INTO `ma_result` VALUES ('135', '677718', '2018-04-21 13:52:20', '9', '7', '1', '3', '2', '8', '5', '4', '6', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('136', '677719', '2018-04-21 13:57:20', '4', '10', '6', '9', '1', '8', '2', '7', '3', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('137', '677720', '2018-04-21 14:02:20', '8', '3', '7', '2', '5', '9', '1', '6', '10', '4', '涨', '1');
INSERT INTO `ma_result` VALUES ('138', '677721', '2018-04-21 14:07:20', '1', '4', '7', '3', '9', '2', '5', '8', '6', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('139', '677722', '2018-04-21 14:12:20', '10', '6', '4', '9', '8', '1', '3', '5', '7', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('140', '677723', '2018-04-21 14:17:20', '2', '7', '3', '1', '5', '6', '8', '4', '10', '9', '跌', '0');
INSERT INTO `ma_result` VALUES ('141', '677724', '2018-04-21 14:22:20', '7', '4', '8', '9', '2', '6', '3', '1', '10', '5', '涨', '1');
INSERT INTO `ma_result` VALUES ('142', '677725', '2018-04-21 14:27:20', '2', '10', '4', '3', '8', '1', '9', '7', '5', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('143', '677726', '2018-04-21 14:32:20', '6', '2', '9', '5', '3', '7', '10', '1', '4', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('194', '680816', '2018-05-08 18:27:41', '6', '5', '4', '3', '1', '7', '2', '8', '10', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('195', '680817', '2018-05-08 18:32:44', '4', '2', '9', '3', '5', '8', '7', '10', '6', '1', '跌', '0');
INSERT INTO `ma_result` VALUES ('201', '677727', '2018-05-08 00:00:00', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('202', '680898', '2018-05-09 10:22:38', '1', '2', '10', '4', '9', '6', '7', '5', '3', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('203', '680899', '2018-05-09 10:27:40', '10', '6', '2', '9', '4', '7', '8', '5', '3', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('204', '681087', '2018-05-10 11:12:42', '9', '4', '6', '5', '8', '7', '1', '3', '2', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('205', '681088', '2018-05-10 11:17:46', '10', '8', '6', '5', '9', '1', '2', '4', '7', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('206', '681089', '2018-05-10 11:22:48', '6', '4', '2', '9', '5', '3', '1', '8', '7', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('207', '681090', '2018-05-10 11:27:38', '6', '9', '10', '5', '3', '4', '2', '8', '7', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('208', '681091', '2018-05-10 11:32:46', '9', '1', '6', '10', '5', '8', '7', '4', '3', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('209', '681092', '2018-05-10 11:37:38', '6', '4', '2', '5', '10', '7', '1', '9', '8', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('210', '681093', '2018-05-10 11:42:45', '1', '2', '4', '7', '6', '10', '5', '8', '9', '3', '跌', '0');
INSERT INTO `ma_result` VALUES ('211', '681094', '2018-05-10 11:47:42', '5', '2', '3', '7', '10', '6', '8', '9', '4', '1', '跌', '0');
INSERT INTO `ma_result` VALUES ('212', '681095', '2018-05-10 11:52:42', '4', '3', '5', '9', '2', '7', '8', '6', '1', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('213', '681096', '2018-05-10 11:57:44', '6', '5', '7', '8', '2', '9', '10', '1', '4', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('214', '681097', '2018-05-10 12:02:47', '7', '10', '4', '3', '1', '9', '8', '5', '2', '6', '涨', '1');
INSERT INTO `ma_result` VALUES ('215', '681098', '2018-05-10 12:07:53', '6', '2', '8', '1', '9', '3', '10', '7', '5', '4', '涨', '1');
INSERT INTO `ma_result` VALUES ('216', '681099', '2018-05-10 12:12:45', '10', '7', '6', '1', '5', '8', '9', '3', '4', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('217', '681100', '2018-05-10 12:17:38', '5', '2', '3', '10', '9', '1', '6', '7', '8', '4', '跌', '0');
INSERT INTO `ma_result` VALUES ('218', '681101', '2018-05-10 12:22:40', '1', '4', '5', '10', '6', '3', '8', '7', '9', '2', '跌', '0');
INSERT INTO `ma_result` VALUES ('219', '681102', '2018-05-10 12:27:42', '10', '5', '6', '1', '4', '3', '2', '8', '9', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('220', '681103', '2018-05-10 12:32:42', '1', '9', '6', '7', '10', '8', '4', '2', '3', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('221', '681104', '2018-05-10 12:37:44', '5', '4', '1', '9', '7', '10', '6', '2', '3', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('222', '681105', '2018-05-10 12:42:54', '1', '7', '8', '2', '9', '10', '4', '3', '6', '5', '跌', '0');
INSERT INTO `ma_result` VALUES ('223', '681106', '2018-05-10 12:47:39', '7', '5', '4', '2', '6', '3', '1', '9', '8', '10', '涨', '1');
INSERT INTO `ma_result` VALUES ('224', '681107', '2018-05-10 12:52:39', '4', '1', '10', '2', '7', '5', '6', '9', '3', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('225', '681108', '2018-05-10 12:57:41', '6', '9', '10', '5', '1', '4', '3', '2', '8', '7', '涨', '1');
INSERT INTO `ma_result` VALUES ('226', '681109', '2018-05-10 13:02:53', '6', '10', '5', '2', '7', '3', '1', '4', '9', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('227', '681110', '2018-05-10 13:07:41', '7', '5', '6', '9', '3', '10', '1', '4', '8', '2', '涨', '1');
INSERT INTO `ma_result` VALUES ('228', '681111', '2018-05-10 13:12:43', '4', '1', '10', '7', '8', '2', '3', '9', '5', '6', '跌', '0');
INSERT INTO `ma_result` VALUES ('229', '681112', '2018-05-10 13:17:54', '9', '4', '2', '7', '1', '5', '3', '6', '10', '8', '涨', '1');
INSERT INTO `ma_result` VALUES ('230', '681113', '2018-05-10 13:22:53', '7', '1', '5', '9', '2', '10', '3', '8', '4', '6', '涨', '1');
INSERT INTO `ma_result` VALUES ('231', '681114', '2018-05-10 13:27:35', '10', '7', '3', '6', '2', '5', '8', '4', '1', '9', '涨', '1');
INSERT INTO `ma_result` VALUES ('232', '681115', '2018-05-10 13:32:54', '1', '6', '8', '2', '9', '5', '7', '3', '4', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('233', '681116', '2018-05-10 13:37:42', '7', '10', '9', '8', '1', '5', '4', '2', '3', '6', '涨', '1');
INSERT INTO `ma_result` VALUES ('234', '681117', '2018-05-10 13:42:40', '3', '6', '8', '1', '4', '5', '7', '2', '10', '9', '跌', '0');
INSERT INTO `ma_result` VALUES ('235', '681118', '2018-05-10 13:47:43', '5', '7', '8', '1', '9', '3', '10', '6', '4', '2', '跌', '0');
INSERT INTO `ma_result` VALUES ('236', '681119', '2018-05-10 13:52:39', '2', '9', '1', '6', '4', '5', '7', '10', '3', '8', '跌', '0');
INSERT INTO `ma_result` VALUES ('237', '681120', '2018-05-10 13:57:40', '1', '2', '6', '8', '5', '9', '3', '4', '7', '10', '跌', '0');
INSERT INTO `ma_result` VALUES ('238', '681121', '2018-05-10 14:02:39', '10', '6', '8', '3', '2', '9', '7', '4', '5', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('239', '681122', '2018-05-10 14:07:38', '2', '8', '5', '1', '6', '3', '4', '7', '10', '9', '跌', '0');
INSERT INTO `ma_result` VALUES ('240', '681123', '2018-05-10 14:12:42', '8', '6', '9', '2', '10', '4', '7', '5', '3', '1', '涨', '1');
INSERT INTO `ma_result` VALUES ('241', '681124', '2018-05-10 14:17:51', '9', '6', '10', '7', '4', '1', '5', '8', '2', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('242', '681125', '2018-05-10 14:22:38', '9', '10', '1', '2', '7', '8', '5', '4', '6', '3', '涨', '1');
INSERT INTO `ma_result` VALUES ('243', '681126', '2018-05-10 14:27:43', '10', '7', '1', '2', '4', '9', '3', '8', '5', '6', '涨', '1');
INSERT INTO `ma_result` VALUES ('244', '681127', '2018-05-10 14:32:36', '2', '6', '8', '1', '9', '4', '3', '7', '10', '5',