本文整理汇总了TypeScript中node-pg-migrate.MigrationBuilder.createIndex方法的典型用法代码示例。如果您正苦于以下问题：TypeScript MigrationBuilder.createIndex方法的具体用法？TypeScript MigrationBuilder.createIndex怎么用？TypeScript MigrationBuilder.createIndex使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类node-pg-migrate.MigrationBuilder的用法示例。
在下文中一共展示了MigrationBuilder.createIndex方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的TypeScript代码示例。
示例1:
export const up = (pgm: MigrationBuilder) => {
pgm.createTable(
tableName,
{
id: {
type: 'UUID',
default: pgm.func('uuid_generate_v4()'),
primaryKey: true,
notNull: true,
comment: null
},
address: { type: 'TEXT', notNull: true, comment: null },
token_address: {
type: 'TEXT',
notNull: true,
references: Token.tableName,
comment: null
},
balance: { type: 'DECIMAL', notNull: true, default: '0', comment: null }
},
{ ifNotExists: true, comment: null }
)
pgm.createIndex(tableName, ['address', 'token_address'], { unique: true })
}示例2:
export const up = (pgm: MigrationBuilder) => {
pgm.createTable(
tableName,
{
id: {
type: 'UUID',
default: pgm.func('uuid_generate_v4()'),
primaryKey: true,
notNull: true,
comment: null
},
account_address: { type: 'TEXT', notNull: true, comment: null },
account_balance: {
type: 'DECIMAL',
notNull: true,
default: '0',
comment: null
},
poll_id: {
type: 'UUID',
references: Poll.tableName,
notNull: true,
comment: null
},
option_id: {
type: 'UUID',
references: Option.tableName,
notNull: true,
comment: null
},
message: { type: 'TEXT', notNull: true, comment: null },
signature: { type: 'TEXT', notNull: true, comment: null },
created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
updated_at: { type: 'TIMESTAMP', comment: null }
},
{ ifNotExists: true, comment: null }
)
pgm.createIndex(tableName, ['account_address', 'poll_id'], {
unique: true
})
pgm.createIndex(tableName, 'poll_id')
}示例3:
export const up = (pgm: MigrationBuilder) => {
pgm.createTable(
tableName,
{
address: { type: 'TEXT', primaryKey: true, notNull: true, comment: null },
name: { type: 'TEXT', notNull: true, comment: null },
symbol: { type: 'TEXT', notNull: true, comment: null }
},
{ ifNotExists: true, comment: null }
)
pgm.createIndex(tableName, 'symbol', { unique: true })
}示例4:
export const up = (pgm: MigrationBuilder) => {
pgm.createTable(
tableName,
{
id: {
type: 'UUID',
default: pgm.func('uuid_generate_v4()'),
primaryKey: true,
comment: null
},
server_signature: { type: 'TEXT', notNull: true, comment: null },
server_message: { type: 'TEXT', notNull: true, comment: null },
account_message: { type: 'TEXT', notNull: true, comment: null },
account_signature: { type: 'TEXT', notNull: true, comment: null },
account_address: { type: 'TEXT', notNull: true, comment: null },
option_value: { type: 'TEXT', notNull: true, comment: null },
vote_id: {
type: 'UUID',
notNull: true,
comment: null
},
nonce: { type: 'SERIAL', comment: null },
created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
updated_at: { type: 'TIMESTAMP', comment: null }
},
{ ifNotExists: true, comment: null }
)
pgm.createIndex(tableName, ['server_signature', 'server_message'], {
unique: true
})
pgm.createIndex(tableName, ['account_signature', 'account_message'], {
unique: true
})
pgm.createIndex(tableName, 'account_address')
}