ALTER TABLE omo.consultant ADD seniority_year int4 NULL;
ALTER TABLE omo.consultant ADD seniority_month int4 NULL;

-- Auto-generated SQL script #202111301732
UPDATE omo.consultant SET seniority_year=10,seniority_month=0 WHERE agent_no='AGAM11249699';
UPDATE omo.consultant SET seniority_year=22,seniority_month=8 WHERE agent_no='J149388015';
UPDATE omo.consultant SET seniority_year=15,seniority_month=9 WHERE agent_no='X147309614';
UPDATE omo.consultant SET seniority_year=3,seniority_month=0 WHERE agent_no='A183619275';
UPDATE omo.consultant SET seniority_year=1,seniority_month=0 WHERE agent_no='AG0101234567';
UPDATE omo.consultant SET seniority_year=30,seniority_month=8 WHERE agent_no='B282677963';
UPDATE omo.consultant SET seniority_year=20,seniority_month=3 WHERE agent_no='D265260662';
UPDATE omo.consultant SET seniority_year=38,seniority_month=0 WHERE agent_no='R221444250';
UPDATE omo.consultant SET seniority_year=26,seniority_month=10 WHERE agent_no='AG0109051204';
UPDATE omo.consultant SET seniority_year=17,seniority_month=1 WHERE agent_no='Z152717443';

ALTER TABLE omo.consultant DROP COLUMN seniority;
