/*
  Warnings:

  - You are about to alter the column `phone_code` on the `country` table. The data in that column could be lost. The data in that column will be cast from `VarChar(190)` to `VarChar(128)`.

*/
-- AlterTable
ALTER TABLE "country" ALTER COLUMN "short_name" SET DATA TYPE VARCHAR(256),
ALTER COLUMN "name" SET DATA TYPE VARCHAR(256),
ALTER COLUMN "phone_code" SET DATA TYPE VARCHAR(128);

-- CreateTable
CREATE TABLE "tbl_category" (
    "id" BIGSERIAL NOT NULL,
    "parent_id" BIGINT,
    "category_name" VARCHAR(256),
    "is_active" BOOLEAN DEFAULT true,
    "is_delete" BOOLEAN DEFAULT false,
    "deleted_at" TIMESTAMP(3),
    "inserted_at" TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP,
    "updated_at" TIMESTAMP(3),

    CONSTRAINT "tbl_category_pkey" PRIMARY KEY ("id")
);
