/*
  Warnings:

  - You are about to drop the column `can_ranges` on the `CanRanges` table. All the data in the column will be lost.
  - You are about to drop the column `cans_have_high` on the `LifeCycle` table. All the data in the column will be lost.
  - You are about to drop the column `cans_have_low` on the `LifeCycle` table. All the data in the column will be lost.

*/
-- AlterTable
ALTER TABLE "CanRanges" DROP COLUMN "can_ranges",
ADD COLUMN     "can_range_high" INTEGER DEFAULT 0,
ADD COLUMN     "can_range_low" INTEGER DEFAULT 0;

-- AlterTable
ALTER TABLE "LifeCycle" DROP COLUMN "cans_have_high",
DROP COLUMN "cans_have_low",
ADD COLUMN     "cans_submitted" INTEGER NOT NULL DEFAULT 0;

-- AlterTable
ALTER TABLE "User" ADD COLUMN     "cans_have_high" INTEGER NOT NULL DEFAULT 0,
ADD COLUMN     "cans_have_low" INTEGER NOT NULL DEFAULT 0;