/*
  Warnings:

  - You are about to drop the column `email` on the `shops` table. All the data in the column will be lost.
  - You are about to drop the column `gstin` on the `shops` table. All the data in the column will be lost.

*/
-- DropForeignKey
ALTER TABLE `purchases` DROP FOREIGN KEY `purchases_supplier_id_fkey`;

-- DropIndex
DROP INDEX `shops_email_key` ON `shops`;

-- DropIndex
DROP INDEX `shops_gstin_key` ON `shops`;

-- AlterTable
ALTER TABLE `attendances` ALTER COLUMN `updated_at` DROP DEFAULT;

-- AlterTable
ALTER TABLE `employees` ALTER COLUMN `updated_at` DROP DEFAULT;

-- AlterTable
ALTER TABLE `shops` DROP COLUMN `email`,
    DROP COLUMN `gstin`,
    ADD COLUMN `god_image_1` VARCHAR(191) NULL,
    ADD COLUMN `god_image_2` VARCHAR(191) NULL,
    ADD COLUMN `god_name_1` VARCHAR(191) NULL,
    ADD COLUMN `god_name_2` VARCHAR(191) NULL,
    ADD COLUMN `god_name_3` VARCHAR(191) NULL,
    ADD COLUMN `map_url` VARCHAR(191) NULL,
    ADD COLUMN `mobile2` VARCHAR(191) NULL;

-- CreateIndex
CREATE INDEX `customers_status_idx` ON `customers`(`status`);

-- CreateIndex
CREATE INDEX `customers_created_at_idx` ON `customers`(`created_at`);

-- CreateIndex
CREATE INDEX `purchases_status_idx` ON `purchases`(`status`);

-- CreateIndex
CREATE INDEX `purchases_created_at_idx` ON `purchases`(`created_at`);

-- CreateIndex
CREATE INDEX `retail_sales_created_at_idx` ON `retail_sales`(`created_at`);

-- CreateIndex
CREATE INDEX `retail_stocks_allocation_date_idx` ON `retail_stocks`(`allocation_date`);

-- CreateIndex
CREATE INDEX `retail_stocks_lot_no_idx` ON `retail_stocks`(`lot_no`);

-- CreateIndex
CREATE INDEX `retail_stocks_created_at_idx` ON `retail_stocks`(`created_at`);

-- CreateIndex
CREATE INDEX `sales_created_at_idx` ON `sales`(`created_at`);

-- AddForeignKey
ALTER TABLE `purchases` ADD CONSTRAINT `purchases_supplier_id_fkey` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;