ALTER TABLE headquarter
   ALTER COLUMN address TYPE character varying(100);
ALTER TABLE headquarter
   ALTER COLUMN headquarter_name TYPE character varying(100);
ALTER TABLE headquarter
   ALTER COLUMN email TYPE character varying(60);

   
ALTER TABLE indication
   ALTER COLUMN id SET DEFAULT nextval('indication_id_seq'::regclass);
ALTER TABLE indication
   ALTER COLUMN current SET DEFAULT (('now'::text)::timestamp without time zone)::timestamp(0) without time zone;
   
ALTER TABLE preparation
  ADD COLUMN current timestamp(6) without time zone NOT NULL DEFAULT (('now'::text)::timestamp without time zone)::timestamp(0) without time zone;
ALTER TABLE preparation
   ALTER COLUMN id SET DEFAULT nextval('preparation_id_seq'::regclass);
   
ALTER TABLE rate
  ALTER COLUMN id SET DEFAULT nextval('rate_id_seq'::regclass);
ALTER TABLE rate
  ADD COLUMN current timestamp(6) without time zone NOT NULL DEFAULT (('now'::text)::timestamp without time zone)::timestamp(0) without time zone;

ALTER TABLE transcription_template
   ALTER COLUMN id_template SET DEFAULT nextval('transcription_template_id_template_seq'::regclass);