forked from Tencent/APIJSON
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsys_Password.sql
More file actions
55 lines (48 loc) · 5.84 KB
/
sys_Password.sql
File metadata and controls
55 lines (48 loc) · 5.84 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)
--
-- Host: localhost Database: sys
-- ------------------------------------------------------
-- Server version 5.7.16
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;
--
-- Table structure for table `Password`
--
DROP TABLE IF EXISTS `Password`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Password` (
`_index` int(11) NOT NULL AUTO_INCREMENT,
`id` bigint(15) NOT NULL,
`type` varchar(20) DEFAULT NULL,
`password` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`_index`),
UNIQUE KEY `_index_UNIQUE` (`_index`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='@deprecated,合并至UserPrivacy';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Password`
--
LOCK TABLES `Password` WRITE;
/*!40000 ALTER TABLE `Password` DISABLE KEYS */;
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');
/*!40000 ALTER TABLE `Password` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2017-07-09 14:39:29