ALTER TABLE person ALTER COLUMN iq TYPE bigint;
+ALTER TABLE person ALTER COLUMN nickname SET NOT NULL;
+ALTER TABLE person ALTER COLUMN nickname TYPE character varying(24);
+
ALTER TABLE person RENAME COLUMN description TO physical_description;
ALTER TABLE person ADD CONSTRAINT unique_name UNIQUE (name);
ALTER TABLE person ALTER COLUMN iq TYPE bigint;
+ALTER TABLE person ALTER COLUMN nickname SET NOT NULL;
+ALTER TABLE person ALTER COLUMN nickname TYPE character varying(24);
+
ALTER TABLE person RENAME COLUMN description TO physical_description;
ALTER TABLE person ADD CONSTRAINT UC_person_id UNIQUE (person_id);