Skip to content

Commit 9ae5629

Browse files
TommyLemonTommyLemon
committed
同步table
1 parent bdf1ad1 commit 9ae5629

File tree

12 files changed

+72
-20
lines changed

12 files changed

+72
-20
lines changed

‎table/sys_Comment.sql‎

Lines changed: 2 additions & 2 deletions
Large diffs are not rendered by default.

‎table/sys_Login.sql‎

Lines changed: 3 additions & 3 deletions
Large diffs are not rendered by default.

‎table/sys_Moment.sql‎

Lines changed: 2 additions & 2 deletions
Large diffs are not rendered by default.

‎table/sys_Pair.sql‎

Lines changed: 52 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,52 @@
1+
-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)
2+
--
3+
-- Host: localhost Database: sys
4+
-- ------------------------------------------------------
5+
-- Server version 5.7.16
6+
7+
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8+
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9+
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10+
/*!40101 SET NAMES utf8 */;
11+
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12+
/*!40103 SET TIME_ZONE='+00:00' */;
13+
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14+
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15+
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16+
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17+
18+
--
19+
-- Table structure for table `Pair`
20+
--
21+
22+
DROP TABLE IF EXISTS `Pair`;
23+
/*!40101 SET @saved_cs_client = @@character_set_client */;
24+
/*!40101 SET character_set_client = utf8 */;
25+
CREATE TABLE `Pair` (
26+
`id` bigint(20) NOT NULL,
27+
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28+
`userId` bigint(20) NOT NULL,
29+
`toUserId` bigint(20) DEFAULT NULL,
30+
PRIMARY KEY (`id`)
31+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='对，一般用于朋友关系等。\n添加好友时创建一条row，但toUserId是空的，toUser同意后就修改toUserId';
32+
/*!40101 SET character_set_client = @saved_cs_client */;
33+
34+
--
35+
-- Dumping data for table `Pair`
36+
--
37+
38+
LOCK TABLES `Pair` WRITE;
39+
/*!40000 ALTER TABLE `Pair` DISABLE KEYS */;
40+
/*!40000 ALTER TABLE `Pair` ENABLE KEYS */;
41+
UNLOCK TABLES;
42+
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
43+
44+
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
45+
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
46+
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
47+
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
48+
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
49+
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
50+
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
51+
52+
-- Dump completed on 2017-05-08 15:54:34

‎table/sys_Password.sql‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -31,7 +31,7 @@ CREATE TABLE `Password` (
3131
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
3232
PRIMARY KEY (`id`),
3333
UNIQUE KEY `_index_UNIQUE` (`_index`)
34-
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
34+
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
3535
/*!40101 SET character_set_client = @saved_cs_client */;
3636

3737
--
@@ -40,7 +40,7 @@ CREATE TABLE `Password` (
4040

4141
LOCK TABLES `Password` WRITE;
4242
/*!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'),(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'),(33,13000038790,'User',NULL,'123456','2017-03-27 03:22:32'),(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'),(60,99999999999,'User','0','123456','2017-02-01 11:21:50');
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');
4444
/*!40000 ALTER TABLE `Password` 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-04-23 16:15:46
56+
-- Dump completed on 2017-05-08 15:54:34

‎table/sys_Request.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-04 2:30:14
56+
-- Dump completed on 2017-05-08 15:54:34

‎table/sys_Response.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -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-04 2:30:14
56+
-- Dump completed on 2017-05-08 15:54:35

0 commit comments

Comments
 (0)