TypeScript MigrationBuilder.createTable方法代码示例

本文整理汇总了TypeScript中node-pg-migrate.MigrationBuilder.createTable方法的典型用法代码示例。如果您正苦于以下问题：TypeScript MigrationBuilder.createTable方法的具体用法？TypeScript MigrationBuilder.createTable怎么用？TypeScript MigrationBuilder.createTable使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类node-pg-migrate.MigrationBuilder的用法示例。

在下文中一共展示了MigrationBuilder.createTable方法的6个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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.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

示例5:

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

示例6:

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.createTable方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。