Skip to content
Snippets Groups Projects
20200323000437-create-bundle-codes-table.js 885 B
Newer Older
module.exports = {
	up: (migration, Types) => {
		return migration.createTable('bundle_codes', {
			id: {
				type: Types.UUID,
				primaryKey: true,
				defaultValue: Types.UUIDV4,
				allowNull: false,
			},
			name: {
				type: Types.TEXT,
				allowNull: false,
			},
			description: {
				type: Types.TEXT,
				allowNull: false,
			},
			platforms: {
				type: Types.JSONB,
				defaultValue: {},
				allowNull: false,
			},
			meta: {
				type: Types.JSONB,
				defaultValue: {},
				allowNull: false,
			},
			created_at: {
				type: Types.DATE,
				defaultValue: Types.fn('now'),
				allowNull: false,
			},
			updated_at: {
				type: Types.DATE,
				defaultValue: Types.fn('now'),
				allowNull: false,
			},
			deleted_at: {
				type: Types.DATE,
				defaultValue: null,
				allowNull: true,
			},
		})
	},

	down: (migration, Types) => {
		return migration.dropTable('')
	},
}