id: db-schema

info:
  name: Discover db schema files
  author: geeknik
  severity: info
  description: This file is auto-generated from the current state of the database.
  metadata:
    max-request: 3
  tags: exposure,backup,files

http:
  - method: GET
    path:
      - "{{BaseURL}}/db/schema.rb"
      - "{{BaseURL}}/database/schema.rb"
      - "{{BaseURL}}/schema.rb"

    matchers-condition: and
    matchers:
      - type: word
        words:
          - "This file is auto-generated from the current state of the database."
          - "ActiveRecord::Schema.define"
        condition: and

      - type: status
        status:
          - 200

    extractors:
      - type: regex
        name: version
        part: body
        regex:
          - 'eRecord::Schema\.define\(version: ([0-9_]+)\) do'

# digest: 490a0046304402206f62e7172c143bd1c9d4857d5183eb783c2f6712d72e886a58dd336cd3b497ec02202dc188f4b7beff9048aa1a4187379cee2191563781c25af84813d2ec712ee902:922c64590222798bb761d5b6d8e72950