add new db

main.tf

variable "location" {
  type    = string
  default = "eastus"
}

provider "azurerm" {
  version = 1.38
}

resource "azurerm_resource_group" "rg" {
  name     = "dilani-tf-rg"
  location = var.location
}

resource "azurerm_sql_server" "sqlserver" {
  name                         = "diltfsqlserver"
  resource_group_name          = azurerm_resource_group.rg.name
  location                     = var.location
  version                      = "12.0"
  administrator_login          = "diladmin"
  administrator_login_password = "1qaz2wsx@"

}

resource "azurerm_sql_database" "sqldb" {
  name                = "diltfdb"
  resource_group_name = azurerm_resource_group.rg.name
  location            = var.location
  server_name         = azurerm_sql_server.sqlserver.name
}

resource "azurerm_sql_database" "sqldb1" {
  name                = "diltfdb1"
  resource_group_name = azurerm_resource_group.rg.name
  location            = var.location
  server_name         = azurerm_sql_server.sqlserver.name
}

resource "azurerm_app_service_plan" "serviceplan" {
  name                = "diltf-appserviceplan"
  location            = var.location
  resource_group_name = azurerm_resource_group.rg.name

  sku {
    tier = "Standard"
    size = "S1"
  }
}

resource "azurerm_app_service" "appservice" {
  name                = "diltf-app-service"
  location            = var.location
  resource_group_name = azurerm_resource_group.rg.name
  app_service_plan_id = azurerm_app_service_plan.serviceplan.id

  app_settings = {
    "ASPNETCORE_ENVIRONMENT" = "QA"
  }
}