'PostgreSQL',
{
producer_args => {
- quote_table_names => 0,
+ quote_identifiers => 0,
}
}
);
BEGIN;
CREATE TABLE added (
- "id" bigint
+ id bigint
);
ALTER TABLE old_name RENAME TO new_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 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);