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_sdks1 %%%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' )c7indexidx_people_deleted_atpeopleCREATE INDEX idx_people_deleted_at ON "people"(deleted_at) P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)KqtablepeoplepeopleCREATE 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/camhaikangz U %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øïæÝ (UC0057FDF-7E7E-0185-AAB5-E5143E260A8F (U3AEEB583-63B5-ACCB-E8E6-E88AD3D2BF62 (UB67705C0-D9D2-5A4F-50F6-1B4D88EFF3DB
| (UFED152F1-0472-CD1E-3032-A5DD8B7A909B (U9E3C9FCF-47DA-50BE-9F6D-1910E168635B(UD5C30D96-47DB-6E68-7B55-A474F3D7E5D3(U56B731D4-F3B7-DE83-FF53-2AA59FAC01A0(U71F5A130-027C-EAD8-2402-BA9294047E46cid3cid2cid1 cid0 , Ëa, 3
| U 5b0902ae-b1bd-43c0-816d-0a87f1f859d4task43
| U 5b0902ae-b1bd-43c0-816d-0a87f1f859d3task33
| U 5b0902ae-b1bd-43c0-816d-0a87f1f859d2task23
| U 5b0902ae-b1bd-43c0-816d-0a87f1f859d1task1
| ] د] (U5b0902ae-b1bd-43c0-816d-0a87f1f859d4(U5b0902ae-b1bd-43c0-816d-0a87f1f859d3(U5b0902ae-b1bd-43c0-816d-0a87f1f859d2'U 5b0902ae-b1bd-43c0-816d-0a87f1f859d1 ||||
| {{{{{
P ¨P V U #E c6af3d21-13e8-423a-94f8-a7c7c9a9bdcclongsdknamehttp://ip:port/govideo/sdk/1V U #E 911c2631-e282-4442-9c2c-5faa007ae5eflongsdknamehttp://ip:port/govideo/sdk/1
| ¯ د (Uc6af3d21-13e8-423a-94f8-a7c7c9a9bdcc'U 911c2631-e282-4442-9c2c-5faa007ae5ef
|
|
