优化云端录像定时清理

648540858

2023-10-19 daac0010b16fc03ef72b6b0712b5ba38dde2801d

 sql/初始化.sql

@@ -164,6 +164,8 @@
                                  create_time character varying(50),
                                  update_time character varying(50),
                                  hook_alive_interval integer,
                                  record_path character varying(255),
                                  record_date integer default 7,
                                  constraint uk_media_server_unique_ip_http_port unique (ip, http_port)
);

@@ -267,20 +269,21 @@
                                 constraint uk_stream_push_app_stream unique (app, stream)
);
create table wvp_cloud_record (
                                id serial primary key,
                                app character varying(255),
                                stream character varying(255),
                                call_id character varying(255),
                                start_time integer,
                                end_time integer,
                                media_server_id character varying(50),
                                file_name character varying(255),
                                folder character varying(255),
                                file_path character varying(255),
                                collect_type character varying(255),
                                file_size integer,
                                time_len integer,
                                constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
                                  id serial primary key,
                                  app character varying(255),
                                  stream character varying(255),
                                  call_id character varying(255),
                                  start_time integer,
                                  end_time integer,
                                  media_server_id character varying(50),
                                  file_name character varying(255),
                                  folder character varying(255),
                                  file_path character varying(255),
                                  collect bool default false,
                                  reserve bool default false,
                                  file_size integer,
                                  time_len integer,
                                  constraint uk_stream_push_app_stream_path unique (app, stream, file_path)
);

create table wvp_user (