1
2
3
4
5
6
7
8
9
10
| SQLite format 3 @ .(j [ 2à{ c Í ,
| A 5í
| ~K:c tableareasareasCREATE TABLE "areas" ("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' )&/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),"args" varchar(255),"icon" varchar(255),"url" varchar(255) , PRIMARY KEY ("uuid"))'; indexsqlite_autoindex_sdks_1sdks< Gtabletask_sdkstask_sdks CREATE TABLE "task_sdks" ("taskid" varchar(255),"sdkid" varchar(100) REFERENCES sdks(uuid) ON DELETE CASCADE,"sort" integer , PRIMARY KEY ("taskid","sdkid"))1 E indexsqlite_autoindex_task_sdks_1task_sdksl %%
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,"del_flag" bool DEFAULT 0,"update_flag" bool DEFAULT 0,"sdk_args" varchar(255),"enable" integer DEFAULT 1 ) 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 tableareaareaCREATE TABLE "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) )
|
|
|
|
|
|
|
