本文整理汇总了TypeScript中node-pg-migrate.MigrationBuilder类的典型用法代码示例。如果您正苦于以下问题：TypeScript MigrationBuilder类的具体用法？TypeScript MigrationBuilder怎么用？TypeScript MigrationBuilder使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了MigrationBuilder类的8个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的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
},
title: { type: 'TEXT', notNull: true, comment: null },
description: 'TEXT',
token_address: {
type: 'TEXT',
references: Token.tableName,
notNull: true,
comment: null
},
balance: { type: 'DECIMAL', notNull: true, default: 0, comment: null },
submitter: { type: 'TEXT', notNull: true, comment: null },
closes_at: { type: 'BIGINT', notNull: true, comment: null },
created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
updated_at: { type: 'TIMESTAMP', comment: null }
},
{ ifNotExists: true, comment: null }
)
}
开发者ID:decentraland，项目名称:agora，代码行数:28，代码来源:1527706985005_polls-create.ts
示例2:
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 })
}
开发者ID:decentraland，项目名称:agora，代码行数:25，代码来源:1527707064752_accounts-create.ts
示例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 })
}
开发者ID:decentraland，项目名称:agora，代码行数:13，代码来源:1527706973005_tokens-create.ts
示例4:
export const up = (pgm: MigrationBuilder) => {
pgm.addColumns(tableName, {
timestamp: {
type: 'DECIMAL',
notNull: true,
comment: null
}
})
}
开发者ID:decentraland，项目名称:agora，代码行数:9，代码来源:1530201653559_votes-add-timestamp.ts
示例5:
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')
}
开发者ID:decentraland，项目名称:agora，代码行数:44，代码来源:1527707259148_votes-create.ts
示例6:
export const up = (pgm: MigrationBuilder) => {
pgm.createTable(
tableName,
{
id: {
type: 'UUID',
default: pgm.func('uuid_generate_v4()'),
primaryKey: true,
notNull: true,
comment: null
},
value: { type: 'TEXT', notNull: true, comment: null },
poll_id: { type: 'UUID', references: Poll.tableName, comment: null },
created_at: { type: 'TIMESTAMP', notNull: true, comment: null },
updated_at: { type: 'TIMESTAMP', comment: null }
},
{ ifNotExists: true, comment: null }
)
}
开发者ID:decentraland，项目名称:agora，代码行数:19，代码来源:1527707071189_options-create.ts
示例7:
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')
}
开发者ID:decentraland，项目名称:agora，代码行数:36，代码来源:1529057165916_receipt-create.ts
示例8:
export const up = (pgm: MigrationBuilder) => {
pgm.createExtension('uuid-ossp', { ifNotExists: true })
}
开发者ID:decentraland，项目名称:agora，代码行数:3，代码来源:1527706973000_uuid-extension-create.ts
注：本文中的node-pg-migrate.MigrationBuilder类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论