Sha256: 33cf1eaded3ebcc008e6581b96a13dc4a543dd061a00e379c0513788f16fd5d7

Contents?: true

Size: 1.44 KB

Versions: 13

Compression:

Stored size: 1.44 KB

Contents

# frozen_string_literal: true

# rubocop:disable Metrics/BlockLength

Sequel.migration do
  change do
    create_table(:aa_inst) do
      Integer :uniqueIdentifier, null: false
      String :organizationName, size: 128, null: false
      Integer :manager
      DateTime :lastModifiedTime, default: Sequel::CURRENT_TIMESTAMP, null: false
      String :lastModifiedBy, size: 64, null: false
      String :dlpsDeleted, size: 1, fixed: true, null: false

      primary_key [:uniqueIdentifier]
    end

    create_table(:aa_network, ignore_index_errors: true) do
      Integer :uniqueIdentifier, null: false
      String :dlpsDNSName, size: 128
      String :dlpsCIDRAddress, size: 18
      Bignum :dlpsAddressStart
      Bignum :dlpsAddressEnd
      String :dlpsAccessSwitch, size: 5, null: false
      String :coll, size: 32
      Integer :inst
      DateTime :lastModifiedTime, default: Sequel::CURRENT_TIMESTAMP, null: false
      String :lastModifiedBy, size: 64, null: false
      String :dlpsDeleted, size: 1, fixed: true, null: false

      check Sequel::SQL::BooleanExpression.new(:>=, Sequel::SQL::Identifier.new(:dlpsAddressStart), 0)
      check Sequel::SQL::BooleanExpression.new(:>=, Sequel::SQL::Identifier.new(:dlpsAddressEnd), 0)
      primary_key [:uniqueIdentifier]

      index [:dlpsAddressEnd], name: :network_dlpsAddressEnd_index
      index [:dlpsAddressStart], name: :network_dlpsAddressStart_index
    end
  end
end

# rubocop:enable Metrics/BlockLength

Version data entries

13 entries across 13 versions & 1 rubygems

Version Path
keycard-0.3.4 db/migrations/1_create_tables.rb
keycard-0.3.3 db/migrations/1_create_tables.rb
keycard-0.3.2 db/migrations/1_create_tables.rb
keycard-0.3.1 db/migrations/1_create_tables.rb
keycard-0.3.0 db/migrations/1_create_tables.rb
keycard-0.2.4 db/migrations/1_create_tables.rb
keycard-0.2.3 db/migrations/1_create_tables.rb
keycard-0.2.2 db/migrations/1_create_tables.rb
keycard-0.2.1 db/migrations/1_create_tables.rb
keycard-0.2.0 db/migrations/1_create_tables.rb
keycard-0.1.2 db/migrations/1_create_tables.rb
keycard-0.1.1 db/migrations/1_create_tables.rb
keycard-0.1.0 db/migrations/1_create_tables.rb