Skip to content

Instantly share code, notes, and snippets.

@hesoyamcode
Created August 23, 2018 18:51
Show Gist options
  • Save hesoyamcode/d2719a9c8d2dabb08ad991cf823b2690 to your computer and use it in GitHub Desktop.
Save hesoyamcode/d2719a9c8d2dabb08ad991cf823b2690 to your computer and use it in GitHub Desktop.
*
* Migration
*/
'use strict';
module.exports = {
up: function(queryInterface, Sequelize) {
return queryInterface.createTable('Users', {
firstName: {
type: Sequelize.STRING
},
lastName: {
type: Sequelize.STRING
},
email: {
type: Sequelize.STRING
},
createdAt: {
allowNull: false,
type: Sequelize.DATE
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE
}
})
.then(() => {
return queryInterface.sequelize.query('ALTER TABLE "Users" ADD CONSTRAINT "username" PRIMARY KEY ("firstName", "lastName")');
})
},
down: function(queryInterface, Sequelize) {
return queryInterface.dropTable('Users');
}
};
/*
* Model
*/
'use strict';
module.exports = function(sequelize, DataTypes) {
var User = sequelize.define('users', {
firstName: {
type: DataTypes.STRING,
primaryKey: true,
},
lastName: {
type: DataTypes.STRING,
primaryKey: true,
},
email: DataTypes.STRING
});
User.removeAttribute('id');
return User;
};
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment