forked from keaijohnee/OpenMDMServer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathopenmdmserver.sql
108 lines (94 loc) · 4.38 KB
/
openmdmserver.sql
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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`account` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`password` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`role` varchar(10) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `apps`;
CREATE TABLE `apps` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`appName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`bundleSize` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`deviceId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`dynamicSize` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`identifier` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`managedAppsOnly` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`shortVersion` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`version` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `command`;
CREATE TABLE `command` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`callBack` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`command` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`ctype` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`cvalue` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`doIt` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`result` longtext COLLATE utf8_bin,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`availableDeviceCapacity` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`batteryLevel` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`bluetoothMAC` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`control` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`deviceCapacity` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceFlag` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`iccid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`imei` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`isActivationLockEnabled` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`isCloudBackupEnabled` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`isDeviceLocatorServiceEnabled` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`isSupervised` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`meid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`model` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`modelName` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`oSVersion` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`pushMagic` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`serialNumber` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`token` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`topic` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`udid` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`unlockToken` longtext COLLATE utf8_bin,
`updateTime` datetime DEFAULT NULL,
`wifimac` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `devicetemp`;
CREATE TABLE `devicetemp` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`callBack` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceFlag` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `profile`;
CREATE TABLE `profile` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`createTime` datetime DEFAULT NULL,
`ctype` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`deviceId` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`result` longtext COLLATE utf8_bin,
`updateTime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` varchar(255) COLLATE utf8_bin NOT NULL,
`email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`password` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`remark` varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
SET FOREIGN_KEY_CHECKS = 1;