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;
|
