Postgres.sql

-- Postgres alter varchar(4000) to TEXT
-- mrequest
ALTER TABLE mrequest ALTER COLUMN reason TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN plandesc TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN remark_wf TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN responsibility TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN destination TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN conclusion TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN language TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN behavior TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN position_specific TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN orther_knowledge TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN examdata TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN pregnantdesc TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN qualification TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN software TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN remark_hr TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN other TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN experience TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN impairdesc TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN cancel_reason TYPE TEXT;
ALTER TABLE mrequest ALTER COLUMN router TYPE TEXT;

-- mapplicant
ALTER TABLE mapplicant ALTER COLUMN jobexp TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN education TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN contact TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN personal TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN skill TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN jobrouter TYPE TEXT;
ALTER TABLE mapplicant ALTER COLUMN family TYPE TEXT;

-- mappointment
ALTER TABLE mappointment ALTER COLUMN detail TYPE TEXT;

-- mjobrouter
ALTER TABLE mjobrouter ALTER COLUMN jobrouter TYPE TEXT;

-- mexam
ALTER TABLE mexam ALTER COLUMN examdata TYPE TEXT;
ALTER TABLE mexam ALTER COLUMN question TYPE TEXT;

-- crecruit
ALTER TABLE crecruit ALTER COLUMN object TYPE TEXT;