/*
  Warnings:

  - You are about to drop the column `grupoFamiliar` on the `SituacionVivienda` table. All the data in the column will be lost.
  - You are about to drop the column `habitabilidad` on the `SituacionVivienda` table. All the data in the column will be lost.
  - You are about to drop the column `tieneAgua` on the `SituacionVivienda` table. All the data in the column will be lost.
  - You are about to drop the column `tieneAlcantarillado` on the `SituacionVivienda` table. All the data in the column will be lost.
  - You are about to drop the column `tieneLuz` on the `SituacionVivienda` table. All the data in the column will be lost.
  - The `tipoVivienda` column on the `SituacionVivienda` table would be dropped and recreated. This will lead to data loss if there is data in the column.
  - The `estadoConstructivo` column on the `SituacionVivienda` table would be dropped and recreated. This will lead to data loss if there is data in the column.
  - The `materialPredominante` column on the `SituacionVivienda` table would be dropped and recreated. This will lead to data loss if there is data in the column.

*/
-- CreateEnum
CREATE TYPE "TipoVivienda" AS ENUM ('VIVIENDA_1_PISO', 'VIVIENDA_2_PISOS', 'VIVIENDA_PRECARIA');

-- CreateEnum
CREATE TYPE "EstadoConstructivo" AS ENUM ('BUENA', 'MALA', 'ACEPTABLE');

-- CreateEnum
CREATE TYPE "MaterialPredominante" AS ENUM ('LIGERA', 'SOLIDA', 'MIXTO');

-- CreateEnum
CREATE TYPE "CuentaConLuz" AS ENUM ('MEDIDOR_PROPIO', 'CEDIDA_VECINOS', 'CONEXION_IRREGULAR_RED_PUBLICA');

-- CreateEnum
CREATE TYPE "SistemaEvacuacionAguas" AS ENUM ('FOSA_SEPTICA', 'POZO_NEGRO', 'DERIVACION_CURSO_AGUA_SUPERFICIAL');

-- CreateEnum
CREATE TYPE "AbastecimientoAguaPotable" AS ENUM ('ALJIBE_MUNICIPAL_GOBERNACION', 'ALJIBE_PARTICULAR', 'POZO_PROPIO');

-- AlterTable
ALTER TABLE "SituacionVivienda" DROP COLUMN "grupoFamiliar",
DROP COLUMN "habitabilidad",
DROP COLUMN "tieneAgua",
DROP COLUMN "tieneAlcantarillado",
DROP COLUMN "tieneLuz",
ADD COLUMN     "abastecimientoAguaPotable" "AbastecimientoAguaPotable",
ADD COLUMN     "cantidadViviendasLote" INTEGER,
ADD COLUMN     "cuentaConLuz" "CuentaConLuz",
ADD COLUMN     "sistemaEvacuacionAguas" "SistemaEvacuacionAguas",
DROP COLUMN "tipoVivienda",
ADD COLUMN     "tipoVivienda" "TipoVivienda",
DROP COLUMN "estadoConstructivo",
ADD COLUMN     "estadoConstructivo" "EstadoConstructivo",
DROP COLUMN "materialPredominante",
ADD COLUMN     "materialPredominante" "MaterialPredominante";