server/ses-manage/sql/2019-06/2019-06-04.sql

-- Add/modify columns 
alter table STD_REG_INFO add is_new_stu number(1);
-- Add comments to the columns 
comment on column STD_REG_INFO.is_new_stu
  is '只针对新旧专业衔接，0：老考生，1：新考生';
  
-- Add/modify columns 
alter table PL_COURSE add course_type NUMBER(2);
-- Add comments to the columns 
comment on column PL_COURSE.course_type
  is '课程类型：0：实践课，1：沟通课，默认为空';
  
insert into frame_dict (DICT_NAME, DICT_VALUE, DICT_TEXT, DICT_ORDER)
values ('CourseType', '0', '实践课', '0');

insert into frame_dict (DICT_NAME, DICT_VALUE, DICT_TEXT, DICT_ORDER)
values ('CourseType', '1', '沟通课', '1');

alter table KJ_COLLEGE_BATCH_INFO modify batch_name VARCHAR2(60);

-- Add/modify columns 
alter table PL_MAJOR_APPLY_DIR modify major_code VARCHAR2(8);

alter table pl_country_exam_plan add start_time VARCHAR2(8);
alter table pl_country_exam_plan add end_time VARCHAR2(8);
-- Add comments to the columns 
comment on column pl_country_exam_plan.start_time
  is '考试开始时间';
comment on column pl_country_exam_plan.end_time
  is '考试结束时间';
  
alter table PL_PROVINCE_EXAM_PLAN add start_time VARCHAR2(8);
alter table PL_PROVINCE_EXAM_PLAN add end_time VARCHAR2(8);
-- Add comments to the columns 
comment on column PL_PROVINCE_EXAM_PLAN.start_time
  is '考试开始时间';
comment on column PL_PROVINCE_EXAM_PLAN.end_time
  is '考试结束时间';

alter table pl_merge_publish_plan add start_time VARCHAR2(8);
alter table pl_merge_publish_plan add end_time VARCHAR2(8);
-- Add comments to the columns 
comment on column pl_merge_publish_plan.start_time
  is '考试开始时间';
comment on column pl_merge_publish_plan.end_time
  is '考试结束时间';