/*
  Warnings:

  - You are about to alter the column `name` on the `Activity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `Category` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `nameAr` on the `Category` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `City` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `logo` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `address` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `phoneNumber` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `email` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `linkedin` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `facebook` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactFirstName` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactLastName` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactEmail` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactLinkedin` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactFacebook` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `businessLicense` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `numRC` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `numICE` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `website` on the `Company` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `ExpertiseArea` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `InterestArea` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `message` on the `Message` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `NEmployees` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `country` on the `Opportunity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `address` on the `Opportunity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `requirements` on the `Opportunity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactEmail` on the `Opportunity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `contactPhoneNumber` on the `Opportunity` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `Position` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `Province` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `email` on the `Training` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `phoneNumber` on the `Training` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `website` on the `Training` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `name` on the `Turnover` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `firstName` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `lastName` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `email` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `password` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `phoneNumber` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.
  - You are about to alter the column `bio` on the `User` table. The data in that column could be lost. The data in that column will be cast from `VarChar(255)` to `VarChar(250)`.

*/
-- AlterTable
ALTER TABLE "Activity" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Category" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "nameAr" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "City" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Company" ALTER COLUMN "logo" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "name" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "address" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "phoneNumber" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "email" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "linkedin" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "facebook" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactFirstName" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactLastName" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactEmail" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactLinkedin" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactFacebook" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "businessLicense" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "numRC" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "numICE" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "website" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "ExpertiseArea" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "InterestArea" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Message" ALTER COLUMN "message" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "NEmployees" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Opportunity" ALTER COLUMN "country" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "address" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "requirements" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactEmail" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "contactPhoneNumber" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Position" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Province" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Training" ALTER COLUMN "email" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "phoneNumber" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "website" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "Turnover" ALTER COLUMN "name" SET DATA TYPE VARCHAR(250);

-- AlterTable
ALTER TABLE "User" ALTER COLUMN "firstName" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "lastName" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "email" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "password" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "phoneNumber" SET DATA TYPE VARCHAR(250),
ALTER COLUMN "bio" SET DATA TYPE VARCHAR(250);

-- CreateTable
CREATE TABLE "Fair" (
    "id" TEXT NOT NULL,
    "title" VARCHAR(500) NOT NULL,
    "country" VARCHAR(250) NOT NULL,
    "place" VARCHAR(500) NOT NULL,
    "startDate" TIMESTAMP(3) NOT NULL,
    "endDate" TIMESTAMP(3) NOT NULL,
    "sector" VARCHAR(250) NOT NULL,
    "organizer" VARCHAR(250) NOT NULL,
    "phoneNumber" VARCHAR(250) NOT NULL,
    "fax" VARCHAR(250) NOT NULL,
    "email" VARCHAR(250) NOT NULL,
    "website" VARCHAR(250) NOT NULL,

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