const Sequelize =require('sequelize')
const sequelize = new Sequelize(
'testdatabase',
'root',
'216612',
{
'dialect': 'mysql', // 数据库使用mysql
'host': 'localhost', // 数据库服务器ip
'port': 3306, // 数据库服务器端口
'define': {
// 字段以下划线(_)来分割(默认是驼峰命名风格)
'underscored': true
}
});
const ItemTag = sequelize.define('item_tag', {
id: {
type: Sequelize.INTEGER,
primaryKey: true,
autoIncrement: true
},
tag_id: {
type: Sequelize.INTEGER,
unique: 'item_tag_taggable'
},
taggable: {
type: Sequelize.STRING,
unique: 'item_tag_taggable'
},
taggable_id: {
type: Sequelize.INTEGER,
unique: 'item_tag_taggable',
references: null
}
});
const Tag = sequelize.define('tag', {
name: Sequelize.STRING
});
const Post = sequelize.define('post', {
name: Sequelize.STRING
});
c