Guest User

Untitled

a guest
May 30th, 2018
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. const Sequelize = require('sequelize');
  2. const config = require('./default.config')
  3. const sequelize = new Sequelize(config.database, config.user, config.password, {
  4. host: config.host,
  5. port: config.port,
  6. dialect: 'mysql',
  7. timezone: config.timezone,//东八区
  8. pool: {
  9. max: 5,
  10. min: 0,
  11. acquire: 30000,
  12. idle: 10000
  13. }
  14. });
  15.  
  16. sequelize
  17. .sync()
  18. .then(err => {
  19. console.log('Connection has been established successfully.');
  20. })
  21. .catch(err => {
  22. console.error('Unable to connect to the database:', err);
  23. });
  24.  
  25. module.exports = sequelize;
  26.  
  27. const Admin = Model.define('admin', {
  28. username : {type : sequelize.STRING, allowNull : false},//用户名
  29. password : {type : sequelize.STRING, allowNull : false},//密码
  30. details : {type : sequelize.STRING, allowNull : true},//简介
  31. head_thumb : {type : sequelize.STRING, allowNull : true},//头像
  32. gender : {type : sequelize.STRING, allowNull : true},//性别
  33. nickname : {type : sequelize.STRING, allowNull : true},//昵称
  34. userid : {type : sequelize.INTEGER, autoIncrement : true, primaryKey : true}//用户userid
  35. }, {
  36. freezeTableName:true
  37. })
  38.  
  39. module.exports = Admin;
  40.  
  41. var Sequelize = require('sequelize');
  42. const Model = require('../../config/squelize');
  43. const Admin = require('./admin.model')
  44.  
  45. var user_relation = Model.define('user_relation', {
  46. id : {type : Sequelize.INTEGER, autoIncrement : true, primaryKey : true},
  47. userid : {type : Sequelize.STRING, allowNull : false},//用户id
  48. frendid : {type : Sequelize.STRING, allowNull : false}//朋友id
  49. },{
  50. timestamps:false,
  51. freezeTableName:true,
  52. });
  53. user_relation.hasMany(Admin,{as:'admin',foreignKey:'userid'})
  54.  
  55. module.exports = user_relation;
Add Comment
Please, Sign In to add comment