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
| SQLite format 3 @ Í
|
| Í Í .G¨
| © ä 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 SgA indexsqlite_autoindex__sqliteexpert_temp_table_1_1_sqliteexpert_temp_table_1
| XÃAAmtable_sqliteexpert_temp_table_1_sqliteexpert_temp_table_1 CREATE TABLE "_sqliteexpert_temp_table_1"(
| [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,
| PRIMARY KEY([deviceId], [time])) X N_9 indexsqlite_autoindex_device_mobile_position_1device_mobile_ ;}O) indexsqlite_autoindex_device_channel_1device_channelP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) Ä ? +W? indexsqlite_autoindex_device_1device F $99
ctabledevice_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 â íÖ *
|
| ¶¶¶ J
|
|
|
