test

liuxiaolong

2019-06-27 8ceae6fc8ef80a43e1c5e4c82487963a3450cb7b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SQLite format 3

@  5
5.(j  O€2à{ WÁ  
5    )áþ­Êz€¡ O
)‚
„tablesdkssdksCREATE TABLE "sdks" ("uuid" varchar(255),"create_time" varchar(255),"update_time" varchar(255),"create_by" varchar(255),"del_flag" varchar(255),"enabled" varchar(255),"sdk_name" varchar(255),"icon" varchar(255),"url" varchar(255),"args" blob , PRIMARY KEY ("uuid"))';
indexsqlite_autoindex_sdks_1sdks-
‚)tabletask_sdkstask_sdks CREATE TABLE "task_sdks" ("taskid" varchar(255),"sdkid" varchar(100) REFERENCES sdks(uuid) ON DELETE CASCADE , PRIMARY KEY ("taskid","sdkid"))1 E
indexsqlite_autoindex_task_sdks_1task_sdks‚1%%
„%tablecamera_taskscamera_tasksCREATE TABLE "camera_tasks" ("cameraid" varchar(100) REFERENCES cameras(id) ON DELETE CASCADE,"taskid" varchar(100) REFERENCES tasks(taskid) ON DELETE CASCADE,"sdkid" varchar(100) REFERENCES sdks(uuid) ON DELETE CASCADE,"sdkname" varchar(255),"sdk_args" varchar(255) )‚    
„tabletaskstasks
CREATE TABLE "tasks" ("taskid" varchar(255),"taskname" varchar(100),"create_at" datetime,"createby" varchar(255),"update_at" datetime,"enable" bool DEFAULT 0,"is_alarm" bool DEFAULT 0,"del_flag" bool DEFAULT 0,"isfull" bool DEFAULT 0 , PRIMARY KEY ("taskid")))
=
indexsqlite_autoindex_tasks_1tasks‚    11
ƒ=tableVSSLocalSettingTblVSSLocalSettingTbl    CREATE TABLE "VSSLocalSettingTbl" ("id" integer primary key autoincrement,"ServerIp" varchar(255),"ServerPort" integer,"ServerId" varchar(255),"UserAuthId" varchar(255),"Password" varchar(255),"UpdateTime" datetime )ƒ    ''
…Qtablelocal_configslocal_configsCREATE TABLE "local_configs" ("id" integer primary key autoincrement,"alarm_ip" varchar(255),"alarm_port" integer,"web_pic_ip" varchar(255),"web_pic_port" integer,"es_pic_ip" varchar(255),"es_pic_port" integer,"cut_max_duration" integer,"cut_min_duration" integer,"dev_id" varchar(255),"dev_name" varchar(255),"dev_type" integer,"reserved" varchar(255) )‚\
…tablecamerascamerasCREATE TABLE "cameras" ("id" varchar(100) UNIQUE,"name" varchar(255),"type" integer,"areaid" integer,"addr" varchar(255),"longitude" real,"latitude" real,"rtsp" varchar(255),"ip" varchar(255),"port" integer,"username" varchar(255),"password" varchar(255),"brand" varchar(255),"reserved" varchar(255) , PRIMARY KEY ("id"))-A
indexsqlite_autoindex_cameras_1cameras‚!
„tablecam_areacam_areaCREATE TABLE "cam_area" ("id" integer primary key autoincrement,"parentid" integer,"parentids" varchar(255),"name" varchar(255),"createby" integer DEFAULT 10000,"createtime" datetime DEFAULT '2010-08-28T13:40:02.200',"reserved" varchar(255) DEFAULT 'galeone' )c7
indexidx_people_deleted_atpeopleCREATE INDEX idx_people_deleted_at ON "people"(deleted_at) P++
Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)K

‚qtablepeoplepeopleCREATE TABLE "people" ("id" integer primary key autoincrement,"created_at" datetime,"updated_at" datetime,"deleted_at" datetime,"user_name" varchar(255),"password" varchar(255) )  
òò

