sails mysql_sails-mysql架构数据类型

我是Waterline的作者,很抱歉您无法在文档中找到所需内容,我们一直在努力添加它们并使它们保持最新状态.

您非常接近您的架构. Waterline当前不支持数据库级ENUM类型,但我们有验证可以让您最终获得相同的最终结果.

module.exports = {

// Disables Automatic ID generation

// (allows you to use a FLOAT type for your ID)

autoPK: false,

// Disables Automatic Timestamps

// You will need to manually update your timestamps, usually best to leave this

// on and remove the updated_at and created_at attributes below to let Waterline

// keep these up to date for you

autoCreatedAt: false,

autoUpdatedAt: false,

attributes: {

id: {

type: 'FLOAT',

primaryKey: true

}

// Proper ENUM types at the Database level are not yet supported

// but you can use validations to achieve the same end result.

// You can also add a default social_network with defaultsTo

social_network: {

type: 'STRING',

in: ['facebook', 'twitter', 'vk', 'weibo']

},

country: 'STRING',

message: 'TEXT',

link: 'STRING',

comments: 'TEXT',

userid: 'INTEGER',

username: 'STRING',

image_link: 'STRING',

longitude: 'FLOAT',

latitude: 'FLOAT',

location_name: 'STRING',

// Timestamp is not supported but Time, Date, and DateTime are

updated_at: 'DATETIME',

created_at: 'DATETIME'

}

};