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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
| SQLite format 3 @ & z .K ö %ûö oÝ
| jª§c9»úttµ EY3 indexsqlite_autoindex_platform_gb_channel_1platform_gb_channel<++/tableparent_platformparent_platformCREATE TABLE parent_platform
| (
| enable INTEGER,
| name TEXT,
| serverGBId TEXT not null
| unique,
| serverGBDomain TEXT not null,
| serverIP TEXT not null,
| serverPort INTEGER not null,
| deviceGBId TEXT not null,
| deviceIp TEXT not null,
| devicePort TEXT not null,
| username TEXT not null,
| password TEXT,
| expires TEXT,
| keepTimeout TEXT,
| transport TEXT,
| characterSet TEXT,
| ptz INTEGER,
| rtcp INTEGER,
| status INTEGER,
| id INTEGER
| primary key autoincrement
| )=Q+ indexsqlite_autoindex_parent_platform_1parent_platforml)%indexmedia_server_imedia_server CREATE UNIQUE INDEX media_server_i
| on media_server (ip, httpPort)
9 %%5tablemedia_servermedia_server CREATE TABLE media_server
| (
| ip TEXT not null,
| hookIp REAL not null,
| sdpIp TEXT not null,
| streamIp TEXT not null,
| httpPort INTEGER not null,
| httpSSlPort INTEGER not null,
| rtmpPort INTEGER not null,
| rtmpSSlPort INTEGER not null,
| rtpProxyPort INTEGER not null,
| rtspPort INTEGER not null,
| rtspSSLPort INTEGER not null,
| autoConfig INTEGER not null,
| secret TEXT not null,
| streamNoneReaderDelayMS INTEGER not null,
| rtpEnable INTEGER not null,
| rtpPortRange TEXT not null,
| recordAssistPort INTEGER not null,
| id TEXT
| primary key,
| createTime TEXT not null,
| updateTime TEXT not null
| )7 K% indexsqlite_autoindex_media_server_1media_server
| etablegb_streamgb_stream CREATE TABLE gb_stream
| (
| app TEXT,
| stream TEXT,
| gbId TEXT,
| name TEXT,
| longitude REAL,
| latitude REAL,
| streamType TEXT,
| status INTEGER,
| mediaServerId TEXT not null,
| primary key (app, stream, gbId)
| )1 E indexsqlite_autoindex_gb_stream_1gb_stream
|
| 99
/tabledevice_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
5))%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,
| createTime TEXT,
| updateTime TEXT,
| primary key (channelId, deviceId)
| );O) indexsqlite_autoindex_device_channel_1device_channelJotabledevicedeviceCREATE TABLE device
| (
| deviceId TEXT not null
| primary key,
| name TEXT,
| manufacturer TEXT,
| model TEXT,
| firmware TEXT,
| transport TEXT,
| streamMode TEXT,
| online TEXT,
| registerTime TEXT,
| ip TEXT not null,
| port INTEGER not null,
| hostAddress TEXT not null,
| keepaliveTime TEXT,
| expires INTEGER,
| createTime TEXT not null,
| updateTime TEXT not null,
| mediaServerId TEXT
| )+? indexsqlite_autoindex_device_1device P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence D 0 $ Ü5%%A3%/333 34020000002000000005DH-NVR5864-IDahuaDH-NVR5864-I4.001.0000000.3,2020-10-22UDPUDP02021-12-04 16:34:10192.168.1.19Ä192.168.1.19:50602021-12-04 16:51:112021-12-04 12:04:112021-12-04 16:51:11gb2312
| è 34020000002000000005 Õ÷Õ㺪 Þ 2 + ã parent_platform_dg_tmp role +parent_platform user ww 5% 5 % _5 3334020000001310000001éé1DahuaDH-NVR5864-I0340200axy340200000020000000050192.168.1.17 34020000002000000005_340200000013100000013402000000200000000502021-12-04 12:04:112021-12-04 12:04:11 ª5!% 5 5 3334020000001310000065GB_Chn_065DahuaDH-NVR5864-I0340200axy3402000000200000000503402000000200000000502021-12-04 12:04:112021-12-04 12:04:11
| ¥Ó [3402000000131000000134020000002000000005 - 3402000000131000006534020000002000000005
|
|
| ÷ ÷ admin
| z ® ö ¹ +
| ö
| Át
| ^ n V*tableuseruser"CREATE TABLE "user"
| (
| id INTEGER
| primary key autoincrement,
| username TEXT not null,
| password TEXT not null,
| roleId INTEGER not null,
| createTime TEXT not null,
| updateTime Text not null
| ) (tableloglog CREATE TABLE "log"
| (
| id INTEGER
| primary key autoincrement,
| name TEXT not null,
| type TEXT not null,
| uri TEXT not null,
| address TEXT not null,
| result TEXT not null,
| timing INTEGER not null,
| username TEXT not null,
| createTime TEXT not null
| ) 0stabledevicedeviceCREATE TABLE "device" (
| "deviceId" TEXT NOT NULL,
| "name" TEXT,
| "manufacturer" TEXT,
| "model" TEXT,
| "firmware" TEXT,
| "transport" TEXT,
| "streamMode" TEXT,
| "online" TEXT,
| "registerTime" TEXT,
| "ip" TEXT NOT NULL,
| "port" INTEGER NOT NULL,
| "hostAddress" TEXT NOT NULL,
| "keepaliveTime" TEXT,
| "expires" INTEGER,
| "createTime" TEXT NOT NULL,
| "updateTime" TEXT NOT NULL,
| "mediaServerId" TEXT,
| "charset" TEXT NOT NULL, subscribeCycleForCatalog int default 0 not null,
| PRIMARY KEY("deviceId")
| )I-utablerolerole!CREATE TABLE "role" (
| "id" INTEGER,
| "name" TEXT NOT NULL,
| "authority" TEXT NOT NULL,
| "createTime" TEXT NOT NULL,
| "updateTime" TEXT NOT NULL,
| PRIMARY KEY("id" AUTOINCREMENT)
| )a+5indexuser_username_uindexuser CREATE UNIQUE INDEX user_username_uindex
| on user (username)3G! indexsqlite_autoindex_recordInfo_2recordInfo3G! indexsqlite_autoindex_recordInfo_1recordInfoL!!ctablerecordInforecordInfoCREATE TABLE recordInfo
| (
| id INTEGER
| primary key autoincrement,
| app TEXT not null
| unique,
| stream TEXT not null
| unique,
| mediaServerId TEXT not null,
| createTime TEXT not null,
| type INTEGER not null,
| deviceId TEXT,
| channelId TEXT,
| name TEXT
| ) ? ;O) indexsqlite_autoindex_device_channel_1device_channel
5))%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,
| createTime TEXT,
| updateTime TEXT,
| primary key (channelId, deviceId)
| )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)
| 2 Ó ä
| ñ
| ¸ ´ }}J2ù¿Ù5 î « « D%%mtablemedia_servermedia_server CREATE TABLE "media_server" (
| "ip" TEXT NOT NULL,
| "hookIp" REAL NOT NULL,
| "sdpIp" TEXT NOT NULL,
| "streamIp" TEXT NOT NULL,
| "httpPort" INTEGER NOT NULL,
| "httpSSlPort" INTEGER NOT NULL,
| "rtmpPort" INTEGER NOT NULL,
| "rtmpSSlPort" INTEGER NOT NULL,
| "rtpProxyPort" INTEGER NOT NULL,
| "rtspPort" INTEGER NOT NULL,
| "rtspSSLPort" INTEGER NOT NULL,
| "autoConfig" INTEGER NOT NULL,
| "secret" TEXT NOT NULL,
| "streamNoneReaderDelayMS" INTEGER NOT NULL,
| "rtpEnable" INTEGER NOT NULL,
| "rtpPortRange" TEXT NOT NULL,
| "recordAssistPort" INTEGER NOT NULL,
| "id" TEXT,
| "createTime" TEXT NOT NULL,
| "updateTime" TEXT NOT NULL,
| "defaultServer" INTEGER NOT NULL DEFAULT 0,
| "sendRtpPortRange" TEXT,
| "hookAliveInterval" INTEGER NOT NULL,
| PRIMARY KEY("id")
| )1:E indexsqlite_autoindex_gb_stream_1gb_stream }9 Itablegb_streamgb_streamCREATE TABLE "gb_stream" (
| "app" TEXT,
| "stream" TEXT,
| "gbId" TEXT,
| "name" TEXT,
| "longitude" REAL,
| "latitude" REAL,
| "streamType" TEXT,
| "status" INTEGER,
| "mediaServerId" TEXT NOT NULL,
| PRIMARY KEY("app","stream")
| )58I# indexsqlite_autoindex_stream_push_1stream_push7##Itablestream_pushstream_pushCREATE TABLE "stream_push"
| (
| app TEXT,
| stream TEXT,
| totalReaderCount TEXT,
| originType INTEGER,
| originTypeStr TEXT,
| createStamp INTEGER,
| aliveSecond INTEGER,
| mediaServerId TEXT not null,
| primary key (app, stream)
| )76K% indexsqlite_autoindex_stream_proxy_1stream_proxy#5%% tablestream_proxystream_proxyCREATE 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,
| mediaServerId TEXT not null,
| createTime TEXT not null, enable_remove_none_reader INTEGER,
| primary key (app, stream)
| )K4_9 indexsqlite_autoindex_device_mobile_position_1device_mobile_position#399
Qtabledevice_mobile_positiondevice_mobile_position CREATE 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,
| "channelId" TEXT NOT NULL,
| PRIMARY KEY("deviceId","time")
| )N2%%_tabledevice_alarmdevice_alarm CREATE TABLE "device_alarm" (
| "id" INTEGER,
| "deviceId" TEXT NOT NULL,
| "alarmPriority" TEXT NOT NULL,
| "alarmMethod" TEXT,
| "alarmTime" TEXT NOT NULL,
| "alarmDescription" TEXT,
| "longitude" REAL,
| "latitude" REAL,
| "alarmType" TEXT,
| "channelId" TEXT NOT NULL,
| PRIMARY KEY("id" AUTOINCREMENT)
| )+1? indexsqlite_autoindex_device_1device
|
| ÂL =- -10001098080_581111110rtmp_pusha« Xi6qLZA }- -10001098080_586887580rtsp_pusha«+mi6qLZA288yREdJEV >- -10001098080_586887580rtsp_pusha«+Îi6qLZA288yREdJEV
| çæÒ 10001098080 8 410001098080_58688758 10001098080_58688758 ·i /3 -10001098080_5868875891112222211111111117æ¯æi6qLZA288yREdJEV M I
| çÈ 810001098080_586887589
| ÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷÷ Ì Ì 2 33admin02021-04-13 14:14:572021-04-13 14:14:57 ¬ ¬ R M 33admin21232f297a57a5a743894a0e4a801fc32021-04-13 14:14:572021-04-13 14:14:57
|
|
| ¦ ÇQ Ü ¾¦ Ø ØrØm99otabl\f++otableparent_platformparent_platform CREATE TABLE "parent_platform"
| (
| enable INTEGER,
| name TEXT,
| serverGBId TEXT not null
| unique,
| serverGBDomain TEXT not null,
| serverIP TEXT not null,
| serverPort INTEGER not null,
| deviceGBId TEXT not null,
| deviceIp TEXT not null,
| devicePort TEXT not null,
| username TEXT not null,
| password TEXT,
| expires TEXT,
| keepTimeout TEXT,
| transport TEXT,
| characterSet TEXT,
| ptz INTEGER,
| rtcp INTEGER,
| status INTEGER,
| id INTEGER
| primary key autoincrement,
| shareAllLiveStream INTEGER,
| catalogId TEXT not null
| ) # --OtIh--Etableplatform_catalogplatform_catalogCREATE TABLE "platform_catalog"
| (
| id TEXT
| primary key,
| platformId TEXT not null,
| name TEXT not null,
| parentId TEXT
| )EcY3 indexsqlite_autoindex_platform_gb_channel_1platform_gb_channel& btS- indexsqlite_autoindex_platform_catalog_1platform_catalog Ð>Q+ indexsqlite_autoindex_parent_platform_1parent_platform bt++itableparent_platformparent_platformCREATE TABLE "parent_platform" (
| "enable" INTEGER,
| "name" TEXT,
| "serverGBId" TEXT NOT NULL UNIQUE,
| "serverGBDomain" TEXT NOT NULL,
| "serverIP" TEXT NOT NULL,
| "serverPort" INTEGER NOT NULL,
| "deviceGBId" T\hWh;;Etableplatform_catalog_dg_tmpplatform_catalog_dg_tmpCREATE TABLE "platform_catalog"
| (
| id TEXT
| primary key,
| platformId TEXT not null,
| name TEXT not null,
| parentId TEXT
| )Mia; indexsqlite_au?iS- indexsqlite_autoindex_platform_catalog_1platform_catalog=gQ+ indexsqlite_autoindex_parent_platform_1parent_platform$Hb337tableplatform_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,
| catalogId TEXT not null,
| primary key (deviceAndChannelId, platformId)
| )þ \W1 indexsqKg_9 indexsqlite_autoindex_parent_platform_dg_tmp_1parent_platform_dg_tmp$CeW1 indexsqlite_autoindex_platform_gb_stream_1platform_gb_streamxd11tableplatform_gb_streamplatform_gb_streamCREATE TABLE "platform_gb_stream"
| (
| platformId TEXT not null,
| app TEXT not null,
| stream TEXT not null,
| catalogId TEXT not null,
| primary key (platformId, app, stream)
| ) Se? indexsqlite_autoindex_platform_gb_stream_dg_tmp_1platform_gb_stream_dg_tmptF)%'indexmedia_server_imedia_server CREATE UNIQUE INDEX "media_server_i" ON "media_server" (
| "ip",
| "httpPort"
| )7EK% indexsqlite_autoindex_media_server_1media_server
|
|
|
|
