USE `nephrolink`;

ALTER TABLE institutions
  ADD COLUMN tax_number VARCHAR(20) DEFAULT NULL AFTER type,
  ADD COLUMN tax_office VARCHAR(120) DEFAULT NULL AFTER tax_number,
  ADD COLUMN full_address VARCHAR(255) DEFAULT NULL AFTER address;

ALTER TABLE institutions
  ADD UNIQUE KEY uq_institutions_tax_number (tax_number);
