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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
| SQLite format 3 @ ä ù ä .?Ù ô ? ®]0 ¼
| y
| 1W|.UY%
? ô½ ô í H Í ô CHW1 indexsqlite_autoindex_platform_gb_stream_1platform_gb_streamLG11Ctableplatform_gb_streamplatform_gb_streamCREATE TABLE "platform_gb_stream" (
| "platformId" TEXT NOT NULL,
| "app" TEXT NOT NULL,
| "stream" TEXT NOT NULL,
| PRIMARY KEY("platformId","app","stream")
| )7"K% indexsqlite_autoindex_stream_proxy_1stream_proxya!%%
tablestream_proxystream_proxy CREATE TABLE "stream_proxy" (
| "type" TEXT NOT NULL,
| "app" TEXT NOT NULL,
| "stream" TEXT NOT NULL,
| "url" TEXT,
| "src_url" TEXT,
| "dst_url" BLOB,
| "timeout_ms" INTEGER,
| "ffmpeg_cmd_key" TEXT,
| "rtp_type" TEXT,
| "enable_hls" INTEGER,
| "enable_mp4" INTEGER,
| "enable" INTEGER NOT NULL,
| PRIMARY KEY("app","stream")
| ) 1 1BE indexsqlite_autoindex_gb_stream_1gb_streamQA qtablegb_streamgb_streamCREATE TABLE "gb_stream" (
| "app" TEXT,
| "stream" TEXT,
| "gbId" TEXT,
| "name" TEXT,
| "longitude" REAL,
| "latitude" REAL,
| "streamType" TEXT,
| PRIMARY KEY("app","stream","gbId")
| )K _9 indexsqlite_autoindex_device_mobile_position_1device_mobile_position99
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]))=Q+ indexsqlite_autoindex_parent_platform_1parent_platform 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")
| )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")
| );}O) indexsqlite_autoindex_device_channel_1device_channelq|)) 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")
| )+W? indexsqlite_autoindex_device_1deviceNVwtabledevicedeviceCREATE 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")
| )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) â ïØ (
|
| ¶¶¶ J
|
|
|
|
|
|
|
|
