/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.5.9 : Database - bank
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`bank` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `bank`;

/*Table structure for table `creditcard` */

DROP TABLE IF EXISTS `creditcard`;

CREATE TABLE `creditcard` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `accountNumber` varchar(20) NOT NULL,
  `name` varchar(20) NOT NULL,
  `type` varchar(20) DEFAULT NULL,
  `realName` varchar(20) DEFAULT NULL,
  `idNumber` varchar(20) DEFAULT NULL,
  `pass` varchar(20) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10028 DEFAULT CHARSET=utf8;

/*Data for the table `creditcard` */

insert  into `creditcard`(`id`,`accountNumber`,`name`,`type`,`realName`,`idNumber`,`pass`,`date`) values (10001,'123','梁楷松','普通卡','梁楷松','195487621565','123456','2018-12-25 15:05:40'),(10002,'123','梁楷松','普通卡','123','123','123','2018-12-25 21:18:01'),(10003,'123','梁楷松','金卡','健康','12345679','123','2018-12-25 21:29:43'),(10005,'123','梁楷松','金卡','无法','123123123123123','123','2018-12-25 21:32:56'),(10011,'123','梁楷松','普通卡','请问','1123123123','111','2018-12-25 22:30:36'),(10012,'123','梁楷松','金卡','千瓦时','12312312312312333','123','2018-12-25 22:49:51'),(10015,'123','梁楷松','贷记卡','发发发','请问23123','123','2018-12-25 23:04:53'),(10016,'123','梁楷松','贷记卡','确定','123124123','123','2018-12-27 13:58:57'),(10017,'234','王昭君','金卡','哇哇是','123123123','123','2018-12-27 14:01:22'),(10018,'234','王昭君','准贷记卡','狗蛋','234123','123','2018-12-27 14:26:08'),(10019,'234','王昭君','贷记卡','请问','123123123123','123','2018-12-27 16:32:41'),(10020,'234','王昭君','贷记卡','强无敌','123123123','123','2018-12-27 22:42:02'),(10021,'123','梁楷松','贷记卡','123','123','123','2018-12-28 11:17:21'),(10022,'123','梁楷松','贷记卡','123','123','123','2018-12-28 11:50:23'),(10023,'123','梁楷松','贷记卡','12311','123','123','2019-01-19 22:25:08'),(10024,'234','王昭君','准贷记卡','2222','234','234','2019-05-02 10:02:31'),(10025,'345','莫小梅','准贷记卡','懒得玩','123456789','123','2019-05-06 10:44:25'),(10026,'234','王昭君','贷记卡','wwd','321','123','2019-05-18 09:02:38'),(10027,'123','梁小松','金卡','122','3333211','123','2019-05-18 09:31:03');

/*Table structure for table `cunkuanqvkuan` */

DROP TABLE IF EXISTS `cunkuanqvkuan`;

