From 26f5dd8ef80e5671cda8fc0e6c0d0298c4e678ff Mon Sep 17 00:00:00 2001
From: shikeying <shikeying@163.com>
Date: 星期二, 27 九月 2022 16:31:33 +0800
Subject: [PATCH] 视频相似度分析3
---
recommend-video/doc/table.SQL | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git a/recommend-video/doc/table.SQL b/recommend-video/doc/table.SQL
index 2283614..4506ab4 100644
--- a/recommend-video/doc/table.SQL
+++ b/recommend-video/doc/table.SQL
@@ -6,4 +6,15 @@
ADD INDEX inx_src_vid (src_video_id) USING BTREE ;
ALTER TABLE rc_video_t2
- ADD INDEX inx_t2_src_vid (src_video_id) USING BTREE ;
\ No newline at end of file
+ ADD INDEX inx_t2_src_vid (src_video_id) USING BTREE ;
+ALTER TABLE rc_video_t2
+ ADD INDEX inx_t2_src_bid (batch_id) USING BTREE ;
+
+-- ALTER TABLE rc_video_batch
+-- ADD INDEX inx_vb_vid (src_video_id) USING BTREE ;
+
+ALTER TABLE rc_video_batch
+ 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
--
Gitblit v1.9.1