本文整理匯總了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')
}