CREATE TABLE `cunkuanqvkuan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `money` varchar(255) DEFAULT NULL,
  `style` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `yue` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=350 DEFAULT CHARSET=utf8;

/*Data for the table `cunkuanqvkuan` */

insert  into `cunkuanqvkuan`(`id`,`name`,`money`,`style`,`date`,`yue`) values (1,'123','100','1','2018-10-30 22:18:12','5100'),(2,'123','100','0','2018-10-30 22:19:06','5000'),(3,'123','1000','1','2018-11-01 00:02:00','6000'),(4,'123','1000','1','2018-11-01 00:02:42','7000'),(5,'123','1000','1','2018-11-01 00:09:49','8000'),(6,'123','2000','0','2018-11-01 00:09:55','6000'),(7,'123','1000','0','2018-11-01 00:10:00','5000'),(8,'1','100','1','2018-11-01 00:11:15','1000'),(9,'1','999','0','2018-11-01 00:11:52','1'),(10,'1','9999','1','2018-11-01 00:11:59','10000'),(11,'1','500','1','2018-11-01 00:12:05','10500'),(12,'50534','500','1','2018-11-01 00:25:47','600'),(13,'50534','600','0','2018-11-01 00:25:52','0'),(14,'50534','700','1','2018-11-01 00:25:56','700'),(15,'50534','8000','1','2018-11-01 00:26:00','8700'),(16,'50534','1270','0','2018-11-01 00:26:09','7430'),(17,'62294','500','1','2018-11-01 00:30:12','600'),(18,'62294','872','1','2018-11-01 00:30:18','1472'),(19,'62294','227','0','2018-11-01 00:30:25','1245'),(20,'62294','2453','1','2018-11-01 00:30:33','3698'),(21,'62294','2000','0','2018-11-01 00:30:37','1698'),(22,'76077','500','1','2018-11-01 00:41:50','600'),(23,'76077','700','1','2018-11-01 00:41:54','1300'),(24,'76077','50','0','2018-11-01 00:41:57','1250'),(25,'76077','70','0','2018-11-01 00:42:01','1180'),(26,'76077','605','1','2018-11-01 00:42:05','1785'),(27,'87554','4500','1','2018-11-01 00:46:13','4600'),(28,'87554','3000','0','2018-11-01 00:46:21','1600'),(29,'123','4000','1','2018-11-01 19:25:19','9000'),(30,'123','2000','0','2018-11-01 19:25:23','7000'),(31,'123','100','1','2018-11-01 19:25:42','7100'),(32,'123','555','0','2018-11-01 19:25:46','6545'),(33,'123','42','1','2018-11-01 19:25:55','6587'),(34,'123','100','1','2018-11-01 20:37:54','6687'),(35,'123','100','1','2018-11-01 20:37:59','6787'),(36,'123','100','1','2018-11-01 20:38:16','6887'),(37,'123','100','1','2018-11-01 20:38:22','6987'),(38,'123','100','1','2018-11-01 20:38:26','7087'),(39,'123456','999','1','2018-11-01 21:27:12','1998'),(40,'123456','555','1','2018-11-01 21:27:18','2553'),(41,'123456','400','1','2018-11-01 21:27:23','2953'),(42,'123456','325','1','2018-11-01 21:27:27','3278'),(43,'123456','846','1','2018-11-01 21:27:32','4124'),(44,'123456','1000','0','2018-11-01 21:27:38','3124'),(45,'123456','200','0','2018-11-01 21:27:42','2924'),(46,'123456','1000','1','2018-11-01 21:27:53','3924'),(47,'74245','4455','1','2018-11-01 21:30:02','4555'),(48,'74245','0','1','2018-11-01 21:30:06','4555'),(49,'74245','11','1','2018-11-01 21:30:09','4566'),(50,'74245','2','1','2018-11-01 21:30:13','4568'),(51,'74245','4040','1','2018-11-01 21:30:15','8608'),(52,'74245','453','0','2018-11-01 21:30:19','8155'),(53,'74245','1234','0','2018-11-01 21:30:23','6921'),(54,'74245','10999','1','2018-11-01 21:32:27','17920'),(55,'74245','50000','1','2018-11-01 21:32:35','67920'),(56,'74245','12654','0','2018-11-01 21:32:42','55266'),(57,'74245','235460','1','2018-11-01 21:35:11','290726'),(58,'74245','66644454','1','2018-11-01 21:35:29','66935180'),(59,'74245','1001000','0','2018-11-01 21:35:59','65934180'),(60,'74245','10001000','0','2018-11-01 21:36:13','55933180'),(61,'65319','123','1','2018-11-01 23:33:07','223'),(62,'65319','1234','1','2018-11-01 23:33:17','1457'),(63,'65319','12345','1','2018-11-01 23:33:23','13802'),(64,'65319','2345','0','2018-11-01 23:33:36','11457'),(65,'65319','1234','0','2018-11-01 23:33:41','10223'),(66,'123','2000','1','2018-11-02 00:05:54','9087'),(67,'123','453453','1','2018-11-02 12:33:01','462540'),(68,'123','422101','0','2018-11-02 12:33:10','40439'),(69,'123','400000','1','2018-11-02 12:33:17','440439'),(70,'123','5000000','1','2018-11-02 12:33:20','5440439'),(71,'123','2222','0','2018-11-02 12:33:28','5438217'),(72,'123','222222','0','2018-11-02 12:33:31','5215995'),(73,'123','2222222','0','2018-11-02 12:33:37','2993773'),(74,'123','100','1','2018-11-02 12:33:41','2993873'),(75,'123','2222222','0','2018-11-02 12:33:50','771651'),(76,'123','5000000','0','2018-11-02 12:33:56','-4228349'),(77,'123','5000000','1','2018-11-02 12:34:04','771651'),(78,'123','400000','1','2018-11-02 12:34:10','1171651'),(79,'123','1000000','0','2018-11-02 12:34:14','171651'),(80,'123','20000','0','2018-11-02 12:34:21','151651'),(81,'123','100000','0','2018-11-02 12:34:27','51651'),(82,'123','453','1','2018-11-03 09:35:45','52104'),(83,'123','4555','0','2018-11-03 09:36:06','47549'),(84,'123','1','1','2018-11-03 09:43:14','47550'),(85,'123','50','1','2018-11-03 09:43:21','47600'),(86,'123','400','1','2018-11-03 09:43:26','48000'),(87,'123','2000','1','2018-11-03 09:43:31','50000'),(88,'123','10000','0','2018-11-03 09:43:40','40000'),(89,'28495','100','1','2018-11-03 10:07:37','100'),(90,'28495','400','1','2018-11-03 10:08:47','500'),(91,'28495','5000','1','2018-11-03 10:09:12','5500'),(92,'28495','1000','0','2018-11-03 10:09:28','4500'),(93,'123','2000','1','2018-11-03 10:10:23','42000'),(94,'123','5000','1','2018-11-03 10:15:56','47000'),(95,'123','7000','0','2018-11-03 10:16:02','40000'),(96,'67420','100','1','2018-11-03 10:17:41','100'),(97,'67420','4000','1','2018-11-03 10:18:31','4100'),(98,'67420','200','0','2018-11-03 10:18:39','3900'),(99,'67420','500','1','2018-11-03 10:18:45','4400'),(100,'67420','4000','0','2018-11-03 10:18:48','400'),(101,'123','10000','1','2018-11-03 10:19:06','50000'),(102,'67420','5000','1','2018-11-03 10:19:14','5400'),(103,'67420','4000','0','2018-11-03 10:19:19','1400'),(104,'123','40000','0','2018-11-03 10:19:26','10000'),(105,'123','5000','0','2018-11-03 10:19:30','5000'),(106,'85332','100','1','2018-11-03 10:23:59','100'),(107,'123456','3333','1','2018-11-03 10:34:30','7257'),(108,'123456','32','1','2018-11-03 10:34:33','7289'),(109,'123456','4','1','2018-11-03 10:34:39','7293'),(110,'123456','7','1','2018-11-03 10:34:45','7300'),(111,'123456','700','1','2018-11-03 10:34:49','8000'),(112,'1','12000','1','2018-11-03 10:35:23','22500'),(113,'1','120','1','2018-11-03 10:35:30','22620'),(114,'1','500','0','2018-11-03 10:35:36','22120'),(115,'1','3000','0','2018-11-03 10:35:41','19120'),(116,'1','8000','0','2018-11-03 10:35:46','11120'),(117,'1','4000','0','2018-11-03 10:35:49','7120'),(118,'1','5300','1','2018-11-03 10:35:55','12420'),(119,'1','8000','0','2018-11-03 10:35:59','4420'),(120,'1','20','0','2018-11-03 10:36:02','4400'),(121,'1','600','1','2018-11-03 10:36:06','5000'),(122,'123456','1200','1','2018-11-03 10:36:19','9200'),(123,'123456','5000','0','2018-11-03 10:36:26','4200'),(124,'10622','100','1','2018-11-03 11:24:18','100'),(125,'10622','10622','1','2018-11-03 11:28:34','10722'),(126,'10622','555','0','2018-11-03 11:28:46','10167'),(127,'10622','8000','0','2018-11-03 11:28:59','2167'),(128,'64655','100','1','2018-11-03 20:20:29','100'),(129,'64493','100','1','2018-11-03 20:20:44','100'),(130,'64655','1000','1','2018-11-03 20:24:14','1100'),(131,'64655','800','0','2018-11-03 20:25:12','300'),(132,'123','5000','1','2018-11-05 19:43:07','10000'),(133,'123','555','1','2018-11-05 19:46:04','10555'),(134,'123','5000','0','2018-11-05 19:46:22','5555'),(135,'123','333','1','2018-11-05 20:16:35','5888'),(136,'123','222','1','2018-11-05 20:16:39','6110'),(137,'123','111','0','2018-11-05 20:16:46','5999'),(138,'123456','456','0','2018-11-05 20:17:23','3744'),(139,'123456','555','0','2018-11-05 20:17:28','3189'),(140,'123456','555','0','2018-11-05 20:17:31','2634'),(141,'123456','111','0','2018-11-05 20:17:35','2523'),(142,'123456','1111','0','2018-11-05 20:17:39','1412'),(143,'123456','2','0','2018-11-05 20:17:42','1410'),(144,'123456','10','1','2018-11-05 20:17:49','1420'),(145,'123456','20','0','2018-11-05 20:17:54','1400'),(146,'123456','600','1','2018-11-05 20:17:59','2000'),(147,'123','12','1','2018-11-05 22:38:57','6011'),(148,'123','12','0','2018-11-05 22:39:00','5999'),(149,'123','50','1','2018-11-05 22:39:08','6049'),(150,'123','30','0','2018-11-05 22:39:13','6019'),(151,'123','50','0','2018-11-05 22:39:17','5969'),(152,'123','1000','0','2018-11-05 22:39:24','4969'),(153,'123','1500','1','2018-11-05 22:39:29','6469'),(154,'123','1300','0','2018-11-05 22:39:34','5169'),(155,'123','5000','0','2018-11-05 22:57:20','169'),(156,'123','100','0','2018-11-05 22:57:25','69'),(157,'123','50','0','2018-11-05 22:57:29','19'),(158,'123','12','0','2018-11-05 22:57:33','7'),(159,'123','3','1','2018-11-05 22:57:39','10'),(160,'123','2','1','2018-11-05 22:57:43','12'),(161,'123','15','1','2018-11-05 22:57:46','27'),(162,'123','23','1','2018-11-05 22:57:50','50'),(163,'123','50','1','2018-11-05 22:57:53','100'),(164,'123','40','1','2018-11-05 22:57:56','140'),(165,'123','70','0','2018-11-05 22:58:00','70'),(166,'123','50','0','2018-11-05 22:58:12','20'),(167,'123','11','0','2018-11-05 22:58:16','9'),(168,'123','5','0','2018-11-05 22:58:21','4'),(169,'123','500','1','2018-11-05 22:58:27','504'),(170,'123','4000','1','2018-11-05 22:58:31','4504'),(171,'123','552','1','2018-11-13 21:17:04','5056'),(172,'123','52','1','2018-11-13 21:17:08','5108'),(173,'123','12','1','2018-11-13 21:17:13','5120'),(174,'123','500','1','2018-11-13 21:17:19','5620'),(175,'123','400','1','2018-11-13 21:17:25','6020'),(176,'123','20','0','2018-11-13 21:17:28','6000'),(177,'123','555552','1','2018-11-14 15:11:00','561552'),(178,'123','444444','1','2018-11-14 15:11:12','1005996'),(179,'123','200000','1','2018-11-14 15:11:18','1205996'),(180,'123','1200000','0','2018-11-14 15:11:26','5996'),(181,'23160','100','1','2018-11-14 17:51:05','100'),(182,'123','500','1','2018-11-15 13:04:08','6496'),(183,'123','200','0','2018-11-15 13:04:24','5796'),(184,'123','500','0','2018-11-15 13:04:47','5296'),(185,'123','500','1','2018-11-15 13:05:00','6996'),(186,'123','1000','1','2018-11-16 00:12:31','7996'),(187,'123','799','1','2018-11-16 00:20:49','8795'),(188,'123','585','1','2018-11-16 00:21:39','9380'),(189,'123','5000','0','2018-11-16 00:21:47','4380'),(190,'123','4000','0','2018-11-16 00:21:57','380'),(191,'123','200','1','2018-11-16 00:22:06','580'),(192,'123','411','1','2018-11-18 21:54:27','991'),(193,'123','100','1','2018-11-18 22:59:03','1091'),(194,'123','100','0','2018-11-18 22:59:07','991'),(195,'123','100','0','2018-11-18 22:59:14','891'),(196,'123','100','0','2018-11-18 22:59:19','791'),(197,'123','100','0','2018-11-18 22:59:44','691'),(198,'123','50','0','2018-11-18 22:59:48','641'),(199,'123','50','0','2018-11-18 22:59:52','591'),(200,'123','100','1','2018-11-18 23:11:23','691'),(201,'123','100','1','2018-11-18 23:11:39','791'),(202,'123','100','1','2018-11-18 23:12:39','791'),(203,'123','100','1','2018-11-18 23:12:43','791'),(204,'123','200','1','2018-11-18 23:13:30','791'),(211,'123','200','0','2018-11-18 23:18:53','591'),(212,'123','100','0','2018-11-18 23:18:58','491'),(214,'123','100','1','2018-11-18 23:29:48','591'),(215,'123','100','0','2018-11-18 23:29:57','491'),(216,'123','100','0','2018-11-18 23:30:04','391'),(217,'123','100','1','2018-11-18 23:43:02','491'),(218,'123','200','0','2018-11-18 23:43:07','291'),(219,'123','200','1','2018-11-18 23:43:11','491'),(220,'123','500','1','2018-11-18 23:43:25','991'),(221,'123','50','0','2018-11-18 23:46:29','941'),(222,'123','5','0','2018-11-18 23:46:35','936'),(223,'123','40','0','2018-11-18 23:46:40','896'),(224,'123','500','0','2018-11-18 23:47:13','396'),(225,'123','123','1','2018-11-19 19:51:09','519'),(226,'123','100','1','2018-11-19 21:32:18','619'),(227,'123','100','1','2018-11-19 21:32:22','719'),(228,'21494','100','1','2018-11-19 22:33:10','100'),(229,'48386','100','1','2018-11-19 23:02:03','100'),(230,'72768','100','1','2018-11-19 23:26:30','100'),(231,'123','300','0','2018-11-20 00:41:47','419'),(232,'123','100','1','2018-11-20 00:41:56','519'),(233,'123','100','1','2018-11-20 00:42:00','619'),(234,'123','200','1','2018-11-20 00:44:30','819'),(235,'123','70','1','2018-11-20 08:32:35','889'),(236,'123','500','0','2018-11-20 08:32:52','389'),(237,'20456','100','1','2018-11-20 09:50:45','100'),(238,'20456','100','1','2018-11-20 09:51:59','200'),(239,'123','500','1','2018-12-21 14:30:49','889'),(240,'123','123','1','2018-12-25 21:12:47','1012'),(241,'123','10','1','2018-12-27 11:45:26','1022'),(242,'123','100','1','2018-12-27 11:45:36','1122'),(243,'123','200','1','2018-12-27 11:45:39','1322'),(244,'123','1000','0','2018-12-27 11:45:46','322'),(245,'123','100','1','2018-12-27 11:45:54','422'),(246,'123','600','1','2018-12-27 11:45:57','1022'),(247,'234','100','1','2018-12-27 14:02:29','200'),(248,'234','500','1','2018-12-27 14:02:49','700'),(249,'234','400','0','2018-12-27 14:02:54','300'),(250,'234','300','0','2018-12-27 14:03:07','0'),(251,'234','200','1','2018-12-27 14:03:26','200'),(252,'234','100','1','2018-12-27 14:49:00','300'),(253,'234','10','1','2018-12-27 14:49:04','310'),(254,'234','300','0','2018-12-27 14:49:09','10'),(255,'234','10','1','2018-12-27 14:49:11','20'),(256,'234','10','0','2018-12-27 14:49:16','10'),(257,'234','10','0','2018-12-27 14:49:19','0'),(258,'234','400','1','2018-12-27 14:49:24','400'),(259,'234','20','0','2018-12-27 14:49:27','380'),(260,'234','10','1','2018-12-27 14:49:38','390'),(261,'234','30','1','2018-12-27 14:49:42','420'),(262,'234','50','1','2018-12-27 14:49:44','470'),(263,'234','400','1','2018-12-27 14:49:48','870'),(264,'234','200','1','2018-12-27 14:49:51','1070'),(265,'234','12','1','2018-12-27 14:49:53','1082'),(266,'234','1000','0','2018-12-27 14:49:56','82'),(267,'234','100','1','2018-12-27 16:29:51','182'),(268,'234','500','1','2018-12-27 16:30:29','682'),(269,'123','50','1','2018-12-27 17:29:39','1072'),(270,'123','1000','0','2018-12-27 17:30:16','72'),(271,'234','200','1','2018-12-27 22:39:48','2515'),(272,'234','100','0','2018-12-27 22:40:10','2415'),(273,'60655','100','1','2018-12-28 09:07:11','100'),(274,'60655','500','1','2018-12-28 09:14:52','600'),(275,'61914','100','1','2018-12-28 10:45:58','100'),(276,'61914','100','0','2018-12-28 10:47:08','0'),(277,'123','500','1','2018-12-28 11:19:30','1512'),(278,'123','100','1','2018-12-28 11:19:53','1612'),(279,'123','1000','0','2018-12-28 11:21:20','612'),(280,'123','100','1','2018-12-28 11:44:30','712'),(281,'123','500','1','2018-12-28 11:44:46','1212'),(282,'123','100','1','2018-12-28 11:45:14','1312'),(283,'123','1000','0','2018-12-28 11:45:23','312'),(284,'79321','100','1','2019-01-06 01:42:37','100'),(285,'123','500','1','2019-01-19 22:17:39','812'),(286,'123','100','0','2019-01-19 22:17:56','712'),(287,'123','100','1','2019-04-01 14:11:05','812'),(288,'123456','1000','0','2019-04-08 00:35:33','1000'),(289,'123456','200','1','2019-04-08 00:35:44','1200'),(290,'123','100','0','2019-04-08 13:18:53','712'),(291,'123','200','0','2019-04-08 13:23:34','512'),(292,'123','100','1','2019-04-08 13:28:47','612'),(293,'123','100','1','2019-04-08 13:28:56','712'),(294,'123','100','1','2019-04-08 13:29:02','812'),(295,'123','50','1','2019-04-08 15:43:17','862'),(296,'123','50','1','2019-04-08 17:19:44','912'),(297,'123','500','0','2019-04-08 17:19:59','412'),(298,'234','100','1','2019-05-01 23:43:51','2515'),(299,'234','1002','0','2019-05-01 23:44:01','1513'),(300,'123','500','1','2019-05-02 01:15:58','912'),(301,'123','300','0','2019-05-02 01:16:16','612'),(302,'234','1000','1','2019-05-05 00:53:37','2513'),(303,'234','2500','0','2019-05-05 00:53:44','13'),(304,'234','3000','1','2019-05-05 00:53:50','3013'),(305,'234','1500','0','2019-05-05 00:54:07','1513'),(306,'234','500','1','2019-05-05 00:54:25','2013'),(307,'234','2000','0','2019-05-05 00:54:31','13'),(308,'345','500','1','2019-05-06 10:45:03','600'),(309,'345','700','1','2019-05-06 10:45:18','1300'),(310,'345','1000','0','2019-05-06 10:45:31','300'),(311,'456','500','0','2019-05-06 10:46:28','700'),(312,'456','600','0','2019-05-06 10:46:34','100'),(313,'456','2000','1','2019-05-06 10:46:53','2100'),(314,'567','4000','0','2019-05-06 10:47:57','100'),(315,'567','2000','1','2019-05-06 10:48:02','2100'),(316,'567','2000','1','2019-05-06 10:48:12','4100'),(317,'567','4000','0','2019-05-06 10:48:20','100'),(318,'567','50','0','2019-05-06 10:48:27','50'),(319,'567','100','1','2019-05-06 10:48:34','150'),(320,'567','500','1','2019-05-06 10:48:39','650'),(321,'567','200','1','2019-05-06 10:56:11','850'),(322,'567','200','1','2019-05-06 10:56:30','1050'),(323,'123','400','1','2019-05-08 00:03:10','1012'),(324,'44285','100','1','2019-05-10 23:23:12','100'),(325,'123','500','0','2019-05-11 22:38:44','512'),(326,'123','1600','1','2019-05-11 22:39:15','2112'),(327,'123','1000','0','2019-05-11 22:39:28','1112'),(328,'234','3000','1','2019-05-12 13:05:15','3013'),(329,'234','3000','0','2019-05-12 13:05:28','13'),(330,'123','1000','1','2019-05-12 13:31:00','2112'),(331,'123','20','1','2019-05-12 13:31:03','2132'),(332,'123','40','1','2019-05-12 13:31:07','2172'),(333,'123','20','1','2019-05-12 13:39:31','2192'),(334,'123','500','1','2019-05-12 13:39:47','2692'),(335,'123','2500','0','2019-05-12 13:39:56','192'),(336,'123','2600','1','2019-05-12 13:46:46','2792'),(337,'34990','100','1','2019-05-13 09:19:41','100'),(338,'54298','100','1','2019-05-13 12:26:14','100'),(339,'17032','100','1','2019-05-16 00:54:11','100'),(340,'50794','100','1','2019-05-16 00:57:20','100'),(341,'99581','100','1','2019-05-16 08:02:22','100'),(342,'63480','100','1','2019-05-16 20:29:36','100'),(343,'234','3500','1','2019-05-17 21:56:08','3513'),(344,'123','1020','0','2019-05-18 08:46:50','1772'),(345,'234','3500','0','2019-05-18 08:51:35','13'),(346,'234','10','1','2019-05-18 08:51:59','23'),(347,'234','2020','1','2019-05-18 08:59:34','2043'),(348,'234','1010','0','2019-05-18 08:59:43','1033'),(349,'234','1000','0','2019-05-18 08:59:48','33');

/*Table structure for table `invest` */

DROP TABLE IF EXISTS `invest`;

CREATE TABLE `invest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invest_username` varchar(255) NOT NULL,
  `product_name` varchar(11) NOT NULL,
  `money` double NOT NULL,
  `invest_date` datetime NOT NULL,
  `month` int(11) NOT NULL,
  `end_time` datetime NOT NULL,
  `after_money` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10012 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='投资理财表';

/*Data for the table `invest` */

insert  into `invest`(`id`,`invest_username`,`product_name`,`money`,`invest_date`,`month`,`end_time`,`after_money`) values (10001,'123','劲松金融',200,'2019-05-07 08:52:38',1,'2019-06-07 08:52:38',300),(10002,'123','劲松金融',123,'2019-05-07 14:29:47',1,'2019-06-07 14:29:47',129.15),(10003,'345','劲松金融',1200,'2019-05-07 14:31:37',12,'2020-05-07 14:31:37',1920),(10004,'123','劲松金融',222,'2019-05-08 00:53:03',1,'2019-06-08 00:53:03',233.1),(10005,'123','劲松金融',500,'2019-05-08 11:30:20',10,'2020-03-08 11:30:20',750),(10006,'567','劲松金融',200,'2019-05-11 10:46:21',2,'2019-07-11 10:46:21',220),(10007,'234','长期债券',100,'2019-05-17 21:55:10',2,'2019-07-17 21:55:10',120),(10008,'234','长期存款',20,'2019-05-17 21:55:27',1,'2019-06-17 21:55:27',22),(10009,'234','中期债券',20,'2019-05-17 21:57:01',2,'2019-07-17 21:57:01',23.2),(10010,'234','理财基金',400,'2019-05-18 09:00:22',2,'2019-07-18 09:00:22',440),(10011,'234','发展资本',200,'2019-05-18 09:01:20',1,'2019-06-18 09:01:20',240);

/*Table structure for table `login_record` */

DROP TABLE IF EXISTS `login_record`;

CREATE TABLE `login_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `user_roles` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `login_IP` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `user_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `login_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10079 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='登录记录表';

