1'use strict';
2
3module.exports = {
4 up: (queryInterface, Sequelize) => {
5 return queryInterface.createTable('Posts', {
6 id: {
7 allowNull: false,
8 autoIncrement: true,
9 primaryKey: true,
10 type: Sequelize.INTEGER
11 },
12 name: {
13 type: Sequelize.STRING,
14 allowNull: false,
15 },
16 content: {
17 type: Sequelize.TEXT,
18 allowNull: false,
19 },
20 slug: {
21 type: Sequelize.STRING,
22 allowNull: false,
23 unique: true,
24 },
25 boardId: {
26 allowNull: false,
27 type: Sequelize.INTEGER,
28 references: {
29 model: 'Boards',
30 key: 'id'
31 }
32 },
33 createdByUser: {
34 allowNull: false,
35 type: Sequelize.INTEGER,
36 references: {
37 model: 'Users',
38 key: 'id'
39 }
40 },
41 createdAt: {
42 allowNull: false,
43 type: Sequelize.DATE
44 },
45 updatedAt: {
46 allowNull: false,
47 type: Sequelize.DATE
48 }
49 });
50 },
51 down: (queryInterface, Sequelize) => {
52 return queryInterface.dropTable('Posts');
53 }
54};