2019-06-24.sql 365 B

123456789
  1. -- Add/modify columns
  2. alter table KJ_COLLEGE_SCORE_MAIN add join_school_id NUMBER(10);
  3. -- Add comments to the columns
  4. comment on column KJ_COLLEGE_SCORE_MAIN.join_school_id
  5. is '衔接学校ID';
  6. -- Add/modify columns
  7. alter table KJ_COLLEGE_SCORE_MAIN modify final_auth_oper NUMBER(10);
  8. alter table KJ_COLLEGE_SCORE_MAIN modify school_auth_oper NUMBER(10);