diff options
| author | Rigel Kent <sendmemail@rigelk.eu> | 2020-04-20 11:20:12 +0200 |
|---|---|---|
| committer | Rigel Kent <par@rigelk.eu> | 2020-05-01 16:41:02 +0200 |
| commit | 0251197e249cc03b65805ed6805da72bf4573529 (patch) | |
| tree | 3aae202fd1ea24bac5cd7f2c380ffe50aae189a0 /server/initializers | |
| parent | b8cf27c0f86d205a279d03b83e0e6728f46da67f (diff) | |
| download | PeerTube-0251197e249cc03b65805ed6805da72bf4573529.tar.gz PeerTube-0251197e249cc03b65805ed6805da72bf4573529.tar.zst PeerTube-0251197e249cc03b65805ed6805da72bf4573529.zip | |
Factorize rest-table and fix/simplify SQL
Diffstat (limited to 'server/initializers')
| -rw-r--r-- | server/initializers/migrations/0490-abuse-video.ts | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/server/initializers/migrations/0490-abuse-video.ts b/server/initializers/migrations/0490-abuse-video.ts index 26333feb5..610307aa4 100644 --- a/server/initializers/migrations/0490-abuse-video.ts +++ b/server/initializers/migrations/0490-abuse-video.ts | |||
| @@ -11,10 +11,8 @@ async function up (utils: { | |||
| 11 | allowNull: true | 11 | allowNull: true |
| 12 | } | 12 | } |
| 13 | await utils.queryInterface.addColumn('videoAbuse', 'deletedVideo', deletedVideo) | 13 | await utils.queryInterface.addColumn('videoAbuse', 'deletedVideo', deletedVideo) |
| 14 | await utils.sequelize.query(`ALTER TABLE "videoAbsue" ALTER COLUMN "videoId" DROP NOT NULL;`) | 14 | await utils.sequelize.query(`ALTER TABLE "videoAbuse" ALTER COLUMN "videoId" DROP NOT NULL;`) |
| 15 | await utils.sequelize.query(`ALTER TABLE "videoAbuse" DROP CONSTRAINT IF EXISTS "videoAbuse_videoId_fkey";`) | 15 | await utils.sequelize.query(`ALTER TABLE "videoAbuse" DROP CONSTRAINT IF EXISTS "videoAbuse_videoId_fkey";`) |
| 16 | await utils.sequelize.query(`ALTER TABLE "videoAbuse" ADD CONSTRAINT "videoAbuse_videoId_fkey" | ||
| 17 | FOREIGN KEY ("videoId") REFERENCES video(id) ON UPDATE CASCADE ON DELETE SET NULL;`) | ||
| 18 | 16 | ||
| 19 | } | 17 | } |
| 20 | 18 | ||