diff options
author | Chocobozzz <me@florianbigard.com> | 2020-01-10 10:41:05 +0100 |
---|---|---|
committer | Chocobozzz <me@florianbigard.com> | 2020-01-10 13:33:22 +0100 |
commit | 6fd8c4da261ce12aeaa2a4d75e8eec1a43592784 (patch) | |
tree | 5728ae4f8000efb47869260a681a659743ada530 /server/initializers | |
parent | 2d0d88a0cbd8c1823fe476abb80903cce6a61fd3 (diff) | |
download | PeerTube-6fd8c4da261ce12aeaa2a4d75e8eec1a43592784.tar.gz PeerTube-6fd8c4da261ce12aeaa2a4d75e8eec1a43592784.tar.zst PeerTube-6fd8c4da261ce12aeaa2a4d75e8eec1a43592784.zip |
Cleanup DB indexes
Diffstat (limited to 'server/initializers')
-rw-r--r-- | server/initializers/constants.ts | 2 | ||||
-rw-r--r-- | server/initializers/migrations/0470-cleaup-indexes.ts | 22 |
2 files changed, 23 insertions, 1 deletions
diff --git a/server/initializers/constants.ts b/server/initializers/constants.ts index 8461c7320..d4ac8bbbe 100644 --- a/server/initializers/constants.ts +++ b/server/initializers/constants.ts | |||
@@ -14,7 +14,7 @@ import { CONFIG, registerConfigChangedHandler } from './config' | |||
14 | 14 | ||
15 | // --------------------------------------------------------------------------- | 15 | // --------------------------------------------------------------------------- |
16 | 16 | ||
17 | const LAST_MIGRATION_VERSION = 465 | 17 | const LAST_MIGRATION_VERSION = 470 |
18 | 18 | ||
19 | // --------------------------------------------------------------------------- | 19 | // --------------------------------------------------------------------------- |
20 | 20 | ||
diff --git a/server/initializers/migrations/0470-cleaup-indexes.ts b/server/initializers/migrations/0470-cleaup-indexes.ts new file mode 100644 index 000000000..53e401c2b --- /dev/null +++ b/server/initializers/migrations/0470-cleaup-indexes.ts | |||
@@ -0,0 +1,22 @@ | |||
1 | import * as Sequelize from 'sequelize' | ||
2 | |||
3 | async function up (utils: { | ||
4 | transaction: Sequelize.Transaction, | ||
5 | queryInterface: Sequelize.QueryInterface, | ||
6 | sequelize: Sequelize.Sequelize, | ||
7 | db: any | ||
8 | }): Promise<void> { | ||
9 | await utils.sequelize.query('DROP INDEX IF EXISTS video_share_account_id;') | ||
10 | await utils.sequelize.query('DROP INDEX IF EXISTS video_published_at;') | ||
11 | |||
12 | await utils.sequelize.query('ALTER TABLE "avatar" DROP COLUMN IF EXISTS "avatarId"') | ||
13 | } | ||
14 | |||
15 | function down (options) { | ||
16 | throw new Error('Not implemented.') | ||
17 | } | ||
18 | |||
19 | export { | ||
20 | up, | ||
21 | down | ||
22 | } | ||