forked from APIJSON/APIJSON-Demo
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathsys_System.sql
More file actions
56 lines (49 loc) · 5.71 KB
/
Copy pathsys_System.sql
File metadata and controls
56 lines (49 loc) · 5.71 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
56
-- MySQL dump 10.13 Distrib 5.7.17, for macos10.12 (x86_64)
--
-- Host: apijson.cn Database: sys
-- ------------------------------------------------------
-- Server version 5.7.19-log
/*!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 `System`
--
DROP TABLE IF EXISTS `System`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `System` (
`id` bigint(15) NOT NULL COMMENT '唯一标识',
`userId` bigint(15) NOT NULL,
`type` varchar(45) NOT NULL DEFAULT '0' COMMENT '类型：0 - Android OS, 1 - iOS, 3 - HarmonyOS, 4 - Tizen',
`brand` varchar(45) NOT NULL COMMENT '品牌。Xiaomi MIUI, Meizu Flyme, Huawei HiOS, Huawei HornorOS, Apple iPad OS, Apple Watch OS 等',
`versionCode` varchar(45) NOT NULL COMMENT '版本号 int 值，不是名称。',
`versionName` varchar(45) NOT NULL COMMENT '版本号名称',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `System`
--
LOCK TABLES `System` WRITE;
/*!40000 ALTER TABLE `System` DISABLE KEYS */;
INSERT INTO `System` VALUES (1601929575252,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:26:15'),(1601929715716,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:28:35'),(1601929992921,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:33:12'),(1601930423250,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:40:23'),(1601930494939,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:41:34'),(1601930555709,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:42:35'),(1601930618717,82001,'0','Xiaomi MIUI','14','14.0','2020-10-05 20:43:38'),(1601972574424,82001,'0','Xiaomi MIUI','14','14.0','2020-10-06 08:22:54'),(1602055684628,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 07:28:04'),(1602057315642,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 07:55:15'),(1602057545626,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 07:59:05'),(1602060059486,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 08:40:59'),(1602060270886,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 08:44:30'),(1602061034817,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 08:57:14'),(1602061530596,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 09:05:30'),(1602065812805,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:16:52'),(1602066287656,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:24:47'),(1602066545689,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:29:05'),(1602067252715,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:40:52'),(1602067871797,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:51:11'),(1602068377124,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 10:59:37'),(1602070009484,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 11:26:49'),(1602082759614,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 14:59:19'),(1602084332203,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 15:25:32'),(1602084643701,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 15:30:43'),(1602085266441,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 15:41:06'),(1602085669675,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 15:47:49'),(1602088334588,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 16:32:14'),(1602089560241,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 16:52:40'),(1602089630451,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 16:53:50'),(1602090095173,82001,'0','Xiaomi MIUI','14','14.0','2020-10-07 17:01:35'),(1602322054259,82001,'0','Xiaomi MIUI','14','14.0','2020-10-10 09:27:34'),(1602475089014,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 03:58:09'),(1602493112111,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 08:58:32'),(1602493797410,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:09:57'),(1602494010115,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:13:30'),(1602494348809,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:19:08'),(1602494649560,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:24:09'),(1602494933229,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:28:53'),(1602495177826,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:32:57'),(1602495322871,82001,'0','Xiaomi MIUI','14','14.0','2020-10-12 09:35:22'),(1602958186093,82001,'0','Xiaomi MIUI','14','14.0','2020-10-17 18:09:46'),(1602958538326,82001,'0','Xiaomi MIUI','14','14.0','2020-10-17 18:15:38'),(1602959335909,82001,'0','Xiaomi MIUI','14','14.0','2020-10-17 18:28:55'),(1602959548052,82001,'0','Xiaomi MIUI','14','14.0','2020-10-17 18:32:28'),(1603041790458,82001,'0','Xiaomi MIUI','14','14.0','2020-10-18 17:23:10'),(1603101611834,82001,'0','Xiaomi MIUI','14','14.0','2020-10-19 10:00:11');
/*!40000 ALTER TABLE `System` 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 2020-10-28 1:57:45