swagger: "2.0"
schemes:
  - https
host: management.azure.com
info:
  description: The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall rules, VNET rules, log files and configurations with new business model.
  title: MySQLManagementClient
  version: 2017-12-01-preview
  x-apisguru-categories:
    - cloud
  x-logo:
    url: https://api.apis.guru/v2/cache/logo/https_assets.onestore.ms_cdnfiles_onestorerolling-1606-01000_shell_v3_images_logo_microsoft.png
  x-origin:
    - format: swagger
      url: https://raw.githubusercontent.com/Azure/azure-rest-api-specs/master/specification/mysql/resource-manager/Microsoft.DBforMySQL/preview/2017-12-01-preview/mysql.json
      version: "2.0"
  x-preferred: true
  x-providerName: azure.com
  x-serviceName: mysql
  x-tags:
    - Azure
    - Microsoft
consumes:
  - application/json
produces:
  - application/json
securityDefinitions:
  azure_auth:
    authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize
    description: Azure Active Directory OAuth2 Flow
    flow: implicit
    scopes:
      user_impersonation: impersonate your user account
    type: oauth2
security:
  - azure_auth:
      - user_impersonation
parameters:
  ApiVersionParameter:
    description: The API version to use for the request.
    in: query
    name: api-version
    required: true
    type: string
  ConfigurationNameParameter:
    description: The name of the server configuration.
    in: path
    name: configurationName
    required: true
    type: string
    x-ms-parameter-location: method
  DatabaseNameParameter:
    description: The name of the database.
    in: path
    name: databaseName
    required: true
    type: string
    x-ms-parameter-location: method
  FirewallRuleNameParameter:
    description: The name of the server firewall rule.
    in: path
    name: firewallRuleName
    required: true
    type: string
    x-ms-parameter-location: method
  LocationNameParameter:
    description: The name of the location.
    in: path
    name: locationName
    required: true
    type: string
    x-ms-parameter-location: method
  ResourceGroupParameter:
    description: The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
    in: path
    name: resourceGroupName
    required: true
    type: string
    x-ms-parameter-location: method
  SecurityAlertPolicyNameParameter:
    description: The name of the security alert policy.
    enum:
      - default
    in: path
    name: securityAlertPolicyName
    required: true
    type: string
    x-ms-parameter-location: method
  ServerNameParameter:
    description: The name of the server.
    in: path
    name: serverName
    required: true
    type: string
    x-ms-parameter-location: method
  SubscriptionIdParameter:
    description: The subscription ID that identifies an Azure subscription.
    in: path
    name: subscriptionId
    required: true
    type: string
  virtualNetworkRuleNameParameter:
    description: The name of the virtual network rule.
    in: path
    name: virtualNetworkRuleName
    required: true
    type: string
    x-ms-parameter-location: method
