页面历史记录

alter table AO_B40E65_WISE_TEAM_USER rename column TEAM_ID to TEAM_ID_TEMP;
alter table AO_B40E65_WISE_TEAM_USER add TEAM_ID NUMBER(11);
update AO_B40E65_WISE_TEAM_USER set TEAM_ID = trim(TEAM_ID_TEMP);
alter table AO_B40E65_WISE_TEAM_USER drop column TEAM_ID_TEMP;

alter table AO_B40E65_LEAVE_RECORD rename column ISSUE_ID to ISSUE_ID_TEMP;
alter table AO_B40E65_LEAVE_RECORD add ISSUE_ID NUMBER(20);
update AO_B40E65_LEAVE_RECORD set ISSUE_ID = trim(ISSUE_ID_TEMP);
alter table AO_B40E65_LEAVE_RECORD drop column ISSUE_ID_TEMP;

alter table AO_B40E65_M_LEAVE_CONFIG rename column ISSUE_ID to ISSUE_ID_TEMP;
alter table AO_B40E65_M_LEAVE_CONFIG add ISSUE_ID NUMBER(20);
update AO_B40E65_M_LEAVE_CONFIG set ISSUE_ID = trim(ISSUE_ID_TEMP);
alter table AO_B40E65_M_LEAVE_CONFIG drop column ISSUE_ID_TEMP;