aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2018-12-20 15:25:24 +0100
committerChocobozzz <me@florianbigard.com>2018-12-20 15:25:49 +0100
commit439b1744f5f50b8530cded9398d51aa4bb5ed4ff (patch)
treec1e432dc55b377f2e7de44d8f6878ad161292b56 /server/initializers/migrations
parent2f5c6b2fc6e60502c2a8df4dc9029c1d87ebe30b (diff)
downloadPeerTube-439b1744f5f50b8530cded9398d51aa4bb5ed4ff.tar.gz
PeerTube-439b1744f5f50b8530cded9398d51aa4bb5ed4ff.tar.zst
PeerTube-439b1744f5f50b8530cded9398d51aa4bb5ed4ff.zip
Optimize index sizes
Diffstat (limited to 'server/initializers/migrations')
-rw-r--r--server/initializers/migrations/0310-drop-unused-video-indexes.ts32
1 files changed, 32 insertions, 0 deletions
diff --git a/server/initializers/migrations/0310-drop-unused-video-indexes.ts b/server/initializers/migrations/0310-drop-unused-video-indexes.ts
new file mode 100644
index 000000000..d51f430c0
--- /dev/null
+++ b/server/initializers/migrations/0310-drop-unused-video-indexes.ts
@@ -0,0 +1,32 @@
1import * as Sequelize from 'sequelize'
2
3async function up (utils: {
4 transaction: Sequelize.Transaction,
5 queryInterface: Sequelize.QueryInterface,
6 sequelize: Sequelize.Sequelize,
7 db: any
8}): Promise<void> {
9 const indexNames = [
10 'video_category',
11 'video_licence',
12 'video_nsfw',
13 'video_language',
14 'video_wait_transcoding',
15 'video_state',
16 'video_remote',
17 'video_likes'
18 ]
19
20 for (const indexName of indexNames) {
21 await utils.sequelize.query('DROP INDEX IF EXISTS "' + indexName + '";')
22 }
23}
24
25function down (options) {
26 throw new Error('Not implemented.')
27}
28
29export {
30 up,
31 down
32}