paths:
  /providers/Microsoft.DBforMySQL/operations:
    get:
      description: Lists all of the available REST API operations.
      operationId: Operations_List
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/OperationListResult"
      tags:
        - Operations
      x-ms-examples:
        OperationList:
          parameters:
            api-version: 2017-12-01-preview
          responses:
            "200":
              body:
                value:
                  - display:
                      description: Returns the list of Performance Tiers available.
                      operation: List Performance Tiers
                      provider: Microsoft DB for MySQL
                      resource: Performance Tiers
                    name: Microsoft.DBforMySQL/locations/performanceTiers/read
                  - display:
                      description: Return the list of firewall rules for a server or gets the properties for the specified firewall rule.
                      operation: List/Get Firewall Rules
                      provider: Microsoft DB for MySQL
                      resource: Firewall Rules
                    name: Microsoft.DBforMySQL/servers/firewallRules/read
                  - display:
                      description: Creates a firewall rule with the specified parameters or update an existing rule.
                      operation: Create/Update Firewall Rule
                      provider: Microsoft DB for MySQL
                      resource: Firewall Rules
                    name: Microsoft.DBforMySQL/servers/firewallRules/write
                  - display:
                      description: Deletes an existing firewall rule.
                      operation: Delete Firewall Rule
                      provider: Microsoft DB for MySQL
                      resource: Firewall Rules
                    name: Microsoft.DBforMySQL/servers/firewallRules/delete
                  - display:
                      description: Return the list of servers or gets the properties for the specified server.
                      operation: List/Get MySQL Servers
                      provider: Microsoft DB for MySQL
                      resource: MySQL Server
                    name: Microsoft.DBforMySQL/servers/read
                  - display:
                      description: Creates a server with the specified parameters or update the properties or tags for the specified server.
                      operation: Create/Update MySQL Server
                      provider: Microsoft DB for MySQL
                      resource: MySQL Server
                    name: Microsoft.DBforMySQL/servers/write
                  - display:
                      description: Deletes an existing server.
                      operation: Delete MySQL Server
                      provider: Microsoft DB for MySQL
                      resource: MySQL Server
                    name: Microsoft.DBforMySQL/servers/delete
                  - display:
                      description: Returns the list of Performance Tiers available.
                      operation: List Performance Tiers
                      provider: Microsoft DB for MySQL
                      resource: Performance Tiers
                    name: Microsoft.DBforMySQL/performanceTiers/read
                  - display:
                      description: Return the recoverable MySQL Server info
                      operation: Get Recoverable MySQL Server info
                      provider: Microsoft DB for MySQL
                      resource: Recoverable MySQL Server
                    name: Microsoft.DBforMySQL/servers/recoverableServers/read
                  - display:
                      description: Return types of metrics that are available for databases
                      operation: Get database metric definitions
                      provider: Microsoft DB for MySQL
                      resource: Database Metric Definition
                    name: Microsoft.DBforMySQL/servers/providers/Microsoft.Insights/metricDefinitions/read
                    properties:
                      serviceSpecification:
                        metricSpecifications:
                          - aggregationType: Average
                            displayDescription: CPU percent
                            displayName: CPU percent
                            fillGapWithZero: true
                            name: cpu_percent
                            unit: Percent
                          - aggregationType: Average
                            displayDescription: Memory percent
                            displayName: Memory percent
                            fillGapWithZero: true
                            name: memory_percent
                            unit: Percent
                          - aggregationType: Average
                            displayDescription: IO percent
                            displayName: IO percent
                            fillGapWithZero: true
                            name: io_consumption_percent
                            unit: Percent
                          - aggregationType: Average
                            displayDescription: Storage percentage
                            displayName: Storage percentage
                            name: storage_percent
                            unit: Percent
                          - aggregationType: Average
                            displayDescription: Storage used
                            displayName: Storage used
                            name: storage_used
                            unit: Bytes
                          - aggregationType: Average
                            displayDescription: Storage limit
                            displayName: Storage limit
                            name: storage_limit
                            unit: Bytes
                          - aggregationType: Average
                            displayDescription: Server Log storage percent
                            displayName: Server Log storage percent
                            name: serverlog_storage_percent
                            unit: Percent
                          - aggregationType: Average
                            displayDescription: Server Log storage used
                            displayName: Server Log storage used
                            name: serverlog_storage_usage
                            unit: Bytes
                          - aggregationType: Average
                            displayDescription: Server Log storage limit
                            displayName: Server Log storage limit
                            name: serverlog_storage_limit
                            unit: Bytes
                          - aggregationType: Average
                            displayDescription: Total active connections
                            displayName: Total active connections
                            fillGapWithZero: true
                            name: active_connections
                            unit: Count
                          - aggregationType: Average
                            displayDescription: Total failed connections
                            displayName: Total failed connections
                            fillGapWithZero: true
                            name: connections_failed
                            unit: Count
                          - aggregationType: Average
                            displayDescription: Replication lag in seconds
                            displayName: Replication lag in seconds
                            fillGapWithZero: true
                            name: seconds_behind_master
                            unit: Count
                  - display:
                      description: Gets the disagnostic setting for the resource
                      operation: Read diagnostic setting
                      provider: Microsoft DB for MySQL
                      resource: Database Metric Definition
                    name: Microsoft.DBforMySQL/servers/providers/Microsoft.Insights/diagnosticSettings/read
                  - display:
                      description: Creates or updates the diagnostic setting for the resource
                      operation: Write diagnostic setting
                      provider: Microsoft DB for MySQL
                      resource: Database Metric Definition
                    name: Microsoft.DBforMySQL/servers/providers/Microsoft.Insights/diagnosticSettings/write
  "/subscriptions/{subscriptionId}/providers/Microsoft.DBforMySQL/checkNameAvailability":
    post:
      description: Check the availability of name for resource
      operationId: CheckNameAvailability_Execute
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - description: The required parameters for checking if resource name is available.
          in: body
          name: nameAvailabilityRequest
          required: true
          schema:
            $ref: "#/definitions/NameAvailabilityRequest"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/NameAvailability"
      tags:
        - CheckNameAvailability
      x-ms-examples:
        NameAvailability:
          parameters:
            api-version: 2017-12-01-preview
            nameAvailabilityRequest:
              name: name1
              type: Microsoft.DBforMySQL
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                message: ""
                nameAvailable: true
                reason: ""
  "/subscriptions/{subscriptionId}/providers/Microsoft.DBforMySQL/locations/{locationName}/performanceTiers":
    get:
      description: List all the performance tiers at specified location in a given subscription.
      operationId: LocationBasedPerformanceTier_List
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/LocationNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/PerformanceTierListResult"
      tags:
        - LocationBasedPerformanceTier
      x-ms-examples:
        PerformanceTiersList:
          parameters:
            api-version: 2017-12-01-preview
            locationName: WestUS
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: Basic
                    serviceLevelObjectives:
                      - edition: Basic
                        hardwareGeneration: Gen4
                        id: B_Gen4_1
                        maxBackupRetentionDays: 35
                        maxStorageMB: 1048576
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 1
                      - edition: Basic
                        hardwareGeneration: Gen4
                        id: B_Gen4_2
                        maxBackupRetentionDays: 35
                        maxStorageMB: 1048576
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 2
                  - id: GeneralPurpose
                    serviceLevelObjectives:
                      - edition: GeneralPurpose
                        hardwareGeneration: Gen4
                        id: GP_Gen4_2
                        maxBackupRetentionDays: 35
                        maxStorageMB: 2097152
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 2
                      - edition: GeneralPurpose
                        hardwareGeneration: Gen4
                        id: GP_Gen4_4
                        maxBackupRetentionDays: 35
                        maxStorageMB: 2097152
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 4
                      - edition: GeneralPurpose
                        hardwareGeneration: Gen4
                        id: GP_Gen4_8
                        maxBackupRetentionDays: 35
                        maxStorageMB: 2097152
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 8
                      - edition: GeneralPurpose
                        hardwareGeneration: Gen4
                        id: GP_Gen4_16
                        maxBackupRetentionDays: 35
                        maxStorageMB: 2097152
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 16
                      - edition: GeneralPurpose
                        hardwareGeneration: Gen4
                        id: GP_Gen4_32
                        maxBackupRetentionDays: 35
                        maxStorageMB: 2097152
                        minBackupRetentionDays: 7
                        minStorageMB: 5120
                        vCore: 32
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/providers/Microsoft.DBforMySQL/servers":
    get:
      description: List all the servers in a given subscription.
      operationId: Servers_List
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerListResult"
      tags:
        - Servers
      x-ms-examples:
        ServerList:
          parameters:
            api-version: 2017-12-01-preview
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1
                    location: westus
                    name: mysqltestsvc1
                    properties:
                      administratorLogin: testuser
                      earliestRestoreDate: 2018-02-28T23:56:02.627+00:00
                      fullyQualifiedDomainName: mysqltestsvc1.mysql.database.azure.com
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 7
                        geoRedundantBackup: Disabled
                        storageMB: 5120
                      userVisibleState: Ready
                      version: "5.7"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: B_Gen4_2
                      tier: Basic
                    type: Microsoft.DBforMySQL/servers
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltstsvc2
                    location: westus
                    name: mysqltstsvc2
                    properties:
                      administratorLogin: testuser
                      earliestRestoreDate: 2018-02-28T23:56:54.3+00:00
                      fullyQualifiedDomainName: mysqltstsvc2.mysql.database.azure.com
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 7
                        geoRedundantBackup: Disabled
                        storageMB: 5120
                      userVisibleState: Ready
                      version: "5.7"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: GP_Gen4_2
                      tier: GeneralPurpose
                    type: Microsoft.DBforMySQL/servers
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg1/providers/Microsoft.DBforMySQL/servers/mysqltestsvc3
                    location: westus
                    name: mysqltestsvc3
                    properties:
                      administratorLogin: testuser
                      earliestRestoreDate: 2018-02-28T23:59:44.847+00:00
                      fullyQualifiedDomainName: mysqltestsvc3.mysql.database.azure.com
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 35
                        geoRedundantBackup: Enabled
                        storageMB: 102400
                      userVisibleState: Ready
                      version: "5.7"
                    sku:
                      capacity: 4
                      family: Gen4
                      name: GP_Gen4_4
                      tier: GeneralPurpose
                    type: Microsoft.DBforMySQL/servers
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers":
    get:
      description: List all the servers in a given resource group.
      operationId: Servers_ListByResourceGroup
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerListResult"
      tags:
        - Servers
      x-ms-examples:
        ServerListByResourceGroup:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1
                    location: westus
                    name: mysqltestsvc1
                    properties:
                      administratorLogin: testuser
                      earliestRestoreDate: 2018-03-07T18:17:35.729321+00:00
                      fullyQualifiedDomainName: mysqltestsvc1.mysql.database.azure.com
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 7
                        geoRedundantBackup: Disabled
                        storageMB: 5120
                      userVisibleState: Ready
                      version: "5.7"
                    sku:
                      capacity: 1
                      family: Gen4
                      name: B_Gen4_1
                      tier: Basic
                    type: Microsoft.DBforMySQL/servers
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltstsvc2
                    location: westus
                    name: mysqltstsvc2
                    properties:
                      administratorLogin: testuser
                      earliestRestoreDate: 2018-03-07T18:17:35.729321+00:00
                      fullyQualifiedDomainName: mysqltstsvc2.mysql.database.azure.com
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 7
                        geoRedundantBackup: Disabled
                        storageMB: 5120
                      userVisibleState: Ready
                      version: "5.7"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: GP_Gen4_2
                      tier: GeneralPurpose
                    type: Microsoft.DBforMySQL/servers
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}":
    delete:
      description: Deletes a server.
      operationId: Servers_Delete
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
        "202":
          description: Accepted
        "204":
          description: NoContent
      tags:
        - Servers
      x-ms-examples:
        ServerDelete:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200": {}
            "202": {}
            "204": {}
      x-ms-long-running-operation: true
    get:
      description: Gets information about a server.
      operationId: Servers_Get
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Server"
      tags:
        - Servers
      x-ms-examples:
        ServerGet:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4
                location: westus
                name: mysqltestsvc4
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: mysqltestsvc4.mysql.database.azure.com
                  masterServerId: ""
                  replicaCapacity: 5
                  replicationRole: None
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen4
                  name: GP_Gen4_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
    patch:
      description: Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
      operationId: Servers_Update
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - description: The required parameters for updating a server.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/ServerUpdateParameters"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Server"
        "202":
          description: Accepted
      tags:
        - Servers
      x-ms-examples:
        ServerUpdate:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              properties:
                administratorLoginPassword: newpa$$w0rd
                sslEnforcement: Disabled
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4
                location: westus
                name: mysqltestsvc4
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: mysqltestsvc4.mysql.database.azure.com
                  sslEnforcement: Disabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen4
                  name: GP_Gen4_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "202": {}
      x-ms-long-running-operation: true
    put:
      description: Creates a new server or updates an existing server. The update action will overwrite the existing server.
      operationId: Servers_Create
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - description: The required parameters for creating or updating a server.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/ServerForCreate"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Server"
        "201":
          description: Created
          schema:
            $ref: "#/definitions/Server"
        "202":
          description: Accepted
      tags:
        - Servers
      x-ms-examples:
        Create a database as a point in time restore:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              location: brazilsouth
              properties:
                createMode: PointInTimeRestore
                restorePointInTime: 2017-12-14T00:00:37.467Z
                sourceServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver
              sku:
                capacity: 2
                family: Gen5
                name: GP_Gen5_2
                tier: GeneralPurpose
              tags:
                ElasticServer: "1"
            resourceGroupName: TargetResourceGroup
            serverName: targetserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver
                location: brazilsouth
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  elasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver
                location: brazilsouth
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "202": {}
        Create a new server:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              location: westus
              properties:
                administratorLogin: cloudsa
                administratorLoginPassword: pass$w0rd
                createMode: Default
                sslEnforcement: Enabled
                storageProfile:
                  backupRetentionDays: 7
                  geoRedundantBackup: Enabled
                  storageMB: 128000
              sku:
                capacity: 2
                family: Gen5
                name: GP_Gen5_2
                tier: GeneralPurpose
              tags:
                ElasticServer: "1"
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4
                location: westus
                name: mysqltestsvc4
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: mysqltestsvc4.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  elasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4
                location: westus
                name: mysqltestsvc4
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: mysqltestsvc4.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 7
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "202": {}
        Create a replica server:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              location: westus
              properties:
                createMode: Replica
                sourceServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver
            resourceGroupName: TargetResourceGroup
            serverName: targetserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/servers/targetserver
                location: westus
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  masterServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver
                  replicaCapacity: 0
                  replicationRole: Replica
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 14
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TargetResourceGroup/providers/Microsoft.DBforMySQL/servers/targetserver
                location: westus
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  masterServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/MasterResourceGroup/providers/Microsoft.DBforMySQL/servers/masterserver
                  replicaCapacity: 0
                  replicationRole: Replica
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 14
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "202": {}
        "Create a server as a geo restore ":
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              location: westus
              properties:
                createMode: GeoRestore
                sourceServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/SourceResourceGroup/providers/Microsoft.DBforMySQL/servers/sourceserver
              sku:
                capacity: 2
                family: Gen5
                name: GP_Gen5_2
                tier: GeneralPurpose
              tags:
                ElasticServer: "1"
            resourceGroupName: TargetResourceGroup
            serverName: targetserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver
                location: westus
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 14
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  elasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/targetserver
                location: westus
                name: targetserver
                properties:
                  administratorLogin: cloudsa
                  earliestRestoreDate: 2018-03-14T18:02:41.577+00:00
                  fullyQualifiedDomainName: targetserver.mysql.database.azure.com
                  sslEnforcement: Enabled
                  storageProfile:
                    backupRetentionDays: 14
                    geoRedundantBackup: Enabled
                    storageMB: 128000
                  userVisibleState: Ready
                  version: "5.7"
                sku:
                  capacity: 2
                  family: Gen5
                  name: GP_Gen5_2
                  tier: GeneralPurpose
                tags:
                  ElasticServer: "1"
                type: Microsoft.DBforMySQL/servers
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/Administrators/activeDirectory":
    delete:
      description: Deletes AAD Administrator.
      operationId: ServerAdministrators_Delete
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        "202":
          description: Accepted
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        "204":
          description: NoContent
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        default:
          description: Error response describing why the operation failed.
          schema:
            $ref: "#/definitions/CloudError"
      tags:
        - ServerAdministrators
      x-ms-examples:
        ServerAdministratorsDelete:
          parameters:
            administratorName: activeDirectory
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body: OK
            "202":
              body: Accepted
            "204":
              body: No Content
      x-ms-long-running-operation: true
    get:
      description: Gets information about a AAD server administrator.
      operationId: ServerAdministrators_Get
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        default:
          description: Error response describing why the operation failed.
          schema:
            $ref: "#/definitions/CloudError"
      tags:
        - ServerAdministrators
      x-ms-examples:
        ServerAdministratorGet:
          parameters:
            administratorName: activeDirectory
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4/administrators/activeDirectory
                name: activeDirectory
                properties:
                  administratorType: ActiveDirectory
                  login: bob@contoso.com
                  sid: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                  tenantId: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                type: Microsoft.DBforMySQL/servers/administrators
    put:
      description: Creates or update active directory administrator on an existing server. The update action will overwrite the existing administrator.
      operationId: ServerAdministrators_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - description: The required parameters for creating or updating an AAD server administrator.
          in: body
          name: properties
          required: true
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        "202":
          description: Accepted
          schema:
            $ref: "#/definitions/ServerAdministratorResource"
        default:
          description: Error response describing why the operation failed.
          schema:
            $ref: "#/definitions/CloudError"
      tags:
        - ServerAdministrators
      x-ms-examples:
        ServerAdministratorCreate:
          parameters:
            administratorName: activeDirectory
            api-version: 2017-12-01-preview
            properties:
              properties:
                administratorType: ActiveDirectory
                login: bob@contoso.com
                sid: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                tenantId: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4/administrators/activeDirectory
                name: activeDirectory
                properties:
                  administratorType: ActiveDirectory
                  login: bob@contoso.com
                  sid: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                  tenantId: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                type: Microsoft.DBforMySQL/servers/administrators
            "202":
              body: Accepted
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/administrators":
    get:
      description: Returns a list of server Administrators.
      operationId: ServerAdministrators_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerAdministratorResourceListResult"
        default:
          description: Error response describing why the operation failed.
          schema:
            $ref: "#/definitions/CloudError"
      tags:
        - ServerAdministrators
      x-ms-examples:
        get a list of server administrators:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            serverName: mysqltestsvc4
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc4/administrators/activeDirectory
                    name: ActiveDirectory
                    properties:
                      administratorType: ActiveDirectory
                      login: bob@contoso.com
                      sid: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                      tenantId: c6b82b90-a647-49cb-8a62-0d2d3cb7ac7c
                    type: Microsoft.DBforMySQL/servers/administrators
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/configurations":
    get:
      description: List all the configurations in a given server.
      operationId: Configurations_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ConfigurationListResult"
      tags:
        - Configurations
      x-ms-examples:
        ConfigurationList:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: testrg
            serverName: mysqltestsvc1
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/event_scheduler
                    name: event_scheduler
                    properties:
                      allowedValues: ON,OFF,DISABLED
                      dataType: Enumeration
                      defaultValue: OFF
                      description: Indicates the status of the Event Scheduler.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/div_precision_increment
                    name: div_precision_increment
                    properties:
                      allowedValues: 0-30
                      dataType: Integer
                      defaultValue: "4"
                      description: Number of digits by which to increase the scale of the result of division operations.
                      source: system-default
                      value: "4"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/group_concat_max_len
                    name: group_concat_max_len
                    properties:
                      allowedValues: 4-16777216
                      dataType: Integer
                      defaultValue: "1024"
                      description: Maximum allowed result length in bytes for the GROUP_CONCAT().
                      source: system-default
                      value: "1024"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_adaptive_hash_index
                    name: innodb_adaptive_hash_index
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: ON
                      description: Whether innodb adaptive hash indexes are enabled or disabled.
                      source: system-default
                      value: ON
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_lock_wait_timeout
                    name: innodb_lock_wait_timeout
                    properties:
                      allowedValues: 1-3600
                      dataType: Integer
                      defaultValue: "50"
                      description: The length of time in seconds an InnoDB transaction waits for a row lock before giving up.
                      source: system-default
                      value: "50"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/interactive_timeout
                    name: interactive_timeout
                    properties:
                      allowedValues: 10-1800
                      dataType: Integer
                      defaultValue: "1800"
                      description: Number of seconds the server waits for activity on an interactive connection before closing it.
                      source: system-default
                      value: "1800"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/log_queries_not_using_indexes
                    name: log_queries_not_using_indexes
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: Logs queries that are expected to retrieve all rows to slow query log.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/log_throttle_queries_not_using_indexes
                    name: log_throttle_queries_not_using_indexes
                    properties:
                      allowedValues: 0-4294967295
                      dataType: Integer
                      defaultValue: "0"
                      description: Limits the number of such queries per minute that can be written to the slow query log.
                      source: system-default
                      value: "0"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/log_slow_admin_statements
                    name: log_slow_admin_statements
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: Include slow administrative statements in the statements written to the slow query log.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/log_slow_slave_statements
                    name: log_slow_slave_statements
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: When the slow query log is enabled, this variable enables logging for queries that have taken more than long_query_time seconds to execute on the slave.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/log_bin_trust_function_creators
                    name: log_bin_trust_function_creators
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: This variable applies when binary logging is enabled. It controls whether stored function creators can be trusted not to create stored functions that will cause unsafe events to be written to the binary log.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/long_query_time
                    name: long_query_time
                    properties:
                      allowedValues: 0-1E+100
                      dataType: Numeric
                      defaultValue: "10"
                      description: If a query takes longer than this many seconds, the server increments the Slow_queries status variable.
                      source: system-default
                      value: "10"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/min_examined_row_limit
                    name: min_examined_row_limit
                    properties:
                      allowedValues: 0-18446744073709551615
                      dataType: Integer
                      defaultValue: "0"
                      description: Can be used to cause queries which examine fewer than the stated number of rows not to be logged.
                      source: system-default
                      value: "0"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/slow_query_log
                    name: slow_query_log
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: Enable or disable the slow query log
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/sql_mode
                    name: sql_mode
                    properties:
                      allowedValues: ",ALLOW_INVALID_DATES,ANSI_QUOTES,ERROR_FOR_DIVISION_BY_ZERO,HIGH_NOT_PRECEDENCE,IGNORE_SPACE,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ENGINE_SUBSTITUTION,NO_FIELD_OPTIONS,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_UNSIGNED_SUBTRACTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,PAD_CHAR_TO_FULL_LENGTH,PIPES_AS_CONCAT,REAL_AS_FLOAT,STRICT_ALL_TABLES,STRICT_TRANS_TABLES"
                      dataType: Set
                      defaultValue: ""
                      description: The current server SQL mode.
                      source: system-default
                      value: ""
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/wait_timeout
                    name: wait_timeout
                    properties:
                      allowedValues: 60-86400
                      dataType: Integer
                      defaultValue: "120"
                      description: The number of seconds the server waits for activity on a noninteractive connection before closing it.
                      source: system-default
                      value: "120"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/net_read_timeout
                    name: net_read_timeout
                    properties:
                      allowedValues: 10-3600
                      dataType: Integer
                      defaultValue: "120"
                      description: The number of seconds the server waits for network reading action, especially for LOAD DATA LOCAL FILE.
                      source: system-default
                      value: "120"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/net_write_timeout
                    name: net_write_timeout
                    properties:
                      allowedValues: 10-3600
                      dataType: Integer
                      defaultValue: "240"
                      description: The number of seconds the server waits for network writing action, especially for LOAD DATA LOCAL FILE.
                      source: system-default
                      value: "240"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/server_id
                    name: server_id
                    properties:
                      allowedValues: 1000-4294967295
                      dataType: Integer
                      defaultValue: "1000"
                      description: The server ID, used in replication to give each master and slave a unique identity.
                      source: user-override
                      value: "1381286943"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/max_allowed_packet
                    name: max_allowed_packet
                    properties:
                      allowedValues: 1024-1073741824
                      dataType: Integer
                      defaultValue: "536870912"
                      description: The maximum size of one packet or any generated/intermediate string, or any parameter sent by the mysql_stmt_send_long_data() C API function.
                      source: system-default
                      value: "536870912"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/slave_net_timeout
                    name: slave_net_timeout
                    properties:
                      allowedValues: 30-3600
                      dataType: Integer
                      defaultValue: "60"
                      description: The number of seconds to wait for more data from the master before the slave considers the connection broken, aborts the read, and tries to reconnect.
                      source: system-default
                      value: "60"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/time_zone
                    name: time_zone
                    properties:
                      allowedValues: "[+|-][0]{0,1}[0-9]:[0-5][0-9]|[+|-][1][0-2]:[0-5][0-9]|SYSTEM"
                      dataType: String
                      defaultValue: SYSTEM
                      description: The server time zone
                      source: system-default
                      value: SYSTEM
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/binlog_group_commit_sync_delay
                    name: binlog_group_commit_sync_delay
                    properties:
                      allowedValues: 0,11-1000000
                      dataType: Integer
                      defaultValue: "1000"
                      description: Controls how many microseconds the binary log commit waits before synchronizing the binary log file to disk.
                      source: system-default
                      value: "1000"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/binlog_group_commit_sync_no_delay_count
                    name: binlog_group_commit_sync_no_delay_count
                    properties:
                      allowedValues: 0-1000000
                      dataType: Integer
                      defaultValue: "0"
                      description: The maximum number of transactions to wait for before aborting the current delay as specified by binlog-group-commit-sync-delay.
                      source: system-default
                      value: "0"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/character_set_server
                    name: character_set_server
                    properties:
                      allowedValues: BIG5,DEC8,CP850,HP8,KOI8R,LATIN1,LATIN2,SWE7,ASCII,UJIS,SJIS,HEBREW,TIS620,EUCKR,KOI8U,GB2312,GREEK,CP1250,GBK,LATIN5,ARMSCII8,UTF8,UCS2,CP866,KEYBCS2,MACCE,MACROMAN,CP852,LATIN7,UTF8MB4,CP1251,UTF16,CP1256,CP1257,UTF32,BINARY,GEOSTD8,CP932,EUCJPMS
                      dataType: Enumeration
                      defaultValue: latin1
                      description: Use charset_name as the default server character set.
                      source: system-default
                      value: latin1
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/join_buffer_size
                    name: join_buffer_size
                    properties:
                      allowedValues: 128-2097152
                      dataType: Integer
                      defaultValue: "262144"
                      description: The minimum size of the buffer that is used for plain index scans, range index scans, and joins that do not use indexes and thus perform full table scans.
                      source: system-default
                      value: "262144"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/table_open_cache
                    name: table_open_cache
                    properties:
                      allowedValues: 1-4000
                      dataType: Integer
                      defaultValue: "2000"
                      description: The number of open tables for all threads.
                      source: system-default
                      value: "2000"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/lower_case_table_names
                    name: lower_case_table_names
                    properties:
                      allowedValues: 1,2
                      dataType: Enumeration
                      defaultValue: "1"
                      description: If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive. If set to 2, table names are stored as given but compared in lowercase.
                      source: system-default
                      value: "1"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/slave_compressed_protocol
                    name: slave_compressed_protocol
                    properties:
                      allowedValues: ON,OFF
                      dataType: Enumeration
                      defaultValue: OFF
                      description: This option places an upper limit on the total size in bytes of all relay logs on the slave.
                      source: system-default
                      value: OFF
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_io_capacity
                    name: innodb_io_capacity
                    properties:
                      allowedValues: 100-1500
                      dataType: Integer
                      defaultValue: "200"
                      description: Sets an upper limit on I/O activity performed by InnoDB background tasks, such as flushing pages from the buffer pool and merging data from the change buffer.
                      source: system-default
                      value: "200"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_read_io_threads
                    name: innodb_read_io_threads
                    properties:
                      allowedValues: 1-64
                      dataType: Integer
                      defaultValue: "4"
                      description: The number of I/O threads for read operations in InnoDB.
                      source: system-default
                      value: "4"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_thread_concurrency
                    name: innodb_thread_concurrency
                    properties:
                      allowedValues: 0-1000
                      dataType: Integer
                      defaultValue: "0"
                      description: InnoDB tries to keep the number of operating system threads concurrently inside InnoDB less than or equal to the limit given by this variable.
                      source: system-default
                      value: "0"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_write_io_threads
                    name: innodb_write_io_threads
                    properties:
                      allowedValues: 1-64
                      dataType: Integer
                      defaultValue: "4"
                      description: The number of I/O threads for write operations in InnoDB.
                      source: system-default
                      value: "4"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_page_cleaners
                    name: innodb_page_cleaners
                    properties:
                      allowedValues: 1-64
                      dataType: Integer
                      defaultValue: "4"
                      description: The number of page cleaner threads that flush dirty pages from buffer pool instances.
                      source: system-default
                      value: "4"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_online_alter_log_max_size
                    name: innodb_online_alter_log_max_size
                    properties:
                      allowedValues: 65536-2147483648
                      dataType: Integer
                      defaultValue: "134217728"
                      description: Specifies an upper limit on the size of the temporary log files used during online DDL operations for InnoDB tables.
                      source: system-default
                      value: "134217728"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/init_connect
                    name: init_connect
                    properties:
                      allowedValues: ""
                      dataType: String
                      defaultValue: ""
                      description: A string to be executed by the server for each client that connects.
                      source: system-default
                      value: ""
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/tx_isolation
                    name: tx_isolation
                    properties:
                      allowedValues: READ-UNCOMMITTED,READ-COMMITTED,REPEATABLE-READ,SERIALIZABLE
                      dataType: Enumeration
                      defaultValue: REPEATABLE-READ
                      description: The default transaction isolation level.
                      source: system-default
                      value: REPEATABLE-READ
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/eq_range_index_dive_limit
                    name: eq_range_index_dive_limit
                    properties:
                      allowedValues: 0-4294967295
                      dataType: Integer
                      defaultValue: "200"
                      description: This variable indicates the number of equality ranges in an equality comparison condition when the optimizer should switch from using index dives to index statistics in estimating the number of qualifying rows.
                      source: system-default
                      value: "200"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_old_blocks_pct
                    name: innodb_old_blocks_pct
                    properties:
                      allowedValues: 5-95
                      dataType: Integer
                      defaultValue: "37"
                      description: Specifies the approximate percentage of the InnoDB buffer pool used for the old block sublist.
                      source: system-default
                      value: "37"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_old_blocks_time
                    name: innodb_old_blocks_time
                    properties:
                      allowedValues: 0-4294967295
                      dataType: Integer
                      defaultValue: "1000"
                      description: Non-zero values protect against the buffer pool being filled by data that is referenced only for a brief period, such as during a full table scan.
                      source: system-default
                      value: "1000"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_read_ahead_threshold
                    name: innodb_read_ahead_threshold
                    properties:
                      allowedValues: 0-64
                      dataType: Integer
                      defaultValue: "56"
                      description: Controls the sensitivity of linear read-ahead that InnoDB uses to prefetch pages into the buffer pool.
                      source: system-default
                      value: "56"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/max_length_for_sort_data
                    name: max_length_for_sort_data
                    properties:
                      allowedValues: 4-8388608
                      dataType: Integer
                      defaultValue: "1024"
                      description: The cutoff on the size of index values that determines which filesort algorithm to use.
                      source: system-default
                      value: "1024"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/max_connect_errors
                    name: max_connect_errors
                    properties:
                      allowedValues: 1-18446744073709551615
                      dataType: Integer
                      defaultValue: "100"
                      description: If more than this many successive connection requests from a host are interrupted without a successful connection, the server blocks that host from further connections.
                      source: system-default
                      value: "100"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_thread_sleep_delay
                    name: innodb_thread_sleep_delay
                    properties:
                      allowedValues: 0-1000000
                      dataType: Integer
                      defaultValue: "10000"
                      description: Defines how long InnoDB threads sleep before joining the InnoDB queue, in microseconds.
                      source: system-default
                      value: "10000"
                    type: Microsoft.DBforMySQL/servers/configurations
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/configurations/innodb_file_format
                    name: innodb_file_format
                    properties:
                      allowedValues: Antelope,Barracuda
                      dataType: Enumeration
                      defaultValue: Barracuda
                      description: Indicates the InnoDB file format for file-per-table tablespaces.
                      source: system-default
                      value: Barracuda
                    type: Microsoft.DBforMySQL/servers/configurations
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/configurations/{configurationName}":
    get:
      description: Gets information about a configuration of server.
      operationId: Configurations_Get
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/ConfigurationNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Configuration"
      tags:
        - Configurations
      x-ms-examples:
        ConfigurationGet:
          parameters:
            api-version: 2017-12-01-preview
            configurationName: event_scheduler
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/configurations/event_scheduler
                name: event_scheduler
                properties:
                  allowedValues: ON,OFF,DISABLED
                  dataType: Enumeration
                  defaultValue: OFF
                  description: Indicates the status of the Event Scheduler.
                  source: user-override
                  value: ON
                type: Microsoft.DBforMySQL/servers/configurations
    put:
      description: Updates a configuration of a server.
      operationId: Configurations_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/ConfigurationNameParameter"
        - description: The required parameters for updating a server configuration.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/Configuration"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Configuration"
        "202":
          description: Accepted
      tags:
        - Configurations
      x-ms-examples:
        ConfigurationCreateOrUpdate:
          parameters:
            api-version: 2017-12-01-preview
            configurationName: event_scheduler
            parameters:
              properties:
                source: user-override
                value: off
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/configurations/event_scheduler
                name: event_scheduler
                properties:
                  allowedValues: ON,OFF,DISABLED
                  dataType: Enumeration
                  defaultValue: OFF
                  description: Indicates the status of the Event Scheduler.
                  source: user-override
                  value: ON
                type: Microsoft.DBforMySQL/servers/configurations
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/databases":
    get:
      description: List all the databases in a given server.
      operationId: Databases_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/DatabaseListResult"
      tags:
        - Databases
      x-ms-examples:
        DatabaseList:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/databases/db1
                    name: db1
                    properties:
                      charset: utf8
                      collation: utf8_general_ci
                    type: Microsoft.DBforMySQL/servers/databases
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/databases/db2
                    name: db2
                    properties:
                      charset: utf8
                      collation: utf8_general_ci
                    type: Microsoft.DBforMySQL/servers/databases
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/databases/{databaseName}":
    delete:
      description: Deletes a database.
      operationId: Databases_Delete
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/DatabaseNameParameter"
      responses:
        "200":
          description: OK
        "202":
          description: Accepted
        "204":
          description: NoContent
      tags:
        - Databases
      x-ms-examples:
        DatabaseDelete:
          parameters:
            api-version: 2017-12-01-preview
            databaseName: db1
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200": {}
            "202": {}
            "204": {}
      x-ms-long-running-operation: true
    get:
      description: Gets information about a database.
      operationId: Databases_Get
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/DatabaseNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Database"
      tags:
        - Databases
      x-ms-examples:
        DatabaseGet:
          parameters:
            api-version: 2017-12-01-preview
            databaseName: db1
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/databases/db1
                name: db1
                properties:
                  charset: utf8
                  collation: utf8_general_ci
                type: Microsoft.DBforMySQL/servers/databases
    put:
      description: Creates a new database or updates an existing database.
      operationId: Databases_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/DatabaseNameParameter"
        - description: The required parameters for creating or updating a database.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/Database"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/Database"
        "201":
          description: Created
          schema:
            $ref: "#/definitions/Database"
        "202":
          description: Accepted
      tags:
        - Databases
      x-ms-examples:
        DatabaseCreate:
          parameters:
            api-version: 2017-12-01-preview
            databaseName: db1
            parameters:
              properties:
                charset: utf8
                collation: utf8_general_ci
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/databases/db1
                name: db1
                properties:
                  charset: utf8
                  collation: utf8_general_ci
                type: Microsoft.DBforMySQL/servers/databases
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/databases/db1
                name: db1
                properties:
                  charset: utf8
                  collation: utf8_general_ci
                type: Microsoft.DBforMySQL/servers/databases
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/firewallRules":
    get:
      description: List all the firewall rules in a given server.
      operationId: FirewallRules_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/FirewallRuleListResult"
      tags:
        - FirewallRules
      x-ms-examples:
        FirewallRuleList:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/firewallRules/rule1
                    name: rule1
                    properties:
                      endIpAddress: 255.255.255.255
                      startIpAddress: 0.0.0.0
                    type: Microsoft.DBforMySQL/servers/firewallRules
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/firewallRules/rule2
                    name: rule2
                    properties:
                      endIpAddress: 255.0.0.0
                      startIpAddress: 1.0.0.0
                    type: Microsoft.DBforMySQL/servers/firewallRules
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/firewallRules/{firewallRuleName}":
    delete:
      description: Deletes a server firewall rule.
      operationId: FirewallRules_Delete
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/FirewallRuleNameParameter"
      responses:
        "200":
          description: OK
        "202":
          description: Accepted
        "204":
          description: NoContent
      tags:
        - FirewallRules
      x-ms-examples:
        FirewallRuleDelete:
          parameters:
            api-version: 2017-12-01-preview
            firewallRuleName: rule1
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200": {}
            "202": {}
            "204": {}
      x-ms-long-running-operation: true
    get:
      description: Gets information about a server firewall rule.
      operationId: FirewallRules_Get
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/FirewallRuleNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/FirewallRule"
      tags:
        - FirewallRules
      x-ms-examples:
        FirewallRuleGet:
          parameters:
            api-version: 2017-12-01-preview
            firewallRuleName: rule1
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/firewallRules/rule1
                name: rule1
                properties:
                  endIpAddress: 255.255.255.255
                  startIpAddress: 0.0.0.0
                type: Microsoft.DBforMySQL/servers/firewallRules
    put:
      description: Creates a new firewall rule or updates an existing firewall rule.
      operationId: FirewallRules_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/FirewallRuleNameParameter"
        - description: The required parameters for creating or updating a firewall rule.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/FirewallRule"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/FirewallRule"
        "201":
          description: Created
          schema:
            $ref: "#/definitions/FirewallRule"
        "202":
          description: Accepted
      tags:
        - FirewallRules
      x-ms-examples:
        FirewallRuleCreate:
          parameters:
            api-version: 2017-12-01-preview
            firewallRuleName: rule1
            parameters:
              properties:
                endIpAddress: 255.255.255.255
                startIpAddress: 0.0.0.0
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/firewallRules/rule1
                name: rule1
                properties:
                  endIpAddress: 255.255.255.255
                  startIpAddress: 0.0.0.0
                type: Microsoft.DBforMySQL/servers/firewallRules
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver/firewallRules/rule1
                name: rule1
                properties:
                  endIpAddress: 255.255.255.255
                  startIpAddress: 0.0.0.0
                type: Microsoft.DBforMySQL/servers/firewallRules
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/logFiles":
    get:
      description: List all the log files in a given server.
      operationId: LogFiles_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/LogFileListResult"
      tags:
        - LogFiles
      x-ms-examples:
        LogFileList:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforMySQL/servers/mysqltestsvc1/logFiles/mysql-slow-mysqltestsvc1-2018022823.log
                    name: mysql-slow-mysqltestsvc1-2018022823.log
                    properties:
                      createdTime: 0001-01-01T00:00:00+00:00
                      lastModifiedTime: 2018-03-01T06:09:20+00:00
                      sizeInKB: 1
                      type: slowlog
                      url: https://wasd2prodwus1afse42.file.core.windows.net/833c99b2f36c47349e5554b903fe0440/serverlogs/mysql-slow-mysqltestsvc1-2018022823.log?sv=2015-04-05&sr=f&sig=D9Ga4N5Pa%2BPe5Bmjpvs7A0TPD%2FF7IZpk9e4KWR0jgpM%3D&se=2018-03-01T07%3A12%3A13Z&sp=r
                    type: Microsoft.DBforMySQL/servers/logFiles
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/replicas":
    get:
      description: List all the replicas for a given server.
      operationId: Replicas_ListByServer
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
          schema:
            $ref: "#/definitions/ServerListResult"
      tags:
        - Replicas
      x-ms-examples:
        ReplicasListByServer:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testmaster
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver
                    location: northeurope
                    name: testserver
                    properties:
                      administratorLogin: cloudsa
                      earliestRestoreDate: 2018-06-11T23:56:54.3+00:00
                      fullyQualifiedDomainName: testserver.mysql.database.azure.com
                      masterServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testmaster
                      replicaCapacity: 0
                      replicationRole: Replica
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 35
                        geoRedundantBackup: Enabled
                        storageMB: 256000
                      userVisibleState: Ready
                      version: "5.6"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: GP_Gen4_2
                      tier: GeneralPurpose
                    tags:
                      elasticServer: "1"
                    type: Microsoft.DBforMySQL/servers
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver1
                    location: northeurope
                    name: testserver1
                    properties:
                      administratorLogin: cloudsa
                      earliestRestoreDate: 2018-06-11T23:56:54.3+00:00
                      fullyQualifiedDomainName: testserver1.mysql.database.azure.com
                      masterServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testmaster
                      replicaCapacity: 0
                      replicationRole: Replica
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 35
                        geoRedundantBackup: Enabled
                        storageMB: 256000
                      userVisibleState: Ready
                      version: "5.6"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: GP_Gen4_2
                      tier: GeneralPurpose
                    tags:
                      elasticServer: "1"
                    type: Microsoft.DBforMySQL/servers
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testserver2
                    location: northeurope
                    name: testserver2
                    properties:
                      administratorLogin: cloudsa
                      earliestRestoreDate: 2018-06-11T23:56:54.3+00:00
                      fullyQualifiedDomainName: testserver2.mysql.database.azure.com
                      masterServerId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/testmaster
                      replicaCapacity: 0
                      replicationRole: Replica
                      sslEnforcement: Enabled
                      storageProfile:
                        backupRetentionDays: 35
                        geoRedundantBackup: Enabled
                        storageMB: 256000
                      userVisibleState: Ready
                      version: "5.6"
                    sku:
                      capacity: 2
                      family: Gen4
                      name: GP_Gen4_2
                      tier: GeneralPurpose
                    tags:
                      elasticServer: "1"
                    type: Microsoft.DBforMySQL/servers
      x-ms-pageable:
        nextLinkName: null
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/restart":
    post:
      description: Restarts a server.
      operationId: Servers_Restart
      parameters:
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
      responses:
        "200":
          description: OK
        "202":
          description: Accepted
        default:
          description: Error response describing why the operation failed.
          schema:
            $ref: "#/definitions/CloudError"
      tags:
        - ServerRestart
      x-ms-examples:
        ServerRestart:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: testserver
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
          responses:
            "200": {}
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/securityAlertPolicies/{securityAlertPolicyName}":
    get:
      description: Get a server's security alert policy.
      operationId: ServerSecurityAlertPolicies_Get
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - description: The name of the security alert policy.
          enum:
            - Default
          in: path
          name: securityAlertPolicyName
          required: true
          type: string
          x-ms-enum:
            modelAsString: true
            name: SecurityAlertPolicyName
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the server threat detection policy.
          schema:
            $ref: "#/definitions/ServerSecurityAlertPolicy"
        default:
          description: Error response describing why the operation of getting security alert policies failed.
      tags:
        - ServerSecurityAlertPolicies
      x-ms-examples:
        Get a server's threat detection policy:
          parameters:
            api-version: 2017-03-01-preview
            resourceGroupName: securityalert-4799
            securityAlertPolicyName: Default
            serverName: securityalert-6440
            subscriptionId: 00000000-1111-2222-3333-444444444444
          responses:
            "200":
              body:
                id: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/securityalert-4799/providers/Microsoft.DBforMySQL/servers/securityalert-6440/securityAlertPolicies/default
                name: Default
                properties:
                  disabledAlerts:
                    - Access_Anomaly
                  emailAccountAdmins: true
                  emailAddresses:
                    - test@microsoft.com;user@microsoft.com
                  retentionDays: 0
                  state: Disabled
                  storageEndpoint: https://mystorage.blob.core.windows.net
                type: Microsoft.DBforMySQL/servers/securityAlertPolicies
    put:
      description: Creates or updates a threat detection policy.
      operationId: ServerSecurityAlertPolicies_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - description: The name of the threat detection policy.
          enum:
            - Default
          in: path
          name: securityAlertPolicyName
          required: true
          type: string
          x-ms-enum:
            modelAsString: true
            name: SecurityAlertPolicyName
        - description: The server security alert policy.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/ServerSecurityAlertPolicy"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully updated the threat detection policy.
          schema:
            $ref: "#/definitions/ServerSecurityAlertPolicy"
        "202":
          description: Created request to set the server threat detection policy.
        default:
          description: Error response describing why the operation of setting security alert policies failed.
      tags:
        - ServerSecurityAlertPolicies
      x-ms-examples:
        Update a server's threat detection policy with all parameters:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              properties:
                disabledAlerts:
                  - Access_Anomaly
                  - Usage_Anomaly
                emailAccountAdmins: true
                emailAddresses:
                  - testSecurityAlert@microsoft.com
                retentionDays: 5
                state: Enabled
                storageAccountAccessKey: sdlfkjabc+sdlfkjsdlkfsjdfLDKFTERLKFDFKLjsdfksjdflsdkfD2342309432849328476458/3RSD==
                storageEndpoint: https://mystorage.blob.core.windows.net
            resourceGroupName: securityalert-4799
            securityAlertPolicyName: Default
            serverName: securityalert-6440
            subscriptionId: 00000000-1111-2222-3333-444444444444
          responses:
            "200":
              body:
                id: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/securityalert-4799/providers/Microsoft.DBforMySQL/servers/securityalert-6440/securityAlertPolicies/default
                name: Default
                properties:
                  disabledAlerts:
                    - Access_Anomaly
                    - Usage_Anomaly
                  emailAccountAdmins: true
                  emailAddresses:
                    - testSecurityAlert@microsoft.com
                  retentionDays: 5
                  state: Enabled
                  storageEndpoint: https://mystorage.blob.core.windows.net
                type: Microsoft.DBforMySQL/servers/securityAlertPolicies
            "202": {}
        Update a server's threat detection policy with minimal parameters:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              properties:
                emailAccountAdmins: true
                state: Disabled
            resourceGroupName: securityalert-4799
            securityAlertPolicyName: Default
            serverName: securityalert-6440
            subscriptionId: 00000000-1111-2222-3333-444444444444
          responses:
            "200":
              body:
                id: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/securityalert-4799/providers/Microsoft.DBforMySQL/servers/securityalert-6440/securityAlertPolicies/default
                name: Default
                properties:
                  disabledAlerts: []
                  emailAccountAdmins: true
                  emailAddresses: []
                  retentionDays: 0
                  state: Enabled
                  storageEndpoint: ""
                type: Microsoft.DBforMySQL/servers/securityAlertPolicies
            "202": {}
      x-ms-long-running-operation: true
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/virtualNetworkRules":
    get:
      description: Gets a list of virtual network rules in a server.
      operationId: VirtualNetworkRules_ListByServer
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully retrieved the list of virtual network rules.
          schema:
            $ref: "#/definitions/VirtualNetworkRuleListResult"
        default:
          description: |-
            *** Error Responses: ***

             * 404 SubscriptionDoesNotHaveServer - The requested server was not found

             * 404 ResourceNotFound - The requested resource was not found.
      tags:
        - VirtualNetworkRules
      x-ms-examples:
        List virtual network rules:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: vnet-test-svr
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
            virtualNetworkRuleName: vnet-firewall-rule
          responses:
            "200":
              body:
                value:
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/vnet-test-svr/virtualNetworkRules/vnet-firewall-rule
                    name: vnet-firewall-rule
                    properties:
                      ignoreMissingVnetServiceEndpoint: false
                      state: Ready
                      virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
                    type: Microsoft.DBforMySQL/servers/virtualNetworkRules
                  - id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/vnet-test-svr/virtualNetworkRules/vnet-firewall-rule
                    name: vnet-firewall-rule
                    properties:
                      ignoreMissingVnetServiceEndpoint: false
                      state: Ready
                      virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
                    type: Microsoft.DBforMySQL/servers/virtualNetworkRules
      x-ms-pageable:
        nextLinkName: nextLink
  "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforMySQL/servers/{serverName}/virtualNetworkRules/{virtualNetworkRuleName}":
    delete:
      description: Deletes the virtual network rule with the given name.
      operationId: VirtualNetworkRules_Delete
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/virtualNetworkRuleNameParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
      responses:
        "200":
          description: Successfully deleted the virtual network rule.
        "202":
          description: Accepted
        "204":
          description: The specified virtual network rule does not exist.
        default:
          description: |-
            *** Error Responses: ***

             * 400 InvalidResourceId - Invalid resource identifier.

             * 400 MismatchingSubscriptionWithUrl - The provided subscription did not match the subscription in the Url.

             * 400 MismatchingResourceGroupNameWithUrl - The provided resource group name did not match the name in the Url.

             * 400 MismatchingServerNameWithUrl - The provided server name did not match the name in the Url.

             * 400 NullVirtualNetworkRequest - Virtual Network Request is Null

             * 400 NullVirtualNetworkRequestParameters - Virtual Network Request Parameters are Null

             * 404 SubscriptionDoesNotHaveServer - The requested server was not found

             * 404 OperationIdNotFound - The operation with Id does not exist.

             * 409 OperationCancelled - The operation has been cancelled by user.

             * 409 OperationInterrupted - The operation on the resource could not be completed because it was interrupted by another operation on the same resource.

             * 500 OperationTimedOut - The operation timed out and automatically rolled back. Please retry the operation.
      tags:
        - VirtualNetworkRules
      x-ms-examples:
        Delete a virtual network rule:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: vnet-test-svr
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
            virtualNetworkRuleName: vnet-firewall-rule
          responses:
            "200": {}
            "202": {}
            "204": {}
      x-ms-long-running-operation: true
    get:
      description: Gets a virtual network rule.
      operationId: VirtualNetworkRules_Get
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/virtualNetworkRuleNameParameter"
      responses:
        "200":
          description: Successfully retrieved a specified virtual network rule.
          schema:
            $ref: "#/definitions/VirtualNetworkRule"
        default:
          description: |-
            *** Error Responses: ***

             * 404 SubscriptionDoesNotHaveServer - The requested server was not found

             * 404 ResourceNotFound - The requested resource was not found.
      tags:
        - VirtualNetworkRules
      x-ms-examples:
        Gets a virtual network rule:
          parameters:
            api-version: 2017-12-01-preview
            resourceGroupName: TestGroup
            serverName: vnet-test-svr
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
            virtualNetworkRuleName: vnet-firewall-rule
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/vnet-test-svr/virtualNetworkRules/vnet-firewall-rule
                name: vnet-firewall-rule
                properties:
                  ignoreMissingVnetServiceEndpoint: false
                  state: Ready
                  virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
                type: Microsoft.DBforMySQL/servers/virtualNetworkRules
    put:
      description: Creates or updates an existing virtual network rule.
      operationId: VirtualNetworkRules_CreateOrUpdate
      parameters:
        - $ref: "#/parameters/ResourceGroupParameter"
        - $ref: "#/parameters/ServerNameParameter"
        - $ref: "#/parameters/SubscriptionIdParameter"
        - $ref: "#/parameters/ApiVersionParameter"
        - $ref: "#/parameters/virtualNetworkRuleNameParameter"
        - description: The requested virtual Network Rule Resource state.
          in: body
          name: parameters
          required: true
          schema:
            $ref: "#/definitions/VirtualNetworkRule"
      responses:
        "200":
          description: Successfully updated a virtual network rule.
          schema:
            $ref: "#/definitions/VirtualNetworkRule"
        "201":
          description: Successfully created a virtual network rule.
          schema:
            $ref: "#/definitions/VirtualNetworkRule"
        "202":
          description: Accepted
        default:
          description: |-
            *** Error Responses: ***

             * 400 InvalidResourceId - Invalid resource identifier.

             * 400 MismatchingSubscriptionWithUrl - The provided subscription did not match the subscription in the Url.

             * 400 MismatchingResourceGroupNameWithUrl - The provided resource group name did not match the name in the Url.

             * 400 MismatchingServerNameWithUrl - The provided server name did not match the name in the Url.

             * 400 NullVirtualNetworkRequest - Virtual Network Request is Null

             * 400 NullVirtualNetworkRequestParameters - Virtual Network Request Parameters are Null

             * 400 NullVirtualNetworkSubnetId - The Virtual Network Subnet Id is null

             * 404 SubscriptionDoesNotHaveServer - The requested server was not found

             * 404 VirtualNetworkRuleNotEnabled - Azure SQL Server Virtual Network Rule feature is not enabled

             * 404 OperationIdNotFound - The operation with Id does not exist.

             * 409 OperationCancelled - The operation has been cancelled by user.

             * 409 OperationInterrupted - The operation on the resource could not be completed because it was interrupted by another operation on the same resource.

             * 500 OperationTimedOut - The operation timed out and automatically rolled back. Please retry the operation.
      tags:
        - VirtualNetworkRules
      x-ms-examples:
        Create or update a virtual network rule:
          parameters:
            api-version: 2017-12-01-preview
            parameters:
              properties:
                ignoreMissingVnetServiceEndpoint: false
                virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
            resourceGroupName: TestGroup
            serverName: vnet-test-svr
            subscriptionId: ffffffff-ffff-ffff-ffff-ffffffffffff
            virtualNetworkRuleName: vnet-firewall-rule
          responses:
            "200":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/vnet-test-svr/virtualNetworkRules/vnet-firewall-rule
                name: vnet-firewall-rule
                properties:
                  ignoreMissingVnetServiceEndpoint: false
                  virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
                type: Microsoft.DBforMySQL/servers/virtualNetworkRules
            "201":
              body:
                id: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforMySQL/servers/vnet-test-svr/virtualNetworkRules/vnet-firewall-rule
                name: vnet-firewall-rule
                properties:
                  ignoreMissingVnetServiceEndpoint: false
                  virtualNetworkSubnetId: /subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.Network/virtualNetworks/testvnet/subnets/testsubnet
                type: Microsoft.DBforMySQL/servers/virtualNetworkRules
            "202": {}
      x-ms-long-running-operation: true
