forked from Tencent/APIJSON
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsys_Verify.sql
More file actions
53 lines (46 loc) · 5 KB
/
sys_Verify.sql
File metadata and controls
53 lines (46 loc) · 5 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
-- 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_RES
6A07
ULTS */;
/*!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 `Verify`
--
DROP TABLE IF EXISTS `Verify`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Verify` (
`id` bigint(15) NOT NULL COMMENT '一般存phone',
`type` int(2) DEFAULT NULL COMMENT '类型：\n验证码登录、注册验证手机、修改密码验证手机...',
`code` int(6) 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 `Verify`
--
LOCK TABLES `Verify` WRITE;
/*!40000 ALTER TABLE `Verify` DISABLE KEYS */;
INSERT INTO `Verify` VALUES (13000034949,NULL,6476,'2017-03-25 07:41:56'),(13000037810,NULL,8209,'2017-04-03 09:16:23'),(13000038170,NULL,1710,'2017-03-29 05:09:27'),(13000038600,NULL,3146,'2017-03-27 03:26:22'),(13000038601,NULL,5403,'2017-03-27 03:26:59'),(13000038710,NULL,2599,'2017-04-05 02:02:40'),(13000038711,NULL,8475,'2017-03-25 07:41:45'),(13000038712,NULL,10919,'2017-03-05 09:51:57'),(13000038713,NULL,7619,'2017-03-05 09:52:33'),(13000038714,NULL,1023,'2017-03-05 09:57:32'),(13000038715,NULL,6276,'2017-03-05 09:58:21'),(13000038716,NULL,5603,'2017-03-25 05:43:36'),(13000038717,NULL,2307,'2017-03-25 07:36:05'),(13000038720,NULL,3406,'2017-03-05 15:25:27'),(13000038721,NULL,10609,'2017-03-06 12:28:28'),(13000038722,NULL,1220,'2017-03-30 13:23:31'),(13000038723,NULL,10782,'2017-03-30 13:24:06'),(13000038726,NULL,10467,'2017-04-01 02:51:10'),(13000038727,NULL,10253,'2017-04-01 02:51:15'),(13000038730,NULL,9671,'2017-03-12 06:01:07'),(13000038731,NULL,8913,'2017-03-12 06:01:35'),(13000038750,NULL,7798,'2017-03-27 03:22:16'),(13000038751,NULL,2167,'2017-03-29 05:01:08'),(13000038752,NULL,6390,'2017-03-29 05:09:01'),(13000038753,NULL,2131,'2017-03-29 14:09:08'),(13000038755,NULL,2052,'2017-04-02 11:03:18'),(13000038761,NULL,5678,'2017-03-29 14:07:12'),(13000038790,NULL,1503,'2017-03-27 03:22:24'),(13000038810,NULL,2345,'2017-03-25 07:49:36'),(13000070793,NULL,5825,'2017-03-31 15:30:19'),(13000082000,NULL,9860,'2017-04-02 12:46:05'),(13000082001,NULL,6917,'2017-04-02 11:05:03'),(13000082002,NULL,9157,'2017-03-02 16:44:12'),(13000082005,NULL,10469,'2017-03-12 06:11:28'),(13000082007,NULL,9110,'2017-04-03 09:06:38'),(13000082008,NULL,8179,'2017-04-03 09:06:16'),(13000082009,NULL,4931,'2017-04-04 05:28:33'),(13000082010,NULL,9717,'2017-03-04 15:11:05'),(13000082011,NULL,2001,'2017-04-02 07:50:54'),(13000082012,NULL,6429,'2017-03-04 16:43:53'),(13000082013,NULL,5647,'2017-03-03 19:36:27'),(13000082014,NULL,1158,'2017-03-12 06:02:01'),(13000082015,NULL,6913,'2017-03-04 09:59:19'),(13000082016,NULL,3898,'2017-03-04 10:04:24'),(13000082017,NULL,7215,'2017-03-04 10:04:41'),(13000082018,NULL,1573,'2017-03-30 08:56:34'),(13000082020,NULL,7620,'2017-03-04 10:22:02'),(13000082021,NULL,6403,'2017-03-04 16:01:55'),(13000082022,NULL,10487,'2017-03-04 16:43:33'),(13000082024,NULL,3712,'2017-03-30 08:56:25'),(13000082025,NULL,1912,'2017-03-30 08:56:21'),(13000082030,NULL,6816,'2017-03-11 15:04:20'),(13000082031,NULL,4677,'2017-03-30 08:49:59'),(13000082033,NULL,7243,'2017-03-19 14:49:35'),(13000082034,NULL,2611,'2017-03-19 14:49:49'),(13000082040,NULL,6923,'2017-03-11 15:32:11'),(13000082050,NULL,8885,'2017-03-31 15:28:35'),(13000082051,NULL,9285,'2017-03-31 15:28:29'),(13000082056,NULL,8952,'2017-04-02 11:06:27'),(13000082060,NULL,2399,'2017-03-30 12:10:49'),(13000082100,NULL,3060,'2017-03-21 15:22:13'),(13000082101,NULL,1205,'2017-03-21 15:25:34'),(13000082102,NULL,6776,'2017-03-25 07:39:27'),(13000082105,NULL,9640,'2017-04-04 03:56:31'),(13000082111,NULL,7365,'2017-04-03 09:15:56'),(13000082222,NULL,10384,'2017-03-05 11:18:36'),(15988125475,NULL,4298,'2017-03-04 08:40:08');
/*!40000 ALTER TABLE `Verify` 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:22