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
| SQLite format 3 @ È Ä È .?Ù
| © ä X ä É ~ ~
| ©
| ©
| ©ñ
| ©z 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")
| ) X ;}O) indexsqlite_autoindex_device_channel_1device_channelP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) Ä ? +W? indexsqlite_autoindex_device_1device < â íÖ *
| ¶¶¶ J
|
|
|
