aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2021-03-03 11:24:16 +0100
committerChocobozzz <me@florianbigard.com>2021-03-03 11:24:16 +0100
commit534556052ed4aab539325dccaa16c6dd2acecf73 (patch)
tree19e6c0a0729196e13eeab66398b6963e424b0181 /server/initializers/migrations
parent6c9c3b7b14411a854c8dcf8583d56b314e45a4ce (diff)
downloadPeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.gz
PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.zst
PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.zip
Optimize views sort sql query
Diffstat (limited to 'server/initializers/migrations')
-rw-r--r--server/initializers/migrations/0610-views-index.ts20
1 files changed, 20 insertions, 0 deletions
diff --git a/server/initializers/migrations/0610-views-index.ts b/server/initializers/migrations/0610-views-index.ts
new file mode 100644
index 000000000..02ee21172
--- /dev/null
+++ b/server/initializers/migrations/0610-views-index.ts
@@ -0,0 +1,20 @@
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
10 await utils.sequelize.query('DROP INDEX IF EXISTS video_views;')
11}
12
13function down (options) {
14 throw new Error('Not implemented.')
15}
16
17export {
18 up,
19 down
20}