--- alter-table-clients-add-assistant

ALTER TABLE clients ADD personal_manager_group_id BIGINT REFERENCES groups(id) default null;
CREATE INDEX clients_personal_managers_group_id_ix ON clients (personal_manager_group_id);


ALTER TABLE clients ADD assistant_personal_manager_id BIGINT REFERENCES users(id) default null;
CREATE INDEX clients_personal_manager_assistant_id_ix ON clients (assistant_personal_manager_id);

ALTER TABLE clients ADD assistant_personal_manager_group_id BIGINT REFERENCES groups(id) default null;
CREATE INDEX clients_personal_manager_assistant_group_id_ix ON clients (assistant_personal_manager_group_id);
