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
54 lines (47 loc) · 6.07 KB
/
sys_Password.sql
File metadata and controls
54 lines (47 loc) · 6.07 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
-- 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` (
`id` bigint(15) NOT NULL,
`model` varchar(20) NOT NULL DEFAULT 'User' COMMENT 'table是关键字不能用!',
`type` varchar(20) DEFAULT NULL,
`password` varchar(20) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!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 (12345678900,'User','0','123456','2017-02-01 11:21:50'),(12345678901,'User','0','123456','2017-02-01 11:21:50'),(12345678902,'User','0','123456','2017-02-01 11:21:50'),(12345678903,'User','0','123456','2017-02-01 11:21:50'),(12345678904,'User','0','apijson','2017-02-01 11:21:50'),(12345678905,'User','0','apijson','2017-02-01 11:21:50'),(12345678906,'User','0','123456','2017-02-01 11:21:50'),(12345678907,'User','0','123456','2017-02-01 11:21:50'),(12345678908,'User','0','123456','2017-02-01 11:21:50'),(12345678909,'User','0','123456','2017-02-01 11:21:50'),(12345678910,'User','0','123456','2017-02-01 11:21:50'),(12345678911,'User','0','123456','2017-02-01 11:21:50'),(12345678912,'User','0','123456','2017-02-01 11:21:50'),(12345678913,'User','0','123456','2017-02-01 11:21:50'),(12345678914,'User','0','123456','2017-02-01 11:21:50'),(12345678915,'User','0','123456','2017-02-01 11:21:50'),(12345678916,'User','0','123456','2017-02-01 11:21:50'),(12345678917,'User','0','123456','2017-02-01 11:21:50'),(12345678918,'User','0','123456','2017-02-01 11:21:50'),(12345678919,'User','0','123456','2017-02-19 13:57:56'),(13000038600,'User',NULL,'123456','2017-03-27 03:26:32'),(13000038601,'User',NULL,'123456','2017-03-27 03:27:06'),(13000038710,'User','1','apijson','2017-02-01 11:21:50'),(13000038711,'User',NULL,'123456','2017-03-04 16:04:02'),(13000038712,'User',NULL,'123456','2017-03-05 09:51:51'),(13000038713,'User',NULL,'123456','2017-03-05 09:52:52'),(13000038714,'User',NULL,'123456','2017-03-05 09:53:37'),(13000038715,'User',NULL,'123456','2017-03-05 09:57:54'),(13000038716,'User',NULL,'123456','2017-03-25 05:44:11'),(13000038717,'User',NULL,'123456','2017-03-25 07:32:19'),(13000038720,'User',NULL,'123456','2017-03-05 15:25:42'),(13000038721,'User',NULL,'123456','2017-03-06 12:29:03'),(13000038722,'User',NULL,'123456','2017-03-30 13:23:40'),(13000038723,'User',NULL,'123456','2017-03-30 13:24:14'),(13000038726,'User',NULL,'123456','2017-04-01 02:50:49'),(13000038730,'User',NULL,'123456','2017-03-12 06:01:23'),(13000038750,'User',NULL,'123456','2017-03-12 11:23:04'),(13000038751,'User',NULL,'123456','2017-03-29 05:01:20'),(13000038752,'User',NULL,'123456','2017-03-29 05:04:49'),(13000038753,'User',NULL,'123456','2017-03-29 14:08:56'),(13000038755,'User',NULL,'123456','2017-04-02 11:03:36'),(13000038790,'User',NULL,'123456','2017-03-27 03:22:32'),(13000070793,'User','0','apijson','2017-02-01 11:21:50'),(13000082000,'User',NULL,'123456','2017-04-02 12:46:10'),(13000082001,'User','1','123456','2017-02-01 11:21:50'),(13000082002,'User','1','123456','2017-02-01 11:21:50'),(13000082003,'User','1','123456','2017-02-01 11:21:50'),(13000082004,'User','0','123456','2017-02-01 11:21:50'),(13000082005,'User','0','123456','2017-02-01 11:21:50'),(13000082006,'User','0','123456','2017-02-01 11:21:50'),(13000082010,'User',NULL,'123456','2017-03-04 15:11:17'),(13000082012,'User','0','123456','2017-02-01 11:21:50'),(13000082015,'User','0','123456','2017-03-04 09:59:34'),(13000082016,'User','0','123456','2017-03-04 10:04:33'),(13000082017,'User','0','123456','2017-03-04 10:05:04'),(13000082018,'User','0','123456','2017-03-04 10:20:27'),(13000082019,'User','0','123456','2017-03-02 16:44:26'),(13000082020,'User','0','123456','2017-03-04 10:22:39'),(13000082021,'User',NULL,'123456','2017-03-04 16:02:05'),(13000082030,'User',NULL,'123456','2017-03-11 15:04:00'),(13000082033,'User',NULL,'123456','2017-03-19 14:49:15'),(13000082040,'User',NULL,'123456','2017-03-11 15:32:25'),(13000082050,'User',NULL,'123456','2017-03-21 14:10:18'),(13000082051,'User',NULL,'123456','2017-03-31 15:21:10'),(13000082056,'User',NULL,'123456','2017-04-02 11:06:48'),(13000082060,'User',NULL,'123456','2017-03-30 12:10:55'),(13000082100,'User',NULL,'123456','2017-03-21 15:22:22'),(13000082101,'User',NULL,'123456','2017-03-21 15:24:05'),(13000082102,'User',NULL,'123456','2017-03-25 07:39:37'),(13000082105,'User',NULL,'123456','2017-04-04 03:56:43'),(13000082111,'User',NULL,'123456','2017-04-03 09:15:48'),(13000090814,'User','1','123456','2017-02-01 11:21:50'),(13000093793,'User','1','123456','2017-02-01 11:21:50'),(99999999999,'User','0','123456','2017-02-01 11:21:50');
/*!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-04-05 10:14:23