cam_area
 £Ðžl<
Ø£3
;0,1,3area3'2010-08-28T13:40:02.200galeone0    ;0,1area2'2010-08-28T13:40:02.200galeone0    ;0,1area1'2010-08-28T13:40:02.200galeone.;0area0'2010-08-28T13:40:02.200galeone0    ;0,1area2'2010-08-28T13:40:02.200galeone0    ;0,1area1'2010-08-28T13:40:02.200galeone.
;0area0'2010-08-28T13:40:02.200galeone œ‚ͳ#ÀG Î Zæjò.
%     cid0摄像机AAAaefafewahaikangvU    g    C0057FDF-7E7E-0185-AAB5-E5143E260A8Fpanlei我天的rtsp://admin123:admin123@172.16.0.155:554/camhaikangzU    %g    3AEEB583-63B5-ACCB-E8E6-E88AD3D2BF62panlei2哈哈哈哈rtsp://admin123:admin123@172.16.0.155:554/camhaikangr
U    g    B67705C0-D9D2-5A4F-50F6-1B4D88EFF3DBpanlei1你好rtsp://admin123:admin123@172.16.0.155:554/camdahuar    U    g    FED152F1-0472-CD1E-3032-A5DD8B7A909Bpanlei1你好rtsp://admin123:admin123@172.16.0.155:554/camdahuawU    !g    9E3C9FCF-47DA-50BE-9F6D-1910E168635Bpanleihaahaaaaaartsp://admin123:admin123@172.16.0.155:554/camhaikangwU    !g    D5C30D96-47DB-6E68-7B55-A474F3D7E5D3panleihaahaaaaaartsp://admin123:admin123@172.16.0.155:554/camhaikangaU    56B731D4-F3B7-DE83-FF53-2AA59FAC01A0hahhstringstringstringstringstringstringstring]U     #71F5A130-027C-EAD8-2402-BA9294047E46banqiuhandan192.169.1.1 haha123dahuahahah
cid1cam1ç
cid3cam3
cid2cam2    cid0cam0
•¾‹´9ç•bøïæÝ(U
C0057FDF-7E7E-0185-AAB5-E5143E260A8F(U
3AEEB583-63B5-ACCB-E8E6-E88AD3D2BF62(U
B67705C0-D9D2-5A4F-50F6-1B4D88EFF3DB
(U
FED152F1-0472-CD1E-3032-A5DD8B7A909B    (U
9E3C9FCF-47DA-50BE-9F6D-1910E168635B(U
D5C30D96-47DB-6E68-7B55-A474F3D7E5D3(U
56B731D4-F3B7-DE83-FF53-2AA59FAC01A0(U
71F5A130-027C-EAD8-2402-BA9294047E46
cid3
cid2
cid1    cid0   ,Ë–a,3
U5b0902ae-b1bd-43c0-816d-0a87f1f859d4task43
U5b0902ae-b1bd-43c0-816d-0a87f1f859d3task33
U5b0902ae-b1bd-43c0-816d-0a87f1f859d2task23

U5b0902ae-b1bd-43c0-816d-0a87f1f859d1task1
]د†](U
5b0902ae-b1bd-43c0-816d-0a87f1f859d4(U
5b0902ae-b1bd-43c0-816d-0a87f1f859d3(U
5b0902ae-b1bd-43c0-816d-0a87f1f859d2'U    5b0902ae-b1bd-43c0-816d-0a87f1f859d1 ||||
„ 

{{{{{
… P¨PVU     #E  c6af3d21-13e8-423a-94f8-a7c7c9a9bdcclongsdknamehttp://ip:port/govideo/sdk/1V
U     #E 911c2631-e282-4442-9c2c-5faa007ae5eflongsdknamehttp://ip:port/govideo/sdk/1
¯Ø¯(U
c6af3d21-13e8-423a-94f8-a7c7c9a9bdcc'U    911c2631-e282-4442-9c2c-5faa007ae5ef