Skip to content

Commit 0af690c

Browse files
committed
同步table
1 parent 86a6605 commit 0af690c

4 files changed

Lines changed: 11 additions & 14 deletions

File tree

‎table/sys_Password.sql‎

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -25,13 +25,12 @@ DROP TABLE IF EXISTS `Password`;
2525
CREATE TABLE `Password` (
2626
`_index` int(11) NOT NULL AUTO_INCREMENT,
2727
`id` bigint(15) NOT NULL,
28-
`model` varchar(20) NOT NULL DEFAULT 'User' COMMENT 'table是关键字不能用!',
2928
`type` varchar(20) DEFAULT NULL,
3029
`password` varchar(20) NOT NULL,
3130
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
32-
PRIMARY KEY (`id`),
31+
PRIMARY KEY (`_index`),
3332
UNIQUE KEY `_index_UNIQUE` (`_index`)
34-
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
33+
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
3534
/*!40101 SET character_set_client = @saved_cs_client */;
3635

3736
--
@@ -40,7 +39,7 @@ CREATE TABLE `Password` (
4039

4140
LOCK TABLES `Password` WRITE;
4241
/*!40000 ALTER TABLE `Password` DISABLE KEYS */;
43-
INSERT INTO `Password` VALUES (1,12345678900,'User','0','123456','2017-02-01 11:21:50'),(2,12345678901,'User','0','123456','2017-02-01 11:21:50'),(3,12345678902,'User','0','123456','2017-02-01 11:21:50'),(4,12345678903,'User','0','123456','2017-02-01 11:21:50'),(5,12345678904,'User','0','apijson','2017-02-01 11:21:50'),(6,12345678905,'User','0','apijson','2017-02-01 11:21:50'),(7,12345678906,'User','0','123456','2017-02-01 11:21:50'),(8,12345678907,'User','0','123456','2017-02-01 11:21:50'),(9,12345678908,'User','0','123456','2017-02-01 11:21:50'),(10,12345678909,'User','0','123456','2017-02-01 11:21:50'),(11,12345678910,'User','0','123456','2017-02-01 11:21:50'),(12,12345678911,'User','0','123456','2017-02-01 11:21:50'),(13,12345678912,'User','0','123456','2017-02-01 11:21:50'),(14,12345678913,'User','0','123456','2017-02-01 11:21:50'),(15,12345678914,'User','0','123456','2017-02-01 11:21:50'),(16,12345678915,'User','0','123456','2017-02-01 11:21:50'),(17,12345678916,'User','0','123456','2017-02-01 11:21:50'),(18,12345678917,'User','0','123456','2017-02-01 11:21:50'),(19,12345678918,'User','0','123456','2017-02-01 11:21:50'),(20,12345678919,'User','0','123456','2017-02-19 13:57:56'),(70,13000031000,'User',NULL,'123456','2017-05-04 09:30:14'),(71,13000031001,'User',NULL,'123456','2017-05-04 09:31:43'),(21,13000038710,'User','1','apijson','2017-02-01 11:21:50'),(22,13000038711,'User',NULL,'123456','2017-03-04 16:04:02'),(23,13000038712,'User',NULL,'123456','2017-03-05 09:51:51'),(24,13000038713,'User',NULL,'123456','2017-03-05 09:52:52'),(25,13000038714,'User',NULL,'123456','2017-03-05 09:53:37'),(26,13000038715,'User',NULL,'123456','2017-03-05 09:57:54'),(27,13000038716,'User',NULL,'123456','2017-03-25 05:44:11'),(28,13000038717,'User',NULL,'123456','2017-03-25 07:32:19'),(29,13000038720,'User',NULL,'123456','2017-03-05 15:25:42'),(30,13000038721,'User',NULL,'123456','2017-03-06 12:29:03'),(31,13000038730,'User',NULL,'123456','2017-03-12 06:01:23'),(32,13000038750,'User',NULL,'123456','2017-03-12 11:23:04'),(63,13000038777,'User',NULL,'123456','2017-05-02 17:51:52'),(64,13000038778,'User',NULL,'123456','2017-05-02 17:56:17'),(65,13000038779,'User',NULL,'123456','2017-05-02 18:09:54'),(66,13000038780,'User',NULL,'123456','2017-05-02 18:10:15'),(67,13000038781,'User',NULL,'123456','2017-05-02 18:18:10'),(33,13000038790,'User',NULL,'123456','2017-03-27 03:22:32'),(62,13000038888,'User',NULL,'123456','2017-04-29 15:35:42'),(68,13000038999,'User',NULL,'123456','2017-05-03 18:27:23'),(69,13000039999,'User',NULL,'123456','2017-05-04 07:31:50'),(34,13000070793,'User','0','apijson','2017-02-01 11:21:50'),(35,13000082001,'User','1','123456','2017-02-01 11:21:50'),(36,13000082002,'User','1','123456','2017-02-01 11:21:50'),(37,13000082003,'User','1','123456','2017-02-01 11:21:50'),(38,13000082004,'User','0','123456','2017-02-01 11:21:50'),(39,13000082005,'User','0','123456','2017-02-01 11:21:50'),(40,13000082006,'User','0','123456','2017-02-01 11:21:50'),(41,13000082010,'User',NULL,'123456','2017-03-04 15:11:17'),(42,13000082012,'User','0','123456','2017-02-01 11:21:50'),(43,13000082015,'User','0','123456','2017-03-04 09:59:34'),(44,13000082016,'User','0','123456','2017-03-04 10:04:33'),(45,13000082017,'User','0','123456','2017-03-04 10:05:04'),(46,13000082018,'User','0','123456','2017-03-04 10:20:27'),(47,13000082019,'User','0','123456','2017-03-02 16:44:26'),(48,13000082020,'User','0','123456','2017-03-04 10:22:39'),(49,13000082021,'User',NULL,'123456','2017-03-04 16:02:05'),(50,13000082030,'User',NULL,'123456','2017-03-11 15:04:00'),(51,13000082033,'User',NULL,'123456','2017-03-19 14:49:15'),(52,13000082040,'User',NULL,'123456','2017-03-11 15:32:25'),(53,13000082050,'User',NULL,'123456','2017-03-21 14:10:18'),(54,13000082051,'User',NULL,'123456','2017-03-31 15:21:10'),(55,13000082100,'User',NULL,'123456','2017-03-21 15:22:22'),(56,13000082101,'User',NULL,'123456','2017-03-21 15:24:05'),(57,13000082102,'User',NULL,'123456','2017-03-25 07:39:37'),(58,13000090814,'User','1','123456','2017-02-01 11:21:50'),(59,13000093793,'User','1','123456','2017-02-01 11:21:50'),(61,13000093794,'User',NULL,'123456','2017-04-23 08:29:29'),(60,99999999999,'User','0','123456','2017-02-01 11:21:50');
42+
INSERT INTO `Password` VALUES (1,12345678900,'0','123456','2017-02-01 11:21:50'),(2,12345678901,'0','123456','2017-02-01 11:21:50'),(3,12345678902,'0','123456','2017-02-01 11:21:50'),(4,12345678903,'0','123456','2017-02-01 11:21:50'),(5,12345678904,'0','apijson','2017-02-01 11:21:50'),(6,12345678905,'0','apijson','2017-02-01 11:21:50'),(7,12345678906,'0','123456','2017-02-01 11:21:50'),(8,12345678907,'0','123456','2017-02-01 11:21:50'),(9,12345678908,'0','123456','2017-02-01 11:21:50'),(10,12345678909,'0','123456','2017-02-01 11:21:50'),(11,12345678910,'0','123456','2017-02-01 11:21:50'),(12,12345678911,'0','123456','2017-02-01 11:21:50'),(13,12345678912,'0','123456','2017-02-01 11:21:50'),(14,12345678913,'0','123456','2017-02-01 11:21:50'),(15,12345678914,'0','123456','2017-02-01 11:21:50'),(16,12345678915,'0','123456','2017-02-01 11:21:50'),(17,12345678916,'0','123456','2017-02-01 11:21:50'),(18,12345678917,'0','123456','2017-02-01 11:21:50'),(19,12345678918,'0','123456','2017-02-01 11:21:50'),(20,12345678919,'0','123456','2017-02-19 13:57:56'),(21,13000038710,'1','666666','2017-02-01 11:21:50'),(22,13000038711,NULL,'123456','2017-03-04 16:04:02'),(23,13000038712,NULL,'123456','2017-03-05 09:51:51'),(24,13000038713,NULL,'123456','2017-03-05 09:52:52'),(25,13000038714,NULL,'123456','2017-03-05 09:53:37'),(26,13000038715,NULL,'123456','2017-03-05 09:57:54'),(27,13000038716,NULL,'123456','2017-03-25 05:44:11'),(28,13000038717,NULL,'123456','2017-03-25 07:32:19'),(29,13000038720,NULL,'123456','2017-03-05 15:25:42'),(30,13000038721,NULL,'123456','2017-03-06 12:29:03'),(31,13000038730,NULL,'123456','2017-03-12 06:01:23'),(32,13000038750,NULL,'123456','2017-03-12 11:23:04'),(33,13000038790,NULL,'123456','2017-03-27 03:22:32'),(34,13000070793,'0','apijson','2017-02-01 11:21:50'),(35,13000082001,'1','123456','2017-02-01 11:21:50'),(36,13000082002,'1','123456','2017-02-01 11:21:50'),(37,13000082003,'1','123456','2017-02-01 11:21:50'),(38,13000082004,'0','123456','2017-02-01 11:21:50'),(39,13000082005,'0','123456','2017-02-01 11:21:50'),(40,13000082006,'0','123456','2017-02-01 11:21:50'),(41,13000082010,NULL,'123456','2017-03-04 15:11:17'),(42,13000082012,'0','123456','2017-02-01 11:21:50'),(43,13000082015,'0','123456','2017-03-04 09:59:34'),(44,13000082016,'0','123456','2017-03-04 10:04:33'),(45,13000082017,'0','123456','2017-03-04 10:05:04'),(46,13000082018,'0','123456','2017-03-04 10:20:27'),(47,13000082019,'0','123456','2017-03-02 16:44:26'),(48,13000082020,'0','123456','2017-03-04 10:22:39'),(49,13000082021,NULL,'123456','2017-03-04 16:02:05'),(50,13000082030,NULL,'123456','2017-03-11 15:04:00'),(51,13000082033,NULL,'123456','2017-03-19 14:49:15'),(52,13000082040,NULL,'123456','2017-03-11 15:32:25'),(53,13000082050,NULL,'123456','2017-03-21 14:10:18'),(54,13000082051,NULL,'123456','2017-03-31 15:21:10'),(55,13000082100,NULL,'123456','2017-03-21 15:22:22'),(56,13000082101,NULL,'123456','2017-03-21 15:24:05'),(57,13000082102,NULL,'123456','2017-03-25 07:39:37'),(58,13000090814,'1','123456','2017-02-01 11:21:50'),(59,13000093793,'1','123456','2017-02-01 11:21:50'),(60,99999999999,'0','123456','2017-02-01 11:21:50'),(61,13000093794,NULL,'123456','2017-04-23 08:29:29'),(62,13000038888,NULL,'123456','2017-04-29 15:35:42'),(63,13000038777,NULL,'123456','2017-05-02 17:51:52'),(64,13000038778,NULL,'123456','2017-05-02 17:56:17'),(65,13000038779,NULL,'123456','2017-05-02 18:09:54'),(66,13000038780,NULL,'123456','2017-05-02 18:10:15'),(67,13000038781,NULL,'123456','2017-05-02 18:18:10'),(68,13000038999,NULL,'123456','2017-05-03 18:27:23'),(69,13000039999,NULL,'123456','2017-05-04 07:31:50'),(70,13000031000,NULL,'123456','2017-05-04 09:30:14'),(71,13000031001,NULL,'123456','2017-05-04 09:31:43'),(72,13000038788,NULL,'123456','2017-05-09 13:59:22'),(73,13000038789,NULL,'123456','2017-05-09 14:01:04'),(75,13000082009,NULL,'666666','2017-05-12 16:01:35');
4443
/*!40000 ALTER TABLE `Password` ENABLE KEYS */;
4544
UNLOCK TABLES;
4645
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -53,4 +52,4 @@ UNLOCK TABLES;
5352
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5453
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5554

56-
-- Dump completed on 2017-05-08 15:54:34
55+
-- Dump completed on 2017-05-13 0:12:27

‎table/sys_Request.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -40,7 +40,7 @@ CREATE TABLE `Request` (
4040

4141
LOCK TABLES `Request` WRITE;
4242
/*!40000 ALTER TABLE `Request` DISABLE KEYS */;
43-
INSERT INTO `Request` VALUES (1,0,'User','POST','{\"User\": {\"disallow\": \"id\", \"necessary\": \"name,phone\"}, \"necessary\": \"password,verify\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ?','2017-02-01 11:19:51'),(2,0,'Moment','POST','{\"disallow\": \"id\", \"necessary\": \"userId,pictureList\"}',NULL,'2017-02-01 11:19:51'),(3,0,'Comment','POST','{\"disallow\": \"id\", \"necessary\": \"userId,momentId,content\"}',NULL,'2017-02-01 11:19:51'),(4,0,'User','PUT','{\"disallow\": \"phone\", \"necessary\": \"id\"}',NULL,'2017-02-01 11:19:51'),(6,0,'Moment','DELETE','{\"necessary\": \"id\"}','所有删除都要有currentUserId和loginPassword?','2017-02-01 11:19:51'),(7,0,'Comment','DELETE','{\"put\": {\"Comment:child\": {\"toId@\": \"Comment/id\"}}, \"Comment\": {\"necessary\": \"id\"}}','disallow没必要用于DELETE','2017-02-01 11:19:51'),(8,0,'Password','PUT','{\"Password\": {\"disallow\": \"!\", \"necessary\": \"id,password\"}, \"necessary\": \"oldPassword\"}','对安全要求高,不允许客户端改type,date等字段','2017-02-01 11:19:51'),(9,0,'User.phone','PUT','{\"User\": {\"disallow\": \"!\", \"necessary\": \"id,phone\"}}','! 表示其它所有,这里指necessary所有未包含的字段','2017-02-01 11:19:51'),(10,0,'MomentWithComment','POST','{\"Moment\": {\"Comment\": {\"disallow\": \"id\", \"necessary\": \"userId,workId,content\"}, \"disallow\": \"id\", \"necessary\": \"userId,title,content,picture\"}}','用的极少,可能根本用不上','2017-02-01 11:19:51'),(11,0,'User','DELETE','{\"necessary\": \"id\"}','','2017-02-01 11:19:51'),(12,0,'Password','POST_GET','{\"disallow\": \"!\", \"necessary\": \"id,model\"}','String:table, Long: tableId 限制类型?','2017-02-18 12:03:17'),(13,0,'Wallet','POST_GET','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"userId\"}, \"necessary\": \"currentUserId,loginPassword\"}',NULL,'2017-02-18 14:20:43'),(14,0,'Login','POST_GET','{\"User\": {\"necessary\": \"phone\"}, \"Password\": {\"disallow\": \"!\", \"necessary\": \"table,phone,value\"}}',NULL,'2017-02-18 14:20:43'),(15,0,'Login','POST','{\"disallow\": \"!\", \"necessary\": \"userId,type\"}',NULL,'2017-02-18 14:20:43'),(16,0,'Verify','POST','{\"disallow\": \"!\", \"necessary\": \"id,code\"}',NULL,'2017-02-18 14:20:43'),(17,0,'Verify','POST_GET','{\"necessary\": \"id\"}',NULL,'2017-02-18 14:20:43'),(18,0,'Verify','DELETE','{\"disallow\": \"!\", \"necessary\": \"id\"}',NULL,'2017-02-18 14:20:43'),(19,0,'Verify','POST_HEAD','{}',NULL,'2017-02-18 14:20:43'),(20,0,'Moment','PUT','{\"disallow\": \"userId,date\", \"necessary\": \"id\"}',NULL,'2017-02-01 11:19:51'),(30,0,'Wallet','POST','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"userId\"}, \"necessary\": \"payPassword\"}',NULL,'2017-02-18 14:20:43'),(31,0,'Wallet','PUT','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"userId,balance+\"}, \"necessary\": \"payPassword,oldPassword\"}',NULL,'2017-02-18 14:20:43'),(32,0,'Wallet','DELETE','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"userId\"}, \"necessary\": \"payPassword\"}',NULL,'2017-02-18 14:20:43'),(33,0,'Login','POST_HEAD','{\"disallow\": \"!\", \"necessary\": \"userId,type\"}',NULL,'2017-02-18 14:20:43');
43+
INSERT INTO `Request` VALUES (1,0,'User','POST','{\"User\": {\"disallow\": \"id\", \"necessary\": \"name,phone\"}, \"necessary\": \"password,verify\"}','\"User:toUser\":{}转化为\"toUser\":User的JSONObject ?','2017-02-01 11:19:51'),(2,0,'Moment','POST','{\"disallow\": \"id\", \"necessary\": \"userId,pictureList\"}',NULL,'2017-02-01 11:19:51'),(3,0,'Comment','POST','{\"disallow\": \"id\", \"necessary\": \"userId,momentId,content\"}',NULL,'2017-02-01 11:19:51'),(4,0,'User','PUT','{\"disallow\": \"phone\", \"necessary\": \"id\"}',NULL,'2017-02-01 11:19:51'),(6,0,'Moment','DELETE','{\"put\": {\"Comment\": {\"momentId@\": \"Moment/id\"}}, \"Moment\": {\"necessary\": \"id\"}}','所有删除都要有currentUserId和loginPassword?','2017-02-01 11:19:51'),(7,0,'Comment','DELETE','{\"put\": {\"Comment:child\": {\"toId@\": \"Comment/id\"}}, \"Comment\": {\"necessary\": \"id\"}}','disallow没必要用于DELETE','2017-02-01 11:19:51'),(8,0,'Password','PUT','{\"Password\": {\"disallow\": \"!\", \"necessary\": \"id,password\"}, \"necessary\": \"oldPassword\"}','对安全要求高,不允许客户端改type,date等字段','2017-02-01 11:19:51'),(9,0,'User.phone','PUT','{\"User\": {\"disallow\": \"!\", \"necessary\": \"id,phone\"}}','! 表示其它所有,这里指necessary所有未包含的字段','2017-02-01 11:19:51'),(10,0,'MomentWithComment','POST','{\"Moment\": {\"Comment\": {\"disallow\": \"id\", \"necessary\": \"userId,workId,content\"}, \"disallow\": \"id\", \"necessary\": \"userId,title,content,picture\"}}','用的极少,可能根本用不上','2017-02-01 11:19:51'),(11,0,'User','DELETE','{\"necessary\": \"id\"}','','2017-02-01 11:19:51'),(12,0,'Password','POST_GET','{\"disallow\": \"!\", \"necessary\": \"id,model\"}','String:table, Long: tableId 限制类型?','2017-02-18 12:03:17'),(13,0,'Wallet','POST_GET','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"id\"}, \"necessary\": \"currentUserId,loginPassword\"}',NULL,'2017-02-18 14:20:43'),(14,0,'Login','POST_GET','{\"User\": {\"necessary\": \"phone\"}, \"Password\": {\"disallow\": \"!\", \"necessary\": \"table,phone,value\"}}',NULL,'2017-02-18 14:20:43'),(15,0,'Login','POST','{\"disallow\": \"!\", \"necessary\": \"userId,type\"}',NULL,'2017-02-18 14:20:43'),(16,0,'Verify','POST','{\"disallow\": \"!\", \"necessary\": \"id,code\"}',NULL,'2017-02-18 14:20:43'),(17,0,'Verify','POST_GET','{\"necessary\": \"id\"}',NULL,'2017-02-18 14:20:43'),(18,0,'Verify','DELETE','{\"disallow\": \"!\", \"necessary\": \"id\"}',NULL,'2017-02-18 14:20:43'),(19,0,'Verify','POST_HEAD','{}',NULL,'2017-02-18 14:20:43'),(20,0,'Moment','PUT','{\"disallow\": \"userId,date\", \"necessary\": \"id\"}',NULL,'2017-02-01 11:19:51'),(30,0,'Wallet','POST','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"id\"}, \"necessary\": \"payPassword\"}',NULL,'2017-02-18 14:20:43'),(31,0,'Wallet','PUT','{\"Wallet\": {\"verify\": {\"balance+&{}\": \">=-10000,<=10000\"}, \"disallow\": \"!\", \"necessary\": \"id,balance+\"}, \"Password\": {\"disallow\": \"!\", \"necessary\": \"id,password,type\"}}',NULL,'2017-02-18 14:20:43'),(32,0,'Wallet','DELETE','{\"Wallet\": {\"disallow\": \"!\", \"necessary\": \"id\"}, \"necessary\": \"payPassword\"}',NULL,'2017-02-18 14:20:43'),(33,0,'Login','POST_HEAD','{\"disallow\": \"!\", \"necessary\": \"userId,type\"}',NULL,'2017-02-18 14:20:43');
4444
/*!40000 ALTER TABLE `Request` ENABLE KEYS */;
4545
UNLOCK TABLES;
4646
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2017-05-08 15:54:34
56+
-- Dump completed on 2017-05-13 0:12:27

‎table/sys_Response.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -40,7 +40,7 @@ CREATE TABLE `Response` (
4040

4141
LOCK TABLES `Response` WRITE;
4242
/*!40000 ALTER TABLE `Response` DISABLE KEYS */;
43-
INSERT INTO `Response` VALUES (1,NULL,'User','{\"add\": {\"extra\": \"Response is effective!\"}, \"put\": {\"certified\": 0}, \"remove\": \"phone\"}','remove-移除字段;add-如果没有对应字段就添加字段;replace-如果有就替换;put-添加或替换字段','2017-02-01 11:19:51'),(2,'DELETE','Comment','{\"remove\": \"Comment:child\"}',NULL,'2017-05-03 17:51:26');
43+
INSERT INTO `Response` VALUES (1,'GET','User','{\"add\": {\"extra\": \"Response is effective!\"}, \"remove\": \"phone\"}','remove-移除字段;add-如果没有对应字段就添加字段;replace-如果有就替换;put-添加或替换字段','2017-02-01 11:19:51'),(2,'DELETE','Comment','{\"remove\": \"Comment:child\"}',NULL,'2017-05-03 17:51:26');
4444
/*!40000 ALTER TABLE `Response` ENABLE KEYS */;
4545
UNLOCK TABLES;
4646
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -53,4 +53,4 @@ UNLOCK TABLES;
5353
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5454
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5555

56-
-- Dump completed on 2017-05-08 15:54:35
56+
-- Dump completed on 2017-05-13 0:12:27

‎table/sys_Wallet.sql‎

Lines changed: 3 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -24,10 +24,8 @@ DROP TABLE IF EXISTS `Wallet`;
2424
/*!40101 SET character_set_client = utf8 */;
2525
CREATE TABLE `Wallet` (
2626
`id` bigint(15) NOT NULL,
27-
`userId` int(11) NOT NULL,
2827
`balance` decimal(10,2) DEFAULT NULL,
29-
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
30-
PRIMARY KEY (`id`)
28+
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
3129
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
3230
/*!40101 SET character_set_client = @saved_cs_client */;
3331

@@ -37,7 +35,7 @@ CREATE TABLE `Wallet` (
3735

3836
LOCK TABLES `Wallet` WRITE;
3937
/*!40000 ALTER TABLE `Wallet` DISABLE KEYS */;
40-
INSERT INTO `Wallet` VALUES (1,38710,10000.50,'2017-02-01 11:15:44'),(2,70793,500.00,'2017-02-01 11:15:44'),(4,82001,2000.00,'2017-02-01 11:15:44'),(5,82002,2000.00,'2017-02-01 11:15:44'),(6,82003,700.00,'2017-02-01 11:15:44'),(7,82004,100.00,'2017-02-01 11:15:44'),(8,82005,700.00,'2017-02-01 11:15:44');
38+
INSERT INTO `Wallet` VALUES (38710,14912.50,'2017-02-01 11:15:44'),(70793,500.00,'2017-02-01 11:15:44'),(82001,8682.30,'2017-02-01 11:15:44'),(82002,3500.00,'2017-02-01 11:15:44'),(82003,700.00,'2017-02-01 11:15:44'),(82004,100.00,'2017-02-01 11:15:44'),(82005,700.00,'2017-02-01 11:15:44');
4139
/*!40000 ALTER TABLE `Wallet` ENABLE KEYS */;
4240
UNLOCK TABLES;
4341
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
@@ -50,4 +48,4 @@ UNLOCK TABLES;
5048
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
5149
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
5250

53-
-- Dump completed on 2017-05-08 15:54:34
51+
-- Dump completed on 2017-05-13 0:12:27

0 commit comments

Comments
 (0)