当前位置: 首页>>代码示例>>TypeScript>>正文


TypeScript MigrationBuilder.createIndex方法代码示例

本文整理汇总了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 })
}
开发者ID:decentraland,项目名称:agora,代码行数:25,代码来源:1527707064752_accounts-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
      },
      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

示例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.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


注:本文中的node-pg-migrate.MigrationBuilder.createIndex方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。