]> git.immae.eu Git - github/Chocobozzz/PeerTube.git/blame - server/initializers/migrations/0250-video-abuse-state.ts
Try to fix video duplication
[github/Chocobozzz/PeerTube.git] / server / initializers / migrations / 0250-video-abuse-state.ts
CommitLineData
268eebed 1import * as Sequelize from 'sequelize'
268eebed
C
2import { VideoAbuseState } from '../../../shared/models/videos'
3
4async function up (utils: {
5 transaction: Sequelize.Transaction
6 queryInterface: Sequelize.QueryInterface
7 sequelize: Sequelize.Sequelize
8}): Promise<any> {
9 {
10 const data = {
11 type: Sequelize.INTEGER,
12 allowNull: true,
13 defaultValue: null
14 }
15 await utils.queryInterface.addColumn('videoAbuse', 'state', data)
16 }
17
18 {
19 const query = 'UPDATE "videoAbuse" SET "state" = ' + VideoAbuseState.PENDING
20 await utils.sequelize.query(query)
21 }
22
23 {
24 const data = {
25 type: Sequelize.INTEGER,
26 allowNull: false,
27 defaultValue: null
28 }
29 await utils.queryInterface.changeColumn('videoAbuse', 'state', data)
30 }
31
32 {
33 const data = {
d23e6a1c 34 type: Sequelize.STRING(300),
268eebed
C
35 allowNull: true,
36 defaultValue: null
37 }
38 await utils.queryInterface.addColumn('videoAbuse', 'moderationComment', data)
39 }
40}
41
42function down (options) {
43 throw new Error('Not implemented.')
44}
45
46export { up, down }