aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/migrations/0240-drop-old-indexes.ts
diff options
context:
space:
mode:
Diffstat (limited to 'server/initializers/migrations/0240-drop-old-indexes.ts')
-rw-r--r--server/initializers/migrations/0240-drop-old-indexes.ts80
1 files changed, 0 insertions, 80 deletions
diff --git a/server/initializers/migrations/0240-drop-old-indexes.ts b/server/initializers/migrations/0240-drop-old-indexes.ts
deleted file mode 100644
index 39868fa2d..000000000
--- a/server/initializers/migrations/0240-drop-old-indexes.ts
+++ /dev/null
@@ -1,80 +0,0 @@
1import * as Sequelize from 'sequelize'
2
3async function up (utils: {
4 transaction: Sequelize.Transaction
5 queryInterface: Sequelize.QueryInterface
6 sequelize: Sequelize.Sequelize
7}): Promise<any> {
8
9 const indexNames = [
10 'accounts_application_id',
11 'accounts_user_id',
12 'accounts_name',
13
14 'account_video_rates_video_id_account_id',
15 'account_video_rates_video_id_account_id_type',
16
17 'account_follows_account_id_target_account_id',
18 'account_follow_account_id_target_account_id',
19 'account_follow_account_id',
20 'account_follow_target_account_id',
21 'account_follows_account_id',
22 'account_follows_target_account_id',
23
24 'o_auth_clients_client_id',
25 'o_auth_clients_client_id_client_secret',
26
27 'o_auth_tokens_access_token',
28 'o_auth_tokens_refresh_token',
29 'o_auth_tokens_o_auth_client_id',
30 'o_auth_tokens_user_id',
31
32 'pods_host',
33 'servers_host',
34
35 'tags_name',
36
37 'users_email',
38 'users_username',
39
40 'videos_channel_id',
41 'videos_created_at',
42 'videos_duration',
43 'videos_likes',
44 'videos_name',
45 'videos_uuid',
46 'videos_views',
47
48 'video_abuses_reporter_account_id',
49 'video_abuses_video_id',
50
51 'blacklisted_videos_video_id',
52
53 'video_channels_account_id',
54
55 'video_files_info_hash',
56 'video_files_video_id',
57
58 'video_shares_account_id',
59 'video_shares_video_id',
60
61 'video_tags_tag_id',
62 'video_tags_video_id'
63 ]
64
65 for (const indexName of indexNames) {
66 await utils.sequelize.query('DROP INDEX IF EXISTS "' + indexName + '";')
67 }
68
69 await utils.sequelize.query('ALTER TABLE "account" DROP CONSTRAINT IF EXISTS "actorId_foreign_idx";')
70 await utils.sequelize.query('ALTER TABLE "videoChannel" DROP CONSTRAINT IF EXISTS "actorId_foreign_idx";')
71 await utils.sequelize.query('ALTER TABLE "videoShare" DROP CONSTRAINT IF EXISTS "VideoShares_videoId_fkey";')
72
73 await utils.sequelize.query('DROP TABLE IF EXISTS "videoChannelShare";')
74}
75
76function down (options) {
77 throw new Error('Not implemented.')
78}
79
80export { up, down }