definitions:
  CloudError:
    description: An error response from the Batch service.
    properties:
      error:
        $ref: "#/definitions/CloudErrorBody"
    x-ms-external: true
  CloudErrorBody:
    description: An error response from the Batch service.
    properties:
      code:
        description: An identifier for the error. Codes are invariant and are intended to be consumed programmatically.
        type: string
      details:
        description: A list of additional details about the error.
        items:
          $ref: "#/definitions/CloudErrorBody"
        type: array
      message:
        description: A message describing the error, intended to be suitable for display in a user interface.
        type: string
      target:
        description: The target of the particular error. For example, the name of the property in error.
        type: string
    x-ms-external: true
  Configuration:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Represents a Configuration.
    properties:
      properties:
        $ref: "#/definitions/ConfigurationProperties"
        description: The properties of a configuration.
        x-ms-client-flatten: true
  ConfigurationListResult:
    description: A list of server configurations.
    properties:
      value:
        description: The list of server configurations.
        items:
          $ref: "#/definitions/Configuration"
        type: array
  ConfigurationProperties:
    description: The properties of a configuration.
    properties:
      allowedValues:
        description: Allowed values of the configuration.
        readOnly: true
        type: string
      dataType:
        description: Data type of the configuration.
        readOnly: true
        type: string
      defaultValue:
        description: Default value of the configuration.
        readOnly: true
        type: string
      description:
        description: Description of the configuration.
        readOnly: true
        type: string
      source:
        description: Source of the configuration.
        type: string
      value:
        description: Value of the configuration.
        type: string
  Database:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Represents a Database.
    properties:
      properties:
        $ref: "#/definitions/DatabaseProperties"
        description: The properties of a database.
        x-ms-client-flatten: true
  DatabaseListResult:
    description: A List of databases.
    properties:
      value:
        description: The list of databases housed in a server
        items:
          $ref: "#/definitions/Database"
        type: array
  DatabaseProperties:
    description: The properties of a database.
    properties:
      charset:
        description: The charset of the database.
        type: string
      collation:
        description: The collation of the database.
        type: string
  FirewallRule:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Represents a server firewall rule.
    properties:
      properties:
        $ref: "#/definitions/FirewallRuleProperties"
        description: The properties of a firewall rule.
        x-ms-client-flatten: true
    required:
      - properties
  FirewallRuleListResult:
    description: A list of firewall rules.
    properties:
      value:
        description: The list of firewall rules in a server.
        items:
          $ref: "#/definitions/FirewallRule"
        type: array
  FirewallRuleProperties:
    description: The properties of a server firewall rule.
    properties:
      endIpAddress:
        description: The end IP address of the server firewall rule. Must be IPv4 format.
        pattern: ^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$
        type: string
      startIpAddress:
        description: The start IP address of the server firewall rule. Must be IPv4 format.
        pattern: ^(([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])\.){3}([0-9]|[1-9][0-9]|1[0-9]{2}|2[0-4][0-9]|25[0-5])$
        type: string
    required:
      - startIpAddress
      - endIpAddress
  LogFile:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Represents a log file.
    properties:
      name:
        description: The name of the log file.
        type: string
      properties:
        $ref: "#/definitions/LogFileProperties"
        description: The properties of the log file.
        x-ms-client-flatten: true
  LogFileListResult:
    description: A list of log files.
    properties:
      value:
        description: The list of log files.
        items:
          $ref: "#/definitions/LogFile"
        type: array
  LogFileProperties:
    description: The properties of a log file.
    properties:
      createdTime:
        description: Creation timestamp of the log file.
        format: date-time
        readOnly: true
        type: string
      lastModifiedTime:
        description: Last modified timestamp of the log file.
        format: date-time
        readOnly: true
        type: string
      sizeInKB:
        description: Size of the log file.
        format: int64
        type: integer
      type:
        description: Type of the log file.
        type: string
      url:
        description: The url to download the log file from.
        type: string
  NameAvailability:
    description: Represents a resource name availability.
    properties:
      message:
        description: Error Message.
        type: string
      nameAvailable:
        description: Indicates whether the resource name is available.
        type: boolean
      reason:
        description: Reason for name being unavailable.
        type: string
  NameAvailabilityRequest:
    description: Request from client to check resource name availability.
    properties:
      name:
        description: Resource name to verify.
        type: string
      type:
        description: Resource type used for verification.
        type: string
    required:
      - name
  Operation:
    description: REST API operation definition.
    properties:
      display:
        $ref: "#/definitions/OperationDisplay"
        description: The localized display information for this particular operation or action.
        readOnly: true
      name:
        description: The name of the operation being performed on this particular object.
        readOnly: true
        type: string
      origin:
        description: The intended executor of the operation.
        enum:
          - NotSpecified
          - user
          - system
        readOnly: true
        type: string
        x-ms-enum:
          modelAsString: true
          name: OperationOrigin
      properties:
        additionalProperties:
          type: object
        description: Additional descriptions for the operation.
        readOnly: true
        type: object
        x-ms-client-flatten: false
  OperationDisplay:
    description: Display metadata associated with the operation.
    properties:
      description:
        description: Operation description.
        readOnly: true
        type: string
      operation:
        description: Localized friendly name for the operation.
        readOnly: true
        type: string
      provider:
        description: Operation resource provider name.
        readOnly: true
        type: string
      resource:
        description: Resource on which the operation is performed.
        readOnly: true
        type: string
  OperationListResult:
    description: A list of resource provider operations.
    properties:
      value:
        description: The list of resource provider operations.
        items:
          $ref: "#/definitions/Operation"
        type: array
  PerformanceTierListResult:
    description: A list of performance tiers.
    properties:
      value:
        description: The list of performance tiers
        items:
          $ref: "#/definitions/PerformanceTierProperties"
        type: array
  PerformanceTierProperties:
    description: Performance tier properties
    properties:
      id:
        description: ID of the performance tier.
        type: string
      serviceLevelObjectives:
        description: Service level objectives associated with the performance tier
        items:
          $ref: "#/definitions/PerformanceTierServiceLevelObjectives"
        type: array
  PerformanceTierServiceLevelObjectives:
    description: Service level objectives for performance tier.
    properties:
      edition:
        description: Edition of the performance tier.
        type: string
      hardwareGeneration:
        description: Hardware generation associated with the service level objective
        type: string
      id:
        description: ID for the service level objective.
        type: string
      maxBackupRetentionDays:
        description: Maximum Backup retention in days for the performance tier edition
        type: integer
      maxStorageMB:
        description: Max storage allowed for a server.
        format: int32
        type: integer
      minBackupRetentionDays:
        description: Minimum Backup retention in days for the performance tier edition
        type: integer
      minStorageMB:
        description: Max storage allowed for a server.
        format: int32
        type: integer
      vCore:
        description: vCore associated with the service level objective
        type: integer
  ProxyResource:
    description: Resource properties.
    properties:
      id:
        description: Resource ID
        readOnly: true
        type: string
      name:
        description: Resource name.
        readOnly: true
        type: string
      type:
        description: Resource type.
        readOnly: true
        type: string
    x-ms-azure-resource: true
  ResourceIdentity:
    description: Azure Active Directory identity configuration for a resource.
    properties:
      principalId:
        description: The Azure Active Directory principal id.
        format: uuid
        readOnly: true
        type: string
      tenantId:
        description: The Azure Active Directory tenant id.
        format: uuid
        readOnly: true
        type: string
      type:
        description: The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.
        enum:
          - SystemAssigned
        type: string
        x-ms-enum:
          modelAsString: true
          name: IdentityType
    type: object
  SecurityAlertPolicyProperties:
    description: Properties of a security alert policy.
    properties:
      disabledAlerts:
        description: "Specifies an array of alerts that are disabled. Allowed values are: Sql_Injection, Sql_Injection_Vulnerability, Access_Anomaly"
        items:
          type: string
        type: array
      emailAccountAdmins:
        description: Specifies that the alert is sent to the account administrators.
        type: boolean
      emailAddresses:
        description: Specifies an array of e-mail addresses to which the alert is sent.
        items:
          type: string
        type: array
      retentionDays:
        description: Specifies the number of days to keep in the Threat Detection audit logs.
        format: int32
        type: integer
      state:
        description: Specifies the state of the policy, whether it is enabled or disabled.
        enum:
          - Enabled
          - Disabled
        type: string
        x-ms-enum:
          modelAsString: false
          name: ServerSecurityAlertPolicyState
      storageAccountAccessKey:
        description: Specifies the identifier key of the Threat Detection audit storage account.
        type: string
      storageEndpoint:
        description: Specifies the blob storage endpoint (e.g. https://MyAccount.blob.core.windows.net). This blob storage will hold all Threat Detection audit logs.
        type: string
    required:
      - state
    type: object
  Server:
    allOf:
      - $ref: "#/definitions/TrackedResource"
    description: Represents a server.
    properties:
      identity:
        $ref: "#/definitions/ResourceIdentity"
        description: The Azure Active Directory identity of the server.
      properties:
        $ref: "#/definitions/ServerProperties"
        description: Properties of the server.
        x-ms-client-flatten: true
      sku:
        $ref: "#/definitions/Sku"
        description: The SKU (pricing tier) of the server.
  ServerAdministratorProperties:
    description: The properties of an server Administrator.
    properties:
      administratorType:
        description: The type of administrator.
        enum:
          - ActiveDirectory
        type: string
        x-ms-enum:
          name: AdministratorType
      login:
        description: The server administrator login value.
        type: string
      sid:
        description: The server administrator Sid (Secure ID).
        format: uuid
        type: string
      tenantId:
        description: The server Active Directory Administrator tenant id.
        format: uuid
        type: string
    required:
      - tenantId
      - administratorType
      - login
      - sid
  ServerAdministratorResource:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Represents a and external administrator to be created.
    properties:
      properties:
        $ref: "#/definitions/ServerAdministratorProperties"
        description: Properties of the server AAD administrator.
        x-ms-client-flatten: true
  ServerAdministratorResourceListResult:
    description: The response to a list Active Directory Administrators request.
    properties:
      value:
        description: The list of server Active Directory Administrators for the server.
        items:
          $ref: "#/definitions/ServerAdministratorResource"
        type: array
  ServerForCreate:
    description: Represents a server to be created.
    properties:
      location:
        description: The location the resource resides in.
        type: string
      properties:
        $ref: "#/definitions/ServerPropertiesForCreate"
        description: Properties of the server.
        x-ms-client-flatten: false
      sku:
        $ref: "#/definitions/Sku"
        description: The SKU (pricing tier) of the server.
      tags:
        additionalProperties:
          type: string
        description: Application-specific metadata in the form of key-value pairs.
        type: object
    required:
      - properties
      - location
  ServerListResult:
    description: A list of servers.
    properties:
      value:
        description: The list of servers
        items:
          $ref: "#/definitions/Server"
        type: array
  ServerProperties:
    description: The properties of a server.
    properties:
      administratorLogin:
        description: The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation).
        type: string
      earliestRestoreDate:
        description: Earliest restore point creation time (ISO8601 format)
        format: date-time
        type: string
      fullyQualifiedDomainName:
        description: The fully qualified domain name of a server.
        type: string
      masterServerId:
        description: The master server id of a replica server.
        type: string
      replicaCapacity:
        description: The maximum number of replicas that a master server can have.
        format: int32
        minimum: 0
        type: integer
      replicationRole:
        description: The replication role of the server.
        type: string
      sslEnforcement:
        $ref: "#/definitions/SslEnforcement"
        description: Enable ssl enforcement or not when connect to server.
      storageProfile:
        $ref: "#/definitions/StorageProfile"
        description: Storage profile of a server.
      userVisibleState:
        description: A state of a server that is visible to user.
        enum:
          - Ready
          - Dropping
          - Disabled
        type: string
        x-ms-enum:
          modelAsString: true
          name: ServerState
      version:
        $ref: "#/definitions/ServerVersion"
        description: Server version.
  ServerPropertiesForCreate:
    description: The properties used to create a new server.
    discriminator: createMode
    properties:
      createMode:
        description: The mode to create a new server.
        enum:
          - Default
          - PointInTimeRestore
          - GeoRestore
          - Replica
        type: string
        x-ms-enum:
          modelAsString: true
          name: CreateMode
      sslEnforcement:
        $ref: "#/definitions/SslEnforcement"
        description: Enable ssl enforcement or not when connect to server.
      storageProfile:
        $ref: "#/definitions/StorageProfile"
        description: Storage profile of a server.
      version:
        $ref: "#/definitions/ServerVersion"
        description: Server version.
    required:
      - createMode
  ServerPropertiesForDefaultCreate:
    allOf:
      - $ref: "#/definitions/ServerPropertiesForCreate"
    description: The properties used to create a new server.
    properties:
      administratorLogin:
        description: The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation).
        type: string
      administratorLoginPassword:
        description: The password of the administrator login.
        format: password
        type: string
    required:
      - administratorLogin
      - administratorLoginPassword
    x-ms-discriminator-value: Default
  ServerPropertiesForGeoRestore:
    allOf:
      - $ref: "#/definitions/ServerPropertiesForCreate"
    description: The properties used to create a new server by restoring to a different region from a geo replicated backup.
    properties:
      sourceServerId:
        description: The source server id to restore from.
        type: string
    required:
      - sourceServerId
    x-ms-discriminator-value: GeoRestore
  ServerPropertiesForReplica:
    allOf:
      - $ref: "#/definitions/ServerPropertiesForCreate"
    description: The properties to create a new replica.
    properties:
      sourceServerId:
        description: The master server id to create replica from.
        type: string
    required:
      - sourceServerId
    x-ms-discriminator-value: Replica
  ServerPropertiesForRestore:
    allOf:
      - $ref: "#/definitions/ServerPropertiesForCreate"
    description: The properties used to create a new server by restoring from a backup.
    properties:
      restorePointInTime:
        description: Restore point creation time (ISO8601 format), specifying the time to restore from.
        format: date-time
        type: string
      sourceServerId:
        description: The source server id to restore from.
        type: string
    required:
      - sourceServerId
      - restorePointInTime
    x-ms-discriminator-value: PointInTimeRestore
  ServerSecurityAlertPolicy:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: A server security alert policy.
    properties:
      properties:
        $ref: "#/definitions/SecurityAlertPolicyProperties"
        description: Resource properties.
        x-ms-client-flatten: true
    type: object
  ServerUpdateParameters:
    description: Parameters allowed to update for a server.
    properties:
      properties:
        description: The properties that can be updated for a server.
        properties:
          administratorLoginPassword:
            description: The password of the administrator login.
            format: password
            type: string
          replicationRole:
            description: The replication role of the server.
            type: string
          sslEnforcement:
            $ref: "#/definitions/SslEnforcement"
            description: Enable ssl enforcement or not when connect to server.
          storageProfile:
            $ref: "#/definitions/StorageProfile"
            description: Storage profile of a server.
          version:
            $ref: "#/definitions/ServerVersion"
            description: The version of a server.
        x-ms-client-flatten: true
      sku:
        $ref: "#/definitions/Sku"
        description: The SKU (pricing tier) of the server.
      tags:
        additionalProperties:
          type: string
        description: Application-specific metadata in the form of key-value pairs.
        type: object
  ServerVersion:
    description: The version of a server.
    enum:
      - "5.6"
      - "5.7"
      - "8.0"
    type: string
    x-ms-enum:
      modelAsString: true
      name: ServerVersion
  Sku:
    description: Billing information related properties of a server.
    properties:
      capacity:
        description: The scale up/out capacity, representing server's compute units.
        format: int32
        minimum: 0
        type: integer
      family:
        description: The family of hardware.
        type: string
      name:
        description: The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8.
        type: string
      size:
        description: The size code, to be interpreted by resource as appropriate.
        type: string
      tier:
        description: The tier of the particular SKU, e.g. Basic.
        enum:
          - Basic
          - GeneralPurpose
          - MemoryOptimized
        type: string
        x-ms-enum:
          modelAsString: true
          name: SkuTier
  SslEnforcement:
    description: Enable ssl enforcement or not when connect to server.
    enum:
      - Enabled
      - Disabled
    type: string
    x-ms-enum:
      modelAsString: false
      name: SslEnforcementEnum
  StorageProfile:
    description: Storage Profile properties of a server
    properties:
      backupRetentionDays:
        description: Backup retention days for the server.
        type: integer
      geoRedundantBackup:
        description: Enable Geo-redundant or not for server backup.
        enum:
          - Enabled
          - Disabled
        type: string
        x-ms-enum:
          modelAsString: true
          name: GeoRedundantBackup
      storageAutogrow:
        description: Enable Storage Auto Grow.
        enum:
          - Enabled
          - Disabled
        type: string
        x-ms-enum:
          modelAsString: true
          name: StorageAutogrow
      storageMB:
        description: Max storage allowed for a server.
        format: int32
        type: integer
  TrackedResource:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: Resource properties including location and tags for track resources.
    properties:
      location:
        description: The location the resource resides in.
        type: string
      tags:
        additionalProperties:
          type: string
        description: Application-specific metadata in the form of key-value pairs.
        type: object
    required:
      - location
  VirtualNetworkRule:
    allOf:
      - $ref: "#/definitions/ProxyResource"
    description: A virtual network rule.
    properties:
      properties:
        $ref: "#/definitions/VirtualNetworkRuleProperties"
        description: Resource properties.
        x-ms-client-flatten: true
    type: object
  VirtualNetworkRuleListResult:
    description: A list of virtual network rules.
    properties:
      nextLink:
        description: Link to retrieve next page of results.
        readOnly: true
        type: string
      value:
        description: Array of results.
        items:
          $ref: "#/definitions/VirtualNetworkRule"
        readOnly: true
        type: array
    type: object
  VirtualNetworkRuleProperties:
    description: Properties of a virtual network rule.
    properties:
      ignoreMissingVnetServiceEndpoint:
        description: Create firewall rule before the virtual network has vnet service endpoint enabled.
        type: boolean
      state:
        description: Virtual Network Rule State
        enum:
          - Initializing
          - InProgress
          - Ready
          - Deleting
          - Unknown
        readOnly: true
        type: string
        x-ms-enum:
          modelAsString: true
          name: VirtualNetworkRuleState
      virtualNetworkSubnetId:
        description: The ARM resource id of the virtual network subnet.
        type: string
    required:
      - virtualNetworkSubnetId
    type: object
