server/migrations/20190212043623-create-session.js
module.exports = {
up: async (queryInterface, Sequelize) => {
await queryInterface.createTable('t_session', {
id: {
allowNull: false,
primaryKey: true,
type: Sequelize.UUID,
},
user_id: {
allowNull: false,
type: Sequelize.UUID,
references: {
model: 't_user',
key: 'id',
},
onUpdate: 'CASCADE',
onDelete: 'CASCADE',
},
token_type: {
allowNull: false,
type: Sequelize.STRING,
},
token_hash: {
allowNull: false,
type: Sequelize.TEXT,
},
scope: {
allowNull: false,
type: Sequelize.TEXT,
},
valid_until: {
type: Sequelize.DATE,
},
last_seen: {
type: Sequelize.DATE,
},
revoked: {
allowNull: false,
type: Sequelize.BOOLEAN,
defaultValue: false,
},
created_at: {
allowNull: false,
type: Sequelize.DATE,
},
updated_at: {
allowNull: false,
type: Sequelize.DATE,
},
});
await queryInterface.addIndex('t_session', ['user_id']);
},
down: async (queryInterface, Sequelize) => queryInterface.dropTable('t_session'),
};