/*
  Warnings:

  - You are about to drop the column `discount` on the `subscription_packages` table. All the data in the column will be lost.
  - You are about to drop the column `price` on the `subscription_packages` table. All the data in the column will be lost.
  - You are about to drop the column `stripePriceId` on the `subscription_packages` table. All the data in the column will be lost.
  - Added the required column `priceNgn` to the `subscription_packages` table without a default value. This is not possible if the table is not empty.
  - Added the required column `priceUsd` to the `subscription_packages` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `subscription_packages` DROP COLUMN `discount`,
    DROP COLUMN `price`,
    DROP COLUMN `stripePriceId`,
    ADD COLUMN `priceNgn` DECIMAL(12, 2) NOT NULL,
    ADD COLUMN `priceUsd` DECIMAL(10, 2) NOT NULL,
    ADD COLUMN `stripePriceIdNgnLive` VARCHAR(191) NULL,
    ADD COLUMN `stripePriceIdNgnSandbox` VARCHAR(191) NULL,
    ADD COLUMN `stripePriceIdUsdLive` VARCHAR(191) NULL,
    ADD COLUMN `stripePriceIdUsdSandbox` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `subscriptions` ADD COLUMN `currency` VARCHAR(191) NOT NULL DEFAULT 'usd',
    ADD COLUMN `stripeCustomerId` VARCHAR(191) NULL;
