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
| SQLite format 3 @ Ð ù Ð .?Ù
| ©
| X ä Éú²
| r
| × r
| ©
| ©
| ©ñ V++ctableparent_platformparent_platform CREATE TABLE "parent_platform" (
| "enable" BLOB,
| "name" TEXT,
| "serverGBId" TEXT,
| "serverGBDomain" TEXT,
| "serverIP" TEXT,
| "serverPort" INTEGER,
| "deviceGBId" TEXT NOT NULL,
| "deviceIp" TEXT,
| "devicePort" TEXT,
| "username" TEXT,
| "password" TEXT,
| "expires" TEXT,
| "keepTimeout" TEXT,
| "transport" TEXT,
| "characterSet" TEXT,
| "PTZEnable" BLOB,
| "rtcp" BLOB,
| "status" BLOB,
| PRIMARY KEY("serverGBId")
| )q|)) tabledevice_channeldevice_channelCREATE TABLE "device_channel" (
| "channelId" TEXT NOT NULL,
| "name" TEXT,
| "manufacture" TEXT,
| "model" BLOB,
| "owner" TEXT,
| "civilCode" TEXT,
| "block" TEXT,
| "address" TEXT,
| "parentId" TEXT,
| "safetyWay" INTEGER,
| "registerWay" INTEGER,
| "certNum" TEXT,
| "certifiable" INTEGER,
| "errCode" INTEGER,
| "endTime" TEXT,
| "secrecy" TEXT,
| "ipAddress" TEXT,
| "port" INTEGER,
| "password" TEXT,
| "PTZType" INTEGER,
| "status" INTEGER,
| "longitude" REAL,
| "latitude" REAL,
| "streamId" TEXT,
| "deviceId" TEXT NOT NULL,
| "parental" TEXT,
| "hasAudio" BLOB,
| PRIMARY KEY("channelId","deviceId")
| )NVwtabledevicedeviceCREATE TABLE "device" (
| "deviceId" TEXT NOT NULL,
| "name" TEXT,
| "manufacturer" TEXT,
| "model" TEXT,
| "firmware" TEXT,
| "transport" TEXT,
| "streamMode" TEXT,
| "online" TEXT,
| "registerTimeMillis" INTEGER,
| "ip" TEXT NOT NULL,
| "port" INTEGER NOT NULL,
| "hostAddress" TEXT NOT NULL,
| PRIMARY KEY("deviceId")
| ) À . N~33Ctableparent_platform_oldpare99
Itabledevice_mobile_positiondevice_mobile_positionCREATE TABLE [device_mobile_position](
| [deviceId] TEXT NOT NULL,
| [deviceName] TEXT,
| [time] TEXT NOT NULL,
| [longitude] REAL NOT NULL,
| [latitude] REAL NOT NULL,
| [altitude] REAL,
| [speed] REAL,
| [direction] REAL,
| [reportSource] TEXT,
| [geodeticSystem] TEXT,
| [cnLng] TEXT,
| [cnLat] TEXT,
| PRIMARY KEY([deviceId], [time]))K _9 indexsqlite_autoindex_device_mobile_position_1device_mobile_position X ;}O) indexsqlite_autoindex_device_channel_1device_channelP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) Ä ? +W? indexsqlite_autoindex_device_1device ® =Q+ indexsqlite_autoindex_parent_platform_1parent_platform EY3 indexsqlite_autoindex_platform_gb_channel_1platform_gb_channel 33+tableplatform_gb_channelplatform_gb_channel
| CREATE TABLE "platform_gb_channel" (
| "channelId" TEXT NOT NULL,
| "deviceId" TEXT NOT NULL,
| "platformId" TEXT NOT NULL,
| "deviceAndChannelId" TEXT NOT NULL,
| PRIMARY KEY("deviceAndChannelId","platformId")
| ) â íÖ *
|
| ¶¶¶ J
|
|
|
|
|
