/*
  Warnings:

  - You are about to drop the column `city_id` on the `tbl_user` table. All the data in the column will be lost.
  - You are about to drop the column `state_id` on the `tbl_user` table. All the data in the column will be lost.
  - You are about to drop the `city` table. If the table is not empty, all the data it contains will be lost.
  - You are about to drop the `state` table. If the table is not empty, all the data it contains will be lost.

*/
-- DropForeignKey
ALTER TABLE "city" DROP CONSTRAINT "city_state_id_fkey";

-- DropForeignKey
ALTER TABLE "state" DROP CONSTRAINT "state_country_id_fkey";

-- DropForeignKey
ALTER TABLE "tbl_user" DROP CONSTRAINT "tbl_user_city_id_fkey";

-- DropForeignKey
ALTER TABLE "tbl_user" DROP CONSTRAINT "tbl_user_state_id_fkey";

-- AlterTable
ALTER TABLE "tbl_user" DROP COLUMN "city_id",
DROP COLUMN "state_id",
ADD COLUMN     "about" TEXT,
ADD COLUMN     "annual_sales_id" BIGINT,
ADD COLUMN     "business_profile_banner_image" VARCHAR(256),
ADD COLUMN     "business_profile_image" VARCHAR(256),
ADD COLUMN     "company_values_ids" VARCHAR(256),
ADD COLUMN     "founding_year" VARCHAR(128),
ADD COLUMN     "instagram_account" VARCHAR(256),
ADD COLUMN     "lead_time_id" BIGINT,
ADD COLUMN     "linkedin_account" VARCHAR(256),
ADD COLUMN     "located_in_id" BIGINT,
ADD COLUMN     "number_of_locations" BIGINT DEFAULT 0,
ADD COLUMN     "profile_banner_image" VARCHAR(256),
ADD COLUMN     "shipping_fee" DECIMAL(13,2),
ADD COLUMN     "shipping_fee_currency" VARCHAR(128),
ADD COLUMN     "year_in_business" VARCHAR(128);

-- DropTable
DROP TABLE "city";

-- DropTable
DROP TABLE "state";
