diff options
Diffstat (limited to 'server/initializers/migrations')
-rw-r--r-- | server/initializers/migrations/0315-user-notifications.ts | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/server/initializers/migrations/0315-user-notifications.ts b/server/initializers/migrations/0315-user-notifications.ts index 2bd9c657d..8c54c5d6c 100644 --- a/server/initializers/migrations/0315-user-notifications.ts +++ b/server/initializers/migrations/0315-user-notifications.ts | |||
@@ -13,6 +13,8 @@ CREATE TABLE IF NOT EXISTS "userNotificationSetting" ("id" SERIAL, | |||
13 | "newCommentOnMyVideo" INTEGER NOT NULL DEFAULT NULL, | 13 | "newCommentOnMyVideo" INTEGER NOT NULL DEFAULT NULL, |
14 | "videoAbuseAsModerator" INTEGER NOT NULL DEFAULT NULL, | 14 | "videoAbuseAsModerator" INTEGER NOT NULL DEFAULT NULL, |
15 | "blacklistOnMyVideo" INTEGER NOT NULL DEFAULT NULL, | 15 | "blacklistOnMyVideo" INTEGER NOT NULL DEFAULT NULL, |
16 | "myVideoPublished" INTEGER NOT NULL DEFAULT NULL, | ||
17 | "myVideoImportFinished" INTEGER NOT NULL DEFAULT NULL, | ||
16 | "userId" INTEGER REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE, | 18 | "userId" INTEGER REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
17 | "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, | 19 | "createdAt" TIMESTAMP WITH TIME ZONE NOT NULL, |
18 | "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, | 20 | "updatedAt" TIMESTAMP WITH TIME ZONE NOT NULL, |
@@ -24,8 +26,8 @@ PRIMARY KEY ("id")) | |||
24 | { | 26 | { |
25 | const query = 'INSERT INTO "userNotificationSetting" ' + | 27 | const query = 'INSERT INTO "userNotificationSetting" ' + |
26 | '("newVideoFromSubscription", "newCommentOnMyVideo", "videoAbuseAsModerator", "blacklistOnMyVideo", ' + | 28 | '("newVideoFromSubscription", "newCommentOnMyVideo", "videoAbuseAsModerator", "blacklistOnMyVideo", ' + |
27 | '"userId", "createdAt", "updatedAt") ' + | 29 | '"myVideoPublished", "myVideoImportFinished", "userId", "createdAt", "updatedAt") ' + |
28 | '(SELECT 2, 2, 4, 4, id, NOW(), NOW() FROM "user")' | 30 | '(SELECT 2, 2, 4, 4, 2, 2, id, NOW(), NOW() FROM "user")' |
29 | 31 | ||
30 | await utils.sequelize.query(query) | 32 | await utils.sequelize.query(query) |
31 | } | 33 | } |