/*Data for the table `login_record` */

insert  into `login_record`(`id`,`login_username`,`user_roles`,`login_IP`,`user_status`,`login_time`) values (10001,'123','普通用户','192.168.163.1','正常','2019-05-01 02:13:51'),(10002,'234','普通用户','140.243.219.186','正常','2019-05-07 01:14:32'),(10003,'234','普通用户','117.28.129.71','正常','2019-05-07 07:59:19'),(10004,'234','普通用户','117.28.129.71','正常','2019-05-07 08:10:23'),(10005,'234','普通用户','117.28.129.71','正常','2019-05-07 12:48:25'),(10006,'123','普通用户','117.28.129.71','异常','2019-05-07 13:14:12'),(10007,'345','普通用户','117.28.129.71','正常','2019-05-07 13:18:28'),(10008,'123','游客','117.28.129.71','正常','2019-05-07 13:19:15'),(10009,'123','普通用户','117.28.129.71','正常','2019-05-07 13:22:12'),(10010,'234','管理员','117.28.129.71','正常','2019-05-07 13:22:22'),(10011,'123','普通用户','117.28.129.71','正常','2019-05-07 14:25:43'),(10012,'123','普通用户','117.28.129.71','正常','2019-05-07 14:27:18'),(10013,'123','普通用户','117.28.129.71','正常','2019-05-07 14:29:36'),(10014,'345','普通用户','117.28.129.71','正常','2019-05-07 14:31:23'),(10015,'123','普通用户','117.28.129.71','正常','2019-05-07 22:59:35'),(10016,'123','普通用户','140.243.105.178','正常','2019-05-07 23:27:37'),(10017,'123','普通用户','140.243.105.178','正常','2019-05-07 23:27:43'),(10018,'123','普通用户','140.243.105.178','正常','2019-05-07 23:36:07'),(10019,'123','普通用户','140.243.105.178','正常','2019-05-07 23:37:54'),(10020,'123','普通用户','140.243.105.178','正常','2019-05-07 23:41:30'),(10021,'123','普通用户','140.243.105.178','正常','2019-05-07 23:56:41'),(10022,'123','普通用户','140.243.105.178','正常','2019-05-08 00:02:55'),(10023,'123','普通用户','140.243.105.178','正常','2019-05-08 00:52:45'),(10024,'123','普通用户','140.243.105.178','正常','2019-05-08 00:53:48'),(10025,'123','普通用户','117.28.128.233','正常','2019-05-08 11:27:28'),(10026,'123','普通用户','117.28.128.233','正常','2019-05-08 11:29:48'),(10027,'123','普通用户','117.28.128.233','正常','2019-05-08 11:32:54'),(10028,'123','普通用户','117.28.128.233','正常','2019-05-08 15:53:02'),(10029,'123','普通用户','117.28.128.233','正常','2019-05-08 15:54:48'),(10030,'123','普通用户','117.28.128.233','正常','2019-05-08 15:55:59'),(10031,'123','普通用户','117.28.128.233','正常','2019-05-08 15:56:55'),(10032,'234','普通用户','140.243.105.178','正常','2019-05-08 23:26:14'),(10033,'123','普通用户','127.0.0.1','正常','2019-05-10 23:24:59'),(10034,'234','普通用户','127.0.0.1','正常','2019-05-10 23:25:06'),(10035,'456','普通用户','127.0.0.1','正常','2019-05-10 23:25:15'),(10036,'456','普通用户','127.0.0.1','正常','2019-05-10 23:38:32'),(10037,'123','普通用户','127.0.0.1','正常','2019-05-10 23:38:45'),(10038,'567','普通用户','127.0.0.1','正常','2019-05-11 10:45:12'),(10039,'123','普通用户','127.0.0.1','正常','2019-05-11 22:38:07'),(10040,'234','普通用户','127.0.0.1','正常','2019-05-12 13:05:03'),(10041,'123','普通用户','127.0.0.1','正常','2019-05-12 13:19:20'),(10042,'123','普通用户','127.0.0.1','正常','2019-05-12 13:24:04'),(10043,'123','普通用户','127.0.0.1','正常','2019-05-12 13:30:40'),(10044,'123','普通用户','127.0.0.1','正常','2019-05-12 13:39:04'),(10045,'123','普通用户','127.0.0.1','正常','2019-05-12 13:53:01'),(10046,'123','普通用户','127.0.0.1','正常','2019-05-13 09:19:00'),(10047,'234','普通用户','127.0.0.1','正常','2019-05-13 09:19:06'),(10048,'34990','普通用户','127.0.0.1','正常','2019-05-13 09:19:53'),(10049,'54298','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-13 12:26:32'),(10050,'234','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-13 18:16:57'),(10051,'234','普通用户','110.80.51.113','正常','2019-05-13 21:08:59'),(10052,'456','普通用户','110.80.51.113','正常','2019-05-13 21:09:12'),(10053,'567','普通用户','110.80.51.113','正常','2019-05-13 21:09:39'),(10054,'123','普通用户','110.80.51.113','正常','2019-05-13 21:09:48'),(10055,'234','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-13 22:01:35'),(10056,'234','普通用户','110.80.51.113','正常','2019-05-13 22:01:52'),(10057,'456','普通用户','110.80.51.113','正常','2019-05-13 22:02:02'),(10058,'99581','普通用户','127.0.0.1','正常','2019-05-16 08:02:34'),(10059,'63480','普通用户','127.0.0.1','正常','2019-05-16 20:55:36'),(10060,'234','普通用户','127.0.0.1','正常','2019-05-17 21:54:14'),(10061,'123','普通用户','127.0.0.1','正常','2019-05-18 08:46:29'),(10062,'234','普通用户','127.0.0.1','正常','2019-05-18 08:51:24'),(10063,'234','普通用户','127.0.0.1','正常','2019-05-18 08:59:10'),(10064,'123','普通用户','127.0.0.1','正常','2019-05-18 09:10:08'),(10065,'123','普通用户','127.0.0.1','正常','2019-05-18 09:10:13'),(10066,'123','普通用户','127.0.0.1','正常','2019-05-18 09:11:42'),(10067,'123','普通用户','127.0.0.1','正常','2019-05-18 09:11:49'),(10068,'123','普通用户','127.0.0.1','正常','2019-05-18 09:12:21'),(10069,'123','普通用户','127.0.0.1','正常','2019-05-18 09:12:28'),(10070,'123','普通用户','127.0.0.1','正常','2019-05-18 09:12:34'),(10071,'234','普通用户','127.0.0.1','正常','2019-05-18 09:13:25'),(10072,'123','普通用户','127.0.0.1','正常','2019-05-18 09:18:18'),(10073,'123','普通用户','127.0.0.1','正常','2019-05-18 09:21:17'),(10074,'123','普通用户','127.0.0.1','正常','2019-05-18 09:21:18'),(10075,'123','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-18 09:22:11'),(10076,'123','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-18 09:22:12'),(10077,'123','普通用户','0:0:0:0:0:0:0:1','正常','2019-05-18 09:26:44'),(10078,'123','普通用户','117.28.130.84','正常','2019-05-18 09:30:32');

