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
| SQLite format 3 @ V .?Ù X
| © ü
| © Ä w w X X X X Xù Xé XÕ Xe Z6))otabledevice_channeldevice_channelCREATE TABLE "device_channel" (
| "channelId" TEXT NOT NULL,
| "name" TEXT,
| "manufacture" TEXT,
| "model" TEXT,
| "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,
| "PTZTypeText" TEXT,
| "status" INTEGER,
| "longitude" REAL,
| "latitude" REAL,
| "streamId" TEXT,
| "deviceId" INTEGER NOT NULL,
| PRIMARY KEY("channelId")
| )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq). l ;7O) indexsqlite_autoindex_device_channel_1device_channel+(? indexsqlite_autoindex_device_1device Î ']tabledevicedeviceCREATE TABLE "device" (
| "deviceId" TEXT NOT NULL,
| "name" TEXT,
| "manufacturer" TEXT,
| "model" TEXT,
| "firmware" TEXT,
| "transport" TEXT,
| "streamMode" TEXT,
| "online" TEXT,
| "registerTimeMillis" INTEGER,
| PRIMARY KEY("deviceId")
| ) íÖ *
|
|
|
|
