github.com/paybyphone/terraform@v0.9.5-0.20170613192930-9706042ddd51/examples/azure-sql-database/main.tf (about)

     1  # provider "azurerm" {
     2  #   subscription_id = "REPLACE-WITH-YOUR-SUBSCRIPTION-ID"
     3  #   client_id       = "REPLACE-WITH-YOUR-CLIENT-ID"
     4  #   client_secret   = "REPLACE-WITH-YOUR-CLIENT-SECRET"
     5  #   tenant_id       = "REPLACE-WITH-YOUR-TENANT-ID"
     6  # }
     7  
     8  resource "azurerm_resource_group" "rg" {
     9    name     = "${var.resource_group}"
    10    location = "${var.location}"
    11  }
    12  
    13  resource "azurerm_sql_database" "db" {
    14    name                             = "mysqldatabase"
    15    resource_group_name              = "${azurerm_resource_group.rg.name}"
    16    location                         = "${var.location}"
    17    edition                          = "Basic"
    18    collation                        = "SQL_Latin1_General_CP1_CI_AS"
    19    create_mode                      = "Default"
    20    requested_service_objective_name = "Basic"
    21    server_name                      = "${azurerm_sql_server.server.name}"
    22  }
    23  
    24  resource "azurerm_sql_server" "server" {
    25    name                         = "${var.resource_group}-sqlsvr"
    26    resource_group_name          = "${azurerm_resource_group.rg.name}"
    27    location                     = "${var.location}"
    28    version                      = "12.0"
    29    administrator_login          = "${var.sql_admin}"
    30    administrator_login_password = "${var.sql_password}"
    31  }
    32  
    33  resource "azurerm_sql_firewall_rule" "fw" {
    34    name                = "firewallrules"
    35    resource_group_name = "${azurerm_resource_group.rg.name}"
    36    server_name         = "${azurerm_sql_server.server.name}"
    37    start_ip_address    = "0.0.0.0"
    38    end_ip_address      = "0.0.0.0"
    39  }