/*Table structure for table `mainpost` */

DROP TABLE IF EXISTS `mainpost`;

CREATE TABLE `mainpost` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `classification_category` varchar(255) DEFAULT NULL COMMENT '文章类别',
  `text` varchar(255) DEFAULT NULL COMMENT '正文',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10002 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='正文表';

/*Data for the table `mainpost` */

insert  into `mainpost`(`id`,`name`,`title`,`classification_category`,`text`) values (10001,'123','这是标题哦',NULL,'文本内容我随便写写');

/*Table structure for table `messages_record` */

DROP TABLE IF EXISTS `messages_record`;

CREATE TABLE `messages_record` (
  `m_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `m_PostMessages` varchar(1000) CHARACTER SET utf8 NOT NULL COMMENT '消息内容(最长1000)',
  `m_status` varchar(20) CHARACTER SET utf8 NOT NULL COMMENT '接收状态(接收/未接收)',
  `m_Time` datetime NOT NULL COMMENT '发送时间(当前时间)',
  `m_MessagesType` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '消息类型(个人/群)',
  `m_ FromUserID` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '发送者ID(指向用户表)',
  `m_ToUserID` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '接收者ID(指向用户表)',
  PRIMARY KEY (`m_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=100003 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC COMMENT='用户消息记录表';

/*Data for the table `messages_record` */

insert  into `messages_record`(`m_ID`,`m_PostMessages`,`m_status`,`m_Time`,`m_MessagesType`,`m_ FromUserID`,`m_ToUserID`) values (100001,'你好','接收','2019-05-18 07:05:50','个人','123','234'),(100002,'你叫什么名字','未接收','2019-05-18 10:24:57','个人','234','123');

/*Table structure for table `moneylist` */

DROP TABLE IF EXISTS `moneylist`;

CREATE TABLE `moneylist` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `style` varchar(255) DEFAULT NULL,
  `value` double DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `cash` double DEFAULT NULL,
  `source` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=217 DEFAULT CHARSET=utf8;

/*Data for the table `moneylist` */

insert  into `moneylist`(`id`,`name`,`style`,`value`,`date`,`cash`,`source`) values (1,'123','收入',100,'2018-12-27 11:45:29',174,'快速赚钱'),(2,'123','收入',100,'2018-12-27 11:45:31',274,'快速赚钱'),(3,'123','收入',100,'2018-12-27 11:45:32',374,'快速赚钱'),(4,'123','收入',100,'2018-12-27 11:45:33',474,'快速赚钱'),(5,'123','收入',100,'2018-12-27 11:45:41',274,'快速赚钱'),(6,'123','收入',100,'2018-12-27 11:45:42',374,'快速赚钱'),(7,'123','消费',200,'2018-12-27 11:45:47',1174,'快速花钱'),(8,'123','消费',200,'2018-12-27 11:45:48',974,'快速花钱'),(9,'123','消费',200,'2018-12-27 11:45:49',774,'快速花钱'),(10,'234','收入',100,'2018-12-27 14:02:32',100,'快速赚钱'),(11,'234','收入',100,'2018-12-27 14:02:36',200,'快速赚钱'),(12,'234','收入',100,'2018-12-27 14:02:38',300,'快速赚钱'),(13,'234','收入',100,'2018-12-27 14:02:41',400,'快速赚钱'),(14,'234','收入',100,'2018-12-27 14:02:43',500,'快速赚钱'),(15,'234','消费',200,'2018-12-27 14:03:01',200,'快速花钱'),(16,'234','消费',200,'2018-12-27 14:03:10',300,'快速花钱'),(17,'234','消费',200,'2018-12-27 14:03:12',100,'快速花钱'),(18,'234','收入',100,'2018-12-27 14:03:15',200,'快速赚钱'),(19,'234','收入',100,'2018-12-27 14:03:18',300,'快速赚钱'),(20,'234','收入',100,'2018-12-27 14:03:21',400,'快速赚钱'),(21,'234','存款',100,'2018-12-27 14:49:00',100,'存入余额'),(22,'234','存款',10,'2018-12-27 14:49:04',90,'存入余额'),(23,'234','取款',300,'2018-12-27 14:49:09',390,'余额取出'),(24,'234','存款',10,'2018-12-27 14:49:11',380,'存入余额'),(25,'234','取款',10,'2018-12-27 14:49:16',390,'余额取出'),(26,'234','取款',10,'2018-12-27 14:49:19',400,'余额取出'),(27,'234','存款',400,'2018-12-27 14:49:24',0,'存入余额'),(28,'234','取款',20,'2018-12-27 14:49:27',20,'余额取出'),(29,'234','收入',100,'2018-12-27 14:49:30',120,'快速赚钱'),(30,'234','收入',100,'2018-12-27 14:49:31',220,'快速赚钱'),(31,'234','收入',100,'2018-12-27 14:49:32',320,'快速赚钱'),(32,'234','收入',100,'2018-12-27 14:49:33',420,'快速赚钱'),(33,'234','收入',100,'2018-12-27 14:49:34',520,'快速赚钱'),(34,'234','收入',100,'2018-12-27 14:49:34',620,'快速赚钱'),(35,'234','收入',100,'2018-12-27 14:49:35',720,'快速赚钱'),(36,'234','存款',10,'2018-12-27 14:49:38',710,'存入余额'),(37,'234','存款',30,'2018-12-27 14:49:42',680,'存入余额'),(38,'234','存款',50,'2018-12-27 14:49:44',630,'存入余额'),(39,'234','存款',400,'2018-12-27 14:49:48',230,'存入余额'),(40,'234','存款',200,'2018-12-27 14:49:51',30,'存入余额'),(41,'234','存款',12,'2018-12-27 14:49:53',18,'存入余额'),(42,'234','取款',1000,'2018-12-27 14:49:56',1018,'余额取出'),(43,'234','收入',100,'2018-12-27 14:49:59',1118,'快速赚钱'),(44,'234','收入',100,'2018-12-27 14:50:00',1218,'快速赚钱'),(45,'234','消费',200,'2018-12-27 14:50:02',1018,'快速花钱'),(46,'234','消费',200,'2018-12-27 14:50:03',818,'快速花钱'),(47,'234','存款',100,'2018-12-27 16:29:51',718,'存入余额'),(48,'234','存款',500,'2018-12-27 16:30:29',218,'存入余额'),(49,'123','存款',50,'2018-12-27 17:29:39',24,'存入余额'),(50,'123','取款',1000,'2018-12-27 17:30:16',1024,'余额取出'),(51,'234','存款',200,'2018-12-27 22:39:48',34,'存入余额'),(52,'234','取款',100,'2018-12-27 22:40:10',134,'余额取出'),(53,'234','收入',100,'2018-12-27 22:40:15',234,'快速赚钱'),(54,'234','收入',100,'2018-12-27 22:40:18',334,'快速赚钱'),(55,'234','收入',100,'2018-12-27 22:40:20',434,'快速赚钱'),(56,'234','收入',100,'2018-12-27 22:40:22',534,'快速赚钱'),(57,'60655','存款',100,'2018-12-28 09:07:11',0,'开户预存'),(58,'60655','收入',100,'2018-12-28 09:14:36',100,'快速赚钱'),(59,'60655','收入',100,'2018-12-28 09:14:36',200,'快速赚钱'),(60,'60655','收入',100,'2018-12-28 09:14:38',300,'快速赚钱'),(61,'60655','收入',100,'2018-12-28 09:14:40',400,'快速赚钱'),(62,'60655','收入',100,'2018-12-28 09:14:42',500,'快速赚钱'),(63,'60655','收入',100,'2018-12-28 09:14:44',600,'快速赚钱'),(64,'60655','存款',500,'2018-12-28 09:14:52',100,'存入余额'),(65,'60655','收入',100,'2018-12-28 09:14:56',200,'快速赚钱'),(66,'61914','存款',100,'2018-12-28 10:45:58',0,'开户预存'),(67,'61914','取款',100,'2018-12-28 10:47:08',100,'余额取出'),(68,'61914','收入',100,'2018-12-28 10:47:14',200,'快速赚钱'),(69,'61914','收入',100,'2018-12-28 10:47:17',300,'快速赚钱'),(70,'61914','收入',100,'2018-12-28 10:47:21',400,'快速赚钱'),(71,'123','收入',100,'2018-12-28 11:18:26',184,'快速赚钱'),(72,'123','收入',100,'2018-12-28 11:18:28',284,'快速赚钱'),(73,'123','收入',100,'2018-12-28 11:18:28',384,'快速赚钱'),(74,'123','收入',100,'2018-12-28 11:18:29',484,'快速赚钱'),(75,'123','收入',100,'2018-12-28 11:18:30',584,'快速赚钱'),(76,'123','存款',500,'2018-12-28 11:19:30',84,'存入余额'),(77,'123','收入',100,'2018-12-28 11:19:48',184,'快速赚钱'),(78,'123','收入',100,'2018-12-28 11:19:49',284,'快速赚钱'),(79,'123','存款',100,'2018-12-28 11:19:53',184,'存入余额'),(80,'123','收入',100,'2018-12-28 11:21:11',284,'快速赚钱'),(81,'123','取款',1000,'2018-12-28 11:21:20',1284,'余额取出'),(82,'123','消费',200,'2018-12-28 11:21:23',1084,'快速花钱'),(83,'123','消费',200,'2018-12-28 11:21:25',884,'快速花钱'),(84,'123','消费',200,'2018-12-28 11:21:27',684,'快速花钱'),(85,'123','存款',100,'2018-12-28 11:44:30',584,'存入余额'),(86,'123','存款',500,'2018-12-28 11:44:46',84,'存入余额'),(87,'123','收入',100,'2018-12-28 11:45:05',184,'快速赚钱'),(88,'123','收入',100,'2018-12-28 11:45:09',284,'快速赚钱'),(89,'123','存款',100,'2018-12-28 11:45:14',184,'存入余额'),(90,'123','取款',1000,'2018-12-28 11:45:23',1184,'余额取出'),(91,'123','消费',200,'2018-12-28 11:45:28',984,'快速花钱'),(92,'123','消费',200,'2018-12-28 11:45:29',784,'快速花钱'),(93,'79321','存款',100,'2019-01-06 01:42:37',0,'开户预存'),(94,'123','存款',500,'2019-01-19 22:17:39',284,'存入余额'),(95,'123','取款',100,'2019-01-19 22:17:56',384,'余额取出'),(96,'123','收入',100,'2019-01-19 22:18:07',484,'快速赚钱'),(97,'123','收入',100,'2019-01-19 22:18:10',584,'快速赚钱'),(98,'123','消费',200,'2019-01-19 22:18:18',384,'快速花钱'),(99,'123','存款',100,'2019-04-01 14:11:05',284,'存入余额'),(100,'123456','收入',100,'2019-04-08 00:33:19',100,'快速赚钱'),(101,'123456','收入',100,'2019-04-08 00:33:23',200,'快速赚钱'),(102,'123456','收入',100,'2019-04-08 00:33:28',300,'快速赚钱'),(103,'123456','消费',200,'2019-04-08 00:35:23',100,'快速花钱'),(104,'123456','收入',100,'2019-04-08 00:35:26',200,'快速赚钱'),(105,'123456','取款',1000,'2019-04-08 00:35:33',1200,'余额取出'),(106,'123456','消费',200,'2019-04-08 00:35:37',1000,'快速花钱'),(107,'123456','消费',200,'2019-04-08 00:35:39',800,'快速花钱'),(108,'123456','存款',200,'2019-04-08 00:35:44',600,'存入余额'),(109,'123','取款',100,'2019-04-08 13:18:53',384,'余额取出'),(110,'123','取款',200,'2019-04-08 13:23:34',584,'余额取出'),(111,'123','存款',100,'2019-04-08 13:28:47',484,'存入余额'),(112,'123','存款',100,'2019-04-08 13:28:56',384,'存入余额'),(113,'123','存款',100,'2019-04-08 13:29:02',284,'存入余额'),(114,'123','存款',50,'2019-04-08 15:43:17',234,'存入余额'),(115,'123','存款',50,'2019-04-08 17:19:44',184,'存入余额'),(116,'123','取款',500,'2019-04-08 17:19:59',684,'余额取出'),(117,'234','存款',100,'2019-05-01 23:43:51',434,'存入余额'),(118,'234','取款',1002,'2019-05-01 23:44:01',1436,'余额取出'),(119,'123','存款',500,'2019-05-02 01:15:58',184,'存入余额'),(120,'123','取款',300,'2019-05-02 01:16:16',484,'余额取出'),(121,'234','收入',100,'2019-05-05 00:53:27',1536,'快速赚钱'),(122,'234','存款',1000,'2019-05-05 00:53:37',536,'存入余额'),(123,'234','取款',2500,'2019-05-05 00:53:44',3036,'余额取出'),(124,'234','存款',3000,'2019-05-05 00:53:50',36,'存入余额'),(125,'234','取款',1500,'2019-05-05 00:54:07',1536,'余额取出'),(126,'234','收入',100,'2019-05-05 00:54:10',1636,'快速赚钱'),(127,'234','收入',100,'2019-05-05 00:54:12',1736,'快速赚钱'),(128,'234','收入',100,'2019-05-05 00:54:15',1836,'快速赚钱'),(129,'234','收入',100,'2019-05-05 00:54:17',1936,'快速赚钱'),(130,'234','收入',100,'2019-05-05 00:54:20',2036,'快速赚钱'),(131,'234','存款',500,'2019-05-05 00:54:25',1536,'存入余额'),(132,'234','取款',2000,'2019-05-05 00:54:31',3536,'余额取出'),(133,'345','收入',100,'2019-05-06 10:44:48',200,'快速赚钱'),(134,'345','收入',100,'2019-05-06 10:44:50',300,'快速赚钱'),(135,'345','收入',100,'2019-05-06 10:44:52',400,'快速赚钱'),(136,'345','收入',100,'2019-05-06 10:44:54',500,'快速赚钱'),(137,'345','收入',100,'2019-05-06 10:44:56',600,'快速赚钱'),(138,'345','收入',100,'2019-05-06 10:44:58',700,'快速赚钱'),(139,'345','存款',500,'2019-05-06 10:45:03',200,'存入余额'),(140,'345','收入',100,'2019-05-06 10:45:07',300,'快速赚钱'),(141,'345','收入',100,'2019-05-06 10:45:08',400,'快速赚钱'),(142,'345','收入',100,'2019-05-06 10:45:10',500,'快速赚钱'),(143,'345','收入',100,'2019-05-06 10:45:12',600,'快速赚钱'),(144,'345','收入',100,'2019-05-06 10:45:13',700,'快速赚钱'),(145,'345','存款',700,'2019-05-06 10:45:18',0,'存入余额'),(146,'345','取款',1000,'2019-05-06 10:45:31',1000,'余额取出'),(147,'456','取款',500,'2019-05-06 10:46:28',600,'余额取出'),(148,'456','取款',600,'2019-05-06 10:46:34',1200,'余额取出'),(149,'456','收入',100,'2019-05-06 10:46:35',1300,'快速赚钱'),(150,'456','收入',100,'2019-05-06 10:46:37',1400,'快速赚钱'),(151,'456','收入',100,'2019-05-06 10:46:38',1500,'快速赚钱'),(152,'456','收入',100,'2019-05-06 10:46:40',1600,'快速赚钱'),(153,'456','收入',100,'2019-05-06 10:46:42',1700,'快速赚钱'),(154,'456','收入',100,'2019-05-06 10:46:43',1800,'快速赚钱'),(155,'456','收入',100,'2019-05-06 10:46:45',1900,'快速赚钱'),(156,'456','收入',100,'2019-05-06 10:46:47',2000,'快速赚钱'),(157,'456','收入',100,'2019-05-06 10:46:48',2100,'快速赚钱'),(158,'456','存款',2000,'2019-05-06 10:46:53',100,'存入余额'),(159,'567','取款',4000,'2019-05-06 10:47:57',4050,'余额取出'),(160,'567','存款',2000,'2019-05-06 10:48:02',2050,'存入余额'),(161,'567','收入',100,'2019-05-06 10:48:05',2150,'快速赚钱'),(162,'567','收入',100,'2019-05-06 10:48:06',2250,'快速赚钱'),(163,'567','收入',100,'2019-05-06 10:48:08',2350,'快速赚钱'),(164,'567','存款',2000,'2019-05-06 10:48:12',350,'存入余额'),(165,'567','消费',200,'2019-05-06 10:48:14',150,'快速花钱'),(166,'567','取款',4000,'2019-05-06 10:48:20',4150,'余额取出'),(167,'567','取款',50,'2019-05-06 10:48:27',4200,'余额取出'),(168,'567','存款',100,'2019-05-06 10:48:34',4100,'存入余额'),(169,'567','存款',500,'2019-05-06 10:48:39',3600,'存入余额'),(170,'567','存款',200,'2019-05-06 10:56:11',3400,'存入余额'),(171,'567','存款',200,'2019-05-06 10:56:30',3200,'存入余额'),(172,'123','存款',400,'2019-05-08 00:03:10',84,'存入余额'),(173,'44285','存款',100,'2019-05-10 23:23:12',0,'开户预存'),(174,'123','取款',500,'2019-05-11 22:38:44',584,'余额取出'),(175,'123','收入',100,'2019-05-11 22:38:48',684,'快速赚钱'),(176,'123','收入',100,'2019-05-11 22:38:49',784,'快速赚钱'),(177,'123','收入',100,'2019-05-11 22:38:51',884,'快速赚钱'),(178,'123','收入',100,'2019-05-11 22:38:52',984,'快速赚钱'),(179,'123','收入',100,'2019-05-11 22:38:54',1084,'快速赚钱'),(180,'123','收入',100,'2019-05-11 22:38:56',1184,'快速赚钱'),(181,'123','收入',100,'2019-05-11 22:38:57',1284,'快速赚钱'),(182,'123','收入',100,'2019-05-11 22:38:59',1384,'快速赚钱'),(183,'123','收入',100,'2019-05-11 22:39:01',1484,'快速赚钱'),(184,'123','收入',100,'2019-05-11 22:39:02',1584,'快速赚钱'),(185,'123','收入',100,'2019-05-11 22:39:04',1684,'快速赚钱'),(186,'123','存款',1600,'2019-05-11 22:39:15',84,'存入余额'),(187,'123','取款',1000,'2019-05-11 22:39:28',1084,'余额取出'),(188,'234','存款',3000,'2019-05-12 13:05:15',536,'存入余额'),(189,'234','取款',3000,'2019-05-12 13:05:28',3536,'余额取出'),(190,'234','收入',100,'2019-05-12 13:06:54',3636,'快速赚钱'),(191,'123','存款',1000,'2019-05-12 13:31:00',84,'存入余额'),(192,'123','存款',20,'2019-05-12 13:31:03',64,'存入余额'),(193,'123','存款',40,'2019-05-12 13:31:07',24,'存入余额'),(194,'123','存款',20,'2019-05-12 13:39:31',4,'存入余额'),(195,'123','收入',100,'2019-05-12 13:39:34',104,'快速赚钱'),(196,'123','收入',100,'2019-05-12 13:39:36',204,'快速赚钱'),(197,'123','收入',100,'2019-05-12 13:39:38',304,'快速赚钱'),(198,'123','收入',100,'2019-05-12 13:39:39',404,'快速赚钱'),(199,'123','收入',100,'2019-05-12 13:39:40',504,'快速赚钱'),(200,'123','收入',100,'2019-05-12 13:39:42',604,'快速赚钱'),(201,'123','存款',500,'2019-05-12 13:39:47',104,'存入余额'),(202,'123','取款',2500,'2019-05-12 13:39:56',2604,'余额取出'),(203,'123','存款',2600,'2019-05-12 13:46:46',4,'存入余额'),(204,'34990','存款',100,'2019-05-13 09:19:41',0,'开户预存'),(205,'54298','存款',100,'2019-05-13 12:26:14',0,'开户预存'),(206,'99581','存款',100,'2019-05-16 08:02:22',0,'开户预存'),(207,'63480','存款',100,'2019-05-16 20:29:36',0,'开户预存'),(208,'234','存款',3500,'2019-05-17 21:56:08',16,'存入余额'),(209,'123','取款',1020,'2019-05-18 08:46:50',1024,'余额取出'),(210,'234','取款',3500,'2019-05-18 08:51:35',3516,'余额取出'),(211,'234','存款',10,'2019-05-18 08:51:59',3506,'存入余额'),(212,'234','存款',2020,'2019-05-18 08:59:34',1486,'存入余额'),(213,'234','取款',1010,'2019-05-18 08:59:43',2496,'余额取出'),(214,'234','取款',1000,'2019-05-18 08:59:48',3496,'余额取出'),(215,'234','购买投资产品',400,'2019-05-18 09:00:22',3096,'购买了理财基金产品 2 个月'),(216,'234','购买投资产品',200,'2019-05-18 09:01:20',2896,'购买了发展资本产品 1 个月');

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `name` char(40) NOT NULL,
  `pass` char(40) NOT NULL,
  `yue` double NOT NULL,
  `xingming` char(255) DEFAULT NULL,
  `youxiang` char(255) DEFAULT NULL,
  `shoujihao` char(255) DEFAULT NULL,
  `money` double NOT NULL,
  PRIMARY KEY (`name`,`pass`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

/*Data for the table `users` */

insert  into `users`(`name`,`pass`,`yue`,`xingming`,`youxiang`,`shoujihao`,`money`) values ('102159','1231',200,'刘晓松','789@333','13254689542',0),('10622','1231',2167,'项羽','147258369@qq.com','14631225675',0),('107839','1231',100,'锡林','134@123','13756352864',0),('123','1231',1772,'梁小松','394605496@qq.com','18120756836',1024),('123321','1231231',5000,'王雅媛','123456@qq.com','13513534724',50),('1234','121',100,'seddie','2123123@qq.com','123123123',100),('123456','1234561',1200,'老冀','123123123@qq.com','14534343586',600),('1607052210','1234561',888,'黄雄杰','123@qq.com','12335437864',0),('1607052216','1234561',500,'刘德华','123@qq.com','18603534608',0),('1607052217','1231',2444,'李建宇','123@qq.com','12123458648',0),('1607052218','1234561',500,'林德嘉','123@qq.com','12312535321',0),('17032','1231',100,'希望我','35646512@qq.com','16515354865',0),('20456','1234561',200,'liang','123@qq.com','15678645867',100),('21494','shen12341',100,'sss','980447530@qq.com','18060944757',0),('23160','1231',100,'狄仁杰','123@303.com','12322265488',0),('234','2341',33,'王昭君','123987456@qq.com','15987654325',2896),('28495','1231',4500,'诸葛毅','12344321@qq.com','15346873254',0),('345','3451',300,'莫小梅','223333@qwe.com','15468796543',1000),('34990','1231',100,'玩游戏','123123@13.com','12685354802',0),('44285','1231',100,'来看待','369@123','13569954352',0),('456','4561',2100,'王小杰','1231232211@qq.com','15357864532',100),('48386','shen12341',100,'sss','1697175672@qq.com','18060944757',0),('50534','1231',7430,'吴雨涵','123@qq.com','75283685398',0),('50794','2341',100,'希望我2','3564652212@qq.com','16515355265',0),('54298','1231',100,'猪八戒','125125513@qq.com','15369485648',0),('56135','1231',100,'李林','12345@qq.com','12345678952',0),('567','5671',1050,'方小彬','987987987@qq.com','18942101215',3200),('58665','1231',100,'梁楷松','abc@qq.com','11111111111',0),('60655','1231',600,'夏侯惇','321654@qq.com','13694521111',200),('61914','lzy188765030111',0,'德嘉老爸','2410267884@qq.com','18965805130',400),('62294','1234561',1698,'刘一斌','345@qq.com','14275839685',0),('63480','1231',100,'得到去我','122135421@qq.com','12580120315',0),('64493','1234561',100,'李伟','123@123','12385375286',0),('64655','132035346081',300,'梁斌','123456@qq.com','13203534608',0),('65319','1231',10223,'秦舞阳','596566@qq.com','13246852546',500),('67420','1231',1400,'海贼王','394605496@qq.com','18120756830',0),('72104','1231',100,'吴强','123@qq.com','12222355533',0),('72768','1231',100,'李白','132@qq.com','17428395694',0),('73181','1231',100,'李晓明','42351@qwe','17421529478',0),('74245','1231',55933180,'李小龙','123456789@qwe','17402560145',0),('74953','1231',100,'黄晓波','123@qq.com','14058607898',0),('76077','1231',1785,'邱学文','344232@qwe','15296200828',0),('77324','1231',100,'张建林','43210@123','10526087452',0),('79321','1231',100,'猴子D路飞','123456789@qwe','12312340234',0),('85332','1231',100,'金庸','123@qq.com','12312856023',0),('87554','1231',1600,'李晓敏','123456@qq.com','17280869520',0),('96732','1231',100,'李新民','23456243@qq.com','10256963808',0),('99581','1231',100,'贵妇人','12322221123@1123.com','18654832023',0);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;