From fb66d5ed24e716e536543364f746a9db5aeb20a9 Mon Sep 17 00:00:00 2001
From: shikeying <shikeying@163.com>
Date: 星期二, 27 九月 2022 18:47:56 +0800
Subject: [PATCH] 视频相似度分析4
---
recommend-video/doc/table.SQL | 191 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 190 insertions(+), 1 deletions(-)
diff --git a/recommend-video/doc/table.SQL b/recommend-video/doc/table.SQL
index 4506ab4..8c5d46e 100644
--- a/recommend-video/doc/table.SQL
+++ b/recommend-video/doc/table.SQL
@@ -1,3 +1,6 @@
+-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+-- 浠ヤ笅涓虹储寮曡缃�
+-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ALTER TABLE rc_video_t1
ADD INDEX inx_src_img (src_img) USING BTREE ;
@@ -17,4 +20,190 @@
ADD INDEX inx_vb_bid (batch_id) USING BTREE ;
ALTER TABLE rc_video_user
- ADD INDEX inx_vu_uid (user_id) USING BTREE ;
\ No newline at end of file
+ ADD INDEX inx_vu_uid (user_id) USING BTREE ;
+
+-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+-- 浠ヤ笅涓鸿〃缁撴瀯
+-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+create table milvus_video_batch (
+ batch_id bigint(20) not null comment '鎵规id锛屽嵆锛氭棩鏈熸椂闂�',
+ video_id varchar(255) not null,
+ video_path varchar(255) default null,
+ vector_size int(11) not null default '0',
+ create_time bigint(20) not null,
+ status int(11) not null default '1' comment '鐘舵�侊細0 鏈畬鎴愶紝1瀹屾垚'
+) engine=innodb default charset=utf8;
+
+create table milvus_video_search (
+ milvus_id text,
+ image_path text,
+ video_id text
+) engine=innodb default charset=utf8;
+
+create table milvus_video_status (
+ id varchar(255) not null comment '瑙嗛璺緞',
+ create_time bigint(20) not null,
+ status int(11) not null default '0' comment '瀹屾垚鐘舵��: 0 鏈畬鎴�, 1 瀹屾垚',
+ records bigint(20) not null default '0',
+ primary key (id)
+) engine=innodb default charset=utf8;
+
+create table rc_task_status (
+ id bigint(20) not null comment '涓婚敭',
+ create_time bigint(20) not null comment '鍒涘缓鏃堕棿锛屽: 20220922180501',
+ name varchar(180) not null comment '浠诲姟鍚嶇О',
+ last_value bigint(20) not null comment '鑾峰彇鏁版嵁鐨勬渶澶у��',
+ status varchar(32) not null comment '褰撳墠鐘舵�侊紝瑙佹灇涓�: taskstatus',
+ start_time bigint(20) default null,
+ end_time bigint(20) default null,
+ msg varchar(180) default null comment '鎵ц鎻忚堪',
+ task_type varchar(32) not null comment '浠诲姟绫诲瀷锛岃鏋氫妇: tasktype',
+ primary key (id)
+) engine=innodb default charset=utf8;
+
+create table rc_video_batch (
+ id bigint(20) not null,
+ batch_id varchar(32) not null comment '鎵规id',
+ user_id bigint(20) not null,
+ src_video_id varchar(32) not null,
+ src_video_path varchar(255) default null,
+ primary key (id),
+ key inx_vb_bid (batch_id) using btree
+) engine=innodb default charset=utf8;
+
+create table rc_video_t1 (
+ src_img varchar(36) not null comment '鍥惧儚id',
+ src_video_id varchar(32) not null,
+ sim_video_id varchar(32) not null,
+ distance double not null default '0',
+ id varchar(32) not null,
+ primary key (id),
+ key inx_src_img (src_img) using btree,
+ key inx_src_vid (src_video_id) using btree
+) engine=innodb default charset=utf8;
+
+create table rc_video_t2 (
+ src_video_id varchar(32) not null,
+ sim_video_id varchar(32) not null,
+ score double not null default '0' comment '鐩镐技瑙嗛缁煎悎寰楀垎',
+ id varchar(32) not null,
+ batch_id varchar(32) not null default '0',
+ primary key (id),
+ key inx_t2_src_vid (src_video_id) using btree,
+ key inx_t2_src_bid (batch_id) using btree
+) engine=innodb default charset=utf8;
+
+create table rc_video_user (
+ user_id bigint(20) not null,
+ video_id varchar(32) not null,
+ score double not null default '0',
+ create_time bigint(20) not null default '0',
+ id bigint(20) not null,
+ primary key (id),
+ key inx_vu_uid (user_id) using btree
+) engine=innodb default charset=utf8;
+
+create table s_host (
+ id bigint(20) not null auto_increment,
+ create_time bigint(20) not null,
+ create_user varchar(36) not null,
+ url varchar(200) not null comment '搴撳湴鍧�',
+ port int(11) not null default '1306' comment '绔彛',
+ service_name varchar(100) default null comment '鏈嶅姟鍚嶇О',
+ authentication varchar(30) default null comment '璁よ瘉鐢ㄦ埛',
+ certification varchar(30) default null comment '鎺堟潈瀵嗙爜',
+ max_active int(11) not null default '5' comment '鏈�澶ц繛鎺ユ暟',
+ primary key (id)
+) engine=innodb auto_increment=105 default charset=utf8 comment='瀛樺偍璧勬簮鍙敤涓绘満';
+
+create table s_scheduler (
+ id int(11) not null comment '璋冨害鍣╥d',
+ create_time bigint(20) not null,
+ name varchar(180) not null,
+ status int(11) not null default '0' comment '鐘舵�侊細0_鍒濆鍖栵紝1_杩愯锛�2_鏆傚仠锛�9_缁撴潫锛�-1_浜哄伐缁堟',
+ start_time bigint(20) not null default '0' comment '璋冨害寮�濮嬭繍琛屾椂闂�',
+ end_time bigint(20) not null default '0' comment '璋冨害缁撴潫杩愯鏃堕棿',
+ interval_time int(11) not null default '5000' comment '鍐呴儴绾跨▼鎵ц闂撮殧鏃堕棿锛岄粯璁わ細5绉�',
+ sleep_time int(11) not null default '600000' comment '绾跨▼鎵ц涓紝鐫＄湢鏃堕棿锛岄粯璁わ細10鍒嗛挓',
+ sleep_option int(11) not null default '1' comment '閲囬泦绾跨▼鍦ㄦ病鏈夎幏鍙栨暟鎹椂锛屾槸鍚﹁繘鍏ヤ紤鐪狅細0_鍚︼紝1_鏄�',
+ period_type varchar(36) not null comment '鍛ㄦ湡绫诲瀷锛歯one,day,week,month,year',
+ time_type varchar(36) not null comment '瀹氭椂绫诲瀷锛氱簿纭椂闂確exactly锛屾椂闂存_range',
+ year int(11) not null default '0',
+ month int(11) not null default '0',
+ day int(11) not null default '0',
+ hour int(11) not null default '0',
+ ranges varchar(50) default null comment '鏃堕棿鑼冨洿锛屽涓锛�5,6锛�12,15;...',
+ dept int(11) not null default '0',
+ class_name varchar(200) not null,
+ pause_time bigint(20) not null default '0',
+ summary varchar(255) default null,
+ primary key (id)
+) engine=innodb default charset=utf8 comment='骞冲彴璋冨害鍣ㄨ褰曡〃';
+
+create table sdc_gather (
+ id bigint(20) not null,
+ create_time bigint(20) not null,
+ create_user varchar(36) not null,
+ name varchar(120) not null comment '閲囬泦鍚嶇О',
+ description varchar(255) default null,
+ src_type tinyint(4) not null default '0' comment '閲囬泦婧愶細0_http,1_db',
+ src_url varchar(120) not null,
+ src_port int(11) default '80',
+ src_service varchar(120) default null,
+ src_user varchar(120) default null,
+ src_pass varchar(120) default null,
+ store_id varchar(36) not null comment '澶栭敭锛氬瓨鍌╥d',
+ status tinyint(4) not null default '0' comment '鐘舵�侊細0_鍒濆鍖栵紝1_杩愯锛�2_鏆傚仠锛�9_缁撴潫',
+ schedule_id int(11) not null comment '璋冨害鍣╥d',
+ primary key (id)
+) engine=innodb default charset=utf8 comment='閲囬泦浠诲姟璁板綍';
+
+create table sdc_meta_db (
+ id bigint(20) not null,
+ create_time bigint(20) not null,
+ store_id varchar(36) not null comment '澶栭敭锛氬瓨鍌╥d',
+ database_name varchar(60) default null,
+ used tinyint(4) not null default '0' comment '鏄惁琚娇鐢ㄨ繃锛�0_鍚︼紝1_鏄�',
+ is_using tinyint(4) not null default '0' comment '姝ｅ湪琚娇鐢細0_鍚︼紝1_鏄�',
+ host_info varchar(100) not null comment '瀛樺偍浣跨敤搴撶殑淇℃伅锛歩p:port',
+ table_count int(11) not null default '0' comment '瀛樺湪鐨勮〃鏁伴噺',
+ summary varchar(255) default null,
+ password varchar(255) default null,
+ username varchar(255) default null,
+ primary key (id),
+ key store_id (store_id),
+ constraint sdc_meta_db_ibfk_1 foreign key (store_id) references sdc_store (id) on delete cascade
+) engine=innodb default charset=utf8 comment='鍏冩暟鎹暟鎹簱淇℃伅';
+
+create table sdc_meta_table (
+ id bigint(20) not null auto_increment,
+ create_time bigint(20) not null,
+ store_id varchar(36) not null comment '澶栭敭锛氬瓨鍌╥d',
+ db_id bigint(20) not null comment '澶栭敭锛歞bid',
+ table_name varchar(60) not null comment '琛ㄥ悕',
+ row_count bigint(20) not null default '0' comment '璁板綍鏁伴噺',
+ summary varchar(255) default null,
+ primary key (id),
+ key db_id (db_id),
+ key store_id (store_id),
+ constraint sdc_meta_table_ibfk_1 foreign key (db_id) references sdc_meta_db (id) on delete cascade,
+ constraint sdc_meta_table_ibfk_2 foreign key (store_id) references sdc_store (id) on delete cascade
+) engine=innodb default charset=utf8 comment='鍏冩暟鎹紝琛ㄤ俊鎭�';
+
+create table sdc_store (
+ id varchar(36) not null comment '瀛樺偍id锛屼富閿�',
+ create_time bigint(20) default null comment '鍒涘缓鏃堕棿姣鍊�',
+ create_user varchar(36) not null,
+ description varchar(255) not null comment '鎻忚堪',
+ inner_use tinyint(4) not null default '0' comment '鍐呴儴浣跨敤锛�0_琛ㄧず绯荤粺鎺у埗鐨勫唴閮ㄦ暟鎹紝鍏朵粬琛ㄧず澶栭儴瀛樺偍锛屽锛氳嚜宸辨墜鍔ㄥ姞涓婄殑鍙綔涓鸿褰�',
+ type varchar(30) not null comment '瀛樺偍绫诲瀷锛氭暟鎹簱銆佸垎甯冨紡鏂囦欢绯荤粺绛�',
+ database_type tinyint(4) not null default '0' comment '鏁版嵁搴撶被鍨嬶細0_derby,1_oracle,2_mysql,3_sqlserver',
+ strategy varchar(90) not null comment '瀛樺偍绛栫暐鐨勭被鍚�',
+ deleted tinyint(4) not null default '0' comment '鏄惁搴熷純锛�1_鏄紝0_鍚�',
+ update_time bigint(20) default null comment '鏇存柊鏃堕棿',
+ update_user varchar(36) default null comment '鏇存柊鐢ㄦ埛',
+ define_name varchar(60) not null comment '瀛樺偍搴撳畾涔夊悕瀛楋紝濡傦細鏁版嵁搴撳悕',
+ select_hosts varchar(100) not null comment '閫夋嫨涓绘満淇℃伅锛屽涓敤鑻辨枃鍒嗗彿闅斿紑',
+ primary key (id)
+) engine=innodb default charset=utf8;
--
Gitblit v1.9.1